Course Title: Develop and use complex spreadsheets
Part B: Course Detail
Teaching Period: Term2 2010
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: |
Enter, check and amend data in accordance with organisational and task requirements |
Element: |
Automate and standardise spreadsheet operation |
Performance Criteria: |
Evaluate tasks to identify those where automation would increase efficiency |
Element: |
Develop a linked spreadsheet solution |
Performance Criteria: |
Utilise spreadsheet design software functions and formulae to meet identified requirements |
Element: |
Prepare to develop spreadsheet. |
Performance Criteria: |
Organise personal work environment in accordance with ergonomic requirements |
Element: |
Represent numerical data in graphic form |
Performance Criteria: |
Determine style of graph to meet specified requirements and manipulate spreadsheet data if necessary to suit graph requirements |
Learning Outcomes
Details of Learning Activities
Learning activities will include class based exercises, demonstrations, and observations in order to develop competency including the underpinning skills and knowledge.
Teaching Schedule
| Week beginning | Content | Requirements |
| Week 1 - 5 July | Introduction; Required files; Review Excel Basics; Chapter 15: General Computer Usage; Employability skills | Learning Hub |
| Week 2 - 12 July | Chapter 1: Printing techniques | Learning Hub, Text & printing credits |
| Week 3 - 19 July | Chapter 2: Charting; Chapter 3: Charting Techniques & Consolidation Exercise 1 | Learning Hub & Text |
| Week 4 - 26 July | Chapter 4: Logical Functions & Chapter 5: Maths Functions | Learning Hub & Text |
| Week 5 - 2 Aug | Chapter 6: Statistical Functions & Consolidation Exercise 2 | Learning Hub & Text |
| Week 6 - 9 Aug | Chapter 8: Data & Time Functions; Chapter 9: Lookup Functions & Consolidation Exercise 3 | Learning Hub & Text |
| Week 7 - 16 Aug | Pivot Tables & Chapter 10: Linking Workbooks | Learning Hub & Text |
| Week 8 - 23 Aug | Chapter 11: Templates; Chapter 12: Importing & Exporting & Consolidation Exercise 4 | Learning Hub & Text |
| 30 Aug - 5 Sep | Mid semester break | |
| Week 9 - 6 Sept | Chapter 13: Recorded Macros & Chapter 14: Recorder Workshop | Learning Hub & Text |
| Week 10 - 13 Sept | Consolidation Exercise 5 | Learning Hub & Text |
| Week 11 - 20 Sept | Assessment 1 | Learning Hub, Printing Credits & Text |
| Week 12 - 27 Sept | Review: Integrated Assignment | Learning Hub & Text |
| Week 13 - 4 Oct | Review: Integrated Assignment | Learning Hub & Text |
| Week 14 - 11 Oct | Review: Integrated Assignment | Learning Hub & Text |
| Week 15 - 18 Oct | Assessment 2 | Learning Hub, Printing Credits & Text |
| Week 16 - 25 Oct | Special Consideration | Learning Hub, Printing Credits & Text |
Learning Resources
Prescribed Texts
BSBADM404A Develop & Use Complex Spreadsheets using Microsoft Excel 2003, Learning Guide & Study Guides, Watsonia Publishing |
1740078756 |
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
Assessment 1 Week 11 - 50%
Students will complete a number of documents which focus on the practical component of developing and using complex spreadsheets. The assessment is to be completed individually in class and is open book.
Assessment 2 Week 15 - 50%
Students will complete a number of documents which focus on the practical component of developing and using complext spreadsheets. The assessment is to be completed individually in class and is open book.
Assessment Matrix
Grading Information
| Grade | Mark | Description |
| HD | >=80 | High distinction (Competency achieved) |
| DI | 70-79 | Distinction (Competency achieved) |
| CR | 60-69 | Credit (Competency achieved) |
| PA | 50-59 | Pass (Competency achieved) |
| NN | <50 | Fail (Not yet competent) |
| CA | Not applicable | Competency achieved |
| NYC | Not available | Net yet competent |
| Competency | Assessment 1 | Assessment 2 |
| Prepare to develop spreadsheet | Yes | Yes |
| Develop a linked spreadsheet solution | Yes | Yes |
| Automate and standardise spreadsheet operation | Yes | Yes |
| Use spreadsheets | Yes | Yes |
| Represent numerical data in graphic form | Yes | Yes |
Other Information
In adherence with RMIT’s commitment to sustainability, course teachers will seek to incorporate environmental concerns in the facilitation of this course. These include, but are not limited to:
• Conserving natural resources
• Using recycled materials wherever possible
• Minimising pollution
• Applying energy savings measures
• Reducing waste
Students are encouraged to identify and follow environmental and resource efficient ways of working whilst studying this course.
Special Consideration
Special consideration allows the University to take account of unexpected circumstances that can affect your ability to complete an assessment. Examples of unexpected or extenuating circumstances for eligibility may include:
• Serious illness with a significant impact e.g. hospital admission, concussion, serious injury, asthma attack or depression. It does not include illnesses with minor impact such as a cold, headache, period pain or stomach ache.
• Loss or bereavement e.g. death of a close family member, family/relationship breakdown.
• Hardship or trauma e.g. victim of serious crime, sudden loss of income or employment, severe unexpected disruption to domestic arrangements.
How to apply
You must apply for special consideration no later than two working days after the relevant examination or assessment deadline. You must complete the Special Consideration Application form available at rmit.edu.au/students/forms and lodge the original and one photocopy at the Hub on your campus. You can also lodge the application and supporting documentation via fax to tel. 9925 8845 or send scanned copies via email to special.consideration@rmit.edu.au.
Please note that in 2010 it is anticipated that applications for special consideration will move to an online process. More information about this new process will be available at rmit.edu.au/students/specialconsideration.
Your application must be supported by a medical impact statement and/or relevant supporting documentation. A medical certificate alone is not sufficient. If you cannot obtain the impact statement or supporting documents within two days, you should lodge an incomplete application form and provide the additional documents within five business day.
Late applications can only be accepted in extenuating circumstances and their submission requires the approval of the Academic Registrar.
Assessment of applications
All special consideration applications are considered by a panel of health and academic experts, convened by the Academic Registrar. All communication about your application will be through your RMIT student email account. It is your responsibility to check your RMIT student email account regularly, promptly respond to any requests for information or action and ensure your account can receive incoming emails.
Extensions of time for submission of assessment – seven days or fewer
If you are seeking an extension of seven calendar days or fewer from the original due date you must meet certain eligibility criteria (similar to special consideration) and complete an Application for Extension of Time for Submission of Assessable Work form and lodge it with the School. Forms are available at rmit.edu.au/students/forms.
Arrangements for lodging forms can vary according to individual school procedures. It is your responsibility, as the applicant, to check whether the form should be lodged with the school administrative officer, the course coordinator or program coordinator. Except in exceptional circumstances the application must be lodged no later than one working day before the official due date.
Employability skills
Employability skills are included in this course and are based on broad industry requirements.
Course Overview: Access Course Overview