Complete Open College Network Northern Ireland Vocationally-Related Qualification Digital Skills & IT specification revision resources. Tailored syllabus coverage with topic breakdowns, quizzes, and practice questions.
Specification Topics
- Bespoke Software
- OCN NI Level 2 Certificate in Essential Skills – Digital ICT - Core Content
- GIS Data Manipulation and Presentation
- IT User fundamentals
- Introduction to Using ICT Systems
- Search Engine Optimisation
- OCN NI Level 1 Certificate in Essential Skills – Digital ICT - Core Content
- Exploring Social Media
- Introduction to Geographical Information Systems
- Economics, Location and Geographical Information Systems
- OCN NI Entry Level 3 Certificate in Essential Skills – Digital ICT - Core Content
- Imaging Software
- Establishing an IT System
- Improving Productivity Using IT
- Imaging Software Tools
- IT Communication Fundamentals
- IT Software Fundamentals
- IT User Security
- Mobile Application Development
- IT User Fundamentals
- Optimise IT System Performance
- Multimedia Software
- Presentation Software
- Project Management Software
- Set Up an IT System
- Social Media
- Capturing and Editing Audio Sequences
- Capture and Edit Audio Sequences
- Geographical Information Systems Analysis to Inform Planning
- Using Mobile Technologies to Market Products and Services
- Spreadsheet software
- Specialist Software
- Spreadsheet Software
- Use Collaborative Technologies
- Use Digital Imaging and Printing Tools
- Using Digital Imaging and Printing Tools
- Using Mobile IT Devices
- Using Email
- Using the Internet
- Websites Software
- Using Multimedia Software
- Word Processing Software
- Using Social Media to Market and Promote Events, Products and Services
- Website Software
- Capture, Edit and Present Video Sequences
- Using email
- Using Social Media to Market Products and Services
- Geographical Information Systems Data Manipulation and Presentation
- Capturing, Editing and Presenting Video Sequences
- Using Geographical Information Systems to Inform the Decision Making Process
- Computerised Accounting Software
- Computer Animation Techniques
- Using Technology to Develop Online Interaction with Customers
- Database Software
- Computer Networks
- Word processing software
- Design Software
- Desktop Publishing
- Design Software
- Email Software Skills
- Desktop Publishing Software
- Enhance IT System Performance
Top Exam Board Tips
- Familiarise yourself thoroughly with the specific bespoke software you will be assessed on—practice all required functions before the assignment.
- Always follow the assignment brief precision, paying close attention to input requirements, naming conventions, and output formats specified.
- When organising information, explain or annotate your folder structure clearly to demonstrate your understanding of retrieval logic.
- Before submitting evidence, review your work for common errors: check data accuracy, test any queries, and ensure all outputs display as intended.
- Before starting the practical task, plan your data structure on paper to ensure it meets all organisational and retrieval requirements, and include this plan in your evidence.
- Take screenshots and annotate them to prove you have used advanced functions; assessors need clear evidence of exploiting software capabilities.
- Test your solution thoroughly with sample data and document any error handling, as this demonstrates professional practice and can earn additional marks.
- In coursework or practical assessments, clearly document the rationale behind your design choices, linking them directly to the end-user requirements.
- Provide annotated screenshots or step-by-step evidence of using software functions to process and present data; assessors need to see the process, not just the final output.
- Test your bespoke solution thoroughly with sample data and demonstrate error handling or validation to show robustness and an understanding of real-world application.
Common Mistakes to Avoid
- Entering data without checking field types or validation rules, leading to errors or rejected entries.
- Failing to save work incrementally or using unclear file names, making retrieval difficult.
- Attempting to combine information without first ensuring consistency in data formats (e.g., date formats, text case).
- Confusing the purpose of different software functions, such as using a filter when a query is needed.
- Presenting information without reviewing the output for accuracy or professional appearance.
- Learners often neglect to validate and clean imported data, resulting in inaccurate outputs and lost marks.
- A common error is creating overly complex or redundant data structures when simpler, built-in features would suffice, leading to inefficiency.
- Many students underutilise the software's advanced capabilities, relying on manual methods that could be automated, thus failing to meet the 'exploit the functions' criterion.
Key Terminology & Definitions
- Be able to input and combine information using bespoke applications., Be able to use appropriate structures to organise and retrieve information., Be able to use the functions of the software to process and present information.
- Input and combine information using bespoke software., Create and modify appropriate structures to organise and retrieve information efficiently., Exploit the functions of the software effectively to process and present information.
- Digital device operation
- File management and storage
- Word processing fundamentals
- Spreadsheet basics
- Online communication
- Internet safety and security
- Understand the structure of databases, Know how to connect to other available database sources, Know how to set up a virtual server, Know how to present the outcome of GIS queries in a graphical format
- IUFE:1 Interact with and use IT system to meet needs, IUFE:2 Organise, store and retrieve appropriately, IUFE:3 Understand the need for safety and security practices, IUFE:4 Maintain system and respond to common IT system problems
- Hardware recognition
- Basic system operation
- Safety and security awareness
- Software application use
- Data entry and output