OCN London · RQF Level 3
OCNLR Level 3 Award in IT User Skills (ITQ)
You don’t just earn this. You learn to use it, one-to-one, on your own real work.
- LevelRQF Level 3
- Total credits12
- Guided learning85 hours
- Units in this qualification82
Awarded by OCN London · on the Ofqual register
Start here
See how this course maps onto your role
Ten quick questions, one per Future Fluency, asked against this qualification rather than a generic one.
About 5 minutes · No card · Nothing to commit to
What you’ll learn
What each unit actually teaches you to do
The OCNLR Level 3 Award in IT User Skills (ITQ) is a vocational qualification. It allows learners to develop skills in areas such as using the internet, collaborative technologies, and audio software. It is aimed at individuals who wish to enhance their IT user skills within a digital technology environment.
These are the units OCN London registers against this qualification. It is a catalogue, not a syllabus. Which of them you take depends on the combination the qualification requires, and that is set by the awarding body rather than by us. Every unit here is regulated, and every one you earn is yours to keep.
Audio SoftwareReal unit · OCN London
What you'll be able to do
- Use audio hardware and software to capture audio sequences effectively.
- Use audio software tools and techniques to combine captured audio sequences into a cohesive whole.
- Use audio software tools and techniques to edit captured audio sequences to a professional standard.
- Play and present audio sequences using appropriate hardware and software.
Audio SoftwareReal unit · OCN London
What you'll be able to do
- Use audio hardware to capture sequences, setting up microphones and recording equipment correctly
- Use audio software to capture sequences, configuring recording settings and levels appropriately
- Use audio software tools to edit sequences, applying cuts, fades, and other adjustments
- Use audio software techniques to edit sequences, manipulating audio waveforms and effects
- Play audio sequences, ensuring correct playback settings and volume levels
- Present audio sequences, integrating them into presentations or other media
Audio SoftwareReal unit · OCN London
What you'll be able to do
- Use audio hardware to capture audio sequences effectively
- Use audio software to capture audio sequences effectively
- Use audio software tools to combine audio sequences into a cohesive whole
- Use audio software tools to edit audio sequences to improve their quality
- Play audio sequences using appropriate hardware and software
- Present audio sequences to an audience in a clear and engaging manner
Bespoke SoftwareReal unit · OCN London
What you'll be able to do
- Input information accurately using bespoke software
- Organise information effectively using bespoke software
- Combine information effectively using bespoke software
- Use tools and techniques within the bespoke software to edit information
- Use tools and techniques within the bespoke software to process information
- Use tools and techniques within the bespoke software to format information
- Use tools and techniques within the bespoke software to present information
Bespoke SoftwareReal unit · OCN London
What you'll be able to do
- Input information using bespoke applications
- Combine information using bespoke applications
- Use appropriate structures to organise information efficiently
- Use appropriate structures to retrieve information efficiently
- Use the functions of the software effectively to process information
- Use the functions of the software effectively to present information
Bespoke SoftwareReal unit · OCN London
What you'll be able to do
- Input and combine information effectively using bespoke software applications.
- Create and modify appropriate data structures within the bespoke software to organise and retrieve information efficiently.
- Exploit the available functions of the bespoke software effectively to process and present information in a clear and concise manner.
Computerised Accounting SoftwareReal unit · OCN London
What you'll be able to do
- Access accounting information using computerised accounting software
- Enter accounting information using computerised accounting software
- Edit accounting information using computerised accounting software
- Use tools and techniques to process business transactions within computerised accounting software
- Produce accounting documents to meet requirements using computerised accounting software
- Produce summary reports to meet requirements using computerised accounting software
Computerised Accounting SoftwareReal unit · OCN London
What you'll be able to do
- Access computerised accounting software securely and efficiently
- Enter accounting information accurately and completely into the software
- Edit accounting information as required to maintain accuracy and currency
- Select appropriate tools and techniques within the software to process business transactions
- Use selected tools and techniques to process business transactions accurately and efficiently
- Produce accounting documents, such as invoices and receipts, to meet business requirements
- Produce summary reports, such as profit and loss statements and balance sheets, to meet reporting requirements
Computerised Accounting SoftwareReal unit · OCN London
What you'll be able to do
- Access accounting information within a computerised accounting system, using appropriate security measures
- Enter accounting information accurately and efficiently into the system, following established procedures
- Edit accounting information as required, ensuring data integrity and accuracy
- Process business transactions from source documents, such as invoices and receipts, using the computerised accounting system
- Develop management information reports using the computerised accounting system, selecting appropriate data and formatting options
- Interpret management information reports to identify trends, patterns, and anomalies, and to support decision-making
- Set up a computerised accounting system ready for use, including configuring settings, creating accounts, and importing data
Data Management SoftwareReal unit · OCN London
What you'll be able to do
- Enter data records in a data management system
- Edit data records in a data management system
- Maintain data records in a data management system
- Retrieve data records to meet requirements from a data management system
- Display data records to meet requirements from a data management system
Data Management SoftwareReal unit · OCN London
What you'll be able to do
- Enter data records into a data management system, ensuring accuracy and completeness
- Edit and maintain data records in a data management system, updating information as required
- Retrieve data records from a data management system based on specified criteria
- Display data records to meet requirements, presenting information in a clear and understandable format
Data Management SoftwareReal unit · OCN London
What you'll be able to do
- Enter data records in a data management system
- Edit data records in a data management system
- Maintain data records in a data management system
- Retrieve data records to meet requirements from a data management system
- Display data records to meet requirements from a data management system
Database SoftwareReal unit · OCN London
What you'll be able to do
- Enter structured information accurately and efficiently into a database
- Edit existing information within a database to ensure accuracy and currency
- Organise structured information within a database to facilitate efficient retrieval and analysis
- Use database software tools to extract specific information based on defined criteria
- Produce reports from a database that effectively summarise and present extracted information
Database SoftwareReal unit · OCN London
What you'll be able to do
- Create non-relational database tables, defining fields and data types appropriately
- Modify non-relational database tables, altering fields and data types as required
- Enter structured information in a database, inputting data accurately and consistently
- Edit structured information in a database, correcting errors and updating records
- Organise structured information in a database, using indexing and sorting techniques
- Use database software tools to run queries, retrieving specific data based on defined criteria
- Use database software tools to produce reports, generating summaries and analyses of data
Database SoftwareReal unit · OCN London
What you'll be able to do
- Plan relational database tables to meet requirements
- Create relational database tables to meet requirements
- Modify relational database tables to meet requirements
- Enter structured information into a database
- Edit structured information in a database
- Organise structured information in a database
- Use database software tools to create data queries
- Use database software tools to edit data queries
- Use database software tools to run data queries
- Use database software tools to produce reports
Design SoftwareReal unit · OCN London
What you'll be able to do
- Obtain information from various sources for use in designs, ensuring accuracy and relevance
- Insert information into designs effectively, maintaining consistency and visual appeal
- Combine different types of information effectively within designs to achieve the desired outcome
- Use design software tools to create original designs that meet specific requirements
- Manipulate existing designs using design software tools to adapt them to new purposes
- Edit designs using design software tools to correct errors and improve their overall quality
Design SoftwareReal unit · OCN London
What you'll be able to do
- Obtain information relevant to designs
- Insert information accurately into design software
- Combine information effectively within design software
- Use design software tools to create designs
- Use design software tools to manipulate designs
- Use design software tools to edit designs
Design SoftwareReal unit · OCN London
What you'll be able to do
- Obtain information from various sources for use in designs, ensuring accuracy and relevance
- Insert information into design software, maintaining appropriate formatting and layout
- Combine different types of information (e.g., text, images, graphics) to create visually appealing designs
- Use design software tools to create designs, utilising various features and functions
- Use design software tools to manipulate designs, adjusting size, shape, and position of elements
- Use design software tools to edit designs, making changes to colours, fonts, and other visual aspects
Desktop Publishing SoftwareReal unit · OCN London
What you'll be able to do
- Select and use appropriate designs and page layouts for publications, considering the target audience and purpose
- Input and combine text and other information within publications, ensuring consistency and accuracy
- Use desktop publishing software techniques to edit and format publications to a professional standard
Desktop Publishing SoftwareReal unit · OCN London
What you'll be able to do
- Select appropriate designs and page layouts for publications, considering factors such as target audience, purpose, and branding guidelines
- Use appropriate designs and page layouts for publications, ensuring consistency and visual appeal
- Input text accurately into publications, adhering to specified formatting requirements
- Combine text with other information, such as images, charts, and tables, to create visually engaging and informative publications
- Use desktop publishing software techniques to edit text, including adjusting font styles, sizes, and spacing
- Use desktop publishing software techniques to format publications, including setting margins, columns, and headers/footers
Desktop Publishing SoftwareReal unit · OCN London
What you'll be able to do
- Select and use appropriate designs and page layouts for publications, considering the target audience and purpose
- Input text and other information into publications, ensuring accuracy and consistency
- Combine text and other information within publications, arranging elements effectively to create a visually appealing layout
- Use desktop publishing software techniques to edit publications, making corrections and adjustments as needed
- Use desktop publishing software techniques to format publications, applying styles and effects to enhance the overall appearance
Drawing and Planning SoftwareReal unit · OCN London
What you'll be able to do
- Input information accurately and efficiently for use in drawings or plans
- Organise information logically and systematically for drawings or plans
- Combine different types of information effectively to create comprehensive drawings or plans
- Use a range of tools within drawing and planning software to edit drawings or plans
- Manipulate elements within drawings or plans to achieve desired outcomes
- Format drawings or plans to ensure clarity and professional presentation
- Present drawings or plans in a suitable format for the intended audience and purpose
Drawing and Planning SoftwareReal unit · OCN London
What you'll be able to do
- Input, organise and combine information effectively for the creation of drawings or plans.
- Use appropriate tools and techniques to edit drawings or plans to meet specific requirements.
- Use appropriate tools and techniques to manipulate drawings or plans to achieve desired outcomes.
- Use appropriate tools and techniques to format drawings or plans for clarity and professionalism.
- Use appropriate tools and techniques to present drawings or plans effectively.
Drawing and Planning SoftwareReal unit · OCN London
What you'll be able to do
- Input information for drawings or plans
- Organise information for drawings or plans
- Combine information for drawings or plans
- Use tools to edit drawings or plans
- Use techniques to edit drawings or plans
- Use tools to manipulate drawings or plans
- Use techniques to manipulate drawings or plans
- Use tools to format drawings or plans
- Use techniques to format drawings or plans
- Use tools to present drawings or plans
- Use techniques to present drawings or plans
IT Communication FundamentalsReal unit · OCN London
What you'll be able to do
- Select and use a variety of sources of information to meet specific communication needs.
- Access, search for, select and use Internet-based information resources effectively.
- Evaluate the fitness for purpose of Internet-based information.
- Select and use appropriate IT tools to communicate and exchange information safely.
- Demonstrate responsible and effective communication practices when using IT.
IT Communication FundamentalsReal unit · OCN London
What you'll be able to do
- Use a variety of sources of information, including digital and non-digital sources, to meet specific information needs
- Access Internet-based information effectively using appropriate search strategies and tools
- Search for relevant information on the Internet using appropriate keywords and search techniques
- Select relevant information from Internet sources based on its suitability for the intended purpose
- Use Internet-based information effectively to meet specific needs
- Assess the fitness for purpose of Internet-based information, considering factors such as accuracy, reliability, and bias
- Select appropriate IT tools and methods to communicate information effectively
- Use IT to communicate information clearly and concisely to a specified audience
- Use IT to exchange information effectively with others, ensuring secure and reliable transmission
IT Security for UsersReal unit · OCN London
What you'll be able to do
- Select appropriate procedures to monitor security risks to IT systems and data
- Use appropriate procedures to monitor security risks to IT systems and data
- Develop appropriate procedures to minimise security risks to IT systems and data
IT Security for UsersReal unit · OCN London
What you'll be able to do
- Use appropriate methods to minimise security risks to IT systems and data, implementing preventative measures and safeguards
IT Security for UsersReal unit · OCN London
What you'll be able to do
- Select and use appropriate methods to minimise security risk to IT systems and data, adhering to organisational policies and legal requirements
IT Software FundamentalsReal unit · OCN London
What you'll be able to do
- Select and use software applications to meet specific needs and solve problems effectively
- Enter, develop and format different types of information to suit its meaning and purpose, ensuring accuracy and clarity
- Present information in ways that are fit for purpose and audience, considering accessibility and engagement
- Make effective use of IT tools and facilities to present information in a professional and impactful manner
IT Software FundamentalsReal unit · OCN London
What you'll be able to do
- Select appropriate software applications to meet specific needs
- Use appropriate software applications to solve specific problems
- Enter different types of information into software applications
- Develop different types of information within software applications
- Combine different types of information within software applications
- Format different types of information to suit its meaning and purpose
- Present information in ways that are fit for purpose
- Present information in ways that are appropriate for the intended audience
- Evaluate the selection of IT tools and facilities used to present information
- Evaluate the use of IT tools and facilities used to present information
IT User FundamentalsReal unit · OCN London
What you'll be able to do
- Use IT systems effectively to meet specific needs and requirements
- Organise information efficiently using appropriate IT tools and techniques
- Store information securely using appropriate IT systems and methods
- Retrieve information effectively and efficiently from IT systems
- Follow established safety practices when using IT systems
- Understand the need for security practices to protect IT systems and data
- Carry out routine maintenance tasks on IT systems
- Respond to routine IT system problems in a timely and effective manner
IT User FundamentalsReal unit · OCN London
What you'll be able to do
- Use IT systems effectively to meet a variety of needs in a professional context
- Manage information storage and retrieval appropriately, ensuring data integrity and accessibility
- Follow and understand the need for safety and security practices when using IT systems
- Maintain IT systems and troubleshoot common IT system problems effectively
Imaging SoftwareReal unit · OCN London
What you'll be able to do
- Obtain, insert and combine information from various sources for inclusion in images
- Use imaging software tools to create, manipulate and edit images, achieving desired visual effects and outcomes
Imaging SoftwareReal unit · OCN London
What you'll be able to do
- Obtain information from various sources for inclusion in images, such as text, data, and graphics
- Insert information into images, ensuring proper placement and alignment
- Combine different types of information within images to create visually appealing and informative compositions
- Use imaging software tools to create images from scratch, utilising various drawing and painting tools
- Use imaging software tools to manipulate existing images, such as resizing, cropping, and rotating
- Use imaging software tools to edit images, including adjusting colour, brightness, and contrast
Imaging SoftwareReal unit · OCN London
What you'll be able to do
- Obtain information for inclusion in images
- Insert information into images
- Combine information within images
- Use imaging software tools to create images
- Use imaging software tools to manipulate images
- Use imaging software tools to edit images
Improving Productivity Using ITReal unit · OCN London
What you'll be able to do
- Plan the use of appropriate IT systems and software for different purposes, considering factors such as functionality, compatibility, and cost-effectiveness
- Select appropriate IT systems and software for different purposes, based on a thorough evaluation of available options
- Use appropriate IT systems and software for different purposes, adhering to organisational policies and procedures
- Review the ongoing use of IT tools and systems to identify areas for improvement and optimisation
- Adapt the ongoing use of IT tools and systems to ensure that activities are successful and meet evolving needs
- Develop solutions to improve the ongoing use of IT tools and systems, addressing identified challenges and opportunities
- Test solutions to improve the ongoing use of IT tools and systems, ensuring that they are effective and reliable
Improving Productivity Using ITReal unit · OCN London
What you'll be able to do
- Plan the use of appropriate IT systems for different purposes
- Plan the use of appropriate IT software for different purposes
- Select appropriate IT systems for different purposes
- Select appropriate IT software for different purposes
- Use appropriate IT systems for different purposes
- Use appropriate IT software for different purposes
- Evaluate the selection of IT tools to make sure that activities are successful
- Evaluate the use of IT tools to make sure that activities are successful
- Devise solutions to improve the use of IT tools for self and others
- Devise solutions to improve the use of IT systems for self and others
Improving Productivity Using ITReal unit · OCN London
What you'll be able to do
- Plan the use of appropriate IT systems and software to meet specific requirements, considering factors such as functionality, compatibility, and cost
- Use IT systems and software efficiently to complete planned tasks, adhering to organisational policies and procedures
- Review the selection of IT tools to ensure they are fit for purpose and meet the needs of the work activities
- Review the use of IT systems and software to make sure that work activities are successful, identifying areas for improvement
Multimedia SoftwareReal unit · OCN London
What you'll be able to do
- Plan the content of multimedia products, taking into account the target audience and purpose
- Plan the organisation of multimedia products to ensure logical flow and ease of navigation
- Obtain content from various sources, ensuring appropriate permissions and licences are in place
- Input content into multimedia software, maintaining quality and accuracy
- Combine different types of content (e.g., text, images, audio, video) to create engaging multimedia outcomes
- Use multimedia software tools to edit content, adjusting parameters such as colour, brightness, and contrast
- Use multimedia software tools to format content, ensuring consistency and visual appeal
- Play multimedia outcomes to test functionality and identify areas for improvement
- Present multimedia outcomes to stakeholders, gathering feedback and making necessary revisions
Multimedia SoftwareReal unit · OCN London
What you'll be able to do
- Plan the content and organisation of multimedia products to meet identified needs and objectives.
- Obtain, input and combine various content types, such as text, images, audio, and video, to build comprehensive multimedia outcomes.
- Use appropriate tools and techniques to build and edit multimedia content effectively.
- Play and present multimedia outcomes in a suitable format for the intended audience.
Multimedia SoftwareReal unit · OCN London
What you'll be able to do
- Plan the content and organisation of multimedia products to meet identified needs and objectives
- Obtain, input and combine content from various sources to build comprehensive multimedia outcomes
- Use multimedia software tools to edit and format multimedia content to meet specified requirements and standards
- Play and present multimedia outcomes effectively, ensuring optimal viewing and listening experiences
Optimise IT System PerformanceReal unit · OCN London
What you'll be able to do
- Maintain hardware components in working order to ensure optimal IT system performance.
- Maintain software applications in working order to ensure optimal IT system performance.
- Manage files effectively to maintain optimal system performance and prevent data loss.
- Respond effectively to common IT system problems and errors to minimise disruption.
- Customise the working environment, including settings and configurations, to meet specific user needs and preferences.
Optimise IT System PerformanceReal unit · OCN London
What you'll be able to do
- Keep computer hardware operating efficiently to ensure optimal performance
- Keep computer software operating efficiently to ensure optimal performance
- Manage files effectively to optimise IT system performance
- Manage disks effectively to optimise IT system performance
- Troubleshoot common IT system problems and errors effectively
- Respond appropriately to common IT system problems and errors
- Customise the working environment to optimise performance and user experience
- Maintain software regularly to meet ongoing performance needs
Optimise IT System PerformanceReal unit · OCN London
What you'll be able to do
- Keep computer hardware operating efficiently through regular maintenance and optimisation
- Keep computer software operating efficiently through updates and configuration
- Manage files effectively to maintain and improve IT system performance
- Troubleshoot IT system problems quickly and effectively to minimise downtime
- Respond to IT system problems in a way that minimises disruption
- Plan routine maintenance of hardware and software to ensure optimal performance
- Monitor the routine maintenance of hardware and software to identify potential issues
- Plan non-routine maintenance of hardware and software to address specific needs
- Monitor the non-routine maintenance of hardware and software to ensure effectiveness
- Review hardware and software configurations to identify areas for improvement
- Modify hardware and software configurations to maintain optimal performance
Personal Information Management SoftwareReal unit · OCN London
What you'll be able to do
- Use calendars to schedule appointments
- Use calendars to schedule meetings
- Use a task list to prioritise activities
- Use an address book to store contact information
- Use an address book to organise contact information
- Use an address book to retrieve contact information
Personal Information Management SoftwareReal unit · OCN London
What you'll be able to do
- Use a calendar application to schedule appointments, including setting reminders and recurring events
- Use a task list application to prioritise activities, assigning due dates and tracking progress
- Use an address book application to store contact information, including names, addresses, phone numbers, and email addresses
- Organise contact information in an address book application, using groups or categories
- Retrieve contact information from an address book application efficiently and accurately
Presentation SoftwareReal unit · OCN London
What you'll be able to do
- Input and combine text and other information, such as images and charts, within presentation slides.
- Use presentation software tools to structure slides in a logical order.
- Use presentation software tools to edit and format slides for visual appeal and clarity.
- Prepare slides for presentation to meet specific audience needs and objectives.
Presentation SoftwareReal unit · OCN London
What you'll be able to do
- Input and combine text and other information effectively within presentation slides
- Use presentation software tools to structure, edit and format slide sequences logically and professionally
- Prepare slideshow for presentation, ensuring it is engaging and informative
Presentation SoftwareReal unit · OCN London
What you'll be able to do
- Input text and other information within presentation slides accurately and efficiently
- Combine text and other information effectively within presentation slides to create a cohesive presentation
- Use presentation software tools to structure presentations logically and effectively
- Edit presentations using presentation software tools to ensure accuracy and clarity
- Format presentations using presentation software tools to enhance visual appeal and readability
- Prepare an interactive slideshow for presentation, incorporating elements that engage the audience
Project Management SoftwareReal unit · OCN London
What you'll be able to do
- Create a project plan, defining its scope, objectives, and deliverables
- Define the tasks, resources, and timelines required for the project
- Enter information about project tasks, including dependencies and constraints
- Edit information about project tasks and resources to reflect changes in the project plan
- Update information about project progress, including task completion and resource utilisation
- Select appropriate tools and techniques to display project status
- Use appropriate tools and techniques to report on project status to stakeholders
Project Management SoftwareReal unit · OCN London
What you'll be able to do
- Create a project plan, defining its scope, objectives, and deliverables
- Enter and edit information about project tasks, including dependencies, durations, and deadlines
- Enter and edit information about project resources, including personnel, equipment, and materials
- Update information about project progress, tracking task completion and resource utilisation
- Select and use appropriate tools and techniques to display and report on project status, such as Gantt charts and progress reports
Project Management SoftwareReal unit · OCN London
What you'll be able to do
- Create a project
- Define a project
- Enter information about project tasks
- Edit information about project tasks
- Enter information about project resources
- Edit information about project resources
- Update information about project progress
- Select appropriate tools to display project status
- Select appropriate techniques to display project status
- Select appropriate tools to report on project status
- Select appropriate techniques to report on project status
- Use appropriate tools to display project status
- Use appropriate techniques to display project status
- Use appropriate tools to report on project status
- Use appropriate techniques to report on project status
Set Up an IT SystemReal unit · OCN London
What you'll be able to do
- Select and safely connect a personal computer with associated hardware components and storage media to meet specific requirements.
- Select and connect an IT system to a communication service, such as the internet or a network, to meet communication needs.
- Install and configure necessary software applications for intended use on the IT system.
- Check that the IT system and communication service are functioning successfully and troubleshoot any issues that arise.
Set Up an IT SystemReal unit · OCN London
What you'll be able to do
- Select a personal computer and associated hardware and storage media safely, ensuring they meet identified needs
- Connect a personal computer safely with associated hardware and storage media to meet identified needs
- Select an IT system and connect it to a communication service successfully, ensuring it meets identified needs
- Install an operating system and application software for use on the IT system
- Configure the operating system and application software for use on the IT system
- Check that the IT system is working successfully
- Check that the communication service is working successfully
Set Up an IT SystemReal unit · OCN London
What you'll be able to do
- Connect up a personal computer safely, following manufacturer's instructions and health and safety guidelines
- Connect up a printer safely, following manufacturer's instructions and health and safety guidelines
- Connect up peripheral devices safely, following manufacturer's instructions and health and safety guidelines
- Connect to an IT communication service, ensuring correct configuration and security settings
- Set up software for use, installing and configuring it according to user requirements
- Check that the IT system is working successfully, verifying all components are functioning correctly
- Check that the communication service is working successfully, ensuring connectivity and data transfer
Specialist SoftwareReal unit · OCN London
What you'll be able to do
- Input information accurately using specialist software
- Combine information effectively using specialist software
- Create appropriate structures within the specialist software to organise information efficiently
- Modify existing structures within the specialist software to organise information efficiently
- Retrieve information efficiently using the specialist software
- Exploit the functions of the specialist software effectively to process information
- Exploit the functions of the specialist software effectively to present information
Specialist SoftwareReal unit · OCN London
What you'll be able to do
- Input, organise and combine information effectively using specialist software applications
- Use appropriate tools and techniques to edit, process, format and present information using specialist software
Specialist SoftwareReal unit · OCN London
What you'll be able to do
- Input information accurately using specialist applications
- Combine information effectively using specialist applications
- Use appropriate structures within the specialist software to organise information efficiently
- Retrieve information efficiently using the specialist software
- Use the functions of the software effectively to process information
- Use the functions of the software effectively to present information
Spreadsheet SoftwareReal unit · OCN London
What you'll be able to do
- Use a spreadsheet to enter numerical and other data accurately and efficiently
- Edit and organise data within a spreadsheet, using appropriate formatting and layout techniques
- Use appropriate formulas to summarise spreadsheet information, performing calculations and generating totals
- Use appropriate tools to display spreadsheet information, creating charts and graphs to visualise data
- Select and use appropriate tools and techniques to present spreadsheet information effectively, tailoring the presentation to the audience and purpose
Spreadsheet SoftwareReal unit · OCN London
What you'll be able to do
- Use a spreadsheet to enter, edit and organise numerical and other data accurately and efficiently.
- Select and use appropriate formulas to perform calculations and data analysis to meet specific requirements.
- Select and use appropriate data analysis tools to interpret and summarise data effectively.
- Select and use appropriate tools and techniques to present spreadsheet information clearly and concisely.
- Select and use appropriate tools and techniques to format spreadsheet information for professional presentation.
Spreadsheet SoftwareReal unit · OCN London
What you'll be able to do
- Use a spreadsheet to enter numerical data accurately and efficiently
- Use a spreadsheet to enter other types of data, such as text and dates
- Use a spreadsheet to edit data, making corrections and updates as needed
- Use a spreadsheet to organise data, using features such as sorting, filtering, and grouping
- Select appropriate formulas to perform calculations on spreadsheet data, such as sums, averages, and percentages
- Use data analysis tools and techniques to meet requirements, such as creating charts and graphs
- Use tools and techniques to present spreadsheet information clearly and effectively, such as formatting cells and adding headings
- Format spreadsheet information to enhance readability and visual appeal
- Publish spreadsheet information in a suitable format, such as a PDF or web page
Using Collaborative TechnologiesReal unit · OCN London
What you'll be able to do
- Stay safe when using collaborative technology
- Stay secure when using collaborative technology
- Set up IT tools and devices for collaborative working
- Access IT tools and devices for collaborative working
- Prepare collaborative technologies for use
- Contribute to tasks using collaborative technologies
Using Collaborative TechnologiesReal unit · OCN London
What you'll be able to do
- Stay safe and secure when working with collaborative technology by adhering to security protocols and best practises.
- Plan and set up IT tools and devices effectively for collaborative working environments.
- Prepare collaborative technologies for use by configuring settings and ensuring compatibility.
- Contribute effectively to tasks using collaborative technologies, demonstrating effective communication and collaboration skills.
Using Collaborative TechnologiesReal unit · OCN London
What you'll be able to do
- Practise safe online behaviour when working with collaborative technology, adhering to security protocols
- Maintain a secure working environment when using collaborative technology, protecting data and systems
- Plan the implementation of IT tools and devices for collaborative working, considering user needs and technical requirements
- Set up IT tools and devices effectively to facilitate collaborative working
- Prepare collaborative technologies for use, ensuring they are configured correctly and ready for participants
- Manage tasks effectively using collaborative technologies, tracking progress and assigning responsibilities
Using EmailReal unit · OCN London
What you'll be able to do
- Use e-mail software tools and techniques to compose and send messages effectively
- Manage incoming email effectively, prioritising and organising messages as required
Using EmailReal unit · OCN London
What you'll be able to do
- Use e-mail software tools and techniques to compose and send messages clearly and professionally
- Manage incoming e-mail effectively, prioritising and organising messages appropriately
Using EmailReal unit · OCN London
What you'll be able to do
- Use e-mail software tools to compose messages, creating clear and concise content
- Use e-mail software tools to send messages, ensuring correct addressing and attachments
- Use e-mail software techniques to compose messages, applying formatting and styling appropriately
- Use e-mail software techniques to send messages, managing delivery options and confirmations
- Manage use of e-mail software effectively, organising inbox and folders for efficient retrieval
- Manage use of e-mail software effectively, applying filters and rules to prioritise messages
Using Mobile IT DevicesReal unit · OCN London
What you'll be able to do
- Set up a mobile device to meet individual needs, configuring settings such as language, time zone, and network connections
- Use applications on a mobile device to perform various tasks, such as communication, information access, and entertainment
- Use files on a mobile device, including creating, editing, and organising documents, images, and other data
- Transfer data to a mobile device from other devices or sources, using methods such as Bluetooth, Wi-Fi, or USB
- Transfer data from a mobile device to other devices or sources, using appropriate methods
- Maintain the performance of a mobile device by managing storage space, updating software, and optimising settings
Using Mobile IT DevicesReal unit · OCN London
What you'll be able to do
- Set up the mobile device to meet individual needs, configuring settings and preferences
- Customise the mobile device to meet individual needs, personalising the interface and functionality
- Select applications on the mobile device, choosing appropriate tools for specific tasks
- Use applications on the mobile device effectively, utilising their features and functions
- Select files on the mobile device, identifying and accessing relevant data
- Use files on the mobile device effectively, opening, editing, and managing them
- Use tools to transfer data to mobile devices, employing appropriate methods for different file types
- Use techniques to transfer data from mobile devices, employing appropriate methods for different file types
- Optimise the performance of mobile devices, managing resources and settings to improve speed and efficiency
Using the InternetReal unit · OCN London
What you'll be able to do
- Connect to the Internet using appropriate hardware and software
- Use browser software to navigate webpages effectively
- Use browser tools to search for information from the Internet
- Use browser software to communicate information online
- Understand the need for safety practices when working online
- Understand the need for security practices when working online
Using the InternetReal unit · OCN London
What you'll be able to do
- Select and set up an appropriate connection to access the Internet, ensuring compatibility and functionality
- Set up and use browser software to navigate webpages, utilising various features and settings
- Use browser tools to search effectively and efficiently for information from the Internet, employing appropriate search terms and techniques
- Use browser software to communicate information online, utilising different communication methods and platforms
- Develop and apply appropriate safety and security practices and procedures when working online, mitigating potential risks and threats
Using the InternetReal unit · OCN London
What you'll be able to do
- Connect to the internet using appropriate hardware and software
- Use browser software to navigate web pages effectively
- Use browser tools to search for information from the internet efficiently
- Use browser software to communicate information online in a professional manner
- Follow and understand the need for safety and security practices when working online to protect personal data and systems
Video SoftwareReal unit · OCN London
What you'll be able to do
- Use video hardware to capture video sequences effectively
- Use video software to capture video sequences effectively
- Use video software tools to combine video sequences into a cohesive whole
- Use video software tools to edit video sequences to improve their quality
- Play video sequences using appropriate hardware and software
- Present video sequences to an audience in a clear and engaging manner
Video SoftwareReal unit · OCN London
What you'll be able to do
- Use video hardware and software to capture video sequences effectively
- Use video software tools and techniques to combine and edit video sequences to a professional standard
- Play and present video sequences effectively, ensuring optimal viewing experience
Video SoftwareReal unit · OCN London
What you'll be able to do
- Use video hardware and software to capture video sequences, ensuring appropriate settings and quality
- Use video software tools and techniques to edit video sequences, including cutting, splicing, and adding transitions
- Play and present video sequences, optimising for different output formats and devices
Website SoftwareReal unit · OCN London
What you'll be able to do
- Plan the structure and content of web pages to meet specific objectives
- Create web pages using appropriate website software tools
- Use website software tools to structure web pages logically and consistently
- Format web pages to enhance readability and visual appeal
- Publish web pages to the Internet or an intranet, ensuring accessibility and functionality
Website SoftwareReal unit · OCN London
What you'll be able to do
- Create structures and styles for websites using appropriate coding languages and design principles
- Use website software tools to prepare content for websites, ensuring accessibility and usability
- Publish websites to a specified server, ensuring functionality and security
Website SoftwareReal unit · OCN London
What you'll be able to do
- Create website structures using appropriate coding languages and frameworks
- Create website styles using CSS or similar styling languages to define the visual appearance of the website
- Use website structures and styles effectively to produce functional and visually appealing websites
- Select appropriate website software tools and features for developing multiple page websites
- Use website software tools and features to develop multiple page websites with multimedia elements such as images, audio, and video
- Use website software tools and features to develop multiple page websites with interactive features such as forms, quizzes, and animations
- Publish multiple page websites to a web server, ensuring accessibility and functionality
- Test multiple page websites thoroughly to identify and resolve any errors or issues with multimedia and interactive features
Word Processing SoftwareReal unit · OCN London
What you'll be able to do
- Enter text and other information accurately into word processing documents, ensuring correct spelling and grammar
- Edit text and other information within word processing documents to improve clarity and conciseness
- Combine text and other information effectively within word processing documents to create a cohesive document
- Structure information logically within word processing documents using headings, subheadings, and other formatting features
- Use word processing software tools to format documents consistently and professionally
- Present documents effectively using word processing software tools, considering factors such as layout, font choice, and visual appeal
Word Processing SoftwareReal unit · OCN London
What you'll be able to do
- Enter text accurately within word processing documents
- Combine text and other information accurately within word processing documents
- Create layouts for word processing documents
- Modify layouts for word processing documents
- Create structures for word processing documents
- Modify structures for word processing documents
- Use word processing software tools to format documents effectively
- Use word processing software tools to present documents effectively to meet requirements
Word Processing SoftwareReal unit · OCN London
What you'll be able to do
- Enter and combine text and other information accurately within word processing documents
- Create and modify appropriate layouts for word processing documents
- Create and modify appropriate structures for word processing documents
- Create and modify appropriate styles for word processing documents
- Use word processing software tools to format documents effectively to meet requirements
- Use word processing software techniques to format documents effectively to meet requirements
- Use word processing software tools to present documents effectively to meet requirements
- Use word processing software techniques to present documents effectively to meet requirements
The honest bit
You’ve started things before
Most courses were built for a room full of people who aren’t you. A cohort moves on whether or not your week allowed it, and by the third week the thing you’re behind on becomes the reason you stop opening it.
There’s no cohort here, and no timetable to fall behind. Before anything starts, Zavmo asks when you’re sharpest and how long you can realistically sit down for, then builds the sessions around those answers. A bad fortnight changes your pace. It doesn’t put you behind.
And you only pay once you start learning. Searching and planning are free, and you can cancel any time — so the cost of finding out is an afternoon, not a year.
Your passport
Every credit is a stamp you keep
Level 3 credits are regulated. They don’t vanish when a subscription ends or a website closes. They travel to any employer, and Zavmo keeps the map of what you’ve earned and what’s next.
Each stamp is a real unit registered against this qualification.
Who’d teach you this

