IGCSE Information And Communication Technology (0983) — May–June 2025, Paper 32
27 questions · every question answerable online with instant point-by-point AI marking against the official mark scheme.
Start with Question 1 →Scenario: You are assisting Tawara Racing to analyse data about performance when testing its racing cars. You will also create a web page to advertise this racing team. Source…
Answer this question and get it marked →Step 2: Merge cells A1 to F1. Format this merged cell with a black 40-point serif font on a yellow background. Merge cells A3 to B3 and A11 to B11. Format these merged cells with…
Answer this question and get it marked →Step 3: Create, using cells D18:D77, a named range called TTime. Place in your Evidence Document a screenshot showing the name and the range of cells.
Answer this question and get it marked →Step 4: Place in cell B4 a formula to display the fastest test time, using the named range created in Step 3.
Answer this question and get it marked →Step 5: Place in cell B5 a formula to display the slowest test time.
Answer this question and get it marked →Step 6: Place in cell B6 a formula to display the average test time.
Answer this question and get it marked →Three different fuel mixes are being tested. Step 7: Place in cell B7 a formula, using the named range created in Step 3, to display the average test time for mix number 1.
Answer this question and get it marked →Step 8: Place in cell B8 a formula, using the named range created in Step 3, to display the average test time for mix number 2.
Answer this question and get it marked →Step 9: Place in cell B9 a formula, using the named range created in Step 3, to display the average test time for mix number 3.
Answer this question and get it marked →Tests are only acceptable if there is little or no following wind. Step 10: Place in cell F18 a replicable formula to check the wind adjustment for this test. If this value is…
Answer this question and get it marked →For the calculations for wind adjusted tests, the results will only count if the wind levels are acceptable. Step 11: Place in cell B12 a formula to display the average test time…
Answer this question and get it marked →Step 12: Place in cell B13 a formula to display the average test time for mix number 2 where the wind is at an acceptable level.
Answer this question and get it marked →Step 13: Place in cell B14 a formula to display the average test time for mix number 3 where the wind is at an acceptable level.
Answer this question and get it marked →Step 14: Place in cell B15 a formula to display the Fuel mix % for the fuel mix that gave the fastest wind-adjusted average test time. Format this cell to display as a percentage.
Answer this question and get it marked →Step 15: Format all test times to 4 decimal places. Save your spreadsheet.
Answer this question and get it marked →Step 16: Print your spreadsheet showing the formulae. Make sure that the printout is in landscape orientation, row and column headings are displayed, and the contents of all cells…
Answer this question and get it marked →Step 17: Print your spreadsheet showing the values. Make sure that the printout fits on a single page, the printout is in portrait orientation, row and column headings are not…
Answer this question and get it marked →Step 18: Create a new folder called TR. Locate only the following files and store them in your TR folder: j25banner.jpg, j25racing.css, j25racing.mp4, j25tech.htm, j25text.txt.…
Answer this question and get it marked →Step 19: Create in your TR folder a web page called j25racing.htm. This web page must be created using a single table and work in all browsers. The table must be centre-aligned…
Answer this question and get it marked →Step 20: Place inline style attributes into the HTML to set both the width and height of cell C to 480 pixels.
Answer this question and get it marked →Step 21: Place in: cell A the image j25banner.jpg; cell C video and source tags to display j25racing.mp4 - make sure that the controls are visible and the video loops when played,…
Answer this question and get it marked →Step 22: Enter in cell B the text from the file j25text.txt. Set this text in style h3.
Answer this question and get it marked →Step 23: Enter in: cell D the text 'New technologies'; cell E the text 'Contact us'; cell F the text 'Designed by:'; cell G your name, centre number and candidate number. Set all…
Answer this question and get it marked →Step 24: Make the text 'New technologies' a link to open the web page j25tech.htm. Make the text 'Contact us' a link to an email editor to prepare an email to…
Answer this question and get it marked →Step 25: Attach the stylesheet j25racing.css to your web page. Edit this stylesheet so that the table is centre-aligned in the browser window. Save this stylesheet.
Answer this question and get it marked →Step 26: Set the text in cell F so that the class right is applied to style h2.
Answer this question and get it marked →Step 27: Save your web page. Take a copy of your HTML source and place this in your Evidence Document. Display your web page in a browser. If necessary, resize it so that all the…
Answer this question and get it marked →← May–June 2024 Paper 12 · May–June 2025 Paper 31 →
← All IGCSE Information And Communication Technology (0983) past papers