Unit of competency Outline

Date retreived
22/07/2026 8:08 PM 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 complex spreadsheets

Design and produce complex spreadsheets

Unit of competency
National Code
BSBTEC402
State Code
OCD99
TGA Status
Current
DTWD Status
Approved
Current Release Number
1.00
Current Release Date
19/10/2020
View on TGA
State Implementation and Classification
Approved Date
16/03/2021
Field of Education
080905 - Practical Computing Skills
Original Release Date
16/03/2021
Nominal Hours
60
Description
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.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Prepare and plan to develop spreadsheet
  • 1.1 Organise personal work environment in accordance with ergonomic requirements
  • 1.2 Analyse task and determine specifications for spreadsheets
  • 1.3 Identify requirements of data entry, storage, output, reporting and presentation requirements
  • 1.4 Apply work organisation strategies and energy and resource conservation techniques
2. Develop a linked spreadsheet solution
  • 2.1 Use spreadsheet design software functions and formulae to meet identified requirements
  • 2.2 Link spreadsheets according to software procedures
  • 2.3 Format cells and use data attributes assigned with cell references, according to task requirements
  • 2.4 Test formulae to confirm output meets task requirements
3. Automate and standardise spreadsheet operation
  • 3.1 Evaluate and identify tasks requiring automation
  • 3.2 Create, use and edit macros to fulfil requirements of task and automate spreadsheet operation
  • 3.3 Develop, edit and use templates and ensure consistency of design and layout according to task requirements
4. Use spreadsheets
  • 4.1 Enter, check and amend data according to organisational and task requirements
  • 4.2 Import and export data between compatible spreadsheets and adjust documents, according to software and organisational procedures
  • 4.3 Use help function to overcome problems with spreadsheet design and production
  • 4.4 Preview, adjust and prepare spreadsheet in accordance with organisational and task requirements
5. Represent numerical data in graphic form and store spreadsheet
  • 5.1 Determine style of graph to meet specified requirements and manipulate spreadsheet data, where required
  • 5.2 Create graphs with labels and titles from numerical data contained in a spreadsheet file
  • 5.3 Name and store spreadsheet in accordance with organisational requirements and exit application
No information
No information
Replaces
State Code National Code Title Type
OAE68 BSBITA411 Design and develop relational databases Unit of competency
AUH20 BSBITU402 Develop and use complex spreadsheets Unit of competency