Information and Communication Technology 0417/21 February/March 2023: question paper and mark scheme

Cambridge IGCSE Information and Communication Technology (0417), Paper 2 Document Production, Databases and Presentations, February/March 2023. Read both free below, or download them. Done the paper? Get it marked by AI against this mark scheme.

0417_m23_qp_210417_m23_ms_210417/21/F/M/23

Mark my answers with AI Read the paper and scheme

Paper: Paper 2 Document Production, Databases and Presentations
Total marks: 70
Time: 2 hours 15 minutes
Questions: 3
Code on the paper: 0417/21/F/M/23

0417_m23_ms_21.pdf

0417/21 mark scheme, question by question

Each question as it's printed, and the mark scheme's points for it, as text. Diagrams, tables and graphs are in the PDFs above.

Question 11 mark

Question

Using suitable software, open the file m23stem.rtf The page setup is set to A4, landscape orientation with two-centimetre margins. Do not make any changes to these settings. Save the document in your work area with the file name stemnews 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]

Mark scheme

Document saved with the file name stemnews 1 EV

Question 21 mark

Question

Place in the footer of the stemnews document: • automated page numbers left aligned • your name, centre number and candidate number right aligned. Make sure that: • all the alignments match the page margins • no other text is included in the footer area • the footer is displayed on all pages. [1]

Mark scheme

Automated page numbers left aligned 1 Doc Candidate name, centre number and candidate number right aligned

Question 33 marks

Question

Create and store the following styles, basing each on the default/normal paragraph style: House style specification Enhancement Space before Line spacing Space after Style name Alignment Font style Font size (points) (points) (points) ST-subhead sans-serif 14 centre all capitals, bold single 0 9 ST-table serif 11 left italic single 0 0 ST-bullet serif 11 left square-shaped single 0 0 bullets aligned to the left margin Take a screenshot to show that you have defined the settings for the ST-subhead style. Make sure there is evidence that you have based this on the default/normal paragraph style. Place this in your Evidence Document. [3]

Mark scheme

Screenshot evidence to show that the ST-subhead style has been defined 3 EV Style name correct based on normal 1 mark sans-serif 14 centre 1 mark all capitals, bold single 0 9 1 mark

Question 41 mark

Question

Display the style names created in Step 3 as a list in the style manager/organiser. Take screenshot evidence to show that you have created, named and saved these styles. Place this in your Evidence Document. [1]

Mark scheme

Custom style names displayed as a list in the style manager/organiser 1 EV

Question 52 marks

Question

The style ST-title has already been created and stored. Modify the ST-title style so only the following formatting is applied: Enhancement Space before Line spacing Space after Style name Alignment Font style Font size (points) (points) (points) ST-title sans-serif 36 centre bold, underlined single 0 0 Apply this style to the title text Tawara Schools STEM Development Place in your Evidence Document a screenshot of the style settings for the ST-title style to show the changes you have made. [2]

Mark scheme

ST-title style modified to meet specified formatting. 2 EV Style modified and based on normal 1 mark sans-serif 36 centre bold, underline single 0 0 1 mark

Question 61 mark

Question

Below the title, add a subtitle: Innovations in Science Education [1]

Mark scheme

Subtitle text entered below title Innovations in Science Education 1 Doc

Question 71 mark

Question

The style ST-subtitle has already been created and stored. Apply this style to the text you entered in Step 6. [1]

Mark scheme

ST-subtitle style applied to the text entered in step 6 1 Doc

Question 81 mark

Question

Apply the ST-bullet style to the text from working in teams … to … developing own solutions. [1]

Mark scheme

ST-bullet style applied to specified text 1 Doc

Question 91 mark

Question

Identify the 7 subheadings in the document and apply the ST-subhead style to each one. [1]

Mark scheme

ST-Subhead style applied to each subheading 1 Doc

Question 102 marks

Question

Change the page layout so that the subheading Why is a STEM approach to learning important? and all following text is displayed in two columns of equal width with a one-centimetre space between them. [2]

Mark scheme

Page layout changed so that the subheading Why is a STEM approach to learning important? 2 Doc and all following text is displayed in two equally spaced columns 1 mark with 1 centimetre spacing between the columns. 1 mark

Question 112 marks

Question

Locate the table and insert a new row above Chemistry. Enter the following data into this row: Biology 50 40 [2]

Mark scheme

A new row inserted above Chemistry 1 mark 2 Doc This data entered into this row: Biology | 50 |40 1 mark

Question 121 mark

