What document skills does SQA Higher Administration and IT require?

Higher requires you to produce well-structured business documents using advanced word-processing features (styles, sections, headers and footers, page and section breaks, columns, tables, templates, an automatic table of contents, track changes and comments), to use mail merge to produce personalised documents and import or link data from spreadsheets and databases, and to research and produce effective presentations using master slides, transitions, animations, multimedia, hyperlinks, the notes feature, and printing in a range of formats.

How does mail merge work?

Mail merge has two main parts: the main document and the data source. The main document (for example a standard letter) holds the fixed text plus merge fields, placeholders such as Name and Address where personalised data goes. The data source is a list of recipients, often a spreadsheet or database. When merged, the software produces one personalised copy per record, inserting each recipient's data into the merge fields. Recipients can be filtered so only the right people receive the document, which saves time and reduces errors.

What is the benefit of using styles and templates in word processing?

A style is a saved set of formatting (font, size, spacing) applied to text such as headings; using styles gives a consistent, professional look, lets formatting be changed everywhere at once, and drives an automatic table of contents. A template is a reusable document layout (for example a letterhead or report) that saves time, keeps a consistent house style and branding, and reduces errors, because the layout and standard content are already set up for each new document.

What is a master slide in a presentation?

A master slide (or template) sets the layout, fonts, colours and logo that apply to every slide at once. It gives a consistent, professional, branded look and saves time, because the formatting does not have to be set on each slide individually. Transitions control how slides change, animations reveal items on a slide one at a time, and both should be used sparingly so they aid rather than distract from the message.

What is the difference between handouts and notes pages when printing a presentation?

Handouts print several slides per page and are for the audience to follow and annotate. Notes pages print each slide together with its speaker notes and are for the presenter to use when delivering. A presentation can also be printed as full slides (one per page). Choosing the right format suits the purpose: handouts for the audience, notes pages for the presenter.

ScotlandAdministration & IT

SQA Higher Administration and IT Documents: a complete overview of advanced word processing, mail merge and importing, and presentations

A deep-dive SQA Higher Administration and IT guide to producing documents. Covers advanced word-processing features (styles, templates, sections, headers and footers, table of contents, track changes), mail merge and importing/linking data, and presentations (master slides, transitions, notes, printing), with worked examples.

Generated by Claude Opus 4.814 min readHigherUpdated 2026-06-16

Reviewed by: AI editorial process; not yet individually human-reviewed

Jump to a section

What producing documents actually demands at Higher
Advanced word processing
Mail merge and importing
Presentations
How producing documents is examined
Check your knowledge

What producing documents actually demands at Higher

Word processing and presentations are the IT applications administrators use to communicate. At Higher, the SQA expects more than basic typing: you produce well-structured, professional documents using advanced features, automate personalised mailings with mail merge, bring in data from other applications, and build and deliver effective presentations. You meet this in the assignment (producing the documents) and the question paper (explaining what a feature does and its benefit).

This guide walks through the whole area, then sets out how it is examined. Each topic has a matching dot-point page with practice questions; this overview ties them together.

Advanced word processing

The heart of advanced word processing is structure and consistency. Styles apply consistent heading and body formatting and drive an automatic table of contents; templates reuse a whole layout (letterhead, report) to save time and keep a house style. Sections and section breaks let different parts have different layouts, headers and footers repeat titles and page numbers, and columns and tables lay out newsletters and data. When several people work on a document, track changes records edits to accept or reject and comments add review notes without changing the text.

Mail merge and importing

A frequent administrative job is sending the same document, personalised, to many people. Mail merge does this with two parts: a main document (fixed text plus merge fields) and a data source (the recipient list, often a spreadsheet or database). Merging produces one personalised copy per record, and recipients can be filtered so only the right people receive it, saving time and reducing errors. Separately, data from a spreadsheet or database can be imported (static) or linked (auto-updating) into a document, reusing data without re-keying.

Presentations

Presentations share information with an audience. Effective ones are researched and clearly presented: one idea per slide, short bullets, readable fonts, relevant visuals. A master slide sets the look for all slides; transitions, animations, multimedia and hyperlinks add flow and interest (used sparingly). The notes feature holds speaker notes, and the presentation can be printed as slides, handouts (for the audience) or notes pages (for the presenter).

How producing documents is examined

A typical SQA profile:

Describe a feature and its benefit. Styles, templates, track changes, a master slide.
Explain a process. How mail merge works (its two parts); the difference between linking and importing.
Distinguish. Track changes vs comments; handouts vs notes pages.
Apply it. The assignment requires producing the document, merge and presentation correctly.

SQA Higher Administration and IT documents requires producing well-structured business documents and presentations. Word processing: advanced features including styles (consistent formatting, driving an automatic table of contents), templates (reusable layouts, house style), sections and breaks, headers and footers, columns, tables, and review tools (track changes records edits to accept or reject; comments add notes without changing text). Mail merge: a main document (fixed text plus merge fields) and a data source (recipient list, often a spreadsheet or database) merged to produce one personalised copy per record, with recipients filtered, saving time and reducing errors; data can also be imported (static) or linked (auto-updating) from other applications. Presentations: researched, clearly designed slides, a master slide for a consistent branded look, transitions, animations, multimedia and hyperlinks used sparingly, the notes feature for speaker notes, and printing as slides, handouts (audience) or notes pages (presenter). It is examined by describing features and processes and producing the documents in the assignment.

Check your knowledge

A mix of recall and explanation questions covering documents. Attempt them, then check against the solutions.

State one benefit of using styles in a document. (1 mark)
What is a template, and why is it useful? (2 marks)
Explain the difference between track changes and comments. (2 marks)
Name the two main parts of a mail merge. (2 marks)
State one benefit of using mail merge. (1 mark)
What is the difference between handouts and notes pages? (2 marks)

Solutions

Q1: Any one: a consistent, professional look; formatting can be changed everywhere at once; an automatic table of contents can be generated from the heading styles.
Q2: A template is a reusable document layout (for example a letterhead or report). It saves time, keeps a consistent house style and branding, and reduces errors, because the layout and standard content are already set up.
Q3: Track changes records actual edits to the text (insertions, deletions, formatting) so they can be accepted or rejected; comments add notes to the document without changing the text, for questions or suggestions during review.
Q4: The main document (fixed text plus merge fields) and the data source (the list of recipients, for example a spreadsheet or database).
Q5: Any one: it produces many personalised documents quickly (saves time); it reduces errors (data from one source, not re-typed); recipients can be filtered so only the right people receive it.
Q6: Handouts print several slides per page for the audience to follow and annotate; notes pages print each slide with its speaker notes for the presenter.

Sources & how we know this

Higher Administration and IT Course Specification — SQA (2024)