Skip to topic
    ← Back to course topics

    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

    1. 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
    1. 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.
    2. 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.
    3. 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.
    4. 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)
    Describe

    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.'

    Explain

    Give reasons or causes, showing understanding of why something happens. For example, 'Explain why using absolute cell references is important in spreadsheets.'

    Demonstrate

    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)
    Pitfall: Students often confuse the purpose of different software applications, e.g., using a spreadsheet for a task that requires a word processor, or vice versa.
    ❌ Weak Answer (Loses Marks):I would use Excel to write a letter because it has good formatting tools.
    Example improved answer:For writing a formal letter, I would use a word processor like Microsoft Word because it is designed for text-based documents, offering features like spell check, mail merge, and flexible page layout. Excel is for numerical data and calculations, so it would be inappropriate for a letter.
    Examiner Tip: Always match the software to the task: word processors for text, spreadsheets for calculations, databases for structured data, and presentation software for visual slides.
    Pitfall: In spreadsheet tasks, students often forget to use absolute cell references when copying formulas, leading to incorrect results.
    ❌ Weak Answer (Loses Marks):I copied the formula =B2*C2 down the column, but the results were wrong.
    Example improved answer:When copying a formula that should always refer to a specific cell (e.g., a tax rate in cell $B$1), I must use an absolute reference like =$B$1*C2. This locks the reference to B1 so it doesn't change when copied, ensuring correct calculations.
    Examiner Tip: Remember the dollar sign: $A$1 locks both column and row, $A1 locks column only, A$1 locks row only. Practice copying formulas with different reference types.
    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. 1.Step 1: Identify the range of cells to sum: B2 to B10.
    2. 2.Step 2: Use the SUM function: =SUM(B2:B10) in cell B11.
    3. 3.Step 3: To display as currency, select cell B11, go to Format Cells, choose Currency, and select £ (GBP) with 2 decimal places.
    Final Answer: Use =SUM(B2:B10) and format the cell as currency with the £ symbol.

    Question: Explain the difference between 'Save' and 'Save As' in a word processing application, and give a scenario where you would use each.

    1. 1.Step 1: Define 'Save': updates the current file with changes, keeping the same filename and location.
    2. 2.Step 2: Define 'Save As': creates a new file with a new name or location, leaving the original unchanged.
    3. 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.
    Final Answer: Save updates the existing file; Save As creates a new file. Use Save for quick updates, Save As for making copies or changing file format.
    Active Recall Memory Test
    What is the keyboard shortcut for 'Save As' in most Microsoft Office applications?
    Key Fact: F12 (or Ctrl+Shift+S in some applications).
    Name three functions you can use in a spreadsheet and what they do.
    Key Fact: SUM adds numbers, AVERAGE calculates the mean, IF performs a logical test and returns different values based on the result.
    What is the purpose of a primary key in a database table?
    Key Fact: It uniquely identifies each record in the table, ensuring no duplicates and enabling efficient data retrieval.
    List three ways to protect your personal data online.
    Key Fact: Use strong, unique passwords; enable two-factor authentication; be cautious about sharing information on social media.
    Frequently Asked Questions
    How long does it take to complete the OCNLR Level 2 Award in IT User Skills?
    The qualification typically takes around 60-90 guided learning hours, which can be completed over a few months depending on your pace. Many learners finish it in one academic year, but it's flexible and can be done faster if you have prior experience.
    Do I need to pass an exam to get this qualification?
    No, there is no written exam. The qualification is assessed through a portfolio of evidence, which you build by completing practical tasks and providing screenshots or recordings of your work. Your assessor will review your portfolio to ensure you meet the required standards.
    What jobs can I get with an ITQ Level 2?
    This qualification is valuable for many entry-level roles that require basic IT skills, such as administrative assistant, data entry clerk, customer service representative, or IT support technician. It also provides a foundation for further study in IT, such as a Level 3 qualification or an apprenticeship.
    Is the ITQ Level 2 equivalent to a GCSE?
    Yes, the Level 2 Award is roughly equivalent to a GCSE grade 4 or above (C in the old grading system). It is a recognised qualification that demonstrates your IT competence to employers and educational institutions.
    Can I study this qualification online?
    Yes, many colleges and training providers offer this qualification online, allowing you to study at your own pace. You will need access to a computer with the required software (e.g., Microsoft Office) and an internet connection to submit your portfolio.
    What software do I need to learn for this qualification?
    You will typically use Microsoft Office applications like Word, Excel, Access, and PowerPoint, but the skills are transferable to other software like Google Docs, Sheets, and Slides. Check with your provider for specific requirements, but most use Microsoft Office.
    Unit assessment details

    Loading assessment details…