Design Software
This element focuses on the practical application of design software to source, import, and combine digital information to produce effective designs. Learners must demonstrate competency in navigating the software interface, using core tools for creation and editing, and applying design principles to meet specified briefs. It underpins workplace tasks such as creating marketing materials, visual reports, and digital content, reinforcing the integration of IT user skills in a professional context.
Assessment criteria
Quick Revision Summary (Key Takeaway)
The OCNLR Level 2 Diploma in IT User Skills (ITQ) is a vocational qualification that develops practical IT proficiency for the workplace. It covers core skills like word processing, spreadsheets, databases, and presentation software, along with essential digital communication and online safety.
Topic Overview
The OCNLR Level 2 Diploma in IT User Skills (ITQ) is designed to equip learners with the practical IT competencies needed in modern workplaces. It covers a broad range of software applications including word processing, spreadsheets, databases, presentation software, and email. The qualification emphasises real-world application, requiring students to produce documents, analyse data, and communicate effectively using digital tools.
This diploma is ideal for those seeking to demonstrate their IT proficiency to employers or progress to further study. It aligns with the National Occupational Standards for IT users, ensuring skills are relevant and transferable. Assessment is portfolio-based, meaning students compile evidence of their work, such as formatted reports, spreadsheets with formulas, and database queries.
Mastering these skills not only boosts employability but also enhances everyday digital literacy. Students learn to organise information, solve problems using technology, and collaborate online safely. The qualification is flexible, allowing learners to focus on areas most relevant to their career goals, such as advanced spreadsheet functions or desktop publishing.
Key Concepts
Core ideas you must understand for this topic
- →File management: organising, saving, and retrieving files in appropriate formats.
- →Spreadsheet formulas and functions: using SUM, AVERAGE, IF, and VLOOKUP.
- →Database queries: creating queries to filter and sort records using criteria.
- →Mail merge: combining a data source with a template to produce personalised documents.
- →Online safety: understanding phishing, strong passwords, and data protection.
Learning Objectives
What you need to know and understand
- Obtain, insert and combine information for designs, Use design software tools to create, manipulate and edit designs
- Obtain, insert and combine information for designs, Use design software tools to create, manipulate and edit designs
- Obtain, insert and combine information for designs, Use design software tools to create, manipulate and edit designs
- Evaluate appropriate information sources for a given design brief
- Apply design software tools to create original graphics
- Demonstrate techniques for combining and layering imported information
- Analyse the effectiveness of design edits made using software manipulation tools
- Obtain, insert and combine information for designs, Use design software tools to create, manipulate and edit designs
- Obtain, insert and combine information for designs, Use design software tools to create, manipulate and edit designs
Assessment Criteria
Key criteria assessors look for in your portfolio
- Award credit for demonstrating the ability to obtain information from multiple sources (e.g., importing images, text, or data from files, web, or other applications) and appropriately inserting them into a design canvas.
- Award credit for effective combination and arrangement of design elements using layers, grouping, alignment tools, and consistent formatting to create a coherent layout that meets the design brief.
- Award credit for manipulating and editing design components using software tools such as cropping, resizing, colour adjustment, text formatting, and applying effects, with evidence of iterative refinement based on testing or feedback.
- Award credit for demonstrating the ability to obtain relevant information (text, images, data) from specified sources.
- Award credit for correctly inserting and combining information into a design layout using appropriate software functions.
- Assess learner's proficiency in using tools to create original design elements (e.g., shapes, text boxes).
- Assess ability to manipulate existing elements (resize, reposition, format) to meet design requirements.
- Evaluate the use of editing techniques to refine designs, such as adjusting colours, fonts, alignment, and applying consistency.
- Award credit for demonstrating the ability to import and integrate at least two distinct media types (e.g., graphic and text) into a single design composition.
- Look for evidence of using fundamental editing tools—such as crop, resize, rotate, and text formatting—to modify design elements accurately.
- Assess appropriate use of layer management to organise elements and achieve the intended visual hierarchy without overlapping errors.
- Award credit for demonstrating effective use of selection and insertion techniques for importing external data
- Credit evidence of using multiple tools (e.g., layers, masks) to combine design elements
- Marks for justifying design decisions when editing and refining final product
- Credit for maintaining version control and saving in appropriate formats
- Award credit for demonstrating the ability to insert and format text boxes with appropriate font choices, sizing, and alignment.
- Evidence of using shape tools to create and customize vector elements (e.g., changing fill colour, stroke weight, and applying gradients).
- Demonstrating the combination of multiple elements from different sources into a single cohesive design, such as importing an image and adding overlaying text with appropriate opacity.
- Applying manipulation tools such as resize, rotate, and crop effectively without distorting key content or compromising aspect ratio.
- Using basic editing techniques like colour adjustment, applying preset styles, or adding simple drop shadows to enhance visual impact.
- Award credit for demonstrating the ability to obtain relevant visual assets (e.g., images, icons) from appropriate sources such as stock libraries or personal files.
- Assess that the learner can accurately insert and position text and graphics within a design canvas using alignment and spacing tools.
- Look for use of fundamental editing techniques: cropping, resizing, rotating, and adjusting colour or text formatting to suit the design purpose.
- Credit the production of a final design that combines multiple elements into a coherent layout, matching a given brief or scenario with basic consistency.
Assessment Guidance
Guidance for achieving higher grades
- 💡Always review the design brief thoroughly before starting, and plan the layout and required elements; annotate your planning to show the assessor your decision-making process.
- 💡Take screenshots or record a time-lapse of your workflow to provide evidence of tool usage, editing decisions, and problem-solving, which strengthens your portfolio for assessment criteria.
- 💡Proof your final design against the original specifications, checking for accuracy of information, alignment, spelling, and technical requirements (resolution, file type) before submission.
- 💡For portfolio-based assessment, carefully document the purpose and audience for each design before starting.
- 💡Use screenshots or annotations to evidence the use of specific software tools and techniques.
- 💡Follow the design brief exactly, showing how you’ve met each point in your final product.
- 💡Check your designs thoroughly for spelling, grammar, and alignment errors before submission.
- 💡Capture screenshots or maintain iterative saves to evidence your workflow, as process documentation is often a key assessment criterion.
- 💡Verify the licensing of all sourced images and fonts to avoid inadvertent copyright infringement, which can invalidate your work.
- 💡Always justify design choices with reference to the brief and target audience
- 💡Demonstrate a range of tools and techniques rather than relying on a single feature
- 💡Provide evidence of iterative editing with before/after comparisons
- 💡When compiling your portfolio, clearly annotate screenshots to explain the tools and techniques you used, demonstrating your understanding to the assessor.
- 💡Plan your design on paper first to ensure it meets the brief and target audience needs before starting work in the software.
- 💡Use the align and distribute features of the design software to ensure a professional layout, as this is a key marking point.
- 💡Always save your work in both the native file format (for future editing) and an appropriate output format (e.g., PDF or PNG) to show evidence of final design.
- 💡Keep a log of any assets you obtain from external sources, demonstrating compliance with copyright and appropriate use.
- 💡Always start by sketching a rough layout on paper to plan where text and images will go before using software.
- 💡Use alignment tools (grids, guides, snap) to ensure elements are evenly spaced and neatly arranged.
- 💡Zoom in and proofread all text for spelling and grammar errors before final submission.
- 💡Export or save the design in the specified format (e.g., PDF, JPEG) and check file properties to ensure quality standards.
- 💡Always label your evidence clearly – assessors need to see what you have done. Use annotations or callouts to explain key features.
- 💡When creating spreadsheets, test your formulas with sample data to ensure they work correctly. A simple error like a missing bracket can lose marks.
- 💡In presentations, use consistent slide layouts and themes. Avoid clutter – less is often more for effective communication.
Common Mistakes
Common errors to avoid in your coursework
- Learners often overlook copyright and permissions, using images or content without proper attribution or licensing, rendering their work non-compliant for assessment.
- A frequent error is inconsistent use of design elements, such as mismatched fonts, poor colour contrast, or misaligned objects, which detracts from professional presentation.
- Students sometimes fail to save work in appropriate formats or versions, leading to file corruption, loss of editability, or inability to export for required outputs (e.g., print vs. web).
- Using low-resolution images that pixelate when printed or scaled.
- Ignoring copyright and licensing when obtaining online content.
- Overcrowding the design with too much information or inconsistent formatting.
- Failing to save work in appropriate file formats for different purposes (e.g., editable vs. final output).
- Not utilising alignment and distribution tools, leading to unprofessional-looking layouts.
- Neglecting to check image resolution before insertion, resulting in blurry or pixelated outputs when scaled or printed.
- Ignoring the design brief’s specifications, such as exact dimensions, colour codes, or margin requirements, leading to non-compliant submissions.
- Overlooking the resolution of inserted images leading to poor print quality
- Using excessive filters without considering overall design cohesion
- Failing to save work in appropriate formats for different outputs
- Overlooking the importance of resolution and image format when importing graphics, leading to pixelation or inappropriate file types (e.g., using low-resolution web images for print).
- Applying excessive or inconsistent design elements (fonts, colours, effects) resulting in a cluttered and unprofessional design.
- Failure to align or distribute elements evenly, leading to a visually unbalanced layout that undermines professional output.
- Not naming or organising layers, causing difficulty in later editing and revision, and making it hard for assessors to verify the design process.
- Using design tools without understanding the difference between vector and raster elements, leading to loss of quality when scaling or resizing.
- Using low-resolution images that become pixelated when printed or displayed at larger sizes.
- Ignoring alignment and spacing, resulting in cluttered or unprofessional-looking designs.
- Applying too many different fonts, colours, or effects, which distracts from the message.
- Failing to check the design against the original brief, leading to missing key information or inappropriate tone.
- Misconception: 'A database is the same as a spreadsheet.' Correction: Databases store structured data in tables with relationships, while spreadsheets are for calculation and analysis.
- Misconception: 'Formatting text in bold makes it more important for accessibility.' Correction: Use heading styles for structure; bold alone does not convey hierarchy to screen readers.
- Misconception: 'Once you delete a file from the Recycle Bin, it's gone forever.' Correction: Deleted files can often be recovered with specialist software until overwritten.
Revision Plan
How to revise this topic in 1–2 weeks
- 1Week 1: Focus on word processing and presentation software. Create a report and a slide deck, ensuring correct formatting and use of templates.
- 2Week 2: Move to spreadsheets and databases. Practice formulas, functions, and creating queries. Build a small database with at least two related tables.
- 3Week 3: Consolidate by completing a mock portfolio task that combines skills (e.g., produce a mail-merged letter using a spreadsheet data source).
- 4Week 4: Review online safety and file management. Ensure all evidence is organised and backed up. Practice past paper questions or sample tasks.
Exam Question Types
How this topic typically appears in the exam
- 📋Portfolio tasks: You will be asked to produce a document (e.g., a newsletter, spreadsheet model, or database report). Ensure you follow the brief exactly and include required features.
- 📋Short answer questions: These test knowledge of terms and concepts (e.g., 'What is a primary key?'). Be precise and use correct terminology.
- 📋Practical demonstrations: You may need to show your assessor how to perform a task (e.g., creating a pivot table). Practice explaining your steps clearly.
Command Word Expectations (OCN LONDON)
What examiners look for when using specific command words in this specification
Give a detailed account of a topic, including key features and characteristics. For example, 'Describe the steps to create a mail merge.'
Provide reasons or causes, showing how or why something works. For example, 'Explain why validation rules are important in a database.'
Show how to perform a task, often by actually doing it or providing a step-by-step account. For example, 'Demonstrate how to apply conditional formatting in a spreadsheet.'
How Students Lose Marks (Examiner Pitfalls)
Common mark loss traps and how to write 100% full-mark answers
Step-by-Step Worked Solutions
Detailed solution breakdown for typical exam problems
Question: A spreadsheet contains sales data for January to June. Use a formula to calculate the total sales for the first quarter (Jan-Mar) if the data is in cells B2, B3, and B4.
- 1.Step 1: Identify the cells containing the data: B2, B3, B4.
- 2.Step 2: Use the SUM function: =SUM(B2:B4).
- 3.Step 3: Press Enter to display the total.
Question: Explain two ways to ensure data accuracy when entering records into a database.
- 1.Step 1: Use validation rules to restrict data entry (e.g., only allow numbers in a 'Price' field).
- 2.Step 2: Use input masks to format data consistently (e.g., a date mask DD/MM/YYYY).
- 3.Step 3: Both methods reduce errors and maintain data integrity.
Active Recall Memory Test
Test your memory before revealing the key facts
Frequently Asked Questions
Common questions students ask about this topic
Pass / Merit / Distinction Evidence Checklist
How your portfolio evidence is graded for OCN LONDON Design 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 computer literacy: ability to use a mouse, keyboard, and open/close applications.
- •Understanding of file types (e.g., .docx, .xlsx, .pdf) and how to save work.
- •Familiarity with the internet and web browsing.
Coursework AI Review
Paste your assignment brief and check your draft against its P/M/D criteria
Key Terminology
Essential terms to know
- Obtain, insert and combine information for designs, Use design software tools to create, manipulate and edit designs
- Obtain, insert and combine information for designs, Use design software tools to create, manipulate and edit designs
- Obtain, insert and combine information for designs, Use design software tools to create, manipulate and edit designs
- Information gathering and insertion
- Combining design elements
- Software tool proficiency
- Image manipulation and editing
- Design refinement and output
- Obtain, insert and combine information for designs, Use design software tools to create, manipulate and edit designs
- Obtain, insert and combine information for designs, Use design software tools to create, manipulate and edit designs
Ready to learn?
AI-powered learning tailored to this unit