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

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

2 0983/31/M/J/23 © UCLES 2023 You have been supplied with the following source file: j31weather.csv 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 j2331evidence_ followed by your centre number_candidate number, for example, j2331evidence_ZZ999_9999 You will use this as your Evidence Document during the examination. Task 2 – Spreadsheet You are going to create a spreadsheet to calculate and display weather data about three towns called Amarta, Bingchen and Chelsmy. 1 Open and examine the file j31weather.csv in your spreadsheet software. Save this as a spreadsheet with the file name Weather_ followed by your centre number_ candidate number, for example, Weather_ZZ999_9999 Place in the footer: • left aligned, the automated file name with no file path • right aligned, your name, centre number and candidate number. [2] 2 Format rows 1 to 17 of the spreadsheet to look like this. A B C D E F G H I J Average hours of sunshine per month Town Amarta Bingchen Amarta Date 1st January 2023 4.224 6.86 13 20 20 4 19 23 18 16 10 10 0 18 0 0 0 5.36 0 9.88 1.6 0.5 0 2.97 3.52 0.479 4.748 3.013 3.246 3.212 3.964 3.256 2.109 4.456 4.019 1.827 2nd January 2023 3rd January 2023 4th January 2023 Sunshine (hours) Rainfall (mm) Rainfall (mm) Wind speed (knots) Wind speed (knots) Sunshine (hours) Rainfall (mm) Wind speed (knots) Sunshine (hours) Number of days with rain in Amarta Number of days with heavy rain in Amarta Average wind speed in Amarta in January Number of days with a wind speed of less than 5 knots in Amarta in January Number of days with rain in Bingchen Number of days with rain in Chelsmy January February Bingchen Chelsmy Chelsmy 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Apply the formatting in rows 15 to 17 down to row 73. Cells in rows 1 and 13 must be merged and centre aligned with a 16-point font as shown. Cells in the range A6 to C11 must be merged as shown. [10]

3 0983/31/M/J/23 © UCLES 2023 [Turn over 3 Print your spreadsheet showing the values. Make sure: • the page orientation is landscape • the contents of all cells are fully visible and can be easily read • the row and column headings are displayed. [1] 4 Place in cells B3 to D3 formulae to calculate for each town the average hours of sunshine for January, rounded to one decimal place. Place in cells B4 to D4 formulae to calculate for each town the average hours of sunshine for February, rounded to one decimal place. [8] 5 Place in cells D6 to D8 formulae to calculate the total number of days that it rained in each of the three towns. [3] 6 Place in cell D9 a formula to calculate the number of days with more than 7.5 mm of rain in Amarta. [2] 7 Place in cell D10 a formula to calculate the average wind speed in Amarta in January rounded up to the nearest knot. [2] 8 Place in cell D11 a formula to calculate the number of days with a wind speed of less than 5 knots in Amarta in January. [1] 9 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] 10 Print your spreadsheet showing the values. Make sure: • only cells A1 to D11 are displayed • the row and column headings are not displayed • the page orientation is portrait • it fits on a single page • the contents of all cells are fully visible and can be easily read. [3]

4 0983/31/M/J/23 © UCLES 2023 11 In cell E3 calculate the total rainfall for Chelsmy for January. In cell E4 calculate the total rainfall for Chelsmy for February. Create an appropriate chart to compare the average hours of sunshine with the total amount of rainfall for the months of January and February in Chelsmy. Set the month as the category axis. Set the average hours of sunshine as the primary value axis and the rainfall as the secondary value axis. Set the rainfall axis to have a maximum value of 100 mm. Fully label the chart. Save your chart. Place a copy of your chart in your Evidence Document. [9] [Total: 42] Task 3 – Web Page You are working as part of a team of web developers at TawaraWeb and have been asked to create parts of a web page for a client. 12 Create CSS to be added to an external stylesheet to meet these specifications: Set the font for h1, h2, h3 and the paragraph styles so that the browser selects and displays the font Calibri. If this font is not available, the browser selects and displays the font Helvetica Neue. If neither of these fonts is available, the browser should display its default sans-serif font. Place a copy of your CSS in your Evidence Document. [6] 13 Create all the head section of a web page to meet these specifications: Title for the web page is Weather Data Metatags: • set the character encoding to ISO-8859-1 • set the name of the author to TawaraWeb followed by a space then your name • set the web page description to Weather data for the Tawara region • set the viewport to the width of the device being used with an initial scaling of 2 • set two appropriate metatag keywords for use by search engines for this page. Set the default target window to _blank if a new web page is opened from within this web page. Place a copy of your HTML source in your Evidence Document. [22] [Total: 28]

5 0983/31/M/J/23 © UCLES 2023 Task 4 – 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.

6 0983/31/M/J/23 © UCLES 2023 BLANK PAGE

7 0983/31/M/J/23 © UCLES 2023 BLANK PAGE

