About this course

The Certificate in IT User Skills aims to provide a nationally recognised standard in Information Technology that is accessible and flexible whilst being reliable, consistent and a valid IT benchmark. Learners may gain the 12 credits required to gain the Certificate by successfully completing the following 3 units: Word Processing Software (Word), Spreadsheet Software (Excel) and Presentation Software (Powerpoint), plus a further unit entitled Improving Productivity.

What will the course involve?

Word Processing Unit

Develop skills in Microsoft Word to create professional looking multi-page documents which integrate tables, images and graphs and use the mail-merge feature to produce standard letters and labels.

Spreadsheet Unit

Develop skills in Microsoft Excel to produce a variety of spreadsheets and graphs:

• Create and edit existing spreadsheets
• Use a variety of formatting styles
• Add, subtract, multiply and divide formulas
• Various Functions eg =SUM, =AVERAGE, =MAX, =MIN, =IF, =COUNTIF
• Link formulas in different spreadsheets
• Data Management: Sort, Filter, Automatic Sub-Totalling
• Create a variety of graphs

Presentation Unit

Develop skills in Microsoft PowerPoint to create professional looking slide presentations which include:

• Use of slide master
• Creation of embedded Organisation Charts
• Creation of embedded Excel graphs
• Apply animations to text and objects
• Apply transitions and timings
• Print presentations in a variety of formats

What qualifications will I need?

This course is suitable for those wishing to build on the Microsoft Office software skills gained at Level 1 or for those with equivalent experience who wish to progress to Level 2.

How much will the course cost?

Additional Costs

All students are subject to a £25 registration fee per academic year. 

Each student will receive a print allowance at the start of their course, should they require additional printing beyond this limit, they will be charged.

Next Steps

Progress to OCR Level 3 Award for IT Users