MSJC - The Community College FOR YOUR FUTURE . . .

CAPP-120B / OTEC-120 ~ 0612 - 0478

Using Microsoft Office XP - Level 1

*** * * Fall, 2002 Semester Class Schedule * * ***

August

08/19 - (MONDAY)

Introductory meeting and handouts.
The “ON/OFF” switch.
Using the keyboard and the mouse – Part 1.
Exploring our CAPP120 / OTEC-120 Course Web Site.
Homework: Read: Preface section in EACH textbook.
Homework: Read: Appendix A, B and E in “Microsoft Office XP - Introductory Concepts and Techniques” textbook.

08/21 - (WEDNESDAY)

Using the keyboard and the mouse – Part 2.
Windows XP Tour.
Computer Lab Exercise. (To be announced and completed in class.)

08/26 - (MONDAY)

In-class review: [“Microsoft Windows XP - Brief Concepts and Techniques” text booklet] Windows XP - Project 1: “Fundamentals of Using Microsoft Windows XP” (Pages WIN 1.1 - Win 1.40). (To be completed in class.)
Computer Lab Exercise. (To be announced and completed in class.)

08/28 - (WEDNESDAY)

In-class review: [“Microsoft Windows XP - Brief Concepts and Techniques” text booklet] Windows XP - Project 1: “Fundamentals of Using Microsoft Windows XP” (Pages WIN 1.40 - Win 1.54). (To be completed in class.)
(In-class review: Windows XP - Project 2: “Using Windows XP Explorer” (Pages WIN 2.1 - Win 2.21). (To be completed in class.)
Computer Lab Exercise. (To be announced and completed in class.)

Top of Page

September

09/02 - (MONDAY)

Holiday: Labor Day ! ! !

09/04 - (WEDNESDAY)

In-class review: [“Microsoft Office XP - Introductory Concepts and Techniques” textbook] Office XP: Project 1 - “An Introduction to Windows 2000 Professional and Office XP”, pages INT1.61 - INT 1.75. (To be completed in class.)
Review for Windows XP test.

09/09 - (MONDAY)

Windows XP Test.
In-class review of Word 2002, Project 1 - “Creating and Editing a Word Document”, Pages WD 1.1 - 1.32. (To be completed in class.)
Homework: “Personal Profile” Assignment (1^st Draft due 9/18. Final [Formatted] version due on or before 10/2). (Note: This assignment will be discussed in class. See the following link: Personal Profile Guidelines.)

09/11 - (WEDNESDAY)

Review Windows XP test.
In-class review of Word 2002, Project 1 [Continued] - “Creating and Editing a Word Document”, Pages WD 1.32 - 1.62. (To be completed in class.)
Homework: Read and Do the Steps in Word 2002, Project 2 - “Creating a Research Paper”. (Note: You should complete this on your own by 9/16. Turn-in the Project File on 9/16.)
Homework: Apply Your Knowledge #1, “Revising a Document”, Word Project 2, Page WD 2.57 (Turn-in on 9/16). Note: Requires file from Office XP - Word: Student Data Disk [See Note 1 below].

09/16 - (MONDAY)

Turn-in Homework due today. Note: Don’t forget your Cover Page. [See Note 3 below].
Computer Laboratory Exercise, Word 2002: Project 1. (To be announced and completed in class.)
In-class review of Word 2002, Project 2 - “Creating a Research Paper”, pages WD 2.01 - 2.55. [Part 1.]
Homework: To be announced in class. Due: 9/18.

09/18 - (WEDNESDAY)

Turn-in Homework due today.
Turn-in “Personal Profile” assignment - 1^st Draft. Final [Formatted] version due on or before 10/2).
In-class review of Word 2002 - Project 2 - "Creating a Research Paper", Pages WD 2.01 - 2.55. [Part 2]
Computer Lab Exercise. (To be announced and completed in class.)
Homework: Read and Do the Steps in Word 2002, Project 3 - "Using a Wizard to Create a Resume and Creating a Cover Letter with a Table". (Note: You should complete this on your own by 9/23. Turn-in the Project File on 9/23.)

09/23 - (MONDAY)

Turn-in Homework due today.
Work on ‘Format’ (appearance) of “Personal Profile” in class. (Note: the final copy of the formatted “Personal Profile” is due on or before 10/2.)
In-class review of Word 2002, Project 3 "Using a Wizard to Create a Resume and Creating a Cover Letter with a Table". [Part 1]
Homework: Read and Do the Steps in Word 2002, "Creating Web Pages Using Word" - Web Feature, pages WDW 1.01 - 1.14. (Note: You should complete this on your own by 9/25. Turn-in the Project File on 9/25.) [Note: You will need the resume created in Word 2002 Project 3 to do this assignment.]

