Course Title: Design and produce spreadsheets
Part B: Course Detail
Teaching Period: Term1 2022
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
Lorraine Hall
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: |
1.1 Identify task purpose and audience 1.2 Identify task requirements according to data entry, storage, output, timeline and presentation format 1.3 Select most appropriate application to produce spreadsheet, according to available resources and organisational policies and procedures |
Element: |
2. Plan spreadsheet design |
Performance Criteria: |
2.1 Design spreadsheet design to suit purpose, audience and information requirements of task 2.2 Confirm spreadsheet is designed to enhance readability and appearance, and is in accordance with organisational and task requirements 2.3 Use available application functions and confirm consistency of design and layout, adhering to organisational and task requirements |
Element: |
3. Create spreadsheet |
Performance Criteria: |
3.1 Enter data, check and amend to maintain consistency of design and layout, in accordance with organisational and task requirements 3.2 Format spreadsheet using application functions, according to organisational policies and procedures and presentation requirements 3.3 Consult with relevant stakeholders and confirm formulae are tested and output meets task requirements 3.4 Use required help functions and action issues as required |
Element: |
4. Produce charts |
Performance Criteria: |
4.1 Select chart type and design that offers analysis of numerical data, and meets organisational and task requirements 4.2 Create charts using required data range in spreadsheet 4.3 Modify chart type and layout using formatting features, adhering to organisational and task requirements |
Element: |
5. Finalise and present spreadsheets |
Performance Criteria: |
5.1 Review and edit final spreadsheet and accompanying charts, and prepare for delivery according to task requirements 5.2 Deliver document to required stakeholders according to organisational requirements, policies and procedures 5.3 Name and store spreadsheet according to organisational requirements and exit application |
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
This unit is clustered with BSBTEC401 - Design and produce complex text documents
A range of learning activities are planned for this course including self-paced and collaborative classroom based activities.
The collaborative classroom based activities will include group discussion, group problem solving activities and opportunities to practice your skills in a simulated/real workplace environment.
Teaching Schedule
WEEK | TOPIC | ACTIVITIES | ASSESSMENT |
1 10/02/22 |
RMIT Welcome and Orientation Course Induction Course Assessments Course Resources General Computer Operation
|
Read all introductory modules Watch the Welcome video Note your supports Do the exercising and breathing for office workers |
Download and read the assessments and requirements Note the due dates of your assessment in your calendar Download Course Resources |
2 17/02/22 |
General Computer Operation
|
Do the pre-class activities Do the "How to" exercises Do the after-class activities |
Set Up Your Work Area / Workstation Check the after-class activities for assessment questions that can be completed |
3 24/02/22 |
General Computer Operation
|
Do the pre-class activities Do the "How to" exercises Do the after-class activities |
Check the after-class activities for assessment questions that can be completed |
4 03/03/22 |
General Computer Operation
|
Do the pre-class activities Do the "How to" exercises Do the after-class activities |
Do the pre-class activities Do the after-class activities |
5 10/03/22 |
Document Basics
|
Do the pre-class activities Do the "How to" exercises Do the after-class activities |
Check the after-class activities for assessment questions that can be completed Draft Assessment Task 1 - Workstation Ergonomics and Prepare Style Guide Document Assessments Information includes:
|
6 17/03/22 |
Word-Processing Basics
|
Do the pre-class activities Do the "How to" exercises Do the after-class activities |
Submit Assessment Task 1 on 20th March 2022- Workstation Ergonomics and Prepare Style Guide Document |
7 24/03/22 |
Word-Processing Basics
|
Do the pre-class activities Do the "How to" exercises Do the after-class activities |
Check the after-class activities for assessment questions that can be completed |
8 31/03/22 |
Complex Word Processing
|
Do the pre-class activities Do the "How to" exercises Do the after-class activities |
Check the after-class activities for assessment questions that can be completed |
9 07/04/22 |
Complex Word Processing
|
Do the pre-class activities Do the "How to" exercises Do the after-class activities |
Check the after-class activities for assessment questions that can be completed Over the next 6 weeks, draft Assessment Task 2 - Develop Complex Documents:
Assessments Information includes:
|
Mid-semester break (14th April - 20th April 2022) | |||
10 21/04/22 |
Complex Word Processing
|
Do the pre-class activities Do the "How to" exercises Do the after-class activities |
Check the after-class activities for assessment questions that can be completed |
11 28/04/22 |
Using Spreadsheets - Excel
|
Do the pre-class activities Do the "How to" exercises Do the after-class activities |
Check the after-class activities for assessment questions that can be completed |
12 05/05/22 |
Using Spreadsheets - Excel
|
Do the pre-class activities Do the "How to" exercises Do the after-class activities |
Check the after-class activities for assessment questions that can be completed |
13 12/05/22 |
Using Spreadsheets - Excel
|
Do the pre-class activities Do the "How to" exercises Do the after-class activities |
Check the after-class activities for assessment questions that can be completed |
14 19/05/22 |
Using Spreadsheets - Excel
|
Do the pre-class activities Do the "How to" exercises Do the after-class activities |
Check the after-class activities for assessment questions that can be completed Assessment 2 - Develop Complex Documents - Due Date 21st May 2022 |
15 26/05/22 |
Using Spreadsheets - Excel
|
Do the pre-class activities Do the "How to" exercises Do the after-class activities |
Check the after-class activities for assessment questions that can be completed Finalize Assessment Task 3 - Using Excel for Business |
16 02/06/22 |
Assessment Workshop
|
Do the pre-class activities Do the after-class activities |
Submit Assessment Task 3- Produce Spreadsheets due date 5th June 2022 |
Learning Resources
Prescribed Texts
References
Other Resources
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 - Workstation Ergonomics and Prepare Style Guide Document
This is Assessment Task 1 of 3 that you need to be complete. Both assessments need to be completed satisfactorily in order to be deemed competent for this unit.
Completing this task will allow you to demonstrate your ability to design and prepare an organisational Style Guide utilising a range of complex word processing techniques. You will also be assessed on your ability to apply ergonomics to your workstation and the workplace.
The assessment has two parts:
Part A – Ergonomics/setting up your workstation
Part B – Develop a Style Guide for the organisation (Stingray)
Assessment Task 2 - Develop Complex Documents
This is Assessment Task 2 of 3 that you need to be complete. Both assessments need to be completed satisfactorily in order to be deemed competent for this unit.
This assessment task will assess your skills and knowledge in creating complex documents that are designed to be added to the Style Guide they created in the previous assessment.
You are required to read the case study provided and continue with following the instructions. You will create four templates that are designed to go with the Style Guide created in Assessment Task 1.
Assessment Task 3 - Produce spreadsheets
This is Assessment Task 3 of 3 that students need to be complete. All three assessments need to be completed satisfactorily to be deemed competent for this cluster of two units (BSBTEC401 and BSBTEC302).
The purpose of the assessment is to assess the student’s skills and knowledge to develop spreadsheets using the features and functions found in most spreadsheet applications.
Assessment Matrix
The competency assessment map that maps all the assessment tasks is available on CANVAS
Submission Requirements
You should:
- Ensure that you submit assessments on or before the due date.
- 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.
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
Where an extension of greater than seven days is needed, you must apply for Special Consideration. You must submit your application within five working days after your assessment date or due date.
More Information: https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/assessment/special-consideration
Re-submissions (VE Programs):
If you are found to be unsuccessful (Not satisfactory/Unsatisfactory) in a Course Assessment Task you will be allowed one re-submission. Your teacher will provide feedback regarding what you need to do to improve and will set a new deadline for the re-submission.
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. For more information about the circumstances under which assessment arrangements might be granted please access the following website:
Final Results
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.
The following grades are available for this course:
CA |
Competency Achieved |
NYC |
Not Yet Competent |
DNS |
Did Not Submit for Assessment |
Course Overview: Access Course Overview