BACK TO SCHOOLS ITQ

Handbook home page

• General guidance for interpreting QCF qualification levels.
  
• Link to assessor's guide to interpreting the criteria for this unit.
  
• Click on the links in the table below for specific guidance on the assessment criteria.
  
• National Strategies APP criteria are relevant from Entry 3 upwards.
  
• References to personal learning and thinking skills (PLTS)
  .

  Level 2, Unit 11 - Database software (4 credits)

  1. Create and modify non-relational database tables.	2. Enter, edit and organise structured information in a database.	3. Use database software tools to run queries and produce reports.
  1.1 I can identify the components of a database design.	2.1 I can create forms to enter, edit and organise data in a database.	3.1 I can create and run database queries using multiple criteria to display or amend selected data.
  1.2 I can describe the field characteristics for the data required.	2.2 I can select and use appropriate tools and techniques to format data entry forms.	3.2 I can plan and produce database reports from a single table non-relational database.
  1.3 I can create and modify database tables using a range of field types.	2.3 I can check data entry meets needs, using IT tools and making corrections as necessary.	3.3 I can select and use appropriate tools and techniques to format database reports.
  1.4 I can describe ways to maintain data integrity.	2.4 I can respond appropriately to data entry errors.	3.4 I can check reports meet needs, using IT tools and making corrections as necessary.
  1.5 I can respond appropriately to problems with database tables.
  1.6 I can use database tools and techniques to ensure data integrity is maintained.

  Links to ITQ units

  Entry Level	Level 1	Level 2	Level 3
  Entry Level 1, Unit R - Registration	Level 1, Unit R - Registration	Level 2, Unit R - Registration	Level 3, Unit R - Registration
  Entry Level 1, Unit 1 - Improving Productivity Using IT (1 credit)	Level 1, Unit 1 - Improving Productivity Using IT (3 credits)	Level 2, Unit 1 - Improving Productivity Using IT (4 credits)	Level 3, Unit 1 - Improving Productivity Using IT (5 credits)
  Entry Level 1, Unit 2 - Using ICT to Select and Exchange Information (2 credits)	Level 1, Unit 2 - Website Software (3 credits)	Level 2, Unit 2 - Website Software (4 credits)	Level 3, Unit 2 - Website Software (5 credits)
  Entry Level 1, Unit 3 - Online Basics (2 credits)	Level 1, Unit 3 - Using Collaborative Technologies (3 credits)	Level 2, Unit 3 - Using Collaborative Technologies (4 credits)	Level 3, Unit 3 - Using Collaborative Technologies (6 credits)
  Entry Level 1, Unit 4 - Desktop Publishing Software (2 credits)	Level 1, Unit 4 - IT Security for Users (1 credit)	Level 2, Unit 4 - IT Security for Users (2 credits)	Level 3, Unit 4 - IT Security for Users (3 credits)
  Entry Level 1, Unit 5 - Safe Working Practices (2 credits)	Level 1, Unit 5 - Spreadsheet Software (3 credits)	Level 2, Unit 5 - Spreadsheet Software (4 credits)	Level 3, Unit 5 - Spreadsheet Software (6 credits)
  Entry Level 1, Unit 6 - Using ICT in the Workplace (2 credits)	Level 1, Unit 6 - Specialist Software (2 credits)	Level 2, Unit 6 - Specialist software (3 credits)	Level 3, Unit 6 - Specialist Software (4 credits)
  Entry Level 1, Unit 7 - Imaging software (2 credits)	Level 1, Unit 7 - Word Processing (3 credits)	Level 2, Unit 7 - Word processing (4 credits)	Level 3, Unit 7 - Word Processing Software (6 credits)
  Entry Level 1, Unit 8 - Using ICT Equipment in a Work Place (2 credits)	Level 1, Unit 8 - Using the Internet (3 credits)	Level 2, Unit 8 - Using the internet (4 credits)	Level 3, Unit 8 - Using the Internet (5 credits)
  Entry Level 1, Unit 9 - Using Word Processing Software (2 credits)	Level 1, Unit 9 - Drawing and planning (2 credits)	Level 2, Unit 9 - Drawing and planning (3 credits)	Level 3, Unit 9 - Drawing and Planning Software (4 credits)
  Entry Level 1, Unit 11 - Audio and Video Software (2 credits)	Level 1, Unit 10 - Presentation Software (3 credits)	Level 2, Unit 10 - Presentation software (4 credits)	Level 3, Unit 10 - Presentation Software (6 credits)
  Entry Level 1, Unit 12 - Presentation Software (2 credits)	Level 1, Unit 11 - Database Software (3 credits)	Level 2, Unit 11 - Database software (4 credits)	Level 3, Unit 11 - Database Software (6 credits)
  Entry Level 1, Unit 13 - Computer Games Development (2 credits)	Level 1, Unit 12 - Desktop Publishing Software (3 credits)	Level 2, Unit 12 - Desktop Publishing Software (4 credits)	Level 3, Unit 12 - Desktop Publishing Software (5 credits)
  Entry Level 1, Unit 14 - Video Communication (2 credits)	Level 1, Unit 13 - Using Email (2 credits)	Level 2, Unit 13 - Using Email (3 credits)	Level 3, Unit 13 - Using Email (3 credits)
  Entry Level 1, Unit 29 - Understand social media (2 credits)	Level 1, Unit 14 - Audio Software (2 credits)	Level 2, Unit 14 - Audio Software (3 credits)	Level 3, Unit 14 - Audio Software (4 credits)
  Entry Level 2, Unit R - Registration	Level 1, Unit 15 - Imaging Software (3 credits)	Level 2, Unit 15 - Imaging Software (4 credits)	Level 3, Unit 15 - Imaging Software (5 credits)
  Entry Level 2, Unit 1 - Improving Productivity Using IT (2 credits)	Level 1, Unit 16 - IT Communication Fundamentals (2 credits)	Level 2, Unit 16 - IT Communication Fundamentals (2 credits)	Level 3, Unit 17 - Video Software (4 credits)
  Entry Level 2, Unit 2 - Using ICT to Select and Exchange Information (2 credits)	Level 1, Unit 17 - Video Software (2 credits)	Level 2, Unit 17 - Video Software (3 credits)	Level 3, Unit 23 - Multimedia Software (6 credits)
  Entry Level 2, Unit 3 - Online Basics (2 credits)	Level 1, Unit 18 - IT Software Fundamentals (3 credits)	Level 2, Unit 18 - IT Software Fundamentals (3 credits)	Level 3, Unit 24 - Additive Manufacture (6 credits)
  Entry Level 2, Unit 4 -Desktop Publishing Software (2 credits)	Level 1, Unit 19 - IT User Fundamentals (3 credits)	Level 2, Unit 19 - IT User Fundamentals (3 credits)	Level 3, Unit 27 - Design Software (5 credits)
  Entry Level 2, Unit 5 - Using ICT: Safe Working Practices (1 credit)	Level 1, Unit 20 - Using Mobile IT Devices (2 credits)	Level 2, Unit 20 - Using Mobile IT Devices (2 credits)	Level 3, Unit 28 - Optimise IT System Performance (5 credits)
  Entry Level 2, Unit 6 - Using ICT in the Workplace (3 credits)	Level 1, Unit 21 - Data Management Software (2 credits)	Level 2, Unit 21 - Data Management Software (3 credits)	Level 3, Unit 29 - Set Up an IT System (5 credits)
  Entry Level 2, Unit 7 - Imaging software (2 credits)	Level 1, Unit 22- Understanding the social and environmental impact of architecture and construction (3 credits)	Level 2, Unit 22 -Understanding the social and environmental impact of architecture and construction (4 credits)	Level 3, Unit 32 - Computerised Accounting Software (5 credits)
  Entry Level 2, Unit 8 - Using ICT Equipment in a Work Place (2 credits)	Level 1, Unit 23 - Multimedia Software (3 credits)	Level 2, Unit 23 - Multimedia Software (4 credits)	Level 3, Unit 33 - Application Development Using Project Management Methods (6 credits)
  Entry Level 2, Unit 9 - Using Word Processing Software (2 credits)	Level 1, Unit 24 - Additive Manufacture (3 credits)	Level 2, Unit 24 - Additive Manufacture (3 credits)	Level 3, Unit 37 - Internet of Things (6 credits)
  Entry Level 2, Unit 10 - ICT for Employment (1 credit)	Level 1, Unit 25 - Developing Computer Games and Puzzles (4 credits)	Level 2, Unit 25 - Developing Computer Games and Puzzles (4 credits)	Level 3, Unit 40 - Cloud Based Services and Applications (5 credits)
  Entry Level 2, Unit 11 - Audio and Video Software (2 credits)	Level 1, Unit 26 - Computer Games Development (3 credits)	Level 2, Unit 26 - Computer Games Development (4 credits)	Level 3, Unit 41 - Cloud Based Systems and Security (5 credits)
  Entry Level 2, Unit 12 - Presentation Software (2 credits)	Level 1, Unit 27 - Design Software (3 credits)	Level 2, Unit 27 - Design Software (4 credits)	Level 3, Unit 42 - Undertaking a RealWorld Project (5 credits)
  Entry Level 2, Unit 14 - Video Communication (2 credits)	Level 1, Unit 28 - Optimise IT System Performance (2 credits)	Level 2, Unit 28 - Optimise IT System Performance (4 credits)	Level 3, Unit 44 - Bespoke Software (4 credits)
  Entry Level 2, Unit 16 - Using Collaborative Technologies (2 credits)	Level 1, Unit 29 - Set Up an IT System (3 credits)	Level 2, Unit 29 - Set Up an IT System (4 credits)	Level 3, Unit 57 - Networking Fundamentals (5 credits)
  Entry Level 2, Unit 26 - Computer Games Development (2 credits)	Level 1, Unit 30 - CAD (3 credits)	Level 2, Unit 30 - CAD (3 credits)	Level 3, Unit 60 - Cisco CCNA 1 – Introduction to Networks (6 credits)
  Entry Level 2, Unit 29 - Understand social media (2 credits)	Level 1, Unit 31 - Internet Safety for IT users (3 credits)	Level 2, Unit 32 - Computerised Accounting Software (3 credits)	Level 3, Unit 61 - Cisco CCNA 2 – Routing and Switching (6 credits)
  Entry Level 2, Unit 32 - Website Software (2 credits)	Level 1, Unit 32 - Computerised Accounting Software (2 credits)	Level 2, Unit 33 - Application Development Using Project Management Methods (4 credits)	Level 3, Unit 62 - Cisco CCNA 3 – Scaling Networks (6 credits)
  Entry Level 2, Unit 36 - Specialist Software (2 credits)	Level 1, Unit 36 - Financial Modelling (3 credits)	Level 2, Unit 34 - Developing skills for project management (4 credits)	Level 3, Unit 63 - Cisco CCNA 4 – Connecting Networks (6 credits)
  Entry Level 3, Unit R - Registration	Level 1, Unit 50 - Developing skills for remote working (3 credits)	Level 2, Unit 35 - Using Project Management Software (4 credits)	Level 3, Unit 64 - Cisco – CCNA Security (6 credits)
  Entry Level 3, Unit 1 - Improving Productivity Using IT (3 credits)	Level 1, Unit 51 - Effectiveness communication using remote systems (4 credits)	Level 2, Unit 38 - Animation Software (4 credits)	Level 3, Unit 65 - Cisco – CyberSecurity Essentials (6 credits)
  Entry Level 3, Unit 2 - Online Basics (1 credit)	Level 1, Unit 102 - Digital Editing and Publishing (4 credits)	Level 2, Unit 50 - Developing skills for remote working (3 credits)	Level 3, Unit 66 - Cisco – IT Essentials (6 credits)
  Entry Level 3, Unit 3 - Desktop Publishing Software (2 credits)	Level 1, Unit 103 - Digital Modelling (4 credits)	Level 2, Unit 51 - Effectiveness communication using remote systems (4 credits)	Level 3, Unit 67 - Cisco – Networking Essentials (6 credits)
  Entry Level 3, Unit 4 - Displaying Information Using ICT (3 credits)	Level 1, Unit 105 - Digital Design and Graphics (4 credits)	DELLevel 2, Unit 70 - Understanding of Cyber Security and Online Threats (3 credits)
  Entry Level 3, Unit 5 - Using ICT to Find Information (3 credits)		DELLevel 2, Unit 71 - Analysing and Evaluating Cyber Threats (3 credits)
  Entry Level 3, Unit 6 - Communicating Information Using ICT (3 credits)		DELLevel 2, Unit 72 - Applying and Deploying Security Tools and Best Practice (3 credits)
  Entry Level 3, Unit 7 - Producing Charts Using ICT (3 credits)		DELLevel 2, Unit 73 - Extended Project: Securing and Defending Online Systems (6 credits)
  Entry Level 3, Unit 8 - IT Security for users (1 credit)		Level 2, Unit 80 - Digital Tools and Best Practice for Project Management (5 credits)
  Entry Level 3, Unit 10 - Presentation software (2 credits)		Level 2, Unit 81 - Digital Safety and Security Policies and Procedures (4 credits)
  Entry Level 3, Unit 14 - Audio and Video Software (2 credits)		Level 2, Unit 82 - Digital Editing and Publishing (3 credits)
  Entry Level 3, Unit 15 - Imaging Software (2 credits)		Level 2, Unit 83 - Digital Design and Graphics (3 credits)
  Entry Level 3, Unit 16 - Using Collaborative Technologies (3 credits)		Level 2, Unit 84 - Digital Modelling and Data Management (3 credits)
  Entry Level 3, Unit 20 - Introduction to Using mobile IT devices (2 credits)		Level 2, Unit 85 - Virtual Reality and the Development Life Cycle (4 credits)
  Entry Level 3, Unit 23 - Multimedia Software (2 credits)
  Entry Level 3, Unit 25 - Developing Computer Games and Puzzles (3 credits)
  Entry Level 3, Unit 26 - Computer Games Development (3 credits)
  Entry Level 3, Unit 28 - Personal information management software (1 credit)
  Entry Level 3, Unit 32 - Website Software (2 credits)
  Entry Level 3, Unit 36 - Specialist Software (2 credits)