Course Title: Develop and use complex spreadsheets
Part A: Course Overview
Program: C5236
Course Title: Develop and use complex spreadsheets
Portfolio: SET
Nominal Hours: 20.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) |
COSC5956C |
City Campus |
TAFE |
130T Engineering (TAFE) |
Face-to-Face |
Term1 2010,
Term1 2011 |
Course Contact: Program Manager
Course Contact Phone: +61 3 9925 4468
Course Contact Email: engineering-tafe@rmit.edu.au
Course Description
This unit covers the use of spreadsheet software to complete business tasks and produce suitable complex documents. This unit is related to BSBCMN214A Create and use simple spreadsheets
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: |
1. Use safe work practices |
2. Develop a linked spreadsheet solution |
|
3. Automate and standardise spreadsheet operation |
|
4. Use spreadsheets |
|
5. Represent numerical data in graphic form |
Learning Outcomes
Refer to elements
Overview of Assessment
A person who demonstrates competency in this unit must be able to demonstrate understanding of a broad knowledge base incorporating some theoretical concepts.
• Literacy skills to interpret and evaluate the purposes and uses of various features of spreadsheets; use a variety of strategies for planning and reviewing own work
• Proofreading and editing skills to check for accuracy and consistency of information by consulting additional resources
• Problem solving skills to use processes flexibly and interchangeably
• Numeracy skills to collate and present data; graphs and related references
• Communication skills to follow complex oral instructions when using technology; listen to and interpret complex sequenced instructions
• Keyboarding skills
• Ability to relate to people from a range of social, cultural and ethnic backgrounds and physical and mental abilities