Course Title: Use technology in the workplace

Part B: Course Detail

Teaching Period: Term1 2007

Course Code: EMPL5394C

Course ID: 038932

Course Title: Use technology in the workplace

School: 650T TAFE Business

Program Code: C4170 - Certificate IV in Financial Services

Course Contact : Swati Dave

Course Contact Phone: +61 3 9925 5811

Course Contact Email: swati.dave@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

Training Package Pre-requisites: Nil

Course Description

This unit 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 and RMIT’s internet and email applications.


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

FNSICGEN302A Use technology in the workplace

Element:

Access and enter information from / into the computer

Performance Criteria:

1. Organisational 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 organisation'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 organised 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


NONE


Overview of Learning Activities


Details of Learning Activities

The Course will be taught through Classroom lecture and tutorial delivery providing theories and concepts and the opportunity to gain hands-on experience in all areas discussed. Students will be required to complete set tasks from their text and/or handouts within a specified time frame.

The use of “real world” examples will facilitate the understanding of the theoretical concepts and students will be encouraged to use lateral thinking.

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 (Intro), MS Excel (Intro) and MS Access (Intro) 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). The student must achieve competency (a pass) in each assessment to be deemed competent. 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 pass all the packages covered in the final test.


Graded results will apply the following

Grade HD   Mark > = 80   Description High Distinction (Competency Achieved)
Grade DI   Mark  70 - 79   Description  Distinction (Competency Achieved)
Grade CR   Mark  60 - 69   Description  Credit (Competency Achieved)
Grade PA   Mark  50 - 59   Description  Pass (Competency Achieved)
Grade NN   Mark  0 - 49   Description  Fail (Not Yet Competent)
Grade NYC   Mark  Not Applicable   Description  Not Yet Competent






Teaching Schedule

  Weekly Schedule  
Week beginning Topics Covered Practical and Assessments
Week 1 - 12th Feb
Course Introduction 		Course Overview
O H & S, E-Mail & File Management, Equipment Maintenance procedures 		Teacher handouts and in-class exercises.
Week 2 - 19th Feb Word Units A & B & C
Getting Started
Editing Documents
Formatting text and paragraphs 		In-class exercises
Week 3 - 26th Feb Word Units D & E
Formatting Documents
Creating and Formatting Tables 		In-class exercises
Week 4 - 5th March Word F & H
Illustrating Documents with Graphics
Merging Word Documents 		In-Class exercises
Week 5 - 12th March Review and Consolidation of MS Word Competency Status Review
Week 6 - 19th March Excel Unit A & B
Getting started
Building and editing worksheets 		In-class exercises
Week 7 - 26th March Excel Unit C & E
Formatting a worksheet
Working with Formulas and Functions 		In-Class exercises
Week 8 – 12 April Excel Unit D & G
Working with Charts
Automating worksheet task 		In-Class exercises
  5 - 11 April - Mid-Semester Student Vacation (Easter Break)  
Week 8 – 12 April Excel Unit E & G
Working with Formulas and Functions Automating worksheet task 		In-Class exercises
Week 9 - 16th April Review and Consolidation of MS Excel Competency Status Review
Week 10 - 23rd April Access A & B
Getting Started
Using Tables and queries 		In-class exercises
Week 11- 30th April Access C & D
Using Forms
Using Reports 		In-Class exercises
Week 12 - 7th May Access E & F
Modifying the Database Structure
Creating Multiple Table Queries 		In-class exercises
Week 13 - 14th May Access G & H
Developing Forms and Subforms
Sharing Information and improving Reports 		In-class exercises
Week 14- 21st May Review and Consolidation of MS Access Competency Status Review
Week 15 - 28th May Integration of Software Applications  
Week 16 - 4th June Graded Assessment on Word & Excel  
Week 17 - 11th June Graded Presentation on Access  
Week 18 - 18th June Feedback and review  

Overview of Learning Resources


Learning Resources

Prescribed Texts

Illustrated Word (Introductory), Illustrated Excel (Introductory) & Illustrated Access (Introductory)
Shrinkwrap ISBN 9-781418-85246-7

Components in ShrinkWrap The text books above can be purchased as a shrink wrapped package in the RMIT Business Bookshop on the ground floor of building 108.
Students are to make sure that they purchase the correct version of shrink wrapped version related to their course as once opened, these books cannot be returned to the RMIT bookshop,


 Jennifer A. Duffy 2005
Microsoft Office Word 2003 (Introductory), ISBN 9-7814-1884301-4
ILLUSTRATED SERIES™, Course Technology, Boston.

 Reding & Wermers 2005
Microsoft Office Excel 2003 (Introductory), ISBN 9-7814-1884295-6
ILLUSTRATED SERIES™, Course Technology, Boston.

 Friedrichsen, Lisa 2005
Microsoft Office Access 2003 (Introductory), ISBN 9-7814-1884298-7


References


Other Resources


Overview of Assessment

Competency Status Review – Consolidation Exercises
The consolidation exercises on packages will be conducted to test the competency status of a student and will focus on the student’s practical ability to solve problems and provide professionally reasoned and practical solutions to a scenario provided to them in class.

Exam
A voluntary exam will be conducted at the end of the course for grading purposes only.
In addition to the assessments, formative feedback is provided to the students throughout the duration of the course.


Assessment Tasks

Consolidation Exercises
The consolidation assessments in class will focus on the student’s practical ability to solve problems and provide practical solutions to a scenario given to them in class. The consolidation exercise is open book and conducted in the computer laboratories and students are encouraged to use all the resources at their disposal 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.


Course Overview: Access Course Overview