Course Title: Develop and use complex spreadsheets
Part B: Course Detail
Teaching Period: Term1 2014
Course Code: COSC5946C
Course Title: Develop and use complex spreadsheets
School: 650T TAFE Business
Campus: City Campus
Program: C5317 - Diploma of Financial Planning
Course Contact : Michael Elliot
Course Contact Phone: +61 3 9925 5519
Course Contact Email:michael.elliot@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
Michael Elliot
+61 3 9925 5519
Building 80, Level 5
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 unit describes the performance outcomes, skills and knowledge required to use spreadsheet software to complete business tasks and to produce complex documents.
No licensing, legislative, regulatory or certification requirements apply to this unit at the time of endorsement.
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title: |
BSBITU402A Develop and use complex spreadsheets |
Element: |
1. Prepare to develop spreadsheet |
Performance Criteria: |
1.1. Organise personal work environment in accordance with ergonomic requirements |
Element: |
2. Develop a linked spreadsheet solution |
Performance Criteria: |
2.1. Utilise spreadsheet design software functions and formulae to meet identified requirements |
Element: |
3. Automate and standardise spreadsheet operation |
Performance Criteria: |
3.1. Evaluate tasks to identify those where automation would increase efficiency |
Element: |
5. Represent numerical data in graphic form |
Performance Criteria: |
5.1. Determine style of graph to meet specified requirements and manipulate spreadsheet data if necessary to suit graph requirements |
Element: |
4. Use spreadsheets |
Performance Criteria: |
4.1. Enter, check and amend data in accordance with organisational and task requirements |
Learning Outcomes
Details of Learning Activities
This unit is delivered using a blend of classroom based and self -paced learning activities.
Teaching Schedule
Teaching Schedule | |||
| Week | Week Commencing | Topics | Assessment |
| 1 | 10th February | Pre-training review: • RPL /LLN Familiarisation with: • Program • Services/facilities • Other students • Teacher(s) • Where to get support • Student responsibilities • Course requirements • Course support documents • Pre-reading • Blackboard • Overview of assessment requirements • Grading • Plagiarism • Appeals • Extensions • Feedback • Privacy • Submission requirements • Resubmission policy Financial Services Industry – Module 1- Chapter 1 Spreadsheet exercises |
|
| 2 | 17th February | Spreadsheet exercises Financial Services Industry – Module 1- Chapter 1 |
|
| 3 | 24th February | Financial Services Industry – Module 1- Chapter 2 | Assessment Handed Out Excel Activity Questions (CA/NYC) |
| 4 | 3rd March | Financial Services Industry – Module 1- Chapter 2 continued |
|
| 5 | 10th March | Financial Services Industry – Module 1- Chapter 3 | |
| 6 | 17th March | Financial Services Industry – Module 1- Chapter 3 continued |
|
| 7 | 24th march | Financial Services Industry – Module 1- Chapter 4 | |
| 8 | 31st March | Financial Services Industry – Module 1- Chapter 4 Continued Financial Services Industry – Manage Client Services- Chapter 1 |
|
| 9 | 7th April | Financial Services Industry – Manage Client Services- Chapter 1 |
|
| 10 | 14th April | Financial Services Industry – Manage Client Services- Chapter 2 | 18th Good Friday Public Holiday |
| 21st April | Mid semester break (18th to 27th April.) | ||
| 11 | 28th April | Financial Services Industry – Manage Client Services- Chapter 3 | |
| 12 | 5th May | Financial Services Industry – Manage Client Services- Chapter 4 | |
| 13 | 12th May | Financial Services Industry – Manage Client Services- Chapter 5 Introduction to Role Plays (This is outlining the assessment) |
Final Role Play Assessment discussion Excel Assessment Due |
| 14 | 19th May | Completion of role Plays and Final assessment review and Discussion | Final Role Play Assessment Practice With teacher |
| 15 | 26th May. | Assessment 3 – (CA/NYC) (From Topics covered in Weeks 3 to Weeks 12)
|
Continued as per above (CA/NYC) |
| 16 | 2nd June | Re-submissions if required | (CA/NYC) |
Learning Resources
Prescribed Texts
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 tests, 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.
You are advised that you are likely to be asked to personally demonstrate your assessment work to your teacher to ensure that the relevant competency standards are being met. You will be provided with feedback throughout the course to check their progress.
Assessment Tasks
Assessment Tasks
You are required to complete the following tasks. You must successfully complete these tasks to be deemed competent in this unit.
Task 1
This will be developing an excel spreadsheet. (CA/NYC)
Excel Assessment Due Week 9
Task 2
Client/Adviser Role Play (CA/NYC)
Task 3
Open Book Assessment on topics from Weeks 1 to Weeks 12 (CA/NYC)
This course is co-delivered and/or co-assessed.
Marking Guide (competency):
Vocational Education and Training (VET) is based on current industry needs and the focus on preparing you for the workplace. Because VET courses are informed by practical application of knowledge and skills, they are based on a system known as ‘competency based training’ (CBT). So when you are assessed in VET it is about whether you are competent to do the job, as well as having a firm grasp on the knowledge and skills required to do that job, as opposed to traditional curriculum based education settings that are often based on knowledge retention.
You need to demonstrate you are competent in each element of the unit of competency you are studying.
You will receive feedback on each assessment task that will inform you whether you are competent or not and how well you are performing. Once competent in all elements of the unit you receive a competency grading.
Please refer to the Final Grades table below.
Marking Guide (Grading)
After achieving competency we then grade your performance in the unit; this gives you the opportunity to have the level of your performance formally recognized against industry standards and employability skills.
The grading is according to the following criteria:
1. LEVEL OF INDEPENDENCE, INITIATIVE, ENTERPRISE AND PERFORMANCE OF WORK TASK
We are looking for a high level of ability to complete all tasks independently as per the specifications as well as demonstrating a high level of initiative in your approach to job roles such as a actuaries, intermediaries, managers or supervisors, marketing and sales personnel, underwriters and other relevant organisational personnel. Have the ability to confirm to work requirements, using questioning and active listening as required, liaise with others, share information, listen and understand and use language and concepts appropriate to cultural differences.
2. DEMONSTRATED BREADTH OF UNDERPINNING KNOWLEDGE AND A WILLINGNESS TO CONTINUE LEARNING
We are looking for depth of understanding of the key concepts and knowledge required in accessing and managing financial services information, accessing financial product and services information and interpreting documentation. We are also looking at literacy skills to read, write, edit and proofread documents to ensure clarity of meaning, accuracy and consistency of information. Students should have knowledge of the basis of actuarial analysis and decisions, risk assessment policies and procedural guidelines, underwriting policies and procedures, geographic and demographic data, insurance products, premiums, extent of insurance coverage and other conditions of the insurance contract, investment product information, data and trends. Students should also have an understanding about insurance for accidental damage, burglary/theft, business interruption, defined events, employee fraud, environment and pollution, fire and perils, general and products liability, personal accident and illness, professional indemnity, public liability, directors and officers. Students should understand about, reinsurance, the relationship between underwriting and rate making, relevant legislation, regulatory guidelines and industry sector compliance requirements, such as the Insurance Contracts Act, Privacy Act, Trade Practices and Corporations Act. Knowledge of the risk analysis/prevention methods and application and type of risk and probability of likely occurrence.
3. TECHNIQUES & PROCESSES, TECHNOLOGY SKILLS AND PROBLEM SOLVING
We are looking for appropriate use of technology to assist in presenting all tasks clearly and suitable for the intended audience. You also need to show an understanding of the kinds of problems that can arise in managing client services or reporting and to develop options to resolve these issues when they arise. We also want you to interpret and apply organisation policy and procedures. Apply knowledge and skills in the area of risk identification and assessment. How compliance with legislation and regulations and industry codes of practice in monitoring, analysing and determining risk ratings is determined.
4. WORK ORGANISATION, PLANNING AND SELF MANAGEMENT
We expect to see ongoing uploading of information that is relevant to the unit, full utilisation of Blackboard as per course requirements and timely submission of all required assessment tasks. Teamwork skills
problem solving skills to identify any issues that have the potential to impact on organisational skills, including the ability to plan and sequence work. Self-management skills for complying with ethical, legal and procedural requirements.
5. COMMUNICATION, PEOPLE NETWORKING, LANGUAGE AND INTERPERSONAL SKILLS AND TEAMWORK
We expect to see contributions to relevant discussions and scheduled classroom sessions. In addition your tasks should demonstrate a very good understanding of strategies for well-developed literacy skills for analysing information on client needs and preparing clear written advice, plans and reports. This includes research skills such as: accessing and managing information, interpreting documentation and coordinating tasks.
Final Grades table:
CHD Competent with High Distinction
CDI Competent with Distinction
CC Competent with Credit
CAG Competency Achieved – Graded
NYC Not Yet Competent
DNS Did Not Submit for assessment
Assessment Matrix
Course Overview: Access Course Overview