Course Description: This course is designed to teach the numeric keypad with speed and accuracy using industry standards for data entry. Proficiency on three employment tests used by three large interstate corporations helps the student meet employment standards.

Course Objectives: After completing all three modules of this course, the student will be able to:
define data entry; key a minimum of 6,000 ksph (keystrokes per hour) with 98% accuracy; enter data in forms with 100% accuracy; and proofread and edit forms.

Course Materials:

10 Key Mastery, Barbara Ellsworth Publishing

Course Requirements:

You must attend an orientation session before beginning the course. This is a skill course that requires 40/48 hours to complete all modules. You will practice 10 key to improve your speed and learn to enter data in forms. The software will record all your scores and grades.

Course Grading:

Module A: 100% KSPH (see grading scale below)

12,000 KSPH = A

10,222 KSPH = B

8,000 KSPH = C

6,000 KSPH = D

Below = F

Modules B & C: 85% KSPH (see grading scale above)
15% Forms

“Getting Started”—Completing This Course:

1. Start this course by reviewing the Course Introduction presentation. To view presentation: double click “My Computer” on the desktop, double click the “Instructor on ‘Lucy’ (K:)” icon, double click the “CAO” folder; double click the “177-Data Entry” folder, right click on “Course Introduction”; and then click “Show.” This presentation will explain the skills needed for data entry and also show the types of forms used at the end of the course. You will also be reviewing the “TenKeyMastery-Student” presentation located in the same folder. Follow the same steps to show this presentation.

2. Follow the directions below for Online Version—Getting Started:

Online Version—Getting Started

n                Go to:

www.keyboardingonline.com

n                Get the Login/Password from your teacher and enter it (lowercase).

n                Click: Login

Login:ltcc

Password: ltcc

Online Version—Getting Started

n Select your course.

Online Version—Selecting Student Data File

Click Open

Click Open

Select teacher or class

Select student name

1. Click on OPEN

2. Select your class
LTCC CAO 177 - Fall 06

3. Click your name from the data file list

Password Protection

n Student data files are password protected. Your password is the telephone number used when you registered for classes. Do not include the area code or the dash.

Online Version—Enter Serial Code

n Enter the serial code in the back of the textbook under the software CD. (The software CD is for personal use to be used after the online class is deleted. It is not used for the online class—work must be done online so the teacher can see it online.)

Data Entry

ASSIGNMENT SCHEDULE

This schedule is a suggested guide for the student who wishes to finish the required
assignments by the end of the quarter and earn three quarter units of credit. Students may proceed faster or slower than this schedule. You must complete one module of work to receive one unit of credit.

MODULE A

Week 1:	1.	Introduction to the course, computers, lab procedures

	2.	Familiarize yourself with your computer and 10-Key Mastery software. “Getting Started”—follow the directions on pages 2-5 of this syllabus

	3.	Complete the following Exercises: 1. pg. B-4 2. pg. B-4 3. pg. B-5 4, pg. B-5


Week 2::		Complete the following Exercises: 5. pg. B-6 6. pg. B-6 7. pg. B-7 8. pg. B-7 9. pg. B-8


Week 3::		Complete the following Exercises: 10. pg. B-8 11. pg. B-9 12. pg. B-9 13. pg. B-10


Week 4::		Complete the following Exercises: 14. pg. B-8 15. pg. B-11 16. pg. B-11 17. pg. B-12 18. pg. B-12

END OF MODULE A

MODULE B

Week 5::

Complete the following Exercises:
                                            19. pg. B-13
                                           20. pg. B-13
                                           21. pg. B-14


Week 6::		Complete the following Exercises: 22. pg. B-14 23. pg. B-15 24. pg. B-16


Week 7 & 8	1.	DATA ENTRY FORMS Complete the data entry forms. Double click on the CAO folder on the K drive. Double click the 177 folder and then double click the Data Forms folder. There are seven forms in this folder that you will save to your disk. The data information sheet is attached to this course outline. Following the directions on the data sheet, open each form and begin entering the information and saving the forms. Form 1 Apparel, pg. 8 of syllabus Form 2 Admissions, pg. 8 of syllabus Form 3 Confirmation Letter, pg.9 of syllabus Form 4 Employee Evaluation, pg 9 of syllabus You will open the folder and bring the form to the screen. Enter all information into the form. Save the form to your disk and name the form. Do not save over the original form. After you have entered all the data in the forms and have saved each form to your disk, proofread very carefully. ALL FORMS MUST BE 100% ACCURATE. NO ERRORS ALLOWED! Review forms with your instructor. You will find the necessary data on pps. 8-9 of the syllabus.

	2.	Staple and turn in all completed forms. Please put your name, course code, form number (Form 1, etc.) and date on the first page of each packet

