DIVISON OF Career and Technical Education

COMPUTER INFORMATION SERVICES DEPARTMENT

CIS 230 INTRO TO MICROSOFT OFFICE 2007 (Windows XP)—3 credit hours

COURSE SYLLABUS

SUMMER SCHOOL:  JUNE 2 TO JULY 28, 2008

COURSE DESCRIPTION:

As a student in this course, you will learn the most important topics of Microsoft Office 2007.  No prior computer experience is assumed.  You will learn the Office 2007software programs: Word 2007 Excel 2007, Access 2007, PowerPoint 2007, and Outlook 2007.  You will also learn how to integrate these applications.

PREREQUISITES: 

None.

TEXT AND OTHER MATERIALS:

MICROSOFT OFFICE 2007, MARQUEE SERIES with Windows XP and Internet Explorer 7.0, Rutkosky, EMC Paradigm.  BUNDLED FOR NPC ISBN: 978-0-76383-223-0 (Textbook includes CD containing student data files.)  Also Includes a FREE 180-DAY TRIAL OF MS OFFICE 2007 SOFTWARE. (After 180 days, student will have the opportunity to purchase it for $59).   THIS OFFER IS ONLY FOR TEXTBOOKS PURCHASED AT THE NORTHLAND PIONEER COLLEGE BOOKSTORE.   

Internet students:  You do not need these if you are saving your work on your own computer.

Do not open your textbooks until you check with your instructor, make sure you have the correct text and are in the right class.  The bookstore will not give refunds on textbooks with broken seals.  Check your computer system to make sure that it meets the requirements for MS Office 2007 (see below).

Do you have  Windows Vista?   If you do, then ask your instructor for the course syllabus that will direct you to the correct MS OFFICE 2007 For Vista Windows textbook, and assignments for that version.

*System Requirements: MICROSOFT OFFICE 2007

·         Windows XP with Service Pack 2 or later, or Windows Vista

·         500 MHz processor or higher; 256 MB RAM or higher

·         DVD drive

·         2 GB of available hard-disk space

·         800 x 600 minimum monitor resolution; 1024 x 768 recommended

·         Computer mouse, or compatible pointing device

STUDENT CONDUCT and ATTENDANCE:

All students are responsible for knowing and understanding the Northland Pioneer College Student Conduct Code.  The code is in the Student Guide, available from any campus or center office.  Any violation of the conduct code, academic or otherwise, will be reported to the appropriate vice president for investigation and decision.

Upon entering Northland Pioneer College, a student assumes the responsibility of completing each course for which he/she is registered. The student is expected to attend all sessions of the classes in which he/she are enrolled.  Students should review attendance policies as stated in the Northland Pioneer College Student Guide under “Student Rights and Responsibilities.”  Internet students: are required to communicate with the instructor once a week (email). 

DISABILITY STATEMENT:

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 by calling 1-800-266-7845 and asking for extension 6178.  In the Show Low area call 532-6178.

COURSE COMPETENCIES/OUTCOMES:· 

• Analyze, synthesize, and evaluate school, work, or home situations and apply MS Office technology to complete information-processing tasks efficiently and effectively.

• Use and customize the capabilities of the operating system utilities to solve problems.

• Access the Internet and learn to use the browse, search, and hyperlink capabilities of Web browsers.

• Create, design, and produce professional documents using word processing software (Word).  Functions include:  design options for formatting and layout, strategies for working with multiple documents, techniques for using templates and pre-designed styles, and procedures for creating tables. 

• Process, manipulate and represent numeric data using spreadsheet software (Excel).  Functions include:  techniques for preparing and formatting an Excel Worksheet, including Styles and Format Painter, creating formulas, using multiple worksheets, exploring what-if scenarios, and converting data into chart formats.

•  Design and create information and motivational slides using presentation software (PowerPoint) and images that contain hyperlinks, tables, clip art and animation.

•  Use WordArt to create organizational charts and draw and format objects in Word and Excel.

• Learn strategies for merging and integrating source data from different MS Office applications, using the commands for object linking and embedding.

• Plan, structure, and create databases for efficient data access and retrieval using database software (Access). Functions include:  search and sort capabilities for extracting data, data retrieval commands, techniques for record specification and design options for report layout.

  GETTING STARTED:

• 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/personal progress record (in this guide) carefully noting due dates and assignments.  Your instructor will record your scores as you proceed through the course. 

• Turn to the Course Schedule in this course syllabus to start on Week 1 Assignments.   As you proceed through each chapter, you will read all chapter material completing the exercises and activities as presented. 

• Copy your student data files from your CD to your flash drive or hard drive if you are an Internet student.  Instructions for doing this are on the  inside  back cover of your textbook.  You will need these files to complete your chapter work.