09/25 (WEDNESDAY)

Turn-in Homework due today.
In-class review of Word 2002, Project 3 "Using a Wizard to Create a Resume and Creating a Cover Letter with a Table". [Part 2]
In-class review of Word 2002, "Creating Web Pages Using Word" - Web Feature, pages WDW 1.01 - 1.14.

09/30 (MONDAY)

In-class review of Microsoft Word 2002 - Projects 1, 2 & 3.

Top of Page

October

10/02 (WEDNESDAY)

Last day to turn-in "Personal Profile" assignment (final [formatted] version).
Word 2002: WRITTEN & HANDS-ON Test (Projects 1, 2 & 3).
Homework: Read and Do the Steps in Excel 2002, Project 1 - "Creating a Worksheet and Embedded Chart". (Note: You should complete this on your own by 10/9. Turn-in the Project File on 10/9.)
Homework: In the Lab #1, "Madonna's Virtual Sojourn Annual Sales Analysis Worksheet", Excel Project 1, Page E 1.58 - 1.59 (Turn-in on 10/9).
Review Microsoft Word 2002 test.

10/07 (MONDAY)

Review Microsoft Word 2002 test.
Homework: Read and Do the Steps in Excel 2002, Project 2 - "Formulas, Functions, Formatting, and Web Queries". (Note: You should complete this on your own by 10/14. Turn-in the Project File on 10/14.)
Homework: Apply Your Knowledge #1, "Buy It Online Profit Analysis Worksheet", Excel Project 2, Page E 2.67 - 2.68 (Turn-in on 10/14).

10/09 (WEDNESDAY)

Turn-in Homework due today.
In-class review of Excel 2002, Project 1 - "Creating a Worksheet and Embedded Chart".
Homework: Read and Do the Steps in Excel 2002, Project 3 - "What-If Analysis, Charting, and Working with Large Worksheets". (Note: You should complete this on your own by 10/16. Turn-in the Project File on 10/16.)

10/14 (MONDAY)

Turn-in Homework due today.
In-class review of Excel 2002, Project 2 - "Formulas, Functions, Formatting, and Web Queries".

10/16 (WEDNESDAY)

Turn-in Homework due today.
In-class review of Excel 2002, Project 3 - "What-If Analysis, Charting, and Working with Large Worksheets".

10/21 (MONDAY)

In-class discussion of Excel 2002, "Creating Static and Dynamic Web Pages Using Excel" - Web Feature, pages EW 1.01 - 1.15.
In-class review of Microsoft Excel 2002 - Projects 1, 2 & 3.

10/23 (WEDNESDAY)

Excel 2002: WRITTEN & HANDS-ON Test (Projects 1, 2 & 3).
Homework: Read and Do the Steps in Access 2002, Project 1 - "Creating a Database Using Design and Datasheet Views". (Note: You should complete this on your own by 10/30. Turn-in the Project File on 10/30.)
Homework: Apply Your Knowledge #1, "Changing Data and Creating Reports", Access Project 1, Page A 1.54-55 (Turn-in on 10/30).

10/28 (MONDAY)

Review Microsoft Excel 2002 test.
Homework: Review and be prepared for Access 2002, Project 2 - "Querying a Database Using the Select Query Window". (Note: You should prepare for in-class completion of this project on 11/4.)

10/30 (WEDNESDAY)

Turn-in Homework due today.
In-class review of Access 2002, Project 1 - "Creating a Database Using Design and Datasheet Views".

Top of Page

November

11/04 (MONDAY)

In-class review of Access 2002, Project 2 - "Querying a Database Using the Select Query Window". [Part 1] (Note: Project will be done in-class.)

11/05 (TUESDAY)

Please Vote Today.

11/06 (WEDNESDAY)

In-class review of Access 2002, Project 2 - "Querying a Database Using the Select Query Window", [Part 2] (Note: Project will be done in-class.)
Homework: Read and Do the Steps in Access 2002, Project 3 - "Maintaining a Database Using the Design and Update Features of Access". (Note: You should complete this on your own by 11/13. Turn-in the Project File [printout of the Customer table (from the Alisa Vending Services Database) after changes described in the project] on 11/13.)

11/11 (MONDAY)

Holiday: Veteran's Day ! ! !

11/13 (WEDNESDAY)

Turn-in Homework due today.
In-class review of Access 2002, Project 3 - "Maintaining a Database Using the Design and Update Features of Access".
In-class discussion of Access 2002, "Publishing to the Internet Using Data Access Pages" - Web Feature, pages AW 1.01 - 1.10.
In-class review of Microsoft Access 2002 - Projects 1, 2 & 3.

