Course Title: Produce spreadsheets
Part B: Course Detail
Teaching Period: Term1 2009
Course Code: COSC5942C
Course Title: Produce spreadsheets
School: 650T TAFE Business
Campus: City Campus
Program: C3216 - Certificate III in Business Administration
Course Contact : Janet McDonald
Course Contact Phone: +61 3 99255134
Course Contact Email:janet.mcdonald@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
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
There are no pre-requisites or co-requisites for this course.
Course Description
This course covers the skills required to create spreadsheets that encompass formatting, formulae and charts in order to complete business tasks.
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title: |
BSBITU304A Produce spreadsheets |
Element: |
Create spreadsheet |
Performance Criteria: |
Ensure data is entered, checked and amended to maintain consistency of design and layout, in accordance with organisational and task requirements. Format spreadsheet using software functions to adjust page and cell layout to meet information requirements, in accordance with organisational style and presentation requirements. Ensure formulae are tested and used to confirm output meets task requirements, in consultation with appropriate personnel as required. Use manuals, user documentation and online help to overcome problems with spreadsheet design and production. |
Element: |
Finalise spreadsheets |
Performance Criteria: |
Preview, adjust and print spreadsheet and any accompanying charts, in accordance with task requirements. Ensure data input meets designated time lines and organisational requirements for speed and accuracy. Name and store spreadsheet in accordance with organisational requirements and exit the application without data loss/damage. |
Element: |
Plan spreadsheet design |
Performance Criteria: |
Ensure spreadsheet design suits the purpose, audience and information requirements of the task. Ensure spreadsheet design enhances readability and appearance, and meets organisational and task requirements for style and layout. Use style sheets and automatic functions to ensure consistency of design and layout. |
Element: |
Produce simple charts |
Performance Criteria: |
Select chart type and design that enables valid representation of numerical data, and meets organisational and task requirements. Create charts using appropriate data range in the spreadsheet. Modify chart type and layout using formatting features. |
Element: |
Select and prepare resources |
Performance Criteria: |
Adhere to ergonomic, work organisation and occupational health and safety requirements. Use energy and resource conservation techniques to minimise wastage. Indentify spreadsheet task requirements in relation to data entry, storage, output and presentation. |
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 | Reqirements |
Week 1 - 9 Feb |
Course Guide & Assessments Chapter 19 - General Computer Usage |
|
Week 2 - 16 Feb | Chapter 1 - Spreadsheets; Chapter 2 - Excel 2003 Orientation; Chapter 3 - A Simple Workbook & Chapter 4 - Selecting Ranges |
Text |
Week 3 - 25 Feb | Chapter 5 - Formulas & Chapter 6 - Copying and Filling | Text |
Week 4 - 2 Mar | Chapter 7 - Absolute Referencing; Chapter 8 - Formatting Numbers & Chapter 9 - Formatting for Effect | Text |
Week 5 - 9 Mar | Chapter 10 - Adjusting a Worksheet; Chapter 11 - Working with Functions; Assessment |
Text & Printing credits |
Week 6 - 16 Mar | Chapter 12 - Filling Series; Chapter 13 - Printing & Chapter 14 - Printing Techniques |
Text & Printing credits |
Week 7 - 23 Mar | Chapter 15 - Editing Data; Chapter 16 - Labels and Names; Chapter 17 - Charting & Chapter 18 - Charting Techniques | Text |
Week 8 - 30 Mar |
Assessment Review |
Text & Printing credits |
Week 9 - 6 Apr | Final Assessment | Text & Printing credits |
Learning Resources
Prescribed Texts
Watsonia, Produce Spreadsheets BSBITU304A - Microsoft Excel 2003, Watsonia Publishing, 2008. |
9781921341328 |
References
Other Resources
Overview of Assessment
Students must demonstrate an understanding of all elements of competency to be deemed competent.
Assessment methods have been designed to measure achievements of each element of competency in a flexible manner. Assessments will incorporate a variety of methods such as class exercises, practical projects, tests and demonstration of techniques in a workplace or the Virtual Enterprise. 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.
In addition to the assessments, formative feedback is provided to the students throughout the duration of the course.
Learning activities will include class-based discussions, exercises, reading and reflection and situated learning in the Virtual Enterprise in order to develop competency including underpinning skills and knowledge.
Assessment Tasks
Students will complete a number of documents which focus on both the practical and theory component of developing and using spreadsheets, including employability skills. The assessments will be practical exercises completed in class independently as indicated on the Teaching Schedule, are open book and worth a total of 80%. Students will also complete spreadsheet documents whilst participating in the Virtual Enterprise which will be assessed and are worth a total of 20%.
Assessment Matrix
Element of competency | Week 5 | Week 8 | Week 9 |
Select and prepare resources | Yes | Yes | Yes |
Plan spreadsheet design | Yes | Yes | Yes |
Create spreadsheet | Yes | Yes | Yes |
Produce simple charts | Yes | Yes | |
Finalise spreadsheets | Yes | Yes | Yes |
Other Information
Employability Skills
This course/competency includes the employability skills listed below which are assessable under the Business Services Training Package.
In order to be able to effectively demonstrate the required employability skills during the course, students should participate and aim to attend punctually. Students are required to contribute to 80% plus of required classes. Please note that employability skills are assessed across the entire program.
Employability skills are a core component of the competency and if a student is unable to effectively demonstrate these skills within the competency, a mark of NYC (Not Yet Competent) will be given for the course.
Employability skills identifed for this course are:
Communication
Problem solving
Planning and organising
Self-management
Learning
Technology
From July 2008 students issued with Training Package qualifications have been informed by their Registered Training Organisation that Employability Skills Summaries for Training Package qualifications can be downloaded from http://employabilityskills.training.com.au. Registered Training Organisations are required to add the mandatory sentence providing the URL for the Employability Skills Summaries to Training package and qualification testamurs from 1 January 2009. The Australian Qualification Framework Implementation Handbook has been amended to show this requirement.
Course Overview: Access Course Overview