What software do I need for the City & Guilds Level 2 IT Users qualification?

You will typically use Microsoft Office applications such as Word, Excel, PowerPoint, and Access. However, the qualification is software-neutral, so you can use alternatives like Google Workspace or LibreOffice. Check with your centre for specific requirements. The key is to be proficient in the features required by the syllabus, such as mail merge in word processing or pivot tables in spreadsheets.

How is the City & Guilds Level 2 IT Users qualification assessed?

Assessment is through a portfolio of evidence, where you complete practical tasks set by your tutor. These tasks are based on real-world scenarios, such as creating a newsletter or analysing sales data. You will be observed and your work will be marked against specific criteria. There are no formal exams, but you must demonstrate competence in each unit.

Can I use keyboard shortcuts in the exam?

Yes, using keyboard shortcuts is encouraged as it shows efficiency and can save time. Common shortcuts like Ctrl+C (copy), Ctrl+V (paste), and Ctrl+Z (undo) are useful. However, ensure you also know how to perform tasks using menus and ribbons, as some assessors may require you to demonstrate both methods.

What is the difference between Level 1 and Level 2 in IT Users?

Level 1 covers basic skills like creating simple documents and using email. Level 2 requires more advanced skills, such as using formulas and functions in spreadsheets, creating databases with queries and reports, and designing presentations with animations and transitions. Level 2 also places greater emphasis on problem-solving and independent working.

How long does it take to complete the Level 2 Certificate?

The qualification typically takes 6-12 months to complete, depending on your pace and the number of hours you study per week. It is often delivered in colleges or training centres as a part-time course. You can also study online at your own speed, but you must submit your portfolio for assessment.

Do I need to know programming for this qualification?

No, programming is not required. The qualification focuses on using common software applications, not coding. However, you may encounter simple automation tools like macros in Excel, which are optional. If you are interested in programming, consider progressing to a Level 3 qualification in IT or a specialised course in coding.

Set Up an IT System

CITY AND GUILDS OF LONDON INSTITUTE

vocational

This subtopic equips learners with essential practical skills to safely set up a personal computer system by connecting components, peripherals, and establishing network connectivity. It covers the process of installing and configuring software applications, followed by systematic checks to ensure the IT system and communication services are fully operational, enabling effective digital work.

Learning Outcomes

Assessment Guidance

Key Skills

Key Terms

Assessment Criteria

Assessment criteria

City & Guilds Level 2 Certificate for IT Users (QCF)

Topic Overview

The City & Guilds Level 2 Certificate for IT Users (QCF) is a nationally recognised qualification designed to equip learners with essential digital skills for the modern workplace. It covers a broad range of IT topics, including word processing, spreadsheets, databases, presentation software, and using the internet safely and effectively. This qualification is ideal for students who want to demonstrate their competence in using common IT applications, whether for further study, employment, or everyday life.

The course is structured around practical, real-world tasks that require you to apply your knowledge in context. For example, you might create a business report using word processing software, analyse data in a spreadsheet, or design a multimedia presentation. Each unit focuses on specific software skills and also emphasises important concepts like file management, data security, and legal considerations such as copyright and data protection. Mastering these skills not only helps you pass the exam but also prepares you for the digital demands of almost any career.

This qualification fits into the wider subject of Digital Skills and IT by providing a solid foundation for more advanced study, such as the Level 3 Diploma in IT or specialised certifications in areas like cybersecurity or web development. It is also highly valued by employers across industries, as it demonstrates that you can use IT tools efficiently and responsibly. By the end of the course, you will have a portfolio of evidence showing your ability to complete common IT tasks to a professional standard.

Key Concepts

Core ideas you must understand for this topic

→File management: Organising files and folders logically, using appropriate naming conventions, and understanding file extensions (e.g., .docx, .xlsx).
→Data protection: Knowing the principles of the Data Protection Act (2018) and how to handle personal data securely, including password protection and encryption.
→Spreadsheet formulas and functions: Using basic formulas (SUM, AVERAGE) and functions (IF, VLOOKUP) to manipulate data and produce accurate results.
→Presentation design: Applying consistent formatting, using appropriate slide layouts, and incorporating multimedia elements (images, charts, animations) effectively.
→Safe internet use: Recognising phishing attempts, using strong passwords, and understanding the risks of sharing personal information online.

Learning Objectives

What you need to know and understand

Connect up a personal computer, printer and peripheral devices safely, Connect to an IT communication service, Set up software for use, Check that the IT system and communication service are working successfully

