What is the difference between a spreadsheet and a database?

A spreadsheet (like Excel) is best for calculations, data analysis, and small datasets. It uses cells organised in rows and columns. A database (like Access) is designed for storing, querying, and managing large amounts of related data. Databases use tables, queries, forms, and reports, and they allow for complex relationships between data. For this diploma, you'll learn both but use them for different purposes.

How do I create a mail merge in Word?

First, prepare your data source (e.g., an Excel spreadsheet with names and addresses). In Word, go to the 'Mailings' tab, click 'Start Mail Merge,' and choose your document type (e.g., letters). Then select 'Select Recipients' and choose your data source. Insert merge fields (e.g., >) where needed, then click 'Finish & Merge' to produce personalised documents. Remember to save the merged document separately.

What is conditional formatting and how do I use it?

Conditional formatting in Excel automatically applies formatting (like colours or icons) to cells that meet certain criteria. For example, you can highlight all cells with values above 100 in green. To use it, select your data, go to the 'Home' tab, click 'Conditional Formatting,' and choose a rule (e.g., 'Highlight Cell Rules' > 'Greater Than'). This helps you quickly spot trends or outliers in your data.

How can I make my presentations more professional?

Use a consistent theme or template throughout. Avoid too many animations or transitions—they can be distracting. Use high-quality images and ensure text is readable (e.g., high contrast between text and background). Include a clear structure: title slide, agenda, main content, summary, and Q&A. Practice your delivery and check for spelling errors. Also, consider accessibility: add alt text to images and use large fonts.

What are the key online safety rules I need to know?

Always use strong, unique passwords for each account. Be cautious of phishing emails—never click on suspicious links or download attachments from unknown senders. Ensure websites use HTTPS (look for the padlock icon). Respect copyright: only use images or text you have permission to use, and cite sources. Finally, adjust privacy settings on social media to control who sees your information.

How do I create a query in a database?

In Microsoft Access, go to the 'Create' tab and click 'Query Design.' Add the tables you need and close the dialog. Drag fields from the tables into the query grid. To filter results, enter criteria in the 'Criteria' row (e.g., >100 for numbers, 'London' for text). Run the query by clicking 'Run' (red exclamation mark). You can also use the Query Wizard for simpler queries. Save your query for later use.

Desktop Publishing Software

OPEN AWARDS

vocational

This element focuses on the practical application of desktop publishing software to create professional publications. Learners will develop skills in selecting suitable designs, integrating text and multimedia elements, and applying editing and formatting techniques to produce effective documents for print or digital distribution.

Learning Outcomes

Assessment Guidance

Key Skills

Key Terms

Assessment Criteria

Assessment criteria

Open Awards Level 2 Diploma in IT User Skills (RQF)

Topic Overview

The Open Awards Level 2 Diploma in IT User Skills (RQF) is a comprehensive qualification designed to equip students with the practical IT skills needed for the modern workplace. It covers a wide range of topics, including word processing, spreadsheets, databases, presentation software, and using the internet safely and effectively. This diploma is ideal for those looking to improve their digital literacy for employment or further study, as it aligns with the UK's National Occupational Standards for IT users.

Throughout the course, you will develop hands-on skills in creating, editing, and formatting documents, managing data using spreadsheets and databases, and delivering professional presentations. The qualification also emphasises the importance of staying safe online, understanding copyright and data protection, and using communication tools appropriately. By the end of the diploma, you will be confident in using a variety of software applications to solve real-world problems and communicate information effectively.

This diploma fits into the wider subject of Digital Skills and IT by providing a solid foundation for more advanced qualifications, such as the Level 3 Diploma in IT User Skills or specialised certifications in areas like digital marketing or data analysis. It is recognised by employers and educational institutions across the UK, making it a valuable addition to your CV and a stepping stone to further career opportunities.

Key Concepts

Core ideas you must understand for this topic

→File management: organising, saving, and retrieving files in appropriate formats and locations.
→Data validation and formatting: using tools like conditional formatting, data validation rules, and cell styles to ensure accuracy and consistency.
→Mail merge: combining a data source (e.g., Excel spreadsheet) with a template (e.g., Word document) to produce personalised letters, emails, or labels.
→Database queries: using filters, sorts, and structured query language (SQL) to extract specific information from a database.
→Presentation design principles: applying consistent themes, using appropriate animations/transitions, and ensuring accessibility for diverse audiences.

Learning Objectives

What you need to know and understand

1. Select and use appropriate designs and page layouts for publications2. Input and combine text and other information within publications3. Use desktop publishing software techniques to edit and format publications

