Cambridge International AS & A Level: Information Technology 9626/02
Cambridge International AS & A Level: Information Technology 9626/02
Cambridge International AS & A Level: Information Technology 9626/02
com
2 hours 30 minutes
INSTRUCTIONS
● Carry out every instruction in each task.
● Save your work using the file names given in the task as and when instructed.
● You must not have access to either the internet or any email system during this examination.
● You must save your work in the correct file format as stated in the tasks. If work is saved in an incorrect
file format, you will not receive marks for that task.
INFORMATION
● The total mark for this paper is 90.
● The number of marks for each question or part question is shown in brackets [ ].
DC (PQ) 303246/2
© UCLES 2022 [Turn over
www.dynamicpapers.com
2
n22english.csv
n22it.csv
n22maths.csv
n22science.csv
n22student.csv
n22teo.mp4
n22voiceover.mp3
You must use the most efficient method to solve each task. All documents and videos produced must
be of a professional standard and suit the business context.
Create a new document to use as an Evidence Document. Save this document in rich text format
with the file name N22_ followed by your centre number_candidate number
e.g. N22_ZZ999_9999.rtf
Place your name, centre number and candidate number in the header of your Evidence Document.
You work for Tawara High School which has chosen to support the Tawara Elephant Orphanage for its
annual charity event. You will create a short video to show to the students. The original video clip was
recorded by GBRvideo and the audio was recorded by KMBaudio.
1 Open the file n22teo.mp4 in your video editing software. Make sure the aspect ratio is 16:9.
Remove the end of the clip so that only the first 22 seconds remain. Remove all sound from the
clip.
Use pan and zoom to remove the crowd on the left of the frames from the start of the video clip.
Keep the elephant in the frames at all times.
Save your video clip in .mp4 format with a resolution of 1280 × 720 and the file name teo2_
followed by your centre number_candidate number
e.g. teo2_ZZ999_9999 [7]
2 Take a still image of the first frame of the clip saved in step 1.
Save it with the file name teo1 in a format suitable for importing into your video editing software.
[2]
3 Take a still image of the last frame of the clip saved in step 1.
Save it with the file name teo3 in a format suitable for importing into your video editing software.
[1]
4 Use the files saved in steps 1 to 3 to create a video clip to match this storyboard.
Time 0 seconds:
Time 3 seconds:
The title text and background remain, with the subtitle Tawara Elephant Orphanage added
below the title.
Time 6 seconds:
All elements added so far remain, with the text Help us to support them added as a new line
below the existing text.
Time 9 seconds:
No text displayed.
Time 31 seconds:
Display appropriate credits to scroll up the screen, including the text Edited by: and your
name, centre number, candidate number. [26]
5 Save your video clip in .mp4 format with a resolution of 1280 × 720 and the file name teo4_
followed by your centre number_candidate number
e.g. teo4_ZZ999_9999 [1]
You will design a database about students and their classes. Each student studies 4 subjects and
is only in one class per subject. The timetable for each subject is currently stored in a separate file.
These files will be merged into a single file suitable for importing into a database normalised to third
normal form (3NF).
n22english.csv
n22it.csv
n22maths.csv
n22science.csv
Place in your Evidence Document screenshots of the method you use to manipulate the contents
of n22english.csv so that it has the same layout as the other 3 files.
n22english1.csv
n22it.csv
n22maths.csv
n22science.csv
n22student.csv
n22timetable.csv
Create, in your Evidence Document, a physical entity relationship diagram to design the database
to third normal form (3NF) using only this data.
9 Use your entity relationship diagram and the data files opened in step 8 to create a relational
database normalised to third normal form (3NF). Enforce referential integrity in all relationships.
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.