BSBTEC402

Application

This unit describes the skills and knowledge required to use spreadsheet software to complete business tasks and produce complex documents.

The unit applies to individuals employed in a range of work environments who require skills in creation of complex spreadsheets to store and retrieve data. They may work as individuals providing administrative support within an enterprise, or may be independently responsible for designing and working with spreadsheets relevant to their own work roles.

Unit mapping information

Supersedes and is equivalent to BSBITU402 Develop and use complex spreadsheets.

Supersedes but is not equivalent to BSBITA411 Design and develop relational databases.

Licensing, legislative, regulatory or certification requirements

No licensing, legislative or certification requirements apply to this unit at the time of publication.

Foundation skills

Foundation skills essential to performance are explicit in the performance criteria of this unit of competency.

Unit sector or competency field

Digital Competence – Technology Use

Prerequisite, co-requisite or interdependent assessment of units

Not applicable

Assessment conditions

Skills in this unit must be demonstrated in a workplace or simulated environment where the conditions are typical of those in a working environment in this industry.

This includes access to:

• relevant organisational policies and procedures
• workplace documentation and resources
• industry software packages and user instructions

Assessors of this unit must satisfy the requirements for assessors in applicable vocational education and training legislation, frameworks and/or standards.