Bespoke Software — OCN London Vocational Digital Skills & IT
The OCNLR Level 2 Award in IT User Skills (ITQ) is a vocational qualification that assesses practical competence in using digital tools for everyday tasks, such as word processing, spreadsheets, databases, and online safety. It is designed to prepare learners for the workplace by focusing on real-world IT applications and productivity skills.
Bespoke Software explained
This element focuses on using bespoke software applications—typically custom-designed or industry-specific tools—to efficiently input, combine, and manage information.
Read the full explanation
Learners must demonstrate competence in structuring data for optimal retrieval and exploiting advanced software functions to process and present outputs that meet specific vocational requirements.
Learning outcomes
- Input and combine information using bespoke software, Create and modify appropriate structures to organise and retrieve information efficiently, Exploit the functions of the software effectively to process and present information
Which command word is this?
Give a detailed account of a process or feature, including steps or characteristics. For example, 'Describe how to set up a mail merge in Word.'
Bespoke Software assessment help
Topic Overview
The OCNLR Level 2 Award in IT User Skills (ITQ) is a practical qualification that equips learners with essential digital skills for the modern workplace. It covers a range of IT applications, including word processing, spreadsheets, databases, presentations, and using the internet safely and effectively. The qualification is assessed through portfolio-based evidence, meaning students must demonstrate their competence by completing real-world tasks, rather than sitting a traditional written exam.
This qualification is important because it provides a recognised certification of IT proficiency, which is highly valued by employers across all sectors. It also serves as a stepping stone for further study in IT or related fields. The focus on practical skills ensures that learners are not just memorising theory but can actually apply their knowledge to solve problems and increase productivity.
Within the broader subject of Digital Skills & IT, this award sits at Level 2, which is equivalent to a GCSE grade 4 or above. It builds on basic digital literacy and prepares students for more advanced qualifications, such as the Level 3 IT Diploma. The skills learned are transferable and applicable to any career path, making it a versatile and valuable qualification.
Key Concepts
- →File management: organising, saving, and retrieving files in different formats (e.g., .docx, .xlsx, .pdf).
- →Word processing: creating, editing, and formatting text documents, including using styles, tables, and mail merge.
- →Spreadsheets: using formulas, functions (SUM, AVERAGE, IF), and charts to analyse data.
- →Databases: understanding tables, records, fields, and queries to manage structured information.
- →Online safety: protecting personal data, recognising phishing, and using secure passwords.
Assessment Criteria
- Award credit for demonstrating accurate data input and combination from multiple sources or formats within the bespoke system.
- Award credit for creating and modifying logical structures (e.g., folders, tags, categories, custom fields) that enable swift and accurate information retrieval.
- Award credit for effectively using software functions such as filtering, sorting, reporting, or automation to process and present information in a required format.
Assessment Guidance
- 💡Always cross-reference evidence against the assignment brief: show screenshots or logs of the exact bespoke software features used for input, combination, structuring, and presentation.
- 💡Practice navigating the software's help documentation or user guides—assessors look for independent problem-solving when exploiting advanced functions.
- 💡When presenting information, clearly annotate how the software's functions were applied to achieve the final output, linking back to the original data sources.
- 💡Always read the task brief carefully and note the exact requirements, such as file format, naming conventions, and specific features to include (e.g., 'use a formula to calculate the total').
- 💡When demonstrating skills, use screenshots or screen recordings to provide evidence of your work, but ensure they are clear and annotated to show the steps you took.
- 💡Practice using keyboard shortcuts (e.g., Ctrl+C, Ctrl+V, Ctrl+Z) as they save time and show proficiency in the assessment.
Common Mistakes
- Using generic software terms or functions instead of the specific features available in the bespoke application being assessed.
- Failing to validate combined data, leading to duplication or inconsistencies that hinder retrieval and processing.
- Overlooking the software's built-in templates, macros, or shortcuts, resulting in inefficient work practices and incomplete exploitation of functions.
- Misconception: 'Spreadsheets are just for calculations, not for storing data.' Correction: Spreadsheets can also store and organise data, but databases are more efficient for large datasets with relationships.
- Misconception: 'The internet is always safe if I use a secure website.' Correction: Even secure websites can be compromised; always be cautious about sharing personal information and use two-factor authentication.
- Misconception: 'Backing up means copying files to a USB stick once.' Correction: Backups should be regular and stored in multiple locations (e.g., cloud and external drive) to prevent data loss.
Revision Plan
- 1Week 1: Focus on word processing and file management. Practice creating documents, formatting text, inserting images, and using mail merge. Complete at least two practice tasks.
- 2Week 2: Move to spreadsheets and databases. Learn key formulas, create charts, and build a simple database with queries. Practice using absolute references and sorting data.
- 3Week 3: Cover presentations and online safety. Create a presentation with animations and transitions, and research online safety topics. Review all topics and attempt past papers or mock tasks.
- 4Week 4: Consolidate by completing full practice assessments under timed conditions. Identify weak areas and revisit them. Ensure you have evidence for your portfolio.
Exam Question Types
- 📋Practical tasks: You will be given a scenario and asked to produce a document, spreadsheet, or presentation. Advice: Read the brief carefully, plan your approach, and save your work in the correct format.
- 📋Multiple-choice questions: These test knowledge of concepts like file extensions, software functions, and safety. Advice: Eliminate obviously wrong answers and think about the purpose of each tool.
- 📋Short-answer questions: You may be asked to explain a process or define a term. Advice: Use correct terminology and give examples where possible.
- 📋Portfolio evidence: You will need to submit screenshots or recordings of your work. Advice: Label each piece of evidence clearly and explain what it demonstrates.
Command Word Expectations (OCN LONDON)
Give a detailed account of a process or feature, including steps or characteristics. For example, 'Describe how to set up a mail merge in Word.'
Give reasons or causes, showing understanding of why something happens. For example, 'Explain why using absolute cell references is important in spreadsheets.'
Show how to do something, often by performing the task or providing evidence. For example, 'Demonstrate how to create a chart from data in Excel.'
How Students Lose Marks (Examiner Pitfalls)
Step-by-Step Worked Solutions
Question: A student is creating a spreadsheet to track monthly expenses. They have a list of amounts in column B (B2:B10) and want to calculate the total in cell B11. Write the formula they should use and explain how to make it show the result as currency.
- 1.Step 1: Identify the range of cells to sum: B2 to B10.
- 2.Step 2: Use the SUM function: =SUM(B2:B10) in cell B11.
- 3.Step 3: To display as currency, select cell B11, go to Format Cells, choose Currency, and select £ (GBP) with 2 decimal places.
Question: Explain the difference between 'Save' and 'Save As' in a word processing application, and give a scenario where you would use each.
- 1.Step 1: Define 'Save': updates the current file with changes, keeping the same filename and location.
- 2.Step 2: Define 'Save As': creates a new file with a new name or location, leaving the original unchanged.
- 3.Step 3: Scenario: Use 'Save' when editing an existing document and you want to keep the same version. Use 'Save As' when you want to create a copy, e.g., to create a template or a different version.
Active Recall Memory Test
What is the keyboard shortcut for 'Save As' in most Microsoft Office applications?
Name three functions you can use in a spreadsheet and what they do.
What is the purpose of a primary key in a database table?
List three ways to protect your personal data online.
Frequently Asked Questions
How long does it take to complete the OCNLR Level 2 Award in IT User Skills?
Do I need to pass an exam to get this qualification?
What jobs can I get with an ITQ Level 2?
Is the ITQ Level 2 equivalent to a GCSE?
Can I study this qualification online?
What software do I need to learn for this qualification?
Unit assessment details
Loading assessment details…