Elements and Performance Criteria

The range statement relates to the unit of competency as a whole. It allows for different work environments and situations that may affect performance. Bold italicised wording in the performance criteria is detailed below. Add any essential operating conditions that may be present with training and assessment depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts.
Ergonomic requirements may include:
avoiding radiation from computer screens
chair height, seat and back adjustments
document holder
footrest
keyboard and mouse position
lighting
noise minimisation
posture
screen position
workstation height and layout
measurements and dimensions for objects and space
relevant statutory requirements
scope for making adjustments.
End users may include:
elected members
general public
land information authorities
local government
real estate agents
residents
state and federal government departments
statutory bodies, including land titles office
transport companies
utilities.
Clients may include:
customers with routine or special requests
external to organisation
internal to organisation
regular and new customers, including:
business enterprises
government agencies
members of the public
suppliers.
Work organisation strategies may include:
exercise breaks
mix of repetitive and other activities
rest periods.
Energy and resource conservation techniques may include:
paper use, including:
double-sided printing
re-using paper for rough drafts, while observing confidentiality requirements
shredding paper
recycling resources
using power-save options for equipment.
Templates may include:
font types and sizes
forms
headers and footers
headings
page formats
reports.
Spreadsheet design may include:
analysis of data
appropriateness
avoiding blank rows and columns
cell protection
embedding cell references in formulas
formulas, including linked formulas
formatting and reformatting
functions
headers and footers
headings and labels
identification and parameters
import and export of data
multi-page documents
pivot tables
relative and absolute cell references
split screen operation
use of colour.
Functions may include:
date
logical:
choose
conditions
if
lookup
true/false
mathematical:
absolute
integer
round
square root
value
simple nested
statistical:
count
standard deviation
maximum
minimum
time
trigonometrical.
Formulas may include:
addition
average
comparison
complex formula using trigonometrical functions
division
exponentiation
multiplication
percentage
subtraction
combinations of the above.
Graphs may include:
bar
line
pie
scatter
stack
3-D.
Naming and storing of spreadsheets may include:
authorised access
file naming conventions
filing locations
organisational policy for backing up files
organisational policy for filing hard copies of spreadsheets
security
storage in folders and sub-folders
storage on:
disk drives
tape back-up
server.

The evidence guide provides advice on assessment and must be read in conjunction with the performance criteria, required skills and knowledge, the range statement and the Assessment Guidelines for this Training Package.
Overview of assessment
This unit of competency could be assessed on its own or in combination with other units relevant to the job function.
Critical aspects for assessment and evidence required to demonstrate competency in this unit
A person who demonstrates competency in this unit must be able to provide evidence of:
developing spreadsheets using complex mathematical formulas involving trigonometrical functions
developing graphical representation of data contained in spreadsheets
knowledge of spreadsheet software application.
Specific resources for assessment
Resource implications for assessment include access to:
assessment instruments, including personal planner and assessment record book
assignment instructions, work plans and schedules, policy documents and duty statements
registered training provider of assessment services
relevant GIS data
relevant guidelines, regulations and codes of practice
suitable venue and equipment.
Access must be provided to appropriate learning and assessment support when required.
Where applicable, physical resources should include equipment modified for people with disabilities.
Context of assessment
Holistic: based on the performance criteria, evidence guide, range statement, and required skills and knowledge.
Method of assessment
Demonstrated over a period of time and observed by the assessor (or assessment team working together to conduct the assessment).
Demonstrated competency in a range of situations, which may include customer/workplace interruptions and involvement in related activities normally experienced in the workplace.
Obtained by observing activities in the field and reviewing induction information. If this is not practicable, observation in realistic simulated environments may be substituted.
Guidance information for assessment
Assessment requires that the clients’ objectives and industry expectations are met. If the clients’ objectives are narrowly defined or not representative of industry needs, it may be necessary to refer to portfolio case studies of a variety of SIS requirements to assess competency.
Oral questioning or written assessment and hypothetical situations (scenarios) may be used to assess underpinning knowledge (in assessment situations where the candidate is offered a preference between oral questioning or written assessment, questions are to be identical).
Supplementary evidence may be obtained from relevant authenticated correspondence from existing supervisors, team leaders or specialist training staff.
All practical demonstration must adhere to the safety and environmental regulations relevant to each State or Territory.