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

Question

Create a new folder called march24 Open the file m24image.png in an editing package. Reflect (flip) this image horizontally so that the balloon is on the left of the image. Save this new image in your march24 folder with the file name balloon, in a format suitable for inclusion in a web page. Locate only the following files and store them in your march24 folder. m24banner.png m24text.txt m24video.mp4 Display the contents of your march24 folder, showing the folder name, all file names, file extensions, file sizes, image dimensions and the frame height and frame width for the video. Take a screenshot of this folder, making sure that the required information is clearly visible. Place this screenshot in your Evidence Document. [3] [Total: 3] Task 3 – Web page

Question

Create a web page called sbs.htm and save this in your march24 folder. This web page must be created using a single table and work in all browsers. The table must fit 90% of the browser window and have a structure as shown in this diagram: A Width 30% B Width 70% C Height 10% D Height 15% E Each table cell is identified with a letter. Some dimensions are shown. Do not set the height of cells B or E. Table borders must appear on the final web page. The cell contents shown in the diagram must not appear on the final web page. [7]

Question

Set the title of the web page to Serengeti Balloon Safaris [1]

Question

Place in cell: ● A the image balloon saved in Step 1 so that it fits the width of this cell ● B the image m24banner.png so that it fits the width of this cell ● E a video tag to display m24video.mp4 so that it fits the width of this cell. This video must show the controls and play automatically when the web page opens. Display an automated text-based error message if the browser does not support this video type. [10]

Question

Add appropriate alternate text to both still images. [1]

Question

Enter in cell C the text: This web page was created by: then on a new line enter your name, centre number and candidate number. Set this text as style h2. [3]

Question

Place in cell D the text from the file m24text.txt Set this text as paragraph style. Set the text Memorable and inspiring as style h1. [3]

Question

Open the stylesheet m24sbs.css in an editor. Add CSS to this stylesheet so that: ● your name, centre number and candidate number are set as a comment at the start of the stylesheet ● the table is centre-aligned within the browser window ● all table elements have the space between the borders set to 10 pixels ● all table cells have padding set to 20 pixels ● styles h1 and h2 use the: – font Cooper Black – font Impact if Cooper Black is not available – browser’s default serif font if neither of these fonts are available ● styles h1 and h2 are centre-aligned ● styles h1 and h2 have a font colour with a hexadecimal blue component of 99 and no red or green components ● style h1 is 18 points high ● style h2 is 14 points high. Make sure that your stylesheet does not contain HTML or scripting language and is as efficient as possible. Save this stylesheet in your march24 folder in cascading stylesheet format as m24sbs_ followed by your centre number_candidate number, for example m24sbs_ZZ999_9999 Take a screenshot of your stylesheet and place this in your Evidence Document. Make sure that the file name and all contents are clearly visible. Attach this stylesheet to your web page. [16]

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 entire page can be seen ● all the text can be easily read ● the address bar is fully visible. Take a screenshot showing your web page in the browser. Place this in your Evidence Document. [1] [Total: 42] Task 4 – Printing the Evidence Document Make sure your name, centre number and candidate number appear on every page of your Evidence Document. Save your Evidence Document. Print your Evidence Document. Task 5 – Spreadsheet You are going to create a spreadsheet to calculate the cost for Serengeti Balloon Safaris of collecting guests from their lodge or camp and taking them to the place where the balloon will launch. The company uses a number of fixed launch sites. The site will change each day depending on the wind direction. All currency values must be in Tanzanian shillings, with two decimal places and a symbol of TZS, for example 12.50 TZS for 12.50 Tanzanian shillings.

Question

Open and examine the file m24distance.csv This file will be used in Steps 12 and 13. Do not make any changes to this file. Open and examine the file m24calc.csv Save the file m24calc.csv as a spreadsheet with the file name Calculate_ followed by your centre number_candidate number, for example Calculate_ZZ999_9999 Format the spreadsheet so that it looks like this: A B C 1 Serengeti Balloon Safaris 2 3 Launch site E 4 Lodge/Camp code 17 5 6 Lodge/Camp name 7 Distance from lodge/camp to launch site in miles 8 Driving time in minutes 9 10 Cost Make sure cells A1 to C1 are merged and have an 18-point black font on a light blue background. [5]

Question

Enter your name, centre number and candidate number right-aligned in the header. [1]

Question

Place a formula in cell B6 to look up the name of the lodge or camp using the camp code and the external file m24distance.csv for the array. [5]

Question

Place a formula in cell B7 to look up the distance in miles from the lodge or camp using the launch site and the external file m24distance.csv for the array. [7]

Question

Place a formula in cell B8 to calculate the time in minutes taken for the journey from the lodge or camp to the launch site, where the vehicle travels at 20 miles per hour. Distance × 60 Time = Speed [2]

Question

Place a formula in cell B10 to calculate the cost for this journey. Cost = Driving time rounded to the nearest hour × 2200 shillings plus the distance in miles × 800 shillings [3]

Question

Apply appropriate formatting to cell B10. Save your spreadsheet. Print your spreadsheet showing the formulae. Make sure that: ● the printout is in landscape orientation ● the row and column headings are displayed ● the contents of all cells are fully visible. Print the spreadsheet showing the values. Make sure that the: ● printout fits on a single page ● contents of all cells are fully visible. [2] [Total: 25]