Spreadsheet software

Assessment Criteria


1.1 identify what numerical and other information is needed in the spread sheet and how it should be structured

1.2 enter and edit numerical and other data accurately

1.3 combine and link data across worksheets

1.4 store and retrieve spread sheet files effectively, in line with local guidelines and conventions where available.

Assessment Criteria


2.1 identify which tools and techniques to use to analyse and manipulate data to meet requirements

2.2 select and use a range of appropriate functions and formulas to meet calculation requirements

2.3 use a range of tools and techniques to analyse and manipulate data to meet requirements.



Assessment Criteria


3.1 plan how to present and format spread sheet information effectively to meet needs

3.2 select and use appropriate tools and techniques to format spread sheet cells, rows, columns and worksheets

3.3 select and format an appropriate chart or graph type to display selected information

3.4 select and use appropriate page layout to present and print spread sheet information

3.5 check information meets needs, using spread sheet tools and making corrections as necessary

3.6 describe how to find errors in spread sheet formulas

3.7 respond appropriately to any problems with spread sheets.