A full 50-mark Paper 032 style practice paper: four productivity tool tasks (35 marks) and one program-design task (15 marks), to do on your own computer and self-mark with the scheme.
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.
Fifty marks, five tasks, two hours. Do it on the computer as you would in the exam, then tick the mark scheme.
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.
Word processing 9: formatting, table, TOC or merge.
Spreadsheet 10: formulae, $ reference, sort, chart.
Database 10: table, keys, query, report.
Web page 6: logo, nav, two hyperlinks.
Program 15: IPO, algorithm, trace, code.
Tick each point in the scheme.
Practise your lowest-scoring tool.
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]
Open (or type) a notice for Sports Day. Save it as Q1_Document.
(a) (a) Type the text, with a centred bold 18 pt heading, left-justified body text and the date in italics. [3]
(b) (b) Insert a table of 3 columns and 4 rows listing events, times and venues, with a shaded heading row. [3]
(c) (c) Insert a footer with your candidate number and page number. [2]
(d) (d) Save the file under the required name. [1]
Question 2 [10 marks]
Create a sheet with Item, Price and Qty in columns A to C (5 items) and the VAT rate 15% in cell F1. Save as Q2_Sheet.
(a) (a) Enter a formula in D2 for the total (Price × Qty) and fill it down. [2]
(b) (b) Enter a formula in E2 for VAT using an absolute reference to F1 and fill down. [3]
(c) (c) Use functions to find the sum of D and the highest total. [2]
(d) (d) Sort by total (largest first) and create a labelled column chart of the item totals. [3]
Question 3 [10 marks]
Create a database with a table Staff(StaffID, Name, Dept, Salary). Save as Q3_Database.
(a) (a) Set suitable data types and the primary key. [3]
(b) (b) Enter 6 records. [1]
(c) (c) Create a query listing staff in the IT department with salary above $50,000, sorted by Name. [3]
(d) (d) Create a grouped report by Dept with a title and a total of Salary for each department. [3]
Question 4 [6 marks]
Create a one-page website for a school club. Save as Q4_Web.
(a) (a) Add a logo, a heading, a navigation area and a content area. [3]
(b) (b) Add two different types of hyperlink. [2]
(c) (c) Use a consistent colour scheme suitable for the audience. [1]
Question 5 [15 marks]
A shop gives a 10% discount to customers who spend over $100. Write a program that reads the amount spent and displays the amount to pay.
(a) (a) Complete an IPO chart. [3]
(b) (b) Write pseudocode for the program. [5]
(c) (c) Complete a trace table for the amounts 80 and 150. [4]
(d) (d) Write the program in a language and add two comments. [3]
Everything in this lesson is based on these parts of the CXC syllabus and papers.