← Administration & IT syllabus

ScotlandAdministration & IT

IT Solutions for Administrators

4 dot points across 4 inquiry questions. Click any dot point for a focused answer with worked past exam questions where available.

How does an administrator use a database to store, search, sort and report on information?

The database features used to store and manage information (fields and records, data types, sorting on one or more fields, searches and queries using criteria, and reports), and choosing the right feature for a given task.
A focused answer to the SQA National 5 Administration and IT content on databases, covering fields and records, data types, sorting on one or more fields, searches and queries using criteria, and reports, and how to choose the right feature to manage information.
10 min answer →

How does an administrator organise and manage electronic files, and how does an electronic diary help schedule work?

Good electronic file-management practice (clear folder structures, sensible file naming, version control, regular backups) and the use of an electronic diary (e-diary) to schedule appointments, set reminders and manage time.
A focused answer to the SQA National 5 Administration and IT content on electronic file management and electronic diaries, covering folder structures, file naming, version control and backups, and how an e-diary is used to schedule appointments and manage time.
9 min answer →

How does an administrator use a spreadsheet's formulae, functions and charts to process and present numerical information?

The spreadsheet features used to process and present numerical information (formulae and functions such as SUM, AVERAGE, MAX, MIN and IF, formatting, sorting and filtering, charts and graphs), and choosing the right feature for a given task.
A focused answer to the SQA National 5 Administration and IT content on spreadsheets, covering formulae and functions (SUM, AVERAGE, MAX, MIN, IF), formatting, sorting and filtering, and charts, and how to choose the right feature to process and present numerical information.
10 min answer →

Which word-processing and desktop-publishing features does an administrator use to produce accurate, professional documents?

The word-processing and desktop-publishing features used to create and edit business documents (house style, templates, mail merge, tables, headers and footers, page numbering, find and replace, spellcheck), and choosing the right feature for a given task.
A focused answer to the SQA National 5 Administration and IT content on word processing and desktop publishing, covering features such as house style, templates, mail merge, tables, headers and footers, and how to choose the right feature to produce accurate, professional business documents.
10 min answer →