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

This document has 8 pages. Any blank pages are indicated. [Turn over Cambridge IGCSE™(9–1) * 3 7 0 4 3 4 3 7 7 3 * INFORMATION AND COMMUNICATION TECHNOLOGY 0983/31 Paper 3 Spreadsheets and Website Authoring May/June 2025 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 [ ]. DC (IP) 354915 © UCLES 2025

2 0983/31/M/J/25 © UCLES 2025 You have been supplied with the following source files: TRbanner.png TRdevelop.htm TRracing.css TRtest.csv TRtext.txt TRvideo.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 Evidence Document in your work area as j2531evidence_ followed by your centre number_candidate number, for example j2531evidence_ZZ999_9999 You will need your Evidence Document during the examination to place screenshots when required. Task 2 – File management 1 Create a new folder called racing Locate only the following files and store them in your racing folder. TRbanner.png TRdevelop.htm TRracing.css TRtext.txt TRvideo.mp4 Display the contents of your racing folder, showing the folder name and all file names, file extensions, file sizes, frame height, frame width 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]

3 0983/31/M/J/25 © UCLES 2025 [Turn over Task 3 – Web Page You will create a web page to advertise Tawara Racing, who race motor cars. 2 Create in your racing folder a web page called racing.htm This web page must be created using a single table and work in all browsers. The table must be left‑aligned and fit 90% of the browser window. The table must have a structure as shown in this diagram: E D A B C Each table cell is identified with a letter which must not appear on your final web page. Table borders must appear on the final web page. [6] 3 Set the title of the web page to Tawara Racing [1] 4 Place in: • cell A the image TRbanner.png • cell B video and source tags to display TRvideo.mp4 Make sure that the controls are visible and the video loops when played. Display an automated text‑based error message if the browser does not support this video type. [7]

4 0983/31/M/J/25 © UCLES 2025 5 Enter in cell C the text from the file TRtext.txt Set this text as style h3. [2] 6 Enter in cell D the text Click here to find out more about our exciting developments, or here for job opportunities. Enter in cell E the text Web page created by: followed on a new line by your name, centre number and candidate number. Set all the text in cells D and E as style h2. [4] 7 Make the text exciting developments a link to open the web page TRdevelop.htm in a new window called _blank Make the text job opportunities a link to an email editor to prepare an email to Tawara.Racing@cambridge.org with the subject line Job opportunities [6] 8 Attach the stylesheet TRracing.css to your web page. Edit this stylesheet so that the table borders are not collapsed. Save this stylesheet. [2] 9 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: • the full page can be seen • all text can be easily read • the address bar is visible. Take screenshot evidence showing your web page in the browser. Place this in your Evidence Document. [1] [Total: 29] Task 4 – Printing the Evidence Document Save and print your Evidence Document. Make sure your name, centre number and candidate number appear on every page of your Evidence Document.

5 0983/31/M/J/25 © UCLES 2025 [Turn over Task 5 – Spreadsheet You will assist Tawara Racing to analyse performance data when testing their racing cars. 10 Open and examine the file TRtest.csv Place, right‑aligned in the header, the text Created by: followed by a space then your name, centre number and candidate number. Place in the footer 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. Save this as a spreadsheet with the filename TestData_ followed by your centre number_candidate number, for example TestData_ZZ999_9999 [3] 11 Enter the missing lap numbers in column A. [1] 12 Place a replicable formula in cell F14 to calculate the time in seconds taken for this lap. For example: if the minutes = 1, seconds = 14 and thousandths of a second = 484 this cell should display 74.484 1 minute = 60 seconds Display the data in cell F14 to 3 decimal places. Replicate this formula for all laps. [6] 13 Insert ten rows between rows 1 and 2. Move the contents of cells H13 to H20 into cells A3 to A10. [2]

6 0983/31/M/J/25 © UCLES 2025 14 Merge cells A1 to F1. Format this merged cell with a black 36‑point sans‑serif font on a yellow background. Merge cells A12 to F12. Format rows 1 to 13 of the spreadsheet to look like this: Test data for supercharger on the practice circuit [7] 15 Place in cell B3 a formula to display the fastest lap time from the data displayed. [2] 16 Place in cell B4 a formula to display the slowest lap time. [1] 17 Place in cell B5 a formula to display the average lap time. [1] 18 Place in cell B6 a formula to display the number of laps where the Supercharger was On [3] 19 Place in cell B7 a formula to display the number of laps where the Supercharger was Off [1] 20 Place in cell B8 a formula to calculate the average lap time when the Supercharger was On [4] 21 Place in cell B9 a formula to calculate the average lap time when the Supercharger was Off [2] 22 Place in cell B10 a formula to display SC success if the average lap times were faster with the supercharger on or to display SC failed if not. Save your spreadsheet. [4]

7 0983/31/M/J/25 © UCLES 2025 23 Print your spreadsheet showing the formulae. Make sure that the: • printout is in landscape orientation • row and column headings are displayed • contents of all cells are fully visible. [2] 24 Print your spreadsheet showing the values. Make sure that the: • printout fits on a single page • printout is in portrait orientation • row and column headings are not displayed • contents of all cells are fully visible. [1] [Total: 40]

8 0983/31/M/J/25 © UCLES 2025 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 8 printed pages. © Cambridge University Press & Assessment 2025 [Turn over Cambridge IGCSE™ (9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/31 Paper 3 Spreadsheets and Website Authoring May/June 2025 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 2025 series for most Cambridge IGCSE, Cambridge International A and AS Level components, and some Cambridge O Level components.

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2025 © Cambridge University Press & Assessment 2025 Page 2 of 8 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 2025 © Cambridge University Press & Assessment 2025 Page 3 of 8 Task Answer Marks For Task 1 see below for example of folder screenshot. 1 Screenshot includes folder name, frame height and width, image dimensions, file names, file extensions and sizes 1 Task Answer Marks For Task 2 see below for example of HTML and browser view. 2 Table width=90% 1 Single table used 1 Table borders visible in the browser 1 No letters visible 1 Row 1 – colspan="2" 1 Rows 3 and 4 – colspan="2" 1 Task Answer Marks For Task 3 see below for example of HTML 8 3 Head section - title Tawara Racing 1 Task Answer Marks For Task 4 see below for example of HTML and browser view. 4 Top row - TRBanner.png 1 Row 2 left - Video visible 1 video <…> tag used with… 1 … loop attribute 1 source<…> tag used with src="TRvideo.mp4" … 1 … type="video/mp4" 1 Appropriate error message between <video> and </video> 1

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2025 © Cambridge University Press & Assessment 2025 Page 4 of 8 Task Answer Marks For Task 5 see below for example of browser view. 5 Row 2 right – text from source file 100% accurate … 1 … set in style h3 1 Task Answer Marks For Task 6 see below for example of HTML and browser view. 6 Row 3 – Click here to find out more about our exciting developments, or here for job opportunities. 1 Row 4 – Web page created by: … 1 … new line then name and numbers … 1 Rows 3 and 4 – all set in style h2 1 Task Answer Marks For Task 7 see below for example of HTML. 7 Anchor set around exciting developments 1 <a href="TRdevelop.htm" … 1 … target="_blank"> 1 Anchor set around job opportunities 1 <a href="mailto:Tawara.Racing@cambridge.org … 1 … ?subject=Job opportunites"> 1 Task Answer Marks For Task 8 see below for example of html and browser view. 8 TRracing.css attached in head section 1 Table – borders seen separated in browser view 1 Task Answer Marks For Task 9 see below for example of browser view. 9 In web browser with address visible 1

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2025 © Cambridge University Press & Assessment 2025 Page 5 of 8 Task Answer Marks For Task 10 see below for example of spreadsheet. 10 Text Created by: with space then name, centre and candidate number right 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 Task Answer Marks For Task 11 see below for example of spreadsheet formulae. 11 Missing lap numbers replicated into column A down to lap 40 1 Task Answer Marks For Task 12 see below for example of spreadsheet formulae & values. 12 Cell F14 =60*C14 1 +D14 1 +E14… 1 … /1000 1 Formatted to 3dp 1 Replicated to lap 40 1 Task Answer Marks For Task 13 see below for example of spreadsheet formulae. 13 10 rows inserted between rows 1 and 2 … 1 … text from H13:H20 moved to A3:A10 1

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2025 © Cambridge University Press & Assessment 2025 Page 6 of 8 Task Answer Marks For Task 14 see below for example of spreadsheet values. 14 Cells A1:F1 and A10:F10 merged 1 Merged cell A1 black 36 point sans-serif font on yellow background … 1 … wrapped as shown 1 Borders as shown 1 Rows 1, 12 and 13 centre aligned horizontally 1 Row 13 centre aligned vertically 1 Row 13 wrapped as shown 1 Task Answer Marks For Task 15 see below for example of spreadsheet values. 15 Cell B3 =MIN(…) 1 … F14:F53 1 Task Answer Marks For Task 16 see below for example of spreadsheet values. 16 Cell B4 =MAX(F14:F53) 1 Task Answer Marks For Task 17 see below for example of spreadsheet values. 17 Cell B5 =AVERAGE(F14:F53) 1 Task Answer Marks For Task 18 see below for example of spreadsheet values. 18 Cell B6 =COUNTIF( … ) 1 … B14:B53 … 1 … ,"On" 1

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2025 © Cambridge University Press & Assessment 2025 Page 7 of 8 Task Answer Marks For Task 19 see below for example of spreadsheet values. 19 Cell B7 =COUNTIF(B14:B53,"Off") 1 Task Answer Marks For Task 20 see below for example of spreadsheet formulae. 20 Cell B8 =AVERAGEIF( … ) 1 … B14:B53 … 1 … ,"On" … 1 ,F14:F53 1 Task Answer Marks For Task 21 see below for example of spreadsheet formulae. 21 Cell B9 =AVERAGEIF(B14:B53, … ) 1 … ,"Off" ,F14:F53 1 Task Answer Marks For Task 22 see below for example of spreadsheet formulae. 22 Cell B10 =IF( … ) 1 … B8<B9 … 1 … ,"SC success" … 1 … ,"SC failed" 1 Task Answer Marks For Task 23 see below for example of formulae spreadsheet. 23 Formulae printout – All cells fully visible 1 Formulae printout – Landscape orientation with row and column headings 1

0983/31 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2025 © Cambridge University Press & Assessment 2025 Page 8 of 8 Task Answer Marks For Task 24 see below for example of values spreadsheet and selection method. 24 Values printout – Portrait, fully visible, single page, no row and column headings. 1