Question

Merge the cells and centre align the text in the first row of the table. [1]

Mark scheme

First row cells merged and the text centre aligned 1 Doc

Question 132 marks

Question

Apply the ST-table style to rows 2 to 9 of the table. Make sure that: • no data is wrapped within the table • all gridlines are displayed when printed • all borders and data fit within the column width • there is a 6-point space after the table. [2]

Mark scheme

ST-table style applied to the table. 2 Doc No data wrapped and table and gridlines fit within column 1 mark Gridlines show when printed 6-point space after the table 1 mark PUBLISHED Step Document Production Mark

Question 141 mark

Question

Import the image m23scientist.jpg and place it in the paragraph beginning Will the gender disparity… [1]

Mark scheme

The image m23scientist.jpg imported and placed correctly 1 Doc

Question 151 mark

Question

Reflect the image so that the laboratory flask is on the right. [1]

Mark scheme

The image is reflected so that the flask is on the right. 1 Doc

Question 162 marks

Question

Format the image so that: • it is re-sized to a height of 2 centimetres with the aspect ratio maintained • it is aligned to the left column margin and the top of the paragraph starting Will the gender disparity… • text wraps around the image. [2]

Mark scheme

The image is formatted so that it is 2 Doc resized to 2 cm height with aspect ratio 1 mark In correct paragraph aligned top of text and left margin with text wrap on 1 mark

Question 1724 marks

Question

Spell check and proofread the document. Make sure that: • the table and list are not split over two columns or pages • columns align at the top • there are no widows or orphans • there are no blank pages • styles are applied consistently • 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: 24] Task 3 – Database Students at the Tawara High School are placed in one of four groups which are called houses. These houses are Jupiter, Mars, Neptune and Saturn. You are now going to prepare some reports based on school tests.

Mark scheme

Spell check and proofread the document. 1 Doc TOTAL 24 PUBLISHED Step Document Production Mark

Question 183 marks

Question

Using database software, import the file m23tests.csv Do not import the English field. Use these field names and data types: Field name Data type Display Registration_Code Text Given_Name Text Family_Name Text Gender Text Class_Code Text House_Code Text Maths Number 0 decimal places Computer_Science Number 0 decimal places Design_Technology Number 0 decimal places Science Number 0 decimal places Set Registration_Code 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. [3]

Mark scheme

File m23tests.csv is imported 3 EV the field English not imported 1 mark Correct fields and data types used 1 mark Registration_Code set as the primary key 1 mark

Question 193 marks

Question

Import the file m23houses.csv as a new table in your database. Set the House_Code field as the primary key. Examine the file m23staff.csv to identify the most appropriate field to use as a primary key. Import this file as a new table in your database using this field as the primary key. Place in your Evidence Document screenshot evidence showing the field names, data types and the primary key used in each table. [3]

Mark scheme

The files m23staff.csv and m23houses are imported 3 EV with correct field names and data types 1 mark The identified field set as the primary key 1 mark second primary key set 1 mark

Question 201 mark

Question

Edit the following record in the tests table: Registration_Code 2016_029 Class_Code Change from 6B to 6T Check your data entry for errors. Save the data. [1]

Mark scheme

Edit a record (Freya Harris appears in report one if edited). 1 Report 1

Question 211 mark

Question

Create one-to-many relationships between: • the primary key field of the staff table and the Class_Code of the tests table • the primary key field of the houses table and the House_Code field of the tests table. Place in your Evidence Document screenshot(s) showing the one-to-many relationships between the tables. [1]

Mark scheme

One-to-many relationships created between the three tables 1 EV

Question 229 marks

Question

Using fields from all tables, produce a tabular report that: • selects the records where: – the Gender is F – Science is 80 or more – the Class_Code contains 6 • shows only the fields Family_Name, Gender, Teacher_Name, Science, Maths, Computer_Science, Design_Technology, House_Name and Class_Code in this order with data and labels displayed in full. Do not group the data • sorts the data into ascending order of Teacher_Name and descending order of Science • calculates the number of students and places this at the end of the report • has the label New science group size fully visible to the left of this value • has a page orientation of landscape • fits on a single page wide • includes the title STEM Science Class for 2024 displayed in a larger font size, fully visible, at the top of the report • displays 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. Place in your Evidence Document a screenshot showing the database formula used to calculate the number of students. Save and print your report. [9]

Mark scheme

