Design and produce complex spreadsheets
This unit is an accredited training resource consistent with the Nationally Recognised Training requirements for Vocational Education and Training (VET) and is ideal for Registered Training Organisations (RTOs) in Australia. It consists of Learning Resource Material (instructional theory), an Assessment Workbook, and information about assessment mapping to the Performance Criteria, Knowledge Evidence, and Performance Evidence requirements of this accredited unit.
Our BSBTEC402 training product is available for purchase as a hardcopy (printed) book in both Learner Guide and Trainer/Assessor Guide variants. This unit is available for enrolment and online training/assessment via Catapult LMS (Learning Management System). NOTE: If you are a training provider, please do your own validation, in accordance with your Training and Assessment Strategy (TAS).
This BSBTEC402 unit is an accredited training resource consistent with the Nationally Recognised Training requirements for Vocational Education and Training (VET) and is ideal for Registered Training Organisations (RTOs) in Australia.
The unit content consists of:
Our BSBTEC402 training product is available for purchase as a hardcopy (printed) book in both Learner Guide and Trainer/Assessor Guide variants.
This unit is also available for enrolment and online training/assessment via Catapult LMS (Learning Management System). Contact us to learn more.
NOTE: If you are a training provider, please do your own validation, per your Training and Assessment Strategy (TAS).
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.
Supersedes and is equivalent to BSBITU402 Develop and use complex spreadsheets.
Supersedes but is not equivalent to BSBITA411 Design and develop relational databases.
No licensing, legislative or certification requirements apply to this unit at the time of publication.
Foundation skills essential to performance are explicit in the performance criteria of this unit of competency.
Digital Competence – Technology Use
Not applicable
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:
Assessors of this unit must satisfy the requirements for assessors in applicable vocational education and training legislation, frameworks and/or standards.
$19.00 inc GST