Course Title: Develop and use complex spreadsheets
Part A: Course Overview
Program: C5237 Diploma of Spatial Information Services
Course Title: Develop and use complex spreadsheets
Portfolio: SEH Portfolio Office
Nominal Hours: 20
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 Vocational Engineering |
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 usable 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 provide evidence of:
• Successful operation of linked spreadsheets
• Knowledge and application of advanced spreadsheet features
• Formatting and design on the presentation and readability
• 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