Course Title: Develop and use complex spreadsheets

Part A: Course Overview

Program: C5317

Course Title: Develop and use complex spreadsheets

Portfolio: BUS

Nominal Hours: 50.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


650T Vocational Business Education

Distance / Correspondence or Face-to-Face or Internet or Workplace

Term1 2013,
Term1 2014,
Term2 2014,
Term1 2015,
Term2 2015

Course Contact: Michael Elliot

Course Contact Phone: +61 3 9925 5519

Course Contact Email:

Course Description

This unit describes the performance outcomes, skills and knowledge required to use spreadsheet software to complete business tasks and to produce complex documents.

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

Pre-requisite Courses and Assumed Knowledge and Capabilities


National Competency Codes and Titles

National Element Code & Title:

BSBITU402A Develop and use complex spreadsheets


1. Prepare to develop spreadsheet

2. Develop a linked spreadsheet solution

3. Automate and standardise spreadsheet operation

4. Use spreadsheets

5. Represent numerical data in graphic form

Learning Outcomes

Overview of Assessment

Assessment may incorporate a variety of methods including technical requirements documentation, homework, assignments, group and/or individual projects, in class exercises, written and practical tests, problem solving exercises, presentations, direct observation of actual and simulated work practice, presentation of a portfolio of evidence which may comprise documents, and/or photographs and/or video and audio files, review of products produced through work-based or course activities.
You are advised that you are likely to be asked to personally demonstrate your assessment work to your teacher to ensure that the relevant competency standards are being met. You will be provided with feedback throughout the course to check their progress.