CAO 177—DATA ENTRY

DATA SIMULATION

COMPLETING FORMS

In the CAO folder on the K drive is a folder labeled 177. Open this folder and double click on the folder labeled “Data Forms.”

You will need a disk to save the completed forms after you have entered the data listed below for each form. Follow the directions below and complete a form for each of the records listed. When you have entered the information on each form, save the form to your disk in the A drive and name it according to directions given with each form. You will print a copy of each form to turn in to your instructor. Remember the fields where information is to be entered are shaded on the form. Use the tab key to move form field to field. Use the 10-key pad to enter numbers. After you open a form from the folder, be sure to change to the A drive and save the completed form to your disk.

Enter the information on the form for each store number. Save the form as Apparel and the store number. Open form 1 Apparel again and continue with the next form until you have completed all four forms. Each form should be named by Apparel and the store number.

Form 1 Apparel

Store Number	23	152	26	10
Defect ID Tag	July 1, 2003	June 23, 2003	May 4, 2003	August 5, 2003
Vendor Number	581	284	564	781
Vendor Style Number	1	6	48	19
Department Number	22	15	64	71
SKU Number	002456789	003126459	004459753	018456230
Defect Notice in Store/Customer Return	in store	return	in store	return
Defect Location	sleeve	skirt	leg	bottle broken
Seams	Open	Okay	Okay	Okay
Colors	Okay	Okay	Okay	Okay
Fabric Construction	Holes	Stitching	Okay	Okay
Shrinkage	Okay	Excessive	Excessive	Okay
Buttons & Zippers	Buttons Missing	Okay	Okay	Okay
Other	damaged design	seams twisted	wood cracked	cap not holding
Regular Price	$23.95	$129.95	$49.95	$6.95

Form 2 Admissions

Enter information below on three Admissions forms. When all forms have been completed, proofread your work. Save each form as Admissions and the last name.

Last Name	Smith	Lafayette	Brigham
First Name	Brandon	Suzanne	Roxi
Sex	Male	Female	Female
Age	21	19	18
Guardian	none	Howard Lafayette	Marci Brigham
Telephone	858 675-2232	619 566-5858	760 432-0259
Address	14517 Rutledge Square	10A Mercer Street	15154 Vista Way
Fax	none	619 566-5859	760 432-0259
City	San Diego	San Diego	Vista
State	CA	CA	CA
Zip	92128	91021	92056
Start Date	October 1, 2002	October 10, 2002	October 15, 2002
Weeks of Participation	2	3	1
Instrument	Violin	Saxophone	Cello

Form 3 Confirmation Letter

Enter the information listed below on form 3. After completing the entire form, save the form to your disk as Letter and the last name.

Name	Mrs. Mary Lynch	Mr. John Clark	Ms. Susan Blake
Address	2121 East First Street Cincinnati, OH 33450	125A Cunard Street Boston, MA 02120	278 NE Circle Seattle, WA 98078
Dear	Mrs. Lynch	Mr. Clark	Ms. Blake
Arrival Date:	July 1, 2003	August 29, 2003	September 10, 2003
Departure Date:	July 10, 2003	September 2, 2003	September 14, 2003
Room Rate:	$159.00	$325.00	$149.00
Number of Rooms:	1	2	1
Non-smoking Rooms	no	no	yes
Guarantee Methods	Master Card	Check	American Express
Check-in time:	3:00 p.m.	3:00 p.m.	2:00 p.m.
Check-out time	12:00 p.m.	12:00 p.m.	11 a.m.
Agent	Mary Wilson Lodging Department	Mary Wilson Lodging Department	Mary Wilson Lodging Department

Form 4 Employee Evaluation

Enter the information listed below on form 4. Save each from as Evaluation and the last name.

