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

This document has 12 pages. [Turn over Cambridge IGCSE™(9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/22 Paper 2 Document Production, Data Manipulation and Presentations May/June 2022 2 hours 30 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 80. ● The number of marks for each question or part question is shown in brackets [ ]. DC (LK) 310907 © UCLES 2022 * 1 2 2 3 0 7 8 4 4 7 *

2 0983/22/M/J/22 © UCLES 2022 You have been supplied with the following source files: J2222ANCHOR.jpg J2222BOATS.csv J2222EVIDENCE.rtf J2222GUIDE.rtf J2222MARINA.csv J2222MDATA.csv J2222MOORING.rtf J2222TOURISM.rtf J2222VESSELS.csv Task 1 – Evidence Document Open the file J2222EVIDENCE.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 J2222EVIDENCE followed by your candidate number, for example, J2222EVIDENCE9999 You will need your Evidence Document during the examination to place screenshots when required. Task 2 – Document You are going to edit a document for Tawara Adriatic Marine. The company uses a corporate house style for all their documents. Paragraph styles must be created, modified and applied as instructed. 1 Open the file J2222GUIDE.rtf The page setup is set to A4, portrait orientation with 2 centimetre margins. Do not make any changes to these settings. Three paragraph styles have already been created. Do not make any changes to these unless instructed. Save the document in your work area, in the format of the software you are using, with the file name TAM_Marinas Take a screenshot to show this file has been saved including evidence of the file type. Place this screenshot in your Evidence Document. EVIDENCE 1 Screenshot evidence of the document saved in your work area. [1] 2 Place in the header your name, centre number and candidate number right aligned. Place in the footer automated page numbers centre aligned. Make sure that: • the header is right aligned to the page margin • the footer is centre aligned between the page margins • no other text or placeholders are included in the header or footer areas • headers and footers are displayed on all pages. [2]

3 0983/22/M/J/22 © UCLES 2022 [Turn over 3 Create the following paragraph styles, basing them on the default paragraph style: Style name Font style Font size (points) Alignment Enhancement Line spacing Space before (points) Space after (points) TAM-subhead serif 20 centre bold, underline single 0 9 TAM-table serif 12 centre italic single 0 0 Take screenshot evidence to show the settings for the TAM-subhead paragraph style and place this in your Evidence Document. EVIDENCE 2 Screenshot evidence showing the settings for the TAM-subhead paragraph style. [2] 4 Display the custom paragraph style names as a list in the paragraph style manager/organiser. Take screenshot evidence of this list and place this in your Evidence Document. EVIDENCE 3 Screenshot evidence showing the list of custom paragraph styles. [1] 5 At the start of the document enter the title: Tawara Adriatic Marine Apply the TAM-title paragraph style to this text. [2] 6 Enter your name immediately after the subtitle Edited by: The TAM-subtitle paragraph style has already been created and applied to the subtitle text. Modify the TAM-subtitle paragraph 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) TAM-subtitle sans-serif 18 right italic single 0 0 Take screenshot evidence to show your modified settings for the TAM-subtitle paragraph style and place this in your Evidence Document. [2] EVIDENCE 4 Screenshot evidence showing your modified settings for the TAM-subtitle paragraph style.

4 0983/22/M/J/22 © UCLES 2022 7 Select the subheading The Adriatic and the following text up to and including the paragraph ending … price list for each marina. Change the page layout so that only this text is displayed in two columns of equal width with a 2 centimetre space between them. [2] 8 Apply arrow (Ø) shaped bullets to the text from boat repair … to … and showering facilities. Make sure that: • the bullets are indented 1 centimetre 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. [4] 9 Identify the five subheadings in the document and apply the TAM-subhead paragraph style to each one. [1] 10 Import the image J2222ANCHOR.jpg and place it in the paragraph beginning During the summer months … Crop the image to remove only the wave line below the anchor. Format the cropped image so that: • it is resized to a width of 3.5 centimetres with no distortion • it is aligned to the left of the column and top of the paragraph starting During the summer months … • the text wraps around the image. [4] 11 Locate the table in the document. Apply the TAM-table paragraph style to the table. [1] 12 Insert a new row as the first row of the table and enter the title: Support Telephone Numbers [2] 13 Format the first row of the table to be centre aligned over the two columns. [1] 14 Format the table so that: • all internal and external gridlines are displayed when printed • the border and all data fit within the column width • there is a 6 point space after the table. Save the document using the same file name and format used in step 1. Print the document. [1] PRINTOUT 1 Make sure your name, centre number and candidate number are on your document. [Total: 26]

5 0983/22/M/J/22 © UCLES 2022 [Turn over Task 3 – Database You are now going to prepare some reports. Make sure all currency values display the same currency symbol and are set to 0 decimal places. 15 Using a suitable database package, import the file J2222MARINA.csv Use these field names and data types: Field name Date type Store Display Marina_Name Text Marina_ID Text Country Text Country_Code Text Area Text Sea Text Language Text Currency Text Currency_Code Text Berth_Fee Number/Currency 2 decimal places currency symbol with 0 decimal places Set Marina_ID as a primary key. Save the data. Import the file J2222VESSELS.csv as a new table in your database. Use these field names and data types: Field name Data type Store Display Yacht_Name Text Manufacturer Text Built Number Length(m) Number 2 decimal places 2 decimal places Beam(m) Number 2 decimal places 2 decimal places Cabins Number Marina Text Crewed Boolean/Logical Yes/No Do not set a primary key. Take screenshot evidence of the table structures showing field names and data types. Make sure the primary key is showing for the marina table. Place the screenshot evidence in your Evidence Document. EVIDENCE 5 Screenshot evidence of the table structures in your database. [6]

6 0983/22/M/J/22 © UCLES 2022 16 Create a one-to-many relationship between Marina_ID in the marina table and Marina in the vessels table. Take screenshot evidence showing the fields and type of relationship. Place this in your Evidence Document. EVIDENCE 6 Screenshot evidence showing the fields and type of relationship. [1] 17 Enter the following details as a new record in the vessels table: Yacht_Name Western Star Manufacturer Barrington Boat Company Built 2017 Length(m) 30.50 Beam(m) 5.80 Cabins 8 Marina JOS_ES Crewed No Check your data entry for errors. Save the data. [2]

7 0983/22/M/J/22 © UCLES 2022 [Turn over 18 Using fields from both tables produce a tabular report that: • selects only the records where: – Yacht_Name ends with the text star – Language is Greek or Spanish – Crewed is No • contains a new field called New_Rate which is calculated at run-time. This field will calculate the Berth_Fee minus 15% of the Berth_Fee • displays the New_Rate field as currency with 0 decimal places • shows only the fields Yacht_Name, Crewed, Length(m), Beam(m), Marina_Name, Sea, Country_Code, Language, Berth_Fee and New_Rate in this order, with data and labels displayed in full. Do not group the data • sorts the data into ascending order of Country_Code and descending order of Length(m) • has a page orientation of landscape • fits a single page wide and prints on two pages • includes only the text European Yachts Available as a title displayed in a larger font size at the top of the page • calculates the average Berth_Fee and places this at the end of the report, displayed as currency with 0 decimal places • has a label Average berth fee to the left of this value • displays only your name, centre number and candidate number in the footer so it appears in the same position on every page. Make sure no other data is displayed in the footer. Save and print your report. PRINTOUT 2 Make sure that you have entered your name, centre number and candidate number on your report. Take screenshot evidence showing the database formula used to calculate the average berth fee and place this in your Evidence Document. EVIDENCE 7 Screenshot evidence of the database formula used. [14] 19 Using fields from both tables produce an extract which: • selects only the records where: – Sea is Adriatic – Length(m) is 25 or more • shows only the fields: Yacht_Name, Length(m) and Sea, in this order, with data and labels displayed in full. Do not group the data • sorts the data into ascending order of Length(m) Save the extract. [4]

8 0983/22/M/J/22 © UCLES 2022 20 Export the extract saved in step 19 as a table in rich text format (rtf). Save the exported file in your work area. Take a screenshot to show the exported file saved in your work area including evidence of the file type. Place this screenshot in your Evidence Document. EVIDENCE 8 Screenshot evidence of the exported file saved in your work area. [1] [Total: 28]

9 0983/22/M/J/22 © UCLES 2022 [Turn over Task 4 – Document 2 21 Using the document saved at step 14 locate the paragraph which ends … from the 2022 Adriatic fleet: Import the extract you saved in step 20 and place it as a table after this paragraph. Make sure that: • the TAM-table paragraph style is applied to the extract • the table fits within the column width • all required fields and their labels are fully visible • no text is wrapped within the extract • there is a 6 point space after the table. [2] 22 Spell check and proofread the document. Make sure that: • the list and tables are not split over columns or pages • there are no widows or orphans • there are no blank pages • paragraph styles have been applied as instructed with consistent spacing maintained between all items • there is a 6 point space after the tables and the list. Save and print the document. [2] PRINTOUT 3 Make sure that you have entered your name, centre number and candidate number on your document. [Total: 4]

10 0983/22/M/J/22 © UCLES 2022 Task 5 – Mail merge You are required to carry out a mail merge using a form. 23 Create a mail merge document using the file J2222MOORING.rtf as the master document and J2222MDATA.csv as your data source file. Replace the text and chevrons in the master document with the merge fields from the data source file as follows: Text and chevrons to replace Replace with merge field <FULL_NAME> Name <INSUR> Insurance_Co <POL_NO> Policy_No <EXP> Expiry <V_NAME> Vessel_Name <V_TYPE> Vessel_Type <LENGTH> Length <BEAM> Beam <PONT> Pontoon <NB> Number <FEE> Annual_Fee Make sure the spacing, punctuation, alignment and enhancements in the original master document are maintained. [4] 24 Replace the text Candidate details here with your name, centre number and candidate number. Save and print your master document showing the merge field codes. [1] PRINTOUT 4 Make sure you have entered your name, centre number and candidate number on your master document showing the merge field codes. 25 Set an automated filter to select the records where the length is 12 or less and the pontoon is North Take a screenshot to show the use of your automated selection method and place this in your Evidence Document. EVIDENCE 9 Screenshot evidence of your automated selection method. [2] 26 Merge and print the forms for the selected records only. [1] PRINTOUT 5 Make sure you have entered your name, centre number and candidate number on your forms. Save and close the files. [Total: 8]

11 0983/22/M/J/22 © UCLES 2022 [Turn over Task 6 – Printing the Evidence Document Save and print your Evidence Document. PRINTOUT 6 Make sure that your name, centre number and candidate number appear on every page of your Evidence Document. Task 7 – Presentation You are going to create a short presentation. All slides must have a consistent layout and formatting. 27 Create a presentation of six slides using the file J2222TOURISM.rtf Unless otherwise instructed, the slides must display a title and a bulleted list. [1] 28 Use a master slide to display only the following features: • a 3–4 point thick horizontal line across the width of the slide, about 3 centimetres from the top • above the line enter the text Support Coastal Tourism in a large, black font, aligned to the top right of the slide. Make sure the text does not wrap • automatic slide numbers on the bottom 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. [3] 29 Use the data in the file J2222BOATS.csv to create a vertical bar chart for only the top 5 ranked countries. This chart must display: • the names of the countries on the category axis • the values for 2022 only. [1] 30 Label the chart as follows: • chart title Recreational Boats in Europe • value axis title Thousands • category axis title Country [2] 31 Display only the data values at the top of each bar. [1] 32 Format the value axis scale to display: • a minimum value of 0 • a maximum value of 1100 • increments of 100 [2]

12 0983/22/M/J/22 © UCLES 2022 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. 33 Place the chart to the left of the bullets on the slide with the title Participation Make sure that: • no words in the chart are split • all data and labels are fully visible • no legend is displayed • the chart and its content do not overlap any slide items. [1] 34 Add the following text as presenter/speaker notes to the slide with the title Participation Sweden and Finland have the most leisure boats Print only this slide as presenter/speaker notes. [2] PRINTOUT 7 Make sure your name, centre number and candidate number are on this slide. 35 Save the presentation. Print the presentation as a handout with 6 slides to the page. [1] PRINTOUT 8 Make sure your name, centre number and candidate number are on all slides. [Total: 14]

This document consists of 17 printed pages. © UCLES 2022 [Turn over Cambridge IGCSE™ (9–1) INFORMATION AND COMMUNICATION TECHNOLOGY 0983/22 Paper 2 Document Production, Data Manipulation and Presentations May/June 2022 MARK SCHEME Maximum Mark: 80 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 2022 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 2022 © UCLES 2022 Page 2 of 17 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/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2022 © UCLES 2022 Page 3 of 17 Task 2 - Step 14 – Printout 1

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2022 © UCLES 2022 Page 4 of 17

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2022 © UCLES 2022 Page 5 of 17 Name entered, modified style TAM-subtitle seen in EV4, all attributes correct 1 mark (sans-serif, 18pt, right, italic only, single line, 0pt before/after) Header Name, centre number, candidate number right aligned 1 mark Footer Automated page number centre aligned 1 mark Text entered as a title text 100% accurate 1 mark Supplied style TAM-title applied 1 mark (serif, 32pt, centred, bold, italic, 0pt before & after) Columns Section break - applied to correct text 1 mark 2 columns, 2 cm column spacing 1 mark Subheads (5) TAM_subhead style applied – matches style defined in EV2 1 mark (serif, 20pt, centre, bold, underline, single line, 0pt before, 9pt after) Image Image inserted in correct paragraph 1 mark Cropped to remove only black wavy line below anchor 1 mark Resized to 3.5 cm wide with aspect ratio maintained 1 mark Aligned top of text and left margin with text wrapped 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2022 © UCLES 2022 Page 6 of 17 DB Extract DB extract in correct place, intact, table structure, no wrap within column width, field labels displayed, no title, fully visible 1 mark Only fields and data Yacht_Name | Length(m) | Sea correct order 1 mark Select records - Sea is Adriatic 1 mark Select records - Length(m) is 25 or more 1 mark Sort ascending order of Length(m) 1 mark TAM-table style seen in EV3 list, applied to DB extract consistently 1 mark (serif, 12pt, centre, italic, single, 0pt space before and after) Document Presentation No changes to body style, space below columns <=6pt 1 mark (Arial, 11pt, justified, single line spacing 0pt before/6pt after) Document complete/paragraphs intact, portrait, consistent margins, pages and columns aligned at top, no widows/orphans, list and tables not split, no blank pages, 6pt space after table(s) 1 mark Table TAM-table style seen in EV3 list, applied consistently rows 2–7 (serif, 12pt, centre, italic, single, 0pt space before, 0pt after) 1 mark New row inserted as 1st row of table 1 mark Heading entered in new row, 100% accurate 1 mark Row 1 – cells merged, heading centred 1 mark Borders and all data fit within column width, all gridlines printed 1 mark List Bullets applied to correct text 1 mark Arrow () shaped bullets applied 1 mark Bullets indented 1cm from left margin 1 mark Single line spacing 0pt space before and after, 6pt after last item 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2022 © UCLES 2022 Page 7 of 17 European Yachts Available Yacht_Name Crewed Length(m) Beam(m) Marina_Name Sea Country_Code Language Berth_Fee New_Rate Scopio Star No 21.52 6.58 Konstantinou Marina Levantine CY Greek €8,833 €7,508 Radiant Star No 21.49 4.53 Konstantinou Marina Levantine CY Greek €8,833 €7,508 Piola Averstar No 21.41 6.89 Konstantinou Marina Levantine CY Greek €8,833 €7,508 Jades Star No 21.40 6.89 Konstantinou Marina Levantine CY Greek €8,833 €7,508 Dawn Star No 11.39 5.51 Demetriades Marina Levantine CY Greek €6,175 €5,249 Bastian Star No 11.36 5.53 Demetriades Marina Levantine CY Greek €6,175 €5,249 Arctic Star No 30.99 5.15 Molina Marina Balearic ES Spanish €13,695 €11,641 Mediterranean Star No 30.93 5.13 Molina Marina Balearic ES Spanish €13,695 €11,641 Jadestar No 30.61 4.24 Josa de la Plana Balearic ES Spanish €13,459 €11,440 Western Star No 30.50 5.80 Josa de la Plana Balearic ES Spanish €13,459 €11,440 Adriatic Star No 29.80 5.49 Club Nautic Mamblas Balearic ES Spanish €12,973 €11,027 Faithfull Star No 29.61 5.80 Club Nautic Mamblas Balearic ES Spanish €12,973 €11,027 Onward Star No 26.20 6.76 Carnota de Mar Balearic ES Spanish €9,865 €8,386 Protostar No 25.74 4.92 Carnota de Mar Balearic ES Spanish €9,865 €8,386 Gordeano Star No 25.72 4.51 Marina de Taranes Balearic ES Spanish €9,865 €8,386 Cramlingstar No 25.71 5.67 Marina de Taranes Balearic ES Spanish €9,865 €8,386 Black Magic Star No 25.70 4.83 Marina de Taranes Balearic ES Spanish €9,865 €8,386 Silver Star No 25.63 5.65 Marina de Taranes Balearic ES Spanish €9,865 €8,386 Nordic Star No 25.58 4.91 Faramontaos Marina Balearic ES Spanish €9,656 €8,208 Saxon Star No 23.27 5.11 Aritzalde Marina Alboran ES Spanish €8,976 €7,629 Twilight Novostar No 22.97 5.83 Marina Lastras Bay of Gibraltar ES Spanish €8,975 €7,629 Southern Star No 22.96 6.32 Marina Lastras Bay of Gibraltar ES Spanish €8,975 €7,629 Eagle Star No 22.95 6.75 Marina Lastras Bay of Gibraltar ES Spanish €8,975 €7,629 Estelle Star No 20.91 5.32 Marine Pescoso Balearic ES Spanish €8,764 €7,450 Orion Star No 20.71 6.38 Marine Pescoso Balearic ES Spanish €8,764 €7,450 Name, centre number, candidate number Title Correct, 100% accurate 1 mark Specified fields, correct order, headings match data 1 mark Landscape, single page wide, fits 2 pages, all base fields, no truncation 1 mark Sort ascending on Country_Code then descending Length(M) 1 mark Select records (42): Yacht_Name ends with star 1 mark Language is Greek or Spanish 1 mark Crewed is No 1 mark Calculated field Heading 100% accurate 1 mark New rate calculated 1 mark d New record Western Star entered once - 100% accurate 1 mark New record - does not replace record Adriatic Star 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2022 © UCLES 2022 Page 8 of 17 Yacht_Name Crewed Length(m) Beam(m) Marina_Name Sea Country_Code Language Berth_Fee New_Rate Lundy Star No 15.60 5.91 Sabadell Marina Balearic ES Spanish €7,750 €6,587 Diamond Star No 15.57 6.39 Sabadell Marina Balearic ES Spanish €7,750 €6,587 Socorro Star No 15.53 6.20 Sabadell Marina Balearic ES Spanish €7,750 €6,587 Solent Star No 16.88 4.29 Marina Sikounda Aegean GR Greek €8,381 €7,124 Orkney Star No 16.85 6.60 Marina Sikounda Aegean GR Greek €8,381 €7,124 Secret Star No 13.98 6.10 Marina Tyrgia Aegean GR Greek €7,461 €6,341 Sparkling Star No 13.85 4.70 Marina Palióvrisi Paleo Ionian GR Greek €7,356 €6,253 Equinox Star No 12.80 4.17 Triandria Etia Marina Sea of Crete GR Greek €7,146 €6,074 Prizim Star No 12.80 3.62 Triandria Etia Marina Sea of Crete GR Greek €7,146 €6,074 Nirvana Star No 12.79 3.75 Triandria Etia Marina Sea of Crete GR Greek €7,146 €6,074 Delta Star No 11.90 3.16 Petrais Marina Balearic GR Greek €6,865 €5,836 Delphine Star No 11.86 5.19 Petrais Marina Balearic GR Greek €6,865 €5,836 Atlantic Star No 11.47 4.85 Alagonia Marina Aegean GR Greek €6,556 €5,572 Bermuda Star No 22.34 6.10 Marina De Marcolos Alboran PT Spanish €8,955 €7,612 Algean Superstar No 22.33 6.25 Marina De Marcolos Alboran PT Spanish €8,955 €7,612 Solar Star No 14.66 6.34 Grandais de Mar Strait of Gibraltar PT Spanish €7,585 €6,447 Frater Star No 14.19 4.42 Baltaria Marina Balearic PT Spanish €7,488 €6,364 Average berth fee €9,042 Name, centre number, candidate number Name, centre number, candidate number displays in page footer, on every page, no other data displayed 1 mark Average value correct for data 1 mark Positioned in report footer at end of report, 0dp and same currency symbol 1 mark Label Average berth fee accurate, to left of value 1 mark Format/Display Length(m) and Beam(m) stored and presented as 2dp not rounded 1 mark Crewed displays as Yes/No 1 mark Format/Display Berth_Fee and New_Rate same currency symbol, stored and presented 0dp 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2022 © UCLES 2022 Page 9 of 17 Task 5 – Mail merge Placeholders and <> replaced Fields «Name» | «Insurance_Co» | «Policy_No» | «Expiry» correct position 1 mark Fields «Vessel_Name» | «Vessel_Type» | «Length» | «Beam» correct position 1 mark Fields «Pontoon» | «Number» | «Annual_Fee» correct position 1 mark All fields correct spacing with £ symbol and punctuation retained 1 mark Name, centre number, candidate number replace Candidate details and master document printed 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2022 © UCLES 2022 Page 10 of 17 Result of merge – correct 4 forms printed – Emil Tomaszewski, Liam Chan, Sheldon Lopez, Meghan Vanderlee 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2022 © UCLES 2022 Page 11 of 17

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2022 © UCLES 2022 Page 12 of 17

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2022 © UCLES 2022 Page 13 of 17

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2022 © UCLES 2022 Page 14 of 17 Task 7 – Presentation Vertical bar chart, correct data, countries on category axis, values with numbers on value axis 1 mark Chart title 100% accurate 1 mark Accurate axis titles – value axis title Thousands, category axis title Country 1 mark Values only displayed as data labels at the top of each bar 1 mark Value axis (y-axis) displays minimum 0, maximum 1100 1 mark Value axis (y-axis) increments set at 100 1 mark Correct slide, left of bullets, no legend 1 mark Presenter Notes Participation slide – presenter notes added, correct position, 100% accurate 1 mark Participation slide printed as presenter/speaker notes layout 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2022 © UCLES 2022 Page 15 of 17 Presentation complete – 6 slides imported, consistent title/bullet layout, no blank slides, no text changed 1 mark Master items Thick (3–4pt) horizontal line across slide width, about 3cm from top 1 mark Heading 100% accurate, large, black font, top right, not wrapped, above line 1 mark Slide number bottom left | name, centre number, candidate number 1 mark All slides printed as handout with 6 slides to page 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2022 © UCLES 2022 Page 16 of 17 EVIDENCE DOCUMENT Step 1 - EVIDENCE 1 Step 3 – EVIDENCE 2 Step 4 – EVIDENCE 3 Step 6 – EVIDENCE 4 File saved as TAM_Marinas with evidence of correct file type 1 mark TAM-subhead Named correctly based on normal/default 1 mark Serif, 20pt, centred, bold, underline, single line space, 0pt before, 9pt after 1 mark Style list TAM-subhead listed, and TAM-table listed and correctly named 1 mark TAM-subtitle – style modified TAM-subtitle modified, name correct, based on Normal/Default 1 mark

0983/22 Cambridge IGCSE (9–1) – Mark Scheme PUBLISHED May/June 2022 © UCLES 2022 Page 17 of 17 Step 15 - EVIDENCE 5 Step16 - EVIDENCE 6 Step 18 - EVIDENCE 7 Step 20 - EVIDENCE 8 Step 25- EVIDENCE 9 DB Structure J2222MARINA - all field names as given, correct data types 1 mark J2222VESSELS - all field names as given, correct data types 1 mark Primary key Marina_ID (marina table), no primary key in vessels table, no ID fields 1 mark Database formula to calculate average berth fee 1 mark Mail Merge selection Evidence of automated filter to select «Length» is 12 or less 1 mark AND «Pontoon» is North 1 mark 1-to-Many relationship between Marina_ID (marina) and Marina (vessels) 1 mark DB Extract saved in rtf format 1 mark