Course Title: Develop and use complex spreadsheets
Part B: Course Detail
Teaching Period: Term2 2011
Course Code: COSC5946C
Course Title: Develop and use complex spreadsheets
School: 650T TAFE Business
Campus: City Campus
Program: C4223 - Certificate IV in Business Administration
Course Contact : Sylvia Baroutis
Course Contact Phone: +61 3 9925-5469
Course Contact Email:sylvia.baroutis@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
Nominal Hours: 50
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 course covers the use of spreadsheet software to complete business tasks and produce usable complex documents.
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title: |
BSBITU402A Develop and use complex spreadsheets |
Element: |
Use spreadsheets |
Performance Criteria: |
1. Enter, check and amend data in accordance with |
Element: |
Represent numerical data in graphic form |
Performance Criteria: |
1 Determine style of graph to meet specified requirements |
Element: |
Automate and standardise spreadsheet operation |
Performance Criteria: |
1 Evaluate tasks to identify those where automation would |
Element: |
Develop a linked spreadsheet solution |
Performance Criteria: |
1 Utilise spreadsheet design software functions and |
Element: |
Prepare to develop spreadsheet. |
Performance Criteria: |
1 Organise personal work environment in accordance with |
Learning Outcomes
Details of Learning Activities
Students will use MS Office Excel 2010 for this competency. Learning activities will include class-based discussions, demonstrations, practical exercises and observations in order to develop competency including the underpinning skills and knowledge. In addition to the assessments, formative feedback is provided to students throughout the duration of the course.
Some learning activities will include a self-directed learning approach. Self-directed learning refers to organised teacher-directed learning activities that you will undertake independently, either as individuals or with other students.
This unit contains employability skills.
Teaching Schedule
Week beginning | Content & Element of competency | Requirements |
Week 1 - 4 July |
Introduction to course and Blackboard. Prepare to develop spreadsheets. |
Text pg i - xxxi |
Week 2 - 11 July | Prepare to develop spreadsheet; Use spreadsheets |
Text Section 1 & 2 |
Week 3 - 18 July | Prepare to develop spreadsheet; Use spreadsheets; Represent numerical data in graphic form | Text Section 2 & 3 |
Week 4 - 25 July | Prepare to develop spreadsheet; Use spreadsheets; Represent numerical data in graphic form | Text Section 3 |
Week 5 - 1 Aug | Assessment Portfolio 1 Prepare to develop spreadsheet; Use spreadsheets; Represent numerical data in graphic form. | Text & printing credits |
Week 6 - 8 Aug | Prepare to develop spreadsheet; Use spreadsheets; Develop a linked spreadsheet solution | Text Section 4 |
Week 7 - 15 Aug | Assessment Portfolio 2 Prepare to develop spreadsheet; Use spreadsheets; Develop a linked spreadsheet solution; Represent numerical data in graphic form. | Text & printing credits |
Week 8 - 22 Aug | Prepare to develop spreadsheet; Use spreadsheets | Text Section 5 |
Midsemester Break 29 August - 2 September | ||
Week 9 - 5 Sept | Assessment Portfolio 3 Prepare to develop spreadsheet; Use spreadsheets; Develop a linked spreadsheet solution | Text & printing credits |
Week 10 - 12 Sept | Prepare to develop spreadsheet; Use spreadsheets; Automate and standardise spreadsheet operation. | Text Section 6 |
Week 11 - 19 Sept | Prepare to develop spreadsheet; Use spreadsheets; Automate and standardise spreadsheet operation. | Text Section 6 |
Week 12 - 26 Sept | Assessment Portfolio 4 Prepare to develop spreadsheet; Use spreadsheets; Develop a linked spreadsheet solution; Automate and standardise spreadsheet operation. | Text & printing credits |
Week 13 - 3 Oct | Prepare to develop spreadsheet; Use spreadsheets; Develop a linked spreadsheet solution; Represent numerical data in graphic form; Automate and standardise spreadsheet operation. | Text |
Week 14 - 10 Oct | Prepare to develop spreadsheet; Use spreadsheets; Develop a linked spreadsheet solution; Represent numerical data in graphic form; Automate and standardise spreadsheet operation. | Text |
Week 15 - 17 Oct | Assessment Portfolio 5 Prepare to develop spreadsheet; Use spreadsheets; Develop a linked spreadsheet solution; Represent numerical data in graphic form; Automate and standardise spreadsheet operation. | Text & printing credits |
Week 16 - 24 Oct | Assessment Journal Employability Skills and Feedback |
Learning Resources
Prescribed Texts
Price & Wix, Develop and use complex spreadsheets Excel 2010, Software Publications |
9781921780783 |
References
Other Resources
Overview of Assessment
Assessment may incorporate a variety of methods including technical requirements documentation, homework, assignments, group and/or individual projects, in class exercises, written and practical assessments, problem solving exercises, presentations, direct observation of actual and simulated work practice, presentation of a portfolio of evidence which may comprise documents, and/or photographs and/or video and audio files, review of products produced through work-based or course activities.
Students are advised that they are likely to be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant competency standards are being met. Students will be provided with feedback throughout the course to check their progress.
Assessment Tasks
Students will complete a portfolio of evidence which focuses on the practical component of developing and using complex spreadsheets using Microsoft Excel 2010. Each document created is to be completed individually in class as indicated on the Teaching Schedule and is open book.
Note: Students who have been granted special consideration will be able to sit their assessment by arrangement with the class teacher during the scheduled class time in week 17.
Employability Skills
Students will also complete evidence of employability skills developed whilst completing this course which must be submitted by COB Monday 24 October. Assessmentssubmitted late will attract a DNS/NYC grade. Refer to Student Diary for Special Consideration/Extension of Time procedure. If an Extension of Time is granted note that the grade given will be either NYC/CA.
Assessment Matrix
Part of element of competency | Doc 1 | Doc 2 | Doc 3 | Doc 4 | Doc 5 |
Prepare to develop spreadsheet | Yes | Yes | Yes | Yes | Yes |
Develop a linked spreadsheet solution | Yes | Yes | Yes | Yes | Yes |
Automate and standardise spreadsheet operation | Yes | Yes | |||
Use spreadsheets | Yes | Yes | Yes | Yes | Yes |
Represent numerical data in graphic form | Yes | Yes | Yes |
CHD | CDI | CC | CA | NYC/DNS |
Competency achieved with high distinction | Competency achieved with distinction | Competency achieved with credit | Competency achieved with pass | Not yet competent/Did not submit |
Course Overview: Access Course Overview