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

This document has 8 pages. Any blank pages are indicated. [Turn over Cambridge IGCSE™(9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/32 Paper 3 Spreadsheets and Website Authoring May/June 2023 2 hours 15 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 70. ● The number of marks for each question or part question is shown in brackets [ ]. * 2 1 7 5 4 3 4 7 6 3 * DC (KS) 326425/1 © UCLES 2023

2 0983/32/M/J/23 © UCLES 2023 You have been supplied with the following source files: j2332banner.jpg j2332elep.htm j2332eleph1.jpg j2332elephant.jpg j2332monkey.jpg j2332project.csv j2332tas.css j2332tas.txt j2332tiger.jpg j2332tiger.mp4 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 document in your work area as j2332evidence_ followed by your centre number_candidate number, for example, j2332evidence_ZZ999_9999 You will use this as your Evidence Document during the examination.

3 0983/32/M/J/23 © UCLES 2023 [Turn over Task 2 – Image Editing and File Management 1 Create a new folder called TAS Locate the following files and store them in your TAS folder. j2332banner.jpg j2332elep.htm j2332eleph1.jpg j2332elephant.jpg j2332monkey.jpg j2332tas.css j2332tas.txt j2332tiger.jpg j2332tiger.mp4 Open the file j2332tiger.jpg in a graphics package. Edit the image by: • rotating it 180 degrees • reflecting (flipping) it horizontally so the tyre is on the left • cropping it to remove most of the tyre but none of the tiger • cropping it to remove everything above the tiger’s ears • resizing it so that the image is 1000 pixels high but without changing the aspect ratio • cropping it to remove the right side so that the image is 500 pixels wide by 1000 pixels high. Save this new image in your TAS folder in .png format, using the file name tiger_ followed by your candidate number, for example, tiger_9999 Display the contents of your TAS folder, showing the folder name, all file names, file extensions, image dimensions and file sizes. Take a screenshot of this folder and place this in your Evidence Document. [8] [Total: 8]

4 0983/32/M/J/23 © UCLES 2023 Task 3 – Web Page You are going to create a web page and stylesheet to promote the Tawara Animal Sanctuary. The web page and stylesheet must work in any browser. All colour codes are in hexadecimal and any new colour codes must also be in hexadecimal. Make sure that your stylesheet contains no HTML. Make your HTML and stylesheet as efficient as possible. 2 Create in your TAS folder a web page called tas.htm This web page must be created using a single table and work in all browsers. The table must fit 80% of the browser window. The table must have a structure as shown in this diagram: A D E width = 29% F width = 29% B width = 58% C width = 42% Each table cell is identified with a letter. Some dimensions are shown. The cell contents shown in the diagram must not appear on your final web page. Table borders must not appear on your final web page. [10]

5 0983/32/M/J/23 © UCLES 2023 [Turn over 3 Use video and source tags to place in cell B the video file j2332tiger.mp4 The video must fit the width of the cell. Display an appropriate text‑based error message if the browser does not support this video type. Place in cell: • A the image j2332banner.jpg • C the image tiger that you saved in Step 1 • E the image j2332monkey.jpg • F the image j2332elephant.jpg Make sure the aspect ratio is maintained for all images. Set appropriate alternate text for each still image. [11] 4 Place in cell D the contents of the file j2332tas.txt Display this text as two paragraphs. Add, as a third paragraph, the text: Web page edited by: followed by your name, centre number and candidate number Apply style h2 to all text in cell D. [3] 5 Create a hyperlink from the image j2332elephant.jpg to open the web page j2332elep.htm [2] 6 Create a hyperlink from the image j2332monkey.jpg to send an email message to tas@cambridge.org with a subject line Support a monkey [5] 7 Attach the stylesheet j2332tas.css to this web page. Save your web page. Display the web page in your browser. Take screenshot evidence and place this in your Evidence Document. Make sure that: • all the page can be seen • all the text can be easily read • the address bar is fully visible. Display the HTML source in your editor. Take a copy of the HTML source and place this in your Evidence Document. [2] [Total: 33]

6 0983/32/M/J/23 © UCLES 2023 Task 4 – Spreadsheets The Tawara Animal Sanctuary is currently running three projects: Elephant, Monkey and Tiger. Income is from donations and for each project they record the amount spent on food, veterinary bills and relocating the animals back into the wild. You will edit a spreadsheet for this data. All currency values must be in dollars ($), displayed to 2 decimal places. 8 Open and examine the file j2332project.csv in your spreadsheet software. Copy and paste the contents of cell A4 into cell B5. Delete rows 3 and 4. Place in the header, centre aligned, the text Spreadsheet prepared by followed by a space, your name, centre number and candidate number, then a space followed by on followed by a space and today’s automated date, then a space followed by at followed by a space and the automated time. Save your spreadsheet with the file name project_centre number_candidate number, for example, project_ZZ999_9999 [6] 9 Merge cells A1:N1, A9:A12, A13:A16 and A17:A20. Format the merged cell A1:N1 to have a solid black background. Format the spreadsheet to look like this. A Project January February March April May June July August September October November December Month Income Elephant Monkey Monkey Tiger Tiger Elephant Elephant Total Food Veterinary Relocation 3480.38 2061.45 1487.65 1134.94 1893.74 4718.89 2469.32 3595.88 2629.31 844.56 3050.36 646.21 2731.27 327.27 36 2565.61 4586.43 3239.28 1604.3 2295.06 357.86 694.47 4028.66 803.92 240.2 39.66 3421.02 1846.3 754.21 2952.38 2716.18 4118.3 913.83 2815.71 629.55 186.53 20.33 2813.99 174.66 2678.66 2190.97 2048.94 542.2 381.8 38.87 1323.71 1727.69 4319.77 Monkey Total Food Veterinary Relocation Tiger Total Food Veterinary Relocation 1 2 3 4 5 7 B C D E F G H I J K L M N 6 8 9 10 11 12 13 14 15 16 17 18 19 21 20 22 23 24 25 2159.94 6447.05 6541.33 5889.93 6281.2 8244.76 8249.47 455.33 831.69 1306.57 365.61 685.38 7.67 1603.44 139.1 2764.51 1308.39 2872.11 4239.04 123.29 534.26 34.32 283.5 6400.24 8514.5 3126.84 4808.71 421.84 1675.18 2438.75 2096.41 2874.79 542.01 698.75 309.2 35.45 3778.31 3373.79 1611.76 3604.78 472.59 1018.73 8812.25 2719.38 3052.32 4420.34 523.59 2964.81 1850.41 1051.52 188.59 21.86 3501.97 1525.76 2007.2 866.48 2375.29 26.2 1310.9 299.61 17.97 3200.7 33.8 2089.17 8690.99 3260.53 3886.05 2479.65 4056.3 6828.12 3579.62 934.38 1149.43 251.3 485.6 284.51 57.47 1893.51 3335.82 1463.75 340.58 753.83 854.12 210.9 24.15 3338.51 5897.85 2973.13 1753.4 280.63 681.08 351.5 18.63 2387.33 3094.14 3085.12 Tawara Animal Sanctuary income and expenditure Project Expenditure Project Balance [7] 10 Place in appropriate cells functions to calculate the total expenditure for each project for each month. [3] 11 Place in cell C23 a formula to calculate the balance for the Elephant project in January. This is the income for this project for this month minus the total expenditure for this project for this month. Calculate, in cells C24 and C25, the balances for the other two projects. Replicate these three formulae for all other months. [4]

7 0983/32/M/J/23 © UCLES 2023 12 Apply appropriate formatting to all cells containing numeric data. [1] 13 Apply conditional formatting to only the cells in the range C23 to N25 so that if a cell contains a value: • greater than or equal to zero, the cell has a light‑green background with dark‑blue text • less than zero, the cell has red text on a white background. Place in your Evidence Document a screenshot showing the conditional formatting rules, cell ranges and formats. [6] 14 Save your spreadsheet. Print your spreadsheet showing the formulae. Make sure: • the row and column headings are displayed • the page orientation is landscape • the contents of all cells are fully visible and can be easily read. [1] 15 Print your spreadsheet showing the values. Make sure: • the printout fits on a single landscape page • the row and column headings are not displayed • the contents of all cells are fully visible and can be easily read. [1] [Total: 29] Task 5 – Printing the Evidence Document Make sure your name, centre number and candidate number appear on every page of your Evidence Document. Save and print your Evidence Document.

8 0983/32/M/J/23 © UCLES 2023 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 Cambridge Assessment. Cambridge Assessment is the brand name of the University of Cambridge Local Examinations Syndicate (UCLES), which is a department of the University of Cambridge. BLANK PAGE

This document consists of 10 printed pages. © UCLES 2023 [Turn over Cambridge IGCSE™ (9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/32 Paper 3 Spreadsheets and Website Authoring May/June 2023 MARK SCHEME Maximum Mark: 70 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 2023 series for most Cambridge IGCSE, Cambridge International A and AS Level and Cambridge Pre-U components, and some Cambridge O Level components.

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 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 2023 © UCLES 2023 Page 3 of 10 Question Answer Marks 1 TAS folder S/shot: filenames, sizes, extensions, dimensions tiger_9999 Cropped to 500  1000 tiger_9999 in PNG format Tiger image rotated through 180⁰ horizontal reflection with all tiger visible after left and top crops foliage visible on right after right crop aspect ratio maintained 8 2 Browser view In browser with no letters visible Table No borders/gridlines visible width=80% Row 1 colspan=3 Row 2 left width: 58% colspan="2" Row 2 right rowspan=”3” width:42% Row 3 colspan=”2” Row 4 left 2 width:29% 10 3 Row 2 left Video visible in correct cell Row 2 right Tiger image Banner & 2 lower images in correct cells Banner & 2 lower images aspect ratio maintained Appropriate alt text for all 4 still images Video video <…> tag used … … width="100%” Source<…> tag used … … src="j2332tiger.mp4" type="video/mp4" Appropriate error message 11 4 Row 3 Text from source file as 2 paragraphs 3rd para Web page edited by: A Cand ZZ999 9999 In style h2 3 5 Hyperlink Anchor around elephant image href="j2332elep.htm" 2 6 Hyperlink Anchor around monkey image href=“mailto: tas@cambridge.org ?subject= Support a monkey 5 7 Browser view Address bar visible Stylesheet j2332tas.css attached 2 8 Header Spreadsheet prepared by … in centre Candidate details then on automated date then at automated time Rows 3 & 4 deleted B3 Contains text Income 6

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 4 of 10 Question Answer Marks 9 A1:N1 Merged and centre aligned … … Large white sans-serif font black background Merged A9:A12, A13:A16 and A17:A20 Rows 7, 21 Less than 1/2 height of row 3 Grey Correct 7 cells with grey background Bold Rows 2,3,8,22 and column A Centre Row 2 and columns A and B 7 10 C12 =SUM(C9:C11) … … replicated to N12 C16 & 20 Correct formulae replicated to column N 3 11 C23 =C4-C12 C24 =C5-C16 C25 =C6-C20 C23:C25 Replication correct 4 12 Numeric data in $ with 2dp 1 13 Rules Both applied to cells C23:N25 Cell value >=0 … … dark blue text … … on light green background Cell value <0 … … red text on white background 6 14 Printout Landscape, row & column heads fully visible 1 15 All Fully visible with no row & column headings 1

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 5 of 10 Evidence document Evidence 1 TAS folder S/shot: filenames, sizes, extensions, dimensions 1 mark tiger_9999 Cropped to 500  1000 1 mark tiger_9999 in PNG format 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 6 of 10 Evidence 2 In browser with no letters vis 1 mark address bar visible 1 mark Table No borders/gridlines visible 1 mark Row 2 left Video visible in correct cell 1 mark Tiger image Placed in row 2 right column 1 mark Rotated through 180⁰ 1 mark Horizontal reflection 1 mark With all tiger visible after left and top crops 1 mark Foliage visible on right of head after right crop 1 mark Aspect ratio maintained 1 mark Row 3 Text from source file as 2 paragraphs 1 mark 3rd para Web page edited by: A Cand ZZ999 9999 1 mark Banner & 2 lower images In correct cells 1 mark With aspect ratio maintained 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 7 of 10 Evidence 3 <!DOCTYPE html> <html> <head> <link rel="stylesheet" type="text/css" href="j2332tas.css"> </head> <body> <table style="width:80%;"> <tr> <td colspan="3"> <img src="j2332banner.jpg" alt="Banner with images of elephants"> </td> </tr> <tr> <td colspan= "2" style="width:58%;"> <video width="100%" autoplay loop> <source src="j2332tiger.mp4" type="video/mp4"> Your browser does not support this video file type. </video> </td> <td rowspan="3" style="width:42%;"> <img src="tiger_9999.png" alt="Image of tiger"/> </td> </tr> <tr> <td colspan="2"> <h2>Help us to support animals who have been injured or have lost their natural habitat. We always care for these animals and, where possible, return them back to the wild.</h2> <h2>Click on the images below to find out more about the elephants or to contact us about supporting the monkeys.</h2> <h2>Web page edited by: A Candidate, ZZ999, 9999</h2> </td> </tr> <tr> <td style="width:29%;"> <a href="mailto:tas@cambridge.org?subject=Support%20a%20monkey"> <img src="j2332monkey.jpg" alt="Image of monkeys"/> </a> </td> <td style="width:29%;"> Stylesheet j2332tas.css attached 1 mark Row 2 left colspan=2 1 mark width: 58% 1 mark Table width=80% 1 mark Row 1 colspan=3 1 mark Row 2 right rowspan=3 1 mark width:42% 1 mark Row 4 left width:29% 1 mark Row 3 colspan=2 1 mark Hyperlink Anchor around monkey image 1 mark href="mailto: … 1 mark … tas@cambridge.org... 1 mark … ?subject=… 1 mark … Support a monkey" 1 mark Row 2 left video <…> tag used … 1 mark … width="100%” 1 mark source<…> tag used … 1 mark … src="j2332tiger.mp4" 1 mark type="video/mp4" 1 mark Appropriate error message 1 mark Row 3 In style h2 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 8 of 10 <a href="j2332elep.htm"><img src="j2332elephant.jpg" alt="Image of elephant taking a bath"/></a> </td </tr> </table> </body> </html> Evidence 4 Rules Both applied to cells C23:N25 1 mark Cell value >=0 … 1 mark … dark blue text … 1 mark … on light green background 1 mark Cell value <0 … 1 mark … red text on white background 1 mark Hyperlink Anchor around elephant image 1 mark href="j2332elep.htm" 1 mark Images Appropriate alt text for all 4 still images 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 9 of 10 Values Header Centre aligned Spreadsheet prepared by [space] 1 mark Candidate details [space] on [space] 1 mark automated date [space] at [space] 1 mark automated time 1 mark Rows 3 & 4 deleted 1 mark B3 Contains only the text Income 1 mark A1:N1 Merged and centre aligned … 1 mark … large white sans-serif font on black background 1 mark Merged A9:A12, A13:A16 and A17:A20 1 mark Rows 7, 21 < 1/2 height of row 3 1 mark Grey Correct 7 cells with grey background 1 mark Bold Rows 2, 3, 8, 22 and column A 1 mark Centre Row 2 and columns A & B horizontally and 3 merged cells vertically 1 mark All Numeric data in $ with 2dp 1 mark Fully visible with no row & column headings 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 10 of 10 Formulae C12 =SUM(C9:C11) 1 mark Replicated to N12 1 mark C16 & 20 Correct formulae replicated to column N 1 mark C23 =C4-C12 1 mark C24 =C5-C16 1 mark C25 =C6-C20 1 mark C23:C25 Replication correct to column N 1 mark Printout Landscape row & col heads fully visible 1 mark