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

This document has 8 pages. Any blank pages are indicated. [Turn over DC (SL) 340897 © UCLES 2024 * 6 5 0 6 8 3 6 1 7 4 * Cambridge IGCSE™(9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/31 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 [ ].

2 0983/31/M/J/24 © UCLES 2024 You have been supplied with the following source files: j2431contact.jpg j2431divers.csv j2431location.jpg j2431logo.png j2431splendid.csv j2431splendid.jpg j2431style.css j2431text.txt You will assist some marine biologists in analysing data on, and raising awareness of, the splendid toadfish. This is an endangered species only found in the reefs of Cozumel, Mexico. 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 j2431evidence_ followed by your centre number_candidate number, for example j2431evidence_ZZ999_9999 You will use this as your Evidence Document during the examination. Task 2 – Spreadsheet 1 Open and examine the file j2431divers.csv This file will be used in Step 2. Do not make any changes to this file. Open and examine the file j2431splendid.csv in a spreadsheet. Rows 9 to 32 will show the number of sightings of the splendid toadfish on each reef for one week in February. Rows 35 onwards show the details of all sightings for this week. Place your name, centre number and candidate number left-aligned in the footer. Place the automated file name with no file path on the right in the footer. Save this as a spreadsheet with the filename Splendid_ followed by your centre number_ candidate number, for example Splendid_ZZ999_9999 [2] 2 Place a replicable formula in cell C35 to look up the type of diver, using their name and the external file j2431divers.csv for the array. Replicate this formula for all divers. [7] 3 Place in cell B3 a formula to count the total number of sightings for a 7 day period. [2]

3 0983/31/M/J/24 © UCLES 2024 [Turn over 4 Place in cell B4 a formula to count the total number of sightings for a 7 day period where a photograph was taken. [3] 5 Place in cell B5 a formula to count the total number of sightings for a 7 day period where a photograph was taken that held the GPS location of the fish. [3] 6 Place a replicable formula in cell B9 to display the number of sightings at this reef where a photograph with GPS was taken. Replicate this formula for each reef. [7] 7 Format the top of your spreadsheet so that it looks like this: Splendid toadfish sightings A B 41 34 30 Number of sightings 1 0 Number of sightings in 7 day period Number of sightings with photograph Number of sightings with photo and GPS Location with photo and GPS Reef name Maracaibo Chun Chacaab 1 2 3 4 6 7 8 9 10 5 Make sure cells A1 to B1 and B7 to B8 are merged. Set the font size of the text in row 1 to 22 points. Save your spreadsheet. [5] 8 Select only cells A1 to C75 and print these cells with the formulae displayed. Make sure: • the printout is in landscape orientation • the row and column headings are displayed • the contents of these cells are fully visible. [2]

4 0983/31/M/J/24 © UCLES 2024 9 Select rows 1 to 8 inclusive and only the rows between 9 and 32 where a sighting took place. Take a screenshot of the method used to select these rows (between 9 and 32). Place this screenshot in your Evidence Document. Print this selection showing the values. Make sure: • 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: 35] Task 3 – File management 10 Create a new folder called j2431 Locate only the following files and store them in your j2431 folder. j2431contact.jpg j2431location.jpg j2431logo.png j2431splendid.jpg j2431style.css j2431text.txt Display the contents of your j2431 folder, showing the folder name, all file names, file extensions, file sizes and image dimensions. 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]

5 0983/31/M/J/24 © UCLES 2024 [Turn over Task 4 – Web Page 11 Create a web page called splendid.htm and save this in your j2431 folder. This web page must be created using a single table and work in all browsers. The table must fit 85% of the browser window and have a structure as shown in this diagram: C D F E G B width = 60% A height = 20% Each table cell is identified with a letter. The cell contents shown in the diagram must not appear on the final web page. Table borders must not appear on the final web page. [8] 12 Set the title of the web page to Splendid toadfish [1] 13 Enter in cell A the text Conserve our endangered species Enter in cell C the text Splendid toadfish Set the text in cells A and C as style h1. [3] 14 Enter in cell G the text: Created by: followed by your name, centre number and candidate number. Set this text as style h2. [2]

6 0983/31/M/J/24 © UCLES 2024 15 Place in cell: • B the image j2431splendid.jpg • D the image j2431contact.jpg • F the image j2431location.jpg [1] 16 Add appropriate alternate text to all images. [1] 17 Place in cell E the text from the file j2431text.txt Set each of these three paragraphs into paragraph style. [2] 18 Attach the stylesheet j2431style.css to your web page. Do not edit this stylesheet. [1] 19 Create a new stylesheet so that: • the file j2431logo.png is placed as a single background image in the top-left corner of the window • the table is right-aligned within the browser window • h1, h2 and the paragraph style use the: – font Times – font Times New Roman if Times is not available – browser’s default serif font if neither of these fonts is available • h1, h2 and the paragraph style are bold • the paragraph style is fully justified • your name, centre number and candidate number are set as a comment at the top of the stylesheet. Make sure that your stylesheet contains no HTML or scripting language and is as efficient as possible. Save this stylesheet, in your j2431 folder, in cascading stylesheet format as j2431css2_ followed by your centre number_candidate number, for example j2431css2_ZZ999_9999 Attach this stylesheet to your web page so that it has higher priority than the one attached in Step 18. Take a screenshot of your stylesheet and place this in your Evidence Document. Make sure the file name and all contents are clearly visible. [14]

7 0983/31/M/J/24 © UCLES 2024 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: 34] 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/31/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 15 printed pages. © Cambridge University Press & Assessment 2024 [Turn over Cambridge IGCSE™ (9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/31 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/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 2 of 15 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/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 3 of 15 Task 2 – Spreadsheet Question Answer Marks For Question 1 see below for example of spreadsheet. 1 2 Name, centre and candidate number left aligned in footer 1 File name with no file path on the right in the footer 1 For Question 2 see below for example of spreadsheet formulae. 2 7 =VLOOKUP ( … ) 1 … B35, … 1 … j2431divers.csv! … 1 … $A$2:$C$51 … 1 … ,3 1 … ,0 1 Replicated to row 75. 1 For Question 3 see below for example of spreadsheet formulae. 3 2 =COUNTA ( … ) 1 … B35:B75 1 For Question 4 see below for example of spreadsheet formulae. 4 3 =COUNTIF ( … ) 1 … E35:E75 … 1 … ,"Yes") 1 For Question 5 see below for example of spreadsheet formulae. 5 3 =COUNTIFS ( … ) 1 … E35:E75,"Yes" … 1 … , F35:F75,"Yes") 1

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 4 of 15 Question Answer Marks For Question 6 see below for example of spreadsheet formulae. 6 7 =COUNTIFS ( … ) 1 … D35:D75 … 1 … as an absolute reference… 1 … ,A9 … 1 … as a relative reference … 1 … ,$E$35:$E$75,"Yes" … 1 … ,$F$35:$F$75,"Yes" … 1 For Question 7 see below for example of spreadsheet. 7 5 Cells A1:C1 and B7:B8 merged 1 Row 1 – 22-point black 1 Rows 1 to 10 sans-serif 1 Text in B7:B8 wrapped as shown 1 A3:A5 & A9:A10 right aligned, B1:B10 centre aligned 1 For Question 8 see below for example of formulae spreadsheet. 8 2 Formulae printout – Only cells A1 to C75 fully visible 1 Formulae printout – Landscape orientation with row and column headings 1 For Question 9 see below for example of values spreadsheet and selection method. 9 4 Values printout – Rows 1 to 8 and selected rows from 9 to 32 fully visible 1 Values printout – filter used to remove reefs with 0 1 Values printout – Portrait orientation with row and column headings 1 Screen shot evidence of selection method 1 Total 35

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 5 of 15 Task 3 – File management Question Answer Marks For Queston 10 see below for example of folder screen shot. 10 Screen shot includes folder name, file names, file sizes, image dimensions, file extensions/type 1 Total 1 Task 4 – Web Page Question Answer Marks For Question 11 see below for examples of html and browser view. 11 8 No letters or dimensions visible 1 Table style="width:85%;" of browser window 1 Single table used 1 Borders not visible 1 Row 1 – colspan="2" 1 Row 1 – style="height:20%;" 1 Row 2 & row 4 left – rowspan="2" 1 Row 2 / row 4 left – style="width:60%;" 1 For Question 12 see below for example of HTML. 12 Title accurate and in head section 1 For Question 13 see below for example of HTML. 13 3 Top row – Conserve our endangered species 1 Row 2 right cell – Splendid toadfish 1 … both set in style h1 1

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 6 of 15 Question Answer Marks For Question 14 see below for example of HTML. 14 2 Row 5 right cell – Created by: followed by name, centre number and candidate number 1 … all set in style h2 1 For Question 15 see below for example of browser view. 15 Row 2 left – the image j2431splendid.jpg Row 3 right – the image j2431contact.jpg Row 4 right – the image j2431location.jpg 1 For Question 16 see below for example of HTML. 16 Appropriate alternate text to all 3 still images 1 For Question 17 see below for example of HTML and browser view. 17 2 Bottom left cell – text from source file 100% accurate … 1 … in 3 paragraphs set in style p 1 For Question 18 see below for example of HTML. 18 Stylesheet j2431style.css attached in head section 1

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 7 of 15 Question Answer Marks For Question 19 see below for example of CSS. 19 14 Correct file name and type 1 Comments /* A Candidate zz999 9999 */ at top of stylesheet 1 Body {} with background-image: url("j2431logo.png"); 1 Body {} with background-repeat: no-repeat; 1 Body {} with background-position: top left; 1 Table {} with margin-right:0; 1 Table {} with margin-left:auto; 1 h1, h2 and p {} font-family: Times … 1 … , "Times New Roman” in speech marks … 1 … , serif 1 h1, h2 and p {} font-weight: bold; 1 h1, h2 and p elements in a single selector 1 p {text-align: justify; } 1 Stylesheet j2431css2_ZZ999_9999.css attached below j2431style.css 1 For Question 20 see below for example of browser view. 20 In browser, address visible 1 Total 34

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 8 of 15 C35 =VLOOKUP ( … ) 1 mark … B35, … 1 mark … j2431divers.csv! … 1 mark … $A$2:$C$51 … 1 mark … ,3 1 mark … ,0 1 mark Replicated to row 75 1 mark Formulae Only cells A1 to C75 fully visible 1 mark Landscape with row & column headings 1 mark B3 =COUNTA ( … ) 1 mark … B35:B75 1 mark B4 =COUNTIF ( … ) 1 mark … E35:E75 1 mark … , "Yes" 1 mark B5 =COUNTIFS ( … ) 1 mark … E35:E75,"Yes" … 1 mark … F35:F75,"Yes" 1 mark B9 =COUNTIFS ( … ) 1 mark … D35:D75 … 1 mark … as an absolute reference 1 mark … ,A9 … 1 mark … as a relative reference 1 mark … $E$35:$E$75,"Yes" … 1 mark … $F$35:$F$75,"Yes" … 1 mark Footer Name, centre, candidate no left aligned 1 mark File name with no file path on the right 1 mark

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

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 10 of 15 Cells A1:B1 and B7:B8 merged 1 mark Row 1 – 22-point black 1 mark Rows 1 to 10 sans-serif 1 mark Text in B7:B8 wrapped as shown 1 mark A3:A5 & A9:A10 right and B1:B10 centre aligned 1 mark Printout Rows 1 to 8 and selected rows from 9 to 32 fully visible 1 mark Filter used to remove reefs with 0 1 mark Portrait, single page with row and column headings 1 mark

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 11 of 15 Evidence Document Filter Evidence of selection method 1 mark Screen shot includes folder name, file names, file sizes, image dimensions, file extensions/type 1 mark

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 12 of 15 Stylesheet j2431css2_zz999_9999.css Correct file name & type 1 mark Comments /* Candidate details */ at start 1 mark body { background-image: url("j2431logo.png"); 1 mark background-repeat: no-repeat; 1 mark background-position: top left; } 1 mark table { margin-right: 0; 1 mark margin-left: auto } 1 mark h1,h2,p { font-family: Times … 1 mark … ,"Times New Roman" in speech marks … 1 mark … , serif; 1 mark font-weight: bold; } 1 mark h1, h2, p h1,h2 and p included in a single selector 1 mark p { text-align: justify; } 1 mark

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 13 of 15 <!DOCTYPE html> <html> <head> <title>Splendid toadfish</title> <link rel="stylesheet" type="text/css" href="j2431style.css"> <link rel="stylesheet" type="text/css" href="j2431css2_ZZ999_9999.css"> </head> <body> <table style="width:85%;" border="0"> <tr> <td colspan="2" style="height:20%;"> <h1>Conserve our endangered species</h1> </td> </tr> <tr> <td rowspan="2" style="width:60%;"> <img src="j2431splendid.jpg" alt="Image of splendid toadfish" width="100%"> </td> <td style="height:20%;"> <h1>Splendid toadfish</h1> </td> </tr> <tr> <td style="height:20%"> <img src="j2431contact.jpg" alt="Contact us button"> </td> </tr> <tr> <td rowspan="2" style="width:60%;"> <p>The splendid toadfish is sometimes called the coral toadfish. Its Latin name is Sanopus splendidus and it is primarily found in the waters around the island of Cozumel in Mexico. In recent years some have been spotted in Belize and on the mainland coast of the Yucatan near Cancun. Whether these isolated viewings are due to natural influences or the influence of man is unknown. These are very difficult to spot as their dens tend to be below small coral outcrops, usually with a sand patch in the lee of the predominantly South to North current. They are rarely seen during the day outside their den.</p> <p>Like all toadfish it has a flat, broad head and barbells. Its eyes are located on the top of its head and it has small sharp teeth. It is a predator eating smaller fish and crustaceans. Unlike other toadfish it has vibrant colours which range from blue-grey to purple, with black, blue or grey stripes. Its fins are rimmed with bands of bright yellow.</p> <p>Although this species is not critically endangered it is listed as being extremely vulnerable and is often very difficult to locate.</p> </td> <td style="height:20%;"> <img src="j2431location.jpg" alt="Location button"> </td> </tr> <tr> Title accurate and in head section 1 mark j2431style.css attached in head section 1 mark j2431css2_ZZ999_9999.css below j2431style 1 mark Table style="width:85%;" 1 mark Single table used 1 mark Row 1 colspan="2" 1 mark style="height:20%;" 1 mark Row 2 & 4 rowspan="2" 1 mark style="width:60%;" 1 mark Appropriate alternate text to all 3 still images 1 mark

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 14 of 15 <td style="height:20%"> <h2>Created by: A Candidate ZZ999 9999</h2> </td> </tr> </table> </body> </html>

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 15 of 15 Browser In browser, address visible 1 mark Borders not visible 1 mark No letters or dimensions visible 1 mark Row 1 Conserve our endangered species 1 mark Row 2 Splendid toadfish 1 mark Both set into style h1 1 mark Images All 3 in correct cells 1 mark Bottom left text from source file 100% accurate 1 mark 3 paragraphs set in style p 1 mark Bottom right Created by: name & numbers 1 mark Set in style h2 1 mark