Course Title: Develop and use complex spreadsheets

Part A: Course Overview

Program: C5261

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 TAFE Business

Face-to-Face or Internet or Workplace

Term2 2012

Course Contact: Michael Elliot

Course Contact Phone: +61 3 9925 5519

Course Contact Email:

Course Description

The unit applies to individuals employed in a range of work environments who require skills in the creation of complex spreadsheets to store and retrieve data. They may work as individuals providing administrative support within an enterprise, or may be independently responsible for designing and working with spreadsheets relevant to their own work roles.

Pre-requisite Courses and Assumed Knowledge and Capabilities

There are no pre-requisites to this course but it is co-delivered with:

FNSFPL501A Comply w financial planning practice ethical & operational guidelines & regulations
FNSINC401A Apply principles of Professional Practice to work in Fin Services Industry
FNSFPL506A Determine client requirements and expectations
FNSCUS505A Determine client requirements and expectations
FNSCUS506A Record and implement client instructions

National Competency Codes and Titles

National Element Code & Title:

BSBITU402A Develop and use complex spreadsheets


Automate and standardise spreadsheet operation

Develop a linked spreadsheet solution

Prepare to develop spreadsheet

Learning Outcomes

Overview of Assessment

Assessment may incorporate a variety of methods including written tests, a group assignment and final assessment.

Tests are closed book and consist of multiple choice, practical exercises and short answer questions.

The group assignment requires students to research the role and function of a financial institution or a major contemporary issue relating to the financial system and of concern to consumers.

Students are advised that they are likely to be asked to personally demonstrate their assessment work to their teacher to ensure the relevant competency standards are being met. Students will be provided with feedback throughout the course to check their progress.