Assessment Criteria

Key criteria assessors look for in your portfolio

Award credit for selecting a design template or layout that clearly aligns with the publication's stated purpose and target audience, justifying choices where required.
Credit for demonstrating accurate import and placement of text, images, and other media, ensuring seamless integration without distortion or loss of quality.
Look for consistent use of formatting tools (e.g., font styles, paragraph spacing, margins, columns, guides) to improve readability and professional appearance.
Evidence of using advanced techniques such as master pages, text wrapping, object grouping, and style sheets to maintain uniformity across multi-page documents.

Assessment Guidance

Guidance for achieving higher grades

💡Always start by analysing the brief to identify the publication type, target audience, and key message—plan a rough sketch before opening the software.
💡Use master pages and style sheets to ensure consistency and save time; this also demonstrates higher-level competency to assessors.
💡Keep designs clean and functional: limit fonts, use a cohesive colour palette, and ensure text remains legible against backgrounds.
💡For assessment evidence, provide screenshots or annotations showing the use of specific tools and explain how they meet the given requirements.
💡Always read the task instructions carefully. Many students lose marks by missing specific requirements, such as 'use a formula to calculate the total' or 'apply a consistent theme to all slides.' Highlight key words in the question.
💡Save your work regularly and in the correct file format (e.g., .docx, .xlsx, .pptx). Examiners may deduct marks if you submit files in an incompatible format or lose work due to a crash.
💡When creating databases, ensure your tables are normalised (no duplicate data) and relationships are correctly defined. This is a common area where students lose marks for poor design.

Common Mistakes

Common errors to avoid in your coursework

Treating desktop publishing software like a word processor, leading to poor layout control and lack of design structure.
Neglecting to consider audience and purpose, resulting in inappropriate font choices, colour schemes, or excessive decorative elements.
Inconsistent alignment, spacing, and use of white space, which makes publications look unprofessional.
Failing to check final output in print preview or export, leading to errors such as cut-off text, missing images, or incorrect page sizes.
Misconception: 'I can just use the default settings for all my documents.' Correction: Employers expect you to customise formatting (e.g., margins, fonts, headers) to meet specific requirements. Always check the brief and adjust settings accordingly.
Misconception: 'Spreadsheets are just for calculations.' Correction: Spreadsheets are also powerful tools for data analysis, visualisation (charts), and decision-making. Learn to use functions like VLOOKUP, IF, and PivotTables to extract insights.
Misconception: 'Online safety is just about not sharing passwords.' Correction: It also involves recognising phishing emails, using secure connections (HTTPS), understanding privacy settings, and respecting copyright laws when using images or text from the internet.

Frequently Asked Questions

Common questions students ask about this topic

Before You Start

Prior knowledge that will help with this topic

•Basic computer literacy: ability to use a mouse, keyboard, and navigate the operating system (e.g., Windows or macOS).
•Familiarity with common software applications like Microsoft Word, Excel, and PowerPoint at a beginner level.
•Understanding of file types (e.g., .pdf, .jpg) and how to save/retrieve files from different locations (e.g., local drive, cloud storage).

Key Terminology

Essential terms to know

1. Select and use appropriate designs and page layouts for publications2. Input and combine text and other information within publications3. Use desktop publishing software techniques to edit and format publications

Ready to learn?

AI-powered learning tailored to this unit

Desktop Publishing Software

Assessment criteria

Topic Overview

Key Concepts

Learning Objectives

Assessment Criteria

Assessment Guidance

Common Mistakes

Frequently Asked Questions

Before You Start

Key Terminology

Ready to learn?

Related Topics in OPEN AWARDS vocational Digital Skills & IT

Audio Software

Bespoke Software

Computerised Accounting Software

Data Management Software

Topic Synopsis

Key Concepts & Core Principles

Exam Tips & Revision Strategies

Common Misconceptions & Mistakes to Avoid

Examiner Marking Points

Desktop Publishing Software

Assessment criteria

Topic Overview

Key Concepts

Learning Objectives

Assessment Criteria

Assessment Guidance

Common Mistakes

Frequently Asked Questions

What is the difference between a spreadsheet and a database?

How do I create a mail merge in Word?

What is conditional formatting and how do I use it?

How can I make my presentations more professional?

What are the key online safety rules I need to know?

How do I create a query in a database?

Before You Start

Key Terminology

Ready to learn?

Related Topics in OPEN AWARDS vocational Digital Skills & IT

Audio Software

Bespoke Software

Computerised Accounting Software

Data Management Software