Assessment Requirements for BSBITU402 Develop and use complex spreadsheets

Release: 1

Assessment Requirements for BSBITU402 Develop and use complex spreadsheets

Modification History

Release	Comments
Release 1	This version first released with BSB Business Services Training Package Version 1.0.

Performance Evidence

Evidence of the ability to:

follow organisational and safe work practices including:

ergonomic requirements

energy and resource conservation techniques

adhere to organisational requirements for:

ensuring consistency of style, design and layout

saving and printing documents within designated timelines

naming and storing documents

adhere to identified or task requirements when producing documents including:

editing macros and automating some tasks

using appropriate templates

creating graphs to represent data

resolve issues by referring to user documentation and online help

use appropriate data storage options

evaluate tasks to improve efficiency

apply knowledge of functions and features of contemporary computer applications

communicate with relevant personnel.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

Knowledge Evidence

To complete the unit requirements safely and effectively, the individual must:

explain advanced functions of spreadsheet software applications

describe impact of formatting and design on presentation and readability of data

explain organisational requirements for ergonomics, work periods and breaks, and conservation techniques.

Assessment Conditions

Assessment must be conducted in a safe environment where evidence gathered demonstrates consistent performance of typical activities experienced in the information and communications technology – IT use field of work and include access to:

organisational policies and procedures

relevant workplace documentation and resources

industry software packages and user instructions.

Assessors must satisfy NVR/AQTF assessor requirements.

Links

Companion Volume implementation guides are found in VETNet - https://vetnet.gov.au/Pages/TrainingDocs.aspx?q=11ef6853-ceed-4ba7-9d87-4da407e23c10