May 08 Rev
NORTHLAND PIONEER COLLEGE
COMPUTER INFORMATION SERVICES DEPARTMENT
CIS 235 ADVANCED MS OFFICE 2003—3 credit hours
COURSE SYLLABUS MS OFFICE 2003
SUMMER SCHOOL 2008
June 2 -July 28, 2008
DO NOT OPEN YOUR TEXTBOOKS UNTIL YOU CHECK WITH YOUR INSTRUCTOR TO SEE IF YOU HAVE CORRECT VERSION AND ARE IN THE RIGHT CLASS. THE BOOKSTORE WILL NOT GIVE REFUNDS ON OPENED TEXTBOOKS!
COURSE DESCRIPTION:
This advanced course covers features of MS Office Suite 2003. Programs include: MS Word 2003, Excel 2003, Access 2003, and PowerPoint 2003. Students will apply problem-solving techniques to complete professional looking documents and projects. Students successfully completing this and Introduction to MS Office will be prepared to take the Microsoft Office Specialist (MOS) Certification exams.
PREREQUISITES:
CIS 230 Introduction to MS Office 2003. This course begins with many advanced features. A good knowledge of basics is required.
TEXT AND OTHER MATERIALS:
Because NPC is updating to MS OFFICE 2007, the 2003 books will not be available at the NPC bookstore. You will need to order them from another vendor. (List on NPC Bookstore website.) T
Ms WORD 2003, EXPERT, BENCHMARK SERIES, Rutkosky, EMC Paradigm
MS EXCEL 2003, EXPERT, BENCHMARK SERIES, Flynn, EMC Paradigm
MS ACCESS 2003, EXPERT, BENCHMARK SERIES, Flynn, EMC Paradigm
If you wish to update to MS Office 2007, NPC is selling the MS OFFICE 2007 CIS 235 books which come with a free 180-day trial MS OFFICE 2007 software (after 180 days, student may purchase permanently for $59). ONLY AVAILABLE AT NPC! For more information on the books, go back and click on MS OFFICE 2007 VISTA or MS OFFICE WINDOWS XP (depending on what Windows version you have). Make sure your computer will handle MS OFFICE 2007 before opting this.
ATTENDANCE:
Upon entering Northland Pioneer College, students assume the responsibility of completing each course for which they are registered. Students are expected to attend all sessions of the classes in which they are enrolled. Any student who has three (3) absences without communication with the instructor, will be dropped from the class. Students who miss the first two (2) meetings of the class may also be dropped. It is the student's responsibility to communicate with the instructor.
At most campuses/centers, open labs are available for students (a schedule is available within the first two weeks). This course will require 6-12 hours per week additional computer time outside of class for successful completion of assignments. All students must follow college/lab electronic usage policies and student conduct code.
You are not penalized for completing this course early. However, you may be penalized for turning work in late.
COURSE COMPETENCIES/OUTCOMES:
 |
