Unit of competency details

BSBITU202 - Create and use spreadsheets (Release 1)

Summary

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

Usage recommendation:
Current
Mapping:
MappingNotesDate
Supersedes and is equivalent to BSBITU202A - Create and use spreadsheetsUpdated to meet Standards for Training Packages 24/Mar/2015


Training packages that include this unit

CodeTitleSort Table listing Training packages that include this unit by the Title columnRelease
SIT - Tourism, Travel and Hospitality Training PackageTourism, Travel and Hospitality Training Package 1.0-1.1 
PSP - Public Sector Training PackagePublic Sector Training Package 1.0 
HLT - HealthHealth 2.0-3.1 
CUA - Creative Arts and Culture Training PackageCreative Arts and Culture Training Package 2.0 
CPP07 - Property Services Training PackageProperty Services Training Package 14.4-14.5 
CPC08 - Construction, Plumbing and Services Training PackageConstruction, Plumbing and Services Training Package 9.3-9.4 
BSB - Business Services Training PackageBusiness Services Training Package 1.0-2.0 

Qualifications that include this unit

CodeTitleSort Table listing Qualifications that include this unit by the Title columnRelease
SIT40816 - Certificate IV in Asian CookeryCertificate IV in Asian Cookery 
SIT40716 - Certificate IV in PatisserieCertificate IV in Patisserie 
SIT40616 - Certificate IV in Catering OperationsCertificate IV in Catering Operations 
SIT40516 - Certificate IV in Commercial CookeryCertificate IV in Commercial Cookery 
SIT31116 - Certificate III in Asian CookeryCertificate III in Asian Cookery 
SIT31016 - Certificate III in PatisserieCertificate III in Patisserie 
SIT30916 - Certificate III in Catering OperationsCertificate III in Catering Operations 
SIT30816 - Certificate III in Commercial CookeryCertificate III in Commercial Cookery 
SIT30616 - Certificate III in HospitalityCertificate III in Hospitality 1-2 
SIT30516 - Certificate III in EventsCertificate III in Events 1-2 
Items per page 10 | 20 | 50 | 100
Displaying items 1 - 10 of 36

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 correctly create and use spreadsheets and charts using spreadsheet software.

It applies to individuals who perform a range of routine tasks in the workplace using a limited range of practical skills and fundamental knowledge of creating spreadsheets in a defined context under direct supervision or with limited individual responsibility.

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 Adjust workspace, furniture and equipment to suit own ergonomic, work organisation and work health and safety (WHS) requirements

1.2 Use energy and resource conservation techniques to minimise wastage in accordance with organisational and statutory requirements

1.3 Identify spreadsheet task requirements and clarify with relevant personnel as required

2. Create simple spreadsheets

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

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

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

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

3. Produce simple charts

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

3.2 Create chart using appropriate data range in spreadsheet

3.3 Modify chart type and layout using formatting features

4. Finalise spreadsheets

4.1 Ensure spreadsheet and any accompanying charts are previewed, adjusted and printed in accordance with organisational and task requirements

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

4.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.1, 2.4, 4.1, 4.3

  • Recognises numerical and textual information within a range of resources to determine and complete work according to requirements

Writing

2.1, 2.3, 3.2, 4.1, 4.3

  • Enters and amends routine data into software using a format appropriate to requirements

Oral Communication

1.3, 2.3

  • Listens to short and specific instructions and uses questions to clarify understanding
  • Uses simple mathematical language to confirm and convey requirements

Numeracy

2.1, 2.3, 3.1, 3.2

  • Uses basic mathematical skills to create and apply spreadsheet formulae

Navigate the world of work

1.1-1.3, 2.1, 2.2, 3.1, 4.1-4.3

  • Recognises, understands and adheres to legislative and organisational requirements in undertaking own work

Interact with others

1.3

  • Recognises purpose of various communications directly relevant to own role and clarifies as required

Get the work done

1.3, 2.1-2.4, 3.1-3.3, 4.1-4.3

  • Uses key software features and functions in performing specific work tasks

Unit Mapping Information

Code and title  

current version 

Code and title 

previous version 

Comments 

Equivalence status 

BSBITU202 Create and use spreadsheets

BSBITU202A Create and use 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:

  • produce documents following correct ergonomic, conservation, organisational and statutory requirements
  • consult with appropriate personnel as required
  • adhere to organisational style and presentation requirements
  • refer to online help function and user documentation to rectify document problems
  • create and modify simple charts
  • follow designated timelines and ensure high accuracy when preparing documents
  • demonstrate ability to prevent data loss and damage.

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:

  • demonstrate knowledge of how to format workplace documents
  • describe organisational requirements for ergonomic standards, work periods and breaks, and conservation techniques
  • outline organisational guidelines on spreadsheet manipulation and processing
  • explain purpose and range of use of spreadsheet functions.

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 technology
  • organisational policies and procedures
  • relevant legislation
  • user manuals
  • relevant workplace documentation and resources
  • industry software packages.

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.