Course Title: Develop and use complex spreadsheets

Part A: Course Overview

Program: C4114

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)

COSC5884C

City Campus

TAFE

650T TAFE Business

Face-to-Face

Term1 2008,
Term2 2008,
Term1 2009

Course Contact: Janet Mc Donald

Course Contact Phone: +61 3 9925 5134

Course Contact Email: janet.mcdonald@rmit.edu.au


Course Description

This course covers the use of spreadsheet software to complete business tasks and produce usable complex documents.


Pre-requisite Courses and Assumed Knowledge and Capabilities

None



National Competency Codes and Titles

National Element Code & Title:

BSBADM404A Develop and use complex spreadsheets

Elements:

Develop a linked spreadsheet solution

Automate and standardise spreadsheet operation

Represent numerical data in graphic form

Use safe work practices

Use spreadsheets


Learning Outcomes


Overview of Assessment

Students must demonstrate an understanding of all elements of a particular competency to be deemed competent. Assessment methods have been designed to measure achievements of each competency in a flexible manner. Assessments will incorporate a variety of methods: class exercises, homework, practical project and tests. Students are advised that they are likely to be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant competency standards are being met. In addition to the assessments, formative feedback is provided to the students throughout the duration of the course

Learning activities will include class-based discussions, exercises, reading and reflection on various activities, in order to develop competency including the underpinning skills and knowledge.