Course Title: Develop and use complex spreadsheets
Part B: Course Detail
Teaching Period: Term1 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 organisational and task requirements |
Element: |
Automate and standardise spreadsheet operation |
Performance Criteria: |
1 Evaluate tasks to identify those where automation would increase efficiency |
Element: |
Develop a linked spreadsheet solution |
Performance Criteria: |
1 Utilise spreadsheet design software functions and formulae to meet identified requirements |
Element: |
Prepare to develop spreadsheet. |
Performance Criteria: |
1 Organise personal work environment in accordance with ergonomic requirements 4 Apply work organisation strategies and energy and resource conservation techniques to plan work activities |
Element: |
Represent numerical data in graphic form |
Performance Criteria: |
1 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 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 the 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 may include workplace research, library assignments, field work and work placements.
Teaching Schedule
Week | Content | Requirements |
Week 1 - 7 Feb |
Full-time students: Course guide & Assessment Guide; Introduction to Blackboard; Office procedures Flexible delivery students: Overview |
|
Week 2 - 14 Feb | Ergonomic requirements; Office procedures | Text |
Week 3 - 21 Feb | Section 1 | Text |
Week 4 - 28 Feb | Section 2 | Text |
Week 5 - 7 Mar | Portfolio document 1 | Text/Printing Credits |
Week 6 - 14 Mar | Section 3 | Text |
Week 7 - 21 Mar | Portfolio document 2 | Text/Printing Credits |
Week 8 - 28 Mar | Section 4 | Text |
Week 9 - 4 Apr | Section 4 | Text |
Week 10 - 11 Apr | Portfolio document 3 | Text/Printing Credits |
Week 11 - 18 Apr | Section 5 | Text |
Easter Break | ||
Week 11 - 28 Apr | Section 5 | Text |
Week 12 - 2 May | Section 5 | Text |
Week 13 - 9 May | Portfolio document 4 | Text/Printing Credits |
Week 14 - 16 May | Section 6 | Text |
Week 15 - 23 May | Section 6 | Text |
Week 16 - 30 May | Portfolio document 5 | Text/Printing Credits |
Learning Resources
Prescribed Texts
Software Publications, BSBITU402A Develop and use complex spreadsheets - Excel 2010 |
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
Full-time students
Students will complete a portfolio of evidence which focus on the practical component of developing and using complex spreadsheets using MS Office Excel 2010. Each document created in the portfolio is to be completed individually in class as indicated on the Teaching Schedule and is open book. Students who have not received a satisfactory result in all elements of competency will be given an opportunity to show competency in Week 17 and will receive a result of either Competency Achieved (CA) or Not Yet Competent (NYC).
Flexible delivery
Students will complete a portfolio of evidence which focus on the practical component of developing and using complex spreadsheets using MS Office Excel 2010. Each document created in the portfolio is to be completed individually and submitted to the relevant course at ’myRMIT Studies’ by the due date, refer to weekly notices for further information. Students who have not received a satisfactory result in all elements of competency will be given an opportunity to show competency in Week 17 and will receive a result of either Competency Achieved (CA) or Not Yet Competent (NYC).
Assessment Matrix
Part of Element of competency | Doc 1 | Doc 2 | Doc 3 | Doc 4 | Doc 5 |
Prepare to develop spreadsheet | Yes | Yes | Yes | ||
Develop a linked spreadsheet solution | Yes | Yes | Yes | Yes | Yes |
Automate and standardise spreadsheet operation | Yes | ||||
Use spreadsheets | Yes | Yes | Yes | Yes | Yes |
Represent numberical data in graphic form | Yes | Yes |
Course Overview: Access Course Overview