Cambridge IGCSE™

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/22

Paper 2 Document Production, Data Manipulation and Presentations May/June 2020

2 hours 30 minutes

You will need: Candidate source files (listed on page 2)

* 8 9 8 3 8 4 9 2 9 3 *

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 [ ].

This document has 16 pages. Blank pages are indicated.

DC (CJ) 189616/3
© UCLES 2020 [Turn over
 2

You have been supplied with the following source files:

J220BIKE.jpg
J220BIKEPACK.rtf
J220BOOK.rtf
J220CLUBS.csv
J220EVIDENCE.rtf
J220RAAM.rtf
J220RESULTS.csv
J220SPEED.csv
J220TOURS.csv

Task 1 – Evidence Document

Open the file J220EVIDENCE.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 J220EVIDENCE followed by your candidate number, for
example: J220EVIDENCE9999

You will need to place screenshots in this Evidence Document.

Task 2 – Document

You are going to edit a report. The company uses a corporate house style for all its documents. One
paragraph style has been created and applied. Additional paragraph styles must be created and
applied to the report as instructed.

1 Open the file J220BIKEPACK.rtf

The page setup is set to A4, landscape orientation with 2 centimetre margins. Do not make any
changes to these settings.
Save the document in your work area, in the format of the software you are using, with the file
name BPGUIDE

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]

2 Remove any pre-set page breaks in the document. [1]

© UCLES 2020 0417/22/M/J/20

 3

3 Place in the footer:

• 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 or placeholders are included in the header or footer areas
• footers are displayed on all pages.
[1]

4 Create and store the following styles, basing each on the default paragraph style:

House style specifications

Font size (points)

Enhancement

Space before
Line spacing

Space after
Style name

Alignment
Font style

(points)

(points)
BP-Subtitle sans-serif 20 right italic single 0 0
BP-Subhead serif 18 centre bold, underline single 0 9
justified with a
BP-Body sans-serif 11 first line indent none single 0 6
of 1.5 cm
BP-Table serif 10 centre italic single 0 0

EVIDENCE 2
Place in your Evidence Document a screenshot to show that the style settings have been
defined for the BP-Body style. Make sure this style is based on the default paragraph
style.
[3]

5 Display these custom style names as a list in the style manager/organiser. Provide screenshot
evidence of this list.

EVIDENCE 3
Place this screenshot in your Evidence Document.
[1]

© UCLES 2020 0417/22/M/J/20 [Turn over

 4

6 The style name BP-Title has already been created, stored and applied to the title text.
Modify the BP-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)
BP-Title serif 34 centre bold, italic single 0 0

EVIDENCE 4
Place in your Evidence Document a screenshot of these style settings for the BP-Title
style.
[2]

7 Below the title add the subtitle:

Produced by: and add your name
Apply the BP-Subtitle style to this text.
[2]

8 Apply the BP-Body style to the rest of the document. [1]

9 Apply tick-shaped bullets (3) to the text from:

full course must be completed …
to
… and observe local laws.
Make sure that:
• the bullets are indented 1.5 centimetres from the left margin with a hanging indent
applied if text wraps to a second line
• the list is in single line spacing with no space between the lines
• there is a 6 point space after the last item in the list.
[3]

10 Identify the 5 subheadings in the document and apply the BP-Subhead style to each one. [1]

11 Locate the table in the document.

Delete the entire column with the heading Time Limit
[1]

12 Change the page layout so that the subheading Racing and all following text is displayed in two
columns of equal width with a 2 centimetre space between the columns. [2]

© UCLES 2020 0417/22/M/J/20

 5

13 Format the table so that:

• the border and all data fit within the column width
• the BP-Table style is applied to all data
• text in all rows is centre aligned vertically
• no words are split where text is wrapped within the table
• all internal and external gridlines are displayed when printed
• there is no cell shading
• there is a 6 point space after the table.
[3]

14 Sort the data in the table into descending order of KM. [1]

15 Insert a new row as the first row of the table and enter the title:
Popular Distance Bikepacking Races
[2]

16 Format the first row of the table to be:

• bold
• centre aligned over the four columns.
[2]

17 Import the image J220BIKE.jpg and place it in the paragraph beginning Conventional cycle touring …
Rotate the image 180 degrees.
Format the image so that:
• it is resized to a width of 4 centimetres with the aspect ratio maintained
• it is aligned to the right of the column and top of the paragraph starting Conventional
cycle touring …
• the text wraps round the image.
[4]

