Information and Communication Technology 0417/31 February/March 2025: question paper and mark scheme

Question

Create a new folder called plaster Locate only the following files and store them in your plaster folder. m25const.htm m25logo.jpg m25plaster.css m25plaster.mp4 m25spec.htm m25text.txt Display the contents of your plaster folder showing the folder name, 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 for the Tawara Construction website.

Question

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

Question

Place in cell A the image m25logo.jpg Set the width of this image to 100% of the cell size. [2]

Question

Place in cell B video and source tags to display m25plaster.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. [6]

Question

Place in cell C the text from the file m25text.txt Apply the paragraph style to this text. [2]

Question

Enter in cell D the text Specialist plastering Enter in cell E the text Other construction Enter in cell F the text Contact us Enter in cell G the text Edited by: followed by a space and then your name, centre number and candidate number. Apply the style h2 to all the text in these cells. [5]

Question

Make the text Specialist plastering a link to open the web page m25spec.htm in a new window called _blank Make the text Other construction a link to open the web page m25const.htm Make the text Contact us a link to an email editor to prepare an email to tawara.construction@cambridge.org with the subject line More information please! [7] You will create a new external stylesheet for the website. All colour codes must be displayed in hexadecimal. Your stylesheet must not contain HTML or scripting language.

Question

Create a new stylesheet to meet the following specifications: Place a comment at the start of the stylesheet to contain your name, centre number and candidate number. Set a style for tables so that they are centre-aligned in the browser window. Set the table and cell borders so that they are white, visible and 2 pixels wide. Save this as an external cascading stylesheet in your plaster folder with the file name m25plaster2_ followed by your centre number_candidate number, for example m25plaster2_ZZ999_9999 Take a screenshot to show the file name and all contents of your stylesheet. Place this in your Evidence Document. Make sure the file name and all contents are clearly visible. [5]

Question

Attach the stylesheet m25plaster.css to the web page created in Step 2. Attach the stylesheet saved in Step 8 to this web page so that it has higher priority than m25plaster.css [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: • all the 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: 37] Task 4 – Spreadsheet You will edit a spreadsheet to calculate the surface area of walls in a room.

Question

Open and examine the file m25calc.csv Place left-aligned in the header the text Created by followed by a space, then your name, centre number and candidate number. Place right-aligned in the header 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 file name m25area_ followed by your centre number_candidate number, for example m25area_ZZ999_9999 [3]

Question

Insert a new row between rows 1 and 2. In the new row 2, enter the text All dimensions are in metres [2]

Question

Merge cells A1 to B1. Format this merged cell with a white 24-point sans-serif font on a black background. Merge cells A2 to B2. Format the spreadsheet like this: A B Plastering surface area calculator 1 2 All dimensions are in metres 3 4 Room height 2.4 5 Room width 5 6 Room length 3.8 7 8 Door height 2 9 Door width 0.85 10 Reveal depth 0.15 11 12 Has windows 13 Window height 0 14 Window width 0 15 16 Has chimney 17 Chimney width 0 18 Chimney depth 0 19 20 Plaster area ceiling 21 Plaster area walls [8]

Question

Place in cell B12 a validation rule to restrict data entry to only the text Yes or No Data must be selected from a drop-down list, and no other data must be allowed. Place in your Evidence Document screenshot(s) showing the validation rules including the validation criteria. [3]

Question

Delete rows 16, 17, 18 and 19. [1]

Question

Place in cell B16 a formula to calculate the area of the ceiling. Area = Room length × Room width [1]

Question

Place in cell B17 a formula to calculate the area of the walls. Area = Room height ×2× ( Room length + Room width – ) ( Door height × Door width ) + Reveal depth × (2 × Door height + width ) Door If a window is present, add this to the area of the walls within the same formula: + Reveal depth ( × 2× Window Window height + width – ) ( Window Window height × width ) [11]

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: 32] Task 5 – 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.