Career Keys
Introduction to Computer Applications

Table of Contents

Course: Intro-to Computer Applications
Duration:  5 Weeks: Monday-Friday
Time:  Monday through Friday 9:00AM-12:15PM
Location: Career Keys/VISTA Project in the CyberNet Lab
Instructor: Paul Colgrove, E-mail [email protected]

Textbook & Materials:
1.   “Office 2000 Essentials Course” Off to Work Series, by Brian Favro, Russel Stolins, Labyrinth Publications. (739 Pages, Spiral Bound, and Student Exercise Disk)
2. Ten 3.5” High-Density diskettes for student and homework files.

Course Objectives: Keyboarding—Learn basic touch typing-skills and the function of each key on the keyboard. You will learn to type 40 words per minute.

Computer Hardware—You will learn the basics of using the mouse, keyboard navigation, and the basic storage and peripheral components of the computer.
Windows 95/98—You will be taught files management, working with file folders, using Windows Explorer software, changing Windows, adjusting settings and controls, and how to customize your computer.

Word 97/2000— Word Processing—You will learn to create, edit and save documents. You will learn to use spell check, thesaurus, tables, columns, desktop publishing, graphics, email, copy and paste. You will learn to create envelopes, labels, change fonts, do paragraph formatting.

Excel 97/2000— Spread Sheet—You will learn to construct a spreadsheet, calculate using formulas, do page setup, printing, and make charts.

Grading: Homework (On time completion of take home exams and homework exercises
is required.)
Quizzes: Do the homework assignments and you should do well on each test. (60% is passing.)
Tests: (You must pass each test to pass the course, 60% is the minimum passing grade for each quiz or examination. (You need to do better to get a good job.) Contact your instructor to arrange a make up exam. There will be five tests, one each week
Attendance: Late arriving students will have to catch up to the class lesson on their own. The instructor will not repeat the class lesson for late arrivals. If you arrive late to class settle in quietly and turn on your computer. You can make explanations to your instructor during break time.  If you are absent three or more days, you most likely will fail the class.

Requirements:
You will be provided with all necessary supplies and books and must comply with the student contract, which you will read, and sign.

Homework: Reading and practice exercises as assigned by your instructor. You may use computers at Career Keys. Your instructor, Paul Colgrove, teaches other classes at Career Keys and will allow you to use any available computers in his classrooms, not being used by his students.

1. All homework must be turned in on time.
2. Your name should be at the top left of each page.
3. Press the Tab key twice and type the date.
4. The title Cybernet Computer Applications Homework should appear below your name.
5. The chapter and name of the homework exercise should be typed next.
6. Page numbers should be inserted at the bottom right of each page.
7. Use headers and footers when you are able to do so.

Reading Textbook: Office 2000 Quick Course
Homework: Hands-On Lessons, Skill Builders & Assessments
There are 25 Lessons in our textbook. We have 5 weeks or 25 days to complete the book. Our objective is complete more than one lesson each day. Your instructor, Ms. Coleman will provide supplemental handouts, projects and tests whenever necessary. It is important that you read at least one or two lesson each day. Within each lesson are Hands-On Exercises and at the end of each lesson are additional Skill Builders and Assessments that you should complete.Each day for at least 30 minutes to one hour, you must practice keyboarding using the Mavis Beacon keyboarding lessons installed on your computer.
1. Type your name at the top of each page.
2. In each Lesson complete all Hands-On Exercises.
3. At the end of each lesson, complete the True/False and Multiple Choice Questions.
4. Then do the Skill Builders, and Assessments at the end of each lesson.
5. Save your work on your floppy A disk.
6.  Submit your work on a floppy disk, or print if necessary. Print your name on the disk.

1. Classes start Monday _______________ and end _________________
2. Classes are Monday through Fridays for ____________________ weeks.
3. Morning classes run from __________ to ______________ with a fifteen-minute break
4. Class Topics
a) Intro-Computer hardware
b) Keyboarding (Everyday)
c) Windows 95/98 operating systems
d) Word Processing—Word 97/2000
e) Internet and E-mail
f) Excel 97/2000