A report produced which: 9 Count Selects records where Gender is F and Science mark is 80 or more 1 mark formula Class_Code contains 6 1 mark in EV 8 shows only the fields Family_Name, Gender Teacher_Name, Science, Maths, Computer_Science, Design_Technology, House_Name and Class_Code in this order 1 mark sorts the data into ascending order of Teacher_Name and then descending order of Science 1 mark counts the number of students in the report 1 mark has the label New science group size to the left of the number 1 mark has a page orientation of landscape and fits on one page wide 1 mark STEM Science Class for 2024 as a title displayed in a larger font size 1 mark has candidate name, centre number and candidate number in the footer of the report with no other items showing. 1 mark PUBLISHED Step Document Production Mark

Question 2311 marks

Question

Using fields from all the tables, produce a tabular report that: • selects only the records where: – the Class_Code is 5C – the House_Name is Mars • shows only the fields Gender, Family_Name, Given_Name, House_Name, Maths, Computer_Science and Teacher_Name in this order with data and labels displayed in full. Do not group the data • sorts the data into ascending order of Gender and ascending order of Family_Name • has a page orientation of portrait • fits on a single page • calculates the average Maths mark in this selection and positions this number below the Maths column • displays this average mark with 0 decimal places • includes the label Average Maths Score fully visible, to the left of this value • includes the title Year Five Test Report for Mars displayed in a larger font size, fully visible, at the top of the report • has your name, centre number and candidate number displayed at the bottom of the report. Place in your Evidence Document a screenshot showing the database formula used to calculate the average mark for Maths. Save and print your report. [11]

Mark scheme

A report produced which: 11 See EV selects records where Class code is 5C 1 mark 9 House_Name is Mars 1 mark shows only the fields Gender, Family_Name, Given_Name, House_Name, Maths, Computer_Science and Teacher_Name 1 mark sorts the data into ascending order of Gender 1 mark then ascending order of Family_Name 1 mark has a page orientation of portrait and fits on a single page 1 mark calculates the average Maths mark in this selection positions this number below the Maths column 1 mark displays this average mark with no decimal places 1 mark displays the label Average Maths Scores to the left of this value 1 mark has the title Year Five Test Report for Mars displayed at the top of the page 1 mark screenshot evidence provided to show the formula used to calculate the average mark for Maths. 1 mark

Question 2430 marks

Question

