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

Question

Open and examine the files wreck.csv and diveplanner.csv in a spreadsheet package. Save the dive planner file as a spreadsheet with the file name planner_ followed by your centre number and candidate number, for example, planner_ZZ999_9999 Insert a new row between the rows containing Planned dive time and Safe? Format the top of the spreadsheet to look like this: A B C 1 Just-Dive-4-Rust 3 Dive planner 5 Dive 1 Dive 2 6 Wreck code 7 Wreck code Format the merged cell A1 to have white text on a dark blue background. Format the merged cell B3 to have black text on a pale blue background. Save the spreadsheet. [11]

Question

Place your name, centre number and candidate number, left aligned in the header. Place the text Last edited on followed by an automated date, centre aligned in the footer. [2]

Question

In cell B7 use a function to look up the wreck name. Use the Wreck code cell for this dive for the lookup value and the file wreck.csv for the array. [8]

Question

In cell B8 use a function to look up the depth of the dive. Use the Wreck code cell for this dive for the lookup value and the file wreck.csv for the array. [4]

Question

Replicate the functions used in steps 3 to 4 for both dives. [1] It is safer to do the deepest dive first. Just-Dive-4-Rust want an error message displayed if the second dive is deeper than the first.

Question

Merge cells B11 and C11. In this merged cell use a formula to display the text Unsafe, second dive is deeper if the second planned dive will be deeper than the first, or to display Yes if this is not the case. Format this merged cell to have a red background with white text only if the message Unsafe, second dive is deeper is displayed in it. [8] EVIDENCE 1 Place in your Evidence Document a screenshot that shows how you applied the formatting to this merged cell.

Question

Save your spreadsheet. Print only cells A1 to C11 of your spreadsheet showing the formulae. Make sure: • it is in landscape orientation • the row and column headings are displayed • the contents of these cells are fully visible and can be easily read. [3] PRINTOUT 1 Make sure that you have entered your name, centre number and candidate number on your spreadsheet showing the formulae.

Question

Use the spreadsheet to plan dives with wreck codes of first A and then O. Save your spreadsheet. Print only cells A1 to C11 of your spreadsheet showing the values. Make sure the: • printout fits on a single page • row and column headings are not displayed • contents of these cells are fully visible and can be easily read. [5] PRINTOUT 2 Make sure that you have entered your name, centre number and candidate number on your spreadsheet showing the values.

Question

Use the spreadsheet to plan dives with wreck codes of first O and then A. Save your spreadsheet. Print only cells A1 to C11 of your spreadsheet showing the values. Make sure the: • printout fits on a single page • row and column headings are not displayed • contents of these cells are fully visible. [1] PRINTOUT 3 Make sure that you have entered your name, centre number and candidate number on your spreadsheet showing the values. [Total: 43] Task 3 – Web Page You are going to create a web page and edit a stylesheet for Just-Dive-4-Rust. The web page and stylesheet must work in any browser. All colour codes, except those provided in the source files, must be in hexadecimal. Make sure that your stylesheet contains no HTML.

Question

Create a new folder called jd4r Locate the following files and store them in your jd4r folder. aircraft.png jd4r.css jd4rlogo.png ship.jpg wreck1.mp4 Display the contents of your jd4r folder showing the folder name, all file names, extensions, image dimensions and file sizes. [1] EVIDENCE 2 Take a screenshot of your jd4r folder and place this in your Evidence Document. Make sure that the folder name, all file names, extensions, image dimensions and file sizes are clearly visible.

Question

Create a web page called jd4r.htm This web page must work in all browsers and will have a table structure as shown below: A 1000 × 200 B C 360 × 270 640 × 390 D 360 × 120 E F 360 × 270 640 × 270 Each table cell is identified with a letter and all dimensions are in pixels. The letters and dimensions shown in the table must not appear on your final web page. Table borders must appear on the final web page. [10]

Question

Place in cell A the image jd4rlogo.png Set the width of this image in the HTML to 1000 pixels and maintain the aspect ratio. [2]

Question

Place in cell: • B the image to be used to select diving ship wrecks • C a placeholder 640 pixels wide and 354 pixels high containing the video clip wreck1.mp4 Display an automated text-based error message if the browser does not support this video type • E the image to be used to select diving aircraft wrecks. [10]

Question

Enter in cell D the text: Just wrecked! Set this text as style h1. [1]

Question

Enter in cell F the text: We offer some of the best wreck diving in the world. On a new line below this enter the text: Edited by followed by your name, centre number and candidate number. [2]

Question

Set the text in cell F to style h2. [1]

Question

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

Question

Attach the stylesheet jd4r.css to this web page. Save your web page. [1]

Question

Open the stylesheet jd4r.css in a suitable software package. Edit this stylesheet to add the following specifications: All table borders and gridlines are blue (with no red or green components), with a solid visible (collapsed) line that is 2 pixels wide. All cell padding within the table is to be set to 10 pixels. Add your name, centre number and candidate number as a comment at the start of the stylesheet. Save this stylesheet in your jd4r folder. Take a screenshot of the contents of your stylesheet. [8] EVIDENCE 3 Place this screenshot in your Evidence Document. Make sure the file name and all contents are clearly visible. Display the web page in your browser. If necessary, resize it so that: • all the page can be seen • all text can be easily read • the address bar is visible. EVIDENCE 4 Take a single screenshot of the browser window and place this in your Evidence Document. Display the HTML source in your editor. EVIDENCE 5 Take a copy of the HTML source and place this in your Evidence Document. [Total: 37] Task 4 – Printing the Evidence Document You now need to print and save your Evidence Document. PRINTOUT 4 Make sure that your name, centre number and candidate number appear on every page of your Evidence Document.