Course Title: Use technology in the workplace

Part B: Course Detail

Teaching Period: Term2 2009

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:Ron Schnellbeck
Course Contact Phone:(03) 9925-5968
Course Contact Email:Ron.schnellbeck@rmit.edu.au

Course Contact Name:Joyce Liang
Course Contact Phone:(03)9925-5464
Course Contact Email:Joyce.liang@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:

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

Element:

Clarify the function that the equipment fulfils

Performance Criteria:

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

Element:

Save files/data and produce computer reports as required

Performance Criteria:

Files/data are saved following standard procedures prior to exiting the computer equipment
Reports and document are produced
Data and documents are appropriately stored as required
Procedures for shutting down computers are followed
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:

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

Element:

Use and maintain other workplace equipment

Performance Criteria:

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

Element:

Use manuals and online help to solve computing problems

Performance Criteria:

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


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

 Weekly Schedule 
Week beginningTopics CoveredPractical and Assessments
Week 1  Course Overview
O H & S, E-Mail & File Management, Equipment Maintenance procedures
Teacher handouts and in-class exercises.
Week 2 MS Word - Getting Started
Editing Documents
Formatting text and paragraphs
In-class exercises
Week 3 MS Word 
Formatting Documents
Creating and Formatting Tables
In-class exercises
Week 4 MS Word
Illustrating Documents with Graphics
Merging Documents
In-Class exercises
Week 5 Review and Consolidation of MS WordCompetency Status Review
Week 6 MS Excel - Getting started
Building and editing worksheets
In-class exercises
Week 7 MS Excel
Formatting a worksheet
Working with Formulas and Functions
In-Class exercises
Week 8 MS Excel
Working with Charts
Automating worksheet task
Feedback on Review &
Consolidation in MS Word
In-Class exercises
 Mid-Semester Student Break (31 Aug - 5 Sept) 
Week 9 Review and Consolidation of MS ExcelCompetency Status Review
Week 10 MS PowerPoint – Getting started
Creating and modifying Presentations
PowerPoint assignment handed out
In-class exercises
Week 11MS PowerPoint
Enhancing and customizing a Presentation
Use charts
Feedback on Review &
Consolidation in MS Word
In-Class exercises
Week 12 MS PowerPoint
Working with embedded objects and hyperlinks
In-class exercises
Week 13 MS PowerPoint
Using advanced features
In-class exercises
Week 14Review and Consolidation of MS PowerPointMS Power Point assignment due
Competency Status Review
Week 15Feedback on the competency status
Integration of Software Applications
 
Week 16Graded Assessment on Word & Excel 
Week 17 Graded Assessment on MS PowerPoint 
Week 18 Feedback and review 


Learning Resources

Prescribed Texts

Materials available from the Learning Hub


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:

 Practical Review and
Consolidation exercise MS Word
Practical Review and
Consolidation exercise MS Excel
Practical Review and
Consolidation exercise
MS PowerPoint
Final Graded Assessments
(MS Excel,
MS Word
MS PowerPoint)

1. Clarify the function that the equipment fulfils YYYFor Grading Purposes Only
2. Access and enter information from/into the computer YYYFor Grading Purposes Only
3. Save files/data and produce computer reports as required YYYFor Grading Purposes Only
4. Use manuals and online help to solve computing problems YYYFor Grading Purposes Only
5. Undertake routine maintenance of computers and associated devices YYYFor Grading Purposes Only
6. Use and maintain other workplace equipment YYYFor Grading Purposes Only

Other Information

To be deemed competent in EMPL 5581C Use Technology in the Workplace the following criteria should be met:

Competency Based Assessment
Students will be provided with more than one opportunity to demonstrate competence.
Competency based assessment is detailed below in “Assessment methods” and “Assessment Tasks”.

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 methods have been designed to measure achievement of each competency in a flexible manner over multiple tasks.

For grading purposes an optional final test will be offered during the last weeks of classes.
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.

Grading
A pass in each assessment will result in competency for the student (a mark of 50). Competency MUST be achieved in all assessments of the course for eligibility to sit the final test for a graded result to be obtained.
In order to obtain a mark greater than 50, the student must gain a pass in each of the software applications covered in the final test.
Graded results will apply the following mark table:

GradeMarkDescription
HD> = 80High Distinction
DI70 - 79Distinction
CR60 - 69Credit
PA50 - 59Pass
NN0 - 49Fail (Not Yet Competent)
NYCNot ApplicableNot Yet Competent

Course Overview: Access Course Overview