Element 1 Plan a simple spreadsheet to provide a solution to a problem

1.1

A working plan is developed to meet the requirements of the brief

1.2

The plan identifies the purpose of the spreadsheet

1.3

The plan includes a basic outline of the spreadsheet specifications and/or features required to provide a solution

Element 2 Produce a simple spreadsheet in accordance with the plan

2.1

Data is entered, and is formatted to produce the required spreadsheet in terms of cell width, alignment, text, and number formats

2.2

Spreadsheet cell functions/formulae are entered

2.3

The spreadsheet is saved to a file.

Element 3 Use the spreadsheet to provide a solution

3.1

The spreadsheet file is located and opened, and new variables are entered

3.2

Cell ranges are used to produce a graph as part of the solution

3.3

The revised spreadsheet file is printed out in hard copy

Element 4 Evaluate the spreadsheet.

4.1

The spreadsheet is evaluated for compliance with the brief, appropriate formatting, readability, legibility, presentation, accuracy, and data integrity

4.2

The spreadsheet is modified if required and compliance with the brief is confirmed