Cambridge IGCSE Information and Communication Technology (9-1) 0983 — 2024 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 2024 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 [ ]. * 8 5 0 5 6 4 9 1 8 2 * DC (SL) 340892 © UCLES 2024

2 0983/32/M/J/24 © UCLES 2024 You have been supplied with the following source files: j32banner.jpg j32contact.jpg j32feed.mp4 j32giraffe.csv j32logo.png j32sightings.csv j32text.txt j32web.css j32what.htm j32what.jpg Giraffes are endangered species only found in parts of Africa. You will analyse data on giraffes that have been rescued, tagged and returned to the wild. 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 j32evidence_ followed by your centre number_candidate number, for example j32evidence_ZZ999_9999 You will use this as your Evidence Document during the examination.

3 0983/32/M/J/24 © UCLES 2024 [Turn over Task 2 – Spreadsheet 1 Open and examine the file j32giraffe.csv This file will be used in steps 2 and 3. Do not make any changes to this file. Open and examine the file j32sightings.csv Save the file j32sightings.csv as a spreadsheet with the filename Giraffe_ followed by your centre number_candidate number, for example Giraffe_ZZ999_9999 Rows 7 to 25 will show the number of sightings of the tagged giraffes in each country for one week in February. Rows 28 onwards show the details of all sightings for this week. Place your name, centre number and candidate number centre aligned in the header. Place the text Created on followed by a space, the automated date, a space, then the text at followed by a space, then the automated time in the footer. [3] 2 Place a replicable formula in cell D28 to look up the species, using the code and the external file j32giraffe.csv for the array. [6] 3 Place a replicable formula in cell F28 to look up the status, using the code and the external file j32giraffe.csv for the array. [1] 4 Replicate the formulae entered in steps 2 and 3 for all sightings. [1] 5 Place in cell B3 a formula to count the total number of sightings for this 7 day period. [2] 6 Place in cell B4 a formula to count the total number of sightings for this 7 day period where a photograph of a critically endangered species was taken. [5] 7 Insert a new row between rows 5 and 6. Place in cell A6 the text Critically endangered [2] 8 Place a replicable formula in cell B8 to display the number of sightings of a critically endangered species in this country. Replicate this formula for each country. [8]

4 0983/32/M/J/24 © UCLES 2024 9 Format the top of your spreadsheet so that it looks like this: Tagged giraffe sightings Critically endangered A B 70 12 2 0 0 Number of sightings Country Number of sightings in 7 day period Number of critically endangered sightings with photograph Botswana Burundi Cameroon 2 3 5 7 8 9 10 6 1 4 Make sure cells A1 to B1 and A6 to B6 are merged. Set the font size of the text in rows 1 and 6 to 20 points. Save your spreadsheet. [7] 10 Print your spreadsheet showing the formulae. Make sure that: • it is in landscape orientation • the row and column headings are displayed • all formulae are fully visible. [2] 11 Select rows 1 to 7 inclusive and only the rows between 8 and 26 where a sighting took place. Take a screenshot of the method used to select these rows (between 8 and 26). Place this screenshot in your Evidence Document. Print this selection showing the values. Make sure that: • the printout fits on a single page • the printout is in portrait orientation • the row and column headings are displayed • the contents of all the cells in the selected rows are fully visible. [4] [Total: 41]

5 0983/32/M/J/24 © UCLES 2024 [Turn over Task 3 – File management 12 Create a new folder called j32 Locate only the following files and store them in your j32 folder. j32banner.jpg j32contact.jpg j32feed.mp4 j32logo.png j32text.txt j32web.css j32what.htm j32what.jpg Display the contents of your j32 folder, showing the folder name, all file names, file extensions, file sizes, image dimensions and the frame height and frame width for the video. Take a screenshot of this folder, making sure that the required information is clearly visible. Place this screenshot in your Evidence Document. [1] [Total: 1]

6 0983/32/M/J/24 © UCLES 2024 Task 4 – Web page You will create a web page to help raise awareness of giraffe conservation. 13 Create a web page called j32web.htm and save this in your j32 folder. This web page must be created using a single table and work in all browsers. The table must fit 75% of the browser window and have a structure as shown in this diagram: A B C D E F Table borders must appear on the final web page. Each table cell is identified with a letter which must not appear on the final web page. [7] 14 Set the title of the web page to Giraffe conservation [1] 15 Place in cell: • A the image j32banner.jpg • B a video tag to display j32feed.mp4 so that it fits the width of this cell. This video must show the controls and play automatically when the web page opens. Display an automated text-based error message if the browser does not support this video type • C the image j32what.jpg • D the image j32contact.jpg [7] 16 Enter in cell E the text: Web page edited by: then on a new line enter your name, centre number and candidate number Set this text as style h3. [3]

7 0983/32/M/J/24 © UCLES 2024 17 Place in cell F the text from the file j32text.txt Set this text in paragraph style. [2] 18 Attach the stylesheet j32web.css to your web page. Do not edit this stylesheet. [1] 19 Make the image j32what.jpg a link to open the web page j32what.htm in a new window called _blank Make the image j32contact.jpg a link to an email editor to prepare an email to g.raffe@cambridge.org with the subject line Giraffe [6] 20 Save your web page. Take a copy of your HTML source and place this in your Evidence Document. 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 fully visible. Take screenshot evidence showing your web page in the browser. Place this in your Evidence Document. [1] [Total: 28] Task 5 – Printing the Evidence Document Make sure your name, centre number and candidate number appear on every page of your Evidence Document. Save your Evidence Document. Print your Evidence Document.

8 0983/32/M/J/24 © UCLES 2024 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 17 printed pages. © Cambridge University Press & Assessment 2024 [Turn over Cambridge IGCSE™ (9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/32 Paper 3 Spreadsheets and Website Authoring May/June 2024 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 2024 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 2024 © Cambridge University Press & Assessment 2024 Page 2 of 17 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 descriptions 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 2024 © Cambridge University Press & Assessment 2024 Page 3 of 17 Task 2 – Spreadsheet Question Answer Marks For Question 1 see below for example of spreadsheet. 1 3 Name, centre and candidate number centre aligned in header 1 Text Created on with space then with automated date in footer … 1 … with space, the text at another space and the automated time in the footer 1 For Question 2 see below for example of spreadsheet formulae. 2 6 =VLOOKUP ( … ) 1 … B29, … 1 … j32giraffe.csv! … 1 … $A$2:$C$12 … 1 … ,3 1 … ,0 1 For Question 3 see below for example of spreadsheet formulae. 3 =VLOOKUP(B29,j32giraffe.csv!$A$2:$F$12,6,0) 1 For Question 4 see below for example of spreadsheet formulae. 4 Cells D29 and F29 replicated to row 98 1 For Question 5 see below for example of spreadsheet formulae. 5 2 =COUNTA ( … ) 1 … A29:A98 1

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 4 of 17 Question Answer Marks For Question 6 see below for example of spreadsheet formulae. 6 5 =COUNTIFS ( … ) 1 … F29:F98 … 1 … ,"Critically endangered" 1 … ,G29:G98 … 1 … ,"Yes" 1 For Question 7 see below for example of spreadsheet. 7 2 New row 6 inserted … 1 … with text Critically endangered 1 For Question 8 see below for example of spreadsheet formulae. 8 8 =COUNTIFS ( … ) 1 … F29:F98 … 1 … as an absolute reference… 1 … ,"Critically endangered" 1 … ,E29:E98 1 … as an absolute reference 1 … ,A8 … 1 … as a relative reference 1

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 5 of 17 Question Answer Marks For Question 9 see below for example of spreadsheet. 9 7 Cells A1:B1 and A6:B6 merged 1 20-point black text 1 Cells A1:B10 sans-serif 1 Text in A1, A3, A4, B7 wrapped as shown 1 Rows 2 and 5 half height of row 10 1 A3:A4 & A8:A10 right aligned and B1:B10 centre aligned 1 Rows 1, 3, 4 and 7 centre aligned vertically 1 For Question 10 see below for example of formulae spreadsheet. 10 2 Formulae printout – Formulae in cells A1 to G98 fully visible 1 Formulae printout – Landscape orientation with row and column headings 1 For Question 11 see below for example of values spreadsheet and selection method. 11 4 Values printout – Rows 1 to 7 and selected rows from 8 to 26 fully visible 1 Values printout – filter used to remove countries with 0 1 Values printout – Portrait orientation, single page with row and column headings 1 Screen shot evidence of selection method 1 Total 41

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 6 of 17 Task 3 – File management Task Answer Marks For Question 12 see below for example of folder screen shot. 12 Screen shot includes folder name, image dimensions, video frame height and width, file names, file extensions and file sizes 1 For Question 13 see below for examples of html and browser view. 13 7 No letters visible 1 Table style="width:75%;" of browser window 1 Single table used 1 Table attribute border="1" 1 Row 1 – colspan="2" 1 Row 2 left – rowspan="3" 1 Row 5 – colspan="2" 1 For Question 14 see below for example of HTML. 14 Title accurate and in head section 1 For Question 15 see below for examples of html and browser view. 15 7 Banner image in top cell. 1 Video visible in row 2 left cell 1 video <…> tag used with … 1 … src="j32feed.mp4" … 1 … type="video/mp4"… 1 Appropriate error message between <video> and </video> tags 1 Set to autoplay 1

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 7 of 17 Task Answer Marks For Question 16 see below for example of HTML. 16 3 Row 4 right cell - Web page edited by: … 1 … with new line then name, centre number and candidate number … 1 … all text set in style h3 1 For Question 17 see below for example of HTML and browser view. 17 2 Bottom row – text from source file complete 1 … set in style p 1 For Question 18 see below for example of HTML. 18 Stylesheet j32web.css attached in head section 1 For Question 19 see below for example of HTML 19 6 Row 2 right cell - Anchor set around j32what.jpg 1 <a href="j32what.htm" … 1 … target="_blank"> 1 Row 3 right cell - Anchor set around j32contact.jpg 1 <a href="mailto:g.raffe@cambridge.org … 1 … ?subject=Giraffe"> 1 For Question 20 see below for example of browser view. 20 In browser, address visible 1 Total 28

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 8 of 17 B3 =COUNTA ( … ) 1 mark … A29:A98 1 mark B4 =COUNTIFS ( … ) 1 mark … F29:F98 1 mark … ,"Critically endangered" 1 mark … ,G29:G98 1 mark … , "Yes" 1 mark B8 =COUNTIFS ( … ) 1 mark … F29:F98 1 mark … as an absolute reference 1 mark … ,"Critically endangered" 1 mark … ,E29:E98 1 mark … as an absolute reference 1 mark … ,A8 1 mark … as a relative reference 1 mark Header Name, centre & candidate no - centre aligned 1 mark Footer Created on <automated date> ... 1 mark ... at <automated time> 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 9 of 17 D29 =VLOOKUP ( … ) 1 mark … B29, … 1 mark … j32giraffe.csv! … 1 mark … $A$2:$C$12 … 1 mark … ,3 1 mark … ,0 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 10 of 17 F29 =VLOOKUP(B29,j32giraffe.csv!$A$2:$F$12,6,0) 1 mark D29 & F29 Replicated to row 98 1 mark Printout Formulae with cells A1 to G98 fully visible 1 mark Landscape orientation with row and column headings 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 11 of 17

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 12 of 17

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 13 of 17 Row 6 New row inserted 1 mark Critically endangered 1 mark Cells A1:B1 and A6:B6 merged 1 mark Row 1 & 6 20-point black text 1 mark Rows 1-10 Cells A1:B10 sans-serif 1 mark Text in A1, A3, A4, B7 wrapped as shown 1 mark Rows 2 and 5 half height of row 10 1 mark A3:A4 & A8:A10 right aligned & B1:B10 centre aligned 1 mark Rows 1, 3, 4 & 7 centre aligned vertically 1 mark Printout Only rows 1 to 7 and selected rows from 8 to 26 fully visible 1 mark Filter used to remove countries with 0 1 mark Portrait, single page with row and column headings 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 14 of 17 Evidence Document Filter Evidence of selection method 1 mark Screenshot includes folder name, image dimensions, video frame height and width, file names, file extensions & file sizes 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 15 of 17 <!DOCTYPE html> <html> <head> <title>Giraffe conservation</title> <link rel="stylesheet" type="text/css" href="j32web.css"> </head> <body> <table style="width:75%;" border="1"> <tr> <td colspan="2"> <img src="j32banner.jpg" alt="banner for giraffe conservation" style="width:100%" > </td> </tr> <tr> <td rowspan="3"> <video controls autoplay muted > <source src="j32feed.mp4" type="video/mp4"> Your browser does not support this video format </video> </td> <td> <a href="j32what.htm" target="_blank"><img src="j32what.jpg"></a> </td> </tr> <tr> <td> <a href="mailto:g.raffe@cambridge.org?subject=Giraffe"><img src="j32contact.jpg"></a> </td> </tr> <tr> <td> Table style="width:75%;" 1 mark single table used 1 mark Head section title Giraffe conservation 1 mark j32web.css attached 1 mark Row 3 right Anchor set around j32contact.jpg 1 mark <a href="mailto:g.raffe@cambridge.org … 1 mark … ?subject=Giraffe"> 1 mark Row 1 colspan="2" 1 mark Row 2 left rowspan="3" 1 mark Video video <…> tag used with… 1 mark … src="j32feed.mp4" … 1 mark … type="video/mp4" 1 mark Appropriate error message between <video> tags 1 mark Set to autoplay 1 mark Row 2 right Anchor set around j32what.jpg 1 mark <a href="j32what.htm" … 1 mark … target="_blank"> 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 16 of 17 <h3>Web page edited by:</h3> <h3>A Candidate ZZ999 9999</h3> </td> </tr> <tr> <td colspan="2"> <p>With an estimated world population of 111000 giraffes many people do not see these creatures as endangered. There are four distinct species of giraffe with several sub-species. The species are the Masai giraffe, Northern giraffe, Reticulated giraffe and Southern giraffe. The Luangwa giraffe (sometimes called the Thornicroft's giraffe) have an estimated population of only 650 and are critically endangered as are the West African giraffe with an estimated population of 600. This is one of three sub-species of Northern giraffe, with each being classified as endangered or critically endangered. There are fewer than 3000 Northern giraffes remaining. We have arranged a programme to rescue injured or orphaned giraffes, feed them and provide them with medical care until they can be safely released back into the wild with others of the same sub-species. Please support us in our work.</p> </td> </tr> </table> </body> </html> Row 5 colspan="2" 1 mark Row 4 right All text set in h3 1 mark

0983/32 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 17 of 17 Browser In browser, address visible 1 mark Borders visible 1 mark No letters visible 1 mark Row 1 Banner 1 mark Row 2 left Video visible 1 mark Row 4 right Web page edited by: 1 mark New line then name and numbers 1 mark Row 5 text from source file complete 1 mark … set in style p 1 mark