Information and Communication Technology 0417/32 May/June 2022: question paper and mark scheme

Question

Open and examine the files j2232costs.csv, j2232currency.csv and j2232project.csv in a spreadsheet package. Place in the j2232costs file, left aligned in the header, your name, centre number and candidate number and right aligned in the header the automated file name and file path. Save this as a spreadsheet with the filename Costs_ followed by your centre number_candidate number, for example, Costs_ZZ999_9999 [3]

Question

Enter a formula in cell C5 to look up the project name using the project code for the value and the external file j2232project.csv for the array. [8]

Question

Enter a formula in cell G5 to display the ISO of the currency for the country displayed in cell D5 using the external file j2232currency.csv for the array. [6]

Question

Enter a formula in cell H5 to calculate the cost in Tawara dollars by dividing the value in the Cost in local currency column by the Exchange Rate, using the external file j2232currency.csv, for that currency. [6]

Question

Replicate the formulae entered in steps 2, 3 and 4 for all transactions. [1]

Question

Merge cells A1 to H1. [1]

Question

Insert a new row between rows 3 and 4 and a new row between rows 1 and 2. [1]

Question

Format rows 1 to 6 to look like this: A B C D E F G H 1 Tawara Wildlife Trust Expenditure 2022 3 First quarter 4 (Jan-Mar) Local Cost in Project Cost in local Date Project name Country Order number currency Tawara code currency 6 ISO dollars 7 10/03/2022 T1 Elephant Orphanage Kenya TWT00001238 12167.6 KES 92.032373 [7]

Question

Apply appropriate formatting to the values stored in column H. [1]

Question

Save your spreadsheet. Print your spreadsheet showing the formulae. Make sure: • it is in landscape orientation • the row and column headings are displayed • the contents of all cells are fully visible. [1] PRINTOUT 1 Make sure that you have entered your name, centre number and candidate number on the spreadsheet showing the formulae.

Question

Print the spreadsheet showing the values. Make sure the: • page width fits on a single landscape page • contents of all cells are fully visible • row and column headings are not displayed. [1] PRINTOUT 2 Make sure that you have entered your name, centre number and candidate number on the spreadsheet showing the values.

Question

Sort the data into date order with the oldest date first. [1]

Question

Extract only the data where the country is either Indonesia or Malaysia. [3]

Question

Print the spreadsheet extract showing the values. Make sure the: • printout fits on a single landscape page • contents of all cells are fully visible. [1] PRINTOUT 3 Make sure that you have entered your name, centre number and candidate number on the spreadsheet extract showing the values.

Question

Remove the extract selection criteria so that all the data is visible. Sort the data into ascending order of country. [1]

Question

Extract only the data where the ISO is EUR and the date is before March 2022. [3]

Question

Print the spreadsheet extract showing the values. Make sure the: • printout fits on a single landscape page • contents of all cells are fully visible. [1] PRINTOUT 4 Make sure that you have entered your name, centre number and candidate number on the spreadsheet extract showing the values. [Total: 46] Task 3 – File Management

Question

Create a new folder called j2232 Locate the following files and store them in your j2232 folder. • j2232img1.jpg • j2232logo.png • j2232twt.htm Display the contents of your j2232 folder showing the folder name, all file names, file extensions, file sizes and image dimensions. Take a screenshot of this folder and place this in your Evidence Document. [1] EVIDENCE 1 A screenshot of your j2232 folder with the required information clearly visible. [Total: 1] Task 4 is on Page 6. Task 4 – Web Page You will create a stylesheet to be attached to the web page you copied to the folder j2232 in step 18. 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: Add a comment at the start of the stylesheet to contain your name, centre number and candidate number. Set the font for styles h1, h2 and h3 so that the browser selects and displays the font Casion Pro Bold. If this font is not available, the browser selects and displays the font Times New Roman. If neither of these fonts are available, the browser should display its default serif font. Set style h1 so the text is red, centre aligned with a 30-point font. Set style h2 so the text is black, fully justified with an 18-point font. Set style h3 so the text is black, left aligned with a 14-point font. Set the table to 25% from the right margin of the browser window and 5% from all other margins of the browser window. Set the padding for all table cells to 10 pixels. Set all table borders and gridlines so that they are not visible. Set the background for the web page so that it has a colour with a: • green component of 9f • blue component of 25 • red component of da Set the background for the webpage to have the image j2232logo.png placed: • only once • in the top right corner • in a fixed position so that it will not scroll with the web page • with a width of 200 pixels • with a height of 150 pixels Save this stylesheet, in cascading stylesheet format, in your j2232 folder with the file name j2232css_ followed by your centre number_candidate number, for example, j2232css_ZZ999_9999 Take a screenshot to show the file name and all contents of your stylesheet and place this in your Evidence Document. Make sure the file name and all contents are clearly visible. [30] EVIDENCE 2 A screenshot of your stylesheet with the required information clearly visible.

Question

Open the webpage j2232twt.htm in an editing package. Attach the stylesheet saved in step 19 to your web page. [1]

Question

Set the title of your web page to Tawara Wildlife Trust [1]

Question

Save your web page. Take a copy of your HTML source and place this in your Evidence Document. EVIDENCE 3 A copy of your HTML source. 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] EVIDENCE 4 Screenshot evidence of your web page in the browser with the table contents and background elements clearly visible. [Total: 33] Task 5 – Printing the Evidence Document Save and print your Evidence Document. PRINTOUT 5 Make sure your name, centre number and candidate number appear on every page of your Evidence Document.