Course Title: Design and produce spreadsheets
Part B: Course Detail
Teaching Period: Term2 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: C4398 - Certificate IV in Accounting and Bookkeeping
Course Contact: Doug Gourlay
Course Contact Phone: +61 3 9925 5944
Course Contact Email: doug.gourlay@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
Course Coordinator and teacher: Meetu Aggarwal
Phone: +61 3 9925 1621
E-mail:
Contact hours (appointment only):
Mon to Fri: 10am - 5:30pm
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
Primarily you will be learning on a face to face basis with the support of an online course site for dissemination of materials and some assessments. Students will be expected to attend three hours of class each week in the semester. Students will be introduced to budgets and MS Excel, which will then be supported by practical illustrations. Students will complete exercises to reinforce their understanding of the material. Solutions will be available on the learning hub.
It is a cluster of two courses :
Prepare operational budgets - FNSACC412 and
Design and produce spreadsheets - BSBTEC302
Both of these courses will be delivered simultaneously.
Teaching Schedule
The Teaching Schedule for this course is as follows:
Induction Session
Prior to training commencement a program level induction session will be conducted that comprises the following:
· Program overview and requirements
· MyRMIT/Canvas
· Overview of assessment requirements
· Pre-Training Review including:
o Recognition of Prior Learning and Credit Transfers
o Assessment of current skills and knowledge
· Competency/Grading Criteria
· Plagiarism
· Appeals
· Extensions
· Feedback
· Privacy
· Submission requirements
· Re-submission policy
· Where to get support
· Student Charter
The nominal hours associated with this are a guide only and represent the total teaching time and student effort required to successfully complete the course. This may include not only scheduled classes but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.
Week |
Learning Materials |
Assessment Due |
|
1 |
Pre-class work:
Class work:
|
Release of Assessment 1 Part A |
2 |
Online Quiz 1 - "Budgeting Fundamentals" in class - 10 minutes |
|
3 |
Online Quiz 2 - Sales Budget |
|
4 |
Discussion on Assessment 2 |
Submission of Assessment 1 Part A Results will be declared by the end of week 6 and any re-submissions will be in week 7. Release of Assessment 2 |
5 |
Pit stop - Assessment 2 |
|
6 |
|
Submission of Assessment 2 Results will be declared by the end of week 8 and any re-submissions will be in week 9. |
7 |
|
|
8 |
|
|
9 |
|
|
10 |
|
|
11 |
In class Assessment 1 Part B |
Assessment 1 Part B Results will be declared by the end of week 13 and any re-sits will be in week 14. |
12 |
|
|
13 |
|
|
14 |
Resits of Assessment 1 Part B |
|
15 |
In class Assessment 1 Part C |
Assessment 1 Part C Results will be declared by the end of week 15 and any re-sits will be in week 16. |
16 |
Feedback and resubmissions |
Mid-semester break will be from 29 August to 4 September 2022. Classes will resume from 5 September 2022 .
** The teaching schedule may be subject to change. You will be advised in class and via Canvas Announcements if changes become necessary.
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/written presentations and through the application of learned skills and insights. Full assessment briefs will be provided and can be found on CANVAS.
Assessment Tasks
Students MUST successfully complete the below mentioned two assessment tasks and gain competency in order to pass this course.
Assessment 1 - Due date: Weeks 4, 11 and 15
This assessment is divided into 3 parts: Part A, B and C.
Part A: This is an individual assessment that requires you to answer some questions. It will be based on materials covered from week 1 to week 3. You will work on this assessment in your own time and will submit it on Canvas by the end of week 4.
Part B: This is an in class, close book assessment. You will be asked to prepare different budgets on Excel spreadsheet provided by your teacher. It will be based on materials covered from week 2 to week 10 and will be due in week 11.
Part C: This will also be an in class assessment and you will be asked to prepare cash budgets and performance report on Excel spreadsheet provided by your teacher. It will cover materials from week 12 to week 13 and will be due in week 15.
Assessment 2 - Due date: Week 6
This is an individual assessment that requires you to apply a corporate or brand style guide to a spreadsheet design and develop a short ‘how to’ video (not more than 10 minutes) demonstrating how to design spreadsheets using a widely adopted software within the bookkeeping and accounting industry - Microsoft Excel. You will work on this assessment in your own time. There will be a pitstop meeting in week 5 in which your teacher will check your progress on the assessment.
Students can be asked to reproduce any assessment piece in front of the teacher.
Assessment Matrix
The assessment matrix that maps all the assessment is available on CANVAS under Assignments.
All assessments will utilise a competency-based model and will be deemed as either Satisfactory or Not Yet Satisfactory.
Other Information
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 a cover sheet that includes a declaration and statement of authorship. You must complete, sign and submit a cover sheet with all work you submit for assessment, whether individual or group
work. On the cover sheet you declare that the work you are presenting for assessment is your own work. An assignment cover sheet for submission of each assessment task is available on blackboard.
Each page of your assessment should include footer with your name, student number, the title of the assessment, unit code and title and page numbers. For example, Julie Macpherson, 324567, Task 2, OHS2345C Ensure safe workplace, Page 1 of 10.
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(https://www.rmit.edu.au/students/studentessentials/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. 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 (https://www.rmit.edu.au/students/student-essentials/assessment-andexams/assessment/special-consideration)
Resubmissions (VE Programs):
If you are found to be unsuccessful in a Course Assessment Task you will be allowed one resubmission only. Your teacher will provide feedback regarding what you need to do to improve and will set a new deadline for the resubmission. The highest result you will receive if your resubmission is successful is “CA”.
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 the assessment arrangements might be granted please access the following website:
More Information:https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/assessment/adjustments-to-assessment (https://www.rmit.edu.au/students/student-essentials/assessment-andexams/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.
You will achieve one of the following results:
Final results table:
CA Competency Achieved
NYC Not Yet Competent
DNS Did Not Submit for assessment
Course Overview: Access Course Overview