Microsoft Office 2010 Introductory

 

I. COURSE INFORMATION

       Course Title: Mabs 60  Credits: 3

       Course Hours: 3

 

       Instructor: Glenn Knapp                        Office: C106

       Office Hours:T, W: 6:00-6:30 PM

       Email: gknapp@ccsf.edu                         (650) 591-0999

 

II. TEXT AND MATERIALS  Software Discounts—http://www.collegesoftware.org

Before starting the course, you will need the following: CRN: 9780132454469

Ø   GO! with Microsoft Office 2010 Introductory by Shelley Gaskin, Robert L. Ferrett, Alicia Vargas,©2010, Vol. 1  published by Pearson Prentice Hall.

Ø   Storage device for saving files (any of the following: multiple diskettes, CD-RW, flash drive, etc.)

III. WHAT YOU WILL LEARN IN THIS COURSE

This is a hands-on course in which you will learn to use a computer to practice the most commonly used Microsoft programs, including the Windows operating system, Internet Explorer for navigating the Internet, and the three most popular programs within the Microsoft Office Suite (Word, Excel, and Access). You will also practice the basics of using a computer, mouse, and keyboard. You will learn to be an intermediate level user of the Microsoft Office Suite.

 

Within the Microsoft Office Suite, you will use Word, Excel, and Access. Microsoft Word is a word processing program with which you can create common business and personal documents. Microsoft Excel is a spreadsheet program that organizes and calculates accounting-type information. Finally, Microsoft Access is a database program that organizes large amounts of information in a useful manner. There will be three section tests and a final.

IV. ATTENDANCE

Ø   Students should be present and punctual for all classes.

Ø   Regular class attendance will maximize your computer skills for your personal and professional future.

V. CLASSROOM RULES OF CONDUCT

Ø   Be respectful of your instructor and fellow classmates at all times.

Ø   As a courtesy, please do not talk, type, or print while the instructor is talking to the class or when a student is asking a question which pertains to the class.

Ø   Refrain from “surfing” the Web during class, unless directed by your instructor.

Ø   Turn off cell phones and pagers.

Ø   Refrain from bringing food and drink into the classroom.

Ø   You are encouraged to work with other students to solve problems. However, you must complete your own work.

VI. CLASS POLICIES

 

It is the students' responsibility to make any arrangement necessary to obtain a personal tutor. The instructor will not be the student's personal tutor to design and develop the student's personal/business assignments (project). The student is required to learn the course concepts, and then create and develop their own personal/business assignments. The student must design and develop their homework independently, and use the online course information and the instructor as guidelines. The instructor will not install software on the student's personal computer at the students' home or business. The students are responsible and accountable for their own personal property. No cell phones, recorders, camcorders, or any other electrical device is allowed in the classroom without the permission of the instructor. No guests or children are allowed without the permission of the instructor or the Business Office.

 

Missed Classes: You are responsible for the activities of each class period.  If you know of a conflict ahead of time, you are welcome to submit projects early. There is no absolute right to a make up test unless you have an acceptable excuse. If you do not take a test on the scheduled day and have an excuse, contact me for a makeup quiz.  Makeup quizzes are typically more rigorous than the regularly-scheduled test (i.e. You may be asked to complete two or three Independent Challenges instead of only one.)

 

Academic Dishonesty: Plagiarism and cheating are serious offenses and may be punished by failure on an exam, paper or project; failure in the course; and/or expulsion from the College. For more information refer to the "Academic Dishonesty" policy in the College Catalog.

 

Need for Assistance: If you have any condition, such as a physical or learning disability for which you need extra assistance, please see me immediately.  If you have already met with Special Services, please provide me with information regarding your special need as soon as possible so that appropriate accommodations can be made.

Ø   Disability Accommodations - Students with a learning disability need to discuss their situation with the Disability Support Services Department.  Students need to request an accommodation notification for the instructor.

Ø   Cheating - It is expected that students will conduct themselves with integrity. If you cheat or assist others in cheating, you violate a trust.

Cheating includes but is not limited to the following:

Ø   copy files or lend your storage device to another student

Ø   copy answers on exams or glance at nearby exams

Ø   print work for someone else

Ø   turn in assignments that have been used in other classes

Ø   purchase or sell assignments or exam materials

If you cheat, some or all of the following actions will be taken:

Ø   You will receive a lower point score up to and including a zero for that particular assignment or exam.

