Cambridge IGCSE Information and Communication Technology (9-1) 0983 — 2020 May/June Paper 3 · Variant 2

Cambridge IGCSE™(9–1) This document has 8 pages. Blank pages are indicated. * 6 8 7 2 7 9 6 1 6 4 * INFORMATION AND COMMUNICATION TECHNOLOGY 0983/32 Paper 3 Data Analysis and Website Authoring May/June 2020 2 hours 30 minutes You will need: Candidate source files (listed on page 2) INSTRUCTIONS ● Carry out all instructions in each step. ● Enter your name, centre number and candidate number on every printout before it is sent to the printer. ● Printouts with handwritten candidate details will not be marked. ● At the end of the examination, put all your printouts into the Assessment Record Folder. ● If you have produced rough copies of printouts, put a cross through each one to indicate that it is not the copy to be marked. ● You must not have access to either the internet or any email system during this examination. INFORMATION ● The total mark for this paper is 80. ● The number of marks for each question or part question is shown in brackets [ ]. DC (DH) 199021/1 © UCLES 2020 [Turn over

2 0983/32/M/J/20 © UCLES 2020 You have been supplied with the following source files: 2032-ab.css 2032-ab2.htm 2032-accom.jpg 2032-alinao.mp4 2032-beach.jpg 2032-logo.jpg 2032-summary.csv 2032-view.jpg Task 1 – Evidence Document Create a new word-processed document. Make sure your name, centre number and candidate number will appear on every page of this document. Save this Evidence Document in your work area as J2032-evidence followed by your candidate number. For example, J2032-evidence9999 You will need your Evidence Document during the examination to place screenshots when required. Task 2 – Web Page You are going to create a web page for the Alinao Beach and Dive Resort in the Philippines. The web page must work in any browser. All colour codes must be in hexadecimal. 1 Create a new folder called AB Locate the following files and store them in your AB folder. 2032-ab.css 2032-ab2.htm 2032-accom.jpg 2032-alinao.mp4 2032-beach.jpg 2032-logo.jpg 2032-view.jpg Open the file 2032-accom.jpg Crop this image to remove the top so that the image is 456 pixels high and 265 pixels wide. Save this image as 2032-acc.jpg Display the contents of your AB folder showing the folder name, all file names, extensions, image dimensions and file sizes. [3] EVIDENCE 1 Take a screenshot of your AB 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.

3 0983/32/M/J/20 © UCLES 2020 [Turn over 2 Create a web page called ab.htm This web page must work in all browsers and will have a table structure as shown below: A 855 × 200 B 855 × 480 C 265 × 60 F 265 × 456 D 265 × 60 G 265 × 456 E 265 × 60 H 265 × 274 I 265 × 162 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. The table shows the spacing between cells which will be set when your stylesheet is attached in step 9. Table borders must appear on the final web page. [12] 3 Place in cell A the image 2032-logo.jpg [1] 4 Place in cell B, a placeholder, 855 pixels wide and 480 pixels high, containing the video clip 2032-alinao.mp4 Display an automated text-based error message if the browser does not support this video type. [7] 5 Place in cell: • C the text Location • D the text Accommodation • E the text Beach Set this text to style h2. [2]

4 0983/32/M/J/20 © UCLES 2020 6 Place in cell: • F the image 2032-view.jpg • G the image 2032-acc.jpg • H the image 2032-beach.jpg Where necessary, in the HTML, make sure that each image is displayed as 265 pixels wide whilst maintaining the aspect ratio. [3] 7 Enter in cell I the text: Web page last updated by followed by a space, then your name, centre number and candidate number. Set this text to style h3. [2] 8 Add appropriate alternate text to all still images. [1] 9 Attach the stylesheet 2032-ab.css to this web page. Save your web page. [1] 10 Set the name of the default target window to _blank [1] 11 Create hyperlinks from the text Location and from the image 2032-view.jpg to open the web page 2032-ab2.htm in a new browser window called _location [4] 12 Create a hyperlink from all the text placed in cell I to send an email message to ab@cambridgeinternational.org with a subject line Enquiry about Alinao [5] Display the web page in your browser. If necessary, resize it so that: • all the page width can be seen • all text can be easily read • the address bar is visible. EVIDENCE 2 Place in your Evidence Document screenshots showing the web page in your browser. Display the HTML source in your editor. EVIDENCE 3 Take a copy of the HTML source and place this in your Evidence Document. [Total: 42]

5 0983/32/M/J/20 © UCLES 2020 [Turn over Task 3 – Data Analysis You are going to edit a spreadsheet to calculate profit and loss for the Alinao Beach and Dive Resort. Alinao’s financial year is split into four quarters. Each quarter has three months. All currency values must be in dollars to 0 decimal places. 13 Open and examine the file 2032-summary.csv in a spreadsheet package. In the header enter and centre align the text: Edited by: followed by a space, your name, centre number and candidate number. In the footer enter and centre align the text: Edited on: followed by a space, today’s 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 Summary_ followed by your centre number and candidate number. For example, Summary_ZZ999_9999 [4] 14 Format the spreadsheet to look like this: 22 21 20 25 24 23 19 15 14 13 18 17 16 12 8 7 6 11 10 9 5 4 3 Highest quarterly profit Lowest quarterly profit Average monthly profit Average quarterly profit Sub-total Sub-total Sub-total Sub-total 4 3 2 1 Quarter Month April May June July August September October November December January February March Visitors 15 15 11 9 8 23 22 12 0 7 11 32 Income 16515 18003 14600 12048 11724 42424 38698 16451 0 10321 15087 40320 Expenditure 8896 12089 10530 Profit 11724 8632 23975 19345 23041 16040 5324 9379 36691 Annual total 1 A B D E F G C Alinao Beach and Dive Resort 2 Format the merged cell in row 1 to contain orange text, font size 24, on a black background. The text in this cell should contrast with the background when printed in black and white. Format the text in the merged cells in column B to be font size 20. [11]

6 0983/32/M/J/20 © UCLES 2020 15 In cell D12 use a function to calculate the total number of visitors for April, May and June. [1] 16 In cell E12 use a function to calculate the total income for April, May and June. [1] 17 In cell F12 use a function to calculate the total expenditure for April, May and June. [1] 18 Replicate the formulae entered in steps 15 to 17 to calculate the sub-totals for all other quarters. [1] 19 Calculate the profit for each month and each quarter. Profit = Income – Expenditure [2] 20 Calculate, in appropriate cells, the total number of visitors, the total income, the total expenditure and the total profit for the year. [1] 21 Format cell G9 to have a red background with white text, only if the value in the cell is negative. Apply this formatting to cells B3 to B6 and to all other cells containing numeric values in column G. [4] EVIDENCE 4 Place in your Evidence Document a screenshot that shows how you applied the formatting to cell G9. 22 In cell B3 use a function to display the highest profit for any quarter. [2] 23 In cell B4 use a function to display the lowest profit for any quarter. [1] 24 In cell B5 use a function to display the average monthly profit. [2] 25 In cell B6 use a function to display the average quarterly profit. [1] 26 Format all currency values in dollars with 0 decimal places. [1] 27 In cell C3 use a formula to display the number of the quarter which made the highest quarterly profit. The number of each quarter is displayed in column B. [2]

7 0983/32/M/J/20 © UCLES 2020 28 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 and can be easily read. [2] PRINTOUT 1 Make sure that you have entered your name, centre number and candidate number on your spreadsheet showing the formulae. 29 Print 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. [1] PRINTOUT 2 Make sure that you have entered your name, centre number and candidate number on your spreadsheet showing the values. [Total: 38] Task 4 – Printing the Evidence Document You now need to print your Evidence Document. PRINTOUT 3 Make sure that your name, centre number and candidate number appear on every page of your Evidence Document.

8 0983/32/M/J/20 © UCLES 2020 Permission to reproduce items where third-party owned material protected by copyright is included has been sought and cleared where possible. Every reasonable effort has been made by the publisher (UCLES) to trace copyright holders, but if any items requiring clearance have unwittingly been included, the publisher will be pleased to make amends at the earliest possible opportunity. To avoid the issue of disclosure of answer-related information to candidates, all copyright acknowledgements are reproduced online in the Cambridge Assessment International Education Copyright Acknowledgements Booklet. This is produced for each series of examinations and is freely available to download at www.cambridgeinternational.org after the live examination series. Cambridge Assessment International Education is part of the Cambridge Assessment Group. Cambridge Assessment is the brand name of the University of Cambridge Local Examinations Syndicate (UCLES), which itself is a department of the University of Cambridge. BLANK PAGE

This document consists of 10 printed pages. © UCLES 2020 [Turn over Cambridge IGCSE™ (9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/32 Paper 3 Practical Test B May/June 2020 MARK SCHEME Maximum Mark: 80 Published Students did not sit exam papers in the June 2020 series due to the Covid-19 global pandemic. This mark scheme is published to support teachers and students and should be read together with the question paper. It shows the requirements of the exam. The answer column of the mark scheme shows the proposed basis on which Examiners would award marks for this exam. Where appropriate, this column also provides the most likely acceptable alternative responses expected from students. Examiners usually review the mark scheme after they have seen student responses and update the mark scheme if appropriate. In the June series, Examiners were unable to consider the acceptability of alternative responses, as there were no student responses to consider. Mark schemes should usually be read together with the Principal Examiner Report for Teachers. However, because students did not sit exam papers, there is no Principal Examiner Report for Teachers for the June 2020 series. Cambridge International will not enter into discussions about these mark schemes. Cambridge International is publishing the mark schemes for the June 2020 series for most Cambridge IGCSE™ and Cambridge International A & AS Level components, and some Cambridge O Level components.

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 2 of 10 Generic Marking Principles These general marking principles must be applied by all examiners when marking candidate answers. They should be applied alongside the specific content of the mark scheme or generic level descriptors for a question. Each question paper and mark scheme will also comply with these marking principles. GENERIC MARKING PRINCIPLE 1: Marks must be awarded in line with: • the specific content of the mark scheme or the generic level descriptors for the question • the specific skills defined in the mark scheme or in the generic level descriptors for the question • the standard of response required by a candidate as exemplified by the standardisation scripts. GENERIC MARKING PRINCIPLE 2: Marks awarded are always whole marks (not half marks, or other fractions). GENERIC MARKING PRINCIPLE 3: Marks must be awarded positively: • marks are awarded for correct/valid answers, as defined in the mark scheme. However, credit is given for valid answers which go beyond the scope of the syllabus and mark scheme, referring to your Team Leader as appropriate • marks are awarded when candidates clearly demonstrate what they know and can do • marks are not deducted for errors • marks are not deducted for omissions • answers should only be judged on the quality of spelling, punctuation and grammar when these features are specifically assessed by the question as indicated by the mark scheme. The meaning, however, should be unambiguous. GENERIC MARKING PRINCIPLE 4: Rules must be applied consistently e.g. in situations where candidates have not followed instructions or in the application of generic level descriptors. GENERIC MARKING PRINCIPLE 5: Marks should be awarded using the full range of marks defined in the mark scheme for the question (however; the use of the full mark range may be limited according to the quality of the candidate responses seen). GENERIC MARKING PRINCIPLE 6: Marks awarded are based solely on the requirements as defined in the mark scheme. Marks should not be awarded with grade thresholds or grade descriptors in mind.

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 3 of 10 Evidence 1 Screen shot folder name, filenames, dimensions, extensions, file sizes 1 mark 2032-acc.jpg 265 x 456 pixels 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 4 of 10 Evidence 2 In browser with no letters vis 1 mark Borders/gridlines visible 1 mark 2032-logo.jpg visible 1 mark Video seen 1 mark Location ↓ Accommodation ↓ Beach 1 mark In h2 1 mark 3 still images as shown 1 mark All 3 images same width (265 pixels) 1 mark Image not distorted when cropped. 1 mark Staggered cells visible 1 mark Web page last updated by A Candidate ZZ999 9999 1 mark in h3 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 5 of 10 Evidence 3 <!DOCTYPE html> <html> <head> <link rel="stylesheet" type="text/css" href="2032-ab.css"> <Title>Alinao Beach and Dive Resort Homepage</title> <base target="_blank"> </head> <body> <table border=1> <tr> <td colspan=3 style="width:855px; height:200px;"> <img src="2032-logo.jpg" alt="Company logo for Alinao Beach and Dive Resort"> </td> </tr> <tr> <td colspan=3 style="height:480px;"> <video width="855" height="480" controls> <source src="2032-alinao.mp4" type="video/mp4"> Your browser does not support this video file type. </video> </td> </tr> <tr> <td style="width:265px; height:60px;"> <h2><a href="2032-ab2.htm" target=”_location”> Location</a></h2> </td> <td style="width:265px; height:60px;"> <h2>Accommodation</h2> </td> <td style="width:265px; height:60px;"> <h2>Beach</h2> </td> </tr> Stylesheet 2032-ab.css attached 1 mark Target Base target=”_blank” 1 mark Table width=855 1 mark Top row height=200 1 mark Rows 1 and 2 colspan=3 1 mark Row 2 height:480px 1 mark video <…> tag used … 1 mark … width="855" height="480" 1 mark Source<…> tag used … 1 mark … src="2032-alinao.mp4" 1 mark type="video/mp4" 1 mark Appropriate error message 1 mark Row 3 All 3 cells - width:265; height:60 1 mark Hyperlinks Anchor around text Location 1 mark Anchor around image 2032-view.jpg 1 mark href=”2032-ab2.htm” 1 mark target=” location” 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 6 of 10 <tr> <td rowspan=2 style="width:265px; height:456px;"> <a href="2032-ab2.htm" target=”_location”> <img src="2032-view.jpg" alt="View from hotel grounds"> </a> </td> <td rowspan=2 style="width:265px; height:456px;"> <img src="2032-acc.jpg" alt="Image of rooms"> </td> <td style="width:265px; height:274px;"> <img src="2032-beach.jpg" alt="Image of beach" style="width:265px"> </td> </tr> <tr> <td style="width:265px; height:162px;"> <h3><a href="mailto:ab@cambridgeinternational.org?subject=Enquiry%20about%20Alinao "> Web page last updated by A Candidate ZZ999 9999</a></h3> </td> </tr> </table> </body> </html> Row 4 Left 2 cells - width:265; height:456 1 mark Left 2 cells – rowspan=2 1 mark Right cell width:265; height:274 1 mark 2032-beach Image resized to 265 wide with aspect ratio 1 mark Row 5 width:265; height:162 1 mark Hyperlink Anchor around … all text in row 5 1 mark href=“mailto: 1 mark ab@cambridgeinternational.org 1 mark ?subject= 1 mark Enquiry about Alinao 1 mark Alt attribute appropriate alt text for all 4 images 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 7 of 10 Evidence 4 Format G9 G9 conditional formatting applied 1 mark Format only cells that contain 1 mark Cell value less than 0 1 mark White text on red background 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 8 of 10 Row 1 Cells A1 to G1 merged & centre aligned 1 mark 24 point 1 mark Orange font with good contrast 1 mark Black background 1 mark A3:B6, C3 & totals Gridlines 1 mark A & B & row 8 Bold 1 mark Column A Right aligned 1 mark C & row 8 Centre aligned 1 mark 4 Quarters 20 point 1 mark Centre aligned vertically and horizontally 1 mark All text Sans-serif font 1 mark Numbers Formatted as currency in $ with 0dp 1 mark Values Single page no row and col heads fully vis 1 mark Header Edited by: space Name & numbers 1 mark Footer Edited on: space date space 1 mark at space automated time 1 mark Both Header & Footer in centre 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 9 of 10 B3 =MAX( … ) 1 mark … G12,G16,G20,G24 1 mark B4 =MIN(G12,G16,G20,G24) 1 mark B5 =AVERAGE( … ) 1 mark … G9:G11,G13:G15,G17:G19,G21:G23 1 mark B6 =AVERAGE(G12,G16,G20,G24) 1 mark C3 Nested IF statements 1 mark To generate correct quarter 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 10 of 10 D12 =SUM(D9:D11) 1 mark E12 =SUM(E9:E11) 1 mark F12 =SUM(F9:F11) 1 mark Replication All 3 formulae replicated for all quarters 1 mark G9 =E9-F9 1 mark G12 =SUM(G9:G11) =E12-F12 1 mark Row 25 Rows 12,16,20 and 24 added for all 4 cells 1 mark Row and column headings displayed 1 mark Landscape and fully visible 1 mark