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

[Turn over Cambridge International AS & A Level DC (WW/CB) 344481/3 © UCLES 2025 This document has 12 pages. Any blank pages are indicated. * 7 6 9 0 7 1 8 2 0 7 * INFORMATION TECHNOLOGY 9626/04 Paper 4 Advanced Practical February/March 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 [ ].

2 9626/04/F/M/25 © UCLES 2025 You have been supplied with the following source files: 1.svg 2.svg 3.svg 4.svg 5.svg 6.svg 7.svg 8.svg 9.svg Colleges.csv Tier.png Create a folder called Examination You must save all your work in this folder. Copy the source files into this folder. Do not delete these 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.

3 9626/04/F/M/25 © UCLES 2025 [Turn over Task 1 You have been supplied with a file that contains details of scores for a common grading test used in three colleges. Open Colleges.csv in a spreadsheet software. Rename the worksheet as 2025Data Format the cells as shown. 1 2 1 3 4 5 6 7 53 58 60 61 66 41 61 66 80 68 72 54 2 3 A B C Tawara Elementary Tawara Technical Tawara Modern Colleges Save the workbook in spreadsheet format as TestAnalysis_ followed by your centre number_candidate number. For example, TestAnalysis_ZZ999_9999 Add a new worksheet to the workbook. Name the worksheet 2025Analysis Create a drop-down list in cell B2 so users can select a college from the 2025Data sheet. A 1 2 3 4 B Tawara Technical College Tawara Elementary Tawara Technical Tawara Modern When a college is selected, all the data for the college must be displayed under the selection. B 53 61 61 68 Tawara Elementary College B 58 66 66 73 Tawara Technical College

4 9626/04/F/M/25 © UCLES 2025 The data must be used to create charts with different marks intervals. Label and format the cells as shown. 2 1 4 3 5 6 7 8 9 10 D Maximum test score Marks interval Lower Limit Upper Limit Range E F You will enter a Maximum test score in E2. The Marks interval values must be restricted to only 5 or 10 and be selected from a drop-down list. Maximum test score Marks interval 2 1 3 4 5 5 90 10 5 Upper Limit Lower Limit Range 6 7 D E F

5 9626/04/F/M/25 © UCLES 2025 [Turn over The Lower Limit must always start at zero. The Upper Limit must always start with the Marks interval. Add replicable formulae to display the Lower Limit, Upper Limit and Range as shown in these examples. 90 10 10 20 30 40 50 60 70 80 90 0-10 11-20 21-30 31-40 41-50 51-60 61-70 71-80 81-90 0 11 21 31 41 51 61 71 81 Maximum test score Marks interval Lower Limit Upper Limit Range Example 1 with a Maximum test score of 90 and a Marks interval of 10 100 5 5 10 15 20 25 30 35 40 45 50 55 60 65 70 75 80 85 90 95 100 0-5 6-10 11-15 16-20 21-25 26-30 31-35 36-40 41-45 46-50 51-55 56-60 61-65 66-70 71-75 76-80 81-85 86-90 91-95 96-100 0 6 11 16 21 26 31 36 41 46 51 56 61 66 71 76 81 86 91 96 Maximum test score Marks interval Lower Limit Upper Limit Range Example 2 with a Maximum test score of 100 and a Marks interval of 5 Add a Frequency column as shown: 2 1 4 3 5 6 7 8 9 D Maximum test score Marks interval Lower Limit Upper Limit Range Frequency E F G 0 6 5 5 90 10 0-5 6-10

6 9626/04/F/M/25 © UCLES 2025 Insert a replicable formula to count the number of marks that are in each Range for the college selected.

7 9626/04/F/M/25 © UCLES 2025 [Turn over Use this data to create a chart to display the frequency of each range. Label the chart with a dynamic title. The chart must be formatted exactly as shown. [35]

8 9626/04/F/M/25 © UCLES 2025 Task 2 (a) Create a jigsaw piece template as shown here: The piece must be based upon an 80 mm square. Save the piece as a .svg file named JigTemplate_ followed by your centre number_candidate number. For example, JigTemplate_ZZ999_9999 Fit four copies of the JigTemplate_ image together as shown. Save the image as a .png file named 4Pieces_ followed by your centre number_candidate number. For example, 4Pieces_ZZ999_9999 [13]

9 9626/04/F/M/25 © UCLES 2025 [Turn over (b) Open Tier.png in a graphics application software. Use your JigTemplate_ image to cut the Tier.png image into four pieces. The pieces must fit together. TierPiece1 TierPiece2 TierPiece4 TierPiece3 Save each piece as a .png file named TierPiece1 to TierPiece4 as shown. Fit the four pieces together and save the complete image as a .png file named 4Pngs_ followed by your centre number_candidate number. For example, 4Pngs_ZZ999_9999 [20]

10 9626/04/F/M/25 © UCLES 2025 Task 3 In an animation application software set a frame size of 600 pixels wide and 600 pixels high. Each numbered .svg file, found in the source files, must be animated and should take 1 second to move into position. The pieces should move in order and towards the direction shown. Note that some pieces may need to be rotated during the animation to fit properly. The ninth piece should take 1 second to fade into view at the correct position.

11 9626/04/F/M/25 © UCLES 2025 Add the text Putting it all together above the image at the start of the animation. The text must grow from 12pt to the width of the image as all the pieces are moving into position. Save the animation in .gif format with the file name TierLogoAnimation_ followed by your centre number_candidate number. For example, TierLogoAnimation_ZZ999_9999 [22]

12 9626/04/F/M/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