Methodology and Objectives: Through the use of lectures, discussions, demonstrations and, predominantly, hands-on experience, we will meet these objectives: 

• Explain what a PC is, give examples of hardware and software, describe the differences between data and programs and how they are stored, briefly explain networks and the Internet. 
• Create, save, edit and print documents with Word 
• Create, save and manipulate simple spreadsheets using Excel 
• Create and use flat-file databases with Access 

Time permitting, we will often work our way through one or more chapters of the book each night. However, if we do not complete a chapter in class, you need to complete it on your own time.

Grading: Your final grade is based on these factors: 

Note that the lowest quiz score is dropped. There will be no make ups for missed quizzes. 

• The projects require the use of microcomputer software you may already have available, and which is also on the PCs in the college's computer laboratories. If you use your own software, it must be 100% compatible with the software on campus, or else work you do on the college's computers may not be accessible on your home computer, or vice versa. 
• Even different versions of the same brand of software may not be interchangeable, or may only be backward compatible (that is, the newer version may be able to read the old version's files, but the older version may not be able to read the new version's files). 
• You will need to schedule some time on another available computer in addition to time spent in class. The projects focus on Word (word processing), Excel (spreadsheets), Access (databases) and PowerPoint (presentations). See the note on Projects at the end of the syllabus.

Required materials: Text: Microsoft Office XP, Volume 1, O'Leary, Timothy J. & Linda I. O'Leary, authors, McGraw-Hill Irwin, Publishers, ISBN 0-07-247247-2 

Other: At least two high density, 3.5" floppy diskettes.

Classroom etiquette: Audible signals from beepers, cell phones, or other communications devices should be turned off before class starts. If you receive a (silent) cell phone signal while in class, please quietly leave the classroom before answering the phone. Also, do not initiate a call while in the classroom. Conduct yourself as you would in the business environment to which you aspire. 

Outline 

I) Introduction 

II) Introduction to Computer Essentials 

A) Software 
B) Virus Protection 
C) Hardware 
D) Connectivity and the Internet 

III) Windows  

A) Starting Windows 
B) Using Menus 
C) Working with a Window 
D) Windows 2000 Help 
E) Multiple open Windows 
F) Windows Explorer 
G) Folders 
H) Working with Files 

IV) Internet 

A) What are the Internet and the Web 
B) Navigating the Web 
C) E-Mail 
D) Saving and Printing Web Pages 

V) Microsoft Office XP 

VI) Microsoft Word 2002 

A) Creating and Editing a Document 
B) Finding and Revising a Document 
C) Creating Reports and Tables 

VII) Microsoft Excel 2002 and Spreadsheets 

A) Creating and Editing a worksheet 
B) Charting Worksheet Data 

VIII) Microsoft Access 2002 and Database Management 

A) Creating a Database 
B) Modifying a Table and Creating a Form 
C) Analyzing Data and Creating Reports 

IX) Microsoft PowerPoint 2002 

A) Creating a Presentation 
B) Modifying and Refining a Presentation 

Projects 

For all projects: Submit your disk and all printed output as indicated in the specific assignment's steps. Every printed page must have your name, the assignment ("WP" for word processing, etc.), the page (in the book), and the step-you may have to write it in by hand.. Each printed page should be in order. Do not expect me to try to sort out what you mean to submit or distinguish your unidentified work from someone else's. 

Word Lab #6 WD 3.80

Excel Lab #6, 3.65

Access Lab #2, 2.56 - 2.57.

Notes: Step b says ". . .replace Beverage with. . ." but should say ". . .replace Bevage with. . ."

Step f--When filling in the new fields, for the "Amount on hand" use a variety of quantities from 0 to 80.

Step i--The Print Preview shows all records.  You need to go into File/Print to restrict the printing to the selected records.

PowerPoint, Chapter 1 (completed file and printout as developed through page PP1.57).

Due Dates will be forthcoming.

As makeup for snow days, on your own do the first chapter of the PowerPoint section of the book and submit the final file(s) for credit by May 3.