SS2 Assessment

Unit SS2: Spreadsheet software

You should use this file to complete your Assessment.

How to complete and send your assessment:

Save a copy of this document, either onto your computer or a disk
Work through your Assessment, remembering to save your work regularly
When you’ve finished, print out a copy to keep for reference
Then, go to www.vision2learn.com and send your completed Assessment to your tutor via your My Study area – make sure it is clearly marked with your name, the course title and the Unit and Assessment number.

Please note that this Assessment document has 13 pages and is made up of 6 Parts.

Learning outcomes

Throughout this Assessment, you will meet a number of different learning outcomes and assessment criteria. Take a look at the information below to see which criteria you will meet in which Parts of the Assessment.

Learning outcomes & Assessment criteria met

Part 1:

1.1 Identify what numerical and other information is needed in the spreadsheet and how it should be structured
1.2 Enter and edit numerical and other data accurately
1.4 Store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available

Part 2:

1.1 Identify what numerical and other information is needed in the spreadsheet and how it should be structured
1.2 Enter and edit numerical and other data accurately
1.4 Store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available
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

Part 3:

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 and meet requirements

Part 4:

1.3 Combine and