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.
• 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 and graphics.
• 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.
2. Explain the various uses of equipment, materials, software, and computers regarding effective information processing.
• 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 programs.
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

Grading:

• 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.

Course Policies:

• 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 of zero.
• 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 to apply.

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.