Required skills

communication skills to clarify requirements of spreadsheet

editing and proofreading skills to check own work for accuracy

keyboarding skills to enter text and numerical data

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

numeracy skills to create and use spreadsheet formulae

Required knowledge

formatting of workplace documents

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

organisational guidelines on spreadsheet manipulation and processing

purpose and range of use of spreadsheet functions

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 a minimum of two spreadsheets

using cellbased formulae

creating charts using relevant data

knowledge of purpose and range of use of spreadsheet functions

Context of and specific resources for assessment

Assessment must ensure

access to an actual workplace or simulated environment

access to office equipment and resources

access to examples of spreadsheets and simple formulae

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 final spreadsheets

analysis of responses to case studies and scenarios

demonstration of techniques

oral or written questioning to assess knowledge of spreadsheet software functions

Guidance information for assessment

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

general administration units

other IT use units

Ergonomic requirements may include:

Work organisation requirements may include:

Conservation techniques may include:

Spreadsheet task requirements may include:

Data may include:

Checking may include:

Formatting may include:

Software functions may include:

Formulae may include:

Chart types may include:

Features may include:

Printing may include:

Designated time lines may include:

Storing data may include: