Information and Communication Technology 0417/31 May/June 2025: question paper and mark scheme

Question

Create a new folder called racing Locate only the following files and store them in your racing folder. TRbanner.png TRdevelop.htm TRracing.css TRtext.txt TRvideo.mp4 Display the contents of your racing folder, showing the folder name and all file names, file extensions, file sizes, frame height, frame width and image dimensions. Take a screenshot of this folder, making sure that the required information is clearly visible. Place this screenshot in your Evidence Document. [1] [Total: 1] Task 3 – Web Page You will create a web page to advertise Tawara Racing, who race motor cars.

Question

Create in your racing folder a web page called racing.htm This web page must be created using a single table and work in all browsers. The table must be left‑aligned and fit 90% of the browser window. The table must have a structure as shown in this diagram: A B C D E Each table cell is identified with a letter which must not appear on your final web page. Table borders must appear on the final web page. [6]

Question

Set the title of the web page to Tawara Racing [1]

Question

Place in: • cell A the image TRbanner.png • cell B video and source tags to display TRvideo.mp4 Make sure that the controls are visible and the video loops when played. Display an automated text‑based error message if the browser does not support this video type. [7]

Question

Enter in cell C the text from the file TRtext.txt Set this text as style h3. [2]

Question

Enter in cell D the text Click here to find out more about our exciting developments, or here for job opportunities. Enter in cell E the text Web page created by: followed on a new line by your name, centre number and candidate number. Set all the text in cells D and E as style h2. [4]

Question

Make the text exciting developments a link to open the web page TRdevelop.htm in a new window called _blank Make the text job opportunities a link to an email editor to prepare an email to Tawara.Racing@cambridge.org with the subject line Job opportunities [6]

Question

Attach the stylesheet TRracing.css to your web page. Edit this stylesheet so that the table borders are not collapsed. Save this stylesheet. [2]

Question

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: • the full page can be seen • all text can be easily read • the address bar is visible. Take screenshot evidence showing your web page in the browser. Place this in your Evidence Document. [1] [Total: 29] Task 4 – Printing the Evidence Document Save and print your Evidence Document. Make sure your name, centre number and candidate number appear on every page of your Evidence Document. Task 5 – Spreadsheet You will assist Tawara Racing to analyse performance data when testing their racing cars.

Question

Open and examine the file TRtest.csv Place, right‑aligned in the header, the text Created by: followed by a space then your name, centre number and candidate number. Place in the footer the text Created on: followed by a space, the automated date, a space, then the text at followed by a space then the automated time. Save this as a spreadsheet with the filename TestData_ followed by your centre number_candidate number, for example TestData_ZZ999_9999 [3]

Question

Enter the missing lap numbers in column A. [1]

Question

Place a replicable formula in cell F14 to calculate the time in seconds taken for this lap. For example: if the minutes = 1, seconds = 14 and thousandths of a second = 484 this cell should display 74.484 1 minute = 60 seconds Display the data in cell F14 to 3 decimal places. Replicate this formula for all laps. [6]

Question

Insert ten rows between rows 1 and 2. Move the contents of cells H13 to H20 into cells A3 to A10. [2]

Question

Merge cells A1 to F1. Format this merged cell with a black 36‑point sans‑serif font on a yellow background. Merge cells A12 to F12. Format rows 1 to 13 of the spreadsheet to look like this: Test data for supercharger on the practice circuit [7]

Question

Place in cell B3 a formula to display the fastest lap time from the data displayed. [2]

Question

Place in cell B4 a formula to display the slowest lap time. [1]

Question

Place in cell B5 a formula to display the average lap time. [1]

Question

Place in cell B6 a formula to display the number of laps where the Supercharger was On [3]

Question

Place in cell B7 a formula to display the number of laps where the Supercharger was Off [1]

Question

Place in cell B8 a formula to calculate the average lap time when the Supercharger was On [4]

Question

Place in cell B9 a formula to calculate the average lap time when the Supercharger was Off [2]

Question

Place in cell B10 a formula to display SC success if the average lap times were faster with the supercharger on or to display SC failed if not. Save your spreadsheet. [4]

Question

Print your spreadsheet showing the formulae. Make sure that the: • printout is in landscape orientation • row and column headings are displayed • contents of all cells are fully visible. [2]

Question

Print your spreadsheet showing the values. Make sure that the: • printout fits on a single page • printout is in portrait orientation • row and column headings are not displayed • contents of all cells are fully visible. [1] [Total: 40]