Unit of competency details

BSBITU304 - Produce spreadsheets (Release 1)

Summary

Releases:
ReleaseStatusRelease date
1 1 (this release)Current 25/Mar/2015

Usage recommendation:
Superseded
Mapping:
MappingNotesDate
Supersedes and is equivalent to BSBITU304A - Produce spreadsheetsUpdated to meet Standards for Training Packages 24/Mar/2015
Is superseded by and equivalent to BSBITU314 - Design and produce spreadsheets 26/Sep/2018


Training packages that include this unit

CodeTitleSort Table listing Training packages that include this unit by the Title columnRelease
HLT - HealthHealth 2.0-4.1 
FNS - Financial Services Training PackageFinancial Services Training Package 1.0-3.1 
DEF - Defence Training PackageDefence Training Package 2.0-2.1 
CUA - Creative Arts and Culture Training PackageCreative Arts and Culture Training Package 2.0,3.0 
BSB - Business Services Training PackageBusiness Services Training Package 1.0-2.0 
AHC - Agriculture, Horticulture and Conservation and Land Management Training PackageAgriculture, Horticulture and Conservation and Land Management Training Package 1.0-2.0 

Qualifications that include this unit

CodeTitleSort Table listing Qualifications that include this unit by the Title columnRelease
HLT37415 - Certificate III in Pathology AssistanceCertificate III in Pathology Assistance 1-2 
FNS30615 - Certificate III in Insurance BrokingCertificate III in Insurance Broking 1-2 
FNS30317 - Certificate III in Accounts AdministrationCertificate III in Accounts Administration 
FNS30315 - Certificate III in Accounts AdministrationCertificate III in Accounts Administration 1-3 
FNS30115 - Certificate III in Financial ServicesCertificate III in Financial Services 1-5 
DEF40817 - Certificate IV in Defence Financial AdministrationCertificate IV in Defence Financial Administration 
CUA40415 - Certificate IV in Live Production and Technical ServicesCertificate IV in Live Production and Technical Services 1-2 
CUA30915 - Certificate III in Music IndustryCertificate III in Music Industry 
CUA30615 - Certificate III in Arts AdministrationCertificate III in Arts Administration 
CUA30415 - Certificate III in Live Production and ServicesCertificate III in Live Production and Services 1-2 
Items per page 10 | 20 | 50 | 100
Displaying items 1 - 10 of 17

Classifications

SchemeCodeClassification value
ASCED Module/Unit of Competency Field of Education Identifier 080905 Practical Computing Skills  

Classification history

SchemeCodeClassification valueStart dateEnd date
ASCED Module/Unit of Competency Field of Education Identifier 080905 Practical Computing Skills  30/Jul/2015 
The content being displayed has been produced by a third party, while all attempts have been made to make this content as accessible as possible it cannot be guaranteed. If you are encountering issues following the content on this page please consider downloading the content in its original form

Unit Of competency

Modification History

Release 

Comments 

Release 1

This version first released with BSB Business Services Training Package Version 1.0.

Application

This unit describes the skills and knowledge required to develop spreadsheets through the use of spreadsheet software.

It applies to individuals employed in a range of environments who tend to be personally responsible for designing and working with spreadsheets under minimal supervision.

No licensing, legislative or certification requirements apply to this unit at the time of publication.

Unit Sector

Information and Communications Technology – IT 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. Select and prepare resources

1.1 Adhere to ergonomic, work organisation and occupational health and safety requirements

1.2 Use energy and resource conservation techniques to minimise wastage

1.3 Identify spreadsheet task requirements in relation to data entry, storage, output and presentation

2. Plan spreadsheet design

2.1 Ensure spreadsheet design suits purpose, audience and information requirements of task

2.2 Ensure spreadsheet design enhances readability and appearance, and meets organisational and task requirements for style and layout

2.3 Use style sheets and automatic functions to ensure consistency of design and layout

3. Create spreadsheet

3.1 Ensure data is entered, checked and amended to maintain consistency of design and layout, in accordance with organisational and task requirements

3.2 Format spreadsheet using software functions to adjust page and cell layout to meet information requirements, in accordance with organisational style and presentation requirements

