MANSFIELD UNIVERSITY
CIS 103 COURSE SYLLABUS

(last revised 6/25/2001)

GENERAL INFORMATION

Course number: CIS-103
Credit/Contact hours: 3
Term: Summer II, June 25 - August 3, 2001
Course title: Introduction to Microcomputers
College website: www.mansfield.edu

INSTRUCTOR INFORMATION

Instructor name: John Phillips
Instructor office location: Elliott 213A
Instructor office hours: To be announced.
Instructor telephone: 570-662-4704
Instructor e-mail address: jphillip@mnsfld.edu
Instructor website: www.programbetter.com

COURSE INFORMATION

Course Description

Introduces the Disk Operating System for microcomputers and the use of word processing, spreadsheet, presentation, and database management software.

Prerequisite: none

Textbook

Microsoft Office 2000: Introductory Concepts and Techniques, Shelly, Cashman, and Vermaat. Course Technology.

Supplies

Five 3.5 inch HD diskettes.

Course Website

www.programbetter.com

Course Outline

  1. Windows Operating Systems - an overview
  2. File management
  3. Windows accessory programs
  4. Word processing using Word
  5. Presentations using PowerPoint
  6. Spreadsheets using Excel - an overview
  7. Databases using Access - an overview
  8. Advanced topic selected by student

ADDITIONAL COURSE INFORMATION

Class schedule

M, Tu, W, Th, F from 11:00 AM to 12:20 PM

Grading scale and policy

(Refer to the Mansfield University Catalog for grades that can be awarded.)

A >= 90%
B >= 80%
C >= 70%
D >= 60%
F < 60%

In addition, the instructor may choose to further differentiate grades with plus and minus subdivisions as outlined in the catalog.

Course Grade % of Grade
Hands-on Assignments 50
MS Word Test 10
MS PowerPoint Presentation 10
MS Excel Test 10
Terminology Test 20

Methods of instruction

This is a mostly hands-on course. In general, there will be a lecture to introduce the material. Then you will spend much of your time working on projects on the computer. As you complete each assignment, compare your printout to the instructor's printout. If it looks correct, then submit it to the instructor for grading. Wait while the instructor checks your work so he can discuss any mistakes with you. If there is a mistake, you will have to correct it and resubmit your work for grading again.

Syllabus Change Policy

The instructor reserves the right to make changes to this syllabus as the course progresses.

COURSE TIMELINE

Week Date Topics
1 06/25

Monday: Intro to course, Windows OS

Tuesday: An Intro to Win98 and Office 2000 Project 1; read and do INT 1.1 - 1.75.

Wednesday: MS Word 2000 Project 1; read and do WD 1.1 - WD 1.58. Add your initials to the very end of the document before printing.

Thursday: Do In The Lab 3 on page WD 1.62. Add your initials to the very end of the document before printing.

Friday: MS Word 2000 Project 2; read and do WD 2.1 - WD 2.55. Do not e-mail a copy of the research paper. Use your last name instead of Williams in the header of the paper.

2 07/02

Monday: Do In The Lab 1 on page WD 2.57. Use your last name instead of Thornton in the header of the paper.

Tuesday: MS Word 2000 Project 3; read and do WD 3.1 - WD 3.61. Use regular paper to simulate an envelope. Use your name in place of Paulette Rose Brandon in all documents.

Wednesday: Fourth of July Holiday.

Thursday: Word hands-on test.

Friday: MS PowerPoint Project 1; read and do PP 1.1 - PP 1.70. Replace the words Seaview College with your first and last name in the first slide.

3 07/09

Monday: Do In The Lab 2 on page PP 1.74. Use your name in place of Lake Shore Mall on the first slide.

Tuesday: MS PowerPoint Project 2; read and do PP 2.1 - PP 2.58. Use your name in place of The Office of Financial Aid on the first slide.

Wednesday: Create a 2 or 3 minute slide show on your hobby or some other favorite topic.

Thursday: Work on PP hobby slide show.

Friday: Present your PowerPoint presentation to the class.

4 07/16

Monday: MS Excel Project 1; read and do E 1.1 - E 1.58. Type in your name a couple of rows under the chart before you print.

Tuesday: Do In The Lab 1 on page E 1.60. Use your name in place of Marvin's.

Wednesday: MS Excel Project 2; read and do E 2.1 - E 2.64. Type in your name at the bottom of the worksheet before you print it out.

Thursday: Do Cases and Places 1 on page E 2.77. Make sure to type your name somewhere on the worksheet before you print it out.

Friday: Excel hands-on test.

5 07/23

Monday: MS Access Project 1; read and do A 1.1 - A 1.54. Add an extra row to each of the tables that has your name along with some fictional filler information before printing.

Tuesday: MS Access Project 2; read and do A 2.1 - A 2.43.

Wednesday: MS Access Project 3; read and do A 3.1 - A 3.51

Thursday: take home terminology test over all material

Friday: catch up lab time

6 07/30

Monday: Take home test due. Student choice week.

Tuesday: research project of choice

Wednesday: develop project

Thursday: develop project

Friday: present final project