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 beginningTopics CoveredPractical 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 FebWord Units A & B & C
Getting Started
Editing Documents
Formatting text and paragraphs
In-class exercises
Week 3 - 26th FebWord Units D & E
Formatting Documents
Creating and Formatting Tables
In-class exercises
Week 4 - 5th MarchWord F & H
Illustrating Documents with Graphics
Merging Word Documents
In-Class exercises
Week 5 - 12th MarchReview and Consolidation of MS WordCompetency Status Review
Week 6 - 19th MarchExcel 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 AprilExcel Unit D & G
Working with Charts
Automating worksheet task
In-Class exercises
 5 - 11 April - Mid-Semester Student Vacation (Easter Break) 
Week 8 – 12 AprilExcel Unit E & G
Working with Formulas and Functions Automating worksheet task
In-Class exercises
Week 9 - 16th AprilReview and Consolidation of MS ExcelCompetency Status Review
Week 10 - 23rd AprilAccess A & B
Getting Started
Using Tables and queries
In-class exercises
Week 11- 30th AprilAccess C & D
Using Forms
Using Reports
In-Class exercises
Week 12 - 7th MayAccess E & F
Modifying the Database Structure
Creating Multiple Table Queries
In-class exercises
Week 13 - 14th MayAccess G & H
Developing Forms and Subforms
Sharing Information and improving Reports
In-class exercises
Week 14- 21st MayReview and Consolidation of MS AccessCompetency Status Review
Week 15 - 28th MayIntegration of Software Applications 
Week 16 - 4th JuneGraded Assessment on Word & Excel 
Week 17 - 11th JuneGraded Presentation on Access 
Week 18 - 18th JuneFeedback 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