Use advanced features (graphics, merging, templates, hyperlinks, tables, formatting, and columns) of MS Word 2003 to prepare various professional documents. |
|
Create a Web page with graphics, buttons, and hyperlinks using MS Word 2003. |
|
Use MS Excel 2003 to create various business documents using advanced features (calculations, functions, assumptions, and goal seeking).. |
|
Use MS Access 2003 to develop databases. |
|
Utilize advanced features of MS PowerPoint 2003. |
|
Integrate MS Word, Excel, Access, and PowerPoint to create professional business documents. |
Reasonable accommodations for qualified students with disabilities are available
through the Disability Resources and Access Office (DRA). If you have questions
or wish to receive accommodations you will need to contact the Disability
Resources and Access Coordinator, Laurie Winder, by calling 1-800-266-7845 and
asking for extension 6178. In the Show Low area call 532-6178.
GETTING STARTED:
|
Do not open your textbooks until you make sure you have correct text and are in right class. The bookstore will not give refunds on textbooks with broken seals. |
|
Read this course syllabus thoroughly! This guide will explain everything you need to know for successful completion of this course. You will need to bring it with you for each class session. Follow the course schedule carefully noting due dates and assignments. Do only assignments listed. You will record your scores on the point sheet attached as I send you your scores. |
|
Complete all course requirements. (See below.) |
COURSE REQUIREMENTS:
|
This is a “hands-on” course with emphasis on applications and simulations. You will be required to complete assignments and projects but there are no written tests. |
|
Sending me your work: You will complete the assignments in the appropriate programs and then attach to me in emails to me through WEBCT (I will help you get set up in this "virtual classroom." |
|
You are allowed to redo and resubmit any assignments where you had problems and resubmit them. Do not get behind on your work! There is a lot of work to do in this class. |
|
Read through each chapter assigned paying attention to the Performance Objectives listed at the beginning, the Hints and Quick Steps along the margins, and looking at each of the Figures. At the end of the each chapter read through the Chapter Summary and Features Summary, which recap what you have learned in the chapter. |
|
Exercises: 1 pt. each. |
|
Concepts Check: 1 pt. each. |
|
Assessments: 5 pts. each |
|
Work In Progress and Workplace Ready Assessments: 10 pts. each. |
|
Chapter Challenge at the end of the chapters is not assigned, but you may complete them if you wish more reinforcement of the concepts learned in the chapter. (These are not graded or part of the total score for the course). |
|
In order to “pass” this class with a C, you will need to have enough points as listed below for a C. Incompletes “I” grades will only be given under very special circumstances and only if you are 85 percent through the course as listed in the NPC Catalog. |
EVALUATION METHOD:
Exercises (1 pt. each) 276 total points possible
Concepts Checks (1 pt. each) 335 total points possible
Assessments (5 pts. each) 870 total points possible
Work in Progress Assessing Proficiency (10 pts. each) 490 total points possible
Total 1971 total points possible
GRADING SCALE:
A=1774-1971
B=1577-1773
C=1380-1576
D=1183-1379
F=1182 AND BELOW
CIS 235 ADVANCED MS OFFICE 2003 VERSION
COURSE SCHEDULE AND POINT SHEET
|
WEEK |
ASSIGNMENT |
EXERCISES |
CONCEPTS CHECK |
SKILLS (5 PTS.) AND PERFORMANCE ASSESSMENTS (10 Pts.Ea.)* |
POINTS |
|
1 |
Orientation Read this Course Syllabus |
|
|
|
|
|
WORD 2003 EXPERT |
|
|
|
|
|
|
1 |
Chapter 1 |
1-18 |
1-16 |
1-8 |
|
|
Chapter 2 |
1-17 |
1-15 |
1-6 |
|
|
|
Chapter 3 |
1-19 |
1-11 |
1-11 |
|
|
|
Chapter 4 |
1-23 |
1-13 |
1-8 |
|
|
|
2 |
Work In Progress Unit 1 Chapter 5 |
1-14 |
1-12 |
1-12* 1-6 |
|
|
Chapter 6 |
1-19 |
1-14 |
1-4 |
|
|
|
Chapter 7 |
1-11 |
1-11 |
1-3 |
|
|
|
Chapter 8 Workplace Ready |
1-12 |
1-8 |
1-5 1-9* |
|
|
|
EXCEL 2003 EXPERT |
|
|
|
|
|
|
3 |
Chapter 1 |
1-8 |
1-20 |
1-12 |
|
|
Chapter 2 |
1-7 |
1-17 |
1-8 |
|
|
|
Chapter 3 |
1-7 |
1-17 |
1-7 |
|
|
|
4 |
Chapter 4 Work In Progress Assessing Proficiency |
1-11 |
1-17
|
1-11 1-10* |
|
|
Chapter 5 |
1-13 |
1-15 |
1-7 |
|
|
|
Chapter 6 |
1-5 |
1-18 |
1-5 |
|
|
| 5 |
Chapter 7 |
1-6 |
1-17 |
1-5 |
|
|
Chapter 8 Work In Progress Assessing Proficiency |
1-14 |
1-15 |
1-9 1-5* |
|
|
|
ACCESS 2003 EXPERT |
|
|
|
|
|
| 6 |
Chapter 1 |
1-11 |
1-10 |
1-8 |
|
|
Chapter 2 |
1-12 |
1-10 |
1-9 |
|
|
|
Chapter 3 |
1-9 |
1-15 |
1-6 |
|
|
|
7 |
Chapter 4 Work in Progress |
1-6 |
1-15 |
1-7 1-7* |
|
|
Chapter 5 |
1-7 |
1-12 |
1-4 |
|
|
|
Chapter 6 |
1-7 |
1-15 |
1-12 |
|
|
| 8
|
Chapter 7 |
1-6 |
1-12 |
1-5 |
|
|
Chapter 8 Workplace Ready |
1-14 |
1-10 |
1-8 1-6* |
|
|
Your final grade is the total number of points you have the last day of class. Grading scale:
A=1774-1971
B=1577-1773
C=1380-1576
D=1183-1379
F=1182 AND BELOW