Course Title: Use technology in the workplace

Part B: Course Detail

Teaching Period: Term1 2011

Course Code: EMPL5581C

Course Title: Use technology in the workplace

School: 650T TAFE Business

Campus: City Campus

Program: C4210 - Certificate IV in Financial Services

Course Contact : Clem simonetto

Course Contact Phone: +61 3 9925 5426

Course Contact Email:clem.simonetto@rmit.edu.au


Name and Contact Details of All Other Relevant Staff

Course Contact Name: Nawal Shomali

Course Contact Phone: (03)9925-5826

Course Contact Email: nawal.shomali@rmit.edu.au

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

There are no pre-requisites and co-requisites.

Course Description

This Unit of Competency covers using computers and associated devices and office technology to achieve outcomes required in the workplace.
The office technology used will include Microsoft Office packages, Internet and email applications.


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

FNSICGEN302B Use technology in the workplace

Element:

Access and enter information from/into the computer

Performance Criteria:

1. Organizational procedures for accessing computer based equipment are followed.
2. The computer system is navigated to find the required program/file
3. Appropriate software, including custom built software, is selected
4. The program/file is opened and the required data is identified
5. Data is entered, changed or removed as needed
6. Files are checked for accuracy
7. Internet/intranet searching and sending and receiving of emails is undertaken and relevant information or files are saved as required

Element:

Clarify the function that the equipment fulfils

Performance Criteria:

1. Computing equipment, associated devices and other equipment used in the workplace are identified
2. Functions of the computer equipment, associated devices and other equipment and the outcomes they are used to achieve are determined

Element:

Save files/data and produce computer reports as required

Performance Criteria:

1. Files/data are saved following standard procedures prior to exiting the computer equipment
2. Reports and document are produced
3. Data and documents are appropriately stored as required
4. Procedures for shutting down computers are followed
5. Equipment and data is secured as required by the organization’s policies and procedures and/or as required by legislation or regulations and codes of conduct

Element:

Undertake routine maintenance of computers and associated devices

Performance Criteria:

1. Routine maintenance tasks are carried out according to manufacturer's instructions
2. Technical assistance is sought as necessary

Element:

Use and maintain other workplace equipment

Performance Criteria:

1. Other equipment is used to achieve workplace outcomes as required
2. Routine maintenance is carried out or organized in line with manufacturer's instructions
3. Consumables for office equipment are used and replaced as required

Element:

Use manuals and online help to solve computing problems

Performance Criteria:

1. Manuals, training notes, or company documentation are used to solve problems
2. Online help is accessed to solve problems


Learning Outcomes


Refer to the performance elements in part A and the performance criteria in Part B


Details of Learning Activities

Theory sessions, Practical lab sessions, Tutorial sessions, assignments and homework


Teaching Schedule

The total number of scheduled hours of teaching, learning and assessment involved in this course will include all planned activities. This may incorporate face-to-face classes, lectures, workshops and seminars; wherever possible workplace visits, online learning and other forms of structured teaching and learning. The total scheduled hours includes the amount of effort required to undertake, evaluate and complete all assessment requirements, including observation of work performance, discussions with supervisors and others providing third party evidence and one on one and group assessment sessions with students.
  Weekly Schedule  
Week beginning Topics Covered Practical and Assessments

Week 1 - 7th Feb, 11 

 Course Overview
O H & S, E-Mail & File Management, Equipment Maintenance procedures 		Teacher handouts and in-class exercises.
Week 2 - 14th Feb, 11 MS Word - Getting Started
Editing Documents
Formatting text and paragraphs

Assignment handed out

In-class exercises
Week 3 - 21st Feb, 11 MS Word 
Formatting Documents
Creating and Formatting Tables 		In-class exercises
Week 4 - 28th Feb, 11 MS Word
Illustrating Documents with Graphics
Merging Documents

In-Class exercises

Word Assignment Due
Week 5 - 7th Mar, 11 MS Excel - Getting started
Building and editing worksheets 		In-class exercises
Week 6 - 14th Mar, 11 MS Excel
Formatting a worksheet
Working with Formulas and Functions 		In-Class exercises
Week 7 - 21st Mar, 11 MS Excel
Working with Charts
Automating worksheet task

