Course Title: Produce spreadsheets

Part A: Course Overview

Program: C3216

Course Title: Produce spreadsheets

Portfolio: BUS

Nominal Hours: 35.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)

COSC5942C

City Campus

TAFE

650T TAFE Business

Face-to-Face or Workplace

Term1 2009,
Term1 2010

Course Contact: Janet McDonald

Course Contact Phone: +61 3 99255134

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


Course Description

This course covers the skills required to create spreadsheets that encompass formatting, formulae and charts in order to complete business tasks.


Pre-requisite Courses and Assumed Knowledge and Capabilities

There are no pre-requisites or co-requisites for this course.



National Competency Codes and Titles

National Element Code & Title:

BSBITU304A Produce spreadsheets

Elements:

Create spreadsheet

Finalise spreadsheets

Plan spreadsheet design

Produce simple charts

Select and prepare resources


Learning Outcomes


Overview of Assessment

Students must demonstrate an understanding of all elements of competency to be deemed competent.

Assessment methods have been designed to measure achievements of each element of competency in a flexible manner. Assessments will incorporate a variety of  methods such as class exercises, practical projects, tests and demonstration of techniques in a workplace or the Virtual Enterprise. 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 and situated learning in the Virtual Enterprise in order to develop competency including underpinning skills and knowledge.