Course Title: Produce spreadsheets

Part B: Course Detail

Teaching Period: Term1 2010

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

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


Create spreadsheet

Performance Criteria:

3.1 Ensure data is entered, checked and amended to maintain consistency of design and layout, in accordance with organisational and task requirements
3.2 Format spreadsheet using software functions to adjust page and cell layout to meet information requirements, in accordance with organisational style and presentation requirements
3.3 Ensure formulae are tested and used to confirm output meets task requirements, in consultation with appropriate personnel as required
3.4 Use manuals, user documentation and online help to overcome problems with spreadsheet design and production


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


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


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


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

– Scheduled class times 


 Weekly Schedule 
Week beginningContentRequirements
Week 12 – 3 May

Course guide & assessments; Chapter 1 Spreadsheets; Chapter 2 Excel 2003 Orientation; Chapter 3 A simple workbook & Chapter 4 Selecting Ranges

Week 13 – 10 MayChapter 5 Formulas & Chapter 6 Copying and FillingText
Week 14 – 17 MayChapter 7 Absolute Referencing; Chapter 8 Formatting Numbers & Chapter 9 Formatting for Effect Text
Week 15 – 24 MayChapter 10 Adjusting a Worksheet; Chapter 11 – Working with Functions; Assessment 1Text
Week 16 – 1 June Chapter 12 Filling Series; Chapter 13 Printing; Chapter 14 Printing Techniques; Chapter 15 Editing Data; Chapter 16 Labels and NamesText & Printing credits
Week 17 – 7 JuneChapter 17 Charting; Chapter 18 Charting Techniques. Assessment 2Text & Printing credits
Week 18 – 14 JuneFinal Assessment in classText & Printing credits

Learning Resources

Prescribed Texts

Infocus, Produce Spreadsheets BSBITU304A Microsoft Excel 2003, Watsonia Publishng 2008



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 a spreadsheet. The assessments will be held in class as indicated on the Teaching Schedule, are open book and are to be completed individually.

Assessment Matrix


Element Assess 1Assess 2Final assess
Select and prepare resources√√√
Plan spreadsheet design√√√
Create spreadsheet√√√
Produce simple charts √√
Finalise spreadsheets√√√

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.

Course Overview: Access Course Overview