Feedback on Word Assignment

In-Class exercises
Week 8 - 28th Mar, 11 MS Excel
Analyzing Data Using Formulas

In-Class exercises
Week 9 - 4th Apr, 11 MS PowerPoint – Getting started
Creating and modifying Presentations

In-Class exercises

Excel Assignment Due

Week 10 - 11th Apr, 11 MS PowerPoint
Enhancing and customizing a Presentation
Use charts		 In-class exercises
Week 11 - 25th Apr, 11 MS PowerPoint
Working with embedded objects and hyperlinks		 Feedback on Excel Assignment
In-Class exercises
Mid Semester Easter Break Wed 21st April – Thurs 27th April, 2011
Week 11 - 25th Apr, 11  MS PowerPoint
Working with embedded objects and hyperlinks		 Feedback on Excel Assignment
In-Class exercises
Week 12 - 2nd May, 11 MS PowerPoint
Working with advanced tools and masters

In-class exercises

PowerPoint Assignment Due
Week 13 - 9th May, 11 Integration of Word, Excel and PowerPoint In-class exercises
Week 14 - 16th May, 11 Integration of Word, Excel and PowerPoint (Cont.) In-class exercises
Week 15 - 23rd May, 11 Integration of Word, Excel and PowerPoint (Cont.)  In-class exercises
Week 16 - 30th May, 11 Integration Task/Project


Learning Resources

Prescribed Texts

There is no prescribed text book required in this course. Course materials including: lecture notes, learning materials, and class exercises are available to students via online, network and/or in hard copies.


References

On line MS Office references and any text books on MS Excel.


Other Resources


Overview of Assessment

Competency Based Assessment
Students will be provided with more than one opportunity to demonstrate competence.

Assessment Methods
Assessment for competency in this course will require students to present a variety of in class exercises in MS Word (Introduction), MS PowerPoint (Introduction) & MS Excel (Introduction) throughout the course. The student must demonstrate an understanding of all elements of a competency to be deemed competent.


Assessment Tasks

Consolidation Exercises
The in class exercises will focus on the students’ practical ability to solve problems and provide practical solutions to a given scenarios.

The review and consolidation assessments are open book and conducted in the computer laboratories. Students are encouraged to use the online and text resources to provide professionally reasoned solutions to the problems given.

Final Graded Assessment [Optional]
An optional graded assessment will be conducted at the end of the course for grading purposes only.


Assessment Matrix

For a student based at the RMIT BUSINESS campus in Melbourne, Australia in
Semester 2, 2009 the assessment will be:

 Elements MS Word
Task/Project
CA/NYC (20%)		 MS Excel
Task/Project
CA/NYC (20%)		 MS PowerPoint
Task/Project
CA/NYC (20%)		 Integration
Task/Project
CA/NYC
(40%)
1. Clarify the function that the equipment fulfils Y Y Y Y
2. Access and enter information from/into the computer Y Y Y Y
3. Save files/data and produce computer reports as required Y Y Y Y
4. Use manuals and online help to solve computing problems Y Y Y Y
5. Undertake routine maintenance of computers and associated devices Y Y Y Y
6. Use and maintain other workplace equipment Y Y Y Y

Other Information

Other Information
Competency and grading requirements:

To be deemed competent students must demonstrate an understanding of all elements of a competency. Assessment methods have been designed to measure achievement of each competency in a flexible manner over multiple tasks.
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.

All assessments for this course must be completed successfully to achieve CA (Competency Achieved) grade.
Each assessment task will also carry a numerical weighting to be used for grading purposes. The grade applied to this weighting will only be awarded if a CA has been achieved in all compulsory assessment tasks.
If a student has been marked NYC (Not Yet Competent) in any of the assessment tasks, the weighting will carry no value until the student has obtained CA.
If a CA is achieved on re-assessment then a maximum mark of 50% of the original weighting will be granted for that assessment.
Reassessments will only be granted to students who were either unsuccessful in the first attempt or have an approved special consideration application.

Course Overview: Access Course Overview