Cambridge International AS & A Level

INFORMATION TECHNOLOGY 9626/04

Paper 4 Advanced Practical May/June 2025
MARK SCHEME
Maximum Mark: 90

Published

This mark scheme is published as an aid to teachers and candidates, to indicate the requirements of the
examination. It shows the basis on which Examiners were instructed to award marks. It does not indicate the
details of the discussions that took place at an Examiners’ meeting before marking began, which would have
considered the acceptability of alternative answers.

Mark schemes should be read in conjunction with the question paper and the Principal Examiner Report for
Teachers.

Cambridge International will not enter into discussions about these mark schemes.

Cambridge International is publishing the mark schemes for the May/June 2025 series for most
Cambridge IGCSE, Cambridge International A and AS Level components, and some Cambridge O Level
components.

This document consists of 7 printed pages.

© Cambridge University Press & Assessment 2025 [Turn over

9626/04 Cambridge International AS & A Level – Mark Scheme May/June 2025
PUBLISHED

Generic Marking Principles

These general marking principles must be applied by all examiners when marking candidate answers.
They should be applied alongside the specific content of the mark scheme or generic level
descriptions for a question. Each question paper and mark scheme will also comply with these
marking principles.

GENERIC MARKING PRINCIPLE 1:

Marks must be awarded in line with:

• the specific content of the mark scheme or the generic level descriptors for the question
• the specific skills defined in the mark scheme or in the generic level descriptors for the question
• the standard of response required by a candidate as exemplified by the standardisation scripts.

GENERIC MARKING PRINCIPLE 2:

Marks awarded are always whole marks (not half marks, or other fractions).

GENERIC MARKING PRINCIPLE 3:

Marks must be awarded positively:

• marks are awarded for correct/valid answers, as defined in the mark scheme. However, credit
is given for valid answers which go beyond the scope of the syllabus and mark scheme,
referring to your Team Leader as appropriate
• marks are awarded when candidates clearly demonstrate what they know and can do
• marks are not deducted for errors
• marks are not deducted for omissions
• answers should only be judged on the quality of spelling, punctuation and grammar when these
features are specifically assessed by the question as indicated by the mark scheme. The
meaning, however, should be unambiguous.

GENERIC MARKING PRINCIPLE 4:

Rules must be applied consistently, e.g. in situations where candidates have not followed
instructions or in the application of generic level descriptors.

GENERIC MARKING PRINCIPLE 5:

Marks should be awarded using the full range of marks defined in the mark scheme for the question
(however; the use of the full mark range may be limited according to the quality of the candidate
responses seen).

GENERIC MARKING PRINCIPLE 6:

Marks awarded are based solely on the requirements as defined in the mark scheme. Marks should
not be awarded with grade thresholds or grade descriptors in mind.

© Cambridge University Press & Assessment 2025 Page 2 of 7

9626/04 Cambridge International AS & A Level – Mark Scheme May/June 2025
PUBLISHED

Question Answer Marks

Task 1(a) – Database

Candidate file Week21_

1(a)(a) 3 tables and a link table created (Sales / Transactions / Invoices / Orders) 1

Single link table created with a valid primary key included 1

No duplication of fields seen in the tables and relationships established 1

1(a)(b) Trader table created - records - Valid primary key 1

Car table created 1

Data for 155 cars imported 1

Buyer table created with a valid primary key 1

Data for 112 buyers imported 1

1(a)(c) Sold_for field set as currency 1

Warranty field set as yes/no
Year and mileage fields set as number

Fees field set as a calculation - may be in a table, a query or in the form 1

Valid calculation e.g: 1

IIf([Sold_for]<1000,[Sold_for]*0.05,IIf([Sold_for]<=2000,[Sold_for]*0.04,[Sold_f
or]*0.03)) or equivalent with correct inequalities

The relationships work - records expand 1

e.g. - Buyers table shows car purchased by each buyer

1(a)(d) Form created - yellow header - dark text - small car logo in correct place - all 1
visible

Title text correct - Formatted as shown 1

Subtitle correct - smaller - formatted as shown 1

1(a)(e) Trader labels (all) correct, and all trader data as shown - all visible with larger 1
car logo

Trader labels and fields all correctly aligned and sized as shown - all visible 1
with no boxes

Cars Sold/Unsold labels correct - subforms and fields as shown 1

1(a)(f) Sold subform fields – Car_id, Make, Model, Year, Mileage, Sold_for, Fee 1
All visible without horizontal scrolling

Unsold Subform fields - Car_id, Make, Model, Year, Mileage, Day_in_Sale 1

All visible without horizontal scrolling

© Cambridge University Press & Assessment 2025 Page 3 of 7

9626/04 Cambridge International AS & A Level – Mark Scheme May/June 2025
PUBLISHED

Question Answer Marks

1(a)(g) Sold data changes for each trader 1

Unsold data changes for each trader- Sold/Unsold data must not match 1

1(a)(h) Tawara City Motors - Sold data shows - Sulzo Doopi, Faux Furrorus 1

Tawara City Motors Sold Fees show £43.00, £89.70 - Independent for correct 1
values

Tawara City Motors Unsold data shows - Faux Rrari, Ayoto Applause 1

1(a)(i) Tawara Auto Ace - Sold data shows 6 sales only 1

Caudy Pantanal, Cryst Fjord, Bennro Celario, Vuall Yeet, Bennro Toppo,
Puzzilo Mozilo

Tawara Auto Ace - Unsold data - 1 sale only - Cryst Glacier 1

No scroll bars in either subform - must see both subforms 1

No navigation controls shown in the subforms 1

1(a)(j) Data entry disabled in the main form 1

1(a)(k) Correct labels for Total Sales, Total Fees and Balance 1

3 labels and 3 fields aligned left - labels and data spaced evenly - must see 1
data

Total Sales calculation (valid attempt) - checked in design view 1

Total Fees calculation (valid attempt) - checked in design view 1

Balance calculation (valid attempt) - checked for accuracy 1

1(a)(l) Total Sales and Total Fees values correct and change with trader 1
Tawara City Motors = £3,850, £132.70 as initial reference

Balance values correct and change with trader 1

Tawara City Motors = £3717.30 as initial reference

© Cambridge University Press & Assessment 2025 Page 4 of 7

9626/04 Cambridge International AS & A Level – Mark Scheme May/June 2025
PUBLISHED

Question Answer Marks

Task 1(b) – Database reports

Candidate file Week21Report_

1(b)(a) Report created – checked in print preview and/or pdf 1

Correct banner text - Tawara Auctions – Car Sales – Weekly report 1

Banner text as two fields - text size different – all visible 1

1(b)(b) Traders grouped 1

Trader name in line with field labels - (Year, Make Model, Sold_for, Fee) 1

Formatting, field spacing and column alignment as shown 1

Totals shown below (grouped) sales data - (Sold_for and Fee) 1

Totals - dividing lines - top and bottom 1

1(b)(c) Totals label bold 1

Total values bold – with no bounding boxes 1

Only sold cars listed for each trader 1

1(b)(d) pdf created 1

One trader per page 1

© Cambridge University Press & Assessment 2025 Page 5 of 7

9626/04 Cambridge International AS & A Level – Mark Scheme May/June 2025
PUBLISHED

Question Answer Marks

Task 2 – Mail merge

Candidate files MergeDoc_ and ReceiptsDoc_

2(a) Data source in database - not spreadsheet - must see prompt for source 1

IF {MERGEFIELD Warranty} = conditional field used in the merge doc 1

17 or 20 letters or <> Monday seen in database or SKIPIF in the merge doc 1

17 letters or evidence of fully correct selection seen in database or SKIPIFs in 1

the merge doc

2(b) Date in correct format e.g. Wednesday, 23 April 2025 1

Address block - 3 correct fields – 1 field per line 1

Salutation - Title and Family name (only) complete and spaced correctly 1

2(c) Vehicle Make and Model merge fields inserted and spaced correctly 1

Registered: {MERGEFIELD Year} inserted and spaced correctly 1

From: {MERGEFIELD Trader} name inserted and spaced correctly 1

2(d) {IF{MERGEFIELD}=Warranty} = "False" or "True", "Yes" or "No" or null used 1

{If MERGEFIELD Year} >=2024 or >2023 used 1

{MERGEFIELD Year} inserted in "Since the year…" text 1

All three warranty text options present 1

Single (nested) conditional field block for all warranty text 1

Must cover all options - confirm, still, refund

2(e) Letters merged 1

Correct text for confirms warranty statement - (Griffin, Herbert, Fry) 1

Correct text for 2024/5 warranty refund statement – (Hicks, John) 1

Correct text for Warranty still available statement - (12) 1

All letters are fit for purpose with the correct formatting and spacing 1

© Cambridge University Press & Assessment 2025 Page 6 of 7

9626/04 Cambridge International AS & A Level – Mark Scheme May/June 2025
PUBLISHED

Question Answer Marks

Task 3 – Animation
Candidate files Race_

3(a) Set to 800 x 200 1

Grey road - blue background 1

3(b) The frame is stable with no gaps at the top, bottom or sides 1
No disturbance - nothing shows outside the frame

The barrier always fills frame and moves right to left convincingly 1

The barrier moves right to left quite smoothly with no 'twitch' or halt 1

The barrier is intact at all times with no overlap or gaps 1

The squares are undistorted

The barrier is static vertically 1

3(c) The red car is always central, always visible and the correct size 1

The red car vertical position is correct 1

No barrier is seen beneath the car

The red car static horizontally and vertically 1

3(d) The green car is off screen at start and enters incrementally from the left 1

The green car completes the traverse left to right 1

The green car takes 6 seconds to entirely traverse the frame 1

The green car moves horizontally only 1

The green car vertical position is suitable, the size is correct, and all wheels 1
are within the frame

3(e) The green car moves in front of the static red car 1

The green car leaves the frame entirely 1

The green car moves smoothly at a constant speed 1

The green car starts to reappear from offscreen after completely leaving from 1
the right

3(f) The animation loops seamlessly without a ‘twitchy’ restart 1

© Cambridge University Press & Assessment 2025 Page 7 of 7