Computer Applications and Digital Office Tools
What the exam tests
This domain tests word processing, spreadsheets, presentations, databases, email, file management and basic security. Questions often require a formula, a mail-merge step or a safe computing practice.
Core rules and concepts
- Word processing skills include styles, tables, track changes, mail merge and exporting to PDF.
- A spreadsheet stores data in cells. Relative references change when copied; absolute references such as $B$1 stay fixed.
- Common functions include SUM, AVERAGE, IF, COUNT and VLOOKUP. Charts should have a clear title, labelled axes and a suitable type.
- A database has tables, records, fields and a primary key. Queries retrieve data; reports present it.
- File management needs a logical folder structure, consistent names, backup and version control.
- Security basics include strong passwords, two-factor authentication, access control, phishing awareness, malware protection and encryption of sensitive files.
Worked example
A marksheet needs a grade from total marks in A2. Reasoning: write =IF(A2>=90,"A",IF(A2>=80,"B","C")). Nested IF checks from the highest threshold downward. If a pass mark in B1 must stay fixed when the formula is copied down, write $B$1. Test the formula on a low mark, a boundary mark and a high mark before filling it down.
Traps that cost marks
Using a relative reference when copying a fixed rate. Sorting one column and breaking row alignment. Saving over the only copy. Opening suspicious attachments. Running a mail merge without checking the data source.