Level 2 Certificate in IT Essentials

This course covers accredited ITQ (IT User Qualification) units listed on Ofqual and can lead to a Level 2 RQF (Regulated Qualifications Framework) qualification. The ITQ is a nationally recognised qualification for those who need digital skills as users of technology. As well as providing an excellent knowledge base in using a computer, the IT Essentials Level 2 course is ideal for:

• Students who are planning to gain an internationally recognised qualification in IT.
• Those aspiring to achieve a career in the IT industry.
• Those that want to progress in their current IT career.
• Learners who want to boost their IT skills.

What next? Following the successful completion of this course, you will be able to put your newfound knowledge into practice and develop your career. If after, you’re looking to enhance your IT knowledge even further, take a look at the other IT and computer courses we offer. Here are some of the job titles within IT:

• IT support technician
• Network engineer
• Database administrator
• Software developer
• Web developer
• Cyber security analyst
• Cloud analyst
• Cloud engineer
• Business analyst
• Project manager
• IT consultant

Course Content

Lesson 1 IT fundamentals

• Introduction to computers
• Hardware and software
• Using Windows 10
• Organising files
• Managing files
• Information networks
• Health and safety
• Lesson review and quiz
• Assignment 1 – file management exercise

Lesson 2 Word processing

• Introduction
• The Microsoft Word application
• Document creation
• Formatting text
• Word objects
• Mail merge
• Prepare outputs
• Lesson review and quiz
• Assignment 2 – Word processing exercises

Lesson 3 Spreadsheets

• Introduction
• The Excel application
• Cell basics
• Managing worksheets
• Formulae and functions
• Formatting charts
• Preparing Outputs
• Lesson review and quiz
• Assignment 3 – Excel exercises

Lesson 4 Database software

• Introduction
• Using the Access application
• Database tables
• Retrieving data
• Database objects
• Preparing output
• Lesson review and quiz
• Assignment 4 – Access exercises

Lesson 5 Presentation software

• Introduction
• Using the PowerPoint application
• Developing a presentation
• Inserting text
• Inserting charts
• Graphical elements
• Preparing outputs
• Lesson review and quiz
• Assignment 5 – Build a presentation

Lesson 6 Internet and email

• Introduction
• Web browsing concepts
• Web browsing
• Web based information
• Communication concepts
• Using email
• Lesson review and quiz
• Assignment 6 – Blog software research project

Lesson 7 Improving productivity

• Introduction
• Using IT systems
• Selecting IT systems
• Reviewing IT systems
• Improving productivity
• Lesson review and quiz
• Assignment 7 – Productivity review

Lesson 8 IT security

• Introduction
• System performance and security
• Information security
• Technology security
• Guidelines and procedures
• Data security
• Lesson review and quiz
• Assignment 8 – Write a security policy