Establishing an IT System
This element equips learners with the practical skills to assemble, configure, and troubleshoot a personal computer system from scratch. It covers hardware setup, network connectivity, software installation, and functional testing, ensuring the system meets specific user requirements. Mastery of these tasks is essential for entry-level IT support roles and underpins safe, efficient technology use in any workplace.
Assessment criteria
Quick Revision Summary (Key Takeaway)
The OCN NI Level 2 Award in Information Technology Applications covers practical digital skills including word processing, spreadsheets, databases, presentations, and safe internet use. This qualification focuses on applying IT tools to real-world tasks, preparing students for further study or employment in digital environments.
Topic Overview
The OCN NI Level 2 Award in Information Technology Applications is a vocational qualification that equips students with practical IT skills essential for the modern workplace. It covers a range of applications, including word processing, spreadsheets, databases, and presentation software, as well as the principles of safe and responsible internet use. This qualification is designed to be hands-on, with assessments focusing on the application of skills rather than just theoretical knowledge.
In today's digital age, proficiency in IT applications is not just an advantage but a necessity. This course provides a solid foundation for further study in IT or for entering the workforce, as many jobs require at least basic competence in office software and online communication. The skills learned are transferable across industries, making students more versatile and employable.
The qualification is structured to build confidence gradually, starting with fundamental concepts and progressing to more complex tasks. By the end of the course, students should be able to create professional documents, analyse data using spreadsheets, manage information in databases, and deliver effective presentations, all while adhering to e-safety guidelines.
Key Concepts
Core ideas you must understand for this topic
- →Understanding the difference between hardware and software.
- →Using word processing software to format documents, insert images, and use mail merge.
- →Creating and formatting spreadsheets, using formulas and functions (SUM, AVERAGE, IF), and generating charts.
- →Designing and querying databases, including sorting and filtering records.
- →Producing professional presentations with animations, transitions, and multimedia elements.
- →Applying e-safety principles, including password security, phishing awareness, and responsible social media use.
Learning Objectives
What you need to know and understand
- Be able to set up a personal computer to own requirements., Be able to select and connect an IT system to a communication service to own requirements., Be able to install and configure software for use., Know how to check that the IT system and communication service are functioning.
- Be able to set up a personal computer to own requirements., Be able to select and connect an IT system to a communication service to own requirements., Be able to install and configure software for use., Know how to check that the IT system and communication service are functioning.
Assessment Criteria
Key criteria assessors look for in your portfolio
- Award credit for selecting and connecting all necessary peripherals (e.g., monitor, keyboard, mouse) accurately and demonstrating correct power-on sequence.
- Award credit for configuring an internet connection—whether via Ethernet or Wi-Fi—including entering security credentials and verifying successful data transfer.
- Award credit for installing operating system updates, device drivers, and at least one application, with evidence of appropriate license acceptance and customisation.
- Award credit for performing a systematic functionality check, such as running built-in diagnostics, testing peripheral responsiveness, and confirming network access, while logging any issues identified.
- Award credit for demonstrating the physical connection of all internal and external components (e.g., power, monitor, keyboard, mouse) and personalising settings like language, region, and accessibility options.
- Credit should be given when the learner correctly identifies the required communication service (e.g., Ethernet, Wi-Fi) and successfully connects, including entering security keys or configuring IP/DNS settings where necessary.
- Assessors must look for evidence of installing at least one software application from a legitimate source, following the installation wizard, and customising basic preferences (e.g., default save location, auto-update settings).
- Evidence of systematic checks should be rewarded: for example, booting the system, launching installed software, sending a test print, browsing a website, and verifying internet connectivity via command-line tools or network settings.
Assessment Guidance
Guidance for achieving higher grades
- 💡Always follow a logical workflow: hardware assembly, then network setup, then software installation, and finally testing—document each step.
- 💡Before starting, create a checklist of user requirements and tick off each as you complete it to ensure nothing is overlooked.
- 💡When configuring software, take screenshots or notes of settings changed; this demonstrates attention to detail and aids troubleshooting.
- 💡If something doesn’t work during testing, systematically isolate the issue—e.g., check cables, device manager, network settings—showing methodical problem-solving.
- 💡During assessment, narrate your actions while setting up the PC—this demonstrates understanding and allows assessors to follow your thought process for personalisation choices.
- 💡When configuring connectivity, have a backup plan: if wireless fails, show you can switch to a wired connection and troubleshoot common issues like incorrect proxy settings.
- 💡For software installation, always verify the source and license terms before proceeding, and document each step to prove you followed organisational procedures.
- 💡Create a structured testing checklist aligned with the unit criteria and use it methodically; present this as evidence of your thorough verification of system and communication service functionality.
- 💡Always read the question carefully and identify the command word (e.g., 'describe', 'explain', 'evaluate') to know how much detail is needed.
- 💡In practical tasks, save your work regularly and check that you have followed all instructions, such as naming files correctly.
- 💡Use the correct technical terminology in your answers, as this shows depth of understanding and gains marks.
Common Mistakes
Common errors to avoid in your coursework
- Failing to check hardware compatibility before installation, leading to driver conflicts or non-functional components.
- Ignoring operating system and application update prompts, leaving the system vulnerable and missing performance improvements.
- Connecting to a network without verifying that security protocols (e.g., WPA2) are enabled, risking data breaches.
- Skipping the final system check, resulting in undetected faults like a misconfigured display or non-working audio.
- Learners often power on the system before connecting all essential peripherals, causing hardware recognition failures or driver issues.
- A frequent error is selecting an incorrect Wi-Fi network or entering an invalid password, without verifying network availability or checking for MAC filtering.
- Installing software from unverified third-party websites or skipping critical update prompts exposes the system to security vulnerabilities and non-compliance.
- Many learners assume the system is fully functional after a single successful action (e.g., opening one program) and fail to conduct a comprehensive test of all required features.
- Misconception: Spreadsheets are just for calculations. Correction: They also manage data, create charts, and can be used for sorting and filtering.
- Misconception: Databases are the same as spreadsheets. Correction: Databases are designed for storing and retrieving large amounts of structured data, with relationships between tables, whereas spreadsheets are more for calculation and analysis.
- Misconception: Using a computer safely only means having antivirus software. Correction: E-safety also involves strong passwords, not sharing personal information, and being aware of phishing scams.
Revision Plan
How to revise this topic in 1–2 weeks
- 1Week 1: Focus on word processing and presentation skills. Practise formatting documents, inserting tables, and creating slides with animations.
- 2Week 2: Move to spreadsheets. Learn formulas, functions, and chart creation. Practise with sample data.
- 3Week 3: Study databases. Understand tables, queries, and reports. Practise sorting and filtering.
- 4Week 4: Review e-safety and internet use. Revise all topics and attempt past papers or practice assessments.
- 5Final days: Do timed practice questions, focusing on command words and mark schemes.
Exam Question Types
How this topic typically appears in the exam
- 📋Multiple-choice questions testing definitions and basic concepts (e.g., hardware vs software).
- 📋Short-answer questions requiring explanations of functions or features (e.g., 'What is the purpose of mail merge?').
- 📋Practical tasks where you must demonstrate a skill, such as creating a spreadsheet with formulas or a presentation with animations.
- 📋Extended writing questions asking you to evaluate the use of IT in a given scenario (e.g., 'Discuss the advantages and disadvantages of using cloud storage for a business.')
Command Word Expectations (OPEN COLLEGE NETWORK NORTHERN IRELAND)
What examiners look for when using specific command words in this specification
Give a detailed account of the features or characteristics of something. For example, 'Describe the features of a word processor.' You should list and explain key features, not just name them.
Give reasons or causes, showing how and why something happens. For example, 'Explain why it is important to use strong passwords.' You need to give reasons and justifications.
Weigh up the pros and cons, and come to a judgement. For example, 'Evaluate the use of cloud storage for a small business.' You must consider both advantages and disadvantages and give a reasoned conclusion.
How Students Lose Marks (Examiner Pitfalls)
Common mark loss traps and how to write 100% full-mark answers
Step-by-Step Worked Solutions
Detailed solution breakdown for typical exam problems
Question: A student creates a spreadsheet to track weekly expenses. In cell B2 they have the amount spent on food (£25.50), in C2 the amount on travel (£12.00), and in D2 the amount on entertainment (£8.75). Write a formula to calculate the total spent in cell E2. Then, if the student has a budget of £50, write a formula to calculate how much is left over in cell F2.
- 1.Step 1: Identify the cells containing the values to sum: B2, C2, D2.
- 2.Step 2: Use the SUM function to add them: =SUM(B2:D2).
- 3.Step 3: For the remaining budget, subtract the total from the budget: =50 - E2 (or =50 - SUM(B2:D2)).
- 4.Step 4: State the final answers clearly.
Question: Explain the difference between primary and secondary storage, giving one example of each. (4 marks)
- 1.Step 1: Define primary storage as memory directly accessible by the CPU, used for temporary data during processing.
- 2.Step 2: Give an example: RAM.
- 3.Step 3: Define secondary storage as non-volatile storage used for long-term data retention, not directly accessed by the CPU.
- 4.Step 4: Give an example: hard disk drive (HDD) or SSD.
Active Recall Memory Test
Test your memory before revealing the key facts
Frequently Asked Questions
Common questions students ask about this topic
Pass / Merit / Distinction Evidence Checklist
How your portfolio evidence is graded for OPEN COLLEGE NETWORK NORTHERN IRELAND Establishing an IT System
Every vocational unit is marked against named criteria rather than an exam percentage. Your tutor's brief lists the exact codes for this unit — here is what each band is asking you to do.
Demonstrate baseline knowledge, accurate terminology, and core practical application.
Provide detailed analysis, structured explanations, and clear workplace reasoning.
Deliver thorough evaluation, original problem solving, and fully justified recommendations.
Before You Start
Prior knowledge that will help with this topic
- •Basic computer literacy, such as using a mouse and keyboard.
- •Familiarity with common software like Microsoft Word or Google Docs.
- •Understanding of file management (saving, opening, and organising files).
Coursework AI Review
Paste your assignment brief and check your draft against its P/M/D criteria
Key Terminology
Essential terms to know
- Be able to set up a personal computer to own requirements., Be able to select and connect an IT system to a communication service to own requirements., Be able to install and configure software for use., Know how to check that the IT system and communication service are functioning.
- Be able to set up a personal computer to own requirements., Be able to select and connect an IT system to a communication service to own requirements., Be able to install and configure software for use., Know how to check that the IT system and communication service are functioning.
Ready to learn?
AI-powered learning tailored to this unit