ITHHGCT01AEM-Access and Retrieve Computer Data
ITHHGCT01AEM-Access and Retrieve Computer Data
ITHHGCT01AEM-Access and Retrieve Computer Data
Unit Title:
ACCESS AND RETRIEVE
COMPUTER DATA
This package has been produced to provide information that can be used to
complement the materials that are already available. The package is not
intended to replace current resources.
Assessment
The formal process ensuring training meets the standards required by industry. This process
is performed by a qualified assessor within a nationally agreed framework.
Assessor
An assessor is a person who is certified by industry to assess whether a worker is competent
to undertake specific tasks.
Competent
Able to do the job and has all the necessary skills, knowledge and attitude to perform
effectively in the workplace, according to agreed standards.
Context of assessment
Specifies where, how and by what methods assessment should occur.
Elements
The skills, which make up a unit of competence.
Evidence guide
These are guidelines on how a unit should be assessed.
Fair
Does not disadvantage particular Trainees or students.
Flexible
Acknowledges that there is no single approach to the delivery and assessment of
performance in a competency-based system.
Formative assessment
These are small assessment tasks done during training. They assist in making sure that
learning is taking place and also give the Trainees or students feedback on their progress.
Key competencies
Competencies that underpin all work performance. These are: collecting, analysing and
organising ideas and information, communicating ideas and information, planning and
organising activities, working with others and in teams, solving problems, using technology,
using mathematical ideas and techniques.
Performance criteria
This is used to judge whether an individual has achieved competence in a unit.
Range of variables
This details the range of different contexts that may apply to a particular unit.
Reliable
Uses methods and procedures that confirm that the competency standards and their levels
are interpreted and applied consistently in all contexts and to all Trainees or students.
Summative assessment
The assessment done after training of the completed unit of competence to ensure that
Trainees or students have achieved the performance criteria.
Trainee or student
A trainee or student is a person who is being taught knowledge or skills.
Unit descriptor
A general description of the competency standard.
Valid
Judgement on the same evidence and criteria
Package for Hospitality Training – Access and retrieve computer data iii
will produce the same assessment outcomes
from different assessors.
Appendices
1 Competency assessment result.
2 Group trainee or student assessment record.
3 List of overheads and handouts.
4 Trainee or student evaluation sheet.
5 Amendment list.
Section 1
Introduction to this guide
1.1 Introduction
Welcome to this guide.
This guide uses Competency Based Training to teach workplace skills. It is based on
competency standard that is a nationally agreed statement of the skills, attitude and
knowledge needed for a particular task. The major emphasis is on what an individual can do
as a result of training. One of the most important characteristics of Competency Based
Training is its focus on training individuals for actual jobs in the workplace.
This will help you teach the competency Access retrieve computer data.
This guide deals with the skills and knowledge required for basic data entry on a computer.
Care should be taken in developing training to meet the requirements of this unit. For general
and prevocational training, organisations providing training which takes into consideration the
full range of industry contexts, with no bias towards individual sectors. The Range of
Variables will assist in this regard. For sector-specific delivery, training should be tailored to
meet the needs of that sector.
Teachers and Trainer or teachers should structure their sessions according to the:
needs of their students/Trainees
requirements of their organisation
time available for training
training situation.
A delivery strategy has been provided for the teachers and Trainer or teachers. The
suggested content gives an indication of what needs to be covered in the program to meet the
competency standard.
The delivery strategy used and assessment provided in this unit is not compulsory and should
be used as a guide. Teachers and Trainer or teachers are encouraged to utilise their own
industry knowledge, experience, local examples and products to adapt the materials or
develop their own resources, in order to ensure the relevance of the training.
One of your roles as a Trainer or teacher or teacher is to ensure high standards of service
through effective training. To ensure that you are ready to start working on this competency
with Trainees or students, consider the following questions:
How confident do you feel about your own knowledge and skills required to deliver each
element?
Is there any new information or laws that you may need to access before you start training?
Do you feel confident about demonstrating the practical tasks?
Will you be able to clearly explain the underpinning knowledge that your trainee or student will
need to do the job properly?
Are you aware of the scope of industry situations in which the competency may apply?
Are you aware of the language, literacy and numeric skills your Trainees or students need to
demonstrate competency in this standard?
Have you consider access and equity issues in planning the delivery of this training program?
Trainer or teachers should select training strategies that are appropriate for the competency
being taught, the situation and the needs of the learners. For example, if practising on-the-job
is not possible, varied simulations and role-plays may be appropriate.
UNIT DESCRIPTOR This unit deals with the skills and knowledge required for basic
data entry on a computer.
RANGE OF VARIABLES
1. This unit applies to all tourism and hospitality sectors.
2. Computer systems and software programs will vary depending upon the enterprise.
EVIDENCE GUIDE
1. Underpinning skills and knowledge
1.1 To demonstrate competence, evidence of skills and knowledge in the
following areas is required:
a. basic database functions
b. data entry
c. national guidelines for computer based equipment (if any).
2. Context of assessment
2.1 This unit may be assessed on or off-the-job. Assessment should include
practical demonstration either in the workplace or through a simulation. This
should be supported by a range of methods to assess underpinning
knowledge.
3. Critical aspects of assessment
3.1 Look for ability to accurately enter and amend data within designated
timelines.
4. Linkages to other units
1.1. Computer is turned on / Computer systems and software Correct seating of Exp HO 1
accessed correctly. programs will vary depending upon computer
the enterprise.
Main part s of a computer Exp OHT 1
Pre HO 2
1.3. File is correctly identified and Computer drives and Exp OHT 3
opened. addressed PA & HO 4
2.2. Copy of the data is printed as Moving around the Exp OHT 7
required. document PA & HO 8
Legend:
Brainstorm – B Guest Speaker – GS Project – Pro
Case Study – CS Handout – HO Questioning – Q
Demonstration – Dem Multimedia – MM Role Play – RP
Discussion – Dis Overhead Transparency – OHT Research – R
Excursion – Ex Practical Application – PA Simulation – S
Group Work – GW Presentation – Pre Video – V
Explanation – Exp
Trainer or teacher to explain that if the body is kept tensed in one position for a long period of time, muscles,
tendons and nerves become strained or overused. This can result in neck ache, backache, wrist ache and
even eyestrain.
Handout 1 [Correct seating procedures].
Trainer or teacher to explain the four basic parts of the computer, their functions and shows where the main
switch and the switch for the screen are generally located.
OHT 1 and Handout 2 [Main parts of a computer].
Trainer or teacher to evaluate trainee competence, provide feedback and conduct group discussion.
Appropriate software is selected from the The Trainer or teacher to demonstrate the basic use of the keyboard and mouse and the vocabulary
menu associated with their use.
OHT 2 and Handout 3 [Elements of MS Word screen].
Trainer or teacher explain the detail how to use of the mouse.
Trainer or teacher to evaluate trainee competence, provide feedback and conduct group discussion.
Trainer or teacher explains the process of opening Microsoft Word:
click the Start button in the bottom left-hand corner of the screen to open the Start Menu
move the mouse pointer over Programs and the Sub-menu will appear on the right-hand side
move the mouse pointer over Microsoft Word
click the left mouse button once.
Trainer or teacher outlines the Elements of the Microsoft Word screen including:
title bar
menu bar
The file is correctly identified and opened. Trainer or teacher to explain the various drives in a computer including:
C drive (C: computer built in hard disk)
D drive: (D: CD Rom)
A drive (A: 3 ½” floppy disk).
Trainer or teacher to explain the concept of computer file addresses including:
Drive\
Folder (level 1)\
Folder (level 2)\
Folder (level 3)\
File name.
For example C:Letters\Package holidays\Clients\Lubis
Trainer or teacher to explain that files required can be located in any level of folder.
OHT 3 and Handout 4 [Computer drives and addresses].
Trainer or teacher to prepare folders and a file in each trainee’s computer with the above address. The file
Clients should contain a number of letters that may be found in the computer files of a travel agency with
information such as: letters confirming a booking, payment, destinations, departure date, cost of tickets, need
for a visa and recommendations regarding Hotel and Restaurant insurance.
Trainer or teacher to explain the process of opening the above file named “Lubis”.
Trainer or teacher to explain and demonstrate the processes of finding and opening a file.
Click on File in the Menu Bar
Trainer or teacher to prepare a fax to a Mr Hismanto confirming his group’s one-day tour of Jakarta on 21
January 2001, include the places that will be visited, the food that will be arranged, the price that will be
charged on a per person basis and the total price for the package and the pick-up point for the group. Give
this file a different computer address, for example: C:\Faxes\Tour groups\Clients\Hismanto.
Trainer or teacher to evaluate trainee competence, provide feedback and conduct a group discussion.
The keyboard/mouse is operated within Trainer or teacher to explain that people who apply for word processing jobs are sometimes tested for their
the designated speed and accuracy speed and accuracy before they are employed and, therefore, it is very important that trainees or students to
requirements develop their speed and accuracy skills.
Trainer or teacher to explain that there are standards in terms of speed and accuracy for a typist to produce
or edit documents.
In industry these standards may be clearly specified and stated in the form of words per minute (for example
30 words per minute).
Keystrokes per minute (for example 160 keystrokes per minute)
Trainer or teacher to identify actual examples of required speed of a junior typist from Hotel and Restaurant
offices and show these to the trainees or students.
Trainer or teacher goes on to explain why it is important to identify employers’ expectations of these timelines.
Trainer or teacher to produce a document in Bahasa Indonesia that contains approximately 1,600 keystrokes.
Each letter of a word, each space between words and each Enter counts as one keystroke.
Data to be retrieved is located within the Trainer or teacher to explain and demonstrate how to move around a document in order to edit:
file. Using Mouse techniques
Clicking in the document
Using the Scroll Bar
Using Keyboard Movement Commands.
Formatting documents Trainer or teacher to explain that formatting features of Microsoft word help add visual emphasis to parts of
the text. The front of text, the point size and the style can all be changed.
Trainer or teacher to explain why it is better (quicker) to type the text required, save it and then apply the
appropriate formatting.
Trainees or students to practice formatting documents after trainer or teacher give a demonstration.
The trainer or teacher to explain that if they try to exit the program without saving the work, Word will prompt
them to save it prior to exiting the program.
Trainer or teacher to explain the process of exiting the program:
Click File Exit
Trainees or students to practice saving, closing and shutting down the file and programs
Also remember:
change your position regularly – lift your arms, shake
your hands, shrug your shoulders, arch your back,
swivel your head
take frequent breaks from the computer – at least five
minutes every hour
during the breaks take a stroll and do some stretching
like toe touching, hip and neck swivelling.
SCREEN
CPU
KEYBOARD MOUSE
Screen:
an output device where results and information are
displayed on a screen
Keyboard:
To input data to the computer
Mouse:
A small hand held input device, which allows you to,
e.g. Reposition the cursor on screen, select menu
options and activities.
title bar
menu bar
standard toolbar
formatting toolbar
ruler
status bar
scroll bar.
Drives
C drive (C: computer built in hard disk)
D drive: (D: CD Rom)
A drive (A: 3 ½” floppy disk).
Computer Addresses
drive\
folder (level 1)\
folder (level 2)\
folder (level 3)\
file name.
For example:
C:Letters\Package holidays\Clients\Lubis
To Move Press
Up one line
Down one line
Left one character
Right one character
To highlight: Step:
A word double click the word
Mouse Techniques
Clicking in the document – if you can see the text you wish
to move to or edit, click the mouse at the new location.
This will move the insertion point to that location, and you
can begin typing or editing.
Using the Scroll Bar – The scroll bar allows you to move
through your document in small and big steps ranging
from one line to multiple pages.
headers
footers.
This text is right aligned and is 1.5 spaced. Right aligned is not a
common alignment but is often used in tables – it gives an uneven
left margin.
Saving document
5.1.2 Competent
Ask yourself the question, “what does an employee really need to be able to do?” The
answer to this question will tell you what we mean by the word “competent”. To be competent
in a work related skill implies that the person is able to:
perform at an acceptable level of skill
organise the required tasks
respond and react appropriately when things go wrong
fulfil a role in the scheme of things at work
transfer skills and knowledge to new situations.
When you assess this competency you must take into account all of the above issues to
reflect the real nature of work.
5.1.4 Assessors
In workplace situations, an industry certified assessor would determine whether a worker was
competent to undertake the tasks entailed by this unit of competency. If you are certified to
assess this unit, then you may choose from the methods offered in this guide, or develop your
own to conduct assessment. Assessors must look at the evidence guides in the competency
standards before arriving at the assessment methods to use.
Evidence should include a demonstrated ability to correctly explain and apply principles and
practices in the hospitality industry.
Should your Trainees or students not have the underpinning skills and knowledge required,
you must ensure that you deliver this material before you progress to the next section.
Use these tasks to determine if your Trainees or students have the necessary underpinning
skills and knowledge. The table below can be used to record the result of each student and
what further training is needed.
Results of a successful assessment should indicate sufficient and relevant knowledge and
understanding to be able to infer competence. Therefore the trainee is assessed as either
competent / competence to be achieved. Examples of assessment results sheets are
included in Appendix 1 and 2.
Assessment of practical demonstration in the workplace may include observation of the trainee:
using various functions of a computer.
Oral question or some form of written assessment/project would be useful to determine underpinning knowledge such as:
glossary of computer terms
check to ensure correct and safe power access.
ergonomic principles to be followed when standing/sitting/keyboarding.
In off-the-job assessment, simulated activities could be used to allow the trainee to provide evidence of skills through practical
demonstration:
role play that allows the candidate to other demonstrate correct OHS practices when using the computer system
set up of a simulated environment appropriate to the ‘work’ context that allows the candidate to access and retrieve computer data as part of
other day-to-day activities (e.g. sourcing destination information).
Please remember that a current passport is required to travel to Thailand. Insurance is strongly
recommended and I enclose a brochure for your perusal. Thank you for booking with Downtown Travel
Services. We look forward to being of further assistance.
Your sincerely,
D martin
Travel Consultant
Save the document on the floppy drive with a file name that indicates the information contained in the
file.
Retrieve the file and change the final payment date to 21 April.
Print the new letter.
Save the amended file to the diskette using a new file name.
Exit the program. And turn the computer and printer off.
2. Find information on the attractions in your capital city on the internet. Bookmark for easy access or put in your
Favourites folder. Download the information.
3. Update an address list, which you have loaded onto your hard drive from a CD.
Task 1
At work
You work for a travel agency. Your supervisor has asked that you assist a new employee to
begin work by demonstrating the correct use of his/her computer.
Demonstrate the method by which the computer is turned on/accessed correctly.
Explain the reasons why you have carried out each step.
Have your Trainer or teacher evaluate your competence and provide feedback.
Task 2
Developing your mouse skills
Click the Start button
Point to the Programs folder
Point to the Accessories folder
Point to the Games folder
Click the Solitaire icon
Enjoy the game!
Have your Trainer or teacher evaluate your competence and provide feedback.
Task 3
Selecting software
You work for in the front office at a hotel. Your supervisor has asked you to produce a
document using the computer.
Carry out the first step of this process by selecting the appropriate software from the menu for
writing a letter.
Have your Trainer or teacher evaluate your competence and provide feedback.
Task 4
Opening correct files
Your supervisor wants you to open a file containing a fax that he wrote to a client, Mr
Hismanto regarding a tour group that wanted a one-day as top-over of Jakarta. Unfortunately
he has forgotten the computer address for the file.
Using the skills that you have developed, find and open the file.
Have your Trainer or teacher evaluate your competence and provide feedback.
Task 5
Developing speed and accuracy skills
You are working in the front office and you have been asked to type a copy of a letter for your
boss and he wants it urgently. He wants to see your first draft in 10 minutes.
Open a new file and Save as a file using your name as its title, for example “Turi”.
Your Trainer or teacher will give you the letter to copy and will tell you when to start.
Use the default format for the letter.
After 10 minutes your Trainer or teacher will tell you to stop and Save what you have
typed.
Your Trainer or teacher will then explain how to count the number of keystrokes that
you have typed in the ten-minute period. Keep a record of this number.
Task 6
Finding items to be edited
Open the file that you found for your supervisor in Task 4.
Your supervisor wants you to change the date of the fax and the date of the group tour and he
wants to delete Sunda Kalapa from the scheduled places to visit.
Do not change anything at this stage; just find where the items to be changed are.
Show your Trainer or teacher and have your Trainer or teacher evaluate your competence
and provide feedback.
Task 7
Printing a document
Print the document that you’re opened in Task 6 following the procedure that has been
explained to you by your Trainer or teacher.
Have your Trainer or teacher evaluate your competence and provide feedback.
Task 8 & 9
Entering, changing and deleting information
The client (Hismanto) has once again changed his mind and a new fax, based on the old one,
has to be prepared.
Your Trainer or teacher will tell you (verbally) all of the changes to the fax that are necessary,
be sure to write them all down.
After you know what changes are required go ahead and make the changes.
Have your Trainer or teacher evaluate your competence and provide feedback.
Saving documents
During the process of making changes to the fax to Mr Hismanto you should:
demonstrate regular saving of your document
explain to your Trainer or teacher why it is necessary to save regularly
Have your Trainer or teacher evaluate your competence and provide feedback.
Task 10
Closing files and exiting the program
You are working for a restaurant. Your supervisor has asked that you open a letter and make
some changes (details of this will be given to you by your Trainer or teacher).
Produce this letter on the computer, as specified by your Trainer or teacher and then:
save the file
close the file
exit the program
all in accordance with specified procedures.
Have your Trainer or teacher evaluate your competence and provide feedback.
Assessor name:
Competency to be achieved
Feedback to trainee
Signatures
Date:
Date:
Package for Hospitality Training – Access and retrieve computer data Appendix 1 - Page 1
Appendix 2
Group:
Assessor name:
Package for Hospitality Training – Access and retrieve computer data Appendix 2 - Page 1
Appendix 3
9 Saving document
Package for Hospitality Training – Access and retrieve computer data Appendix 3 - Page 1
Appendix 4
Package for Hospitality Training – Access and retrieve computer data Appendix 4 - Page 1
Appendix 5
Example:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
Package for Hospitality Training – Access and retrieve computer data Appendix 5 - Page 1