Spreadsheets

General level descriptors

These are the criteria for spreadsheets

Level 1 Unit 3 - Spreadsheet Software (3 credits)

Level 2, Unit 3 - Spreadsheet Software (4 credits)

Level 3, Unit 3 - 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 2.1 I can explain what methods can be used to summarise, analyse and interpret spreadsheet data and when to use them 3.1 I can explain how to present and format spreadsheet information effectively to meet needs
1.2 I can enter and edit numerical and other data accurately 2.2 I can select and use a wide range of appropriate functions and formulas to meet calculation requirements 3.2 I can select and use appropriate tools and techniques to format spreadsheet cells, rows, columns and worksheets effectively
1.3 I can combine and link data from different sources 2.3 I can select and use a range of tools and techniques to analyse and interpret data to meet requirements 3.3 I can select and use appropriate tools and techniques to generate, develop and format charts and graphs
1.4 I can store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available 2.4 I can select and use forecasting tools and techniques 3.4 I can select and use appropriate page layout to present, print and publish spreadsheet information
3.5 I can explain how to find and sort out any errors in formulas
3.6 I can check spreadsheet information meets needs, using IT tools and making corrections as necessary
3.7 I can use auditing tools to identify and respond appropriately to any problems with spreadsheets

Links to other Open Office Units