Export the report created at Step 23 in portable document format (pdf). Save the exported file in your work area with the file name YEAR 5 Place in your Evidence Document a screenshot to show the exported file saved in your work area. Make sure there is evidence of the name and file type. [2] [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. Task 5 – Presentation You are going to create a short presentation. All slides must have a consistent layout and formatting.

Mark scheme

A report exported in pdf format 1 mark 2 EV 10 with the file name YEAR 5 1 mark TOTAL 30 PUBLISHED Step Document Production Mark

Question 251 mark

Question

Create a presentation of 6 slides using the file m23vision.rtf Unless otherwise instructed, the slides must display a title and a bulleted list. [1]

Mark scheme

A presentation created consisting of six slides in title and bullet layout 1

Question 261 mark

Question

Make sure that your name, centre number and candidate number appear in the same position on all slides. [1]

Mark scheme

Candidate details in same position on all slides 1

Question 271 mark

Question

Format the first slide so that: • a title slide layout is applied with no bullets • the title and subtitle text are centre aligned and in the middle of the slide. [1]

Mark scheme

Slide 1 Layout title and subtitle in centre and middle with no bullet 1

Question 281 mark

Question

Change the layout of the slide with the title Our top performing students to a title with two placeholders side by side. [1]

Mark scheme

Change layout of slide Our top performing students to a title and two place holders 1

Question 295 marks

Question

Using the file m23markscomp.csv create a vertical bar chart to compare the average marks for each subject, except English, for girls and boys. Display: • the subject names in full on the category axis • the chart title Average marks compared • only the data values above each bar • a legend to identify the girls and boys. [5]

Mark scheme

Vertical bar chart created from correct data 1 mark 5 Category axis labels displayed in full 1 mark A legend is included girls / boys 1 mark Values on tops of bars 1 mark Chart has correct title 1 mark

Question 305 marks

Question

On the slide with the title Our top performing students place the chart you created in Step 29 in the right placeholder. Place the contents of the file m23prizes.csv in the left placeholder. Format the table as shown: [5]

Mark scheme

Chart placed on right and data from file as a table on left 1 mark 5 Format table with all gridlines visible 1 mark Text in top row of the table formatted centre aligned 1 mark Larger font 1 mark Text in all rows vertically aligned 1 mark

Question 3116 marks

Question

Print the slide with the title Our top performing students as a single full-page slide. Print all the slides as handouts with 2 slides to the page, each slide filling half the page. [2] [Total: 16]

Mark scheme

Print Our top performing students slide as full page 1 mark 2 Print the slides as handouts 2 to a page 1 mark TOTAL 16 Overall 70 total PUBLISHED Step 1 Evidence 1 File stemnews saved in format of software 1 mark Step 3 Evidence 2 ST-subhead style Style name correct based on normal 1 mark sans-serif, 14pt centre 1 mark all capitals, bold, single Ls, 0 before, 9 after 1 mark PUBLISHED Step 4 Evidence 3 Display styles: in manager ST-table and ST-bullet ST-table and ST-bullet as asgiven given 1 mark 1 mark PUBLISHED Step 5 Evidence 4 ST-title modified, name correct, based on normal / default 1 mark Step 18 Evidence 5 Tests.csv imported without the field English 1 mark All field names as given, correct data types 1 mark Ignore English if imported No ID field Set Registration_Code as the primary key 1 mark PUBLISHED Step 19 Evidence 6 Staff table - all field names as given, correct data types 1 mark Staff table - Class_Code set as primary key 1 mark Houses table - all field names as given, correct data types and correct primary key set 1 mark Step 21 Evidence 7 Create one-to-many relationships between the three tables 1 mark PUBLISHED Step 22 Evidence 8 Screenshot evidence of calculation count of records 1 mark Step 23 Evidence 9 Screenshot evidence of calculation of average on Maths field 1 mark Step 24 Evidence 10 File exported as PDF 1 mark … PDF saved as YEAR 5 1 mark PUBLISHED ST-title style applied to title text 1 mark ST-subtitle text entered 100% accurate 1 mark Sans-serif, 36pt, centred, bold, underlined, single, Supplied style ST-subtitle applied 1 mark 0pt before/after Change page layout from here to end to two columns 1 mark Two equal columns with 1 cm space 1 mark ST-subhead style applied to 7 subheadings and match EV2 1 mark ST-bullet style seen in EV3 and applied to correct text (square bullets aligned to left margin serif 11pt in single line spacing) 1 mark Footer page number left aligned, candidate details right aligned 1 mark PUBLISHED Import the correct image and place in correct paragraph 1 mark Reflect the image so that the flask is on the right 1 mark Resize the image to 2 centimetres high with aspect ratio maintained 1 mark Align top of text and left margin with text wrapped 1 mark Row 1–3 columns merged and text centred 1 mark Insert a new row above Chemistry 1 mark Enter data for Biology into this row 1 mark ST-table style seen in EV3, applied to rows 2 to 9 only 1 mark Serif, 11pt, italic, left, single, 0 before/after No data wrapped, gridlines fit within column, 6 pt space after table 1 mark Spellcheck and proofread the document 1 mark Document complete/paragraphs intact, landscape, styles retained, no widows/orphans, split list or table, columns balanced at top, consistent spacing, no blank pages PUBLISHED STEM Science Class for 2024 Family_Name Gender Teacher_Name Science Maths Computer_Science Design_Technology House_Name Class_Code Flynn F Bostock 99 69 61 94 Neptune 6B Abbott F Bostock 98 82 64 84 Jupiter 6B Hammond F Bostock 93 72 83 81 Neptune 6B Nelson F Bostock STEM92 Science Class 68 for 2024 95 -larger font size, top of93 page, fully visible 1 mark Neptune 6B Archer F Bostock Selects 91records where 87 Gender is 92F and Science mark is 98 80 or more 1 mark Jupiter 6B Hart F Bostock Class_Code 87 contains 88 6 95 92 1 mark Mars 6B Specified fields, correct order, headings match the data, displayed in full 1 mark Murphy F Bostock 82 62 69 93 Jupiter 6B Williamson F Bostock 81 80 78 69 Saturn 6B Watts F Lean 96 70 70 60 Mars 6L Pickering F Lean 96 79 88 64 Jupiter 6L Howells F Lean 96 65 60 91 Saturn 6L Kent F Lean 94 98 72 80 Neptune 6L White F Lean 93 90 82 78 Mars 6L Tomlinson F Lean Sort ascending91order of Teacher_Name 78 then descending order86 70 of Science 1 mark Mars 6L Allan F Lean 89 98 84 68 Saturn 6L Rowe F Lean 88 81 75 69 Mars 6L Thornton F Lean 87 65 64 93 Saturn 6L Whitehead F Lean 86 61 61 77 Jupiter 6L Crawford F Lean 86 69 Label left of calculated value 100% accurate Saturn 89 93 1 mark 6L Fuller F Lean 85 67 93 70 Jupiter 6L Turnbull F Lean 85 87 93 69 Mars 6L Connolly F Lean 84 67 87 70 Neptune 6L Harris edited Class_Code is now 6T 1 mark Townsend F Lean 83 90 87 69 Saturn 6L Joyce F Lean 82 88 89 81 Mars 6L Howarth F Lean 81 71 77 97 Neptune 6L Robson F Lean 80 90 60 76 Mars 6L Harris F Torville 98 99 82 61 Saturn 6T New science group size 27 Has a page orientation of landscape and fits on one page wide 1 mark Candidate name, centre number and candidate number Name, centre number and candidate number in page footer with no other items showing 1 mark PUBLISHED Title larger font, top of page, fully visible 1 mark Class_Code is 5C (i.e. teacher Cook-Abbott) 1 mark House_Name is Mars 1 mark Specified fields, correct order, headings match the data, displayed in full 1 mark Year Five Test Report for Mars Gender Family_Name Given_Name House_Name Maths Computer_Science Teacher_Name F Connor Madeleine Mars 68 79 Cook-Abbott F Harris Harriet Mars 83 65 Cook-Abbott F Kelly Laura Mars 65 77 Cook-Abbott F Power Amelia Mars 91 74 Cook-Abbott F Sykes Lydia Mars 97 75 Cook-Abbott M Bartlett Sebastian Mars 61 79 Cook-Abbott M Gibson Hayden Mars 62 82 Cook-Abbott M Hall Harvey Mars 67 81 Cook-Abbott M O'Sullivan Evan Mars 89 71 Cook-Abbott Average Maths Score 76 Data into ascending order of Gender 1 mark … then ascending order of Family_Name 1 mark Average Maths mark positioned below the Maths column 1 mark Display this value with no decimal places 1 mark Correct label to the left of this value 1 mark Name, centre number, candidate number Orientation is portrait and fits on a single page 1 mark PUBLISHED Vertical bar chart created as shown 1 mark Subject names in full on category axis 1 mark Legend to display Boys / Girls 1 mark Values on tops of bars 1 mark Title as shown 1 mark Slide layout title and 2 placeholders - chart on right and table on left 1 mark Table – text as given, all gridlines visible, no shading 1 mark Top row centre aligned horizontally 1 mark Top row larger font 1 mark Single slide printed 1 mark All rows centre aligned vertically 1 mark Rows 2-5 left aligned consistently 1 mark PUBLISHED Create a presentation of six slides in title and bullet layout 1 mark Candidate details same position on all slides 1 mark Slide 1 layout title and subtitle no bullet and centred on slide 1 mark PUBLISHED PUBLISHED Print all slides two per page as handouts 1 mark

Checked your answers against these? Let AI mark the whole paper, on your own working.

Mark my 0417/21

How this paper is marked

Examiners follow the generic marking principles at the front of the scheme, then each question's points: method (M), accuracy (A) and independent (B) marks, error carried forward where the scheme allows it, and positive marking, so you're credited for what you got right.

Check your answers against it

Done this paper? Upload your script and CIE Buddy's AI marker marks it question by question against this exact scheme, puts the ticks on your own working and says what each lost mark needed.

0417/21 in other series

Find another Information and Communication Technology paper

Every IGCSE Information and Communication Technology mark scheme

Question papers and mark schemes © Cambridge University Press & Assessment. CIE Buddy is independent and not connected to Cambridge.

0417/21 questions

Where can I find the 0417/21 February/March 2023 mark scheme?

On this page, free: the mark scheme for IGCSE Information and Communication Technology 0417/21, February/March 2023 (0417_m23_ms_21), and the question paper (0417_m23_qp_21), to read or download, with each question's marking points written out underneath.

How many marks is 0417/21 out of?

Information and Communication Technology 0417/21 for February/March 2023 is out of 70 marks, with 2 hours 15 minutes to answer it, across 3 questions.

Can I get my 0417/21 answers marked?

Yes. Upload your answers to 0417/21/F/M/23 as a PDF or photos, and CIE Buddy marks every question against this paper's official mark scheme, using Cambridge's marking rules. You get your score, each lost mark explained on your own script, and the topics to revise. It's a guide, not an official Cambridge grade.