Syllabus Course Number: COM151

National College

Revised 2-14-12

COM151: The Microsoft Office

Credit Hours: 4

Prerequisites: PRE080, if applicable


Course Description

This is an introductory course that provides a comprehensive study of The Microsoft Office. This course is a combination of lecture and hands-on training.


Instructor Contact Information

Instructor Name

Gerard Arthus Term 125 13 July to 20 September

(10 weeks) 2012

Instructor E-mail

Garthus801@gmail.com

Instructor Phone

574-855-1617


Course Length

The college evaluates each course in terms of quarter hours of credit. One unit of credit is usually equivalent to a minimum of ten academic instruction hours of lecture and examination, twenty hours of skill development, or thirty hours of internship, or a combination of the three. An academic instructional hour is fifty minutes.


This class will meet for the equivalent of a minimum of five (5) instructional hours per week for ten (10) weeks or as otherwise scheduled by the college and at least in conformance with this minimum and the Syllabus. As specified by the Method of Instruction section of this Syllabus, the instructor will ensure that the total class sessions presented consist of a minimum of 25 direct faculty instruction hours and a maximum of 25 appropriate classroom activity hours.


All course offerings require outside participation time, which is approximate4ly two hours per lecture instructional hour and/or one hour per skill development instructional hour, depending on the background, interest, abilities, and motivation of the individual student.


Course Objectives

By the end of this course, you should be able to:

Microsoft Outlook 2010

Students will open Outlook and display and edit the calendar.

Students will schedule appointments using the Outlook calendar.

Students will schedule a meeting in Outlook.

Students will add a contact and learn how to edit and search contacts and appointments.


Computer Literacy

Students will define terms dealing with computers in general, memory, networks, Internet, and software.

Students will describe different types of computers, input devices, output devices, and processors.

Students will learn to navigate around the Windows 7 operating system.

Students will be introduced to file management.

Students will use features of Internet Explorer to navigate and use the Internet.

Students will be able to use features that are common to all applications in Microsoft Office 2010.


Microsoft Word 2010

Students will create a document.

Students will correct spelling and grammar.

Students will use AutoCorrect.

Students will be introduced to various methods of moving around inside a document.

Students will save a document.

Students will be introduced to various methods of selecting test.

Students will move text within a document.

Students will use Find and Replace.

Students will create lists.

Students will format by changing margins, line spacing, test alignment, fonts and their attributes.

Students will use and edit shapes within their document.


Microsoft Excel

Students will create a spreadsheet.

Students will practice various methods of selecting ranges.

Students will move ranges of data.

Students will use formulas and functions.

Students will insert and delete rows and columns.

Students will use copying and pasting to duplicate formulas.

Students will work with charts.

Students use themes to format a spreadsheet.


Microsoft Access 2010

Students will create a database, tables and forms.

Students will print a table.

Students will create a form.

Students will describe the guidelines involved in designing a database.


Microsoft PowerPoint 2010

Students will use different views of an existing presentation.

Students will modify an existing presentation by editing text, deleting, adding and moving slides.

Students will edit graphics.

Students will create a table slide.

Students will create a presentation using design themes.

Students will add animation to their presentation.

Students will use text boxes.


Gradebook

A student’s performance in this course will be evaluated using a variety of factors listed below. Instructors must use a minimum of three (homework, tests, and a final exam are required), and it is recommended that instructors use all five of the areas in their evaluation.


The exact weight to be given to any particular area is determined by the instructor and will normally fall within the ranges listed below.


Area

Percentage for
this Course


Suggested Range





Final Exam

25%


20-25%





Tests

40%


20-40%





Homework

15%


10-15%





Project/Research Paper

10%


20-25%





Class Participation

10%


10-15%





TOTAL

100%




Letter Grade

Points

Explanation

A

94-100

Excellent

B

84-93

Above Average

C

74-83

Average

D

64-73

Below Average

F

63 & Below

Failure


Textbook & Instructional Material

Muir, Nancy and Verno, Anita. Guidelines for Microsoft Office 2010. Minnesota: Paradigm, 2011. Headphones or ear buds are required for listening segments. A flash drive is required to complete exercises and projects.


Paradigm provides and Instructor’s Resource DVD containing the Instructor’s Manual, Exam View Computerized Test Bank, and PowerPoint presentation slides.


SNAP 2010 Training and Assessment will be available for online training and/or testing.


Online assistance for students and instructors is found at www.emcp.net/guidelines.


There will be on-line resources provided in a web-assisted environment for this course at:


http://www.openeducation.org/moodle


Please consult this site for on-line quizzes and written assignments.


Course Outline

Week 1

Topic

Managing Your Time with Microsoft Outlook

Material Covered

Chapter 1: Microsoft Outlook

Module 1: Computing Essentials

Module 2: Microsoft Windows 7 and File Management

Module 3: Internet Basics

Module 4: Microsoft Office 2010 Overview

In Class Activities

June 19, 2012 PM

