Course Title: Design and produce spreadsheets

Part A: Course Overview

Program: C4411 Certificate IV in Tertiary Preparation

Course Title: Design and produce spreadsheets

Portfolio: Vocational Education

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.

Important Information:

Please note that this course may have compulsory in-person attendance requirements for some teaching activities.  

To participate in any RMIT course in-person activities or assessment, you will need to comply with RMIT vaccination requirements which are applicable during the duration of the course. This RMIT requirement includes being vaccinated against COVID-19 or holding a valid medical exemption.  

Please read this RMIT Enrolment Procedure as it has important information regarding COVID vaccination and your study at RMIT: https://policies.rmit.edu.au/document/view.php?id=209.  

Please read the Student website for additional requirements of in-person attendance: https://www.rmit.edu.au/covid/coming-to-campus  


Please check your Canvas course shell closer to when the course starts to see if this course requires mandatory in-person attendance. The delivery method of the course might have to change quickly in response to changes in the local state/national directive regarding in-person course attendance.  


Terms

Course Code

Campus

Career

School

Learning Mode

Teaching Period(s)

OFFC5352C

City Campus

TAFE

525T Business & Enterprise

Face-to-Face or Internet

Term1 2022,
Term1 2023,
Term2 2023,
Term1 2024

Course Contact: Theresa Lyford

Course Contact Phone: +61 3 9925 5444

Course Contact Email: theresa.lyford@rmit.edu.au



Course Description

This unit describes the skills and knowledge required to develop spreadsheets through the use of spreadsheet applications.

The unit applies to individuals employed in a range of environments who tend to be personally responsible for designing and working with spreadsheets under minimal supervision. These individuals are generally required to have intermediate knowledge and understanding of a number of spreadsheet applications.

Pre-requisite Courses and Assumed Knowledge and Capabilities

Nil



National Competency Codes and Titles

National Element Code & Title:

BSBTEC302 Design and produce spreadsheets

Elements:

1. Select and prepare resources

2. Plan spreadsheet design

3. Create spreadsheet

4. Produce charts

5. Finalise and present spreadsheets


Learning Outcomes

On successful completion of this course you will have developed and applied the skills and knowledge required to demonstrate competency in the above elements.


Overview of Assessment

Assessment for this course is ongoing throughout the semester. Your knowledge and understanding of course content is assessed through participation in class exercises, oral presentations and through the application of learned skills and insights to your written tasks. Full assessment briefs will be provided and can be found on CANVAS.