Unit of competency Outline
Date retreived
23/07/2026 5:41 AM AWST
23/07/2026 5:41 AM AWST
Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.
Design and produce spreadsheets
Design and produce spreadsheets
Unit of competency
National Code
BSBTEC302
BSBTEC302
State Code
OCE02
OCE02
TGA Status
Current
Current
DTWD Status
Approved
Approved
State Implementation and Classification
Approved Date
16/03/2021
Field of Education
080905 - Practical Computing Skills
Original Release Date
16/03/2021
Nominal Hours
30
Description
This unit describes the skills and knowledge required to develop spreadsheets through the use of spreadsheet applications.The unit applies to individuals employed in a range of environments who tend to be personally responsible for designing and working with spreadsheets under minimal supervision. These individuals are generally required to have intermediate knowledge and understanding of a number of spreadsheet applications.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Select and prepare resources
- 1.1 Identify task purpose and audience
- 1.2 Identify task requirements according to data entry, storage, output, timeline and presentation format
- 1.3 Select most appropriate application to produce spreadsheet, according to available resources and organisational policies and procedures
2. Plan spreadsheet design
- 2.1 Design spreadsheet design to suit purpose, audience and information requirements of task
- 2.2 Confirm spreadsheet is designed to enhance readability and appearance, and is in accordance with organisational and task requirements
- 2.3 Use available application functions and confirm consistency of design and layout, adhering to organisational and task requirements
3. Create spreadsheet
- 3.1 Enter data, check and amend to maintain consistency of design and layout, in accordance with organisational and task requirements
- 3.2 Format spreadsheet using application functions, according to organisational policies and procedures and presentation requirements
- 3.3 Consult with relevant stakeholders and confirm formulae are tested and output meets task requirements
- 3.4 Use required help functions and action issues as required
4. Produce charts
- 4.1 Select chart type and design that offers analysis of numerical data, and meets organisational and task requirements
- 4.2 Create charts using required data range in spreadsheet
- 4.3 Modify chart type and layout using formatting features, adhering to organisational and task requirements
5. Finalise and present spreadsheets
- 5.1 Review and edit final spreadsheet and accompanying charts, and prepare for delivery according to task requirements
- 5.2 Deliver document to required stakeholders according to organisational requirements, policies and procedures
- 5.3 Name and store spreadsheet according to organisational requirements and exit application
No information
No information
Replaces
| State Code | National Code | Title | Type |
|---|---|---|---|
| OAE85 | BSBITU314 | Design and produce spreadsheets | Unit of competency |
| OAE78 | BSBITU311 | Use simple relational databases | Unit of competency |