Course Title: Develop and use complex spreadsheets

Part A: Course Overview

Program: C5236 Diploma of Surveying

Course Title: Develop and use complex spreadsheets

Portfolio: SEH Portfolio Office

Nominal Hours: 50

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 Vocational Engineering

Face-to-Face or Internet

Term1 2012,
Term1 2013

Course Contact: Program Manager

Course Contact Phone: +61 3 9925 4468

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.

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

Refer to elements

Overview of Assessment

Evidence of the following is essential:

- developing complex spreadsheets
- developing graphical representation of data contained in spreadsheets.