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

This document has 12 pages. Any blank pages are indicated. Cambridge IGCSE™(9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/32 Paper 3 Data Analysis and Website Authoring May/June 2021 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 (LO) 305838/1 © UCLES 2021 [Turn over * 3 5 0 3 1 3 9 9 4 0 *

2 0983/32/M/J/21 © UCLES 2021 You have been supplied with the following source files: j2132banner.jpg j2132camera.csv j2132diver.jpg j2132housing.csv j2132sales.csv j2132text.txt j2132ump.css j2132ump1.jpg j2132ump2.jpg j2132ump3.jpg j2132ump4.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 j2132evidence_ followed by your centre number_ candidate number, for example, j2132evidence_ZZ999_9999 You will need your Evidence Document during the examination to place screenshots when required. Task 2 – Image Editing and File Management 1 Create a new folder called ump Locate the following files and store them in your ump folder. j2132banner.jpg j2132diver.jpg j2132text.txt j2132ump.css j2132ump1.jpg j2132ump2.jpg j2132ump3.jpg j2132ump4.jpg Open the file j2132diver.jpg in a graphics package. Crop the image so that all of the diver is visible and it is 1600 pixels wide by 3000 pixels high. Save this new image in the ump folder, in .png format using the file name diver_candidate number, for example, diver_9999 Display the contents of your ump folder showing the folder name, all file names, file extensions, image dimensions and file sizes. [4]

3 0983/32/M/J/21 © UCLES 2021 [Turn over EVIDENCE 1 Take a screenshot of your ump folder and place this in your Evidence Document. Make sure that the folder name, all file names, file extensions, image dimensions and file sizes are clearly visible. [Total: 4] Task 3 – Web Page You are going to create a web page and stylesheet to show examples of underwater macro photography. 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. Make your HTML and stylesheet as efficient as possible. 2 Create a web page called ump.htm This web page must be created using a single table and must work in all browsers. The table must fit 90% of the browser window. The table must have a structure as shown in this diagram: A height = 15% B width = 30% height = 20% E height = 10% G height = 20% I height = 10% C width = 30% D width = 40% F H J K height = 25% Each table cell is identified with a letter. Some dimensions are shown. These must be set as percentage values and not in pixels. The cell contents shown in the diagram must not appear on your final web page. Table borders must not appear on the final web page. [13]

4 0983/32/M/J/21 © UCLES 2021 3 Place in cell: • A the image j2132banner.jpg • B the image j2132ump1.jpg • C the image j2132ump2.jpg • D the image diver_ that you saved in step 1 • G the image j2132ump3.jpg • H the image j2132ump4.jpg [3] 4 Place inline style attributes into the HTML, so that each image fits the width of the table cell, with its aspect ratio maintained. [3] 5 Place in cell: • E the text Sponge • F the text Nurdibranch • I the text Anemone • J the text Mushroom eels Apply style h1 to all this text. [3] 6 Place in cell K the contents of the file j2132text.txt Display this text as three paragraphs. Add, as a fourth paragraph, the text: Web page last edited by: followed by your name, centre number and candidate number Apply style h2 to all text in cell K. [4] 7 Attach the stylesheet j2132ump.css to this web page. Save your web page. [1]

5 0983/32/M/J/21 © UCLES 2021 [Turn over 8 Open and edit the stylesheet j2132ump.css to meet the following specifications: Centre align all tables within the browser window. Set the background for the web page so that it has a colour with a: • blue component of d6 • red component of 6f • green component of ea Set the font for styles h1 and h2, so that the browser selects and displays the font Domino Regular. If this font is not available, the browser selects and displays the font Domino. If neither of these fonts are available, the browser should display its default serif font. Set each of these fonts as black. Set style h1 so the text is centre aligned with a 24 point font. Set style h2 so the text is fully justified with a 16 point font. Add your name, centre number and candidate number as a comment at the start of the stylesheet. Save this stylesheet in your ump folder. Take a screenshot to show the file name and all contents of your stylesheet. [15] EVIDENCE 2 Place this screenshot in your Evidence Document. Make sure that the contents of your stylesheet can be easily read. 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: 42]

6 0983/32/M/J/21 © UCLES 2021 Task 4 – Printing the Evidence Document Save and print your Evidence Document. PRINTOUT 1 Make sure your name, centre number and candidate number appear on every page of your Evidence Document. Task 5 – Data Analysis You are going to use a spreadsheet to calculate the sales price of underwater cameras. All currency values must be in pounds (£) to 2 decimal places. 9 Open and examine the files j2132camera.csv and j2132housing.csv in a spreadsheet package. These files will be used to provide data for your spreadsheet and must not be changed. Open and examine the file j2132sales.csv in your spreadsheet. Place the text Prepared by: followed by a space, your name, centre number and candidate number right aligned in the header. Data has been placed into cells B4 and B9 to help you test your model. Save this spreadsheet with the file name j2132sales_centre number_candidate number, for example, j2132sales_ZZ999_9999 [2]

7 0983/32/M/J/21 © UCLES 2021 [Turn over 10 Format the spreadsheet to look like this: 12 7 3 2 A B 4 5 6 Code C004 Camera Underwater Macro Photography Make/Model Price Code H007 Make/Model Price Price Discount % Discount amount 8 9 10 11 Housing 13 14 15 16 Package Package total 17 1 Format the merged cell A1:B1 to contain black 36 point text on a pale blue background. Format the merged cells A3:B3, A8:B8 and A13:B13 to contain black 18 point text on a pale blue background. [7] 11 Enter a function in cell B5, which depending on the camera code, looks up the make and model of the camera from the file j2132camera.csv [5] 12 Enter a function in cell B6, which depending on the camera code, looks up the price of the camera from the file j2132camera.csv [1] 13 Enter a function in cell B10, which depending on the housing code, looks up the make and model of the housing from the file j2132housing.csv [1] 14 Enter a function in cell B11, which depending on the housing code, looks up the price of the housing from the file j2132housing.csv [1]

8 0983/32/M/J/21 © UCLES 2021 15 Enter a formula in cell B14 to calculate the price of both the camera and the housing. [1] 16 Enter a formula in cell B15 to show the discount percentage that will be applied. Use the package price to extract the figure from the discount table. [5] 17 Enter a formula in cell B16 to calculate the discount amount to be applied, which is the package price multiplied by the discount percentage. [1] 18 Enter a formula in cell B17 to subtract the discount amount from the package price. [1] 19 The user enters a code for the camera and a code for the housing. Enter a formula in cell A19 to display an appropriate error message if the camera code for the housing does not match the code for the camera entered by the user. [4] 20 Apply appropriate formatting to column B of the spreadsheet. [1] 21 Save your spreadsheet. Print your spreadsheet showing the formulae. Make sure the: • row and column headings are displayed • contents of all 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 the spreadsheet showing the formulae. 22 Print your spreadsheet showing the values. Make sure the: • printout fits on a single page • row and column headings are not displayed • contents of all 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 the spreadsheet showing the values.

9 0983/32/M/J/21 © UCLES 2021 23 Model this spreadsheet for a customer who wishes to buy camera C013 and use it with housing H025 Print your spreadsheet showing the values. Make sure the: • printout fits on a single page • row and column headings are not displayed • contents of all cells are fully visible and can be easily read. [2] PRINTOUT 4 Make sure that you have entered your name, centre number and candidate number on the spreadsheet showing the values. [Total: 34]

10 0983/32/M/J/21 © UCLES 2021 BLANK PAGE

11 0983/32/M/J/21 © UCLES 2021 BLANK PAGE

12 0983/32/M/J/21 © UCLES 2021 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 12 printed pages. © UCLES 2021 [Turn over Cambridge IGCSE™ (9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/32 Paper 3 Practical Test B May/June 2021 MARK SCHEME Maximum Mark: 80 Published This mark scheme is published as an aid to teachers and candidates, to indicate the requirements of the examination. It shows the basis on which Examiners were instructed to award marks. It does not indicate the details of the discussions that took place at an Examiners’ meeting before marking began, which would have considered the acceptability of alternative answers. Mark schemes should be read in conjunction with the question paper and the Principal Examiner Report for Teachers. Cambridge International will not enter into discussions about these mark schemes. Cambridge International is publishing the mark schemes for the May/June 2021 series for most Cambridge IGCSE™, Cambridge International A and AS Level components and some Cambridge O Level components.

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2021 © UCLES 2021 Page 2 of 12 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 2021 © UCLES 2021 Page 3 of 12 Screen shot folder name ump, file names, dimensions, file extensions, file sizes 1 mark diver_9999 diver image cropped to 1600 x 3000 1 mark diver_9999 in PNG format 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2021 © UCLES 2021 Page 4 of 12 Comment /* Candidate details at top */ 1 mark table margin-left:auto 1 mark margin-right:auto 1 mark body background-color: #6fead6 1 mark h1,h2 { } font-family: Domino Regular 1 mark ʺDomino Regularʺ in speech marks 1 mark , Domino 1 mark , serif 1 mark color: #000000 1 mark Both using single selector 1 mark h1 {…} text-align: center; 1 mark font-size: 24pt 1 mark h2 {…} text-align: justify 1 mark font-size: 16pt 1 mark CSS syntax Correct css syntax 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2021 © UCLES 2021 Page 5 of 12 In browser, address bar visible, no letters visible 1 mark No external table border visible 1 mark j2132banner.jpg visible 1 mark 4 correct images placed in correct cells, row 2 & 4 1 mark Diver image placed in right column … 1 mark … with correct crop left and right and all the diver visible 1 mark Aspect ratio of all images maintained 1 mark Sponge │ Nurdibranch │ 1 mark Anemone │ Mushroom eels │ 1 mark In h1 1 mark Text placed from source file 1 mark Displayed as 3 paragraphs 1 mark Web page last edited by: A Cand ZZ999 9999 1 mark All 4 paragraphs in style h2 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2021 © UCLES 2021 Page 6 of 12 <!DOCTYPE html> <html> <head> <link rel="stylesheet" type="text/css" href="j2132ump.css"> </head> <body> <table style="width:90%;"> <tr> <td colspan="3" style="height:15%;"> <img src="j2132banner.jpg" alt="Banner with the title for the webpage" style="width:100%;" /> </td> </tr> <tr> <td style="width:30%; height:20%;"> <img src="j2132ump1.jpg" alt="Image of a sponge" style="width:100%" /> </td> <td style="width:30%"> <img src="j2132ump2.jpg" alt="Image of a nurdibranch" style="width:100%" /> </td> <td style="width:40%" rowspan=4> <img src="diver_9999.png" alt="Image of scuba diver" style="width:100%" /> </td> </tr> <tr> <td style="height:10%;"> <h1>Sponge</h1> </td> <td> <h1>Nurdibranch</h1> </td> </tr> <tr> <td style="height:20%"> <img src="j2132ump3.jpg" alt="Image of anemone" style="width:100%" /> </td> <td> <img src="j2132ump4.jpg" alt="Image of mushroom eels in anemone" style="width:100%;" /> </td> </tr> <tr> <td style="height:10%;"> <h1>Anemone</h1> </td> Stylesheet j2132ump.css attached 1 mark Table Single table with width 90% 1 mark Row 1 height:15% 1 mark colspan=3 1 mark Row 2 height:20% 1 mark Rows 2 - 5 width:30% for both columns 1 mark Row 2 width 40% in last cell 1 mark rowspan=4 in last cell 1 mark Rows 3 & 5 height:10% 1 mark Row 4 height:20% 1 mark Images width of all images 100% 1 mark using inline style attributes 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2021 © UCLES 2021 Page 7 of 12 <td> <h1>Mushroom eels</h1> </td> </tr> <tr style="height:25%;"> <td colspan="3"> <h2>The term macro photography refers to taking pictures of small subjects at close range. When taking macro photographs underwater, we are usually getting pictures of small creatures that often go unnoticed by divers. These include some of the most beautiful and colourful creatures in our oceans. </h2> <h2>Macro photography forces divers to slow down and observe in much greater detail the endless photo opportunities that surround us while diving. It is not uncommon for discerning underwater macro photographers to confine an entire dive to a small piece of reef due to ample macro opportunities within close proximity to one another.</h2> <h2>All of the images shown here were taken using a compact digital camera with a 5x dioptre in Alinao, the Philippines.</h2> <h2>Web page last edited by: A Candidate ZZ999 9999</h2> </td> </tr> </table> </body> </html> Row 6 height:25% 1 mark colspan = 3 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2021 © UCLES 2021 Page 8 of 12 Header Prepared by: space Name & numbers 1 mark Right aligned 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2021 © UCLES 2021 Page 9 of 12 B5 =VLOOKUP(…) 1 mark B4 or $B$4 1 mark j2132camera.csv!$A$2:$B$24 1 mark ,2 1 mark ,FALSE 1 mark B6 =VLOOKUP(B4,j2132camera.csv!$A$2:$D$24,4,0) 1 mark B10 =VLOOKUP(B9,j2132housing.csv!$A$2:$C$31,3,0) 1 mark B11 =VLOOKUP(B9,j2132housing.csv!$A$2:$E$31,5,0) 1 mark B14 =B6+B11 1 mark B15 =IF(B14<E3,F3 …) 1 mark ,IF(B14<E4,F4 … ) 1 mark ,IF(B14<E5,F5 … ) 1 mark … ,F6) No extra tier unless error trapping 1 mark /100 1 mark B16 =B14*B15 1 mark B17 =B14-B16 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2021 © UCLES 2021 Page 10 of 12 A19 =IF(B4<> …) 1 mark VLOOKUP(B9,j2132housing.csv!$A$2:$B$31,2,0) 1 mark … appropriate error message 1 mark … ," " 1 mark Row & column headings displayed & A1:F19 fully visible 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2021 © UCLES 2021 Page 11 of 12 Row 1,3,8,13 Cells in A and B merged and centred 1 mark Row 1 36 point, black sans-serif font 1 mark Pale blue background 1 mark Vertically aligned middle 1 mark Rows 2,7,12 Half height of row 4 1 mark Rows 3,8,13 18 point, black sans-serif font, pale blue background 1 mark Alignment Column A right aligned 1 mark Formatting Appropriate formatting in column B 1 mark Values Single page, no row and column headings, cells A1:F19 fully visible 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2021 © UCLES 2021 Page 12 of 12 Modelling Camera C013 and housing H025 1 mark Price £1386.00, 10% discount & error message matches formulae printout 1 mark