• Label your work with your name, course name, date, and assignment.  Put your work in your folder with a copy of your Course Schedule/Personal Progress Record and give it to your instructor for grading.  Put this information at the bottom of your document so you do not interfere with the document’s format.  There is a

• key commands quick reference sheet  in the appendix of the textbook that you will find helpful as you proceed through the course.

• Internet students:  Save assignments as you complete them. You do not have to print anything out.  You will got into WEBCT/BLACKBOARD (the link is located on the NPC website).  Your instructor will give you an ID and password to add this class after you have contacted the instructor.)  WEBCT is where you will go to email and attach all Skills Reviews, Skills Assessments and Integrating Programs  to send to your instructor.  Send only the answers to the Knowledge  Checks in an email.   

PUBLIC NOTICE OF NON-DISCRIMINATION: 

The College does not discriminate on the basis of race, color, national origin, religion, marital status, gender, age or disability in admission or access to, or treatment or employment in its educational programs or activities.  District grievance procedures will be followed for compliance with Title IX and Section 504 requirements.  The Affirmative Action Compliance Officer is Mr. A. Daniel Simper, Director of Personnel, 103 N. 1^st Ave. at Hopi Drive, Holbrook, AZ 86025, (928) 524-7671.  The Section 504 Compliance Officer is the Coordinator of Disability Resources and Access, 1001 W. Deuce of Clubs, Show Low AZ 85901, and (928) 532-6178.  The lack of English language will not be a barrier to admission and participation in vocational education programs.

GRADING PROCEDURE:

The instructor is responsible for assigning grades. Grades are based on academic performance, class participation and attendance. Academic dishonesty will not be tolerated. Faculty may lower a grade based on academic dishonesty or other forms of student misconduct. Academic dishonesty or other forms of student misconduct may also be referred to the Vice President for Student Services for further action. Grade changes can be made only by the instructor with approval of the Dean/Division Director and/or the Vice President for Learning. Students who disagree with a grade may file a grievance as outlined in the Policy & Procedures Manual of Northland Pioneer College (Source: Northland Pioneer College Catalog).

Students should review grading policies as stated in the Northland Pioneer College Catalog, or on the NPC web page, or in the Student Guide.

Only under instructor approval will late assignments and/or exams be accepted during the last two weeks of classes.

EVALUATION:

• Label all of your work at the bottom of the document with your name, date, week and assignment. Points will be deducted for errors in spelling, format, and incorrect answers. 

• You will not be penalized for finishing ahead of schedule, but you could lose points for turning in assignments late.  Your instructor will drop you if you do not attend class or contact instructor for 3 weeks. 

• Knowledge Check:   Answer these either on a sheet of paper or in your textbook.  Your instructor will go over these with you.  These are worth 1 point each (276 total points).  Internet Students:  Email only the answers to these either in an email or Word document attached to your email.  Your instructor will grade these and will send you your score.

•  

• Skills Review:  These are to be completed WITHOUT any assistance!  They are worth 5 points each. (260 total points.)  Internet Students:  Go into WEBCT/BLACKBOARD to attach these to emails to send to your instructor.

•  

• Skills Assessment: These are to be completed WITHOUT any assistance.    These are worth 10 points each. (860 total points.)  Internet Students:   Go into WEBCT/BLACKBOARD to attach these to emails to send to your instructor.  Your instructor will grade these and send you your score.

•  

• Integrating Programs:  include numerous integration activities using Word, Excel, Access, and PowerPoint. These demonstrate how documents can be created in one application and then shared with another.  These are worth 10 points each (110  points.)  Internet Students:   Go into WEBCT/BLACKBOARD to attach these to emails to send to your instructor.  Your instructor will grade these and send you your score.

GRADING SCALE:

 Your final grade will be based on the total points you have on the final day of class using the  following course  grading scale.

 Course Study Schedule cis 230 ms office 2007

The Course Study Schedule is designed to help you stay “on track.” By following the schedule, you should complete the course by the end of the semester. If you are having trouble meeting these weekly timelines, see your instructor.  You may complete the course early by working ahead if you wish.  Again, you may be penalized for late work.  Internet students:  work is due by the end of each week.

Internet Students:  Make sure your work is labeled as to Section and Assignment number before attaching it to send to your instructor.  (You will go into WEBCT/BLACKBOARD  to email and send attached assignments.) 

COURSE SCHEDULE CIS 230 MS OFFICE 2007 WINDOWS XP VERSION

COURSE STUDY SCHEDULE/PERSONAL PROGRESS RECORD

 Your final grade will be based on the total points you have on the final day of class using the  course  grading scale.