Course Title: Design and produce spreadsheets
Part B: Course Detail
Teaching Period: Term1 2024
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
Matthew Wallace
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 BSBTEC302 - Design and produce spreadsheets.
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.
Learners will need to complete regular weekly learning tasks that may involve online activities, reading broadly, analysing video material, using office software, completing questions on course topics, and completing prescribed assessment tasks. You need to be active in your learning, asking questions of your Training and/or peers and seeking out information as required, especially from the numerous sources available on Canvas, and through links and material specific to this course that is available through myRMIT Studies Course Site.
Teaching Schedule
BSBTEC401 Design and produce complex text documents (OFFC5347C) and BSBTEC302 Produce Spreadsheets (OFFC5352C) | ||
Week |
Topics |
Remarks |
|
1 Week Starting 19th Feb 2024 |
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 26th Feb 2024 |
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 4th March 2024 |
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 11th March 2024 |
Introduction to MS Word · Table of contents · Referencing and bibliography · Header, footer · Check box, drop down box · Help function 11th March Labour day Public holiday (Monday) |
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 18th March 2024 |
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 25th March 2024 |
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. 29th March Good Friday Public holiday |
Style Guide: AT 1 due · Form, FAX · Flyer, Memo · Letter · Budget · Poster · Help Solution 2 |
|
7 Week Starting 25th March 2024 |
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 |
|
Mid-semester Easter break. Friday 29 th Mar – Friday 5 th April | ||
|
8 Week Starting 8th April 2024 |
Solving problems with the Help function. Integrating advanced functions into your MS suite skills. |
|
|
9 Week 11 Starting 15th April 2024 |
|
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 18 September 2023 |
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 22th April 2024 |
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 29th April 2024 |
Introduction to MS Excel- · Freeze pane · Tabs, colours · 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. This meeting evaluated the requirements of Assessment Task 3 |
|
13 Week Starting 6th May 2024 |
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 13 May 2024 |
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 20 May 2024 |
Resubmissions Attempt 2 |
One on on Assessment reattempts if approved by Manager |
|
16 Week Starting 27 May 2024 |
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
Online learning materials can be accessed by going into the RMIT website's Online Learning Hub.
The online learning materials listed include:
- Course outlines
- Power point Presentations
- Supporting Reading material
- Industry relevant articles
- Activities.
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
A detailed Learner Guide is available for each Assessment Task on Canvas here: https://rmit.instructure.com/courses/125819/assignments
There are three Assessments in this course. They are:
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 assessment matrix that maps all the assessments is available on CANVAS
Other Information
Student support
Your first point of contact for any support needs with your assessments should be your teacher and assessor. If you require further support, you should consider contacting the following support services at RMIT Student Support
Assessment adjustments
Students requiring support or adjustments for their formal assessment tasks should contact Equitable Learning Services (ELS), for more information on the types of adjustments provided, access RMIT adjustments to assessment.
Extension of time
If you require an extension of time to submit an assessment task you can apply for an extension of time by completing the form at this link and then email it together with your supporting documentary evidence to the Program Coordinator suzanne.bevaqua@rmit.edu.au
You will be advised of the outcome of your application within 1 business day. Please ensure you read the general information about extension applications before you apply.
Special consideration
If unexpected circumstances affect your ability to complete an assessment you can apply for special consideration. For more information access RMIT special consideration.
Appeals
As an RMIT student you are entitled to seek a review of decisions that impact on your studies. For more information access RMIT appeals.
Submission Requirements
- 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.
Resubmissions (VET Programs)
If you are found to be unsuccessful (Not satisfactory/Unsatisfactory) in a Course Assessment Task 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.
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.
Penalties for Late Submission
Late submissions of assignments without special consideration or extension will automatically be considered a re-submission (see above).
Extensions, Special Consideration and Adjustment to Assessments
Extensions:
Extensions are available for unforeseen circumstances of a short-term nature.
An application form must be submitted to the school at least one working day before the due date of the assessment.
Extensions can be approved for a maximum of one week (seven calendar days) past the due date for an assessment. (Where students need an extension exceeding one week they must instead apply for special consideration.)
Special consideration:
Special consideration is available for unexpected circumstances outside students’ control. These include but are not limited to: unexpected short-term ill health, and unavoidable family, work, cultural or religious commitments.
An application for special consideration is made in advance of an assessment wherever possible but will normally be accepted within five working days after the assessment date
For more information, see the Special Consideration page of the RMIT website.
Adjustments to Assessment:
RMIT provides several adjustments to assessment for students experiencing ongoing or long-term circumstances. Find the right one for your circumstances here.
Changes to the Assessment Scheme
Where a change to assessment approved by the Dean/head of school changes an assessment due date, students will be given at least five working days’ notice of the new due date.
Feedback
You can expect to receive marks and feedback on in-course assessment work in time to improve your performance in related assessment tasks later in the course.
Academic Integrity and Misconduct
Students demonstrate academic integrity in their assessment practices by:
- engaging with assessment activities in an honest way;
- providing accountability for the authorship and originality of work submitted;
- acknowledging the work of others and the re-use of original work.
Academic misconduct is addressed in accordance with the Student conduct policy
Assessment involving research with human participants, their information or their tissue, or animal subjects is carried out in accordance with the Staff ethics and integrity policy.
For further information see the Academic Integrity website.
Review and Appeal
A student may request a review of an assessment result or appeal a final course grade in accordance with the Conduct of assessment and appeals section of the Assessment Processes.
Grade Criteria
You must demonstrate that you have all the required skills/knowledge/elements in the unit of competency you are studying.
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