Social Security	112-23-1245	147-25-8963
Last	Clarkson	Gentile
First	Susan	Anthony
Middle	B.	C.
Employee No.	1234	9876
Department	Delivery	Accounting
Position	Clerk	Accountant
Date of Evaluation	1/25/03	1/31/03
Date in Position	9/2/85	1/3/98
Date of Last Review	1/31/02	1/27/02
Type of Evaluation	Annual	Salary
Customer Service	meets	exceeds
Completeness	exceeds	exceeds
Driving Record	meets	meets
Follows	meets	exceeds
Dependability	needs	exceeds
Cooperation	meets	exceeds
Job Responsibility	needs	exceeds
Job Attitude	needs	meets
Overall	needs	exceeds
Strong Areas	Loyalty and dedication	Initiative
Area Needing Improvement	Computer skills	Leadership
Action Plan	Retraining and workshops	Join executive club
Supervisor’s Comments	Dedicated employee who is willing to improve skills to keep position.	Exhibits definite leadership and management skills in present position.

END OF MODULE B

MODULE C

Week 9 & 10	1.	DATA ENTRY FORMS: Form 5 Invoice, pg. 11 of this syllabus Form 6 PC Rental Checklist, pg. 11 of this syllabus Form 7 Quote, pg. 12 of this syllabus You will open the folder and bring the form to the screen. Enter all information into the form. Save the form to your disk and name the form. Do not save over the original form. After you have entered all the data in the forms and have saved each form to your disk, proofread very carefully. ALL FORMS MUST BE 100% ACCURATE. NO ERRORS ALLOWED! Review forms with your instructor. You will find the necessary data on pps. 11-12 of the syllabus.

	2.	Staple and turn in all completed forms. Please put your name, course code, form number (Form 1, etc.) and date on the first page of each packet


Weeks 11 & 12		Complete the following Exercises: 25. pg. B-14 26. pg. B-15 27. pg. B-16

DATA SIMULATION

COMPLETING FORMS

In the CAO folder on the K drive is a folder labeled 177. Open this folder and double click on the folder labeled “Data Forms.”

Please follow the same procedures for completing the forms as you did in Module B

Form 5 Invoice

Enter the information listed below in form 5. List information for each date on a separate line. Enter all dollar amounts with a dollar sign and two decimals. Save each form as Invoice and the client name. Be sure to save to your disk.

Invoice Date	February 5, 2003	January 31, 2003	February 3, 2003
Client Name	Sunrise Services	Carr Associates	Prime Meats Inc.
Contact Person	John Thomas	Mary Carr	Stanley Wright
Address	316 Main Street	1264 Dole Street	6432 Vonder Way
City, State, Zip	Oceanside, CA 92056	Vista, CA 92041	San Marcos, CA 92061
Date	12/17	1/3	1/4
No. of hours	24	6	3
Description	Database Plan	Personnel Review	Accounting Analysis
Rate/Hour	45	50	50
Date	12/28		1/24
No. of hours	10		10
Description	Database Review		Preparation of Data
Rate/Hour	35		50
Date	1/31
No. of hours	20
Description	Database Implementation
Rate/Hour	45

Form 6 PC Rental Checklist

Enter information listed below on form 6. Save the form as Checklist and customer name. Save to your disk.

Customer Name	Nancy Parker	Matt Lewis	Frank Campbell
Phone Number	760 381-1111	760 556-8978	760 214-8975
Date Out	1/21/03	1/20/03	1/31/03
Date In	1/23/03	1/22/03	2/2/03
Model Number	586-233	586-200	Laptop
Serial Number	GA44Q21	RT34Q23	BV45X
Accessories:
Power	yes	yes	yes
A/C Cable	no	no	yes
VGA Cable	yes	no	no
Mac Cable	no	yes	no
Mouse	yes	yes	no
Portable	no	no	no
Speakers	no	yes	no
Fax	no	no	no
Additional	none	none	5 disks
Received by	online	warehouse	mail order
Returned by	Sam	Carrie	Rory

ASSIGNMENT SCHEDULE

END OF MODULE A

Store Number

Defect ID Tag

Last Name

Form 3 Confirmation Letter

CAO 177abc – Data Entry
(1-3 units)
Fall Quarter, 2006

Instructor’s Center Hours

CAO 177abc – Data Entry (1-3 units) Fall Quarter, 2006

Instructor’s Center Hours

ASSIGNMENT SCHEDULE

END OF MODULE A

Store Number

Defect ID Tag

Last Name

Form 3 Confirmation Letter

CAO 177abc – Data Entry
(1-3 units)
Fall Quarter, 2006