Ø   A report of the incident may be forwarded to the Dean of Student Services. The Dean may file the report in your permanent record and/or take further disciplinary action.

VII. EVALUATION AND GRADING

 

You will be evaluated based on your combined performance on homework assignments and exams.

The Assignment Sheet will enable easy tracking of progress and grades. There will  be four exams.

Your ability to understand and follow the directions in the text thoroughly will be an essential component for successful completion of the projects/homework. The computer lab is in room C111

The following grading scale will be used: Test 1: 25%: Test 2: 25%: Test 3: 25%: Final: 25%

Percentage of Possible Points

Grade

90-100%

A

80-89%

B

70-79%

C

60-69%

D

Below 60%

F

 

VIII. COURSE OUTLINE & ASSIGNMENT SHEET

 There are tests after every section. The tests are 100 points each.

Course Outline & Assignment Sheet:  16-Week Semester

Unit

Read and
Perform Steps

Homework

Due Date

Possible Points

Your Points

1

 

 

Getting Started with Windows

 

Getting Started with Internet Explorer 8.0

 

 

Basic Computer Concepts

 

 

 

 

 

Matching

Fill in the blank

Project 1A

 

 

Matching

Fill in the blank

Project 3A

Additional Selected Projects

 

Matching

Fill in the blank

Multiple Choice

 

 

 

 

Unit

Read and
Perform Steps

Homework
to Turn In

Due Date

Possible Points

Your Points

2

Chapter1 Word

Creating Documents with Microsoft Word 2010

 

 

Matching

Fill in the blank

Project 1A

Project 1B

Project 1C

Project 1D

 

 

 


 

Unit

Read and
Perform Steps

Homework
to Turn In

Due Date

Possible Points

Your Points

3

Chapter2 Word

Using Tables Formatting and Organizing Text

 

 

Matching

Fill in the blank

Project 2A

Project 2B

Project 2C

Project 2D

 

 

 

 

Unit

Read and
Perform Steps

Homework
to Turn In

Due Date

Possible Points

Your Points

4,5

Chapter3 Word

Special Document Formats, Columns, and

Mail Merge

 

 

Matching

Fill in the blank

Project 3A

Project 3B

Project 3C

Project 3D

 

 

 

 

Unit

Read and
Perform Steps

Homework
to Turn In

Due Date

Possible Points

Your Points

6,7

Special Document Formats, Columns, and

Mail Merge

 

 

 

 

 

 

Unit

Read and
Perform Steps

Homework
to Turn In

Due Date

Possible Points

Your Points

8,9

Chapter 1

Creating a Worksheet and Charting Data

 

 

Matching

Fill in the blank

Project 1A

Project 1B

Project 1C

Project 1D

 

 

 

 

Unit

Read and
Perform Steps

Homework
to Turn In

Due Date

Possible Points

Your Points

10,11

Chapter 2

Managing Workbooks and Analyzing Data,Tables,
Functions

 

Matching

Fill in the blank

Project 2A

Project 2B

Project 2C

Project 2D

 

 

 

 

Unit

Read and
Perform Steps

Homework
to Turn In

Due Date

Possible Points

Your Points

12

Chapter 3

Using Data, Functions and Tables

 

Matching

Fill in the blank

Project 3A

Project 3B

Project 3C

Project 3D

 

 

 

 

Unit

Read and
Perform Steps

Homework
to Turn In

Due Date

Possible Points

Your Points

13

Chapter 1

Getting Started with Access Databases and Tables

 

Matching

Fill in the blank

Project 1A

Project 1B

Project 1C

Project 1D

 

 

 

 

Unit

Read and
Perform Steps

Homework
to Turn In

Due Date

Possible Points

Your Points

14

Chapter 2

Sort and Query a Database

Matching

Fill in the blank

Project 2A

Project 2B

Project 2C

Project 2D

 

 

 

 

Unit

Read and
Perform Steps

Homework
to Turn In

Due Date

Possible Points

Your Points

15

Chapter 3

Forms, Filters, and Reports,
Tables, Video

 

Matching

Fill in the blank

Project 3A

Project 3B

Project 3C

Project 3D

 

 

 


 

 

Unit

Read and
Perform Steps

Homework
to Turn In

Due Date

Possible Points

Your Points

16

 

 

 

 

 

16

Final Exam Week

Final Exam