Course Title: Develop and use complex spreadsheets

Part B: Course Detail

Teaching Period: Term2 2011

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 Email:sylvia.baroutis@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:

BSBITU402A Develop and use complex spreadsheets

Element:

Use spreadsheets

Performance Criteria:

1. Enter, check and amend data in accordance with
organisational and task requirements
2 Import and export data between compatible
spreadsheets and adjust host documents, in accordance
with software and system procedures
3 Use manuals, user documentation and online help to
overcome problems with spreadsheet design and
production 
4  Preview, adjust and print spreadsheet in accordance with
organisational and task requirements
5 Name and store spreadsheet in accordance with
organisational requirements and exit the application
without data loss or damage

Element:

Represent numerical data in graphic form

Performance Criteria:

1 Determine style of graph to meet specified requirements
and manipulate spreadsheet data if necessary to suit
graph requirements
2 Create graphs with labels and titles from numerical data
contained in a spreadsheet file
3 Save, view and print graph within designated time lines

Element:

Automate and standardise spreadsheet operation

Performance Criteria:

1 Evaluate tasks to identify those where automation would
increase efficiency
2 Create, use and edit macros to fulfil the requirements of
the task and automate spreadsheet operation
3 Develop, edit and use templates to ensure consistency of
design and layout for forms and reports, in accordance
with organisational requirements

Element:

Develop a linked spreadsheet solution

Performance Criteria:

1 Utilise spreadsheet design software functions and
formulae to meet identified requirements
2 Link spreadsheets in accordance with software
procedures
3 Format cells and use data attributes assigned with relative
and/or absolute cell references, in accordance with the
task specifications
4 Test formulae to confirm output meets task requirements

Element:

Prepare to develop spreadsheet.

Performance Criteria:

1 Organise personal work environment in accordance with
ergonomic requirements
2 Analyse task and determine specifications for
spreadsheets
3 Identify organisational and task requirements in relation to
data entry, storage, output, reporting and presentation
requirements
4 Apply work organisation strategies and energy and
resource conservation techniques to plan work
activities


Learning Outcomes



Details of Learning Activities

Students will use MS Office Excel 2010 for this competency. Learning activities will include class-based discussions, demonstrations, practical exercises and observations in order to develop competency including the underpinning skills and knowledge. In addition to the assessments, formative feedback is provided to students throughout the duration of the course.

Some learning activities will include a self-directed learning approach. Self-directed learning refers to organised teacher-directed learning activities that you will undertake independently, either as individuals or with other students.

This unit contains employability skills.


Teaching Schedule

Week beginning Content & Element of competency Requirements
Week 1 - 4 July

Introduction to course and Blackboard.

Prepare to develop spreadsheets.

Text pg i - xxxi
Week 2 - 11 July

 Prepare to develop spreadsheet; Use spreadsheets

Text Section 1 & 2
Week 3 - 18 July Prepare to develop spreadsheet; Use spreadsheets; Represent numerical data in graphic form Text Section 2 & 3
Week 4 - 25 July Prepare to develop spreadsheet; Use spreadsheets; Represent numerical data in graphic form Text Section 3
Week 5 - 1 Aug Assessment Portfolio 1 Prepare to develop spreadsheet; Use spreadsheets; Represent numerical data in graphic form. Text & printing credits
Week 6 - 8 Aug Prepare to develop spreadsheet; Use spreadsheets; Develop a linked spreadsheet solution Text Section 4
Week 7 - 15 Aug Assessment Portfolio 2 Prepare to develop spreadsheet; Use spreadsheets; Develop a linked spreadsheet solution; Represent numerical data in graphic form. Text & printing credits
Week 8 - 22 Aug Prepare to develop spreadsheet; Use spreadsheets Text Section 5
   Midsemester Break 29 August - 2 September  
Week 9 - 5 Sept Assessment Portfolio 3 Prepare to develop spreadsheet; Use spreadsheets; Develop a linked spreadsheet solution Text & printing credits
Week 10 - 12 Sept Prepare to develop spreadsheet; Use spreadsheets; Automate and standardise spreadsheet operation. Text Section 6
Week 11 - 19 Sept Prepare to develop spreadsheet; Use spreadsheets;  Automate and standardise spreadsheet operation. Text Section 6
Week 12 - 26 Sept Assessment Portfolio 4 Prepare to develop spreadsheet; Use spreadsheets; Develop a linked spreadsheet solution; Automate and standardise spreadsheet operation. Text & printing credits
Week 13 - 3 Oct Prepare to develop spreadsheet; Use spreadsheets; Develop a linked spreadsheet solution; Represent numerical data in graphic form; Automate and standardise spreadsheet operation.  Text
Week 14 - 10 Oct Prepare to develop spreadsheet; Use spreadsheets; Develop a linked spreadsheet solution; Represent numerical data in graphic form; Automate and standardise spreadsheet operation.  Text
Week 15 - 17 Oct Assessment Portfolio 5 Prepare to develop spreadsheet; Use spreadsheets; Develop a linked spreadsheet solution; Represent numerical data in graphic form; Automate and standardise spreadsheet operation. Text & printing credits
Week 16 - 24 Oct Assessment Journal Employability Skills and Feedback  


Learning Resources

Prescribed Texts

Price & Wix, Develop and use complex spreadsheets Excel 2010, Software Publications

9781921780783


References


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

Students will complete a portfolio of evidence which focuses on the practical component of developing and using complex spreadsheets using Microsoft Excel 2010. Each document created is to be completed individually in class as indicated on the Teaching Schedule and is open book.

Note: Students who have been granted special consideration will be able to sit their assessment by arrangement with the class teacher during the scheduled class time in week 17.

Employability Skills

Students will also complete evidence of employability skills developed whilst completing this course which must be submitted by COB Monday 24 October. Assessmentssubmitted late will attract a DNS/NYC grade. Refer to Student Diary for Special Consideration/Extension of Time procedure. If an Extension of Time is granted note that the grade given will be either NYC/CA.


Assessment Matrix

Part of element of competency Doc 1 Doc 2 Doc 3 Doc 4 Doc 5
Prepare to develop spreadsheet Yes Yes Yes Yes Yes
Develop a linked spreadsheet solution Yes Yes Yes Yes Yes
Automate and standardise spreadsheet operation       Yes Yes
Use spreadsheets Yes Yes Yes Yes Yes
Represent numerical data in graphic form Yes Yes     Yes

 

CHD CDI CC CA NYC/DNS
Competency achieved with high distinction Competency achieved with distinction Competency achieved with credit Competency achieved with pass Not yet competent/Did not submit

Course Overview: Access Course Overview