Course Title: Develop and use complex spreadsheets

Part B: Course Detail

Teaching Period: Term2 2008

Course Code: COSC5240C

Course Title: Develop and use complex spreadsheets

School: 650T TAFE Business

Campus: City Campus

Program: C6072 - Advanced Diploma of Accounting

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

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:

BSBADM404A Develop and use complex spreadsheets

Element:

Automate and standardise spreadsheet operation

Performance Criteria:

Tasks are evaluated to identify those where automation would increase efficiency.

Macros are created, used and edited to fulfil the requirements of the task and automate spreadsheet operation.

Templates are developed, edited and used to ensure consistency of design and layout for forms and reports in accordance with organisational requirements.

Element:

Develop a linked spreadsheet solution

Performance Criteria:

Task is analysed and specificiations for spreadsheets are determined.

Organisational and task requirements in relation to data entry, storage, output, reporting and presentation requirements are identified.

Spreadsheet design utilises software functions and formulae to meet identified requirements.

Spreadsheets are linked in accordance with software procedures.

Cells are formatted and data attributes assigned with relative and/or absolute cell references used in accordance with the task specifications.

Formulae are tested to confirm output meets task requirements.

Element:

Represent numerical data in graphic form

Performance Criteria:

Style of graph is determined to meet specified requirements and spreadsheet data is manipulated if necessary to suit graph requirements.

Graphs are created with labels and titles from numerical data contained in a spreadsheet file.

Graph is saved, viewed and printed within designated timelines.

Element:

Use safe work practices

Performance Criteria:

Workspace, furniture and equipment are adjusted to suit the ergonomic requirements of the user.

Work organisation meets organisational and statutory requirements for computer operation.

Energy and resource conservation techniques are used to minimise wastage in accordance with organisational and statutory requirements.

Element:

Use spreadsheets

Performance Criteria:

Data is entered, checked and amended in accordance with organisational and task requirements.

Data is imported/exported between compatible spreadsheets and host documents adjusted in accordance with software and system procedures.

Manuals, user documentation and on-line help are used to overcome problems with spreadsheet design and production.

Spreadsheet is previewed, adjusted and printed in accordance with organisational and task requirements.

Spreadsheets are named and stored, in accordance with organisational requirements and the application exited without data loss/damage.


Learning Outcomes


Please refer to Elements of Competency.


Details of Learning Activities

Learning activities will include class based exercises, demonstrations and observation in order to develop underpinning skills and knowledge.


Teaching Schedule

Week Beginning Content Requirements
Week 1 - 7 Jul

Course Guide, Assessments & Text

RMIT Policies

Review of the basics.

 
Week 2 - 14 Jul

Individual Assessment Matrix

Chapter 15 - General Computer Usage

Chapter 1 & 2 and Practice Exercises

Text & Printing Credits
Week 3 - 21 Jul

Chapter 3 & Practice Exercise

Chapter 4 & Practice Exercise

Text
Week 4 - 28 Jul

Assessment

Chapter 5 & Practice Exercise

Text & Printing Credits
Week 5 - 4 Aug

Chapter 6 & Practice Exercise

Chapter 7 & Practice Exercise

Text

Week 6 - 11 Aug

Assessment

Chapter 8 & Practice Exercise

Text & Printing Credits
Week 7 - 18 Aug Chapter 9 & Practice Exercise Text
Week 8 - 25 Aug

Assessment

Chapter 10 & Practice Exercise

Text & Printing Credits
1 Sep Mid Semester Break  
Week 9 - 8 Sep Chapter 11 & Practice Exercise Text
Week 10 - 15 Sep Chapter 12 & Practice Exercise Text
Week 11 - 22 Sep

Assessment

Chapter 13 & Practice Exercise

Text & Printing Credits
Week 12 - 29 Sep Chapter 14 & Practice Exercise Text
Week 13 - 6 Oct

Assessment

Integrated Assignment

Text & Printing Credits
Week 14 - 13 Oct Integrated Assignment Text
Week 15 - 20 Oct Integrated Assignment Text
Week 16 - 27 Oct Exam Text & Printing Credits
Week 17 - 3 Nov Assessments - Special Consideration Text & Printing Credits
Week 18 - 10 Nov Feedback  


Learning Resources

Prescribed Texts

Watsonia Publishing, Develop and Use Complex Spreadsheets BSBADM404A, Learning Guide & Study Guide

1740078756


References


Other Resources


Overview of Assessment

Students must demonstrate an understanding of all elements of a particular competency to be deemed competent. Assessment methods have been designed to measure achievements of each competency in a flexible manner. Assessments will incorporate a variety of methods: class exercises, homework, practical projects and tests. 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 on various activities in order to develop competency including the underpinning skills and knowledge.


Assessment Tasks

Students will complete five (5) practical tasks as scheduled on the Teaching Schedule. These tasks will cover all elements of competency and are worth a total of 50%.

A final practical exam will be conducted in class in Week 16 covering all elements of competency. This is worth a total of 50%.


Assessment Matrix

Course Overview: Access Course Overview