Elements

Performance Criteria

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Select and prepare resources

1.1

Determine job requirements from specifications, job sheets and work instructions

1.2

Identify spreadsheet task requirements in relation to data entry, storage, output and presentation

2. Create spreadsheet

2.1

Ensure data is entered, checked and amended to maintain consistency of design and layout

2.2

Format spreadsheet using software functions to adjust page and cell layout to meet information requirements

2.3

Ensure formulas are tested and used to confirm output that meets task requirements

2.4

Use manuals, user documentation and online help to support best practice in spreadsheet design and production

3. Produce charts

3.1

Select chart type and design that enable valid representation of numerical data to show cost, performance and activity

3.2

Create charts using required data range in spreadsheet

3.3

Modify chart type and layout using formatting features

4. Analyse data

4.1

Consolidate data with standard reporting format to report cost, performance and activity

4.2

Analyse trends in data to identify inventory and cost outcomes

4.3

Review and update spreadsheet components to match projected outcomes

4.4

Report outcome of analysis to management