3.3 Ensure formulae are tested and used to confirm output meets task requirements, in consultation with appropriate personnel as required

3.4 Use manuals, user documentation and online help to overcome problems with spreadsheet design and production

4. Produce simple charts

4.1 Select chart type and design that enables valid representation of numerical data, and meets organisational and task requirements

4.2 Create charts using appropriate data range in spreadsheet

4.3 Modify chart type and layout using formatting features

5. Finalise spreadsheets

5.1 Preview, adjust and print spreadsheet and any accompanying charts, in accordance with task requirements

5.2 Ensure data input meets designated timelines and organisational requirements for speed and accuracy

5.3 Name and store spreadsheet in accordance with organisational requirements and exit application without data loss/damage

Foundation Skills

This section describes language, literacy, numeracy and employment skills incorporated in the performance criteria that are required for competent performance.

Skill 

Performance 

Criteria 

Description 

Reading

2.2, 3.1-3.4, 5.1

  • Recognises and interprets numerical and textual information to determine organisational and task requirements

Writing

2.1, 3.1-3.3, 4.2, 4.3, 5.1-5.3

  • Inputs numerical and key reporting information when creating and finalising spreadsheets and uses format, layout, style guides and standard naming conventions to organise data according to purpose and audience

Oral Communication

3.3

  • Participates in exchange of information to determine whether formulae utilised produce result required

Numeracy

4.1, 4.2

  • Uses mathematical equations to create simple formulae and validate numerical data

Navigate the world of work

1.1-1.3, 2.1-2.3, 3.1-3.3, 4.1, 5.1-5.3

  • Recognises and follows explicit and implicit protocols and meets expectations associated with own role

Interact with others

3.3

  • Collaborates with others to achieve joint outcomes

Get the work done

2.1-2.3, 3.1-3.4, 4.1-4.3, 5.1-5.3

  • Uses advanced features within applications to address routine and complex work tasks

Unit Mapping Information

Code and title  

current version 

Code and title 

previous version 

Comments 

Equivalence status 

BSBITU304 Produce spreadsheets

BSBITU304A Produce spreadsheets

Updated to meet Standards for Training Packages

Equivalent unit

Links

Companion Volume implementation guides are found in VETNet - https://vetnet.education.gov.au/Pages/TrainingDocs.aspx?q=11ef6853-ceed-4ba7-9d87-4da407e23c10

 

Assessment requirements

Modification History

Release 

Comments 

Release 1

This version first released with BSB Business Services Training Package Version 1.0.

Performance Evidence

Evidence of the ability to:

  • design spreadsheets that address a range of data and organisational requirements
  • use software functions, graphics and support materials to create spreadsheets
  • apply knowledge of formatting requirements for workplace documents.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

Knowledge Evidence

To complete the unit requirements safely and effectively, the individual must:

  • describe formatting requirements of workplace documents
  • identify organisational guidelines on spreadsheet design and use
  • explain organisational requirements for ergonomic standards, work periods and breaks, and conservation techniques.

Assessment Conditions

Assessment must be conducted in a safe environment where evidence gathered demonstrates consistent performance of typical activities experienced in the information and communications technology – IT use field of work and include access to:

  • industry software packages
  • computer user information
  • relevant legislation and codes of practice
  • organisational policies and procedures
  • relevant workplace documentation and resources.

Assessors must satisfy NVR/AQTF assessor requirements.

Links

Companion Volume implementation guides are found in VETNet - https://vetnet.education.gov.au/Pages/TrainingDocs.aspx?q=11ef6853-ceed-4ba7-9d87-4da407e23c10

Training component details
The following details are displayed for each different NRT:-

Training packages

- Training package details
- Training package components

Qualifications

- Qualification details
- Qualification components

Accredited courses

- Accredited course details

Modules

- Module details

Units of competency

- Units of competency details
- Unit components

Skill sets

- Skill set details
- Skill set components

Click on the Export link to export the NRT information to MS Word or PDF.

Click on the Manage notification link to create or change a notification for this NRT.

When selecting the Display history check box a set of tables will appear displaying a log of historical values describing what has changed and when over time.

If you have access to make changes to an NRT, click on the Edit link on the upper right hand side of the summary box.