Discussion regarding Microsoft Outlook; Computing Essentials; Microsoft Windows 7 and File Management; Internet Basics, and Microsoft Office 2010 Overview

Homework

Read all textbook sections and complete all skills assignments for this week.

Complete Discussion forum for this week and all readings assigned on the web-assisted site.

Week 2


Topics

Module 5: Word 2010

Virtual Library Orientation

Material Covered

Word: Chapter 1 & 2

In Class Activities

Library Orientation – Matthew Falcon, Librarian

Read and Discuss Chapter 1 & 2 of Word 2010 and complete skills assignments

Homework

Complete Discussion forum for this week and all readings assigned on the web-assisted site.

Textbook: Exercise A, p212; Exercise C, p214;

Week 3


Topics

Module 5: Word 2010

Material Covered

Word: Chapter 3 & 4

In Class Activities

Read and Discuss Chapters 3 & 4 Word 2010 and complete skills assignments

Homework

Complete Discussion forum for this week and all readings assigned on the web-assisted site and quiz.

Textbook: Exercise A, p351

Week 4

Topics

Module 6: Excel 2010

Material Covered

Excel: Chapter 1 & 2

In Class Activities

July 10, 2012

Read and Discuss Chapters 1 & 2 Excel 2010 and complete skills assignments

Homework

Complete Discussion forum for this week and all readings assigned on the web-assisted site and quiz.

Week 5

Topics

Module 6: Excel 2010

Material Covered

Excel: Chapter 3 & 4

In Class Activities

July 17, 2012

Read and Discuss Chapters 3 & 4 Excel 2010 and complete skills assignments

Homework

Complete Discussion forum for this week and all readings assigned on the web-assisted site and quiz.

Textbook: Exercise A, p418; Due July 24, 2012

Week 6

Topics

Module 7: Access 2010

Material Covered

Access: Chapter 1 & 2

In Class Activities

Read and Discuss Chapters 1 & 2 Access 2010 and complete skills assignments

Homework

Midterm-Word and Excel applications


Complete Discussion forum for this week and all readings assigned on the web-assisted site and quiz.


Textbook: Exercise B, p468

Week 7

Topics

Module 7: Access 2010

Material Covered

Access: Chapter 3

In Class Activities

Read and Discuss Chapters 3 Access 2010 and complete skills assignments

Homework

Complete Discussion forum for this week and all readings assigned on the web-assisted site and quiz.

Textbook: Exercise B, p508

Week 8

Topics

Module 8: PowerPoint 2010

Material Covered

Chapter 1 & 2

In Class Activities

Read and Discuss Chapters 1 & 2 PowerPoint 2010 and complete skills assignments

Homework

Complete Discussion forum for this week and all readings assigned on the web-assisted site and quiz.

Textbook: Exercise B, p542;

Week 9

Topics

Module 8: PowerPoint 2010

Material Covered

Excel: Chapter 3 & 4

In Class Activities

Read and Discuss Chapters 3 & 4 PowerPoint 2010 and complete skills assignments

Homework

Complete Discussion forum for this week and all readings assigned on the web-assisted site and quiz.

Final exam open this week and final project assignments

Textbook: Exercise A, p579

Week 10

Final

In-Class Final Examination


During terms that include less than 11 weeks, instructional time will be changed to accommodate all materials, resources, research activities, etc.


Method of Instruction


Instructional techniques must be appropriate and at a collegiate level, to the specific goals and objectives cited above. Students and instructors must have a clear understanding of the goals and time requirements of this course, the nature of the course context, and the methods of evaluation.


This course has two distinct but related instructional phases:


The first component constitutes a minimum of 25 classroom lecture hours or fifty percent of the course and time requirement for successful completion. This component is the lecture series and provides instruction in theory, principles or practices of the course. The instructor will provide classroom presentations in a variety of lecture formats and must adhere at least to the time allowed for this learning component. The instructor must demonstrate that an effective relationship exists between curricular content and current practices in the field and skills development applications.


The second component constitutes of a maximum of 25 classroom skill development hours or fifty percent of the course and time requirement for successful completion. This component is te skill development phase of the course and provides students the opportunity to apply knowledge gained in the lecture series and enhance skills and develop practical problem solving abilities and skill enhancement capabilities.


Effective instruction depends largely upon the maintenance of an environment conducive to study and learning. For this reason, the instructor must provide for his/her students a learning environment in which scholarly and creative achievement is encouraged in both the lecture and skills development component.


Additional Class Notes


No excused absences.

Please call or e-mail me if you will be absent or late for class.

If you miss a class, you are still responsible for completing the assignments and learning any missed material.

All assignments must be turned in on time – if not, a zero grade will be entered into Engrade.com

E-mail as an attachment each assignment to me at: garthus801@gmail.com. A paper copy may be requested for certain assignments.

If you are gone for breaks more than the requested minutes, minutes will be deducted from your attendance in class.

Bottled drinks with tight caps are permitted in the classroom.


COM151 • Page 8 of 8