AS & A Level Information Technology (9626) — May–June 2024, Paper 04

5 questions · every question answerable online with instant point-by-point AI marking against the official mark scheme.

Start with Question 1a →
Question 1a · 10 marks · Spreadsheets

Task 1(a) — Spreadsheet: Open CakeSalesData.xls for Llfan Bakery's April 2024 sales. Create a single replicable formula to calculate the cost including tax (items with a TaxCode…

Answer this question and get it marked →
Question 1b · 20 marks · Databases

Task 1(b) — Database and invoices: Create a database using the data from your spreadsheet. Create a database report to display invoices for each customer whose Terms are monthly,…

Answer this question and get it marked →
Question 1c · 22 marks · Document production

Task 1(c) — Mail merge letters: Use MMergeTemplate.rtf to create mail merge letters for customers whose Terms are Payment on delivery. Add merge fields and conditional text as…

Answer this question and get it marked →
Question 2 · 23 marks · Graphics

Task 2 — Vector graphic image: Create a vector graphic image of a cake showing: a symmetrical orange gradient dome top layer, a red jam band with gradient, a brown chocolate base…

Answer this question and get it marked →
Question 3 · 15 marks · Multimedia

Task 3 — Animation: Create an animation advertising a cake customisation service. Set the stage to 640 x 480 pixels. Use CakeBase.png as the background. Add the text 'Your message…

Answer this question and get it marked →

← May–June 2024 Paper 11 · May–June 2024 Paper 02 →

← All AS & A Level Information Technology (9626) past papers