Course Content

Assessment

There are 3 main areas of study in Administration & IT.

• Communication in Administration
• Administrative Practices
• IT Solutions for Administrators
  

N4:
Pupils can achieve a National 4 Qualification by completing and passing three unit assessments and an Added Value Unit.

N5:
Pupils will achieve a National 5 Qualification by completing and passing the final assignment and exam.

---

Useful Websites

GCFLearnFree - Microsoft Office
This website contains handy tutorials and "how-to" guides for Microsoft Office applications.

Teach-ICT
The department has a subscription to Teach ICT.  Pupils can get login details from their class teacher.

SQA Website
The SQA website is a useful resource to inform pupils about the course itself. There are also past papers available for free revision.

Bright Red Digital Zone
Pupils can sign up for free and access a wide range of revision materials.

---

Home Learning

IT Solutions for Administrators

• How to guides and practice tasks for all software can be found on Bright Red Digital Zone

Spreadsheets

• Uses and features of Spreadsheets
• Formulae and functions
• Charting​

Database

• Database Terminology
• Creating a Database (practical tasks)
• Queries and Reports (how-to guides and practical tasks)
• Mail Merge (theory and tasks)

Word Processing

• Layout of a letter

You can also access your Microsoft Teams group for more practice tasks and files - please make sure you speak to your class teacher if you are not in the group!​

Administrative Practices

• You can find notes and interactive quizzes for all topics on Bright Red Digital Zone​. You can register for free!
• Command Words

Communication in Admin
Desktop Publisher

• DTP Intro
• DTP Extension Tasks

Powerpoint

• Introductory Powerpoint Task

E-Mail

• Good Email Etiquette
• E-Mail Past Paper Tasks

Internet

• Internet Research Tasks (AOK)

E-Diary

• ​E-Diary Past Paper Tasks (AOK)

Please note: For E-mail & E-diary tasks pupils will need to use their GLOW accounts. If there are any issues logging into GLOW please use the following Form.

---

Textbooks