Adopted: Fall 1998
Reviewed: Summer 2001
Revised: Summer 2001

CIS 146 MICROCOMPUTER APPLICATIONS (Microsoft Office)

Prerequisite: Keyboarding skills recommended
Credit Hours: 3 hrs. Contact Hours: 3

I. COURSE DESCRIPTION:

This course is an introduction to the most common software applications of microcomputers and includes "hands on" use of microcomputers and some of the major commercial software. These software packages should include typical features of office suites, such as word-processing, spreadsheets, database systems, and other features found in current software packages. Upon completion, students will understand common applications and be able to utilize selected features of these packages.

II. GENERAL COURSE COMPETENCIES:

A. The student will understand the components of a computer system.
B. The student will understand the role of Windows in a computer system.
C. The student will learn to use the basic capabilities of Microsoft Excel spreadsheet software package.
D. The student will learn to use the basic capabilities of Microsoft Access database software package.
E. The student will learn to use the basic capabilities of Microsoft Word word processing software package.

III. COURSE OBJECTIVES:

The following objectives will be completed with at least 60% accuracy overall to receive a passing grade for this course.

A. The student will understand the components of a computer system.

1. The student will be able to list and describe the functions and interrelationships of the hardware components input/output devices, CPU, and secondary storage.

B. The student will understand the role of Windows in a computer system.

1. The student will be able to use Windows to move, copy and rename files.

C. The student will learn to use the basic capabilities of Microsoft Excel software package.

1. The student will be able to create, store and retrieve worksheets.
2. The student will be able to enter formulas using relative addressing, absolute addressing, and functions.
3. The student will be able to format, copy, and move a range of cells.
4. The student will be able to print worksheets.
5. The student will be able to create and print simple charts.

D. The student will learn to use the basic capabilities of Microsoft Access database management software package.

1. The student will be able to design and create database files.
2. The student will be able to add, delete, modify and display records in existing files.
3. The student will be able to retrieve data meeting specified simple and complex criteria.
4. The student will be able to sort records.
5. The student will be able to print reports.

E. The student will learn to use the basic capabilities of the Microsoft Word word processing software package.

1. The student will be able to open, edit, save and close documents.
2. The student will be able to create and format documents.
3. The student will be able to move and copy text in documents.
4. The student will be able to create documents which include columns and graphics.
5. The students will be able to check / correct spelling and print documents.

IV. CLASS ACTIVITIES:

A. Lecture and discussion.
B. Preparation of spreadsheets, files and documents using the microcomputer.
C. Demonstrations.

V. EVALUATION:

A. Daily assignments.
B. Examinations.

VI. TEXT: Microsoft Office 2000 - Introductory Concepts & Techniques Enhanced, Windows 98 and the SAM Password
Authors: Shelly, Cashman & Vermaat
Publisher: Course Technology