SQA Coursework 2022 Assignment: Wednesday 23 March 2022
SQA 2022 Exam: Friday 6 May 2022 - 1.30 pm - 3 pm
Comments welcome on materials - do you spot an error?
Progress & Tracking Material
- Administrative Theory and Practice - Self Evaluation
- Information Technology for Administrators - Self Evaluation
- Communications - Self Evaluation
- Practical Paper Checklist of Marks
- Top Tips for the Assignment
Word Processing
Zip Files contain the documents required to complete eg Spreadsheet or Database extracts
Email all completed tasks (with a suitable professional message) as PDFs to your Line Manager depending who that is as noted in the tasks.
- 2006 - Specimen - 1-Stop Office Supplies - SIMPLE DOCUMENT
- 2006 - SQA Prelim - Just Sharing - SIMPLE DOCUMENT
- 2006 - Cucasa - MEMORANDUM (see house style booklet)
- 2007 - Dunedin - REPORT
- 2008 - Tayforth Caravans Ltd - LETTER
- 2009 - Conference Centres (Scotland) Ltd - REPORT
- 2010 - CSP Promotions - REPORT
- 2011 - Caledonia High School - MINUTES (you can complete this after we have discussed Meetings)
- 2012 - Scottish Stallholders' Association - REPORT
- 2013 - The Great Outdoors - LETTER
- 2014 - Prestige Events - REPORT
- 2015 - Dundee Arts Council - REPORT
Spreadsheets
- 2006 - Specimen - 1-Stop Office Supplies
- 2006 - SQA Prelim - Just Sharing
- 2006 - Cucasa
- 2007 - Dunedin
- 2008 - Tayforth Caravans Ltd
- 2009 - Conference Centres (Scotland) Ltd
- 2010 - CSP Promotions
- 2011 - Caledonia High School
- 2012 - Scottish Stallholders' Association
- 2013 - The Great Outdoors
- 2014 - Prestige Events
- 2015 - Dundee Arts Council
Databases
- 2006 - Specimen - 1-Stop Office Supplies
- 2006 - SQA Prelim - Just Sharing
- 2006 - Cucasa
- 2007 - Dunedin
- 2008 - Tayforth Caravans Ltd
- 2009 - Conference Centres (Scotland) Ltd
- 2010 - CSP Promotions
- 2011 - Caledonia High School
- 2012 - Scottish Stallholders' Association
- 2013 - The Great Outdoors
- 2014 - Prestige Events
- 2015 - Dundee Arts Council
Please let me know if any of these files are 'missing information' by email had@ka-net.org.uk
Administrative Theory and Practice
- PowerPoint - Time and Task Management - Updated September 2019
- PowerPoint - Teams - Updated June 2020
- PowerPoint and GDPR Fact Sheet - Legislation - Updated November 2020
- PowerPoint - Work Practices and the Impact of IT in the Workplace - Updated January 2021
- PowerPoint - Customer Service Methods - Updated October 2020
- PowerPoint - Customer Service Monitoring - Updated October 2020
- PowerPoint - Meetings - Updated January 2021
- PowerPoint - Communication in Administration & IT (Methods | Barriers | File Management | Security) - Updated 2 March 2021
- PowerPoint - The Theory of the Software Packages - Updated 2 March 2021
- Leadership and Command Tasks (external website PDF)
IT Solutions for Administrators
- YouTube Channel with Demonstrations - knox.is/adminvideo - created by another Business Education Teacher - we do some things differently eg not using spreadsheet function wizards, and manually entering grouping totals; and sorting in a database report.
- Add in links to videos on Knox Academy YouTube Channel (knoxhaddington) - see SBEA for direct links at the moment.
- Conditional Formatting (Advanced) - Sophia
- Using Microsoft Office Packages - Microsoft
Command Words
- State - listing or bullet points would be acceptable here.
- Suggest - more than just naming or stating. Put forward a recommendation or advise on a possible course of action.
- Outline - Identify key features and provide a brief description where appropriate.
- Describe - Give a description and use examples where possible as part of the description.
- Explain - Give a definition and then an example as to how something may or may not be affected.
- Discuss - Give advantages and disadvantages where possible. Use examples to expand your answer, and if possible give a conclusion to your answer.
- Compare - You must be able to compare the similarities or differences between the items, again giving a conclusion if necessary. Key words that could be used as part of your answer are "where as", "however", "on the other hand", "both have" etc.
- Justify - You must be able to give reasons why a certain course of action is being taken.
- Implications - You should be able to state what the likely outcome of a particular action will be in the longer term, either to an individual or the organisation.
- Consequences - You must be able to identify the initial impact of the action being followed.
Sample Past Paper Solutions
- SQA 2020 Question Paper - no examination (COVID-19)
- SQA 2019 Question Paper (CMD) - not yet available
- SQA 2018 Question Paper (CMD) - not yet available
- SQA 2017 Question Paper (CMD) - not yet available
- SQA 2016 Question Paper (CMD)
- SQA 2015 Question Paper (CMD)
- SQA Exemplar Question Paper (CMD)
Theory Past Paper Questions (and solutions)
Higher Administration (2013-2016) Selected PPQs
February Break
- A (former) plan of action with some past paper questions
SQA Website
-
EXAMPLE ANSWERS - It is highly recommended to look at the Understanding Standards website for example candidate answers, with commentary on marks given and mistakes made for both theory and practical questions.
- Selected Past Paper (Theory) Questions
Suggested Textbooks:
Website Links:
- Share any news related to Administration to adminnews@ka-net.org.uk
- Bizare objects found in 'cool' offices (BBC News - 17 December 2013)
- Brave New Work: making the 9-5 Somewhere You Want To Be (BBC News - 11 July 2013)
- The pleasures and perils of the open-plan office (BBC News - 28 March 2012)
- The Telework Association
- Equal Oppportunities Training Manual (from The Centre for Economic and Social Inclusion)
- Mental Health - Wellbeing Podcasts
Leckie and Leckie Revision Book
Higher Administration Useful Links and Downloads (for Leckie and Leckie) - this is the 'Green' L&L Book for NQ HAD.
Bright Red Revision Book
How To Pass (Hodder Gibson) Revision Book
Other Useful Sites