Microcomputer Software Applications I
CIS 240
Fall 2000
Saint Augustine's College

Instructor: Albert L. Crawford
Office: Cheshire 118
Phone: (919) 516-4048
Office Hours: MWF 9:00 - 11:00
E-mail: Albert@CrawfordEnterprise.com
Web page: www.CrawfordEnterprise.com/StAug/index.html

Class Time and Place: TT 5:30 to 6:45 in Cheshire 2.

Text: Shelly and Cashman Series - Custom Edition - 1997 - containing Windows 95, Microsoft: Word 7, Excel 7, and Access 7.

Course Description: It is the aim of this course to provide students with an opportunity to develop computer applications skills in word processing, computer graphics, database management, spreadsheet, and windows environments. Prerequisite: CIS 203.

Course Goals and Objectives:  Each student will be able to

  1. Identify and describe information processing fundamentals as they exist today, their purpose, their overall importance, their social and business uses, and their implementations for the future.
  2. Explain the various uses of equipment, materials, software, and computers regarding effective information processing.
  3. Demonstrate proficiency in using elegtronic input devices.
  4. Exhibit interpersonal skills, work habits and attitudes that are accepted in the business environment.

Course Content: This course will provide detailed instructions in the use of Windows 95 and Microsoft Word, Excel, and Access.

Introduction to DOS  The Disk Operating System (DOS) manages the operation of the computer.  The programs in DOS allows interfaces and communications between the computer user, the computer software and the computer hardware.  Students will learn commands necessary to maintain their data diskettes.

Introduction to Windows:  Windows provides the capability to learn applications software on-line, and provides communications and controls the computer hardware.

Microsoft Word:  A step-by-step approach will be used to guide the student thru the concepts and techniques of WORD.  Students will be visually guided as they enter commands and master the tool.

Project 1 -- Creating, Editing, and Formatting a Document
Project 2 -- Creating a Resume

Microsoft Excel:  The ability to build and utilize spreadsheets is a valuable tool for several business and scientific applications.  A hands-on approach will enable students to plan, graph, and construct spreadsheets to solve business problems.

Project 1 -- Building a Spreadsheet.
Project 2 -- Formulas, Formatting and Creating a Chart
Project 3 -- Enhancing a Spreadsheet and Chart

Microsoft Access:  The student will be guided thru hands-on exercises to define a database, store information in the database and utilize the database to solve problems.  Through commands, the student will ask questions of the database and format the responses into useful reports.

Project 1 -- Creating a Database
Project 2 -- Querying a Database
Project 3 -- Maintaining a Database


Course Policies:

Attendance: You are expected to attend class. Any unexcused absence is considered excessive. If such absences reaches three or more the student will receive a half of a letter grade reduction for each absence beyond two. Attendance will be taken at the beginning of each class.

Note: The above syllabus is subject to change at the instructor's discretion.