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

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

2 0983/22/M/J/24 © UCLES 2024 You have been supplied with the following source files: j2422area.csv j2422courses.csv j2422email.jpg j2422evidence.rtf j2422info.rtf j2422students.csv j2422study.rtf Task 1 – Evidence Document Open the file j2422evidence.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 in when required. Task 2 – Document You are going to edit a document for Tawara Agricultural College. The college uses a corporate house style for all its documents. 1 Using suitable software, open the file j2422info.rtf The page setup is set to A4, portrait orientation with two-centimetre margins. Do not make any changes to these settings. Four paragraph styles have already been created and applied. Do not make any changes to these unless instructed to do so. Save the document in your work area with the file name PAMPHLET 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/22/M/J/24 © UCLES 2024 [Turn over 2 Place right-aligned in the header of the PAMPHLET document the text: Information updated by: followed by a space, then your name, centre number and candidate number. Place right-aligned in the footer automated page numbers. Make sure that: • the header and footer are aligned to the right margin of the page • 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 EDUCATIONAL FACILITIES and the following text up to and including the paragraph ending … or additional privileges. Change the page layout so that only this text is displayed in two columns of equal width with a one-centimetre space between them. [2]

4 0983/22/M/J/24 © UCLES 2024 4 The TAC-subhead paragraph style has already been created and applied to the four subheadings. Modify the TAC-subhead style so only the following formatting is applied: Style name Font style Font size (points) Alignment Enhancement Line spacing Space before (points) Space after (points) TAC-subhead serif 16 centre bold, italic single 0 3 Take screenshot evidence to show you have modified the TAC-subhead style and the settings applied. Place this in your Evidence Document. [3] 5 Sort the bulleted list from books … to … travel into alphabetical order. [1] 6 Format the list so that the bullets are indented 1.5 centimetres from the left margin. [1] 7 Import the image j2422email.jpg and place it in the paragraph beginning The college has a limited fund … [1] 8 Format the image so that: • the text wraps around the image • it appears in the paragraph starting The college has a limited fund … aligned to the right of the column and the bottom of the text in that paragraph • when clicked it opens an email editor ready to send a message to TAC@cambridge.org with a subject line Tawara Bursary Place in your Evidence Document a screenshot showing the link from the image, the email address and the subject. [4] 9 Locate the table in the document. Delete the entire column and contents with the heading Price per week [1]

5 0983/22/M/J/24 © UCLES 2024 [Turn over 10 Format the first row of the table so that: • it becomes a single cell with the contents centre-aligned over the three columns • it has a light-grey (20–40%) background fill. [2] 11 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. [2] 12 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 except the TAC-subhead style changed in Step 4 • 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: 22]

6 0983/22/M/J/24 © UCLES 2024 Task 3 – Database You are now going to prepare some reports. Dates must be imported in the format of day month year (DMY). All currency values must display the same currency symbol and be set to two decimal places. 13 Use database software to import the file j2422students.csv as a new table. Use these field names and data types: Field name Data type Display Course_code Text Last_name Text First_name Text Gender Text Roll_no Text DOB Date/Time dd-MMM-yy e.g. 12-Aug-24 Street_address Text Area Text Post_code Text Fees_paid Boolean/Logical Yes/No Payment_type Text Set Roll_no as the primary key. Save the data. Place in your Evidence Document a screenshot showing the field names, data types and primary key.

7 0983/22/M/J/24 © UCLES 2024 [Turn over Import the file j2422courses.csv as a new table in your database. Use these field names and data types: Field name Data type Store Display Level Number integer integer Course_name Text Course_ID Text Course_type Text Study_mode Text Duration Text Course_cost Number/Currency 2 decimal places currency symbol with 2 decimal places Start_date Date/Time day month year Set Course_ID as the primary key. Save the data. Place in your Evidence Document a screenshot showing the field names, data types and primary key. [6] 14 Create a one-to-many relationship between Course_ID in the courses table and Course_Code in the students table. Take screenshot evidence showing the fields and type of relationship. Place this in your Evidence Document. [1] 15 Enter the following details as a new record in the students table: Course_code TAGL204 Last_name Peacock First_name Luca Gender Male Roll_no R0561 DOB 09/06/1988 Street_address 54 Pershore Lane Area Freymarsh Post_code PB51 7EH Fees_paid No Payment_type Cheque [2]

8 0983/22/M/J/24 © UCLES 2024 16 Using fields from both tables, produce a tabular report that: • selects the records where: – Fees_paid is No – Payment_type is Cheque or Credit Card • contains a new field called Late_payment which is calculated at run-time. This field must display the new course cost after a 2% increase has been applied. Use Course_cost multiplied by 1.02. Format this field to display currency • shows only the fields Roll_no, First_name, Last_name, DOB, Course_name, Level, Fees_paid, Payment_type, Course_cost and Late_payment in this order, with data and labels displayed in full. Do not group the data • sorts the data into ascending order of Level and descending order of Course_name • has a page orientation of landscape • fits a single page width and prints on two pages • includes only the title Surcharges for outstanding fees displayed in a larger font size, fully visible, at the top of the page • 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. [11] 17 Using fields from both tables, produce labels which: • select the records where: – Course_name includes the text crop – Course_type is University • are sorted in ascending order of Last_name Use this selection to produce labels which: • are arranged in 2 columns and 5 rows with 10 labels to the page, for example with a label size of 99.0 mm wide × 57.0 mm high (9.90 cm × 5.7 cm) • print in portrait orientation with a page size of 21 cm by 29.7 cm • display the data for each field as shown in the following sample label: Course_name Course_type - Start_date First_name Last_name Street_address Area Post_code • have your name, centre number and candidate number on the left at the bottom of each label. Modify the format of the label so that only the first two lines are displayed in a larger font size, centre-aligned and 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]

9 0983/22/M/J/24 © UCLES 2024 [Turn over 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. Task 5 – Presentation You are going to create a short presentation. All slides must have a consistent layout and formatting. 18 Create a presentation of six slides using the file j2422study.rtf All slides must display a title and a bulleted list. [1] 19 Use a master slide to display only the following features: • a thick black 3 to 4 point wide horizontal line across the full width of the slide. Position this line above the slide titles about three centimetres from the top. Make sure the line does not overlap any slide data • above the line enter the text Organic Crop Farming in a 32 point, black font, aligned to the top right of the slide. Make sure the text does not wrap or overlap the line • automatic slide numbers on the top left • your name, centre number and candidate number. Make sure that: • master slide items appear in the same position on every slide • no items overlap on any slide. [4] 20 Use the data in the file j2422area.csv to create a vertical bar chart. This must compare the size of organic farmland by region for only the years 2013 and 2023. Display with labels: • the regions on the category axis • the values on the value axis • a legend showing the years. [3] 21 Label the chart with a: • chart title Regional distribution of organic farmland • value axis title Million hectares [2]

10 0983/22/M/J/24 © UCLES 2024 22 Display only the data values above each bar. Format all the data labels to display 1 decimal place. [2] 23 Format the value axis scale to display: • a minimum value of 0 • a maximum value of 42 • increments of 7 [2] 24 Place the chart to the left of the bullets on the slide with the title Global statistics 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] 25 Add the following text as presenter/speaker notes to the slide with the title Global statistics India has the most organic farmers in the world. Print only this slide as presenter/speaker notes. [2] 26 Save the presentation. Print all slides in portrait orientation with six slides to the page. [1] [Total: 18]

11 0983/22/M/J/24 © UCLES 2024 BLANK PAGE

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

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 3 of 20 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/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 4 of 20 Task 2 – Document Production Question Answer Marks 1 File saved as PAMPHLET with evidence of correct file type 1 2 3 Header: text Information updated by: entered accurately in header 1 Header: [space] name, centre number, candidate number right aligned on same line, no placeholders 1 Automated page numbers right aligned in footer 1 3 2 Section break – applied to correct text 1 2 columns, 1 cm column spacing 1 4 3 TAC-subhead modified, named correctly, based on Normal/default 1 TAC-title style attributes – serif 16 pt, centred, bold, italic, single line, 0 pt before, 3 pt after, no other formatting 1 Subheads (4) – TAC-subhead modified in EV Step 4, formatting matches 1 5 Bulleted list sorted into alphabetical order 1 6 Bullets indented 1.5 centimetres from the left margin 1 7 Correct image j2422email.jpg inserted in correct paragraph 1

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 5 of 20 Question Answer Marks 8 4 Image aligned to bottom of text and right column margin with text wrapped 1 Evidence of email link from image 1 Email link set to send message to TAC@cambridge.org 1 Email link subject line Tawara Bursary 1 9 Column and contents with the heading Price per week deleted 1 10 2 Table row 1 only merged and data centre aligned 1 Table row 1 only light grey (20–40%) background fill 1 11 2 Rows 2 to 8 text displays on one line 1 Table borders and data fit within the column width 1 12 Document spell checked and proofread – Document complete, paragraphs intact, portrait, consistent margins, pages and columns aligned top, no widows/orphans, list & table not split, no blank pages, pre-applied styles unchanged with consistent spacing (excluding subheads), space below longest column less than or equal to 6 point 1 Total 22

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 6 of 20 Task 3 – Database Question Answer Marks 13 6 Students table – 11 field names as given, correct data types 1 Courses table – 8 field names as given, correct data types 1 Primary keys set on Roll_no (students), Course_ID (courses) 1 Report 1 – DOB in DMY format and displays dd-MMM-yy 1 Report 1 – Fees_paid displays Yes/No 1 Report 1 – Late_payment and Course_cost display same currency symbol and 2dp 1 14 1-to-many relationship between Course_ID (courses) to Course_Code (students) 1 15 2 Students table – new record R0561 Luca Peacock entered once, does not replace R0001 Brandon Middleton 1 New record accurate – R0561 | Luca | Peacock | 09-Jun-88 | No | Cheque 1

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 7 of 20 Question Answer Marks 16 11 Report footer – Name, centre number, candidate number in page footer, appears on every page 1 Report title – Surcharges for outstanding fees top of page, accurate 1 Title displayed in a larger font size and fully visible 1 Calculated field heading Late_payment – 100% accurate 1 Late payment calculated – 2% increase – correct values 1 Select records – Fees_paid is No 1 Select records – Payment_type is Cheque or Credit Card 1 Sort ascending on Level and descending on Course_name, no grouping 1 Print layout – base fields, headings and data in correct order Roll_no | First_name | Last_name | DOB | Course_name | Level | Fees_paid | Payment_type | Course_cost | Late_payment 1 Print layout – Landscape, all base fields present, no truncation 1 Fits a single page wide and prints on two pages 1

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 8 of 20 Question Answer Marks 17 10 Name, centre and candidate number bottom left of each label 1 Top two lines only centre aligned 1 Top two lines only larger font size with bold enhancement 1 Fields – correct position with bottom four field rows left aligned 1 Fields – correct punctuation and spacing, min 1 space between fields and before and after dash 1 All fields present, data fully visible with no field overlap 1 Select records – Course_name includes the text crop 1 Select records – Course_type is University 1 Records sorted in ascending order on Last_Name 1 Labels printed, portrait, layout of 2 columns  5 rows, 10 labels to page 1 Total 30

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 9 of 20 Task 4 – Presentation Question Answer Marks 18 Presentation complete – slides imported, consistent title/bullet layout, no blank slides, no text changed 1 19 4 Thick black 3–4 pt horizontal line across full slide width, 3 cm from top 1 Text Organic Crop Farming large black font, top right, not wrapped 1 Slide number top left | name, centre number, candidate number 1 Line positioned above slide titles, heading above line, no items overlap on any slide 1 20 3 Chart – vertical comparative bar chart created using correct data 1 Region labels on category axis, value numbers displayed on value axis 1 Legend displays the years for their data (2013 and 2023) 1 21 2 Chart title Regional distribution of organic farmland 100% accurate 1 Value axis title Million hectares 100% accurate 1 22 2 Data values only displayed as data labels above each bar 1 All data labels to display 1 decimal place 1

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 10 of 20 Question Answer Marks 23 2 Value axis displays minimum 0, maximum 42 1 Value axis displays increments of 7 1 24 Chart on correct slide, left of bullets, chart data fully visible, no overlap or split words 1 25 2 Presenter notes India has the most organic farmers in the world. in correct position on correct slide 100% accurate 1 Presenter notes slide only printed as presenter/speaker notes layout 1 26 All slides printed as handouts, portrait orientation, 6 slides to page 1 Total 18

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 11 of 20 Header: Text Information updated by: entered accurately in header 1 mark Header: [space] Name. centre number, candidate number, right aligned on same line, no placeholders 1 mark Columns Section break - applied to correct text 1 mark 2 columns, 1 cm column spacing 1 mark Subheads (4) TAC-subhead modified in EV Step 4, formatting matches 1 mark Image Correct image inserted in correct paragraph 1 mark Aligned bottom of text and right column margin with text wrapped 1 mark Bulleted list sorted into alphabetical order 1 mark Bullets indented 1.5 centimetres from left margin 1 mark Footer Automated page number right aligned 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 12 of 20 Table Column and contents Price per week deleted 1 mark Row 1 only merged and data centre aligned 1 mark Row 1 only light grey (20-40%) background fill 1 mark Rows 2 to 8 text displays on one line 1 mark Table borders and data fit within column width 1 mark Document Presentation Document complete/paragraphs intact, portrait, consistent margins, pages and columns aligned top, no widows/orphans, list & table not split, no blank pages, pre-applied styles unchanged with consistent spacing (excluding subheads), space below longest column <=6pt 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 13 of 20 Surcharges for outstanding fees Roll_no First_name Last_name DOB Course_name Level Fees_paid Payment_type Course_cost Late_payment R0534 Mikhail Hallingsworth 30-Jan-07 Introduction to Equine Behaviour 1 No Credit Card £165.55 £168.86 R0503 Corey Dickinson 10-Jul-06 Chainsaw Certificate 1 No Cheque £795.00 £810.90 R0429 Leo Kaplan 19-Aug-06 Chainsaw Certificate 1 No Credit Card £795.00 £810.90 R0541 Nadia Osborne 13-Jan-07 Chainsaw Certificate 1 No Cheque £795.00 £810.90 R0222 Christabella Winterbottom 27-Feb-72 Berry Production 1 No Credit Card £95.60 £97.51 R0500 Charlotte Hunter 13-Apr-99 Berry Production 1 No Credit Card £95.60 £97.51 R0491 Abbey Lewis 10-Feb-86 Beginners Floristry 1 No Cheque £1,245.75 £1,270.67 R0547 Callum Stone 07-Feb-07 Beginners Floristry 1 No Credit Card £1,245.75 £1,270.67 R0239 Mohammed Elliott 06-Aug-02 Tractor Driving 2 No Cheque £565.80 £577.12 R0407 Ross Chadwick 30-Dec-91 Dog Grooming Assistant 2 No Cheque £758.45 £773.62 R0610 Mark Belanger 09-Feb-08 Dog Groomer 2 No Cheque £2,158.75 £2,201.93 R0001 Brandon Middleton 05-Apr-99 Animal Nursing Assistant 2 No Cheque £1,687.45 £1,721.20 R0561 Luca Peacock 09-Jun-88 Animal Care Certificate 2 No Cheque £1,865.34 £1,902.65 R0508 Kelly-Ann Wagner 26-Jul-06 Animal Care and Welfare Assistant 2 No Credit Card £2,479.65 £2,529.24 R0111 Vincent Heath 30-Aug-97 Veterinary Nursing Diploma 3 No Cheque £5,832.65 £5,949.30 R0452 Reuben Thwaites 05-Jun-00 Veterinary Nursing Diploma 3 No Cheque £5,832.65 £5,949.30 R0140 Josephine Dunford 16-Apr-01 Organic Livestock Farming 3 No Credit Card £1,245.85 £1,270.77 R0026 Ludvig Wensel 15-Oct-07 Land and Wildlife Management 3 No Credit Card £4,758.95 £4,854.13 R0202 Wayne Heaton 12-Oct-74 Land and Wildlife Management 3 No Credit Card £4,758.95 £4,854.13 R0313 Mason Purdy 26-Oct-03 Gamekeeping Diploma 3 No Cheque £3,265.10 £3,330.40 R0122 Jasmin Zaman 15-Dec-00 Equine Therapy and Rehabilitation 3 No Cheque £2,357.78 £2,404.94 Name, centre number, candidate number Title Only title top of page, 100% accurate 1 mark Title displayed in larger font size and fully visible 1 mark Calculated field Heading 100% accurate 1 mark Late payment calculated - correct values 1 mark Select records (46): Fees_paid is No 1 mark Payment_type is Cheque or Credit Card 1 mark Specified fields, headings and fields in correct order 1 mark Sort ascending on Level and descending on Course_name, no grouping 1 mark Landscape, all base fields present, no truncation 1 mark Fits a single page wide and prints on two pages only 1 mark Name, centre number, candidate number in footer, appears on every page 1 mark New record Luca Peacock entered once, does not replace Brandon Middleton 1 mark New record 100% accurate 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 14 of 20 Roll_no First_name Last_name DOB Course_name Level Fees_paid Payment_type Course_cost Late_payment R0596 Luna Makela 14-Nov-05 Equine Management 3 No Credit Card £5,551.00 £5,662.02 R0432 Monica Brown 28-Jul-05 Equine Lameness and Rehabilitation 3 No Cheque £2,475.25 £2,524.76 R0044 Camille Robinson 05-Oct-99 Diploma in Horse Health 3 No Credit Card £1,246.32 £1,271.25 R0364 Steffen Nguyen 03-Jul-04 Diploma in Farriery 3 No Cheque £5,589.34 £5,701.13 R0285 Leticia Gamal 16-Sep-94 Crop Nutrition and Production 3 No Cheque £3,875.90 £3,953.42 R0149 Arnie Gray 06-Apr-90 Apprenticeship in Equine 3 No Credit Card £2,569.84 £2,621.24 R0169 Frederick Collingwood 17-Jul-80 Animal Husbandry 3 No Credit Card £2,415.30 £2,463.61 R0451 Darren Woodward 19-Mar-05 Animal Husbandry 3 No Credit Card £2,415.30 £2,463.61 R0078 Wolfgang Odermatt 09-Mar-00 Agriculture Financial Planning 3 No Cheque £1,454.62 £1,483.71 R0375 Milo Hammond 04-Sep-89 Agriculture Financial Planning 3 No Credit Card £1,454.62 £1,483.71 R0162 Genevieve Reeves 03-Jul-01 Professional Floristry 4 No Credit Card £1,987.10 £2,026.84 R0358 Harrison Cooper-Holmes 17-May-04 Professional Floristry 4 No Credit Card £1,987.10 £2,026.84 R0590 Marta Santos 18-Mar-99 Managing Landscape 4 No Cheque £3,465.21 £3,534.51 R0399 Hayden Matthews 11-Feb-05 Equine Husbandry 4 No Credit Card £1,765.23 £1,800.53 R0616 Cressida Leonardson 11-Nov-03 Equine Husbandry 4 No Credit Card £1,765.23 £1,800.53 R0229 Alisha Griffin 17-Jul-89 Equine Health Management 4 No Cheque £2,757.78 £2,812.94 R0051 Gabby Wieser 11-Nov-99 Diploma in Arboriculture 4 No Cheque £2,210.55 £2,254.76 R0101 Arabella Hernandez 08-Jan-01 Animal Technology and Management 4 No Credit Card £3,875.90 £3,953.42 R0235 Polly Matzinger 04-Dec-92 Agricultural Finance 4 No Cheque £1,674.89 £1,708.39 R0320 Nigel Osbrink 11-Oct-05 Agricultural Finance 4 No Cheque £1,674.89 £1,708.39 R0530 Joel Markham 14-Nov-06 Equine Training and Behaviour 5 No Cheque £2,659.50 £2,712.69 R0478 Joyce Flannery 08-Mar-06 Equine Science 6 No Credit Card £9,250.00 £9,435.00 R0409 Maya Thompson 27-Nov-81 Agricultural and Crop Science 6 No Credit Card £5,875.54 £5,993.05 R0386 David Urban 02-May-07 Equine Performance Science 7 No Credit Card £6,689.60 £6,823.39 R0196 Luke Wisebrook 06-Oct-07 Sciences of Plant and Crop 8 No Credit Card £3,654.85 £3,727.95 Name, centre number, candidate number Format/Display DOB in DMY format and displays dd-MMM-yy 1 mark Fees_paid displays Yes/No 1 mark Late_payment and Course_cost display same currency symbol and 2dp 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 15 of 20 Label headings Top two lines centre aligned 1 mark Top two lines only larger font size with bold enhancement 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 16 of 20 Fields in correct position, bottom four field rows left aligned: 1 mark Course_name Course_type - Start_date First_name Last_name Street_address Area Post_code Correct punctuation and spacing, min 1 space between fields and before and after dash 1 mark All fields present, data fully visible with no field overlap 1 mark Sort ascending on Last_Name 1 mark Name, centre number, candidate number bottom left of each label 1 mark Labels printed, portrait, layout of 2 cols x 5 rows, 10 labels to page 1 mark Select records (14): Course_name includes the text crop 1 mark Course_type is University 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 17 of 20 Task 5 – Presentation Presentation complete - slides imported, consistent title/bullet layout, no blank slides, no text changed 1 mark Master items Thick 3-4pt horizontal line across full slide width, 3cm from top 1 mark Heading Organic Crop Farming 100% accurate, large font, top right, not wrapped 1 mark Slide number top left | name, centre number, candidate number any consistent position 1 mark Line positioned above slide titles, heading above line, no items overlap on any slide 1 mark Vertical comparative bar chart created using correct data 1 mark Region labels on category axis, values with numbers on value axis 1 mark Legend displays years for their data (2013 and 2023) 1 mark Chart title Regional distribution of organic farmland - 100% accurate 1 mark Value axis title Million hectares - 100% accurate 1 mark Data values only displayed as data labels above each bar 1 mark All data labels to display 1 decimal place 1 mark Value axis displays minimum 0, maximum 42 1 mark Value axis displays increments of 7 1 mark Correct slide, left of bullets, chart data fully visible, no overlap or split words 1 mark Presenter Notes Global statistics slide – presenter notes added, correct position, 100% accurate 1 mark Presenter notes slide only printed in presenter/speaker notes layout 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 18 of 20 All slides printed as handouts, portrait orientation, 6 slides to page 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 19 of 20 EVIDENCE DOCUMENT Step 1: Step 4: Step 8: File saved as PAMPHLET with evidence of correct file type 1 mark Email link Evidence of email link from image 1 mark Email link set to send message to TAC@cambridge.org 1 mark Email link subject line Tawara Bursary – 100% accurate 1 mark TAC-subhead – style modified TAC-subhead modified, named correctly, based on Normal/default 1 mark Serif, 16pt, centre, bold, italic, single, 0pt before, 3pt after no other formatting 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2024 © Cambridge University Press & Assessment 2024 Page 20 of 20 Step 13 Step 14 OR DB Structure Students table – 11 field names as given, correct data types 1 mark Courses table – 8 field names as given, correct data types 1 mark Primary keys set Roll_no (students), Course_ID (courses) 1 mark 1-to-Many relationship – Course_ID (courses) to Course_code (students) 1 mark