Transcription of Unit 328 Spreadsheet software - City and Guilds
1 1 unit 328 Spreadsheet software UAN: J/502/4626 Level: 3 Credit value: 6 GLH: 45 Assessment type: Portfolio of evidence or Assignment (from 7574 ITQ Users) Relationship to NOS: This unit is based on the Level 3 National Occupational Standards for IT users. Endorsement by a sector or regulatory body: This unit is endorsed by Tech Partnership, the Sector Skills Council for IT and Telecoms. Aim: This unit is about the ability to use IT systems sensibly and purposefully to meet needs, to do so safely and securely in line with organisational guidelines, to respond appropriately to IT problems and to evaluate the use of IT systems.
2 Learning outcome The learner will: 1. Use a Spreadsheet to enter, edit and organise numerical and other data. Assessment criteria The learner can: identify what numerical and other information is needed in the Spreadsheet and how it should be structured enter and edit numerical and other data accurately combine and link data from different sources store and retrieve Spreadsheet files effectively, in line with local guidelines and conventions where available. Assessment Guidance Evidence may be supplied by: product expert witness testimony 2 Learning outcome The learner will: 2.
3 Select and use appropriate formulas and data analysis tools and techniques to meet requirements. Assessment criteria The learner can: explain what methods can be used to summarise, analyse and interpret Spreadsheet data and when to use them select and use a wide range of appropriate functions and formulas to meet calculation requirements select and use a range of tools and techniques to analyse and interpret data to meet requirements select and use forecasting tools and techniques. Assessment Guidance Evidence may be supplied by: product expert witness testimony Learning outcome The learner will: 3.
4 Use tools and techniques to present, and format and publish Spreadsheet information. Assessment criteria The learner can: explain how to present and format Spreadsheet information effectively to meet needs select and use appropriate tools and techniques to format Spreadsheet cells, rows, columns and worksheets effectively select and use appropriate tools and techniques to generate, develop and format charts and graphs select and use appropriate page layout to present, print and publish Spreadsheet information explain how to find and sort out any errors in formulas check Spreadsheet information meets needs.
5 Using IT tools and making corrections as necessary use auditing tools to identify and respond appropriately to any problems with spreadsheets . Assessment Guidance Evidence may be supplied by: product expert witness testimony
