Mail-merge to 650 clients (printer, envelope, validation), cloud storage, storage devices, query/feature for "male clients in Christ Church". (20 marks)
(a)(i) State the type of printer MOST appropriate for printing the notices and envelopes. (1 mark)
Laser printer — fast, low cost-per-page, high quality, well suited to bulk-printing 650 letters and envelopes.
(a)(ii) State TWO field headings, from the list, that should NOT be used on the envelope. (2 marks)
Envelopes only need delivery information. Fields NOT needed: EMAIL ADDRESS and GENDER (some mark schemes also accept ACCT NUM). 1 mark each.
(a)(iii) Illustrate where the appropriate field headings should be placed on the envelope (preview). (3 marks)
The envelope should be marked up like this:
Top-right small box (return-address area or stamp box): may stay blank, or hold sender's address.
Centre rectangle (delivery address): placeholders «FIRST NAME» «LAST NAME» on the first line; «LOCAL ADDRESS» on the second line; «PARISH NAME» on the third line.
1 mark for the name line; 1 mark for the local-address line; 1 mark for the parish line, all placed inside the centre rectangle.
(a)(iv) State the type of document, needed to complete a mail merge, that is represented by the field headings. (1 mark)
Data source / Recipient list (also called the data file) — the table of merge fields that supplies the personalised values for each printed letter/envelope.
(a)(v) Suggest TWO possible causes when the printer stopped after page 450. (2 marks)
Out of paper — the input tray ran empty before all 650 pages printed.
Out of toner / ink — the cartridge ran low and the printer halted.
Other accepted: paper jam; print queue stalled / driver error; loss of network connection; printer buffer / RAM overload.
1 mark each.
(b)(i) State ONE direct-data-entry device that would support direct data entry. (1 mark)
Any one of: OCR scanner, OMR scanner, MICR reader, barcode scanner, magnetic stripe reader, biometric scanner.
(b)(ii) Identify an appropriate validation check that ensures all data for ONE client is entered before entering the next. (1 mark)
Presence check — the system flags any field that has been left empty and refuses to accept the record until every required field is filled in.
(c)(i)+(ii) Describe what is meant by 'cloud storage' AND state ONE advantage of using the cloud over local storage. (2 marks)
(i) Cloud storage: a service in which digital data is stored on remote servers managed by a provider (e.g., Google Drive, AWS S3, OneDrive) and accessed by users over the Internet rather than on a local device. (1 mark)
(ii) Advantage: Files are accessible from any Internet-connected device anywhere in the world, and they are backed up off-site — so a stolen or damaged company laptop does not lose the data. (1 mark)
(d) State the type of storage device MOST appropriate for EACH of the scenarios. (3 marks)
Scenario
Storage Device
A large amount of data stored for back-up and recovery purposes.
Magnetic tape (or external HDD / cloud archive) — high capacity, cheap per GB, ideal for cold/back-up storage.
Data that is frequently taken from one computer to another.
USB flash drive (thumb drive) — small, portable, plug-and-play.
Data that is stored as a file on a computer.
Hard disk drive (HDD) or SSD — the computer's main internal secondary storage.
1 mark each.
(e) State the spreadsheet function for: (i) Total number of clients (ii) Number of female clients. (2 marks)
(i) Total number of clients:=COUNTA(A2:A21) (or simply =COUNT( … ) on the ACCT NUM column). (1 mark)
(ii) Number of female clients:=COUNTIF(D2:D21, "F") (assuming the GENDER column is D). (1 mark)
(f) The company wants to know how many male clients reside in Christ Church. (i) State the feature that would extract these clients. (ii) Determine the number of clients produced. (2 marks)
(i) Feature:Filter (advanced filter) — set criteria GENDER = "M" AND PARISH NAME = "Christ Church". (1 mark)
(ii) Number of clients: applying the filter (GENDER = "M" AND PARISH NAME = "Christ Church") to the client list returns 3 clients. (1 mark)
Question 2
Word-processing scenario for Ali & Raffy: combine documents, comments, save, security, fillable form, validation vs verification. (20 marks)
(a) State TWO features that would produce a new document containing both the verse and chorus. (2 marks)
Copy and paste — copy the contents of one file and paste it into the other.
Insert → Object → Text from File (or "Insert as link") — this command embeds or merges the contents of one document into another.
Other accepted: "Save As" combined with copy/paste; using a master document.
1 mark each.
(b) State the purpose of including the comments feature in a document. (1 mark)
Comments allow collaborators to leave annotations or feedback in the margin without altering the actual document text — useful for suggestions, questions or review notes during co-authoring.
(c) Identify the feature that should be used to ensure the document is regularly updated. (1 mark)
AutoSave (or Save / Save automatically) — saves changes at regular intervals so updates are not lost.
(d) Suggest the BEST feature to ensure no one can view the content of the document. (1 mark)
Password protection / encryption — File → Info → Protect Document → "Encrypt with password". Only someone with the password can open and view the file.
(e) Suggest the feature both can use to see updates/amendments by each other. (1 mark)
Track Changes — every insertion, deletion or formatting edit is highlighted with the editor's name, so each collaborator can see exactly what the other has changed.
(f)(i) Identify FOUR labels and their associated content controls on the fillable form. (4 marks)
Label
Content Control
Full Name
Plain text content control ("Click to enter first name and last name").
Card Number
Repeating section / formatted text content control (the boxes for each digit).
Expiry Date
Date picker content control ("Select card expiry date").
(f)(ii) State TWO advantages of using a GUI instead of a command-line interface. (2 marks)
Easier for novice users — visual icons, menus, and point-and-click reduce the need to memorise commands. The interface is intuitive and self-documenting.
Faster for common tasks — clicking, dragging and dropping is generally quicker than typing long commands; mistakes are rarer because only valid options are presented.
Other accepted: WYSIWYG previews; fewer typing errors; consistent look-and-feel across applications; multi-tasking with windows.
1 mark each.
(g) Complete the table — definition + TWO examples for Validation and Verification. (8 marks)
Approach
Definition
Examples
Validation
Automatic check by the program that ensures entered data is sensible / reasonable / correctly formatted (but not necessarily correct against the source).
1. Range check (e.g., age between 0 and 120). 2. Format / picture check (e.g., NIS pattern AAA-999999).
Verification
Confirms that data has been entered correctly from the source document — checks the entered data matches the original.
1. Double-entry verification (data typed twice; system compares). 2. Visual / proofread verification (operator reads the screen against the source form).
2 marks for each definition + 1 mark per example × 2 examples each = 8 marks.
(a)(i) Write a spreadsheet formula/function to calculate the total traffic observed at 11 AM. (2 marks)
The 11 AM row holds counts of cars, trucks, buses, etc. Sum the cells in that row, e.g., 11 AM is row 7 with vehicle counts in B7:F7:
=SUM(B7:F7)
1 mark for SUM; 1 mark for correct range.
(a)(ii) Total road tax owed if every car that crosses the highway pays $5. (1 mark)
Multiply the total cars (column B Total) by 5. If "Total Cars" is in cell B11:
=B11*5
(b) State the feature that allows a user to summarise + manipulate data without making changes to the worksheet. (1 mark)
Pivot Table — interactively summarises and groups data without modifying the original worksheet.
(c) State the function that has produced the values in Column H (field heading "ANS"). (1 mark)
VLOOKUP — column H pulls a value (e.g., a category like "Toll Free" / "Pay Toll") by looking up the row total in a reference table.
(d) Syntax of VLOOKUP — VLOOKUP(P1, P2, P3, P4). State exactly what each parameter represents. (4 marks)
P1 (lookup_value): the value to search for in the first column of the lookup table.
P2 (table_array): the range of cells that contains the lookup table (with the value to match in its first column).
P3 (col_index_num): the column number within the table_array from which the matching value should be returned.
P4 (range_lookup): a logical value — TRUE for an approximate match (sorted lookup) or FALSE for an exact match.
1 mark each = 4 marks.
(e) From the algorithm "Accept total_vehicles; If total_vehicles > 500 Then print 'Toll Free'; Otherwise print 'Pay Toll'", identify (i) type of algorithm, (ii) ONE variable, (iii) type of branching used. (3 marks)
(i) Type of algorithm:Selection / decision algorithm (uses an IF condition to choose between two outputs). (1 mark)
(ii) ONE variable:total_vehicles. (1 mark)
(iii) Type of branching:Two-way (binary) branching — IF…ELSE. (1 mark)
(f) Use the algorithm in (e) to create the IPO chart. (4 marks)
Input
Processing
Output
total_vehicles
IF total_vehicles > 500 THEN print "Toll Free" ELSE print "Pay Toll"
"Toll Free" or "Pay Toll" (depending on input)
1 mark Input column; 2 marks Processing column (correct condition + both branches); 1 mark Output column.
(g) List THREE numbers that could be used to adequately test many aspects of the algorithm. (3 marks)
Choose boundary + typical values:
500 — the boundary itself (tests the <= condition; should print "Pay Toll").
501 — just above the boundary (should print "Toll Free").
0 or 100 — well below threshold (typical "Pay Toll" case).
1 mark each.
(h) Define the term 'wide area network' (WAN). (2 marks)
A WAN is a computer network that spans a large geographical area — across cities, countries, or continents — connecting smaller networks (LANs/MANs) using leased telecommunication lines, satellites or the public Internet. The Internet itself is the largest example of a WAN. (1 mark for "large geographical area"; 1 mark for "connects multiple LANs / uses long-distance technologies".)
(i) Name the TWO basic parts of a hyperlink. (2 marks)
Display text / anchor text — the visible (often blue, underlined) text that the user clicks on.
URL / target / web address — the underlying address (e.g., https://example.com) that the browser navigates to when the link is clicked.
1 mark each.
(j) State the MOST important aspect that must be considered when assessing the impact of automation on job security. (1 mark)
Whether existing jobs are being eliminated or merely transformed (re-skilled). Automation can displace workers performing repetitive tasks; the most important question is whether the workforce can be re-trained or re-deployed into the new (often higher-skilled) roles that automation creates.
Company (employees can't get paid on time; reputation damaged)
(ii) An employee was caught emailing directors' salaries to a competing company.
Industrial espionage / data theft / breach of confidentiality
Individual (the directors whose salaries were leaked) — and also the company (loss of trust + competitive disadvantage)
1 mark misuse + 1 mark impact for each scenario = 4 marks.
(c)(i) Explain how encryption protects data when it is being transmitted. (2 marks)
Encryption converts plaintext data into ciphertext using a mathematical algorithm and an encryption key (1 mark). Anyone who intercepts the encrypted message during transmission sees only meaningless ciphertext — they cannot read it without the matching decryption key, so the data's confidentiality is preserved (1 mark).
(c)(ii) Identify the cyber threats that match the given counter methods. (2 marks)
Cyber Threat
Counter Method
Hackers / unauthorised network access
A network security device that monitors and filters incoming and outgoing network traffic… → Firewall
Malware (viruses, worms, trojans, ransomware)
A computer program used to prevent, detect and remove malware… → Antivirus software
1 mark each — name the threat that the counter method protects against.
(d)(i) State the data types of EACH variable: StaffID, Full-Time, Salary. (3 marks)
Variable
Data Type
StaffID
Integer / Numeric (the printed values 8912, 2359, …, are whole numbers)
Full-Time
Boolean / Logical (Y or N — two possible values)
Salary
Real / Currency / Floating-point (money values may carry decimals)
1 mark each.
(d)(ii) State the file access method used to load the salary data from the file. (1 mark)
Sequential access — the file is processed record-by-record from beginning to end, which is the standard method for batch payroll runs.
(d)(iii) Categorise each activity as input, processing or output. (3 marks)
Activity
Category
Calculate the salary.
Processing
Print salary slip.
Output
Enter the StaffID.
Input
1 mark each.
(d)(iv) State the fields that can be used as criteria to determine employees who are part-time. (2 marks)
Use Full-Time = "N" as the primary criterion. The Hours field can also be used (Hours < 40, since part-time staff have an Hours value while full-time rows are blank).
So the two fields are: Full-Time and Hours. (1 mark each.)
(d)(v) Why would StaffID be the MOST suitable field to determine the file organisation method used to read the file? (1 mark)
StaffID is unique and ordered (e.g., 8912 < 7011 etc., or sortable). The records can be loaded sequentially in StaffID order, making sequential file organisation efficient — and StaffID can also serve as the unique key for indexed-sequential access if needed.
Solutions generated by Kairu — Student Hub's AI system, trained by The Student Hub. AI can make mistakes — always cross-check tricky answers with your teacher and class notes.