The Evidence Evaluator
Assessor
Helps you show what you can actually do, gathering the evidence that proves it as you learn.
Meet all twelve tutorsWhere this connects
Where these credits take you
A qualification is never a dead end here. See the jobs its credits open, the national occupational standards its units map to, and the future skills they quietly build.
Skills it covers
What the job actually needs. These are the standards the units are built against, in the words employers and awarding bodies already use for the work itself.
How you’ll actually learn this
One-to-one, on your own real work
A qualification is usually something done to you: sit the class, sit the exam, hope it sticks. Here it’s the opposite. You learn it one-to-one with a companion, on your own real work, and you keep going until you can use it, not just recall it.
Applied to your own work
This unit covers the use of audio hardware and software to capture, combine, and edit audio sequences. Learners will develop skills in optimising audio quality and presenting audio sequences effectively using appropriate tools and techniques.
- Remember
- Understand
- Apply
- Analyse
- Evaluate
- Create
Built for OCNLR Level 3 Award in IT User Skills (ITQ)
29 units in this credential, in the order it lists them, awarded by OCN London.
- Audio Software
- Bespoke Software
- Computerised Accounting Software
- Data Management Software
- Database Software
- Design Software
and 23 more in the full unit list below.
One to one, not one to many
No two people run this the same way
A course is written once and handed to everyone. This is assembled around you, and keeps changing as it learns you. Five things it reads, and what each one changes.
- Your actual work Every unit is taught against a live piece of your own work, not a worked example from a textbook.
- What you already know The first conversation finds your starting point, so you skip what you can already do and spend the time on what you cannot.
- The conditions you learn under Not a learning-styles quiz. The evidence does not support those. The dimensions the research does back, read once and used to shape the plan.
- How far you got last time It picks up mid-thought. The tutor knows what you said, what you struggled with, and what it asked you to try.
- Which tutor suits the moment Twelve of them, each for a different kind of thinking. The one who walks you through a first idea is not the one who stress-tests it.
See how you learn, free. Eight questions, no sign-up. A directional taster; the diagnostic inside Zavmo goes deeper and keeps adapting.
Why it sticks
Most courses stop at remembering
There’s a well-known ladder of how deeply you learn something, called Bloom’s Taxonomy. Most courses get you up the first two rungs: you remember some facts, you pass a test, you forget it. Real skill lives at the top. Judging, deciding, creating. And this isn’t a generic ladder: every rung has a named Zavmo tutor who walks you up it.
- 6CreateThe Creative Catalyst
- 5EvaluateThe Evidence Evaluator
- 4AnalyseThe Analyst
- 3ApplyThe Coach
- 2UnderstandThe Connector
- 1RememberThe Builder
Where most courses leave you Where Zavmo takes you
The value
Why the companion is worth £70 a month
You’re not paying for the units. They’re regulated, and the same wherever you earn them. You’re paying for the one thing that decides whether you actually get there: a companion that makes them stick, on your real work.
That is one-to-one on this qualification, every day, on the work you already do, for £70 a month. Your first module is free, so you can see the teaching before you pay for any of it. Billed monthly, cancel any time and billing stops.
Earned on your own work, taught to the top.
Everything you just read, learned one-to-one on the job you already do. Your first module is free, so you can see the teaching before you pay for any of it.
Build my plan, freeNo card. See how this qualification maps onto your role and meet the tutors who’d teach it, free. The learning begins when you subscribe. It’s £70 a month, billed monthly. Cancel any time and billing stops.