Introduction: Intro-to Computer Applications Labs and Passwords
Syllabus, Attendance, Tests, Homework, Student Responsibilities
Getting Down to Business—Explain How to Read the Textbook

Lesson 1—Computer Concepts

 Computer Systems
 Units of Measure
 Inside the System
 Selecting Peripherals
 Computer Software
 Purchasing a Computer
 Setting up a Computer
 Healthy Work Habits with computers

Lesson 2—Windows: Working With Windows Programs

Introducing Windows
Switching on the Computer
Using a Mouse
Starting Programs
Sizing Program Windows
Working with Programs
Saving Files
Editing Files
Multitasking
Using Dialog Boxes
Working with the Paint Program
Printing Files
Shutting Down Windows

Lesson 3—Windows File Management and Online Help

Using Online Help with Windows
Browsing Through Files
Working with Folders
Moving and Copying Files
Deleting Files and Folders
Windows Explorer View

Lesson 4—Internet Explorer: Browsing the Web

Launching Internet Explorer
Navigating the Web
Navigating with Hyperlinks
Navigating with Browsing Controls
Printing Web Pages
Searching the Web

Lesson 5—Outlook: Sending and Receiving Email

Starting Outlook
About Electronic Mail
Sending an Email Message
Receiving Messages
Responding to Messages
Deleting Messages

Lesson 6—Word: Creating and Editing Business Letters

What is Microsoft Word 2000?
Starting Word 2000
Business Letter Styles
Inserting Text
AutoComplete and Other Automated Features
Save Concepts
Scrolling Documents and Repositioning the Insertion Point
Inserting and Overtyping Text
Selecting Text
Undo and Redo
Repeat
Closing and Opening Documents
Showing Nonprinting Characters
Print Preview and Other Views
Printing
Canceling Print Jobs
Exiting from Word

Lesson 7—Word: Creating A Memorandum and Press Release

Memorandum Styles
Adaptive Menus
Working with Toolbars
Insert Date and Time
Inserting Symbols
Views
Zooming
Page Breaks
Removing Manual Page Breaks
Paragraph Concepts
Aligning Text
Formatting Text
Character Effects and Animation
Cut, Copy, and Paste
The Office 2000 Clipboard
Drag and Drop
The Spike
Document Scraps
The Format Painter

Lesson 8—Excel: Creating and Editing a Simple Worksheet

What is Excel?
Starting Excel
Worksheets and Workbooks
 The Highlight
 Entering Data
 Undo and Redo
 Repeat
 Number Entries
 Save Concepts
 Editing Entries
 Selecting Cells
 Aligning Cell Entries
 AutoSum
 AutoCalculate
 Print Preview
 Printing
 Closing Workbooks
 Opening Workbooks
 Exiting from Excel

Lesson 9—Excel: Expanding On The Basics

Adaptive Menus
Working with Toolbars
The Fill Handle
Formulas
Number Formats
Merging Cells
Indenting Entries
Formatting Entries
The Format Painter
Clearing Cell Contents and Formats

1)  CyberNet Lab:
a) 8 Computers
b) Printer and paper
c) Programs
1) Keyboarding
2) Windows 95
3) Word 2000
4) Excel 2000
d) Browser
1) Internet Explorer
2) Netscape Communicator
(a) Yahoo
(b) Hotmail

2) Server to load
a) Student files
b) Tests
c) Handouts

I, __________________________________, agree to comply with the following:
 (print name)

1. that I will dress appropriately for class;
2. that I will attend all my classes on time;
3. that only 3 absences will be allowed during the five weeks of this course;
4. that three (3) tardiness will be weighted as 1 absence, and
5. that I will budget my time to allow for homework and practice exercises;
6. that I will complete and submit my homework and take-home tests on time;
7. that I will bring my books, disks, and other required supplies to each class;
8. that I will come to class prepared to ask questions and participate in class discussions in an orderly fashion.

I further agree that violation of the above policy will be grounds for my dismissal from the program and that a grade of unsatisfactory or fail will be given to me.

Signed___________________
 

_________________________    _________________________
Student                                           For the Department

_________________________    _________________________
Date                                                Date