0417 s23 QP 22-Merged

Download as pdf or txt
Download as pdf or txt
You are on page 1of 10

www.dynamicpapers.

com

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
www.dynamicpapers.com
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


www.dynamicpapers.com
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


www.dynamicpapers.com
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


www.dynamicpapers.com
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


www.dynamicpapers.com
6

Task 4 – Spreadsheets

The Tawara Animal Sanctuary is currently running three projects: Elephant, Monkey and Tiger. Income
is from donations and for each project they record the amount spent on food, veterinary bills and
relocating the animals back into the wild. You will edit a spreadsheet for this data. All currency values
must be in dollars ($), displayed to 2 decimal places.

8 Open and examine the file j2332project.csv in your spreadsheet software.

Copy and paste the contents of cell A4 into cell B5.

Delete rows 3 and 4.

Place in the header, centre aligned, the text Spreadsheet prepared by followed by a space, your
name, centre number and candidate number, then a space followed by on followed by a space
and today’s automated date, then a space followed by at followed by a space and the automated
time.

Save your spreadsheet with the file name project_centre number_candidate number, for example,
project_ZZ999_9999
[6]

9 Merge cells A1:N1, A9:A12, A13:A16 and A17:A20. Format the merged cell A1:N1 to have a solid
black background. Format the spreadsheet to look like this.
A B C D E F G H I J K L M N

1
Tawara Animal Sanctuary income and expenditure
2 Month January February March April May June July August September October November December
3 Project Income
4 Elephant 3480.38 2061.45 1893.74 4586.43 2159.94 6447.05 6541.33 5889.93 6281.2 8244.76 8249.47 8514.5
5 Monkey 754.21 3421.02 1134.94 2565.61 3338.51 4056.3 2089.17 3501.97 1018.73 3604.78 455.33 3126.84
6 Tiger 2952.38 1846.3 1487.65 4718.89 5897.85 6828.12 8690.99 1525.76 8812.25 472.59 6400.24 4808.71
7
8 Project Expenditure
9 Relocation 2716.18 4118.3 3239.28 2469.32 2973.13 3579.62 3260.53 33.8 2719.38 2096.41 831.69 421.84
10 Veterinary 2190.97 913.83 1604.3 3595.88 1753.4 934.38 3886.05 3200.7 3052.32 2874.79 1306.57 1675.18
Elephant
11 Food 2048.94 2815.71 2295.06 2629.31 280.63 1149.43 2479.65 2007.2 4420.34 542.01 365.61 2438.75
12 Total
13 Relocation 542.2 629.55 357.86 844.56 681.08 251.3 485.6 866.48 523.59 698.75 685.38 534.26
14 Veterinary 381.8 186.53 240.2 327.27 351.5 210.9 284.51 299.61 188.59 309.2 123.29 283.5
Monkey
15 Food 38.87 20.33 39.66 36 18.63 24.15 57.47 17.97 21.86 35.45 7.67 34.32
16 Total
17 Relocation 1323.71 2813.99 694.47 3050.36 2387.33 340.58 1893.51 2375.29 2964.81 3778.31 2764.51 4239.04
18 Veterinary 1727.69 174.66 4028.66 646.21 3094.14 753.83 3335.82 26.2 1051.52 3373.79 139.1 2872.11
Tiger
19 Food 4319.77 2678.66 803.92 2731.27 3085.12 854.12 1463.75 1310.9 1850.41 1611.76 1603.44 1308.39
20 Total
21
22 Project Balance
23 Elephant
24 Monkey
25 Tiger

[7]

10 Place in appropriate cells functions to calculate the total expenditure for each project for each
month. [3]

11 Place in cell C23 a formula to calculate the balance for the Elephant project in January. This is the
income for this project for this month minus the total expenditure for this project for this month.
Calculate, in cells C24 and C25, the balances for the other two projects. Replicate these three
formulae for all other months. [4]

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


www.dynamicpapers.com
7

12 Apply appropriate formatting to all cells containing numeric data. [1]

13 Apply conditional formatting to only the cells in the range C23 to N25 so that if a cell contains a
value:

• greater than or equal to zero, the cell has a light‑green background with dark‑blue text
• less than zero, the cell has red text on a white background.

Place in your Evidence Document a screenshot showing the conditional formatting rules, cell
ranges and formats.
[6]

14 Save your spreadsheet.

Print your spreadsheet showing the formulae.

Make sure:

• the row and column headings are displayed


• the page orientation is landscape
• the contents of all cells are fully visible and can be easily read.
[1]

15 Print your spreadsheet showing the values.

Make sure:

• the printout fits on a single landscape page


• the row and column headings are not displayed
• the contents of all cells are fully visible and can be easily read.
[1]

[Total: 29]

Task 5 – Printing the Evidence Document

Make sure your name, centre number and candidate number appear on every page of your Evidence
Document.

Save and print your Evidence Document.

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


www.dynamicpapers.com
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


www.dynamicpapers.com
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


www.dynamicpapers.com
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

You might also like