8 0983/31/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 12 printed pages. © UCLES 2023 [Turn over Cambridge IGCSE™ (9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/31 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/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 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/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 3 of 12 Question Answer Marks 1 Footer: File name with no path on left Candidate details on right 2 2 Rows 1 & 13: Correct cells merged and centred Grey background Bold and italic, 16 point A6:C11: Merged cells Right aligned Wrapped as shown Row 14: Centre aligned horizontally Centre aligned vertically Wrapping as shown Cell borders as shown 10 3 Landscape, fully visible with row & column headings 1 4 B3 AVERAGE( … ) … B15:B45 B4 AVERAGE( B46:B73) C3 AVERAGE( E15:E45) C4 AVERAGE( E46:E73) D3 AVERAGE( H15:H45) D4 AVERAGE( H46:H73) All 6 =ROUND( … ,1) for all 6 formulae 8 5 D6 =COUNTIF(C$15:C$73,">0") D7 =COUNTIF(F$15:F$73,">0") D8 =COUNTIF(I$15:I$73,">0") 3 6 D9 =COUNTIF(C15:C73, …) ,">7.5" 2 7 D10 =ROUNDUP( …,0) AVERAGE(D15:D45) 2 8 =COUNTIF(D15:D45,"<5") 1 9 Printout Landscape row & column heads fully visible 1 10 Values 2 Cells A1:D11 only Portrait orientation & single page fully visible No row & column headings 3

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 4 of 12 Question Answer Marks 11 Chart Appropriate chart type Appropriate title Month as category axis with axis title Sunshine plotted with correct values … on primary value axis with axis title Rainfall plotted with correct calculated values … on secondary value axis with axis title … maximum scale set to 100 Appropriate legend, chart easily read, no truncation/overlapping 9 12 CSS: All 4 correct styles selected Using single selector Font-family: Calibri , "Helvetica Neue" in speech marks , sans-serif; Correct CSS syntax with selector { } 6 13 Head section: <head> <title>Weather Data</title> <meta …> … charset= … … "ISO-8859-1" <meta name= … > … "author" … … content="TawaraWeb A Candidate" <meta name= … > … "description" … … content="Weather data for the Tawara region"> <meta name="viewport" …> … content="width=device-width … …, initial-scale=2.0" <meta name="keywords" … > … content=" … " … Tawara … … comma separator … weather <base … > … Target="_blank" </head> 22

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 5 of 12 Evidence document Layout Rows 1 & 13 Correct cells merged and centred 1 mark Grey background 1 mark Bold and italic, 16 point 1 mark A6:C11 Merged cells 1 mark Right aligned 1 mark Row 11 Only row 11 wrapped as shown 1 mark Row 14 Centre aligned horizontally 1 mark Centre aligned vertically 1 mark Wrapping as shown 1 mark All Cell borders as shown 1 mark Print Landscape, fully visible with row & column headings 1 mark

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 6 of 12 Footer File name with no path on left 1 mark Candidate details on right 1 mark

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 7 of 12 Formulae B3 AVERAGE( … ) 1 mark … B15:B45 1 mark B4 AVERAGE( B46:B73) 1 mark C3 AVERAGE( E15:E45) 1 mark C4 AVERAGE( E46:E73) 1 mark D3 AVERAGE( H15:H45) 1 mark D4 AVERAGE( H46:H73) 1 mark All 6 =ROUND( … ,1) for all 6 formulae 1 mark D6 =COUNTIF(C15:C73,">0") … 1 mark D7 =COUNTIF(F15:F73,">0") 1 mark D8 =COUNTIF(I15:I73,">0") 1 mark D9 =COUNTIF(C15:C73, …) 1 mark … ">7.5" 1 mark D10 =ROUNDUP( … ,0) 1 mark AVERAGE(D15:D45) 1 mark D11 =COUNTIF(D15:D45,"<5") 1 mark Formulae p/o Landscape row & col heads fully visible 1 mark

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 8 of 12

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 9 of 12

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 10 of 12

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 11 of 12 0 10 20 30 40 50 60 70 80 90 100 0 0.5 1 1.5 2 2.5 3 3.5 4 January February Total rainfall in mm Hours of sunshine Month Comparison of rainfall and sunshine in January and February in Chelsmy Average hours of sunshine Total rainfall in mm Values 2 Cells A1:D11 only 1 mark Portrait orientation & single page fully vis 1 mark No row & column headings 1 mark Chart Appropriate chart type 1 mark Appropriate title 1 mark Month as category axis with axis title 1 mark Sunshine plotted with correct values 1 mark … on primary value axis with axis title 1 mark Rainfall plotted with correct calculated values 1 mark … on secondary value axis with axis title 1 mark … maximum scale set to 100 1 mark Legend relates to data & chart has no truncation/overlap 1 mark

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2023 © UCLES 2023 Page 12 of 12 h1,h2,h3,p {font-family:Calibri,"Helvetica Neue",sans-serif} <head> <title>Weather Data</title> <meta charset="ISO-8859-1"> <meta name="author" content="TawaraWeb A Candidate"> <meta name="description" content="Weather data for the Tawara region"> <meta name="viewport" content="width=device-width, initial-scale=2.0"> <meta name="keywords" content="Tawara, weather"> <base target="_blank"> </head> Head section <head> 1 mark <title>Weather Data</title> 1 mark <meta … > 1 mark … charset= … 1 mark … "ISO-8859-1" 1 mark <meta name= … > 1 mark … "author" … 1 mark … content="TawaraWeb A Candidate" 1 mark <meta name= … > 1 mark … "description" … 1 mark … content="Weather data for the Tawara region" 1 mark <meta name="viewport" …> 1 mark … content="width=device-width … 1 mark …, initial-scale=2.0" 1 mark <meta name="keywords" … > 1 mark … content=" … " 1 mark … Tawara … 1 mark … comma separator 1 mark … weather 1 mark <base … > 1 mark target="_blank" 1 mark </head> 1 mark CSS All 4 correct styles selected 1 mark font-family:Calibri 1 mark , "Helvetica Neue" in speech marks 1 mark , sans-serif; 1 mark Correct CSS syntax with selector { } 1 mark