Cambridge A Level Information Technology (from 2017) 9626 — 2025 May/June Paper 4 · Variant 0

This document has 8 pages. Any blank pages are indicated.  [Turn over Cambridge International AS & A Level INFORMATION TECHNOLOGY 9626/04 Paper 4 Advanced Practical May/June 2025 2 hours 30 minutes You will need: Candidate source files (listed on page 2) 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 [ ]. * 3 9 6 5 7 7 0 9 9 9 * DC (CJ/CB) 344503/2 © UCLES 2025

2 9626/04/M/J/25 © UCLES 2025 You have been supplied with the following source files: Barrier.png FunCar.png GreenCar.png Receipt.rtf RedCar.png Week21.csv Create a folder called Examination. You must save all your work in this folder. Copy these files into this folder. Do not delete the source files when submitting your work. Do not tidy the folder by deleting files created at any stage of attempting the tasks. You must use the most efficient methods to solve each task. All work produced must be of a professional standard and contain your candidate details. Task 1 (a) Create a relational database normalised to third normal form (3NF), using the data in the Week21.csv file. Name the database Week21_ followed by your centre number_candidate number. For example, Week21_ZZ999_9999 Make sure all fields in the database use appropriate names and data types. Display all currency values in GBP (£). If this is not available, use your local currency. Create a calculated field named Fee which is charged for each car sold. Calculate this fee based upon the Sold_for value. If this value is: • less than £1000, then the Fee is 5% of the Sold_for value • up to and including £2000, then the Fee is 4% of the Sold_for value • over £2000, then the Fee is 3% of the Sold_for value.

3 9626/04/M/J/25 © UCLES 2025 [Turn over Create a form named Traders containing two subforms to display the data, layout and formatting as shown. The form is for viewing data only. Disable data entry, and make sure that all the fields are fully visible. Add calculated controls to display the Total Sales and the Total Fees. Add another calculated control to display the Balance which is the Total Sales minus the Total Fees. Resave the form as TraderPlusSums  [37]

4 9626/04/M/J/25 © UCLES 2025 (b) Create a report to list the cars sold for each trader. Name the report Week21Summary The report must look like this:

5 9626/04/M/J/25 © UCLES 2025 [Turn over When printed, the report must display each trader on a separate page and show the banner heading on each page like this: Export the report to a pdf file named Week21Report_ followed by your centre number_ candidate number. For example, Week21Report_ZZ999_9999  [13]

6 9626/04/M/J/25 © UCLES 2025 Task 2 Use your database and Receipt.rtf as the template to mail merge letters for people who bought cars and paid for a warranty in the Monday Auction. Exclude all letters where the Trader was Tawara Auto Emporium. Follow these rules to display conditional text. Letters to buyers who did not purchase a warranty should include the following text: Warranties are still available for purchase for up to one month after the sale, please contact us at the above address if you would like to reconsider. Letters to buyers who did purchase a warranty should include the following text: This receipt also confirms a one-year warranty for parts and repairs. Letters to customers who did purchase a warranty but the year of the car is 2024 or later should include the following text: Since the year of your vehicle is <Insert year here> your purchase of our warranty was unnecessary. We have refunded the sum to your account. Save the merge document as MergeDoc_ followed by your centre number_candidate number. For example, MergeDoc_ZZ999_9999 Merge the individual letters to a file named ReceiptsDoc_ followed by your centre number_candidate number. For example, ReceiptsDoc_ZZ999_9999  [20]

7 9626/04/M/J/25 © UCLES 2025 Task 3 You must use Barrier.png, GreenCar.png and RedCar.png to create an animation of two cars that appear to be racing. Set a frame size of 800 pixels by 200 pixels and colour the road and the sky as shown. The red car must always be in the centre of the frame. The barrier image must travel from right to left so that the red car seems to be moving. The barrier must move five squares to the left every second. The green car must enter from the left and take six seconds to pass the red car and leave the frame. The animation must loop continuously. Save the animation as an animated gif named Race_ followed by your centre number_candidate number. For example, Race_ZZ999_9999  [20]

8 9626/04/M/J/25 © UCLES 2025 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. BLANK PAGE