Course Title: Design and produce spreadsheets
Part B: Course Detail
Teaching Period: Term2 2025
Course Code: OFFC5352C
Course Title: Design and produce spreadsheets
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.
School: 525T Business & Enterprise
Campus: City Campus
Program: C4411 - Certificate IV in Tertiary Preparation
Course Contact: Theresa Lyford
Course Contact Phone: +61 3 9925 5444
Course Contact Email: theresa.lyford@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
Michelle Royal-Hebblewhite (till 1 September 2025)
George Hernandez
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.
Pre-requisites and Co-requisites
Nil
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.
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title: |
BSBTEC302 Design and produce spreadsheets |
Element: |
1. Select and prepare resources |
Performance Criteria: |
|
Element: |
2. Plan spreadsheet design |
Performance Criteria: |
|
Element: |
3. Create spreadsheet |
Performance Criteria: |
|
Element: |
4. Produce charts |
Performance Criteria: |
|
Element: |
5. Finalise and present spreadsheets |
Performance Criteria: |
|
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.
Details of Learning Activities
A range of learning activities are provided in this course. These include collaborative classroom-based activities and online self-paced activities. Classroom: The collaborative classroom-based activities will include discussion, problem solving activities and opportunities to practice your skills in a simulated workplace environment. We expect you to participate and contribute in all scheduled learning activities.
Pre-and Post-Class: This is online, by logging on to your Canvas (Learning Management System) course and includes required pre-class reading and activities and post-class exercises and activities. Other self-paced activities will be delivered through various technology platforms. These may include your contribution to discussion threads, reflective journals, quizzes and interactive sessions.
Sessions: There are one face-to-face classroom sessions (tutorials) and workshop for this unit each week. There are additional activities to support learning and research.
Teaching Schedule
Semester 2, 2025 |
||
|
This Course is clustered and contains the following 2 Units of Competency: BSBTEC401 Design and produce complex text documents (OFFC5347C) and BSBTEC302 Produce Spreadsheets (OFFC5352C) | ||
|
Week |
Topics |
Remarks |
|
1 Week Starting 21 July |
Introduction to the course Introduction, library portal and writing Professional reports. |
Meetings will run each session where we identify Assessment tasks requirements, assign roles and responsibilities and use Work Integration Learning within the class space. |
|
2 Week Starting 28 July |
Law and Business - Occupational and Work Health and Safety (OHS Act 2004) · Privacy Act 1988 · Equal Opportunity Act 2004 · Disability discrimination Act 1992 · Environment Protection and Biodiversity Conservation Act 1999 · Industrial Relations Reforms Act 1993 · Fair Work (FW Act 2009) |
Meetings will run each session where we identify Assessment tasks requirements, assign roles and responsibilities and use Work Integration Learning within the class space. Set Up Your Work Area / Workstation Ergonomically and Safely |
|
3 Week Starting 4 August |
Law and Business - Occupational and Work Health and Safety (OHS Act 2004) · Privacy Act 1988 · Equal Opportunity Act 2004 · Disability discrimination Act 1992 · Environment Protection and Biodiversity Conservation Act 1999 · Industrial Relations Reforms Act 1993 · Fair Work (FW Act 2009) |
Meetings will run each session where we identify Assessment tasks requirements, assign roles and responsibilities and use Work Integration Learning within the class space. Set Up Your Work Area / Workstation Ergonomically and Safely |
|
4 Week Starting 11 August |
Introduction to MS Word · Table of contents · Referencing and bibliography · Header, footer · Check box, drop down box · Help function |
Meetings will run each session where we identify Assessment tasks requirements, assign roles and responsibilities and use Work Integration Learning within the class space. Group presentations- 20 min each |
|
5 Week Starting 18 August |
Group evaluation and peer review of each 'employee's recommendations. Assigned Representatives will check Work Area / Workstation Ergonomically and Safely. Students demonstrate how to ergonomically apply exercise and set breaks to prevent injuries. |
Meetings will run each session where we identify Assessment tasks requirements, assign roles and responsibilities and use Work Integration Learning within the class space. |
|
6 Week Starting 25 August |
Group evaluation and peer review of each 'employee's recommendations. Assigned Representatives will check Work Area / Workstation Ergonomically and Safely. Students demonstrate how to ergonomically apply exercise and set breaks to prevent injuries. |
Style Guide: AT 1 due |
|
Mid-semester Break – 1 – 5 September 2025 | ||
|
7 Week Starting 8 September |
Meetings will run each session where we identify Assessment tasks requirements, assign roles and responsibilities and use Work Integration Learning within the class space. This meeting evaluated the requirements of Assessment Task 2 Solving problems with the Help function. Integrating advanced functions into your MS suite skills. |
Commence Assessment task 2 · Form, FAX · Flyer, Memo · Letter · Budget · Help Solution 2 |
|
8 Week Starting 15 September |
Solving problems with the Help function. Integrating advanced functions into your MS suite skills. |
|
|
9 Week Starting 22 September |
Working on AT2 completion |
Meetings will run each session where we identify Assessment tasks requirements, assign roles and responsibilities and use Work Integration Learning within the class space. AT 2: Complex document Submit Task 2 |
|
10 Week Starting 29 September |
Meetings will run each session where we identify Assessment tasks requirements, assign roles and responsibilities and use Work Integration Learning within the class space. This meeting evaluated the requirements of Assessment Task 3 Knowledge check MS Excel |
Skills check- Practical task using data of peers to present in class (non assessed) |
|
11 Week Starting 6 October |
Introduction to MS Excel · Data entry · Insert Rows and Columns · Sorting data |
Meetings will run each session where we identify Assessment tasks requirements, assign roles and responsibilities and use Work Integration Learning within the class space. This meeting evaluated the requirements of Assessment Task 3 |
|
12 Week Starting 13 October |
Introduction to MS Excel · Freeze pane · Tabs, colours · Help function |
|
|
13 Week Starting 20 October |
Calculations in Excel · Add, Multiply, divide · Aligning data (Right, Left, Centre) · Date, Day · Inserting currency, decimal points · Pie charts, Histograms Create a budget using Excel, P&L statement |
AT 3: Produce Spreadsheets Submit Complete and discuss with your teacher in class to allow for Resubmission attempts in class time. |
|
14 Week Starting 27 October |
Excel Functions and Formulas Adding new sheets using eye for detail Crosschecking and exporting documents to present in a meeting |
AT 3: Produce Spreadsheets Submit (FINAL) Complete and discuss with your teacher in class to allow for Resubmission attempts in class time. |
|
15 Week Starting 3 November |
Resubmissions Attempt 2 |
One on one Assessment reattempts if approved by Manager |
|
16 Week Starting 10 November |
One on one Assessment reattempts if approved by Manager |
No class, no extensions – end of term- END of course! |
Learning Resources
Prescribed Texts
References
Other Resources
All teaching and learning materials are available on Canvas.
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.
Assessment Tasks
Assessment Task 1 - Produce a Flyer With Logo
Summary and purpose:
Completing this task will allow you to demonstrate your ability to design and produce a document using graphics elements, including grouping and design principles. You will demonstrate their knowledge of general computer usage for an ergonomic workstation, breaks and exercises, and conservation procedures for an office.
Assessment Task 2 - Produce a Report
Summary and purpose:
Completing this task will allow you to demonstrate your ability to design and produce a report that includes structure and layout elements, such as Section Breaks, Tables, Headers and Footers; complex functions, such as and Table of Contents; formatting and graphics elements, such as Charts; and text formatting. You will demonstrate these activities according to organisational and task requirements by clarifying specifications and timelines with stakeholders and using the Stingray Corporation Style Guide.
Assessment Task 3 - Produce a Letter
Summary and purpose:
Completing this task will allow you to demonstrate their ability to design and produce a business letter that includes a graphics element, such as the company logo; complex functions, such as a Mail Merge with a Data Source. You will demonstrate these activities according to organisational and task requirements by using the Stingray Corporation Style Guide.
Assessment Task 4 - Produce a Letter
Summary and purpose:
Completing this task will allow you to demonstrate your ability to design and produce a form that includes structure and layout elements, such as Page Layout and borders; style elements such as Colour Fill; graphics elements, such as the company logo; complex functions, such as Fields and Controls, such as a Drop-Down List, Date, Check Box, Formulas, and Password Protection; formatting elements, such as Currency Format, and Printing functions. You will demonstrate these activities according to organisational and task requirements by using the Stingray Corporation Style Guide.
Assessment Matrix
The assessment matrix maps of all the assessment requirements are located on the Canvas shell.
Other Information
Submission Requirements
You should:
• Ensure that you submit assessments on or before the due date via Canvas.
• Always retain a copy of your assessment tasks. (hard copy and soft copy)
• When you submit work for assessment at RMIT University you need to use the Assessment task document that includes
a declaration and statement of authorship.
• Each page of your assessment should include a footer with your name, student number, the title of the assessment,
unit code and title and page numbers.
Late Submission Procedures
You are required to submit assessment items and/or ensure performance based assessment is completed by the due dates.
Extension of Time. If you are prevented from submitting an assessment item on time by circumstances outside your control, you may apply in advance to your teacher for an extension to the due date of up to seven calendar days.
More information: https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/assessment/extensions-of-time-for-submission-of-assessable-work
Form to use is found in the section "How to apply."
Special Consideration. Where more than seven days is needed, you must apply for Special Consideration. Applications for special consideration must be submitted no later than two working days after the assessment task deadline or scheduled examination.
More information: https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/assessment/special-consideration
Resubmission (VE Programs)
If you are found to be Not Yet Competent in a course assessment task (or you do not submit the assessment tasks/attend the assessment) you will be allowed one resubmission. Your teacher will provide feedback regarding what you need to do to improve and will set a new deadline for the resubmission in Canvas.
If you are still not meeting the assessment requirements you must apply to your Program Manager in writing outlining the steps you will take to demonstrate competence in your course. Your submission will be considered by the Program Team and you will be advised of the outcome as soon as possible.
Adjustments to Assessment
In certain circumstances students may be eligible for an assessment adjustment.
More information: https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/assessment/adjustments-to-assessment
Marking Guide (Competency):
You must demonstrate that you have all the required skills/knowledge/elements in the unit of competency you are studying. You will receive feedback on each assessment task that will inform you about your progress and how well you are performing.
- CA Competency Achieved
- NYC Not Yet Competent
Course Overview: Access Course Overview