11/18 (MONDAY)

Access 2002: WRITTEN & HANDS-ON Test (Projects 1, 2 & 3).
Homework: Read and Do the Steps in PowerPoint 2002, Project 1 - "Using a Design Template and AutoLayouts to Create a Presentation". (Note: You should complete this on your own by 11/25. Turn-in the Project File on 11/25.)
Homework: In the Lab #1, "Decades of Nutrition in the Twentieth Century", PowerPoint Project 1, Page PP 1.69 - 1.71. (Turn-in on 11/25).
Homework: "PowerPoint Slide Show Presentation" Assignment (Due: 12/9 - This assignment will not be accepted late). (Note: This assignment will be discussed in class.)

11/20 (WEDNESDAY)

Review Microsoft Access 2002 test.
Homework: Read and Do the Steps in PowerPoint 2002, Project 2 -"Using Outline View and Clip Art to Create a Slide Show". (Note: You should complete this on your own by 11/27. Turn-in the Project File on 11/27.)

11/25 (MONDAY)

Turn-in Homework due today.
In-class review of PowerPoint 2002, Project 1 - "Using a Design Template and AutoLayouts to Create a Presentation". Work on PowerPoint Slide Show presentation in class.

Note: Last week extra credit will be accepted.

11/27 (WEDNESDAY)

Turn-in Homework due today.
In-class review of PowerPoint 2002, Project 2 - "Using Outline View and Clip Art to Create a Slide Show".
Homework: Read and Do the Steps in Outlook 2002, Project 1 - "Schedule and Contact Management Using Outlook". (Note: You should complete this on your own by 12/2. This assignment does not require anything turned-in.)

Top of Page

December

12/02 (MONDAY)

Work on PowerPoint Slide Show presentation in class.

12/04 (WEDNESDAY)

Work on PowerPoint Slide Show presentation in class.
Homework: Read and Do the Steps in Office XP Integration Project 1 - "Introduction to Integrating Office XP Applications". (Note: You should complete this on your own by 12/11. This assignment does not require anything turned-in.)

12/09 (MONDAY)

Show PowerPoint Slide Show presentation to class.

12/11 (WEDNESDAY)

In-class review of Outlook 2002, Project 1 - "Schedule and Contact Management Using Outlook".
In-class review of Office XP Integration Project 1 - "Introduction to Integrating Office XP Applications".

Review for Final Exam

(The Final Exam is tentatively scheduled for Wednesday, December 18^th, from 7:45 to 9:45 a.m.)

Top of Page

Notes:

Some exercises / assignments in the textbook Microsoft Office XP - Complete Concepts and Techniques require files found on “the Student Data Disk”. You may obtain a copy of these files via the Public Folders (Ron Lehr folder) on the Mt. San Jacinto Community College Intranet; or at www.course.com (the Course Technology Web site - See inside back cover of the textbook for additional information); or directly from me.
Homework will include both written assignments as well as computer lab projects and assignments. Before turning-in the assignments outlined in the schedule, you must complete the computer steps contained in the project. (Don’t just read the project and then go to the exercises.)

All homework is due at the beginning of the class meeting on the due date shown in the schedule.
All homework / extra credit must be done in Office XP (not hand-written) and have a cover page showing: CAPP-120B or OTEC-120; Class Code 0612 or 0478; the project number; the assignment title and number; the assignment page; and the assignment due date (see sample cover page and sample extra credit cover page below).

Staple your cover page to your work.

[Assignments from the same Project, due the same date should be combined on one cover page.]
Preparation and participation are very important in business and in this class. Preparation means reading the material and keeping-up with the homework assignments. Non-participation includes: distracting or disturbing other students; or working on non-class activities during class. If you prepare and participate in every class meeting for the semester, you will receive a 3% bonus at the end of the semester. If you miss participating in only one class meeting, you will receive a 2% bonus. It is in your best interest to earn this bonus to help your grade.
There are three ‘hands-on’ exams in this class. They are designed to test how well you can perform various word processing, spreadsheet and database features. They will be open book and open notes.
On tests and homework, maximum credit is earned by: following all directions and instructions; by producing a document that is professional in appearance; and by correcting grammatical errors, misspellings, or incorrectly used words.
The Final Exam will cover all material reviewed in the class from the text: Microsoft Office XP - Introductory Concepts and Techniques. It will consist of 100 multiple choice questions.
All attempts will be made to follow this schedule as outlined. However, circumstances may require changes in the schedule for any given class meeting.