Database software — WJEC Vocational Digital Skills & IT

The WJEC Level 1 Award for IT Users (ITQ) is a vocationally-related qualification designed to equip students with essential digital skills for the modern workplace. This qualification covers a broad range of IT applications, including word processing, spreadsheets, databases, presentation software, and using the internet safely and effectively. It is ideal for students who want to build a solid foundation in IT, whether for further study or entry-level employment.

The course is structured around practical, real-world tasks that require students to demonstrate competence in using common software tools. For example, in word processing, you might create and format documents, while in spreadsheets, you'll learn to enter data, use formulas, and create charts. The qualification emphasises not just technical ability but also understanding of good practice, such as file management, data protection, and online safety.

This qualification fits into the wider subject of Digital Skills & IT by providing a stepping stone to more advanced qualifications, such as the Level 2 Certificate for IT Users. It also directly supports employability, as many jobs now require basic IT proficiency. By completing this award, you will gain a recognised certification that demonstrates your ability to use IT effectively in a variety of contexts.

• →File management: Organising, saving, and retrieving files in a logical folder structure, using appropriate file names and understanding file extensions.
• →Data protection: Understanding the principles of the Data Protection Act, including keeping personal data secure and knowing when to share information.
• →Formatting: Applying consistent styles, fonts, and layouts to documents and presentations to improve readability and professional appearance.
• →Formulas and functions: In spreadsheets, using basic formulas (e.g., SUM, AVERAGE) and cell references to perform calculations automatically.
• →Online safety: Recognising phishing attempts, using strong passwords, and understanding the risks of sharing personal information online.

• Award credit for demonstrating correct data entry into appropriate fields
• Award credit for using editing functions to correct or update records
• Award credit for applying sorting or filtering to organise data logically
• Award credit for generating a report using database tools
• Award credit for formatting the report to be readable and professional

• 💡Practise using the database software's help features to find tools quickly
• 💡Always check your data entry for typos and consistency
• 💡When producing reports, ensure you select the correct fields and layout
• 💡Save your work regularly and keep backups
• 💡Read the task carefully and highlight key instructions, such as 'use a formula to calculate the total' or 'format the heading as Heading 1'. Missing a single instruction can lose marks.
• 💡Practice using keyboard shortcuts (e.g., Ctrl+C for copy, Ctrl+V for paste) to work more efficiently during the exam. This also shows competence.
• 💡Check your work for consistency: ensure all headings are the same style, all numbers are formatted consistently (e.g., currency symbols), and there are no spelling errors. Use spell check but also proofread manually.

• Entering data in the wrong field or using incorrect data types
• Forgetting to save changes after editing records
• Not applying filters or sorts correctly, leading to disorganised output
• Producing a report that is cluttered or lacks clear headings
• Misconception: 'I can just use the default settings for everything.' Correction: While defaults are a starting point, you need to adjust formatting (e.g., margins, font size, alignment) to meet specific task requirements. Examiners look for appropriate formatting choices.
• Misconception: 'Saving once is enough.' Correction: You should save your work regularly and use version control (e.g., 'Report_v2') to avoid losing progress. Also, ensure you save in the correct format (e.g., .docx for Word, .xlsx for Excel).
• Misconception: 'All information on the internet is reliable.' Correction: You must evaluate sources for credibility. For example, a government website is more reliable than a personal blog. Always cross-check facts and cite sources where required.

Loading assessment details…