SQA National 5 Administration and IT: IT Solutions for Administrators unit guide

What the IT Solutions unit demands

IT Solutions for Administrators is the applied core of the course. Most of it is practised at a computer, and it underpins the coursework assignment, but the question paper also tests it in writing: you must know what each software feature does and which feature suits a given task. The SQA rewards matching a tool to a problem, so this guide walks through the four areas and then sets out how they are examined. Each topic has a matching dot-point page with worked questions.

Word processing and desktop publishing

The unit covers producing professional documents with word processing (letters, reports, memos) and desktop publishing (newsletters, posters). Examined features include a template and house style for consistency, mail merge for bulk personalised letters, tables, headers and footers with page numbering, find and replace, and spellcheck. The exam reward is choosing the right feature: mail merge for many personalised copies, a template for a consistent look.

Spreadsheets

Spreadsheets process and present numbers. The functions to know are SUM, AVERAGE, MAX, MIN and IF, alongside formatting, sorting, filtering and charts. The key benefits over working by hand are speed, accuracy and automatic recalculation. Questions give a numerical scenario, such as sales figures or a budget, and ask which features would process and present the data.

Databases

Databases store, search, sort and report on information. The vocabulary is examined directly: a field is one piece of information, a record is all the fields for one item, and a query finds records that match criteria. Sorting orders records and a report presents selected records neatly. The big advantages over paper are fast searching, instant sorting and reuse of data in mail merge.

File management and e-diaries

Finally, the unit covers electronic file management (a clear folder structure, sensible naming, version control, backups) and the electronic diary (scheduling, reminders, sharing, recurring entries, colour-coding). Both keep an administrator's information and working day organised.

How the unit is examined

A typical SQA profile for IT Solutions:

• Describe and choose features. Naming software features and matching them to a task in the scenario earns most of the marks.
• Explain the benefits. Spreadsheet and database questions reward explaining why software beats working by hand: speed, accuracy and automatic updating.
• Use the vocabulary precisely. Field versus record, formula versus function, template versus house style: examiners test these directly.

Check your knowledge

A mix of recall and reasoning questions covering IT Solutions. Attempt them, then check against the solutions.

1. State what mail merge is used for. (1 mark)
2. Name two spreadsheet functions. (1 mark)
3. Distinguish between a field and a record. (2 marks)
4. State two features of good electronic file management. (2 marks)
5. Give two ways an e-diary helps manage time. (2 marks)