Assessment Criteria

Key criteria assessors look for in your portfolio

Award credit for correctly identifying and connecting power and data cables (e.g., USB, HDMI, VGA) to appropriate ports while observing anti-static precautions.
Demonstrate ability to configure a network connection, such as entering Wi-Fi credentials or connecting an Ethernet cable and verifying IP settings.
Show competence in installing and launching a specified software application, adjusting initial settings like user preferences or default file locations.
Produce evidence of performing functional tests, such as sending a test print, accessing a website, or running a software self-test.

Assessment Guidance

Guidance for achieving higher grades

💡Always follow a logical sequence: first physical setup, then connectivity, then software, then testing—document each step as you go.
💡When checking system functionality, use a methodical approach: test all hardware components (printer, scanner, speakers) and verify communication services by accessing both intranet and internet resources.
💡For assessed practical tasks, keep a checklist of the learning outcomes to ensure you demonstrate all required skills, such as configuring email client settings if part of communication services.
💡Read the task carefully and highlight key words like 'create', 'format', 'calculate', or 'analyse'. This ensures you address exactly what is asked and don't miss any requirements.
💡Always check your work for errors before submitting. Use spell check, preview your document, and double-check formulas in spreadsheets. Small mistakes can cost marks.
💡Manage your time effectively. If you get stuck on a task, move on and come back to it later. It's better to complete all tasks partially than to spend too long on one.

Common Mistakes

Common errors to avoid in your coursework

Forgetting to connect the power cable to the printer before attempting to install drivers, leading to hardware not detected.
Neglecting to check physical connections (e.g., monitor not displaying due to loose VGA cable) before assuming a fault.
Using default settings without customising software to meet user requirements, causing later inefficiency.
Assuming an internet connection is working without testing basic connectivity (e.g., pinging a website) and only relying on icon indicators.
Misconception: 'I don't need to save my work regularly because the software autosaves.' Correction: Autosave may not always work, especially if the software crashes or you lose power. Always save your work manually every few minutes and keep backup copies.
Misconception: 'Using lots of different fonts and colours makes my document look professional.' Correction: Overusing fonts and colours can make your work look messy and unprofessional. Stick to a maximum of two fonts and use consistent formatting for headings and body text.
Misconception: 'Spreadsheets are just for calculations; I don't need to worry about formatting.' Correction: Formatting is crucial for readability and accuracy. Use cell borders, number formats (currency, percentage), and conditional formatting to highlight important data.

Frequently Asked Questions

Common questions students ask about this topic

Before You Start

Prior knowledge that will help with this topic

•Basic computer literacy: Ability to turn on a computer, use a mouse and keyboard, and open/close applications.
•Understanding of common file types (e.g., .doc, .pdf, .jpg) and how to save and open files.
•Familiarity with the internet and using a web browser to search for information.

Key Terminology

Essential terms to know

Connect up a personal computer, printer and peripheral devices safely, Connect to an IT communication service, Set up software for use, Check that the IT system and communication service are working successfully

Ready to learn?

AI-powered learning tailored to this unit

Set Up an IT System

Assessment criteria

Topic Overview

Key Concepts

Learning Objectives

Assessment Criteria

Assessment Guidance

Common Mistakes

Frequently Asked Questions

Before You Start

Key Terminology

Ready to learn?

Related Topics in CITY AND GUILDS OF LONDON INSTITUTE vocational Digital Skills & IT

Business Concepts 2

Creating a procedural computer program

Creating an event driven computer program

Creating an object oriented computer program

Topic Synopsis

Key Concepts & Core Principles

Exam Tips & Revision Strategies

Common Misconceptions & Mistakes to Avoid

Examiner Marking Points

Set Up an IT System

Assessment criteria

Topic Overview

Key Concepts

Learning Objectives

Assessment Criteria

Assessment Guidance

Common Mistakes

Frequently Asked Questions

What software do I need for the City & Guilds Level 2 IT Users qualification?

How is the City & Guilds Level 2 IT Users qualification assessed?

Can I use keyboard shortcuts in the exam?

What is the difference between Level 1 and Level 2 in IT Users?

How long does it take to complete the Level 2 Certificate?

Do I need to know programming for this qualification?

Before You Start

Key Terminology

Ready to learn?

Related Topics in CITY AND GUILDS OF LONDON INSTITUTE vocational Digital Skills & IT

Business Concepts 2

Creating a procedural computer program

Creating an event driven computer program

Creating an object oriented computer program