Required skills

communication skills to clarify requirements of spreadsheet

editing and proofreading skills to check own work for accuracy against original

keyboarding skills to enter text and numerical data

literacy skills to read and understand organisational procedures and to use basic models to produce a range of spreadsheets

mathematical and statistical skills to use spreadsheet functions such as sum counts and averages

Required knowledge

formatting requirements of workplace documents

organisational guidelines on spreadsheet design and use

organisational requirements for ergonomic standards work periods and breaks and conservation techniques

The Evidence Guide provides advice on assessment and must be read in conjunction with the performance criteria required skills and knowledge range statement and the Assessment Guidelines for the Training Package

Overview of assessment

Critical aspects for assessment and evidence required to demonstrate competency in this unit

Evidence of the following is essential

designing spreadsheets that address a range of data and organisational requirements

using software functions graphics and support materials to create spreadsheets

knowledge of formatting requirements of workplace documents

Context of and specific resources for assessment

Assessment must ensure

access to office equipment and resources

access to samples of data for inclusion in spreadsheets

Method of assessment

A range of assessment methods should be used to assess practical skills and knowledge The following examples are appropriate for this unit

direct questioning combined with review of portfolios of evidence and third party workplace reports of onthejob performance by the candidate

review of energy and resource conservation techniques used to minimise wastage

demonstration of techniques

oral or written questioning to assess knowledge of spreadsheet software functions

review of spreadsheets produced

Guidance information for assessment

Holistic assessment with other units relevant to the industry sector workplace and job role is recommended for example

other IT use units

Ergonomic requirements may include:

Work organisation requirements may include:

Occupational health and safety requirements may include:

Conservation techniques may include:

Spreadsheet design may include:

Automatic functions may include:

Consistency of design and layout may include:

Data may include:

Checking data may include:

Formatting may include:

Software functions may include:

Formulae may include:

Printing may include:

Designated time lines may include:

Naming and storing spreadsheet may include: