Course Title: Design and produce spreadsheets
Part B: Course Detail
Teaching Period: VE 2024
Class Number: 3614
Class Section: AC03
For flexible terms and optional semesters, a Part B course guide may have been published for the entire teaching period, or for the specific class number in which you are enrolled. If there is no Part B course guide published for your specific class number, please refer to the guide for the teaching period in which you are enrolled. Enrolment Online is the definitive source for details regarding your class enrolment.
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.
School: 525T Business & Enterprise
Campus: City Campus
Program: C4435 - Certificate IV in Accounting and Bookkeeping
Course Contact: Nick Reynolds
Course Contact Phone: +61 3 9925 0791
Course Contact Email: nick.reynolds@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: 8:30am - 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
None
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.
No licensing, legislative or certification requirements apply to this unit at the time of publication.
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
Details of Learning Activities
Welcome to BSBTEC302 Design and Produce Spreadsheets.
This is a 9-week course, and all learning and assessment activities for this course must be completed within this time. A weekly breakdown of the activities for this course can be found in the ‘Teaching Schedule’ section below.
To ensure you accomplish the expected learning outcomes of this course, you will be required to devote study time each week outside of scheduled class times, completing exercises, activities and assessment tasks.
All assessment tasks should be completed and submitted by their due dates as shown in CANVAS.
Students will be introduced to MS Excel, which will be supported by practical illustrations. Students will complete exercises to reinforce their understanding of the material. Solutions will be available on the learning hub.Teaching Schedule
|
Week |
Topics |
Assessment/ Quiz |
|
1 |
Chapter 1 Using Computers in the Workplace • Office Equipment • Data Storage. • Safe Work Strategies • Workplace Protocols • Introduction to Microsoft Excel • Alternatives to Microsoft Excel |
Online Quiz 1 |
|
2 |
Chapter 2 Create Spreadsheets • Plan Spreadsheet Design • Spreadsheet Information Requirements • Spreadsheet Style and Layout Requirements • Style Sheets and Automatic Functions |
|
|
3 |
Chapter 2 Create Spreadsheets • Style Sheets and Automatic Functions |
Online Quiz 2
|
|
4 |
Chapter 3 Use Spreadsheets • Enter, Check and Amend Data • Format Spreadsheet, Adjust Layout |
|
|
5 |
Chapter 3 Use Spreadsheets • Format Spreadsheet, Adjust Layout • Test Formulas to Confirm Output • Overcome Problems with Spreadsheet Design and Production Discussion on Assessment |
|
|
6 |
Chapter 4 Produce Charts • Select the Appropriate Chart Type and Design • Create Charts Using Appropriate Data Ranges • Modify Chart Type and Layout Pitstop 1 – Assessment |
|
|
7 |
Chapter 5 Finalise Spreadsheets • Preview, Adjust and Print Spreadsheets and Charts • Deliver Documents to Required Stakeholders • Name and Store Spreadsheet Pitstop 2– Assessment |
Assessment Due |
|
8 |
Assessment Feedback & Resubmission |
|
|
9 |
Final week to submit all assessments, re-submissions if required. |
|
Learning Resources
Prescribed Texts
Design and Produce Spreadsheets by Simon Thomas 2nd Edition (January, 2022) |
978-1-76073-256-1 |
References
Other Resources
Overview of Assessment
Performance Evidence
The candidate must demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including evidence of the ability to:
- plan, design, produce and finalise a spreadsheet on at least four occasions.
In the course of the above, the candidate must:
- produce spreadsheet documents that align to document purpose and appropriate to target audience
- design spreadsheets using:
- formulas and functions with:
- addition, subtraction, division, multiplication
- brackets
- design spreadsheets that address a range of data and organisational requirements
- use software functions to create spreadsheets that adhere to organisational requirements relating to style and presentation
- use relevant help functions to rectify document issues
- produce spreadsheet document in appropriate format for review, including ability to create and modify intermediate-level charts that analyse the dataset.
Knowledge Evidence
The candidate must be able to demonstrate knowledge to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including knowledge of:
- key elements of formatting of spreadsheets appropriate to workplace documents, including the ability to calculate:
- sum totals
- averages
- counts of values
- key features of spreadsheet applications, both cloud-based and non-cloud based
- key features of organisational guidelines on spreadsheet design and use
- organisational requirements for ergonomics, work periods and breaks, and sustainability in relation to spreadsheet production.
Assessment Conditions
Skills in this unit must be demonstrated in a workplace or simulated environment where the conditions are typical of those in a working environment in this industry.
This includes access to:
- industry software/applications for producing spreadsheets
- digital device user information
- relevant legislation and codes of practice
- relevant organisational policies and procedures
- workplace documentation and resources, including style guide.
Assessors of this unit must satisfy the requirements for assessors in applicable vocational education and training legislation, frameworks and/or standards.
Feedback
Feedback will be provided throughout the semester in class and/or online discussions. You are encouraged to ask and answer questions during class time and online sessions so that you can obtain feedback on your understanding of the concepts and issues being discussed. Finally, you can email or arrange an appointment with your teacher to gain more feedback on your progress.
You should take note of all feedback received and use this information to improve your learning outcomes and final performance in the course.
Assessment Tasks
Students MUST successfully complete the below mentioned assessment task and gain competency in order to pass this course.
Assessment Task 1 - Due date: Week 7
This assessment task is the first and only assessment task that you must successfully complete to be deemed competent in this course. In this task you will develop a spreadsheet suite for a client on behalf of 'Complete Business Services (Pty Ltd)'.
Completing this assessment allows you to demonstrate your ability to develop spreadsheets using spreadsheet applications in line with specified organisational requirements, policies, and procedures.
Students can be asked to reproduce any assessment piece in front of the teacher.
Assessment Matrix
The assessment criteria for all the assessments 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
Attendance
Your learning experience will involve online teaching, discussion, demonstration and practical exercises
It is strongly advised that you attend all timetabled sessions. This will allow you to engage in the required learning activities, ensuring you the maximum opportunity to complete this course successfully.
Information about your studies
You can access My Studies through the RMIT website for information about timetables, important dates, assessment dates, results and progress, Canvas etc.
https://www.rmit.edu.au/students
Canvas
Use Canvas to access your course content and announcements, submit assignments, and receive your grades and feedback;
https://www.rmit.edu.au/students/support-and-facilities/it-services-for-students/canvas
Student feedback at RMIT:
You will receive verbal and written feedback by teacher on your work. This feedback also includes suggestions on how you can proceed to the next stage of developing your projects.
The following link is an outline and ways that you will receive your feedback at RMIT;
Assessment
Information on assessment including Special consideration, Adjustments to assessment, (e.g. applying for an extension of time):
https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/assessment
Submitting Assessments onto Canvas
Here is a guide to submitting assessments on Canvas;
Student Progress Monitoring
Academic progress is an important enabling and proactive strategy to assist you to achieve your learning potential.
Please see following access to the student progress policy webpage; https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/academic-progress
Academic Integrity and Plagiarism
RMIT University has a strict policy on plagiarism and academic integrity. Please see following access for more information on Academic Integrity at RMIT; https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/academic-integrity
Credit Transfer and Recognition of Prior Learning
Credit transfer is the recognition of previously completed formal learning (an officially accredited qualification). Recognition of Prior Learning (RPL) is an assessment process that allows you to demonstrate competence using the skills you have gained through experience in the workplace, voluntary work, informal or formal training or other life experiences.
Please speak to your teacher if you wish to discuss applying for Credit Transfer or RPL for the unit(s) of competency addressed in this course.
https://www.rmit.edu.au/students/student-essentials/enrolment/apply-for-credit
Course Overview: Access Course Overview