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 5 - Spreadsheet Software (4 credits)

  1. Use a spreadsheet to enter, edit and organise numerical and other data	2. Select and use appropriate formulas and data analysis tools to meet requirements	3. Select and use tools and techniques to present and format spreadsheet information
  1.1 I can identify what numerical and other data is needed in the spreadsheet and how it should be structured.	2.1 I can identify how to summarise and display the required information.	3.1 I can select and use appropriate tools and techniques to format spreadsheet cells, rows and columns.
  1.2 I can enter and edit numerical and other data accurately.	2.2 I can use functions and formulas to meet calculation requirements.	3.2 I can identify which chart or graph type to use to display information.
  1.3 I can store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available.	2.3 I can use spreadsheet tools and techniques to summarise and display information.	3.3 I can select and use appropriate tools and techniques to generate, develop and format charts and graph.
  1.4 I can combine and link data across worksheets.		3.4 I can select and use appropriate page layout to present and print spreadsheet information.
  		3.5 I can check spreadsheet information meets needs, using IT tools and making corrections as appropriate.
  		3.6 I can describe how to find errors in spreadsheet formulas.
  		3.7 I can respond appropriately to any problems with spreadsheets.

  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 38 - Animation Software (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 39 - Digital Art (3 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 43 - E-safety for learners (2 credits)	Level 2, Unit 39 - Digital Art (4 credits)	Level 3, Unit 66 - Cisco – IT Essentials (6 credits)
  Entry Level 3, Unit 3 - Desktop Publishing Software (2 credits)	Level 1, Unit 50 - Developing skills for remote working (3 credits)	Level 2, Unit 43 - E-safety for learners (3 credits)	Level 3, Unit 67 - Cisco – Networking Essentials (6 credits)
  Entry Level 3, Unit 4 - Displaying Information Using ICT (3 credits)	Level 1, Unit 51 - Effectiveness communication using remote systems (4 credits)	Level 2, Unit 50 - Developing skills for remote working (3 credits)
  Entry Level 3, Unit 5 - Using ICT to Find Information (3 credits)	Level 1, Unit 102 - Digital Editing and Publishing (4 credits)	Level 2, Unit 51 - Effectiveness communication using remote systems (4 credits)
  Entry Level 3, Unit 6 - Communicating Information Using ICT (3 credits)	Level 1, Unit 103 - Digital Modelling (4 credits)	DELLevel 2, Unit 70 - Understanding of Cyber Security and Online Threats (3 credits)
  Entry Level 3, Unit 7 - Producing Charts Using ICT (3 credits)	Level 1, Unit 105 - Digital Design and Graphics (4 credits)	DELLevel 2, Unit 71 - Analysing and Evaluating Cyber Threats (3 credits)
  Entry Level 3, Unit 8 - IT Security for users (1 credit)		DELLevel 2, Unit 72 - Applying and Deploying Security Tools and Best Practice (3 credits)
  Entry Level 3, Unit 10 - Presentation software (2 credits)		DELLevel 2, Unit 73 - Extended Project: Securing and Defending Online Systems (6 credits)
  Entry Level 3, Unit 14 - Audio and Video Software (2 credits)		Level 2, Unit 80 - Digital Tools and Best Practice for Project Management (5 credits)
  Entry Level 3, Unit 15 - Imaging Software (2 credits)		Level 2, Unit 81 - Digital Safety and Security Policies and Procedures (4 credits)
  Entry Level 3, Unit 16 - Using Collaborative Technologies (3 credits)		Level 2, Unit 82 - Digital Editing and Publishing (3 credits)
  Entry Level 3, Unit 20 - Introduction to Using mobile IT devices (2 credits)		Level 2, Unit 83 - Digital Design and Graphics (3 credits)
  Entry Level 3, Unit 23 - Multimedia Software (2 credits)		Level 2, Unit 84 - Digital Modelling and Data Management (3 credits)
  Entry Level 3, Unit 25 - Developing Computer Games and Puzzles (3 credits)		Level 2, Unit 85 - Virtual Reality and the Development Life Cycle (4 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)