Course Title: Develop and use complex spreadsheets

Part A: Course Overview

Program: C4325

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

Term2 2015

Course Contact: Angelo Sellan

Course Contact Phone: +61 3 9925 5460

Course Contact Email:

Course Description

Spreadsheets are an indespensible tool in the financial services industry, it is frequently an requirement in any job application to have some knowledge and experience in the use of spreadsheets. In this course you learn to be competent in devoloping and using complex spreadsheets.

Pre-requisite Courses and Assumed Knowledge and Capabilities


National Competency Codes and Titles

National Element Code & Title:

BSBITU402A Develop and use complex spreadsheets


Prepare and develop spreadsheets

Develop a linked spreadsheet solution

Automate and standardise spreadsheet opreation

Use spreadsheets

Represent numerical data in graphical form

Learning Outcomes

Overview of Assessment

Online Test

This online assessment consists of multiple choice questions relating to ergonomic requirements, work organisation strategies and energy and resource conservation techniques and relevant legislation. The assessment may be completed online.

Portfolio of evidence

Students will complete seven (7) practical exercises during the semester. You may also be required to demonstrate how you have completed tasks via questioning and observation if required.

All the portfolio of evidence exercises will be derived from the prescribed text for this course: Tilde skills Develop & Use Complex Spreadsheets 2nd Edition. It is therefore imperative that learners avail themselves of this text.