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.

Practise this in the app: instant marking and a fix for every mistake. Free, no email needed to start.

Practise this lesson

The paper

What the questions look like

From the June 2024 paper (80 marks), demand rising through the paper:

June 2025 followed the same pattern with an activities and classes scenario.

How it is marked

Evidence technique

Worked example

A query question is worth 6 marks. How long should you spend and what evidence do you give?

  1. Time: 6 x 2.25 = 13.5 minutes, about 13 to 14 minutes.
  2. Build the query, check results against the data by hand.
  3. 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.

Key idea: 3 hours, 80 marks, all compulsory, set in a context, data files supplied, everything evidenced in the word-processed template. Point-marked practical tasks (show every feature in the right view) and two levels-marked 9-mark analyses. About 2.25 minutes per mark; legible, complete screen prints.

Check yourself

  1. 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.

  2. 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.

  3. 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%.

  4. 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.

  5. 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.

  6. 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.

  7. 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.

Practise with instant feedback

Sources

Last updated 8 November 2026. Spotted a mistake? Tell us.