Course Title: Produce spreadsheets
Part A: Course Overview
Program: C4366 Certificate IV in Accounting
Course Title: Produce spreadsheets
Portfolio: BUS Portfolio Office
Nominal Hours: 35
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) |
COSC6190C |
City Campus |
TAFE |
650T Vocational Business Education |
Face-to-Face or Internet |
Term1 2016, Term2 2016 |
Course Contact: Ben Sethia
Course Contact Phone: +61 3 9925 5982
Course Contact Email: ben.sethia@rmit.edu.au
Course Description
This unit describes the skills and knowledge required to develop spreadsheets through the use of spreadsheet software.
It applies to individuals employed in a range of environments who tend to be personally responsible for designing and working with spreadsheets under minimal supervision.
Pre-requisite Courses and Assumed Knowledge and Capabilities
None
National Competency Codes and Titles
National Element Code & Title: |
BSBITU304 Produce spreadsheets |
Elements: |
1. Select and prepare resources 2. Plan spreadsheet design 3. Create spreadsheet 4. Produce simple charts 5. Finalise spreadsheet |
Learning Outcomes
Overview of Assessment
In order to achieve competency in this unit, you must provide:
Performance Evidence
Evidence of the ability to:
- design spreadsheets that address a range of data and organisational requirements
- use software functions, graphics and support materials to create spreadsheets
- apply knowledge of formatting requirements for workplace documents
Knowledge Evidence
To complete the unit requirements safely and effectively, the individual must:
- describe formatting requirements of workplace documents
- identify organisational guidelines on spreadsheet design and use
- explain organisational requirements for ergonomic standards, work periods and breaks, and conservation techniques
Assessment Conditions
Assessment must be conducted in a safe environment where evidence gathered where evidence gathered demonstrates consistent performance of typical activities experienced in the information and communications technology – IT use field of work and include access to:
- industry software packages
- computer user information
- relevant legislation and codes of practice
- organisational policies and procedures
- relevant workplace documentation and resources.
You are advised that you are likely to be asked to personally demonstrate your assessment work to your teacher to ensure that the relevant competency standards are being met.
Feedback
Feedback will be provided throughout the semester in class and/or online discussions. You are encouraged to ask and answer questions during class time and online sessions so that you can obtain feedback on your understanding of the concepts and issues being discussed. Finally, you can email or arrange an appointment with your teacher to gain more feedback on your progress.
You should take note of all feedback received and use this information to improve your learning outcomes and final performance in the course.