Spreadsheet software — WJEC Vocational Digital Skills & IT

The WJEC Level 1 Award for IT Users (ITQ) is a vocationally-related qualification that develops essential digital skills for the modern workplace. It covers core IT competencies such as word processing, spreadsheets, databases, and safe internet use, preparing students for further study or employment.

The WJEC Level 1 Award for IT Users (ITQ) is a vocational qualification that equips students with practical digital skills needed in the modern workplace. It is designed for learners who want to demonstrate their competence in using IT applications such as word processing, spreadsheets, databases, and presentation software. The qualification is assessed through a portfolio of evidence, which allows students to showcase their skills in real-world contexts.

This qualification is important because it provides a solid foundation for further study in IT or for entering the workforce. It covers essential topics like health and safety when using computers, file management, and online safety, which are critical for any job role. By completing this award, students gain confidence in using technology effectively and efficiently, making them more employable.

The ITQ award is part of the wider digital skills curriculum, which aims to develop digital literacy for all. It is a stepping stone to higher-level IT qualifications, such as the Level 2 Certificate in IT User Skills. The skills learned are transferable across all subjects and careers, making it a valuable addition to any student's education.

• →Health and Safety: Understanding the correct posture, screen positioning, and taking breaks to avoid repetitive strain injury (RSI).
• →File Management: Organising files into folders, using appropriate file names, and understanding file extensions (e.g., .docx, .xlsx).
• →Word Processing: Creating, editing, and formatting documents, including using styles, bullet points, and inserting images.
• →Spreadsheets: Using cells, rows, columns, and formulas (e.g., SUM, AVERAGE) to analyse data and create charts.
• →Online Safety: Recognising phishing emails, using strong passwords, and protecting personal information online.

• Award credit for demonstrating accurate data entry with correct cell references and consistent formatting.
• Credit for selecting and applying appropriate formula (e.g., SUM, AVERAGE) to summarise data accurately.
• Credit for using formatting tools (borders, alignment, number formats) to enhance readability and professional appearance.
• Award credit for creating a chart that accurately represents the data with suitable labels, legends and title.
• Credit for showing an understanding of relative versus absolute cell references when copying formulas.

• 💡Always double-check cell references before copying formulas to avoid propagation of errors.
• 💡When presenting data, ensure charts have clear titles, axis labels, and legends to meet assessment criteria for interpretation.
• 💡Use cell formatting to distinguish headers from data, and apply consistent number formats (e.g., currency, decimal places) to enhance clarity.
• 💡Always read the question carefully and identify the command word (e.g., 'describe', 'explain', 'evaluate') to know how much detail is needed.
• 💡Use technical vocabulary correctly – for example, say 'cell' instead of 'box' in spreadsheets, and 'field' instead of 'column' in databases.
• 💡In practical tasks, save your work regularly and check the file format required (e.g., .docx, .xlsx) to avoid losing marks.

• Mistaking absolute and relative cell references leading to incorrect formula replication across cells.
• Selecting inappropriate chart types that misrepresent data, such as using a pie chart for trends over time.
• Overlooking data validation and consistency, resulting in entry errors and unreliable outputs.
• Misconception: 'The internet and the World Wide Web are the same thing.' Correction: The internet is the global network of computers, while the World Wide Web is a service that uses the internet to access websites.
• Misconception: 'If I download an image from Google, it's free to use.' Correction: Many images are copyrighted; you need to check the licence and give credit or use royalty-free sources.
• Misconception: 'Spreadsheets are just for calculations.' Correction: Spreadsheets can also be used to organise data, create charts, and perform what-if analysis, not just for maths.

1. 1Week 1: Focus on health and safety and file management. Practice creating folders, saving files with appropriate names, and understanding file extensions.
2. 2Week 2: Move on to word processing and spreadsheets. Create a document with formatting and a spreadsheet with simple formulas and charts.
3. 3Week 3: Revise online safety and databases. Learn about phishing, strong passwords, and how to create a simple database table.
4. 4Week 4: Review all topics and complete practice questions. Use past papers or sample tasks to test your knowledge and time management.

• 📋Multiple-choice questions: These test recall of key facts, such as definitions of hardware/software or safety rules. Read each option carefully and eliminate obvious wrong answers.
• 📋Short-answer questions: Often ask you to 'list' or 'state' a certain number of points. Give exactly the number asked for, and use bullet points if helpful.
• 📋Practical tasks: You may be given a scenario and asked to create a document, spreadsheet, or database. Follow the instructions step-by-step and save your work in the correct format.
• 📋Extended writing: Questions that ask you to 'explain' or 'evaluate' require a paragraph with reasons and examples. Structure your answer with a clear point, evidence, and explanation.

Loading assessment details…