Customising Software
Customising software involves modifying applications to better suit user needs, including creating templates, macros, and shortcuts. Learners must understand why customisation is beneficial and be able to apply these techniques in practice.
Assessment criteria
Topic Overview
The Cambridge OCR Level 2 Cambridge Technical Diploma in IT is a vocationally-related qualification designed to equip students with practical IT skills and knowledge for the workplace or further study. It covers a broad range of topics including computer systems, networking, database design, web development, and digital communication. This diploma is equivalent to four GCSEs and provides a solid foundation for careers in IT or progression to Level 3 qualifications.
Students will develop hands-on skills through project-based learning, such as building a computer network, creating a website, or designing a database. The course emphasizes real-world applications, problem-solving, and teamwork. Assessment includes both coursework and external exams, ensuring students can demonstrate both theoretical understanding and practical competence.
This qualification fits into the wider subject of Computer Science by focusing on the application of technology in business and industry. It complements academic study by providing practical experience, making it ideal for students who prefer a more hands-on approach to learning IT.
Key Concepts
Core ideas you must understand for this topic
- →Computer hardware components (CPU, RAM, storage) and their functions in a system.
- →Network topologies (star, mesh, bus) and protocols (TCP/IP, HTTP) for data transmission.
- →Database design principles: tables, relationships, primary keys, and SQL queries.
- →Web development using HTML, CSS, and JavaScript to create interactive websites.
- →Digital communication tools (email, VoIP, social media) and their impact on business.
Learning Objectives
What you need to know and understand
- LO1 Understand why application software is customised, LO2 Be able to customise application software, LO3 Be able to create templates in application software, LO4 Be able to create macros and shortcuts in application software.
- LO1 Understand why application software is customised, LO2 Be able to customise application software, LO3 Be able to create templates in application software, LO4 Be able to create macros and shortcuts in application software.
- LO1 Understand why application software is customised, LO2 Be able to customise application software, LO3 Be able to create templates in application software, LO4 Be able to create macros and shortcuts in application software.
Assessment Criteria
Key criteria assessors look for in your portfolio
- Explains reasons for customising software (e.g., efficiency, consistency).
- Creates and uses templates for documents, spreadsheets, or presentations.
- Records and runs macros to automate repetitive tasks.
- Creates and manages shortcuts (keyboard or toolbar).
- Demonstrates ability to customise user interface settings.
- Explain reasons for customising application software.
- Customise software settings and features.
- Create templates for repeated use.
- Create macros and shortcuts to automate tasks.
- Award credit for demonstrating a clear understanding of how customisation improves productivity and user experience, with reference to real-world scenarios.
- Require evidence of successfully modifying interface elements, toolbars, or preferences in at least one application package.
- Assess the ability to design, create, and apply templates that enforce consistent formatting and content structure across multiple documents.
- Evaluate the effective recording, editing, and assignment of macros and keyboard shortcuts to automate repetitive tasks, with proof of correct operation.
Assessment Guidance
Guidance for achieving higher grades
- 💡Practice step-by-step creation of a macro in a common application like Word or Excel.
- 💡Know the difference between relative and absolute macro recording.
- 💡Be prepared to justify why customisation improves productivity.
- 💡Use relative references in macros for flexibility.
- 💡Document customisations for future reference.
- 💡Test templates with sample data.
- 💡In coursework, clearly document the purpose and benefits of each customisation, linking back to user requirements.
- 💡Provide annotated screenshots as evidence for practical tasks, showing before-and-after states of software customisation.
- 💡When presenting templates, explain design choices such as styles, placeholder text, and protected areas to demonstrate professional awareness.
- 💡For macro tasks, include a written explanation of how the macro improves efficiency and any limitations encountered during testing.
- 💡In coursework, always document your process clearly, including screenshots and explanations of decisions. This shows the examiner your problem-solving approach.
- 💡For exams, practice writing SQL queries by hand. Use the correct syntax and test your logic with sample data to avoid common errors like missing semicolons.
- 💡When answering questions about networks, draw diagrams to illustrate topologies or data flow. This can help you explain concepts more clearly and earn additional marks.
Common Mistakes
Common errors to avoid in your coursework
- Confusing macros with templates or shortcuts.
- Failing to test macros thoroughly, leading to errors.
- Not understanding the security implications of enabling macros.
- Creating macros without testing for errors.
- Over-customising, making software confusing for others.
- Failing to save templates in accessible locations.
- Confusing customisation with creating programs from scratch; learners often fail to recognise that customisation leverages existing software functions.
- Creating templates that are overly complex or contain sample content, leading to confusion during reuse.
- Recording macros without cleaning up redundant steps, resulting in inefficient or error-prone automation.
- Assuming that customisation is a one-off activity, rather than an iterative process that evolves with user needs.
- Misconception: 'RAM is the same as storage.' Correction: RAM is temporary memory for active tasks, while storage (HDD/SSD) holds data permanently.
- Misconception: 'A network is just a bunch of computers connected by cables.' Correction: Networks also include wireless connections, switches, routers, and protocols that manage data flow.
- Misconception: 'HTML is a programming language.' Correction: HTML is a markup language for structuring content; programming involves logic and algorithms.
Frequently Asked Questions
Common questions students ask about this topic
Pass / Merit / Distinction Evidence Checklist
How your portfolio evidence is graded for CAMBRIDGE OCR Customising Software
Every vocational unit is marked against named criteria rather than an exam percentage. Your tutor's brief lists the exact codes for this unit — here is what each band is asking you to do.
Demonstrate baseline knowledge, accurate terminology, and core practical application.
Provide detailed analysis, structured explanations, and clear workplace reasoning.
Deliver thorough evaluation, original problem solving, and fully justified recommendations.
Before You Start
Prior knowledge that will help with this topic
- •Basic understanding of computer operations (e.g., file management, using software applications).
- •Familiarity with internet use and common digital tools (email, web browsers).
- •No prior programming experience is required, but logical thinking skills are beneficial.
Coursework AI Review
Paste your assignment brief and check your draft against its P/M/D criteria
Key Terminology
Essential terms to know
- LO1 Understand why application software is customised, LO2 Be able to customise application software, LO3 Be able to create templates in application software, LO4 Be able to create macros and shortcuts in application software.
- LO1 Understand why application software is customised, LO2 Be able to customise application software, LO3 Be able to create templates in application software, LO4 Be able to create macros and shortcuts in application software.
- LO1 Understand why application software is customised, LO2 Be able to customise application software, LO3 Be able to create templates in application software, LO4 Be able to create macros and shortcuts in application software.
Ready to learn?
AI-powered learning tailored to this unit