Complete Qualifications Scotland Occupational Qualification Digital Skills & IT specification revision resources. Tailored syllabus coverage with topic breakdowns, quizzes, and practice questions.
Specification Topics
- Word processing software
- Multimedia Software
- Spreadsheet software
- Using the Internet
- Bespoke Software
- Computerised Accounting Software
- Data Management Software
- Spreadsheet Software
- Using Mobile IT Devices
- Presentation software
- Database Software
- Internet Safety for IT users
- Using email
- Using Email
- Drawing and Planning Software
- Imaging Software
- Using a computer keyboard
- Audio Software
- Project Management Software
- Design and imaging software
- The Internet and World Wide Web
- IT User Fundamentals
- Word Processing Software
- Using Collaborative Technologies
- Video Software
- Design Software
- IT Software Fundamentals
- Specialist Software
- Website Software
- IT User fundamentals
- Improving Productivity Using IT
- Presentation Software
- Desktop publishing software
- Set Up an IT System
- IT Security for Users
- IT Communication Fundamentals
- Personal Information Management Software
- Desktop Publishing Software
- Using mobile IT devices
- Digital Lifestyle
- Optimise IT System Performance
Top Exam Board Tips
- Read assignment briefs carefully to understand exact requirements for formatting, structure, and content—assessors look for adherence to instructions.
- Use print preview or page layout view frequently to check overall document appearance before finalising.
- Save versions as you progress (e.g., v1, v2) to avoid losing work and to demonstrate incremental improvements if required.
- When editing, display non-printing characters (¶) to spot and remove accidental extra spaces or line breaks.
- For structure, learn to differentiate between visual formatting (e.g., manually making text bold and larger) and proper heading styles—styles allow automatic table of contents and consistent look.
- Always start by clearly defining the user requirements and creating a concise plan or storyboard before touching any software; this shows thoughtful design and can be used as evidence.
- Keep a log or capture screenshots of your process, including sourcing content, applying edits, and testing, as this can serve as supplementary assessment evidence.
- When presenting your multimedia outcome, be prepared to explain the choices you made in content selection, editing, and formatting, linking each decision back to the needs you identified.
- Before finalising, check that all formula ranges include the intended cells and that no data has been omitted from calculations.
- Use the 'Wrap Text' and 'Merge & Center' features sparingly but effectively to improve layout without causing confusion during data manipulation.
Common Mistakes to Avoid
- Adding extra spaces or line breaks instead of using paragraph spacing or indentation features.
- Inconsistent formatting, such as mixing fonts or randomly changing alignment, especially when copying text from other sources.
- Forgetting to save work regularly, leading to loss of data, or saving in incorrect locations.
- Using underline for emphasis where bold or italic would be more appropriate, or using all capital letters for headings rather than increasing font size/bold.
- Ignoring spelling and grammar checkers, or accepting all suggestions without reviewing the document context.
- Assuming all online content is free to use, leading to potential copyright breaches without proper attribution or licensing checks.
- Failing to plan adequately before starting, resulting in disjointed multimedia products that do not meet the specified needs or have logical flow.
- Overusing transitions and animations, which distracts from the core message and demonstrates poor design judgement.
Key Terminology & Definitions
- WPE:1 Input text and edit word processing documents, WPE:2 Structure information within word processing documents, WPE:3 Use word processing software tools to format and present documents
- Plan the content and organisation of multimedia products to meet needs, Obtain, input and combine content to build multimedia outcomes, Use multimedia software tools to edit and format multimedia content to meet requirements, Play and present multimedia outcomes
- SSE:1 Enter and edit numerical and other information using spreadsheets, SSE:2 Use appropriate formulas and tools to summarise and display spreadsheet information, SSE:3 Use appropriate tools and techniques to present spreadsheet information effectively
- INTE:1 Connect to the Internet, INTE:2 Use browser software to navigate webpages, INTE:3 Use browser tools to search for information from the Internet and the world-wide web or an intranet, INTE:4 Use browser software to communicate information online, INTE:5 Follow and understand the need for safety and security practices when working online
- Input and combine information using bespoke applications, Use appropriate structures to organise and retrieve information efficiently, Use the functions of the software effectively to process and present information
- Access, enter and edit accounting information, Use tools and techniques to process business transactions, Produce accounting documents and summary reports to meet requirements
- Enter, edit and maintain data records in a data management system, Retrieve and display data records to meet requirements
- Use a spreadsheet to enter, edit and organise numerical and other data, Select and use appropriate formulas and data analysis tools to meet requirements, Select and use tools and techniques to present and format spreadsheet information
- Device Setup and Customisation
- Application Use and File Management
- Data Transfer and Synchronisation
- Performance Maintenance and Storage Management
- PSE:1 Input and combine text and other information within presentation slides, PSE:2 Use presentation software tools to structure, edit and format slides, PSE:3 Prepare slides for presentation
- Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports
- Understand the risks that can exist when using the Internet., Know how to safeguard self and others when working online., Take precautions to maintain data security., Follow legal constraints, guidelines and procedures which apply when working online.