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

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


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


Use spreadsheets

Performance Criteria:

Enter, check and amend data in accordance with organisational and task requirements

Import and export data between compatible spreadsheets and adjust host documents, in accordance with software and system procedures 

Use manuals, user documentation and online help to overcome problems with spreadsheet design and production 

Preview, adjust and print spreadsheet in accordance with organisational and task requirements 

Name and store spreadsheet in accordance with organisational requirements and exit the application without data loss or damage


Automate and standardise spreadsheet operation

Performance Criteria:

Evaluate tasks to identify those where automation would increase efficiency 

Create, use and edit macros to fulfil the requirements of the task and automate spreadsheet operation 

Develop, edit and use templates to ensure consistency of design and layout for forms and reports, in accordance with organisational requirements


Develop a linked spreadsheet solution

Performance Criteria:

Utilise spreadsheet design software functions and formulae to meet identified requirements 

Link spreadsheets in accordance with software procedures 

Format cells and use data attributes assigned with relative and/or absolute cell references, in accordance with the task specifications 

Test formulae to confirm output meets task requirements


Prepare to develop spreadsheet.

Performance Criteria:

Organise personal work environment in accordance with ergonomic requirements 

Analyse task and determine specifications for spreadsheets 

Identify organisational and task requirements in relation to data entry, storage, output, reporting and presentation requirements 

Apply work organisation strategies and energy and resource conservation techniques to plan work activities


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 

Create graphs with labels and titles from numerical data contained in a spreadsheet file 

Save, view and print graph within designated time lines

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 beginningContentRequirements
Week 1 - 5 JulyIntroduction; Required files; Review Excel Basics; Chapter 15: General Computer Usage; Employability skillsLearning Hub
Week 2 - 12 JulyChapter 1: Printing techniquesLearning Hub, Text & printing credits
Week 3 - 19 JulyChapter 2: Charting; Chapter 3: Charting Techniques & Consolidation Exercise 1Learning Hub & Text
Week 4 - 26 JulyChapter 4: Logical Functions & Chapter 5: Maths FunctionsLearning Hub & Text
Week 5 - 2 AugChapter 6: Statistical Functions & Consolidation Exercise 2Learning Hub & Text
Week 6 - 9 AugChapter 8: Data & Time Functions; Chapter 9: Lookup Functions & Consolidation Exercise 3Learning Hub & Text
Week 7 - 16 AugPivot Tables & Chapter 10: Linking WorkbooksLearning Hub & Text
Week 8 - 23 AugChapter 11: Templates; Chapter 12: Importing & Exporting & Consolidation Exercise 4Learning Hub & Text
 30 Aug - 5 Sep Mid semester break 
Week 9 - 6 SeptChapter 13: Recorded Macros & Chapter 14: Recorder WorkshopLearning Hub & Text
Week 10 - 13 SeptConsolidation Exercise 5Learning Hub & Text
Week 11 - 20 SeptAssessment 1Learning Hub, Printing Credits & Text
Week 12 - 27 SeptReview: Integrated AssignmentLearning Hub & Text
Week 13 - 4 OctReview: Integrated AssignmentLearning Hub & Text
Week 14 - 11 OctReview: Integrated AssignmentLearning Hub & Text
Week 15 - 18 OctAssessment 2Learning Hub, Printing Credits & Text
Week 16 - 25 OctSpecial ConsiderationLearning Hub, Printing Credits & Text

Learning Resources

Prescribed Texts

BSBADM404A Develop & Use Complex Spreadsheets using Microsoft Excel 2003, Learning Guide & Study Guides, Watsonia Publishing



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

HD>=80High distinction (Competency achieved)
DI70-79Distinction (Competency achieved)
CR60-69Credit (Competency achieved)
PA50-59Pass (Competency achieved)
NN<50Fail (Not yet competent)
CANot applicableCompetency achieved
NYCNot availableNet yet competent
CompetencyAssessment 1Assessment 2
Prepare to develop spreadsheetYesYes
Develop a linked spreadsheet solutionYesYes
Automate and standardise spreadsheet operationYesYes
Use spreadsheetsYesYes
Represent numerical data in graphic formYesYes

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 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

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

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

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