β Scotland Administration & IT
Scotland Β· SQASyllabus
Administration & IT syllabus, dot point by dot point
Every dot point in the Scotland Administration & ITsyllabus, with a focused answer for each one. Click any dot point for a worked explainer, past exam questions, and links to related dot points. Written by Claude Opus 4.8, Anthropic's latest AI.
Administrative Theory and Practice
Module overview β- How do administrators choose the right way to communicate and research information?Appropriate methods of communication (oral, written, electronic) and how to choose between them, and appropriate methods of research, including evaluating sources for reliability and presenting findings.10 min answer β
- What does good customer care look like, and why does it matter to an organisation?The features of good customer care (including a customer care strategy and service standards), the benefits of good customer care, and the consequences of poor customer care for the organisation.9 min answer β
- What makes a team effective, and why do organisations rely on teamwork?The characteristics of effective teams and the benefits of effective teamwork to the individual and the organisation, together with the features and consequences of poor teamwork.9 min answer β
- How does digital technology change the way organisations work, for better and worse?The impact of digital technology on organisations and on working practices, including the benefits and drawbacks for the organisation and the employee, and the implications for security and ways of working.10 min answer β
- How does an administrator organise and support a meeting or event?The procedures for organising and supporting a range of meetings and events, including the tasks before, during and after, the meeting documents (notice, agenda, minutes), and the impact of poor organisation.10 min answer β
- What does an administrative assistant actually do, and what makes the role effective?The role and tasks (duties) of the administrative assistant, the qualities and skills an effective administrator needs, and how a well-run administrative function supports the wider organisation.10 min answer β
- How do administrators manage their time and tasks, and why does it matter?Strategies for effective time and task management (prioritising, planning, scheduling, to-do lists, electronic tools, delegation, setting targets), and the consequences of poor time and task management for the individual and the organisation.10 min answer β
- What laws govern the workplace, and how do organisations comply with them?Knowledge of workplace legislation (health and safety, data protection, equality, and computer misuse) and the strategies organisations use to ensure compliance, with the responsibilities this places on employer and employee.11 min answer β
Course Assessment
Module overview βIT Solutions for Administrators: Communication
Module overview β- How do administrators use email and e-diaries to communicate and organise their work?Using email effectively (attachments, distribution lists, priority, folders, signatures and rules) and using an electronic diary (e-diary) with appointment and task functions to schedule, share availability and avoid clashes.9 min answer β
- How do emerging technologies change the way organisations communicate and collaborate?Using emerging technologies for communication and collaboration (video conferencing, cloud and online collaboration tools, instant messaging, intranets and the internet, social media), with their benefits, drawbacks and security implications for the organisation.9 min answer β
IT Solutions for Administrators: Databases
Module overview β- How do you use forms and reports to enter and present database data, and output it to other applications?Creating and using forms for data entry, creating reports (including grouped reports with totals), printing database results in a range of formats, and exporting data to spreadsheet, word-processing and presentation applications.10 min answer β
- What is a relational database, and how are tables linked together?The structure of a relational database (tables, fields, records, data types, primary and foreign keys), and creating relationships between tables, with the advantages of a relational database over a flat-file one.11 min answer β
- How do you search a relational database with complex criteria and add calculations?Searching a relational database using advanced functions (queries with multiple criteria, AND/OR logic, comparison and wildcard operators, sorting and multi-level sorting) and using calculations in queries and reports (calculated fields and summary totals).10 min answer β
IT Solutions for Administrators: Documents
Module overview β- How does mail merge work, and how is data brought into a word-processed document?Using mail merge to produce personalised documents (the main document and the data source, merge fields, and filtering recipients), and importing and linking data from other applications (spreadsheets and databases) into a word-processed document.9 min answer β
- How do you research, build and deliver an effective presentation?Researching information and presenting it effectively, using editing, formatting and reviewing features (master slides, transitions, animations, multimedia and hyperlinks), the notes feature, and managing and printing a presentation in a range of formats (slides, handouts, notes pages).9 min answer β
- Which advanced word-processing features does Higher Administration and IT require?Creating and working with word-processed documents using advanced features (styles, sections, headers and footers, page and section breaks, columns, tables, templates, table of contents, track changes and comments) to produce well-structured business documents.10 min answer β
IT Solutions for Administrators: Spreadsheets
Module overview β- How do you manage multiple worksheets and link data between files in a spreadsheet?Managing worksheets and workbooks, consolidating data across sheets, creating dynamic links between software applications, and importing and exporting spreadsheet data from and to external sources.10 min answer β
- How do you turn spreadsheet data into clear charts and print it correctly?Creating and formatting charts from spreadsheet data (choosing an appropriate chart type and adding titles, labels and legends), and printing in a range of views and selections (formulae view, gridlines and headings, fit to page, selected ranges).9 min answer β
- Which spreadsheet functions and formulae does Higher Administration and IT require, and how are they used?Using spreadsheet functions, formulae and features at Higher level, including absolute and relative cell references, logical and lookup functions (IF, nested IF, COUNTIF, SUMIF, VLOOKUP), statistical functions, named ranges and conditional formatting.11 min answer β