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

This document has 8 pages. Blank pages are indicated. DC (KS) 199020 © UCLES 2020 [Turn over * 8 2 5 1 5 1 2 8 9 5 * Cambridge IGCSE™(9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/31 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 [ ].

2 0983/31/M/J/20 © UCLES 2020 You have been supplied with the following source files: 2031-bg.png 2031-board.csv 2031-board.png 2031-logo.png 2031-proc.csv 2031-proc.png 2031-tgc.css 2031-water.png 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 J2031-Evidence followed by your candidate number. For example, J2031‑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 and edit a stylesheet for Tawara Gaming Computers. The web page and stylesheet must work in any browser. All colour codes must be in hexadecimal. Make sure that your stylesheet contains no HTML. 1 Create a new folder called TGC Locate the following files and store them in your TGC folder. 2031-bg.png 2031-board.png 2031-logo.png 2031-proc.png 2031-tgc.css 2031-water.png Display the contents of your TGC folder showing the folder name, all file names, extensions, image dimensions and file sizes. [1] EVIDENCE 1 Take a screenshot of your TGC 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/31/M/J/20 © UCLES 2020 [Turn over 2 Create a web page called tgc.htm This web page must work in all browsers and will have a table structure as shown below: A 750 × 100 B 260 × 470 C 225 × 225 D 225 × 225 E 225 × 225 F 225 × 225 H 225 × 225 G 260 × 225 I 225 × 225 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 edited in step 10. Table borders must not appear on the final web page. [11] 3 Enter in cell A the text: Tawara Gaming Computers Set this to style h1. [2] 4 Place in cell B the image 2031-logo.png [1]

4 0983/31/M/J/20 © UCLES 2020 5 Place in cell: • C the image 2031-proc.png • E the image 2031-board.png • H the image 2031-water.png Where necessary, in the HTML, make sure that each image is displayed as 225 pixels wide whilst maintaining the aspect ratio. [3] 6 Place in cell: • D the text Processors • F the text Motherboards • I the text Water cooling systems Set this text to style h2. [2] 7 Enter in cell G the text: Last edited by: On a new line enter your name, centre number and candidate number. Set all the text in cell G to style h3. [2] 8 Add appropriate alternate text to all images. [1] 9 Attach the stylesheet 2031-tgc.css to this web page. Save your web page. [1] 10 Open the stylesheet 2031-tgc.css in a suitable software package. Edit this stylesheet to meet the following specification: All table borders have a width of 0 and gridlines are separated. All cell spacing within the table is set to 20 pixels. The background colour of the table is black. All tables are centre aligned in the browser. There is no cell padding. The background image 2031-bg.png is set to repeat to fill the browser window. Styles h1, h2 and h3 are green (with no red or blue components) and have the font Segoe print, if it is not available then Verdana, or if neither of these fonts are available the browser’s default sans serif font. Style h1 is set to 36 points high. Style h2 is set to 14 points high, left aligned. Style h3 is set to 12 points high, right aligned.

5 0983/31/M/J/20 © UCLES 2020 [Turn over Add your name, centre number and candidate number as a comment at the bottom of the stylesheet. Save this stylesheet in your TGC folder. Take a screenshot of the contents of your stylesheet. [24] EVIDENCE 2 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 3 Place in your Evidence Document screenshot(s) showing the web page in your browser. Display the HTML source in your editor. EVIDENCE 4 Take a copy of the HTML source and place this in your Evidence Document. [Total: 48] Task 3 – Printing the Evidence Document You now need to print your Evidence Document. PRINTOUT 1 Make sure that your name, centre number and candidate number appear on every page of your Evidence Document.

6 0983/31/M/J/20 © UCLES 2020 Task 4 – Data Analysis You are going to create a spreadsheet to use as an invoice for Tawara Gaming Computers. Open and examine the files 2031-proc.csv and 2031-board.csv Do not edit or re‑save these files. You will require these files for steps 12 to 15. 11 Create and format a new spreadsheet that looks like this: A 2 4 5 6 7 8 9 10 11 13 14 15 16 17 B C D 1 3 12 Invoice number: Customer: Processor: Make Model Price Motherboard: Subtotal: Discount: Invoice total: Special offer - twin purchase Jawara Gaming Computers Invoice If the cursive font style shown in rows 1 and 5 is not available on your computer you can use another similar font style. The merged cells in rows 1 and 5 must have the same green font on a black background. The font in the merged cell in row 3 must have the same green colour as rows 1 and 5 on a grey background. The text in all cells must contrast with their backgrounds when printed in black and white. Place your name, centre number and candidate number, right aligned in the header. Place the text: Last edited on followed by an automated date, centre aligned in the footer. Save the spreadsheet with the file name Invoice_ followed by your centre number and candidate number. For example, Invoice_ZZ999_9999 [14]

7 0983/31/M/J/20 © UCLES 2020 [Turn over The model of the processor and motherboard will be typed into cells C11 and C12 of the invoice spreadsheet. The company offers a 20% reduction in the price of their products, which is calculated in steps 17 and 18. 12 In cell B11 use a function to look up the make of the processor. Use cell C11 for the lookup value and the processor file for the array. [5] 13 In cell B12 use a function to look up the make of the motherboard. Use cell C12 for the lookup value and the board file for the array. [3] 14 In cell D11 use a function to look up the price of the processor. [1] 15 In cell D12 use a function to look up the price of the motherboard. [1] 16 In cell D14 use a formula to add the price of the processor to the price of the motherboard. [1] 17 In cell D15 use a formula to calculate the discount that will be offered on this invoice. The discount rate is 20% of the subtotal. [1] 18 In cell D16 use a formula to calculate the invoice total. [1] 19 Enter the following data in the appropriate cells in column C of your invoice: Processor: i7-5930K Motherboard: Prime Z270-P [1] 20 Format all currency values as dollars with 2 decimal places. [1] 21 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 these cells are fully visible and can be easily read. [2] PRINTOUT 2 Make sure that you have entered your name, centre number and candidate number on your spreadsheet showing the formulae.

8 0983/31/M/J/20 © UCLES 2020 22 Print your spreadsheet showing the values. Make sure the: • printout fits on a single portrait page • row and column headings are not displayed • contents of these cells are fully visible and can be easily read. [1] PRINTOUT 3 Make sure that you have entered your name, centre number and candidate number on your spreadsheet showing the values. [Total: 32] 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.

This document consists of 8 printed pages. © UCLES 2020 [Turn over Cambridge IGCSE™ (9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/31 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/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 2 of 8 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/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 3 of 8 Evidence 1 Screen shot includes folder name, filenames, dimensions, extensions, file sizes 1 mark

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 4 of 8 Evidence 2 table border-collapse:separate; 1 mark border-width:0px; 1 mark border-spacing:20px; 1 mark background-color:#000000; 1 mark margin-left:auto; margin-right:auto; 1 mark td padding:0px 1 mark body background-image: url("2031-bg.png"); 1 mark background-repeat:repeat; 1 mark h1,h2,h3 color:#00ff00; 1 mark font-family:"Segoe print" 1 mark In speech marks 1 mark ,Verdana 1 mark ,sans-serif 1 mark Single statement for all 3 styles 1 mark h1 font-size:36pt; 1 mark text-align retained as center 1 mark h2 font-size:14pt; 1 mark text-align:left 1 mark h3 font-size:12pt; 1 mark text-align:right 1 mark comment Comment added with /* name */ 1 mark CSS syntax Correct css syntax 1 mark

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 5 of 8 Evidence 3 In browser with no letters vis 1 mark Background Image visible tiled x and y with black table 1 mark Table Borders/gridlines hidden 1 mark Top row Tawara Gaming Computers 1 mark In h1 1 mark Row 2 left 2031-logo.png 1 mark Middle col 3 still images as shown 1 mark Right column Text as shown 1 mark in h2 1 mark Bottom left Last edited by: <New line> and cand details 1 mark in h3 1 mark Cell spacing 20 points visible between the cells 1 mark

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 6 of 8 Evidence 4 <!DOCTYPE html> <html> <head> <link rel="stylesheet" type="text/css" href="2031-tgc.css"> </head> <body> <table> <tr> <td colspan=3 style="width:750px; height:100px;"> <h1>Tawara Gaming Computers</h1> </td> </tr> <tr> <td rowspan=2 style="width:260px; height:470px;"> <img src="2031-logo.png" alt="Company logo for Tawara Gaming Computers"> </td> <td style="width:225px; height:225px;"> <img src="2031-proc.png" alt="Image of a processor chip"> </td> <td style="width:225px; height:225px;"> <h2>Processors</h2> </td> </tr> <tr> <td style="width:225px; height:225px;"> <img src="2031-board.png" alt="Image of a motherboard" style="width:225px"> </td> <td style="width:225px; height:225px;"> <h2>Motherboards</h2> </td> </tr> <tr> <td style="width:260px; height:225px;"> <h3>Last edited by: </h3> <h3>A Candidate ZZ999 9999</h3> </td> <td style="width:225px; height:225px;"> <img src="2031-water.png" alt="Image of a water cooling systems"> </td> <td style="width:225px; height:225px;"> <h2>Water cooling systems</h2> </td> </tr> </table> </body> </html> Stylesheet 2031-tgc.css attached in head section 1 mark Table Width=750 1 mark Visible here or in first td Top row height=100 1 mark colspan=3 1 mark Row 2 left rowspan=2 1 mark style=”width:260px; height:470px” 1 mark Rows 2–3 middle and right style=”height:225px” 1 mark Rows 2–4 middle cells style=”width:225px” 1 mark right cells style=”width:225px” 1 mark Row 3 middle Image 2031-board.png width=225 1 mark Aspect ratio maintained 1 mark Row 4 left style=”width:260; height:225” 1 mark Alt attribute appropriate alt text for all 4 images 1 mark

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 7 of 8 B11 =VLOOKUP (C11 … ) 1 mark External file 2031-proc.csv, 1 mark A2:B44 or A2:G44 1 mark Correct return column ,2 1 mark ,0 or ,False 1 mark B12 =VLOOKUP (C12 … ) 1 mark '2031-board.csv'!A2:B121 1 mark ,2,0 1 mark D11 =VLOOKUP(C11,'2031-proc.csv'!A2:G44,7,0) 1 mark D12 =VLOOKUP(C12,'2031-board.csv'!A2:H121,8,0) 1 mark D14 =D11+D12 or =SUM(D11:D12) 1 mark D15 =D14*0.2 or =D14*20% 1 mark D16 =D14-D15 or =D14*0.8 1 mark Row and column headings displayed 1 mark Landscape and fully visible 1 mark

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2020 © UCLES 2020 Page 8 of 8 Header Name and numbers on right 1 mark Footer Last edited on and date in centre 1 mark Rows 1,3,5 Columns A to D merged 1 mark Green font with good contrast 1 mark Rows 1, 5 Black background 1 mark Scripting font 1 mark Centre aligned horizontally and vertically 1 mark Text wrapped 1 mark Row 3 Grey background 1 mark Rows 2, 4, 13 ½ height of rows 7–16 1 mark Rows 3, 7-16 Sans serif font 1 mark Rows 7-12 Left aligned 1 mark Rows 14-16 Right aligned 1 mark All text 100% accuracy 1 mark Data entry i7-5930K and Prime Z270-P 1 mark Numbers Formatted as currency in $ with 2dp 1 mark Extract Single portrait page with no row and col heads 1 mark