Cambridge IGCSE: Information and Communication Technology 0417/21
Cambridge IGCSE: Information and Communication Technology 0417/21
Cambridge IGCSE: Information and Communication Technology 0417/21
com
Cambridge IGCSE™
2 hours 30 minutes
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) 203064/2
© UCLES 2021 [Turn over
www.dynamicpapers.com
2
J2121ATHLETE.csv
J2121CERT.rtf
J2121CHEER.wav
J2121DATA.csv
J2121EVENTS.csv
J2121EVIDENCE.rtf
J2121PARTAKE.csv
J2121RESULTS.csv
J2121SWIM.png
J2121TRI.rtf
J2121TRIATHLON.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 J2121EVIDENCE followed by your candidate number, for
example, J2121EVIDENCE9999
You will need your Evidence Document during the examination to place screenshots when required.
Task 2 – Document
You are going to edit a document to help organise a triathlon. A corporate house style must be used.
Three paragraph styles have already been created. An additional paragraph style must be created and
applied to the document as instructed.
The page setup is set to A4, portrait orientation with 2.5 centimetre margins. Do not make any
changes to these settings.
The TN-body style has been created, stored and applied to the body text in the document. Do not
make any changes to this.
Save the document in your work area, in the format of the software you are using, with the file
name EVPACK
EVIDENCE 1
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 Place in the header your name, centre number and candidate number right aligned.
5 Create and store the following style, basing it on the default paragraph style:
Font size (points)
Enhancement
Space before
Line spacing
Space after
Style name
Alignment
Font style
(points)
(points)
TN-title serif 34 centre bold, italic single 0 0
EVIDENCE 2
Place in your Evidence Document a screenshot to show that the style settings have
been defined for the TN-title style. Make sure this style is based on the default
paragraph style.
[3]
6 Select the subheading General and the following text up to and including the paragraph ending …
competitors in each category.
Change the page layout so that only this text is displayed in two columns of equal width with a
1.5 centimetre space between them.
[2]
8 The style name TN-subhead has already been created, stored and applied to the six subheadings.
Enhancement
Space before
Line spacing
Space after
Style name
Alignment
Font style
(points)
(points)
TN-subhead serif 18 centre italic, all capitals single 0 9
EVIDENCE 3
Place in your Evidence Document a screenshot of the amended settings for the
TN-subhead style.
[2]
9 Format the paragraph that starts This is an important part … so that it:
• is indented 1 centimetre from both the left and right hand margins
• displays an external 3 to 4 point black border.
[2]
Delete the entire column and contents with the heading Distance [1]
11 Format the table so that the left column looks like this:
Swim Wave
Details
[4]
13 Import the image J2121SWIM.png and place it in the paragraph beginning Please follow the Race
Director’s …
Save the document using the same file name and format used in step 1.
PRINTOUT 1
Make sure your name, centre number and candidate number are on your document.
[2]
[Total: 30]
Task 3 – Database
You are now going to prepare some reports. Dates are to be imported in the format of day month year.
EVIDENCE 4
Place in your Evidence Document screenshots showing the primary keys, field names
and data types used in all three tables.
[5]
EVIDENCE 5
Place in your Evidence Document screenshots showing the type of relationships
between the three tables.
[2]
Last_Name Lee
First_Name Sophia
Athlete_ID 15310
Nationality NZL
YOB 1982
Gender Female
18 In the results table, locate the record with Athlete_ID 15318 and Event_ID MX321085
Swim 00:19:38
T1 00:00:36
Position 1
PRINTOUT 2
Make sure that you have entered your name, centre number and candidate number
on your report.
[7]
© UCLES 2021 0417/21/M/J/21
www.dynamicpapers.com
9
PRINTOUT 3
Make sure that you have entered your name, centre number and candidate number
on your report.
EVIDENCE 6
Place in your Evidence Document a screenshot showing the database formula used to
calculate the total number of competitors.
[12]
[Total: 29]
21 Create a mail merge document using the file J2121CERT.rtf as the master document and
J2121DATA.csv as your data source file.
Enter your name, centre number and candidate number in the footer of the document.
[1]
22 Replace the text and chevrons in the master document with the merge fields from the data source
file as follows:
Replace <DATE> with a field to display today’s date in the format dddd, dd MMMM yyyy
Make sure the spacing, punctuation, alignment and enhancements in the original master document
are maintained.
Save and print your master document showing the merge field codes.
EVIDENCE 7
Take screenshot evidence of the date field code showing the dddd, dd MMMM yyyy
format used. Place this screenshot in your Evidence Document.
PRINTOUT 4
Make sure you have entered your name, centre number and candidate number on
your master document.
[5]
EVIDENCE 8
Place in your Evidence Document a screenshot to show the use of an automated
selection method.
[1]
24 Merge and print the certificates for the selected competitors only.
PRINTOUT 5
Print the result of the merge. Make sure you have entered your name, centre number
and candidate number on your certificates.
[1]
[Total: 8]
Task 5 – Presentation
All slides must have a consistent layout and formatting. Unless otherwise instructed, slides must be
formatted to display a title and bulleted list.
On slide 1 enter your name after the text Overview presented by:
[1]
27 Delete the slides with the titles History of Triathlons and Super Sprint Triathlon [1]
28 Use the data in the file J2121PARTAKE.csv to create a pie chart to compare participation by age
group for Triathlon only. [1]
29 Label the chart with the title: Triathlon registrations by age [1]
30 Format the chart to display only percentages and age groups as sector labels.
31 Emphasise the age group with the largest percentage by pulling only this sector away from the
other age groups. [1]
32 Place the chart to the left of the bullets on the slide with the title Market Analysis
33 Apply the sound file J2121CHEER.wav to the slide with the title Ironman Triathlon so the sound
plays automatically as the slide appears.
EVIDENCE 9
Place in your Evidence Document screenshot(s) to show the sound is set to play
automatically as the slide appears.
[2]
Print slides 1, 2, 3 and 4 only as handouts with 2 slides to the page, each slide filling half the page.
PRINTOUT 6
Print this handout. Make sure your name, centre number and candidate number are
on all slides.
[1]
[Total: 13]
PRINTOUT 7
Make sure that your name, centre number and candidate number appear on every
page of your Evidence Document.
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 the Cambridge Assessment Group. Cambridge Assessment is the brand name of the University of
Cambridge Local Examinations Syndicate (UCLES), which itself is a department of the University of Cambridge.