Microcomputer Software Applications I
Saint Augustine's College
Instructor: Albert L. Crawford
Office: Cheshire 118
Phone: (919) 516-4048
Office Hours: MWF 9:00 - 11:00
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
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.
Explain the various uses of equipment, materials, software, and computers
regarding effective information processing.
Identify basic hardware of a computer system. Explain what each component
does and why the component is essential to the successful to the operation
of the computer.
Identify specialized hardware components that may be needed for publishing
Identify operating system commands and the purpose for each command used.
Explain why information processing has become an integral part of management
development and business applications.
Identify the various information processing careers and describe the education,
training, and specific knowledge and skills are needed to perform these
jobs effectively and efficiently.
Demonstrate proficiency in using elegtronic input devices.
Exhibit interpersonal skills, work habits and attitudes that are accepted
in the business environment.
Identify the prodedural steps to be followed in investigating, designing,
and implementing an effective information processing system.
Identify and demonstrate steps in the information processing cycle, including
the inputting and processing of data, and outputing of information.
Identify specific activities included in each step of the cycle.
Demonstrate and/or illustrate wordprocessing, spreadsheets, dagtabase,
and graphics applications for information using both separate and integrated
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
Quizzes: There will be several in class quizzes given throughout
the semester. These will be weighted from 0 to 20 points each. These may
be either announced or unannounced. No makeups will be given for quizzes.
If you miss a quiz your grade will be zero for that quiz.
Exams: There will be two regular hour exams during the semester.
These exams will be weighted at 100 points each. These exams will
be in the computer classroom and will be taken on the computer. Students
will be expected to demonstrate a working knowledge of the concepts presented
in class. At least a portion of the exams will be open book.
Final: The final examination will be weighted at 150 points and
will cover the material from the entire course with the material from the
last third of the course being given the most weight.
Grades: All grades will be based on a 90, 80, 70, 60 percentage
of all points for grades of A, B, C, and D. Any "curves" that will be placed
on the grades will be made on the individual tests and not at the end of
the semester. Such curves are not likely.
Makeup of work: Should an absence be known ahead of time the student
should so inform the instructor and get his approval. This includes, but
is not limited to, scheduled school events.Work that is due during such
an absence should be turned in prior to the absence or sent to class with
a classmate. If an exam is scheduled during such an absence the student
must make arangements for the makeup at least a week prior to the exam
date and may be required to take the exam early.
Makeups for missed regular exams will not be given unless the reason
for the absence is determined by the instructor to be valid and necessary.
It is the students responsibility to make the reason for the absence known
to the instructor as soon as is reasonably possible.
Course Requirements: It is expected that all assignments be complete
and turned in on time. Late or incomplete assignments will be given a score
of -100% until they are completed. At that time they will be given a score
Cheating: I do not expect this paragraph to apply to anyone. However,
in the very unlikely event that a student is caught cheating please see
the student handbook for the penalties that the instructor has the authority
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