Unit of competency
Modification History
Release |
Comments |
Release 1 |
This version first released with BSB Business Services Training Package Version 7.0. |
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.
No licensing, legislative or certification requirements apply to this unit at the time of publication.
Unit Sector
Digital Competence - Technology Use
Elements and Performance Criteria
ELEMENT |
PERFORMANCE CRITERIA |
Elements describe the essential outcomes. |
Performance criteria describe the performance needed to demonstrate achievement of the element. |
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 |
Foundation Skills
This section describes language, literacy, numeracy and employment skills incorporated in the performance criteria that are required for competent performance.
SKILL |
DESCRIPTION |
Reading |
|
Writing |
|
Oral Communication |
|
Numeracy |
|
Self-management |
|
Planning and organising |
|
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.
Links
Companion Volume Implementation Guide is found on VETNet - https://vetnet.gov.au/Pages/TrainingDocs.aspx?q=11ef6853-ceed-4ba7-9d87-4da407e23c10