All subjects · Information Technology · WIT14 3 hour practical exam on database solutions
The Unit 4 practical exam: how it works
Edexcel IAL Information Technology · WIT14 3 hour practical exam on database solutions
Unit 4 (WIT14) is a 3 hour practical exam taken on a computer. Knowing exactly how it runs, how the marks are given and how to present evidence is worth as many marks as any single topic.
The paper
- 3 hours, 80 marks, 25% of the International A level. All questions are compulsory.
- An unseen paper with practical and theoretical questions, set in an overall context (a business scenario).
- You are given data files for some questions. In June 2024 these were a database (.accdb, the Microsoft Access format), a text file of sales and the candidate evidence template (.docx).
- All responses go into the word-processed candidate evidence template: screen prints for practical tasks and typed answers for written ones.
- Assessment objectives for Unit 4: AO2 (apply) 10%, AO3 (analyse and evaluate) 2% and AO4 (design solutions) 13% of the qualification. There is no AO1 (recall) weighting.
- Offered in the June series. The specification does not name the database software; Pearson's papers, scheme of work and mark schemes are written around Microsoft Access, so check with your centre which software and version you will use.
What the questions look like
From the June 2024 paper (80 marks), demand rising through the paper:
- Q1 (28 marks): fix a data type; add a range check; build a user-friendly data entry form with automation; extend the structure to store a supplied file (minimal duplication, keys, referential integrity) with a typed justification; import the data and show the record count.
- Q2 (28 marks): a select query with criteria and sorting; a query feeding a grouped report that must match a given layout; a 9-mark written analysis.
- Q3 (10 marks): a calculated query and a chart report.
- Q4 (5 marks): a dashboard with labelled buttons.
- Q5 (9 marks): a written analysis of how the structure must change to support a new form.
June 2025 followed the same pattern with an activities and classes scenario.
How it is marked
- Practical tasks are point marked: each mark is a specific feature (a criterion, a sort, a heading, a key), and some marks are only given from a particular view (for example 'mark from Design view only'). If the examiner cannot see it, it cannot be credited.
- The two 9-mark written questions are levels marked: Level 1 (1 to 3 marks), Level 2 (4 to 6), Level 3 (7 to 9), judged on how sound and developed the analysis is and how workable the solution is. See the next lesson.
Evidence technique
- Save the template under the name the paper gives (centre number, candidate number, surname, initial) and re-save regularly. Submit only the completed template.
- Screen prints must be legible when zoomed: crop to the relevant window and enlarge. Show criteria, field names and expressions in full (widen columns first).
- Provide every view asked for: design view and datasheet view of a query; design view and print preview of a report; form view, design view of macros and the property sheet.
- Use the scenario's names and follow its instructions exactly; do not modify the database when a question says not to.
- Budget time: 180 minutes / 80 marks = 2.25 minutes per mark.
Worked example
A query question is worth 6 marks. How long should you spend and what evidence do you give?
- Time: 6 x 2.25 = 13.5 minutes, about 13 to 14 minutes.
- Build the query, check results against the data by hand.
- Screen print design view with all fields, criteria and sort visible, and datasheet view showing the results.
Answer: About 13.5 minutes; design view and datasheet view, fully legible.
Check yourself
- The paper lasts 3 hours and has 80 marks. How many minutes is that per mark?
Show answer
2.25 minutes. 180 / 80 = 2.25 minutes per mark.
- In June 2024, Question 1 was worth 28 marks. Using 180 minutes for 80 marks, how many minutes should it take?
Show answer
63 minutes. 28 x 2.25 = 63 minutes.
- Unit 4's assessment objective weightings are AO2 10%, AO3 2% and AO4 13% of the qualification. What percentage of the full International A level is Unit 4?
Show answer
25 %. 10 + 2 + 13 = 25%.
- How are your practical answers submitted?
- By handing in the database file only
- Written on paper
- As screen prints pasted into the word-processed candidate evidence template
- By email to the examiner
Show answer
As screen prints pasted into the word-processed candidate evidence template. All responses are submitted using the candidate evidence template.
- A report mark says 'mark from Design view only'. What does this mean for your evidence?
- You must include a design view screen print or the mark cannot be awarded
- Only print preview is marked
- The report must be printed
- Design view is optional
Show answer
You must include a design view screen print or the mark cannot be awarded. Some features (such as a title in the report header) are checked in a specific view.
- Which habit most often costs candidates marks according to the examiner reports?
- Saving too often
- Using the scenario's field names
- Screen prints too small to read and criteria cut off
- Testing queries by hand
Show answer
Screen prints too small to read and criteria cut off. Unreadable or truncated evidence cannot be credited.
- What does the specification say about which database software to use?
- It does not name it; Pearson's materials are written around Microsoft Access, so check with your centre
- It must be MySQL
- Any spreadsheet is allowed
- Only SQL typed at a command line is allowed
Show answer
It does not name it; Pearson's materials are written around Microsoft Access, so check with your centre. The spec only says database software and tools; the supplied files have been .accdb.
Sources
- Pearson Edexcel International Advanced Level in Information Technology specification (Issue 2, February 2021): Unit 4, Topics 17 to 19
- Pearson: WIT14/01 question paper, June 2024
- Pearson: WIT14/01 mark scheme, June 2024
- Pearson: WIT14/01 examiner report, June 2024
- Pearson: WIT14/01 examiner report, June 2025
- Pearson: IAL Information Technology scheme of work for Unit 4
Last updated 8 November 2026. Spotted a mistake? Tell us.