Course Title: Develop and use complex spreadsheets

Part A: Course Overview

Program: C5236

Course Title: Develop and use complex spreadsheets

Portfolio: SET

Nominal Hours: 20.0

Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.

Course Code




Learning Mode

Teaching Period(s)


City Campus


130T Engineering (TAFE)


Term1 2010,
Term1 2011

Course Contact: Program Manager

Course Contact Phone: +61 3 9925 4468

Course Contact Email:

Course Description

This unit covers the use of spreadsheet software to complete business tasks and produce suitable complex documents. This unit is related to BSBCMN214A Create and use simple spreadsheets

Pre-requisite Courses and Assumed Knowledge and Capabilities


National Competency Codes and Titles

National Element Code & Title:

BSBADM404A Develop and use complex spreadsheets


1. Use safe work practices

2. Develop a linked spreadsheet solution

3. Automate and standardise spreadsheet operation

4. Use spreadsheets

5. Represent numerical data in graphic form

Learning Outcomes

Refer to elements

Overview of Assessment

A person who demonstrates competency in this unit must be able to demonstrate understanding of a broad knowledge base incorporating some theoretical concepts.
• Literacy skills to interpret and evaluate the purposes and uses of various features of spreadsheets; use a variety of strategies for planning and reviewing own work
• Proofreading and editing skills to check for accuracy and consistency of information by consulting additional resources
• Problem solving skills to use processes flexibly and interchangeably
• Numeracy skills to collate and present data; graphs and related references
• Communication skills to follow complex oral instructions when using technology; listen to and interpret complex sequenced instructions
• Keyboarding skills
• Ability to relate to people from a range of social, cultural and ethnic backgrounds and physical and mental abilities