Administration & IT study guides

A deep-dive SQA Higher Administration and IT guide to the Administrative Theory and Practice area. Covers the role and tasks of the administrative assistant, time and task management, effective teams, workplace legislation, customer care, organising meetings and events, the impact of digital technology, and communication and research methods, with worked examples.

A deep-dive SQA Higher Administration and IT guide to IT communication tools. Covers using email effectively, electronic diaries with appointment and task functions, and emerging technologies (video conferencing, cloud collaboration, instant messaging, intranets, social media) with their benefits, drawbacks and security implications.

A complete guide to how SQA Higher Administration and IT is assessed: the question paper (testing knowledge of both areas applied to administrative contexts) and the practical IT assignment (a set of linked tasks across the applications), how they combine into the A to D award, and how to prepare for each.

A deep-dive SQA Higher Administration and IT guide to relational databases. Covers the relational structure (tables, fields, records, primary and foreign keys, relationships), advanced searching (queries, AND/OR, operators, wildcards, sorting) and calculations, and forms, reports and exporting, with worked examples.

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.

A deep-dive SQA Higher Administration and IT guide to spreadsheets. Covers functions, formulae and features (cell references, IF, COUNTIF, SUMIF, VLOOKUP, statistical functions, conditional formatting), managing and linking workbooks (worksheets, consolidation, dynamic links, import/export), and charts and printing, with worked examples.