ADM 242
Integrated Office Software
Course Description: A comprehensive examination of advanced Microsoft Office Professional 2000.
Units: 4
Prerequisites: Micro Applications I (Introductory Techniques) and II (Advanced Microsoft Office Professional 2000).
Hours of Instruction: Flexible hours depending on the individual student.
Method of Instruction: This class is an independent study lab. As such the student is expected to work on their own, progressing through the material at their own pace and seeking assistance from the instructor only when necessary. For the most part, students with the required prerequisites will find that their accumulated knowledge in similar computer applications will be more than adequate to speed them through the material, as previously learned concepts are reintroduced and integrated into four software applications.
Required Text and Materials:
1. Microsoft Office 97 – Introductory Concepts and Techniques, Shelly, Cashman, and Vermaat, Course Technology.
2. 4-7 blank high density (1.44 MB) disks.
Basis of Evaluation: 75% of the quarter grade will be based on the accurate completion of the application projects at the end of each lesson. 25% of the quarter grade will be based on machine tests given at the end of each major section.
TUTORIAL CENTER ASSIGNMENT:
Should student performance reflect any possible deficiencies, the instructor may refer the student to the tutorial center for review. Work completed at the center may be used to raise the grade of one or more unsatisfactory assignments. Any score below 70% will be considered unsatisfactory.
All In the Lab assignments are to be saved utilizing the following naming format. The first letter of your first name, followed by the first letter of your last name, followed by the project number, followed by the lab assignment number. Example: If I were saving the third assignment in the second project I would save the file to my student disk as JD2-3.
All Cases and Places assigned are to be saved utilizing the same format as above except CP will precede the problem number. Example: If I were saving the 2nd assignment of the 4th project, the file would be named JD4-CP2.
“In the Lab” assignments are due in all projects on student provided disks. Late assignments will be assessed a 10% penalty for every week late. Cases and Places assignments are as indicated in the following class schedule. These student disks become the property of the instructor and will not be returned to the students.
Class Schedule:
|
Week 1 |
MS Word 97 Project 1 creating and editing a word document. Project 2 using wizards and templates. |
Complete all of the In the Lab assignments at the end of both projects. Project 1 Cases and Places #2. Project 2 Cases and Places #4. |
|
Week 2 |
Word 97 Project 3, research paper with a table. Creating Web Pages. |
Complete all of the In the Lab assignments at the end of both projects. Project 3 Cases and Places #1. Student disk due end of period on Friday. |
|
Week 3 |
Excel 97 Project 1, creating a worksheet and embedded chart. Project 2, formatting, formulas, charts, and web queries. |
Complete all of the In the Lab assignments at the end of both projects. Project 1 Cases and Places #3. Project 2 Cases and Places #4. |
|
Weeks 4 |
Excel 97 Project 3, What-If Analysis and Working with Large Worksheets. Integration – Linking and Excel worksheet to a Word document. |
Complete all of the In the Lab assignments at the end of both projects. Project 3 Cases and Places #1. Student disk due end of period on Friday. |
|
Week 5 |
Access 97 Project 1, creating a database using design and datasheet views. |
Complete all of the In the Lab assignments at the end of the project. Project 1 Cases and Places #2 and #3. |
|
Week 6 |
Access 97 Project 2, Querying a database using the select query window. |
Complete all of the In the Lab assignments at the end of the project. Project 2 Cases and Places #2 and #3. |
|
Weeks 7 |
Access 97 Project 3, maintaining a database using the design and update features of access. |
Complete all of the In the Lab assignments at the end of the project. Project 3 Cases and Places #2 and #3. Student disk due end of period on Friday. |
|
Week 8 |
Integration: Access and Excel. PowerPoint Project 1, using a design template and style checker to create a presentation. |
Complete all of the In the Lab assignments at the end of both projects. |
|
Week 9 |
PowerPoint Project 2, creating an electronic slide show. |
Complete all of the In the Lab assignments at the end of the project. Student disk due end of period on Friday. |
|
Week 10 |
Outlook 97 Project 1, desktop information management. |
Complete all of the In the Lab assignments at the end of the project. Student disk due end of period on Friday. |
|
Week 11 |
To be announced |
|
|
Week 12 |
Final |
|
NO FOOD OR DRINK ALLOWED IN THE COMPUTER LAB
** FEEDING THE INSTRUCTOR IS ALLOWED **