How is the Level 3 ITQ assessed?

The qualification is assessed through a portfolio of evidence. You will complete practical tasks set by your tutor or chosen from a list of approved assignments. Each task must demonstrate your ability to use IT software to achieve specific outcomes, such as creating a spreadsheet model or designing a presentation. Your portfolio is then internally assessed and externally moderated by the awarding body.

Do I need to have prior IT qualifications to take this course?

No formal qualifications are required, but you should have basic computer skills, such as being able to use a mouse, keyboard, and common software like Word or Excel. The Level 3 certificate is designed for learners who already have some experience and want to build on it. If you are a complete beginner, you may want to start with a Level 1 or 2 ITQ first.

Can I use Google Docs or LibreOffice instead of Microsoft Office?

Yes, you can use any software that meets the assessment criteria. However, most centres use Microsoft Office because it is widely used in the workplace. If you use alternative software, make sure it has equivalent features (e.g., formulas, charts, mail merge) and that you can save files in compatible formats like .docx or .xlsx. Check with your tutor to confirm.

How long does it take to complete the Level 3 ITQ?

The course typically takes 6-12 months, depending on your pace and study hours. It is often delivered as a part-time course in colleges or through distance learning. You can work through the units at your own speed, but you must submit your portfolio within the registration period set by your centre.

What jobs can I get with this qualification?

This qualification is valuable for roles such as administrative assistant, data entry clerk, IT support technician, or digital marketing assistant. It also provides a foundation for further study in IT, such as the Level 3 Diploma in IT or specialised certifications in Microsoft Office Specialist (MOS). Employers value the practical skills you gain, as they directly apply to everyday office tasks.

Is the ITQ recognised by employers?

Yes, the ITQ is a nationally recognised qualification in the UK and is well-regarded by employers. It demonstrates that you have practical, hands-on IT skills that are directly relevant to the workplace. Many employers list ITQ or equivalent qualifications as desirable in job adverts for administrative and IT support roles.

Bespoke Software

OPEN COLLEGE NETWORK YORKSHIRE AND HUMBER REGION TRADING AS CERTA

vocational

This subtopic focuses on the proficient use of custom software solutions tailored to specific business needs, moving beyond generic applications to handle unique data workflows and reporting requirements. Learners must demonstrate the ability to input, structure, and integrate data from diverse sources, and then apply advanced tools to edit, process, format, and present information effectively within the bespoke system. Mastery ensures efficient data management and communication in specialized professional environments.

Learning Outcomes

Assessment Guidance

Key Skills

Key Terms

Assessment Criteria

Assessment criteria

SEG Awards Certa Level 3 Certificate in IT User Skills (ITQ)

Certa Level 1 Diploma in IT User Skills (ITQ) (QCF)

Topic Overview

The SEG Awards Certa Level 3 Certificate in IT User Skills (ITQ) is a vocational qualification designed to equip learners with practical, industry-relevant IT skills for the modern workplace. This certificate covers a broad range of digital competencies, including word processing, spreadsheets, databases, presentation software, and using the internet securely. It is ideal for students who want to demonstrate proficiency in IT applications, whether for employment, further study, or everyday use.

This qualification is part of the Open College Network Yorkshire and Humber Region's Certa suite, which focuses on applied learning. Unlike purely theoretical IT courses, the ITQ emphasises hands-on tasks that mirror real-world scenarios. You will learn how to create professional documents, analyse data using spreadsheets, manage information in databases, and deliver effective presentations. These skills are essential for almost any career, from business administration to digital marketing.

By completing this certificate, you will gain a nationally recognised qualification that proves your ability to use IT effectively. It also prepares you for higher-level study, such as the Level 3 Diploma in IT User Skills, or specialised certifications in Microsoft Office or other software. The course is assessed through portfolio-based evidence, meaning you build a collection of your work to demonstrate your skills. This approach helps you develop a practical understanding that you can immediately apply in the workplace.

Key Concepts

Core ideas you must understand for this topic

→File management: Organising, saving, and retrieving files efficiently using appropriate naming conventions and folder structures.
→Word processing: Creating, formatting, and editing documents using styles, tables, images, and mail merge features.
→Spreadsheets: Using formulas, functions (e.g., SUM, IF, VLOOKUP), charts, and data validation to analyse and present data.
→Databases: Designing tables, setting relationships, creating queries, forms, and reports to manage structured information.
→Presentation software: Designing slides with consistent themes, animations, transitions, and multimedia elements for effective communication.

Learning Objectives

What you need to know and understand

Input, organise and combine information using bespoke software, Use tools and techniques to edit, process, format and present information
Demonstrate accurate input of data into a specified bespoke software application
Apply organisational techniques to structure data within software fields and records
Combine information from at least two different sources within the software to produce a unified output
Use editing tools to identify and correct errors in entered data
Select appropriate formatting features to enhance the presentation of on-screen and printed information
Present organised and formatted information to meet given requirements

