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.