BACK TO SCHOOLS ITQ [1]

Handbook home page [2]

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

  Level 3, Unit 5 - Spreadsheet Software (6 credits)

  1. 1. Use a spreadsheet to enter, edit and organise numerical and other data	2. 2. Select and use appropriate formulas and data analysis tools and techniques to meet requirements	3. 3. Use tools and techniques to present, and format and publish spreadsheet information
  1.1 I can identify what numerical and other information is needed in the spreadsheet and how it should be structured [7]	2.1 I can explain what methods can be used to summarise, analyse and interpret spreadsheet data and when to use them [8]	3.1 I can explain how to present and format spreadsheet information effectively to meet needs [9]
  1.2 I can enter and edit numerical and other data accurately [10]	2.2 I can select and use a wide range of appropriate functions and formulas to meet calculation requirements [11]	3.2 I can select and use appropriate tools and techniques to format spreadsheet cells, rows, columns and worksheets effectively [12]
  1.3 I can combine and link data from different sources [13]	2.3 I can select and use a range of tools and techniques to analyse and interpret data to meet requirements [14]	3.3 I can select and use appropriate tools and techniques to generate, develop and format charts and graphs [15]
  1.4 I can store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available [16]	2.4 I can select and use forecasting tools and techniques [17]	3.4 I can select and use appropriate page layout to present, print and publish spreadsheet information [18]
  		3.5 I can explain how to find and sort out any errors in formulas [19]
  		3.6 I can check spreadsheet information meets needs, using IT tools and making corrections as necessary [20]
  		3.7 I can use auditing tools to identify and respond appropriately to any problems with spreadsheets [21]

  Links to ITQ units

  Entry Level	Level 1	Level 2	Level 3
  Entry Level 1, Unit 1 - Improving Productivity Using IT (1 credit) [23]	Level 1, Unit 1 - Improving Productivity Using IT (3 credits) [24]	Level 2, Unit 1 - Improving Productivity Using IT (4 credits) [25]	Level 3, Unit 1 - Improving Productivity Using IT (5 credits) [26]
  Entry Level 2, Unit 1 - Improving Productivity Using IT (2 credits) [27]	Level 1, Unit 2 - Website Software (3 credits) [28]	Level 2, Unit 2 - Website Software (4 credits) [29]	Level 3, Unit 2 - Website Software (5 credits) [30]
  Entry Level 2, Unit 2 - Using ICT to Select and Exchange Information (2 credits) [31]	Level 1, Unit 3 - Using Collaborative Technologies (3 credits) [32]	Level 2, Unit 3 - Using Collaborative Technologies (4 credits) [33]	Level 3, Unit 3 - Using Collaborative Technologies (6 credits) [34]
  Entry Level 2, Unit 3 - Online Basics (2 credits) [35]	Level 1, Unit 4 - IT Security for Users (1 credit) [36]	Level 2, Unit 4 - IT Security for Users (2 credits) [37]	Level 3, Unit 4 - IT Security for Users (3 credits) [38]
  Entry Level 2, Unit 4 -Desktop Publishing Software (2 credits) [39]	Level 1, Unit 5 - Spreadsheet Software (3 credits) [40]	Level 2, Unit 5 - Spreadsheet Software (4 credits) [41]	Level 3, Unit 5 - Spreadsheet Software (6 credits) [42]
  Entry Level 2, Unit 5 - Using ICT: Safe Working Practices (1 credit) [43]	Level 1, Unit 6 - Specialist Software (2 credits) [44]	Level 2, Unit 6 - Specialist software (3 credits) [45]	Level 3, Unit 6 - Specialist Software (4 credits) [46]
  Entry Level 2, Unit 6 - Using ICT in the Workplace (3 credits) [47]	Level 1, Unit 7 - Word Processing (3 credits) [48]	Level 2, Unit 7 - Word processing (4 credits) [49]	Level 3, Unit 7 - Word Processing Software (6 credits) [50]
  Entry Level 2, Unit 7 - Imaging software (2 credits) [51]	Level 1, Unit 8 - Using the Internet (3 credits) [52]	Level 2, Unit 8 - Using the internet (4 credits) [53]	Level 3, Unit 8 - Using the Internet (5 credits) [54]
  Entry Level 2, Unit 8 - Using ICT Equipment in a Work Place (2 credits) [55]	Level 1, Unit 9 - Drawing and planning (2 credits) [56]	Level 2, Unit 9 - Drawing and planning (3 credits) [57]	Level 3, Unit 9 - Drawing and Planning Software (4 credits) [58]
  Entry Level 2, Unit 9 - Using Word Processing Software (2 credits) [59]	Level 1, Unit 10 - Presentation Software (3 credits) [60]	Level 2, Unit 10 - Presentation software (4 credits) [61]	Level 3, Unit 10 - Presentation Software (6 credits) [62]
  Entry Level 2, Unit 10 - ICT for Employment (1 credit) [63]	Level 1, Unit 11 - Database Software (3 credits) [64]	Level 2, Unit 11 - Database software (4 credits) [65]	Level 3, Unit 11 - Database Software (6 credits) [66]
  Entry Level 2, Unit 11 - Audio and Video Software (2 credits) [67]	Level 1, Unit 12 - Desktop Publishing Software (3 credits) [68]	Level 2, Unit 12 - Desktop Publishing Software (4 credits) [69]	Level 3, Unit 12 - Desktop Publishing Software (5 credits) [70]
  Entry Level 2, Unit 12 - Presentation Software (2 credits) [71]	Level 1, Unit 13 - Using Email (2 credits) [72]	Level 2, Unit 13 - Using Email (3 credits) [73]	Level 3, Unit 13 - Using Email (3 credits) [74]
  Entry Level 3, Unit 1 - Improving Productivity Using IT (3 credits) [75]	Level 1, Unit 14 - Audio Software (2 credits) [76]	Level 2, Unit 14 - Audio Software (3 credits) [77]	Level 3, Unit 14 - Audio Software (4 credits) [78]
  Entry Level 3, Unit 2 - Online Basics (1 credit) [79]	Level 1, Unit 15 - Imaging Software (3 credits) [80]	Level 2, Unit 15 - Imaging Software (4 credits) [81]	Level 3, Unit 15 - Imaging Software (5 credits) [82]
  Entry Level 3, Unit 3 - Desktop Publishing Software (2 credits) [83]	Level 1, Unit 16 - IT Communication Fundamentals (2 credits) [84]	Level 2, Unit 16 - IT Communication Fundamentals (2 credits) [85]	Level 3, Unit 17 - Video Software (4 credits) [86]
  Entry Level 3, Unit 4 - Displaying Information Using ICT (3 credits) [87]	Level 1, Unit 17 - Video Software (2 credits) [88]	Level 2, Unit 17 - Video Software (3 credits) [89]	Level 3, Unit 23 - Multimedia Software (6 credits) [90]
  Entry Level 3, Unit 5 - Using ICT to Find Information (3 credits) [91]	Level 1, Unit 18 - IT Software Fundamentals (3 credits) [92]	Level 2, Unit 18 - IT Software Fundamentals (3 credits) [93]	Level 3, Unit 24 - Additive Manufacture (6 credits) [94]
  Entry Level 3, Unit 6 - Communicating Information Using ICT (3 credits) [95]	Level 1, Unit 19 - IT User Fundamentals (3 credits) [96]	Level 2, Unit 19 - IT User Fundamentals (3 credits) [97]	Level 3, Unit 27 - Design Software (5 credits) [98]
  Entry Level 3, Unit 7 - Producing Charts Using ICT (3 credits) [99]	Level 1, Unit 20 - Using Mobile IT Devices (2 credits) [100]	Level 2, Unit 20 - Using Mobile IT Devices (2 credits) [101]	Level 3, Unit 28 - Optimise IT System Performance (5 credits) [102]
  Entry Level 3, Unit 8 - IT Security for users (1 credit) [103]	Level 1, Unit 21 - Data Management Software (2 credits) [104]	Level 2, Unit 21 - Data Management Software (3 credits) [105]	Level 3, Unit 29 - Set Up an IT System (5 credits) [106]
  Entry Level 3, Unit 10 - Presentation software (2 credits) [107]	Level 1, Unit 22- Understanding the social and environmental impact of architecture and construction (3 credits) [108]	Level 2, Unit 22 -Understanding the social and environmental impact of architecture and construction (4 credits) [109]	Level 3, Unit 32 - Computerised Accounting Software (5 credits) [110]
  Entry Level 3, Unit 15 - Imaging Software (2 credits) [111]	Level 1, Unit 23 - Multimedia Software (3 credits) [112]	Level 2, Unit 23 - Multimedia Software (4 credits) [113]	Level 3, Unit 33 - Application Development Using Project Management Methods (6 credits) [114]
  Entry Level 3, Unit 20 - Introduction to Using mobile IT devices (2 credits) [115]	Level 1, Unit 24 - Additive Manufacture (3 credits) [116]	Level 2, Unit 24 - Additive Manufacture (3 credits) [117]	Level 3, Unit 37 - Internet of Things (6 credits) [118]
  Entry Level 3, Unit 25 - Developing Computer Games and Puzzles (3 credits) [119]	Level 1, Unit 25 - Developing Computer Games and Puzzles (4 credits) [120]	Level 2, Unit 25 - Developing Computer Games and Puzzles (4 credits) [121]	Level 3, Unit 40 - Cloud Based Services and Applications (5 credits) [122]
  Entry Level 3, Unit 26 - Computer Games Development (3 credits) [123]	Level 1, Unit 26 - Computer Games Development (3 credits) [124]	Level 2, Unit 26 - Computer Games Development (4 credits) [125]	Level 3, Unit 41 - Cloud Based Systems and Security (5 credits) [126]
  Entry Level 3, Unit 28 - Personal information management software (1 credit) [127]	Level 1, Unit 27 - Design Software (3 credits) [128]	Level 2, Unit 27 - Design Software (4 credits) [129]	Level 3, Unit 42 - Undertaking a RealWorld Project (5 credits) [130]
  	Level 1, Unit 28 - Optimise IT System Performance (2 credits) [131]	Level 2, Unit 28 - Optimise IT System Performance (4 credits) [132]	Level 3, Unit 44 - Bespoke Software (4 credits) [133]
  	Level 1, Unit 29 - Set Up an IT System (3 credits) [134]	Level 2, Unit 29 - Set Up an IT System (4 credits) [135]	Level 3, Unit 57 - Networking Fundamentals (5 credits) [136]
  	Level 1, Unit 30 - CAD (3 credits) [137]	Level 2, Unit 30 - CAD (3 credits) [138]	Level 3, Unit 60 - Cisco CCNA 1 – Introduction to Networks (6 credits) [139]
  	Level 1, Unit 31 - Internet Safety for IT users (3 credits) [140]	Level 2, Unit 32 - Computerised Accounting Software (3 credits) [141]	Level 3, Unit 61 - Cisco CCNA 2 – Routing and Switching (6 credits) [142]
  	Level 1, Unit 32 - Computerised Accounting Software (2 credits) [143]	Level 2, Unit 33 - Application Development Using Project Management Methods (4 credits) [144]	Level 3, Unit 62 - Cisco CCNA 3 – Scaling Networks (6 credits) [145]
  	Level 1, Unit 36 - Financial Modelling (3 credits) [146]	Level 2, Unit 34 - Developing skills for project management (4 credits) [147]	Level 3, Unit 63 - Cisco CCNA 4 – Connecting Networks (6 credits) [148]
  	Level 1, Unit 50 - Developing skills for remote working (3 credits) [149]	Level 2, Unit 35 - Using Project Management Software (4 credits) [150]	Level 3, Unit 64 - Cisco – CCNA Security (6 credits) [151]
  	Level 1, Unit 51 - Effectiveness communication using remote systems (4 credits) [152]	Level 2, Unit 50 - Developing skills for remote working (3 credits) [153]	Level 3, Unit 65 - Cisco – CyberSecurity Essentials (6 credits) [154]
  	Level 1, Unit 102 - Digital Editing and Publishing (4 credits) [155]	Level 2, Unit 51 - Effectiveness communication using remote systems (4 credits) [156]	Level 3, Unit 66 - Cisco – IT Essentials (6 credits) [157]
  	Level 1, Unit 103 - Digital Modelling (4 credits) [158]	DELLevel 2, Unit 70 - Understanding of Cyber Security and Online Threats (3 credits) [159]	Level 3, Unit 67 - Cisco – Networking Essentials (6 credits) [160]
  	Level 1, Unit 105 - Digital Design and Graphics (4 credits) [161]	DELLevel 2, Unit 71 - Analysing and Evaluating Cyber Threats (3 credits) [162]
  		DELLevel 2, Unit 72 - Applying and Deploying Security Tools and Best Practice (3 credits) [163]
  		DELLevel 2, Unit 73 - Extended Project: Securing and Defending Online Systems (6 credits) [164]
  		Level 2, Unit 80 - Digital Tools and Best Practice for Project Management (5 credits) [165]
  		Level 2, Unit 81 - Digital Safety and Security Policies and Procedures (4 credits) [166]
  		Level 2, Unit 82 - Digital Editing and Publishing (3 credits) [167]
  		Level 2, Unit 83 - Digital Design and Graphics (3 credits) [168]
  		Level 2, Unit 84 - Digital Modelling and Data Management (3 credits) [169]
  		Level 2, Unit 85 - Virtual Reality and the Development Life Cycle (4 credits) [170]