Cambridge IGCSE™: Information and Communication Technology 0417/22 May/June 2021
Cambridge IGCSE™: Information and Communication Technology 0417/22 May/June 2021
Cambridge IGCSE™: Information and Communication Technology 0417/22 May/June 2021
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 2021 series for most Cambridge
IGCSE™, Cambridge International A and AS Level components and some Cambridge O Level components.
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.
• 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.
Marks awarded are always whole marks (not half marks, or other fractions).
• 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.
Rules must be applied consistently, e.g. in situations where candidates have not followed
instructions or in the application of generic level descriptors.
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).
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.
EVIDENCE DOCUMENT
Step 1 – EVIDENCE 1
Top, bottom, left and right margins set to
2 centimetres 1 mark
Step 2 – EVIDENCE 2
File saved as MSREVIEW with evidence of correct file
type 1 mark
Step 4 – EVIDENCE 3
MS-subhead
MS-subhead style created, named correctly, based on Normal/Default 1 mark
Sans-serif 18pt, centre, bold, underline, single, 0pt before 9pt after 1 mark
Step 6 – EVIDENCE 4
Step 19 – EVIDENCE 5
DB table structures
J2122DUATHLON - all field names, data types as given 1 mark
J2122CATEGORIES and J2122OUTCOMES - all field names,
data types as given 1 mark
Primary keys set on Race Number, Cat Code, Stat Code 1 mark
Step 20 – EVIDENCE 6
1-to-Many relationships:
Cat_Code categories table and Cat_Code duathlon table
Stat_Code outcomes table and Stat_Code duathlon table 1 mark
Step 23 – EVIDENCE 7
Database formula to calculate the number of athletes
1 mark
Step 24 – EVIDENCE 8
Report 2 exported in pdf format, outcome with file type 1 mark
… exported report saved as SENIOR 1 mark
Step 26 – EVIDENCE 9
Step 27 – EVIDENCE 10
Selectcandidate
Name, centre number, recordsnumber
(42): Specified fields, correct order 1 mark
of 2
Nationality is GBR or IRL 1 mark Landscape, tabular, one page wide, all base fields 1 mark
Gender is Male 1 mark Fields adjusted to fit, no truncation on any field 1 mark
YOB is >=1982 and <=2001 1 mark Sort ascending on Nationality, descending Position 1 mark
© UCLES 2021 Page 9 of 17
0417/22 Cambridge IGCSE – Mark Scheme May/June 2021
PUBLISHED
First_Name Last_Name Nationality Gender YOB Athlete_Age Run_1 T_1 Bike T_2 Run_2 Total_Time Position
Hayden Porter GBR Male 1991 30 00:30:02 00:01:31 00:55:59 00:02:18 00:18:36 01:48:26 90
David Trevelyan GBR Male 1989 32 00:31:26 00:01:32 00:52:18 00:02:01 00:18:42 01:45:59 68
Walter Ruston GBR Male 1988 33 00:30:51 00:01:43 00:53:03 00:01:50 00:18:31 01:45:58 67
Graham Boardman GBR Male 1982 39 00:31:26 00:01:33 00:51:29 00:02:06 00:19:21 01:45:55 66
Dean Cheshire GBR Male 1984 37 00:29:40 00:01:20 00:52:50 00:01:58 00:18:20 01:44:08 53
Alexander Bowen GBR Male 1985 36 00:27:53 00:00:43 00:53:42 00:00:45 00:14:04 01:37:07 8
Dylan Flanagan IRL Male 2001 20 00:42:38 00:02:17 01:14:39 00:03:03 00:30:28 02:33:05 850
Reece Delaney IRL Male 2001 20 00:40:07 00:07:05 01:04:55 00:02:01 00:20:36 02:14:44 566
Killian Callaghan IRL Male 1982 39 00:4 2:02 00:02:19 01:00:55 00:03:13 00:25:51 02:14:20 556
New record Dean Cheshire, inserted only once, does
Eugene Tierney IRL Male 1982
not replace record Graham Boardman 39 00:37:00
1 mark 00:02:03 00:58:26 00:02:37 00:23:15 02:03:21 321
Flynn McCarthy NewIRL record 100%Male 1984
accurate 37 00:36:24
1 mark 00:01:40 01:04:24 00:01:42 00:17:58 02:02:08 289
Eamon Murphy IRL Male 1991 30 00:38:12 00:01:12 01:01:37 00:01:39 00:19:02 02:01:42 279
Aidan Donoghue IRL Male 2000 21 00:34:06 00:01:46 00:57:16 00:02:32 00:20:25 01:56:05 182
Liam Shanahan IRL Male 1993 28 00:31:10 00:01:41 00:55:50 00:01:58 00:20:36 01:51:15 107
Shane Rafferty IRL Male 1990 31 00:32:24 00:01:32 00:52:35 00:02:20 00:19:45 01:48:36 92
Colm Doyle IRL Male 1996 25 00:30:01 00:00:46 01:00:13 00:00:47 00:15:33 01:47:20 80
Ronan Byrne IRL Male 1986 35 00:32:06 00:01:28 00:50:56 00:02:18 00:19:23 01:46:11 69
Shane Donnelly IRL Male 1987 34 00:29:05 00:01:21 00:50:33 00:01:52 00:17:53 01:40:44 27
Number of athletes 42
Calculates correct number of athletes, positioned end of report, integer display 1 mark
Label 100% accurate, left of value 1 mark
Presentation complete - slides imported, title/bullet layout, no blank slides/no text changed,
Name, centre number, candidate number in footer on every slide 1 mark
All slides printed with 2 slides to page, each filling half page 1 mark
Correct 3 original lines indented, consistent bullets and left aligned 1 mark
3 lines smaller font size, italic, with dashed, -, bullets 1 mark