© UCLES 2020 0417/22/M/J/20 [Turn over

 6

18 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
• spacing is consistent between all items.

Save the document using the same file name and format used in Step 1.

Print the document.

PRINTOUT 1
Make sure your name, centre number and candidate number are on your report.
[1]

[Total: 32]

© UCLES 2020 0417/22/M/J/20

 7

Task 3 – Database

You are now going to prepare some reports. Dates are to be imported in the format of day month year.

19 Using a suitable database package, import the file J220RESULTS.csv

Use these field names and data types:

Field name Data type Format

Racer_ID Text
Last_Name Text
First_Name Text
Club_Code Text
Birth_Date Date/Time
Age_Jan Number Integer
Avg_MPH Number Store and display to 2 decimal places
Event_Rank Number Integer
Points Number Integer
Racing_No Number Integer
Penalty Boolean/Logical To display as Yes/No
Category Text
Year_Band Text
Ability Text
Gender Text

Set Racer_ID as a primary key.

Save the data.

EVIDENCE 5
Place in your Evidence Document a screenshot showing the primary key, field names
and data types used in the table.
[2]

20 Import the file J220CLUBS.csv as a new table in your database.

Set Club_ID as a primary key.
Create a one-to-many relationship between Club_ID in the clubs table and Club_Code in the
results table.

EVIDENCE 6
Place in your Evidence Document screenshot(s) showing the type of relationship
between the two tables.
[1]
© UCLES 2020 0417/22/M/J/20 [Turn over
 8

21 Enter the following details as a new record in the results table:

Racer_ID XC0235
Last_Name Olsen
First_Name Janet
Club_Code MTBC10
Birth_Date 12/02/1991
Age_Jan 28
Avg_MPH 13.67
Event_Rank 6
Points 105
Racing_No 1550
Penalty Yes
Category Senior
Year_Band 19 to 29
Ability Expert
Gender Female

Check your data entry for errors.

Save the data. [2]

© UCLES 2020 0417/22/M/J/20

 9

22 Using fields from both tables produce a tabular report that:

• selects the records where:
– Event_Rank is 5 or less
– Ability does not include Novice
• shows only the fields:
First_Name, Last_Name, Club_Name, Category, Gender and Event_Rank
in this order, with data and labels displayed in full. Do not group the data.
• sorts the data into descending order of Category and ascending order of Event_Rank
• has a page orientation of portrait
• fits on a single page wide
• includes only the text Results By Category as a title displayed in a larger font size, fully
visible, at the top of the page
• calculates the number of racers and places this under the Gender column, formatted as
an integer
• has a label Number of racers to the left of this value
• has only your name, centre number and candidate number in the footer of the report so
it appears on every page.

Save and print your report.

PRINTOUT 2
Make sure that you have entered your name, centre number and candidate number
on your report.

EVIDENCE 7
Place in your Evidence Document a screenshot of the formula used in the database to
calculate the number of racers.
[11]

© UCLES 2020 0417/22/M/J/20 [Turn over

 10

23 Using fields from both tables, produce a tabular report that:

• selects the records where:
– Location includes the text East
– Category is Senior
– Penalty is Yes
• contains a new field called Revised_MPH which is calculated at run-time, using the data
from the Avg_MPH field and reducing this by 5%. Format this field to display 2 decimal
places
• shows only the following 9 fields:
First_Name, Last_Name, Club_Name, Location, Category, Event_Rank, Penalty,
Avg_MPH and Revised_MPH
in this order with data and labels displayed in full. Do not group the data.
• sorts the data into descending order of Avg_MPH
• has a page orientation of landscape
• fits on a single page
• includes only the text Speed Penalties Applied as a title at the top of the page, formatted
so that it displays:
‒ in a black, 30 point, serif font style
‒ with all letters fully visible
• has your name, centre number and candidate number on the report.

Save and print your report.

PRINTOUT 3
Make sure that you have entered your name, centre number and candidate number
on your report.

Export this report to your work area:

• in rich text format (rtf)
• with the file name SPA

EVIDENCE 8
Place in your Evidence Document a screenshot to show the exported file saved in your
work area. Make sure there is evidence of the file type.
[11]

[Total: 27]

© UCLES 2020 0417/22/M/J/20

 11

Task 4 – Mail merge

You are required to carry out a mail merge.

24 Create a mail merge letter using the file J220BOOK.rtf as the master document and
J220TOURS.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

<TTL> Title
<LAST> Last_Name
<ADD1> Street
<ADD2> Town
<POST> Postcode
<HOLIDAY> Tour_Name
<LOCATION> Region
<LENGTH> Distance
<SIZE> People
<LEAVE> Departure
<DURATION> Duration
<COST> Price_PP

Make sure the spacing, punctuation and alignment in the original master document are maintained.
[3]

25 Replace the text Candidate Name with your name.

Enter your name, centre number and candidate number in the header of the document.
Save and print your master document.

PRINTOUT 4
Make sure you have entered your name, centre number and candidate number on
your master document.
[1]

26 Set an automated filter to select people who are booking for a Duration of 4 or less

EVIDENCE 9
Place in your Evidence Document a screenshot to show the use of an automated
selection method.
[1]

© UCLES 2020 0417/22/M/J/20 [Turn over

 12

27 Merge and print the letters for the selected people only.
Save and close the files.

PRINTOUT 5
Print the result of the merge. Make sure you have entered your name, centre number
and candidate number on your letters.
[1]

[Total: 6]

Task 5 – Printing the Evidence Document

28 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 6 – Presentation

You are going to create a short presentation.

All slides must have a consistent layout and formatting. Unless otherwise instructed, slides must be
formatted to display a title and bulleted list.

29 Create a presentation of 6 slides using the file J220RAAM.rtf

On slide 1 enter your name after the text Presented by:
[1]

30 Format the first slide so that:

• a title slide layout is applied with no bullets
• the title and subtitle text are centred in the middle of the slide.
[1]

31 Use a master slide to display only the following features:

• your name, centre number and candidate number
• automated slide numbers on the bottom left.
Make sure that:
• master slide items appear in the same position on every slide
• there is no overlap on any slide.
[2]

32 Move the slide with the title Background so that it becomes slide 2. [1]

© UCLES 2020 0417/22/M/J/20

 13

33 Use the data in the file J220SPEED.csv to create a line chart to compare the records for each
year for Solo Female and Solo Male racers only. Include the years as category axis labels. [1]

34 Label the chart with the title:

Solo Average Speed Records [1]

35 Format the value axis to display:

• the label Miles Per Hour
• a minimum value of 6
• a maximum value of 22
• increments of 4
[3]

36 Format the chart to display:

• only the data values as labels displayed to 2 decimal places above each data point
• a legend to display Solo Female and Solo Male
[3]

37 Place the chart to the left of the bullets on the slide with the title Completion Records
Make sure that all data is fully visible with no overlap.
[1]

38 Save the presentation.

Print the presentation as handouts with 2 slides to the page, each filling half the page.

PRINTOUT 7
Print this handout. Make sure your name, centre number and candidate number are
on all slides.
[1]

[Total: 15]

© UCLES 2020 0417/22/M/J/20

 14

BLANK PAGE

© UCLES 2020 0417/22/M/J/20

 15

BLANK PAGE

© UCLES 2020 0417/22/M/J/20

 16

BLANK PAGE

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.

© UCLES 2020 0417/22/M/J/20

 Cambridge IGCSE™

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/02

Paper 2 Document Production, Data Manipulation and Presentations October/November 2020

2 hours 30 minutes

You will need: Candidate source files (listed on page 2)

* 6 6 7 1 5 1 8 5 9 3 *

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 [ ].

This document has 16 pages. Blank pages are indicated.

DC (CJ) 189620/3
© UCLES 2020 [Turn over
 2

You have been supplied with the following source files:

N220CLUB.csv
N220EVENT.rtf
N220EVIDENCE.rtf
N220GROUP.csv
N220LOGO.jpg
N220RANK.rtf
N220REGS.rtf
N220SCORE.csv
N220SPONSOR.rtf

Task 1 – Evidence Document

Open the file N220EVIDENCE.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 N220EVIDENCE followed by your candidate number, for
example: N220EVIDENCE9999

You will need to place screenshots in this Evidence Document.

Task 2 – Document

You are going to edit an information sheet. The company uses a corporate house style for all its
documents. Two paragraph styles have already been created. Additional paragraph styles must be
created and applied to the information sheet as instructed.

1 Open the file N220EVENT.rtf

The page setup is set to A4, landscape orientation with 2 centimetre margins. Do not make any
changes to these settings.

Save the document in your work area, in the format of the software you are using, with the file
name RWDETAILS

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]

2 Place in the header your name, centre number and candidate number, centre-aligned.

Place in the footer automated page numbers, right-aligned.

Make sure that:

• all the alignments match the page margins
• no other text or placeholders are included in the header and footer areas
• headers and footers are displayed on all pages.
[2]
© UCLES 2020 0417/02/O/N/20
 3

3 At the start of the document enter the title:

Tawara MTB Marathon Race [1]

4 Create and store the following styles, basing each on the default paragraph style:

House style specification

Font size (points)

Enhancement

Space before
Line spacing

Space after
Style name

Alignment
Font style

(points)

(points)
RW-Title serif 36 centre bold, italic single 0 0
RW-Subtitle sans-serif 20 right underline single 0 0
RW-Subhead serif 18 centre bold, underline single 0 8

EVIDENCE 2
Place in your Evidence Document a screenshot to show that the style settings have
been defined for the RW-Subhead style.
[2]

5 Display these custom style names as a list in the style manager/organiser. Provide screenshot
evidence of this list.

EVIDENCE 3
Place this screenshot in your Evidence Document.
[1]

6 The style RW-Body has already been created, stored and applied to the document text. Modify
this style so only the following formatting is applied:
Font size (points)

Enhancement

Space before
Line spacing

Space after
Style name

Alignment
Font style

(points)

(points)

RW-Body sans-serif 10 justified none single 0 9

EVIDENCE 4
Place in your Evidence Document a screenshot of these style settings for the RW-Body
style.
[2]

© UCLES 2020 0417/02/O/N/20 [Turn over

 4

7 Apply the RW-Title style to the title text entered at Step 3. [1]

8 Enter your name immediately after the subtitle Event details by:

Apply the RW-Subtitle style to this line of text.

[1]

9 Change the page layout so that the subheading Event Format and all following text is displayed in
2 columns of equal width with a 2 centimetre space between the columns. [2]

10 Apply bullets to the list from:

Vipers …
to
… under 8

Make sure that:

• the bullets are indented 2.5 centimetres from the left margin
• the list is in single line spacing with no space between the lines
• there is a 9 point space after the last item in the list.
[2]

11 Identify the 6 subheadings in the document and apply the RW-Subhead style to each one. [1]

12 Locate the table in the document.

Apply the RW-Table style to the table.

[1]

13 Delete the entire row for the Novice Pairs category. [1]

14 Edit the table so that it looks like this:

Entry Options
Category Age Max Riders Notes
Solo 18+ More experienced riders. Only pit
crew and other riders for company.
1
Must be able to perform well
Solo Veteran 40+
without any sleep.
Relay format, riding shared. Pair
Pairs 18+ 2 decide team tactics and how many
laps each rider completes.
Relay format with men, women and
Team Open 18+ 4 mixed teams. Spreads the load,
requires strategy and planning.
Combined age 170+ for 4 riders,
Team Veterans 40+ 5
210+ for 5 riders.
Up to 8 riders in relay format. Less
Easy Rider 16+ 8 demanding for individuals. Suits
work groups or clubs.
[5]

© UCLES 2020 0417/02/O/N/20

 5

15 Format only the first row of the table so it:

• has a white 14 point sans-serif font
• is bold and italic
• has a black background.
[3]

16 Make sure:
• the table borders and all data fit within the column width
• no words are split where text is wrapped in column 4
• all internal and external gridlines are displayed when printed
• there is a 9 point space after the table.
[2]

17 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
• spacing is consistent between all items.

Save the document using the same file name and format used in Step 1.

Print the document.

PRINTOUT 1
Make sure your name, centre number and candidate number are on your document.
[1]

[Total: 29]

© UCLES 2020 0417/02/O/N/20 [Turn over

 6

Task 3 – Database

You are now going to prepare some reports.

18 Using a suitable database package, import the file N220SCORE.csv

Use these field names and data types:

Field name Data type Format

Last_Name Text
First_Name Text
Club_Code Text
Age Number Integer
KM_Hour Number 2 decimal places
Position Number Integer
Score Number Integer
Race_No Number Integer
Cat_Code Text
Distance_KM Number Integer

Set Race_No as a primary key.

Save the data.

[2]

19 Import the file N220CLUB.csv as a new table in your database with all fields set with appropriate
data types.

Set the Club_Code field as a primary key.

[1]

20 Import the file N220GROUP.csv as a new table in your database with all fields set with appropriate
data types.

Set the Group_Code field as a primary key.

EVIDENCE 5
Place in your Evidence Document screenshots showing the primary keys, field names
and data types used in all three tables.
[1]

© UCLES 2020 0417/02/O/N/20

 7

21 Create one-to-many relationships as links between the:

• Club_Code field in the club table and the Club_Code field in the score table
• Group_Code field in the group table and the Cat_Code field in the score table.

EVIDENCE 6
Place in your Evidence Document screenshot(s) showing the type of relationships
between the three tables.
[2]

22 Enter the following details as a new record in the score table:

Last_Name Flater
First_Name Susan
Club_Code EPE12
Age 24
KM_Hour 4.05
Position 2
Score 125
Race_No 1476
Cat_Code FE
Distance_KM 50

Check your data entry for errors.

Save the data.

[2]

© UCLES 2020 0417/02/O/N/20 [Turn over

 8

23 Using fields from all tables, produce a tabular report that:

• contains a new field called Total_Time which is calculated at run-time. This field will
multiply the KM_Hour by Distance_KM and divide this by 1440. Format this field to
display time as hh:mm:ss
• selects the records where:
– Club_Name includes the text MTB
– Age is 20 or more
– Distance_KM is 50 or 75
• shows only the following fields:
Last_Name, First_Name, Gender, Age, Race_No, KM_Hour, Distance_KM, Club_Name,
Position and Total_Time
in this order with data and labels displayed in full. Do not group the data
• sorts the data into ascending order of Club_Name and ascending order of Position
• has a page orientation of landscape
• fits on a single page wide
• includes only the text MTB Marathon Results as a title at the top of the page, formatted
so that it displays:
– in a black, 30 point, serif font style
– with all letters fully visible
• has only your name, centre number and candidate number in the footer of the report so
it appears on every page.

Save and print your report.

PRINTOUT 2
Make sure that you have entered your name, centre number and candidate number
on your report.
[12]

© UCLES 2020 0417/02/O/N/20

 9

24 Using fields from the score and club tables produce a tabular report that:
• selects the records where:
– Position is 1
– County does not include Kent
• shows only the 6 fields:
Position, First_Name, Last_Name, Club_Name, County and Distance_KM
in this order, with data and labels displayed in full. Do not group the data
• sorts the data into descending order of County
• has a page orientation of portrait
• fits on a single page
• includes only the text Winning Club Members as a title displayed in a larger font size,
fully visible, at the top of the page
• calculates the average distance and positions this under the Distance_KM column,
formatted as an integer
• has a label Average race distance to the left of this value
• has your name, centre number and candidate number on the report.

Save and print your report.

PRINTOUT 3
Make sure that you have entered your name, centre number and candidate number
on your report.

EVIDENCE 7
Place in your Evidence Document a screenshot of the formula used in the database to
calculate the average distance.
[10]

25 Export the report created in Step 24 in portable document format (pdf).

Save the exported file with an appropriate file name in your work area.

EVIDENCE 8
Place in your Evidence Document a screenshot to show the exported file saved in your
work area. Make sure there is evidence of the file type.
[1]

[Total: 31]

© UCLES 2020 0417/02/O/N/20 [Turn over

 10

Task 4 – Mail merge

You are required to carry out a mail merge.

26 Create a mail merge letter using the file N220SPONSOR.rtf as the master document and
N220RANK.rtf 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

<FIRST> First_Name
<FAMILY> Last_Name
<ADD1> Street
<ADD2> Town
<POST> Postcode
<FINISH> Rank
<FUND> Bursary
<AGREE> Condition
<CN> Club_Name
<AREA> District
<BIB> Race_No
<YB> Year_Band
<CAT> Category

Make sure the spacing, punctuation, alignment and enhancements in the original master document
are maintained.
[4]

27 Replace the text Candidate Name with your name.

Enter your name, centre number and candidate number in the footer of the document.

Save and print your master document.

PRINTOUT 4
Make sure you have entered your name, centre number and candidate number on
your master document.
[1]

© UCLES 2020 0417/02/O/N/20

 11

28 Set an automated filter to select riders who have a rank of 3 or less.

EVIDENCE 9
Place in your Evidence Document a screenshot to show the use of an automated
selection method.
[1]

29 Merge and print the letters for the selected riders only.
Save and close the files.

PRINTOUT 5
Print the result of the merge. Make sure you have entered your name, centre number
and candidate number on your letters.
[1]

[Total: 7]

© UCLES 2020 0417/02/O/N/20 [Turn over

 12

Task 5 – 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 6 – Presentation

You are going to create a short presentation.

All slides must have a consistent layout and formatting. Unless otherwise instructed, slides must be
formatted to display a title and bulleted list.

30 Create a presentation of 5 slides using the file N220REGS.rtf

Use a master slide to display only the following features:
• your name, centre number and candidate number in the bottom left corner
• the club logo, which is saved as N220LOGO.jpg in the source files, positioned in the top
left corner, resized to a width of 3 centimetres with aspect ratio maintained
• automated slide numbers on the top right of every slide.

Make sure that:

• master slide items appear in the same position on every slide
• there is no overlap on any slide.
[4]

31 Insert a new slide as slide 1 and format this slide so that:

• a title slide layout is applied with no bullets
• the title and subtitle text are centred in the middle of the slide.
[1]

32 Enter the text Tawara MTB 2020 Race as a title on slide 1.

Enter the text Presented by: followed by your name as a subtitle on slide 1.
[2]

© UCLES 2020 0417/02/O/N/20

 13

33 On the slide with the title The Course locate the 3 items:
• one arrow – Straight Ahead Slow
• two arrows – Caution – Dangerous Situation
• three arrows – Serious Hazard – Extreme Caution

Format these 3 items to look like this:

• potentially dangerous situations marked by down pointing arrows:

— one arrow — Straight Ahead Slow
— two arrows — Caution — Dangerous Situation
— three arrows — Serious Hazard — Extreme Caution
• road sections are not closed to traffic
[3]

34 Add the following text as presenter/speaker notes to the slide with the title The Course:

Motorbikes and cars will be using the course too – please take extreme care.

Print only this slide as presenter/speaker notes.

PRINTOUT 7
Make sure your name, centre number and candidate number are on this slide.
[2]

35 Save the presentation.

Print the presentation as handouts with 2 slides to the page, each filling half the page.

PRINTOUT 8
Make sure your name, centre number and candidate number are on all slides.
[1]

[Total: 13]

© UCLES 2020 0417/02/O/N/20

 14

BLANK PAGE

© UCLES 2020 0417/02/O/N/20

 15

BLANK PAGE

© UCLES 2020 0417/02/O/N/20

 16

BLANK PAGE

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.

© UCLES 2020 0417/02/O/N/20

 Cambridge IGCSE™

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/22

Paper 2 Document Production, Data Manipulation and Presentations May/June 2021

2 hours 30 minutes

You will need: Candidate source files (listed on page 2)

* 4 4 5 6 4 7 3 9 4 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 [ ].

This document has 12 pages.

DC (CJ) 203063/2
© UCLES 2021 [Turn over
 2

You have been supplied with the following source files:

J2122CATEGORIES.csv
J2122COMPARE.csv
J2122DUATHLON.csv
J2122EVIDENCE.rtf
J2122MULTI.rtf
J2122OUTCOMES.csv
J2122RULES.rtf
J2122SKI.jpg
J2122TABLE.csv
J2122VIOLATIONS.csv
J2122VOUCHER.rtf

Task 1 – Evidence Document

Open the file J2122EVIDENCE.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 J2122EVIDENCE followed by your candidate number, for
example, J2122EVIDENCE9999

You will need your Evidence Document during the examination to place screenshots when required.

Task 2 – Document

You are going to edit a review document. A corporate house style must be used. Two paragraph styles
have already been created. An additional paragraph style must be created and applied to the document
as instructed.

1 Open the file J2122MULTI.rtf

Set the top, bottom, left and right margins to 2 centimetres.

The page setup is set to A4, portrait orientation. Do not make any changes to these settings.

The MS-body style has been created, stored and applied to the body text in the document. Do not
make any changes to this.

EVIDENCE 1
Take a screenshot to show the margin settings. Place this in your Evidence Document.
[1]

2 Save the document in your work area, in the format of the software you are using, with the file
name MSREVIEW

EVIDENCE 2
Place in your Evidence Document a screenshot to show this file has been saved. Make
sure there is evidence of the file type.
[1]

© UCLES 2021 0417/22/M/J/21

 3

3 Place in the header the text Created by: followed by a space and your name, centre number and
candidate number left aligned.
Place in the footer automated page numbers right aligned.
Make sure that:
• all alignments match the page margins
• no other text or placeholders are included in the header or footer areas
• headers and footers are displayed on all pages.
[3]

4 Create and store the following style, basing it on the default paragraph style:

Enhancement

Space before
Line spacing

Space after
Style name

Alignment
Font style

Font size
(points)

(points)

(points)
MS-subhead sans-serif 18 centre bold, underline single 0 9

EVIDENCE 3
Place in your Evidence Document a screenshot to show that the style settings have been
defined for the MS-subhead style. Make sure this style is based on the default paragraph
style.
[2]

5 At the start of the document enter the title:

Multisport Review [1]

6 The style name MS-title has already been created and stored.
Modify the MS-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)

MS-title serif 18 centre bold, italic single 0 0

EVIDENCE 4
Place in your Evidence Document a screenshot of these style settings for the MS-title
style.
[1]

© UCLES 2021 0417/22/M/J/21 [Turn over

 4

7 Apply the amended MS-title style to the title text entered at step 5. [1]

8 Locate and move the paragraph:

Triathlon is an endurance contest … taking up the sport.
so that it appears as a new paragraph immediately after the subheading Triathlon
[1]

9 Change the page layout so that the subheading General Participation and all following text is
displayed in two columns of equal width with a 1 centimetre space between the columns. [2]

10 Apply square bullets to the text from

warmer winter …
to
… avalanche and landslides.
Make sure that:
• the bullets are aligned at 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.
[3]

11 Identify the five subheadings in the document and apply the MS-subhead style to each one. [1]

12 Using the data in the file J2122COMPARE.csv create a vertical bar chart to compare entries by
gender for only the categories that contain duathlon or triathlon. [1]

13 Label the chart with the title:

Comparison of Participation [1]

14 Display the following:

• percentage numbers only as data labels along the top of each bar
• a legend showing Men and Women
[2]

15 Format the value axis scale to display a:

• minimum value of 0%
• maximum value of 100%
[1]

© UCLES 2021 0417/22/M/J/21

 5

16 Insert the chart after the paragraph ending … are more unpopular with women.
Make sure that:
• the chart and all data fits within the column width
• all data labels are displayed in full with no overlap.
[1]

17 Import the image J2122SKI.jpg and place it in the paragraph beginning The running is
contested …
Crop the image to remove only the bottom third (i.e. most of the snow below the skiers).
Format the cropped image so that:
• it is resized to a width of 4 centimetres with no distortion
• it is aligned to the left of the column and top of the paragraph starting The running is
contested …
• the text wraps around the image.
[4]

18 Spell check and proofread the document.

Make sure that:
• the list and chart are not split over columns or pages
• there are no widows or orphans
• there are no blank pages
• styles are applied consistently
• no changes have been made to the MS-body style
• spacing is consistent between all items.

Save the document using the same file name and format used in step 2.

Print the document.

PRINTOUT 1
Make sure your name, centre number and candidate number are on your document.
[2]

[Total: 29]

© UCLES 2021 0417/22/M/J/21 [Turn over

 6

Task 3 – Database

You are now going to prepare some reports based on the duathlon results.

19 Using a suitable database package, import the file J2122DUATHLON.csv

Use these field names and data types:

Field name Data type Format

First_Name Text
Last_Name Text
YOB Number Integer
Nationality Text
Race_Number Number Integer
Total_Time Date/Time hh:mm:ss
Run_1 Date/Time hh:mm:ss
T_1 Date/Time hh:mm:ss
Bike Date/Time hh:mm:ss
T_2 Date/Time hh:mm:ss
Run_2 Date/Time hh:mm:ss
Cat_Code Text
Stat_Code Text
Position Number Integer

Set Race_Number as a primary key.

Import the file J2122CATEGORIES.csv as a new table in your database.

Use these field names and data types:

Field name Data type Format

Cat_Code Text
Race_Category Text
Inter_Category Text
Age_Band Text
Gender Text

Set the Cat_Code field as a primary key.

© UCLES 2021 0417/22/M/J/21

 7

Import the file J2122OUTCOMES.csv as a new table in your database.

Use these field names and data types:

Field name Data type Format

Stat_Code Text

Status Text

Ranked Boolean/Logical To display as Yes/No

Set the Stat_Code field as a primary key.

Save the data.

EVIDENCE 5
Place in your Evidence Document screenshots showing the primary keys, field names
and data types used in all three tables.
[4]

20 Create one-to-many relationships as links between the:

• Cat_Code field in the categories table and the Cat_Code field in the duathlon table
• Stat_Code field in the outcomes table and the Stat_Code field in the duathlon table.

EVIDENCE 6
Place in your Evidence Document screenshots showing the type of relationships between
the three tables.
[1]

© UCLES 2021 0417/22/M/J/21 [Turn over

 8

21 Enter the following details as a new record in the duathlon table:

First_Name Dean
Last_Name Cheshire
YOB 1984
Nationality GBR
Race_Number 1193
Total_Time 01:44:08
Run_1 00:29:40
T_1 00:01:20
Bike 00:52:50
T_2 00:01:58
Run_2 00:18:20
Cat_Code AGM-35
Stat_Code FIN
Position 53

Check your data entry for errors.

Save the data.

[2]

22 Using fields from all tables produce a tabular report that:

• selects the records where:
– Race_Category is Elite-Pro
– Stat_Code does not include FIN
• shows only the following fields:
Race_Number, First_Name, Last_Name, Nationality, Race_Category, Status and
Ranked
in this order, with data and labels displayed in full. Do not group the data
• sorts the data into descending order of Status
• has a page orientation of portrait
• fits on a single page
• includes only the text Non-Ranking Elite Athletes as a title displayed in a larger font
size at the top of the page
• has your name, centre number and candidate number on the report.

Save and print your report.

PRINTOUT 2
Make sure that you have entered your name, centre number and candidate number on
your report.
[6]
© UCLES 2021 0417/22/M/J/21
 9

23 Using fields from the duathlon and categories tables, produce a tabular report that:
• selects the records where:
– Nationality is GBR or IRL
– Gender is Male
– YOB is between 1982 and 2001 inclusive
• contains a new field called Athlete_Age which is calculated at run-time to deduct YOB
from the current year (2021). Format this field to display integer format
• shows only the following fields:
First_Name, Last_Name, Nationality, Gender, YOB, Athlete_Age, Run_1, T_1, Bike,
T_2, Run_2, Total_Time and Position
in this order, with data and labels displayed in full. Do not group the data
• sorts the data into ascending order of Nationality and descending order of Position
• has a page orientation of landscape
• fits on a single page wide
• includes only the text Senior Male UK Results as a title displayed in a larger font size at
the top of the page
• calculates the number of athletes and places this at the end of the report, formatted as
an integer
• has a label Number of athletes 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 3
Make sure that you have entered your name, centre number and candidate number on
your report.

EVIDENCE 7
Place in your Evidence Document a screenshot showing the database formula used to
calculate the number of athletes.
[14]

24 Export the report created in step 23 in portable document format (pdf).

Save the exported file in your work area with the file name SENIOR

EVIDENCE 8
Place in your Evidence Document a screenshot to show the exported file saved in your
work area. Make sure there is evidence of the file type.
[2]

[Total: 29]

© UCLES 2021 0417/22/M/J/21 [Turn over

 10

Task 4 – Mail merge

You are required to carry out a mail merge.

25 Create a mail merge document using the file J2122VOUCHER.rtf as the master document and
J2122VIOLATIONS.csv as your data source file.
Enter your name, centre number and candidate number in the header of the document.
[1]

26 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

<NAME> Full_Name
<CTRY> Country
<RN> Race_Number
<CB> Club
<GEND> Gender
<CAT> Race_Category
<SEG> Discipline
<WHEN> Time_Incurred
<VIOL> Violation
<PEN> Penalty
<DUR> Duration
<OFFICER> Tech_Officer

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 9
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.
[6]

© UCLES 2021 0417/22/M/J/21

 11

27 Set an automated filter to select competitors where:

• Discipline is Transition_2
• Duration is 2 or more

EVIDENCE 10
Place in your Evidence Document a screenshot to show the use of an automated selection
method.
[1]

28 Merge and print the vouchers for the selected competitors only.
Save and close the files.

PRINTOUT 5
Print the result of the merge. Make sure you have entered your name, centre number
and candidate number on your vouchers.
[1]

[Total: 9]

Task 5 – 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 6 – Presentation

You are going to create a short presentation.

All slides must have a consistent layout and formatting. Unless otherwise instructed, slides must be
formatted to display a title and bulleted list.

29 Create a presentation of 6 slides using the file J2122RULES.rtf

Place in the footer your name, centre number and candidate number.
The footer must be displayed on all slides.
[1]

30 On the slide with the title Transition demote the last 3 bulleted items so they look like this:

• competitors must not:

– impede the progress of other competitors
– interfere with another competitor’s equipment
– cycle in the transition area
[2]

© UCLES 2021 0417/22/M/J/21 [Turn over

 12

31 Change the layout of the slide with the title Common Penalties to a title and table.
Create a table that contains 4 columns and 13 rows.
Copy the data from the file J2122TABLE.csv and place this in the table.
[2]

32 Format the table so that:

• a plain table style is applied with no cell shading
• all internal and external gridlines are displayed when printed.
[1]

33 Insert 2 new rows as the first 2 rows of the table.

Enter the text and format rows 1 and 2 of the table so they look like this:

Type of Penalty
Conduct
Stop and Go Time Disqualification

[5]

34 Adjust the column widths so:

• data in column 1 is displayed on one line
• the table fits on the slide with all data fully visible.
[1]

35 Save the presentation.

Print all slides in the presentation as handouts with 2 slides to the page, each slide filling half the
page.

PRINTOUT 7
Print this handout. Make sure your name, centre number and candidate number are on
all slides.
[1]

[Total: 13]

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.

© UCLES 2021 0417/22/M/J/21

 Cambridge IGCSE™

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/02

Paper 2 Document Production, Data Manipulation and Presentations October/November 2021

2 hours 30 minutes

You will need: Candidate source files (listed on page 2)

* 6 5 7 7 5 5 2 5 5 4 *

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 [ ].

This document has 12 pages.

DC (CJ) 203091/3
© UCLES 2021 [Turn over
 2

You have been supplied with the following source files:

N2102CHAMPS.rtf
N2102COMPS.csv
N2102EVIDENCE.rtf
N2102LETTER.rtf
N2102RECRUITS.csv
N2102RESULTS.csv
N2102STARTS.csv
N2102TRAINEE.csv
N2102TRANSFER.jpg
N2102VETNEWS.rtf

Task 1 – Evidence Document

Open the file N2102EVIDENCE.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 N2102EVIDENCE followed by your candidate number, for
example, N2102EVIDENCE9999

You will need your Evidence Document during the examination to place screenshots when required.

Task 2 – Document

You are going to edit a newsletter. 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.

1 Open the file N2102VETNEWS.rtf

The page setup is set to A4, portrait orientation with 2 centimetre margins. Do not make any
changes to these settings.

Save the document in your work area, in the format of the software you are using, with the file
name NEWSLETTER

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]

2 Place in the header automated page numbers centre aligned.

Place in the footer the text Edited by: followed by a space and your name, centre number and
candidate number right aligned.

Make sure that:

• all alignments match the page margins
• no other text or placeholders are included in the header or footer areas
• headers and footers are displayed on all pages.
[3]
© UCLES 2021 0417/02/O/N/21
 3

3 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)
VE-subhead sans-serif 14 centre bold, italic single 0 6

EVIDENCE 2
Place in your Evidence Document a screenshot to show that these settings have been
defined for the VE-subhead style. Make sure this style is based on the default paragraph
style.
[3]

4 The style name VE-body has already been created, stored and applied to the body text in the
document.

Modify the VE-body style so only the following formatting is applied:

Font size (points)

Enhancement

Space before
Line spacing

Space after
Style name

Alignment
Font style

(points)

(points)
VE-body serif 11 justified none 1.5 0 6
[1]

5 At the start of the document, above the subtitle Quarterly Newsletter, enter the title:

Vocational Education and Training

[1]

© UCLES 2021 0417/02/O/N/21 [Turn over

 4

6 The style name VE-title has already been created and stored.

Modify the VE-title style so only the following formatting is applied:

Font size (points)

Enhancement

Space before
Line spacing

Space after
Style name

Alignment
Font style

(points)

(points)
VE-title sans-serif 22 centre bold, italic single 0 0

EVIDENCE 3
Place in your Evidence Document a screenshot of these settings for the VE-title style.
[1]

7 Apply the amended VE-title style to the text entered at step 5. [1]

8 Select the subheading Apprenticeship Update and the following text up to and including the
paragraph ending … can benefit business.

Change the page layout so that only this text is displayed in two columns of equal width with a
1 centimetre space between them.
[2]

9 Apply dash style bullets (-) to the text from

Construction and Building …
to
… Transportation and Logistics

Make sure that:

• the bullets are aligned at the left margin
• the list is in single line spacing with no space between the lines
• there is a 6 point space after the last item in the list.
[3]

10 Identify the 4 subheadings in the document and apply the VE-subhead style to each one. [1]

11 Using the data in the file N2102STARTS.csv create a pie chart to compare each level for the year
2019/2020 only. [1]

© UCLES 2021 0417/02/O/N/21

 5

12 Format the chart to display:

• the title: Apprenticeship Starts 2019/2020
• for each sector, only the level and percentage sector labels.

Do not display a legend.

Make sure the sector labels are displayed in full with no overlap.
[3]

13 Insert the chart after the paragraph ending … outnumbered those at intermediate level.

Make sure that the chart and all data fits within the column width.
[1]

14 Import the image N2102TRANSFER.jpg and place it in the paragraph beginning The vocational
skills …

Rotate the image 180 degrees.

Format the image so that:

• it is resized to a width of 3 centimetres with aspect ratio maintained
• the text wraps around the image
• it is aligned to the left of the column and to the top of the paragraph starting The
vocational skills …
[4]

15 Format only the paragraph that starts The 46th WorldSkills Competition … so that:
• the text is indented by 1 centimetre from both the left and right hand margins
• it displays an external 3 to 4 point black border
• it has a light grey (10–25%) background fill.
[3]

16 Spell check and proofread the document.

Make sure that:

• the list, chart and paragraph with the outside border are not split over columns or pages
• 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.

PRINTOUT 1
Make sure your name, centre number and candidate number are on your newsletter.
[1]

[Total: 30]
© UCLES 2021 0417/02/O/N/21 [Turn over
 6

Task 3 – Database

You are now going to prepare some reports based on assessment results. Dates are to be imported in
the format of day month year.

17 Using a suitable database package, import the file N2102TRAINEE.csv

Use these field names and data types:

Field name Data type Format

Family_Name Text
First_Name Text
Trainee_No Text
Birth_Date Date/Time DMY
Gender Text
Trainee_Job Text
Training_Provider Text

Set the Trainee_No field as a primary key.

Save the data.

EVIDENCE 4
Place in your Evidence Document a screenshot showing the primary key, field names
and data types used in the table.

© UCLES 2021 0417/02/O/N/21

 7

Import the file N2102RESULTS.csv as a new table in your database.

Use these field names and data types:

Field name Data type Format

Test_Date Date/Time DMY to display as dd-MMM-yy e.g.
12-May-21
Test_Day Text
Start_Time Date/Time to display as hh:mm
Subject Text
Test_Version Number
Student_ID Text
Duration Date/Time to display as hh:mm
Mark_Achieved Number
Total_Marks Number
Pass_Mark Number
Test_Type Text
Result Text

Do not set a primary key.

Save the data.

EVIDENCE 5
Place in your Evidence Document a screenshot showing the field names and data types
used in the table.
[5]

18 Create a one-to-many relationship between Trainee_No in the trainee table and Student_ID in the
results table.

EVIDENCE 6
Place in your Evidence Document screenshot(s) showing the type of relationship
between the two tables.
[1]

© UCLES 2021 0417/02/O/N/21 [Turn over

 8

19 Enter the following details as a new record in the trainee table:

Family_Name Schneider
First_Name Lina
Trainee_No CA0096
Birth_Date 19/08/2003
Gender Female
Trainee_Job Software Developer
Training_Provider Tawara Digital Academy

Check your data entry for errors.

Save the data.

[2]

20 Using fields from the trainee table only, produce a tabular report that:
• selects the records where:
– Training_Provider includes the text digital
– Birth_Date is in 2003
• shows only the following fields:
First_Name, Family_Name, Birth_Date, Trainee_Job and Training_Provider
in this order, with data and labels displayed in full. Do not group the data
• sorts the data into ascending order of Training_Provider
• has a page orientation of portrait
• fits on a single page
• includes only the text Digital Work Programmes as a title displayed in a larger font
size, fully visible, at the top of the page
• has your name, centre number and candidate number on the report.

Save and print your report.

PRINTOUT 2
Make sure that you have entered your name, centre number and candidate number
on your report.
[7]

© UCLES 2021 0417/02/O/N/21

 9

21 Using fields from both tables, produce a tabular report that:

• contains a new field called %_Mark which is calculated at run-time. This field will
calculate the Mark_Achieved divided by Total_Marks and be displayed as a percentage
with 0 decimal places.
• selects the records where:
– Test_Day is Saturday or Sunday
– Mark_Achieved is 25 or more
• shows only the following fields:
First_Name, Family_Name, Subject, Test_Date, Test_Day, Start_Time, Mark_Achieved,
%_Mark and Result
in this order, with data and labels displayed in full. Do not group the data
• sorts the data into ascending order of Test_Day and descending order of Subject
• has a page orientation of landscape
• fits on a single page wide
• includes only the text Weekend Testing as a title displayed in a larger font size, fully
visible at the top of the page
• calculates the number of tests and displays this as an integer below the Subject column
at the end of the report
• has a label Total tests completed 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 3
Make sure that you have entered your name, centre number and candidate number
on your report.

EVIDENCE 7
Place in your Evidence Document a screenshot showing the database formula used to
calculate the number of tests.
[15]

[Total: 30]

© UCLES 2021 0417/02/O/N/21 [Turn over

 10

Task 4 – Mail Merge

You are required to carry out a mail merge.

22 Create a mail merge document using the file N2102LETTER.rtf as the master document and
N2102RECRUITS.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

<TTL> Title
<FN> First_Name
<LN> Last_Name
<A1> Add_1
<A2> Add_2
<A3> Add_3
<PC> Post_Code
<JB> Job
<DEPT> Department
<MANG> Line_Manager
<START> Start_Date
<SAL> Salary

Make sure the spacing, punctuation and alignment in the original master document are maintained.
[4]

23 Replace the text Candidate Name with your name.

Enter your name, centre number and candidate number in the footer of the document.

Save and print your master document showing the merge field codes.

PRINTOUT 4
Make sure you have entered your name, centre number and candidate number on
your master document.
[1]

24 Set an automated filter to select recruits where the Salary is 18000 or more

EVIDENCE 8
Place in your Evidence Document a screenshot to show the use of an automated
selection method.
[1]

© UCLES 2021 0417/02/O/N/21

 11

25 Merge and print the letters for the selected recruits only.

Save and close the files.

PRINTOUT 5
Print the result of the merge. Make sure you have entered your name, centre number
and candidate number on your letters.
[1]

[Total: 7]

Task 5 – 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 6 – Presentation

You are going to create a short presentation.

All slides must have a consistent layout and formatting. Unless otherwise instructed, slides must be
formatted to display a title and bulleted list.

26 Create a presentation of 6 slides using the file N2102CHAMPS.rtf

Place in the header your name, centre number and candidate number.

Make sure that the header appears in the same position on every slide.
[1]

27 Change the layout of the slide with the title International Skills Competitions to a title and table.

Create a table that contains 4 columns and 7 rows.

Copy the data from the file N2102COMPS.csv and place this in the table.
[2]

28 Format the table so that:

• a plain table style is applied
• no text is wrapped within the table
• the table fits on the slide with all data fully visible
• all internal and external gridlines are displayed when printed.
[1]

© UCLES 2021 0417/02/O/N/21 [Turn over

 12

29 Insert a new row as the first row of the table.

Merge cells in the first row and enter the text EuroSkills and WorldSkills so rows 1 and 2 look
like this:

EuroSkills WorldSkills
Year Location Year Location
[3]

30 Format the table so that:

• all rows are 1.5 centimetres high
• text in all rows is centre aligned vertically and horizontally.
[3]

31 Add the following text as presenter/speaker notes for the slide with the title International Skills
Competitions

Biennial events held alternate years

Print only this slide as presenter/speaker notes.

PRINTOUT 7
Make sure your name, centre number and candidate number are on this slide.
[2]

32 Save the presentation.

Print all slides in the presentation as a handout using a layout of 6 slides to the page.

PRINTOUT 8
Print this handout. Make sure your name, centre number and candidate number are
on all slides.
[1]

[Total: 13]

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.

© UCLES 2021 0417/02/O/N/21

 Cambridge IGCSE™

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/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)

* 7 8 8 7 8 8 3 0 5 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 [ ].

This document has 12 pages.

DC (LK) 303972/3
© UCLES 2022 [Turn over
 2

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]

© UCLES 2022 0417/22/M/J/22

 3

3 Create the following paragraph styles, basing them on the default paragraph style:

Enhancement

Space before
Line spacing

Space after
Style name

Alignment
Font style

Font size
(points)

(points)

(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:
Enhancement

Space before
Line spacing

Space after
Style name

Alignment
Font style

Font size
(points)

(points)

(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.

© UCLES 2022 0417/22/M/J/22 [Turn over

 4

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]
© UCLES 2022 0417/22/M/J/22
 5

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
currency symbol with
Berth_Fee Number/Currency 2 decimal places
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]

© UCLES 2022 0417/22/M/J/22 [Turn over

 6

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]

© UCLES 2022 0417/22/M/J/22

 7

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]
© UCLES 2022 0417/22/M/J/22 [Turn over
 8

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]

© UCLES 2022 0417/22/M/J/22

 9

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]

© UCLES 2022 0417/22/M/J/22 [Turn over

 10

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]
© UCLES 2022 0417/22/M/J/22
 11

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]
© UCLES 2022 0417/22/M/J/22 [Turn over
 12

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]

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.

© UCLES 2022 0417/22/M/J/22

 Cambridge IGCSE™

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/02

Paper 2 Document Production, Data Manipulation and Presentations October/November 2022

2 hours 30 minutes

You will need: Candidate source files (listed on page 2)

* 9 0 6 4 6 3 2 9 4 7 *

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 [ ].

This document has 16 pages. Any blank pages are indicated.

DC (CJ) 303977/3
© UCLES 2022 [Turn over
 2

You have been supplied with the following source files:

N2202CLASS.csv
N2202EVIDENCE.rtf
N2202FLAG.png
N2202INFRINGE.csv
N2202NRI_FORM.rtf
N2202OUTCOMES.csv
N2202REGATTA.rtf
N2202RESULTS.rtf
N2202SKIPPERS.csv

Task 1 – Evidence Document

Open the file N2202EVIDENCE.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 N2202EVIDENCE followed by your candidate number, for
example, N2202EVIDENCE9999

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 Sailing Club. The company uses a corporate house style
for all its documents. Paragraph styles must be created, modified and applied as instructed.

1 Open the file N2202REGATTA.rtf

The page setup is set to A4, landscape 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 SAILING

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]

© UCLES 2022 0417/02/O/N/22

 3

2 Place right aligned in the header:

• the text Sailing Instructions
• on a new line: your name, centre number and candidate number.

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 Create the following paragraph style, basing it on the default paragraph style.

Space before (points)

Space after (points)

Font size (points)

Enhancement

Line spacing
Style name

Alignment
Font style

TSR-subhead serif 18 centre italic, underline single 0 4

Take screenshot evidence to show the settings for the TSR-subhead paragraph style and place
this in your Evidence Document.

EVIDENCE 2
Screenshot evidence showing the settings for the TSR-subhead paragraph style.
[2]

© UCLES 2022 0417/02/O/N/22 [Turn over

 4

4 At the start of the document enter, on a new line, the title:

Tawara Sailing Regatta

Apply the TSR-title paragraph style to this text.

Modify the TSR-title paragraph style so only the following formatting is applied:

Space before (points)

Space after (points)

Font size (points)

Enhancement

Line spacing
Style name

Alignment
Font style

TSR-title serif 30 centre bold, italic single 0 0

Take screenshot evidence to show your modified settings for the TSR-title paragraph style and
place this in your Evidence Document.

EVIDENCE 3
Screenshot evidence showing your modified settings for the TSR-title paragraph style.
[3]

5 Select the subheading Schedule and the following text up to and including the paragraph ending
… protest committee are final.

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]

6 Apply bullets to the text from

overall team with …

to
… in 2003 or later).

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.
[3]

© UCLES 2022 0417/02/O/N/22

 5

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

8 Import the image N2202FLAG.png and place it in the paragraph beginning At the start of each
race …

Reflect (flip) the image so the flag is on the right.

Format the image so that:

• it is resized to a width of 2.5 centimetres with the aspect ratio maintained
• it is aligned to the right of the column and top of the paragraph starting At the start of
each race …
• the text wraps around the image.
[4]

9 Locate the table in the document.

Format the table so that it looks like this:

09:00 Registration and boat inspection

Racing Schedule

14:00 Practice races, warning signal

4 August
17:00 Opening ceremony
19:30 Skippers’ briefing
5 August 10:00 Race 1
6 August 10:00 Race 2
7 August 10:00 Race 3
8 August 11:00 Race 4

Make sure that:

• text displays on one line in columns 2, 3 and 4
• table borders and all data fit within the column width
• 1 point black internal and external gridlines are displayed when printed
• the TSR-table paragraph style applied to columns 2, 3 and 4 has not been changed
• there is a 6 point space after the table.
[8]

© UCLES 2022 0417/02/O/N/22 [Turn over

 6

10 Spell check and proofread the document.

Make sure that:

• the table and list 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 table and the list.

Save the document using the same file name and format used in step 1.

Print the document.

PRINTOUT 1
Make sure that you have entered your name, centre number and candidate number
on your document.
[2]

[Total: 28]

© UCLES 2022 0417/02/O/N/22

 7

Task 3 – Database

You are now going to prepare some reports.

11 Using a suitable database package, import the file N2202SKIPPERS.csv

Use these field names and data types:

Field name Data type Store Display

Skipper_Name Text
YOB Number
Yacht_Name Text
Make Text
Class Text
Sail_No Text
Nationality Text
Skip_Gender Text
Handicap Number 4 decimal places 4 decimal places
Group Text
Race_1 Number
Race_2 Number
Race_3 Number
Race_4 Number
Points Number

Set Sail_No as a primary key.

Save the data.

© UCLES 2022 0417/02/O/N/22 [Turn over

 8

Import the file N2202CLASS.csv as a new table in your database.

Use these field names and data types:

Field name Data type Store Display

Yacht_Class Text

Crew_Gender Text

Age_Group Text

Class_Code Text

Keel Text

Hull_Type Text

Crew Number

Hull(m) Number 2 decimal places 2 decimal places

Beam(m) Number 2 decimal places 2 decimal places

Sail_Area(m2) Number 2 decimal places 2 decimal places

Set Class_Code as a primary key.

Take screenshot evidence of the table structures showing the primary keys, field names and data
types. Place this in your Evidence Document.

EVIDENCE 4
Screenshot evidence of the table structures in your database.
[5]

12 Create a one-to-many relationship between Class_Code in the class table and Class in the
skippers table.

Take screenshot evidence showing the fields and type of relationship. Place this in your Evidence
Document.

EVIDENCE 5
Screenshot evidence of the fields and type of relationship.
[1]

© UCLES 2022 0417/02/O/N/22

 9

13 Enter the following details as a new record in the skippers table.

Skipper_Name Wang Chen

YOB 1950
Yacht_Name Sunrays
Make Sevier Luna
Class PL003
Sail_No CHN2644
Nationality CHN
Skip_Gender Female
Handicap 0.9800
Group Blue
Race_1 3
Race_2 12
Race_3 13
Race_4 4
Points 32

Check your data entry for errors.

Save the data.

[2]

© UCLES 2022 0417/02/O/N/22 [Turn over

 10

14 Using fields from both tables produce a tabular report that:

• selects the records where:
– Hull_Type is Multihull
– Skip_Gender is Female
– Points is 30 or less
• shows only the fields Skipper_Name, Nationality, Yacht_Class, Hull_Type, Sail_Area(m2),
Hull(m), Beam(m) and Points in this order, with data and labels displayed in full. Do not
group the data
• sorts the data into ascending order of Yacht_Class and descending order of Points
• has a page orientation of portrait
• fits on a single page with no page number displayed
• includes only the text Top Female Multihull Results as a title displayed in a larger font
size at the top of the page
• calculates the lowest Points value and places this below the Points column at the end of
the report
• has a label Lowest points score to the left of this value
• has your name, centre number and candidate number on the report.

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 lowest points
value. Place this in your Evidence Document.

EVIDENCE 6
Screenshot evidence of the database formula used.
[11]

© UCLES 2022 0417/02/O/N/22

 11

15 Using fields from both tables produce a tabular report that:

• selects only the records where:
– Yacht_Name contains the text sun
– Group is Blue or Red
• contains a new field called New_Points which is calculated at run-time to multiply Points
by Handicap. Format this field to display as an integer
• shows only the fields Skipper_Name, YOB, Sail_No, Yacht_Name, Make, Yacht_Class,
Group, Handicap, Points and New_Points in this order, with data and labels displayed in
full. Do not group the data
• sorts the data into ascending order of Yacht_Name
• has a page orientation of landscape
• fits a single page wide and prints on two pages only
• includes only the text Morning Race Results as a title displayed in a larger font size at
the top of the page
• displays only your name, centre number and candidate number in the footer so it appears
in the same position on every page.

Save and print your report.

PRINTOUT 3
Make sure that you have entered your name, centre number and candidate number
on your report.

[10]

[Total: 29]

© UCLES 2022 0417/02/O/N/22 [Turn over

 12

Task 4 – Mail merge

You are required to carry out a mail merge to complete a penalty notice.

16 Create a mail merge document using the file N2202NRI_FORM.rtf as the master document and
N2202INFRINGE.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

<YNAME> Yacht_Name
<SAIL> Sail_Number
<YCLASS> Yacht_Class
<SKIPNAME> Skipper_Name
<NAT> Nationality
<RACE_NO> Race_Number
<RULE> Rule_Ref
<INFRINGE> Infringement
<PENALTY_NO> Penalty_Number
<ACT> Action

Make sure the spacing, punctuation, alignment and enhancements in the original master document
are maintained.
[4]

17 Replace <DATE> with a field to display today’s date in the format dddd, dd MMMM yyyy

Take screenshot evidence to show the date field code format and place this in your Evidence
Document.

EVIDENCE 7
Screenshot evidence of the date field format.
[1]

18 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.

PRINTOUT 4
Make sure you have entered your name, centre number and candidate number on
your master document.
[1]

© UCLES 2022 0417/02/O/N/22

 13

19 Set an automated filter to select the records where nationality is USA or CAN

Take a screenshot to show the use of your automated selection method. Place this in your
Evidence Document.

EVIDENCE 8
Screenshot evidence of your automated selection method.
[2]

20 Merge and print the penalty notices for the selected nationalities only.

Save and close the files.

PRINTOUT 5
Make sure you have entered your name, centre number and candidate number on
your penalty notices.
[1]

[Total: 9]

Task 5 – 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 6 is on page 14.

© UCLES 2022 0417/02/O/N/22 [Turn over

 14

Task 6 – Presentation

You are going to create a short presentation. All slides must have a consistent layout and formatting.

21 Create a presentation of six slides using the file N2202RESULTS.rtf

Unless otherwise instructed, the slides must display a title and a bulleted list.
[1]

22 Use a master slide to display only:

• a thick black 3 to 4 point wide horizontal line across the width of the slide, about
3 centimetres from the top
• the text 2021 Event Statistics on one line, in a large, black font, aligned to the top right.
This text must be above the 3 to 4 point line
• automated 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.
[3]

23 Use the data in the file N2202OUTCOMES.csv to create a vertical bar chart for only the top 6
ranked countries. This chart must display:
• the names of the countries on the category axis
• the values for the Avg_Competitor_Points only.
[1]

24 Label the chart as follows:

• chart title Top Six Countries in 2021
• value axis title Average Points
• category axis title Country
[2]

© UCLES 2022 0417/02/O/N/22

 15

25 Display only the data values at the top of each bar. [1]

26 Format the value axis scale to display:

• a minimum value of 0
• a maximum value of 32
• increments of 4
[2]

27 Place the chart to the left of the bullets on the slide with the title Event Entries

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.

Print only this slide as a full page slide in landscape orientation.

PRINTOUT 7
Make sure your name, centre number and candidate number are on this slide.
[2]

28 Format the bullets on slides 3, 4, 5 and 6 to display as a numbered list starting from 1 on each
slide in ascending order as 1, 2, 3, 4, 5 and 6. [1]

29 Save the presentation.

Print the presentation as a handout with 6 slides to the page.

PRINTOUT 8
Make sure your name, centre number and candidate number are on all slides.
[1]

[Total: 14]

© UCLES 2022 0417/02/O/N/22

 16

BLANK PAGE

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.

© UCLES 2022 0417/02/O/N/22

 Cambridge IGCSE™

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/22

Paper 2 Document Production, Databases and Presentations May/June 2023

2 hours 15 minutes

You will need: Candidate source files (listed on page 2)

* 4 2 1 5 9 7 0 3 3 8 *

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 [ ].

This document has 12 pages. Any blank pages are indicated.

DC (CJ) 314795/3
© UCLES 2023 [Turn over
 2

You have been supplied with the following source files:

j2322apps.csv
j2322clubs.csv
j2322cyclist.jpg
j2322evidence.rtf
j2322race.csv
j2322trends.rtf
j2322vcworld.rtf
j2322virtual.rtf

Task 1 – Evidence Document

Open the file j2322evidence.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 when required.

Task 2 – Document

You are going to edit a document about Virtual Cycling. The company uses a corporate house style for
all their documents. Paragraph styles must be created and applied as instructed.

1 Using suitable software, open the file j2322virtual.rtf

The page setup is set to A4, landscape orientation with 2.5 centimetre margins. Do not make any
changes to these settings.

Three paragraph styles have already been created. Do not make any changes to these.

Save the document in your work area with the file name VCYCLING

Make sure that 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 that
there is evidence of the file type.
[1]

© UCLES 2023 0417/22/M/J/23

 3

2 Place in the header of the VCYCLING document the text Report by: followed by a space and
your name, centre number and candidate number right aligned.

Place in the footer automated page numbers right aligned.

Make sure that:

• all the alignments match the page margins

• 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 Benefits and the following text up to and including the paragraph ending
… being developed continuously.

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]

4 Create and store the following style, basing it on the default/normal paragraph style:
Enhancement

Space before
Line spacing

Space after
Style name

Alignment
Font style

Font size
(points)

(points)

(points)
VC-subhead serif 16 centre bold, italic single 0 8

Take a screenshot to show that you have defined the settings for the VC-subhead style.

Make sure that there is evidence that you have based this on the default/normal paragraph style.

Place this in your Evidence Document.

[2]

5 Identify the 4 subheadings in the document and apply the VC-subhead style to each one. [1]

6 Locate and move the paragraph:

Cycling is an excellent … a mass participation event.

so that it appears as a new paragraph immediately after the subheading Benefits. [1]

© UCLES 2023 0417/22/M/J/23 [Turn over

 4

7 Import the image j2322cyclist.jpg and place it in the paragraph beginning Cheating has become
an … [1]

8 Rotate the image 180 degrees. [1]

9 Format the image so that:

• it is resized to a width of 4 centimetres with the aspect ratio maintained

• it is aligned to the right of the column and top of the paragraph starting Cheating has become
an …
• the text wraps around the image.
[2]

10 Locate the table in the document.

Format the first row of the table so that it looks like this:

Global Cycle App Growth

Region Daily Usage Download Growth
Asia Pacific 23% 45%
Europe 10% 23%
India 72% 137%
Middle East and
North Africa 26% 52%
Rest of the World 22% 40%

[2]

11 Sort the data in the table from

Asia Pacific
to
Rest of the World

into descending order of Download Growth [1]

12 Insert a new row as the last row in the table and enter the following details:

Americas 7% 19%

[2]

© UCLES 2023 0417/22/M/J/23

 5

13 Apply the VC-table style to rows 2 to 8 only.

Apply to rows 1 to 8 a 3–4 point black external border with no internal gridlines displayed when
printed.

Make sure that:

• all the text of each row displays on one line

• the table borders and all the data fit within the column width
• there is an 8 point space after the table.
[3]

14 Spell check and proofread the document.

Make sure that:

• the table is not split over two columns or pages

• there are no widows or orphans
• there are no blank pages
• the original styles are maintained
• all the styles are applied consistently
• the spacing is consistent between all items.

Save the document using the same file name and format used in Step 1.
[1]

Print the document.

[Total: 23]

© UCLES 2023 0417/22/M/J/23 [Turn over

 6

Task 3 – Database

You are now going to prepare some reports.

15 Using database software, import the file j2322race.csv

Use these field names and data types:

Field name Data type Store Display

Club_Code Text
Last_Name Text
First_Name Text
Bib_No Number 0 decimal places
YOB Number 0 decimal places
LPF_Ratio Number 3 decimal places 3 decimal places
Race_Time Date/Time hh:mm:ss
Category Text
Year_Band Text
Gender Text

Set Bib_No as a 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.
[2]

16 Import the file j2322clubs.csv as a new table in your database. Set all the data types to text.

Set Club_ID as a primary key.

Place in your Evidence Document a screenshot showing the field names, data types and primary
key used in the table.
[1]

17 Create a one-to-many relationship between Club_ID in the clubs table and Club_Code in the race
table.

Place in your Evidence Document a screenshot showing the fields and the type of relationship.
[1]

© UCLES 2023 0417/22/M/J/23

 7

18 Create a columnar data entry form, with all the fields in the race table, to display one record at a
time.

Apply two different formatting features to this form to improve the design.
[3]

19 Use the form created in Step 18 to add the following data as a new record in the race table:

Club_Code RCC11
Last_Name Burns
First_Name Amy
Bib_No 1208
YOB 1943
LPF_Ratio 0.678
Race_Time 02:20:05
Category Grand Veteran
Year_Band 80 to 89
Gender Female

Place in your Evidence Document a screenshot of the form with the new record displayed and
showing the formatting features applied in Step 18.
[2]

20 Using fields from both tables, produce a tabular report that:

• selects the records where:
– Area ends with the text land
– Category is Junior or Master
• shows only the fields First_Name, Last_Name, Gender, Category, Area, Country and
Race_Time in this order, with data and labels displayed in full. Do not group the data
• sorts the data into ascending order of Category
• has a page orientation of portrait
• fits on a single page
• includes only the title Master and Junior Outcomes displayed in a larger font size, fully
visible, at the top of the page
• has your name, centre number and candidate number on the report.

Save and print your report.

[6]

© UCLES 2023 0417/22/M/J/23 [Turn over

 8

21 Using fields from both tables, produce a tabular report that:

• selects the records where:
– Country_Code is GBR
– YOB is 1960 or earlier
• contains a new field called LPF_Uplift which is calculated at run-time. This field will calculate
the Race_Time multiplied by the LPF_Ratio. Format this field to display time as hh:mm:ss
• shows only the fields Bib_No, Gender, YOB, Category, LPF_Ratio, Club_Name, Country,
Race_Time and LPF_Uplift in this order, with data and labels displayed in full. Do not group
the data
• sorts the data into ascending order of Country and descending order of LPF_Ratio
• has a page orientation of landscape
• fits a single page wide
• includes only the title GBR Category Results displayed in a larger font size, fully visible, at
the top of the page
• calculates the longest race time and places this at the end of the report, fully visible and right
aligned with the race times in the Race_Time column
• has the label Longest race time fully visible to the left of this value
• 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.

Place in your Evidence Document a screenshot showing the database formula used to calculate
the longest race time.
[14]

[Total: 29]

Task 4 – Presentation

You are going to create a short presentation.

All slides must have a consistent layout and formatting.

22 Create a presentation of 6 slides using the file j2322vcworld.rtf

Unless otherwise instructed, the slides must display a title and a bulleted list.
[1]

23 Place in the header automated slide numbers left aligned.

Place in the footer your name, centre number and candidate number left aligned.

Make sure that:

• the header and footer appear in the same position on every slide
• no items overlap on any slide.
[2]

© UCLES 2023 0417/22/M/J/23

 9

24 Use the data in the file j2322apps.csv to create a vertical bar chart to show the number of
downloads for each app. This chart must display only the App Title and Downloads (million).
Display, with labels, the app titles on the category axis.

Do not display a legend.

[2]

25 Label the chart as follows:

• chart title Top Fitness App Downloads 2022

• value axis title Million
[2]

26 Display only the data values along the top of each bar. [1]

27 Format the value axis scale to display:

• a minimum value of 0
• a maximum value of 15
• increments of 3
[2]

28 Place the chart to the left of the bullets on the slide with the title Virtual Cycling Trends

Make sure that:

• no words in the chart are split

• all the data and labels are fully visible
• the chart and its contents do not overlap any slide items.
[1]

29 On the slide with the title Virtual Cycling Trends, create a square-shaped action button and position
this in the top right corner.

Format the action button so that when clicked it opens the document with the file name
j2322trends.rtf

Enter the text Top Fitness Trends as text on the action button.

Place in your Evidence Document a screenshot(s) showing the action button linked to the correct
document. Make sure that the file name is fully visible.
[4]

30 Set the slide show so it loops continuously on-screen.

Place in your Evidence Document a screenshot to show the presentation set to display in a
continuous on-screen loop.
[1]

© UCLES 2023 0417/22/M/J/23 [Turn over

 10

31 Save the presentation.

Print all the slides as handouts in portrait orientation with 3 slides to the page.

Print the slide with the title Virtual Cycling Trends as a full page slide in landscape orientation.
[2]

[Total: 18]

Task 5 – Printing the Evidence Document

32 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.

© UCLES 2023 0417/22/M/J/23

 11

BLANK PAGE

© UCLES 2023 0417/22/M/J/23

 12

BLANK PAGE

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.

© UCLES 2023 0417/22/M/J/23

 Cambridge IGCSE™

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/02

Paper 2 Document Production, Databases and Presentations October/November 2023

2 hours 15 minutes

You will need: Candidate source files (listed on page 2)

* 2 1 7 2 5 9 6 2 6 9 *

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 [ ].

This document has 12 pages. Any blank pages are indicated.

DC (LK) 314796/4
© UCLES 2023 [Turn over
 2

You have been supplied with the following source files:

n2302evidence.rtf
n2302guide.rtf
n2302platforms.csv
n2302players.csv
n2302ratings.csv
n2302review.rtf
n2302vgames.csv

Task 1 – Evidence Document

Open the file n2302evidence.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 when required.

Task 2 – Document

You are going to edit a report about Video Gaming. The company uses a corporate house style for all
their documents. Paragraph styles must be created, modified and applied as instructed.

1 Using suitable software, open the file n2302review.rtf

The page setup is set to A4, landscape orientation with 2.5-centimetre margins. Do not make any
changes to these settings.

Three styles have already been created. Do not make any changes to these unless instructed.

Save the document in your work area with the file name VGREVIEW

Make sure that 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 that
there is evidence of the file type. [1]

2 Remove any page breaks from the VGREVIEW document. [1]

3 Place in the header of the document automated page numbers left aligned.

Place in the footer the text Market review by: followed by a space and your name, centre number
and candidate number right aligned.

Make sure that:

● all the alignments match the page margins

● no other text or placeholders are included in the header or footer areas
● headers and footers are displayed on all pages.
[3]

4 Select the subheading Video Games and the following text up to and including the paragraph
ending … transactions and advertisements.

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]

© UCLES 2023 0417/02/O/N/23

 3

5 Create and store the following style, basing it on the default/normal paragraph style:

Enhancement

Space before
Line spacing

Space after
Style name

Alignment
Font style

Font size
(points)

(points)

(points)
VG-subhead sans-serif 20 centre bold, italic single 0 0

Take a screenshot to show that you have defined the settings for the VG-subhead style.

Make sure that there is evidence that you have based this on the default/normal paragraph style.

Place this in your Evidence Document. [2]

6 Identify the four subheadings in the document and apply the VG-subhead style to each one. [1]

7 Locate and move the paragraph:

Aggressive competition between … the video game industry.

so that it appears as a new paragraph immediately after the paragraph ending … gamer controls
the action. [1]

8 Using the data in the file n2302players.csv create a vertical bar chart to show the worldwide
distribution of online game players for the year 2022 only. [1]

9 Label the chart as follows:

● chart title Global Online Players 2022 (millions)

● category axis title Region
[2]

10 Display only the data values along the top of each bar.

Do not display a legend. [1]

11 Format the value axis scale to display:

● a minimum value of 0
● a maximum value of 1500
● increments of 300
[2]

12 Insert the chart after the paragraph ending … game players in 2022:

Make sure that:

● the chart and all data fits within the column width
● all data labels are displayed in full with no overlap
● there is a 6-point space after the chart.
[1]

© UCLES 2023 0417/02/O/N/23 [Turn over

 4

13 The style named VG-list has already been created, stored and applied to the five list items in the
report.

Modify the VG-list 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)
aligned italic with
VG-list sans-serif 10 left to numbered list, i.e. single 0 0
margin 1., 2., 3.,

Place in your Evidence Document screenshots of the style settings for the VG-list style to show
that you have changed these. Make sure that the screenshots show all the changes made to this
style. [3]

14 Format the paragraph that starts Mobile gaming is expected … so that it is indented
1.5 centimetres from both the left-hand and right-hand margins. [1]

15 Spell check and proofread the document.

Make sure that:

● the list is not split over two columns or pages

● there are no widows or orphans
● there are no blank pages
● original styles are maintained
● all 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.

[2]

[Total: 24]

© UCLES 2023 0417/02/O/N/23

 5

Task 3 – Database

You are now going to prepare some reports.

Make sure that all currency values display the same currency symbol and are set to 2 decimal places.

16 Examine the file n2302vgames.csv and identify the most appropriate field to set as a primary key.
Close this file.

Using database software, import the file n2302vgames.csv

Use these field names and data types:

Field name Data type Store Display

Game_Title Text
Rank Number 0 decimal places
Game_Code Text
Platform Text
Release_Year Number 0 decimal places
Genre Text
Game_Publisher Text
Global_Sales Number 3 decimal places 3 decimal places
currency symbol with
Price Number/Currency 2 decimal places
2 decimal places

Set the identified field 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]

17 Import the file n2302platforms.csv as a new table in your database.

Use the field names and data types provided.

Set Platform as the primary key.

Place in your Evidence Document a screenshot showing the field names, data types and primary
key used in the table. [1]

18 Create a one-to-many relationship between Platform in the platforms table and Platform in the
games table.

Take screenshot evidence showing the fields and type of relationship. Place this in your Evidence
Document. [1]

19 In the games table, locate the record with the Game_Code AC105

Amend the details as follows:

Rank 455
Release_Year 2020
Genre Action

Check your data entry for errors. Save the data. [1]
© UCLES 2023 0417/02/O/N/23 [Turn over
 6

20 Add the following as a new record in the games table:

Game_Title Sprinter
Rank 134
Game_Code AC149
Platform GD
Release_Year 1999
Genre Action
Game_Publisher Lowena Interactive
Global_Sales 6.230
Price 12.80

Check your data entry for errors. Save the data. [2]

21 Using fields from both tables, produce a tabular report that:

● selects the records where:

– Game_Title includes the text sport
– Release_Year is 2011 or later
● shows only the fields Rank, Game_Title, Release_Year, Genre, Global_Sales and
Console_Name, in this order, with data and labels displayed in full. Do not group the data
● sorts the data into ascending order of Release_Year
● has a page orientation of portrait
● fits on a single page
● includes only the title Sports titles released since 2011 displayed in a larger font size, fully
visible, at the top of the page
● has your name, centre number and candidate number on the report.

Save and print your report.

[6]

© UCLES 2023 0417/02/O/N/23

 7

22 Using fields from both tables, produce a tabular report that:

● selects the records where:

– Genre is Action or Adventure
– Rank is 200 or less
● contains a new field called Discount_Price which is calculated at run-time. This field will
display the new price after a 5% discount has been applied. Use Price multiplied by 95 divided
by 100. Format this field to display currency
● shows only the fields Game_Title, Rank, Genre, Console_Name, Release_Year,
Game_Publisher, Price and Discount_Price, in this order, with data and labels displayed in
full. Do not group the data
● sorts the data into descending order of Genre and ascending order of Rank
● has a page orientation of landscape
● fits a single page wide
● includes only the title Top Entertainment Games displayed in a larger font size, fully visible,
at the top of the page
● calculates the earliest release year and places this below the Release_Year column at the
end of the report
● has the label Earliest game release fully visible to the left of this value
● 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.

Place in your Evidence Document a screenshot showing the database formula used to calculate
the earliest release year. Make sure that the formula is fully visible.
[13]

[Total: 27]

© UCLES 2023 0417/02/O/N/23 [Turn over

 8

Task 4 – Presentation

You are going to create a short presentation.

All slides must have a consistent layout and formatting.

23 Create a presentation of 5 slides, using the file n2302guide.rtf

Unless otherwise instructed, the slides must display a title and a bulleted list. [1]

24 Place in the header your name, centre number and candidate number right aligned.

Make sure that the header appears in the same position on every slide. [1]

25 Change the layout of the slide with the title Age rating system to a title and table.

Create a table that contains 3 columns and 6 rows.

Format the table so that:

● a plain table style is applied with no cell shading

● all internal and external gridlines are displayed when printed. [2]

26 Copy the data from the file n2302ratings.csv and place this in the table created in Step 25.

Adjust the column widths so data in column 3 wraps over no more than 3 lines. [2]

27 Format the table so the height of all six rows is set to 2 centimetres. Make sure the data in column
3 still wraps over no more than 3 lines. [1]

28 Format the table so:

● the first column of the table has a solid black background with white text
● columns 1, 2 and 3 look like this:

Rating Description
Age Categories

Suitable for all age groups. There may be a very mild form of violence such as a cartoon setting. No bad language should
3
be heard.

Same as rating 3 but may also have scary looking characters. Very mild forms of violence may be seen such as vehicles
7 crashing into each other or non-realistic violence. May contain scenes or sounds that could be frightening to younger
children.

May contain violence of a slightly more graphic nature towards fantasy characters such as dragons or trolls, or non-
12
realistic violence towards people. May also contain suggestive themes, crude humour and mild swearing.

May contain more realistic violence towards people that looks the same as would be expected in real life. The use of bad
16
language can be more extreme. Games of chance and the use of tobacco may also be present.

The adult classification is applied when the level of violence reaches a stage where it becomes a depiction of gross
18 violence, motiveless killing, or violence towards defenceless characters. May also have other content that is only suitable
for adults.

[5]

© UCLES 2023 0417/02/O/N/23

 9

29 On the slide with the title Content descriptors, select the seven bulleted items bad language … to
… suggestive themes and format them to look like this:

Content descriptors
● image content descriptors indicate why a game received a particular
age rating:
– bad language
– discrimination
– controlled substances
– fear
– games of chance
– violence
– suggestive themes

● this guidance helps consumers make informed choices

[3]

30 On the slide with the title Online gaming safety, format the text age rating in the last bullet point so
that when clicked it goes to the slide with the title Age rating system

Take screenshot evidence to show that the text links to the correct slide. Place this in your
Evidence Document. [2]

31 Save the presentation.

Print slides 2, 3, 4 and 5 only as handouts in portrait orientation with 2 slides to the page, each
slide filling half the page. [2]

[Total: 19]

Task 5 – 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.

© UCLES 2023 0417/02/O/N/23

 10

BLANK PAGE

© UCLES 2023 0417/02/O/N/23

 11

BLANK PAGE

© UCLES 2023 0417/02/O/N/23

 12

BLANK PAGE

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.

© UCLES 2023 0417/02/O/N/23

 Cambridge IGCSE™

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/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)

* 6 6 1 9 6 4 9 8 8 1 *

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 [ ].

This document has 12 pages. Any blank pages are indicated.

DC (PQ) 327114/4
© UCLES 2024 [Turn over
 2

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]

© UCLES 2024 0417/22/M/J/24

 3

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]

© UCLES 2024 0417/22/M/J/24 [Turn over

 4

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:

Enhancement

Space before
Line spacing

Space after
Style name

Alignment
Font style

Font size
(points)

(points)

(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]

© UCLES 2024 0417/22/M/J/24

 5

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]

© UCLES 2024 0417/22/M/J/24 [Turn over

 6

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.

© UCLES 2024 0417/22/M/J/24

 7

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]
© UCLES 2024 0417/22/M/J/24 [Turn over
 8

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]
© UCLES 2024 0417/22/M/J/24
 9

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]

© UCLES 2024 0417/22/M/J/24 [Turn over

 10

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]

© UCLES 2024 0417/22/M/J/24

 11

BLANK PAGE

© UCLES 2024 0417/22/M/J/24

 12

BLANK PAGE

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.

© UCLES 2024 0417/22/M/J/24