Complete Open College Network Yorkshire and Humber Region trading as Certa Vocationally-Related Qualification Digital Skills & IT specification revision resources. Tailored syllabus coverage with topic breakdowns, quizzes, and practice questions.
Specification Topics
- Word processing software
- Spreadsheet Software
- IT Security for Users
- IT Communication Fundamentals
- Using mobile IT devices
- Audio Software
- Digital Lifestyle
- Optimise IT System Performance
- Desktop Publishing Software
- Using the Internet
- Computerised Accounting Software
- Multimedia Software
- Spreadsheet software
- Using Collaborative Technologies
- Presentation software
- Using Mobile IT Devices
- Database Software
- Audio and video software
- IT User Fundamentals
- Bespoke Software
- Using Email
- Imaging Software
- Project Management Software
- Database software
- Using email
- Personal information management software
- Specialist Software
- Presentation Software
- Improving Productivity Using IT
- Personal Information Management Software
- Data Management Software
- Video Software
- Word Processing Software
- Design and imaging software
- The Internet and World Wide Web
- Specialist/bespoke software
- Set Up an IT System
- IT Software Fundamentals
- Design Software
- Website Software
- Drawing and Planning Software
- Productivity Programmes
- Data management software
- IT User fundamentals
- Desktop publishing software
- Computer Basics
- Computer Security and Privacy
Top Exam Board Tips
- Carefully read the assignment brief and create a checklist of all required features to ensure nothing is missed.
- Use the software's built-in spelling and grammar checker, but also manually proofread your document to catch context-specific errors.
- Even if not explicitly asked, demonstrate a variety of formatting and structuring tools (e.g., page borders, columns, headers) to show wider competence.
- Save your work regularly in multiple locations (e.g., local drive and cloud storage) and keep dated backup copies as evidence of progress.
- Always double-check formula ranges and cell references before final submission.
- Ensure that all data is clearly labelled and organised logically.
- Match chart type to the data: e.g., pie charts for parts of a whole, bar charts for comparisons.
- Practice using print preview to ensure outputs are properly aligned on the page.
- Always link your chosen security procedures back to specific risks identified in the scenario or workplace.
- Use structured approaches like risk assessment matrices to demonstrate methodical thinking.
Common Mistakes to Avoid
- Repeatedly pressing the spacebar instead of using tab stops, indentation, or alignment tools to position text.
- Overusing bold, italics, and multiple font styles, resulting in an unprofessional and inconsistent appearance.
- Forgetting to save the document with an appropriate file name and in the required file format, causing potential loss of work or submission errors.
- Neglecting to proofread for spelling, grammar, and formatting inconsistencies before final submission.
- Confusing relative and absolute cell references when copying formulas.
- Selecting an inappropriate chart type that misrepresents data.
- Over-formatting leading to cluttered and unprofessional presentation.
- Neglecting to check formula accuracy or data ranges.
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
- Data entry and editing
- Formulas and basic functions
- Data organisation and layout
- Chart creation and formatting
- Printing and presentation
- Risk assessment and monitoring
- Access control and authentication
- Data protection and encryption
- Malware prevention and detection
- Physical and environmental security
- Security policy development
- Information source selection
- Effective search techniques
- Evaluating internet credibility