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	Campus	Career	School	Learning Mode	Teaching Period(s)
COSC5946C	City Campus	TAFE	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: angelo.sellan@rmit.edu.au

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

None

National Competency Codes and Titles

National Element Code & Title:	BSBITU402A Develop and use complex spreadsheets
Elements:	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.