Assessment Criteria

Key criteria assessors look for in your portfolio

Award credit for accurate data entry into the bespoke software, including evidence of validation and error-checking to maintain data integrity.
Credit for organising information using the software’s specific structures such as hierarchies, tags, or custom fields to facilitate retrieval and analysis.
Credit for combining data from multiple files or external databases through importing, linking, or merging, ensuring consistency and completeness.
Credit for applying appropriate editing and processing tools, such as automated calculations, macros, or workflow actions, to manipulate data efficiently.
Credit for formatting and presenting outputs according to given specifications, utilising charts, reports, or dashboards that clearly communicate the intended message.
Award credit for correctly entering provided data into the correct fields without typographical errors
Credit for demonstrating the use of software functions such as sort, filter, or group to organise information
Credit for successfully merging or linking data from separate documents or tables into a single coherent record
Credit for applying consistent formatting (e.g., font styles, alignment, borders) to improve readability
Credit for producing a final output (report, chart, or dataset) that meets the specified task requirements

Assessment Guidance

Guidance for achieving higher grades

💡Before the assessment, thoroughly familiarise yourself with the specific bespoke software through practice exercises or demo environments.
💡Read the assignment brief carefully to identify required output formats, and use the software’s templates or style sets to ensure compliance.
💡During the task, keep a log of your actions and decisions; this can serve as evidence of your methodology and troubleshooting steps.
💡When presenting information, think about the end-user: use clear labels, appropriate chart types, and concise summaries to enhance comprehension.
💡Spend time exploring the software's menu structure and help resources before undertaking assessed tasks
💡Ensure you understand the assessment brief fully; some tasks may specify exact formatting or data combination methods
💡Practice entering sample data to build speed and accuracy with the bespoke interface
💡Use a systematic approach: input, verify, organise, edit, format, and then present to avoid missing steps
💡During practical assessments, narrate your actions to the assessor if evidence by observation is required
💡Always read the task brief carefully. Many students lose marks by not following specific instructions, such as using a particular font size or including a header. Highlight key requirements before you start.
💡Save your work regularly and use version numbers (e.g., 'Report_v2'). If your file corrupts, you'll have a backup. Also, ensure your filenames match what the task asks for.
💡When creating evidence for your portfolio, annotate your screenshots or explain your steps in a short commentary. This shows the examiner your thought process and ensures you meet the assessment criteria fully.

Common Mistakes

Common errors to avoid in your coursework

Assuming the bespoke software functions identically to common office suites, leading to misuse of tools or inefficient workflows.
Neglecting to back up data before performing bulk operations, resulting in irreversible data loss if errors occur.
Over-formatting outputs with excessive graphics or fonts that distract from the key information and violate corporate style guides.
Failing to explore the software’s full range of features, such as collaboration or automation, which could streamline tasks and improve accuracy.
Neglecting to proofread data entries for accuracy, leading to poor quality outputs
Misinterpreting bespoke software icons or menu options due to lack of familiarity with specialized interfaces
Failing to save work frequently, risking data loss in non-standard applications that may lack auto-save
Applying excessive or inconsistent formatting that detracts from the professional appearance of the information
Overlooking the need to verify that combined data remains logically coherent
Misconception: 'ITQ is just about knowing how to use software like Word or Excel.' Correction: While software proficiency is key, the qualification also tests your ability to apply these tools to solve problems, manage data securely, and communicate effectively. You need to understand the 'why' behind each action.
Misconception: 'I can just memorise steps and pass.' Correction: The portfolio-based assessment requires you to produce original work that meets specific criteria. You must demonstrate understanding by making appropriate choices, such as selecting the right chart type or applying correct formatting for a given audience.
Misconception: 'Spreadsheets are only for calculations.' Correction: Spreadsheets are also powerful for data organisation, filtering, and creating visualisations. You need to know how to use features like conditional formatting, pivot tables, and data validation to manage information effectively.

Frequently Asked Questions

Common questions students ask about this topic

Before You Start

Prior knowledge that will help with this topic

•Basic computer literacy: understanding how to use a keyboard, mouse, and common operating system functions (e.g., opening files, using menus).
•Familiarity with common software applications like Microsoft Word, Excel, and PowerPoint at a beginner level (e.g., typing text, creating simple tables).
•Understanding of file types (e.g., .docx, .xlsx) and how to save/export documents in different formats.

Key Terminology

Essential terms to know

Input, organise and combine information using bespoke software, Use tools and techniques to edit, process, format and present information
Data entry and accuracy
Information organisation
Combining data from multiple sources
Editing and processing techniques
Professional formatting
Presentation of outputs

Ready to learn?

AI-powered learning tailored to this unit

Bespoke Software

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 OPEN COLLEGE NETWORK YORKSHIRE AND HUMBER REGION TRADING AS CERTA vocational Digital Skills & IT

Audio Software