Course Title: Develop and use complex spreadsheets

Part B: Course Detail

Teaching Period: Term1 2008

Course Code: COSC5884C

Course Title: Develop and use complex spreadsheets

School: 650T TAFE Business

Campus: City Campus

Program: C4114 - Certificate IV in Business Administration

Course Contact : Janet Mc Donald

Course Contact Phone: +61 3 9925 5134

Course Contact Email: janet.mcdonald@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:

BSBADM404A Develop and use complex spreadsheets

Element:

Develop a linked spreadsheet solution

Performance Criteria:

Task is analysed and specifications 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:

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:

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 
Spreadsheet is named and stored, in accordance with organisational requirements and the application exited without data loss/damage

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 Requirements
Week 1 - 11 Feb  Course guide and assessments for this semester 
  Policies: Special consideration & Plagiarism 
  A review of the basics of Excel		  Text
Week 2 - 18 Feb   Individual Assessment Matrix 
  Chapter 15 – General Computer usage 
  Chapter 1 – Printing Techniques & Practice Exercise 1 
  Chapter 2 – Charting & Practice Exercise 2 		 Text
Week 3 - 25 Feb   Chapter 3 – Charting Techniques & Practice Exercise 3 
  Consolidation Exercise 1 
  Chapter 4 – Logical Functions 		 Text
Week 4 - 3 Mar   Assessment 
  Chapter 4 – Logical Functions & Practice Exercise 4 
  Chapter 5 – Maths Functions 		 Text & Printing Credits
Week 5 - 10 Mar   Chapter 5 – Maths Functions & Practice Exercise 5 
  Chapter 6 – Statistical Functions 		 Text
Week 6 - 17 Mar   Chapter 6 – Statistical Functions & Practice Exercise 6 
  Consolidation Exercise 2 
  Chapter 7 – Financial Functions 		 Text
  Mid Semester Break (Student Vacation) - 20 to 26 March  
Week 7 - 31 Mar   Chapter 7 – Financial Functions & Practice Exercise 7 
  Chapter 8 – Date & Time Functions & Practice Exercise 8 		 Text
Week 8 - 7 April   Chapter 9 – Lookup Functions & Practice Exercise 9 
  Consolidation Exercise 3 		 Text
Week 9 - 14 April   Chapter 10 – Linking Workbooks & Practice Exercise 10 
  Chapter 11 – Templates & Practice Exercise 11 		 Text
Week 10 - 21 April   Chapter 12 – Importing & Exporting & Practice Exercise 12 
  Consolidation Exercise 4 		 Text
Week 11 - 28 April   Chapter 13 – Recorded Macros & Practice Exercise 13  Text
Week 12 - 5 May   Chapter 14 – Recorder Workshop & Practice Exercise 14 
  Consolidation Exercise 5 		 Text
Week 13 - 12 May   Assessment  Text & Printing Credits
Week 14 - 19 May   Integrated Assignment Task 1 – 2  Text
Week 15 - 26 May   Integrated Assignment Task 3 – 4  Text
Week 16 - 2 June   Assessment - Exam  Text & Printing Credits
Week 17 - 9 June  Special consideration - Assessments  Text & Printing Credits
Week 18 - 16 June  Review  Text


Learning Resources

Prescribed Texts

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

1 74007924 B

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

Week 4, assessment of element of competency - Represent numerical data in graphic form (10%).
Students will complete a practical test (open book) which focus’s on both the practical and theory components of developing and using complex spreadsheets.

Week 13, assessment of element of competency – Develop a linked spreadsheet solution, Automate and standardise spreadsheet operation, Use spreadsheets and Use safes work practices (40%).
Students will complete a practical test (open book) which focus’s on both the practical and theory components of developing and using complex spreadsheets.

Week 16, assessment of all elements of competency (50%)
Students will complete an end of semester exam which focus on the practical components of developing and using complex spreadsheets. Open book.


Assessment Matrix

Competency Week 4 Week 13 Exam
Use safe work practices   Yes Yes
Develop a linked spreadsheet solution   Yes Yes
Automate & standardise spreadsheet operation   Yes Yes
Use spreadsheets   Yes Yes
Represent numerical data in graphic form Yes   Yes

Course Overview: Access Course Overview