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

[Turn over Cambridge IGCSE™(9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/21 Paper 2 Document Production, Databases and Presentations 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 [ ]. * 0 7 8 6 3 0 8 4 5 8 * This document has 12 pages. Any blank pages are indicated. DC (IP) 354909 © UCLES 2025

2 0983/21/M/J/25 © UCLES 2025 You have been supplied with the following source files: j2521access.csv j2521assembly.rtf j2521class.csv j2521evidence.rtf j2521examinfo.rtf j2521learners.csv j2521mp_trends.csv j2521phone.jpg j2521results.rtf Task 1 – Evidence Document Open the file j2521evidence.rtf Make sure that your name, centre number and candidate number will appear on every page of this document. Save this document in your work area as EVIDENCE followed by your candidate number, for example, EVIDENCE9999 You will need your Evidence Document during the examination to place screenshots when required. Task 2 – Document You are going to edit a document about exams. The school uses a corporate house style for all its documents. Paragraph styles must be created and applied as instructed. 1 Using a suitable software package, open the file j2521examinfo.rtf The page setup is set to A4, landscape orientation with 2.5-centimetre margins. Do not make any changes to these settings. Three paragraph styles have already been created. Do not make any changes to these. Save the document in your work area with the file name ExamGuide Make sure it is saved in the format of the software you are using. Place in your Evidence Document a screenshot to show this file has been saved. Make sure there is evidence of the file type. [1]

3 0983/21/M/J/25 © UCLES 2025 [Turn over 2 Place in the ExamGuide document: • a centre-aligned header with automated page numbers • a right-aligned footer on a single line with the text: Produced by: followed by a space then your name, centre number and candidate number. Make sure that: • all the alignments match the page margins • no other text or placeholders are included in the header or footer areas • headers and footers are displayed on all pages. [3] 3 Select the subheading General and the following text up to and including the paragraph ending … the evidence provided. Change the page layout so that only this text is displayed in two columns of equal width with a 2-centimetre space between the columns. [2] 4 Apply a bulleted list to the text from mobile phones … to … enabled electronic devices. Format the bullets so that: • the bullets are indented 2.5 centimetres from the left margin • the list is in single line spacing with no space before or after each line • there is a 6-point space after the last item in the list. [3] 5 Locate the table in the document. Delete the entire row and contents for the subject Business Unit 1 [1] 6 Sort all the data in the table from Maths Paper 1 to Combined Science Paper 3 into ascending order of Exam Date with data integrity maintained. [1]

4 0983/21/M/J/25 © UCLES 2025 7 Apply to the table: • 0.5-point gridlines to all cells • 3- to 4-point external black borders so that these are displayed when the table is printed. [2] 8 Format the first row of the table so that: • it becomes a single cell • the text in the cell is centred vertically and horizontally • it has a light grey (20–40%) background fill. [3] 9 Apply the EX-table style to rows 2 to 12 only. [1] 10 Format the table so that: • all text in each row displays on one line • the table borders and all data fit within the column width • there is a 6-point space after the table. [2] 11 Create and store the following style, basing it on the default/normal paragraph style: Style name Font style Font size (points) Alignment Enhancement Line spacing Space before (points) Space after (points) EX-subhead sans-serif 18 centre bold, underline single 0 0 Take a screenshot to show that you have defined the settings for the EX-subhead style. Make sure there is evidence that you have based this on the default/normal paragraph style. Place this in your Evidence Document. [2] 12 Identify the four subheadings in the document and apply the EX-subhead style to each one. [1]

5 0983/21/M/J/25 © UCLES 2025 [Turn over 13 In the last paragraph locate the text Results Nomination Form Format this text so that when clicked it opens the document with the file name j2521results.rtf Take screenshot evidence showing the text Results Nomination Form links to the correct file. Place this in your Evidence Document. Make sure that the file name is fully visible. [2] 14 Spell check and proofread the document. Make sure that: • the list and table are not split over columns or pages • there are no widows or orphans • there are no blank pages • the original styles are maintained • spacing is consistent between all items. Save the document using the same file name and format used in Step 1. Print the document. [1] [Total: 25]

6 0983/21/M/J/25 © UCLES 2025 Task 3 – Database You are now going to prepare a report. Dates must be imported in the format day month year (DMY). Make sure all required data is fully visible. 15 Use database software to import the file j2521learners.csv as a new table. Use these field names and data types: Field name Data type Display Surname Text Forename Text Gender Text Learner_no Number Integer DOB Date/Time dd-MMM-yy e.g. 12-Aug-09 Telephone Text School_email Text Class_code Text AA_code Text Online_application Boolean/Logical To display as Yes/No Set Learner_no as the primary key. Save the data. Place in your Evidence Document a screenshot showing the field names, data types and primary key used in the table. [4] 16 Import the file j2521access.csv as a new table in your database. Set all data types to text. Set AA_code as the primary key. Place in your Evidence Document a screenshot showing the field names, data types and primary key used in the table. [1]

7 0983/21/M/J/25 © UCLES 2025 [Turn over 17 Examine the file j2521class.csv and identify the most appropriate data to use as a primary key. Close this file. Import the file j2521class.csv as a new table in your database. Use these field names and data types: Field name Data type Display Year_group Number Integer Class_tutor Text Class_ref Text Year_head Text House_code Text House_colour Text House_leader Text Select the most appropriate field from this data and use it to create a primary key. Save the data. Place in your Evidence Document a screenshot showing the field names, data types and primary key used in the table. [2] 18 Create one-to-many relationships as links between: • the AA_code field in the access table and the AA_code field in the learners’ table • the primary key field in the class table and the Class_code field in the learners’ table. Place in your Evidence Document screenshots showing the one-to-many relationships between the three tables. [1]

8 0983/21/M/J/25 © UCLES 2025 19 Add the following as a new record in the learners’ table: Surname Norris Forename Emma Gender Female Learner_no 10218427 DOB 10/07/2009 Telephone 0770090457 School_email em_norris@tawara.ac Class_code 4R AA_code AA02 Online_application No [2] 20 Using fields from all the tables produce a tabular report that: • selects the records where:
– Gender is Female
– Access_arrangement includes the text time • shows only the fields Learner_no, Forename, Surname, DOB, Gender, Year_group, Class_code, Access_arrangement and Online_application in this order, with data and labels displayed in full. Do not group the data • sorts the data into ascending order of Access_arrangement and descending order of Year_group • has a page orientation of landscape • fits a single page wide and prints on two pages only • includes only the text Access arrangements to be scheduled as a title at the top of the page • uses a function to display the DOB of the youngest student and place this at the end of the report • has the label DOB of youngest student fully visible to the left of this date • has your name, centre number and candidate number in the footer of the report so it appears in the same position on every page. Save and print your report. Place in your Evidence Document a screenshot showing the database formula used to find the youngest student. Make sure this formula is fully visible. [10]

9 0983/21/M/J/25 © UCLES 2025 [Turn over 21 Using fields from all the tables produce labels which: • select the records where:
– AA_code is AA01
– Class_code includes the numbers 5 or 6 • are sorted in descending order of Learner_no Use this selection to produce labels which: • are arranged in two columns and four rows with eight labels to the page, for example, each label size 99.0 mm wide × 67.7 mm high (9.90 cm × 6.77 cm) • print in portrait orientation with a page size of A4 (21 cm by 29.7 cm) • display the data for each field left aligned with the layout as shown in the following sample label: Access_arrangement Learner_no Forename Surname DOB Class_code - Class_tutor • have your name, centre number and candidate number on the left at the bottom of each label. Modify only the first two lines of the label so that the text: • is displayed in a 14-point font size • is centre aligned • is displayed in bold. Make sure that data on every label is fully visible with no overlap of any field. Save and print your labels. [10] [Total: 30] Task 4 – Printing the Evidence Document Make sure that your name, centre number and candidate number appear on every page of your Evidence Document. Save your Evidence Document. Print your Evidence Document.

10 0983/21/M/J/25 © UCLES 2025 Task 5 – Presentation You are going to create a short presentation. All slides must have a consistent layout and formatting. 22 Create a presentation of 6 slides using the file j2521assembly.rtf Unless otherwise instructed, the slides must display a title and a bulleted list. [1] 23 Place in the centre of the slide header your name, centre number and candidate number. Place in the footer automated slide numbers left aligned. Make sure that: • the header and footer appear in the same position on every slide • no items overlap on any slide. [2] 24 Format the first slide so that: • a title layout is applied with no bullets • the title and subtitle are centre aligned and in the middle of the slide. [1] 25 Move the slide with the title Look after yourself so it becomes the last slide in the presentation. [1] 26 Import the image j2521phone.jpg and place it to the left of the bullets on the slide with the title Prohibited items [1] 27 Rotate the image 180 degrees. Make sure the aspect ratio is maintained. [1] 28 Use the data in the file j2521mp_trends.csv to create a vertical bar chart to show the number of offences for the category Mobile phone use. The chart must display only data from 2021 to 2024. Display the years as labels on the category axis. Do not display a legend. [2] 29 Label the chart with the title Increase in mobile phone offences [1] 30 Display only the data values along the top of each bar. [1]

11 0983/21/M/J/25 © UCLES 2025 31 Format the value axis scale to display: • a minimum value of 0 • a maximum value of 2100 • increments of 300 [2] 32 Place the chart to the right of the bullets on the slide with the title Tawara malpractice trends Make sure that: • no words are split • all data and labels are fully visible • the chart and its contents do not overlap any slide items. [1] 33 Save the presentation. Print the full presentation in portrait orientation with 2 slides to the page, each filling half the page. [1] [Total: 15]

12 0983/21/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 10 printed pages. © Cambridge University Press & Assessment 2025 [Turn over Cambridge IGCSE™ (9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/21 Paper 2 Document Production, Databases and Presentations 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/21 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2025 © Cambridge University Press & Assessment 2025 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 alon gside 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.

0983/21 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2025 © Cambridge University Press & Assessment 2025 Page 3 of 10 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 thre sholds or grade descriptors in mind.

0983/21 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2025 © Cambridge University Press & Assessment 2025 Page 4 of 10 Task 2 – Document Production Question Answer Marks 1 File saved as ExamGuide, correct with evidence of file type 1 2 3 Header – automated page numbers centre aligned 1 Footer – text Produced by: entered accurately in footer 1 Footer – [space] name, centre number, candidate number. same line, right aligned 1 3 2 Section break – applied to correct text 1 2 columns, 2 cm column spacing 1 4 3 Bullets applied to correct text 1 Bullets indented 2.5 cm from left margin 1 Bullets – single line spacing, 0 pt before and after, 6 point space after last item 1 5 Table located, Business Unit 1 row and contents deleted, table complete and intact 1 6 Table data sorted in ascending order of Exam Date with integrity maintained 1 7 2 3–4 pt external black borders applied 1 0.5 pt internal gridlines applied to all cells 1

0983/21 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2025 © Cambridge University Press & Assessment 2025 Page 5 of 10 Question Answer Marks 8 3 Row 1 merged across four cells 1 Row 1 cell contents centred vertically and horizontally 1 Row 1 light grey (20–40%) background fill 1 9 EX-table style to rows 2 to 12 only 1 10 2 All table text in each row displays on one line 1 Table borders and all data fit within the column width, 6 pt space below table 1 11 2 EX-subhead style created, named correctly, based on normal/default 1 EX-subhead – sans-serif 18pt, centred, bold, underline, single line, 0pt before and after 1 12 EX-subhead style applied to 4 subheads, matches style defined in Step 11 1 13 2 Evidence of correct source text linked 1 link set to open file j2521results.rtf 1 14 Document spell checked and proofread – layout consistent and paragraphs intact 1

0983/21 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2025 © Cambridge University Press & Assessment 2025 Page 6 of 10 Task 3 – Database Question Answer Marks 15 4 Learners table – (10) field names and data types as given 1 Learners table – Learner_no set as primary key 1 Online_application field displays Yes/No 1 DOB field displays date format dd-MMM-yy 1 16 Access table – (4) field names and data types as given, AA_code set as primary key 1 17 2 Class table – (7) field names and data types as given 1 Primary key set on Class_ref field 1 18 1-to-Many relationship AA_code (access) and AA_code (learners) 1-to-Many relationship classes table primary key and Class_code (learners) 1 19 2 New record entered once – 100 % accurate – 10218427 | Emma | Norris | 10/07/2009 | Female | 4R | No 1 New record does not replace record 10055514, Melissa Meyer 1

0983/21 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2025 © Cambridge University Press & Assessment 2025 Page 7 of 10 Question Answer Marks 20 10 Name, centre number, candidate number in footer, appears on every page 1 Report title – Access arrangements to be scheduled top of page, 100 % accurate 1 Select records (42) –Gender is Female 1 Access_arrangement contains time 1 Sort ascending on Access_arrangement and descending on Year_group 1 Calculation label DOB of youngest student 100 % accurate, left of calculation, fully visible, end of report only 1 Specified fields (9), correct order, headings match data 1 Report fits a single page wide, all fields present, no truncation 1 Landscape, tabular layout, prints on two pages 1 Screenshot evidence - database formula to find most recent DOB (=Max) 1

0983/21 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2025 © Cambridge University Press & Assessment 2025 Page 8 of 10 Question Answer Marks 21 10 Name, centre and candidate number bottom left of each label 1 Top 2 lines centre aligned,14 pt with bold enhancement 1 Formatting applied to top 2 lines of data only 1 Sort records in descending order of Learner_no 1 7 correct fields in correct position 1 All fields present, correct punctuation and spacing, min 1 space between fields/punctuation, label data not truncated 1 Label rows 3–5 left aligned left consistently 1 Select records (13): AA_code is AA01 Class_code contains 5 or 6 1 1 Labels printed, A4 portrait, 2 cols  4 rows, 8 labels to fill page 1

0983/21 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2025 © Cambridge University Press & Assessment 2025 Page 9 of 10 Task 4 – Printing the Evidence Document Task 5 – Presentation Question Answer Marks 22 Presentation complete – slides imported (6), consistent title/bullet layout, no blank slides, no text changed 1 23 2 Header – name, centre number, candidate number top centre, consistent position 1 Footer – automated slide numbers bottom left, consistent position 1 24 Slide 1 changed to title layout, title larger than subtitle, centred – middle of slide, no bullet 1 25 Slide 3 (Look after yourself) moved to become last slide in the presentation 1 26 Image inserted on correct slide, left of bullets 1 27 Image rotated 180°, aspect ratio maintained 1 28 2 Vertical bar chart created using correct data 1 Year labels on category axis, no legend 1 29 Chart title Increase in mobile phone offences – 100% accurate 1 30 Data values only displayed along the top of each bar 1 31 2 Value axis displays minimum 0, maximum 2100 1 Value axis displays increments of 300 1

0983/21 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2025 © Cambridge University Press & Assessment 2025 Page 10 of 10 Question Answer Marks 32 Chart on correct slide, right of bullets, chart data fully visible, no overlap/split words 1 33 All slides printed, portrait orientation, 2 slides to page, each filling half page 1