Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners
BSBITU402 Mapping and Delivery Guide
Develop and use complex spreadsheets
Version 1.0
Issue Date: June 2024
Qualification | - |
Unit of Competency | BSBITU402 - Develop and use complex spreadsheets |
---|---|---|---|
Description | |||
Employability Skills | |||
Learning Outcomes and Application | This unit describes the skills and knowledge required to use spreadsheet software to complete business tasks and produce complex documents.It 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.No licensing, legislative or certification requirements apply to this unit at the time of publication. | ||
Duration and Setting | X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting. |
||
Prerequisites/co-requisites | |||
Competency Field |
Development and validation strategy and guide for assessors and learners | Student Learning Resources | Handouts Activities |
Slides PPT |
Assessment 1 | Assessment 2 | Assessment 3 | Assessment 4 | |
---|---|---|---|---|---|---|---|---|
Elements of Competency | Performance Criteria | |||||||
Element: Prepare to develop spreadsheet |
| |||||||
Element: Develop a linked spreadsheet solution |
| |||||||
Element: Automate and standardise spreadsheet operation |
| |||||||
Element: Use spreadsheets |
| |||||||
Element: Represent numerical data in graphic form |
|