Element 1

Produce a spreadsheet from instructions

1.1

Data is entered into the spreadsheet, using labels and values, as instructed

1.2

Data is formatted in accordance with instructions

1.3

Spreadsheet cell functions and/or formula are applied, as instructed

1.4

Two different types of graphs are produced from spreadsheet cell ranges, as instructed

1.5

The spreadsheet is saved to a file by use of program tools available for the task

Element 2

Use computer spreadsheet application to achieve the specified outcome

2.1

Spreadsheet use demonstrates the achievement of the specified outcome

2.2

Printed spreadsheet document is in accordance with layout requirements