Nat 5 Administration and IT Revision Checklist & Tracker

Know exactly what is in National 5 Administration and IT, see your gaps at a glance, and close them one by one before the prelim, the assignment and the final exam.

This printable checklist turns the whole course into 58 clear “I can…” statements, covering both the administration theory and the practical IT skills, based on the current National 5 Administration and IT course specification. Colour a traffic light for each one, tick it off every time you revise, and watch the reds turn green.

READY FOR 2026-27
The National 5 Administration and IT course assessment is the same for session 2026-27: a 50-mark question paper done on a computer in 2 hours (spreadsheets, databases and theory) and a 70-mark assignment done in up to two sittings over 3 hours. This checklist follows that structure.

WHAT’S INSIDE (17 A4 pages)

• Cover with name, school, target grade (A / B / C / D) and exam date
• How to use, plus the course at a glance: the question paper (50 marks, 2 hours), the assignment (70 marks, 3 hours), where the 120 marks come from, and the command words to know
• 5 course checklist pages covering all 58 statements across administration theory, spreadsheets, databases, word processing and DTP, presentations and electronic communication. Every statement has Red / Amber / Green circles, Revised x1 / x2 / x3 boxes and a Practised? tick box
• Software skills for the question paper: every spreadsheet and database feature to tick off, formulae to practise (SUM, AVERAGE, IF, absolute references), keyboard shortcuts, and where marks are lost
• Software skills for the assignment: word processing, DTP, presentation, e-mail, e-diary and internet features to practise, plus shortcuts and common mistakes
• Theory answers and layouts: outline, describe and explain with examples, a labelled business letter layout, the e-mail layout and the layout rules that save marks
• Key terms: 28 must-know definitions, from house style and UK GDPR to absolute references and mail merge
• Past paper tracker: spreadsheet, database and theory marks, total, percentage and focus areas for 10 papers, plus a progress graph
• My fix-it list with Fixed boxes, and My check-ins: count your greens, ambers and reds three times over the year
• Assignment: the kinds of task set in recent years to practise, what you can and cannot do, a timing plan, a marks checklist showing where all 70 marks come from, and a hand-in checklist
• Exam-week checklist: pack your kit, the week before, and on the day
• Notes page

PLEASE NOTE

• A4 portrait PDF. Prints in colour or greyscale on standard A4 paper.
• An independent revision resource, not an official exam board product. Content is based on the current National 5 Administration and IT course specification.
• No software or past papers are included.

Good luck with your exams!