A second full 50-mark Paper 032 style practice paper that tests different tools: mail merge and table of contents, pivot table and charts, forms and sub-forms, and a loop-based program.
4 narrated scenes. Press play, listen and read along — the points appear as they are explained. Use ‹ Prev / Next › or the scene bar to jump to any scene.
A second full paper gives you a second chance to find gaps. This one emphasises the advanced features worth 5 marks each in the SBA.
Narration uses your device’s built-in voice. No sound? Switch to “Captions only” — the captions advance on their own.
Copy these into your notebook in your own words — that is how they stick.
5 tasks, 50 marks, 2 hours.
Mail merge and table of contents.
Pivot table and chart.
Main form with sub-form; calculated query; report.
Web page with links.
Loop with validation; trace table.
Compare your score with Paper 1.
Redo the weakest task.
8 items modelled on real CSEC Paper 1 questions. Choose one answer for each, then check. Aim for 80% or better. Work each item on paper first.
Write full answers, then reveal the mark scheme and tick the points you earned (50 marks in total). Show all your working — method marks count. Your answers are saved on this device.
Question 1 [9 marks]
Create a letter inviting parents to a PTA meeting. Save as Q1_Letter.
(a) (a) Create a data source with the fields Title, Surname and Address for 4 parents. [3]
(b) (b) Insert merge fields in the letter and merge. [4]
(c) (c) Format the letter with a bold heading and justified body. [2]
Question 2 [10 marks]
Sales data: Region, Product, Sales for 12 rows. Save as Q2_Pivot.
(a) (a) Create a pivot table showing total Sales by Region. [4]
(b) (b) Create a labelled chart of the pivot results. [3]
(c) (c) Filter the original data to show Sales above 500. [2]
(d) (d) Write the formula to find the average Sales. [1]
Question 3 [10 marks]
Tables Class(ClassID, Teacher) and Student(StudentID, Name, ClassID, Mark). Save as Q3_School.
(a) (a) Create the relationship between the tables. [2]
(b) (b) Create a main form from Class with a sub-form of Students. [3]
(c) (c) Create a query with a calculated field showing Mark as a percentage of 50. [2]
(d) (d) Create a grouped report by Class. [3]
Question 4 [6 marks]
Create a one-page web page for a library. Save as Q4_Library.
(a) (a) Add logo, navigation and content areas. [3]
(b) (b) Add a hyperlink to an email address and a bookmark link back to the top. [2]
(c) (c) Check all links work. [1]
Question 5 [15 marks]
Write a program that reads 5 marks (0 to 100), rejects invalid marks, and displays the highest mark and the average.
(a) (a) Complete an IPO chart. [3]
(b) (b) Write pseudocode. [6]
(c) (c) Complete a trace table for the marks 60, 150, 80, 40, 90, 70. [4]
(d) (d) Add comments and documentation. [2]
Everything in this lesson is based on these parts of the CXC syllabus and papers.