SPRING 2003 Tuesdays/Thursdays 7:20 – 9:20 p.m. CRN 31644 YWCA - Harrisburg

DIVISION: Workforce and Economic Development Division

COURSE: Computer Information Systems - CIS 105

This course provides a fundamental understanding of computers and familiarizes students with the interaction of computer hardware and software. Emphasis is on the application of microcomputers and "hands on" use of software applications including word processing, spreadsheet, file and database management. A laboratory fee is required.

Advantage Computer Concepts; Microsoft Windows XP; Microsoft Word 2002, Brief Edition; Microsoft Excel 2002, Brief Edition; Microsoft Access 2002, Brief Edition; by Timothy J. O’Leary and Linda I. O’Leary; The McGraw Hill Companies, 2002

Upon successful completion of this course in word processing, electronic spreadsheet, and data base programs, the student will be able to:

• Identify and explain the purpose of the various computer components.
• Demonstrate fundamental operating skills with a microcomputer.
• Explain the functions and applications of the three major types of microcomputer applications programs.
• Explain the current development in and direction of the three major applications programs.
• Demonstrate a working competency with these three major applications programs.
• Discuss software applications for business.

COLLATERAL READING: Textbook and class handouts

• Introduction to Microcomputers
• Inside the Microcomputer System
• Input and Output Devices
• External Storage Devices
• Windows XP Fundamentals
• Basic Skills – access/use of Desktop components
• Organizing Your Work – File/Folder Management
• Word Processing - Word 2002
• Starting Word 2002
• Creating and Editing a Document
• Revising and Refining a Document
• Creating Reports and Tables
• Spreadsheets - Excel 2002
• Starting Excel 2002
• Creating and Editing a Worksheet
• Charting Worksheet Data
• Managing and Analyzing a Workbook
• Database - Access 2002
• Starting Access 2002
• Creating a Database
• Modifying a Table and Creating a Form
• Analyzing Tables and Creating Reports

METHODOLOGY: Hands-on exercises

Grades will be determined by the following measures:

1. Exams (Objective - ~31%) (Performance - ~46%)
2. Homework assignments - 11.5%
3. Quizes - 5%
4. Group Project - 6.5%

Exams:

• The objective portion (multiple choice) of each exam is worth 40 points. Each student will have a maximum of 25 minutes to complete the written portion and may NOT use any reference materials.
• The performance portion of each exam is worth 60 points. Each student will have a maximum of 50 minutes to complete the performance portion and may use any personal reference materials.

Homework Assignments:

• Homework assignments will be given out during the semester and graded.

Quiz:

• The written quizes will be given early in the course (during the second week) and will cover the fundamentals of the microcomputer and Windows XP theory.

Other (Project):

• You will have a group project to complete. This is a standard group project that us used throughout all CIS 105 classes at HACC. You will be given complete instructions on how to complete this assignment.

Each exam is worth 100 points. Each homework is worth 15 points. The quiz is worth 20 points. The group project is worth 25 points. The total points are 390 for this course.

ACADEMIC DISHONESTY:

Academic dishonesty is not tolerated and will be dealt with by the instructor. Penalties that may be imposed include but are not limited to:

• lowering of a grade or failure for a particular assignment;
• lowering of a grade, failure and/or dismissal from the course;
• disciplinary probation;
• suspension from the curriculum;
• suspension from the College for a period of one semester or more.

Details on the appropriate regulations can be found in the student handbook or in any office bay.

HARRISBURG AREA COMMUNITY COLLEGEATTENDANCE POLICY for the WORKFORCE AND ECONOMIC DEVELOPMENT DIVISION

The faculty of the Workforce and Economic Development Division is concerned with the total education of the individual and his/her future opportunities in business careers. Conceptual knowledge, skill, and proficiency are essential for successful business employment and effective citizenship. Equally important are the qualities of dependability and responsibility. Therefore, students are expected to attend all scheduled classes and are responsible for all class-related work and assignments. However, circumstances may cause a student to be absent from class on occasion; for example, illness, bad weather, accident, etc.

The determination of the attendance policy for each course is the prerogative of the instructor, as stated in the printed course syllabus, subject to the approval of the Division Administrator. Unexcused absence will be defined in each instructor's printed course syllabus which will be distributed to students during the first class meeting.

Students shall not be penalized for non-attendance in regularly scheduled classes, except as indicated below:

The student is responsible for attendance on the day of examinations, unless otherwise excused, and at classes that require regular physical presence and participation to meet the objectives of the course as stated in the printed course syllabus.

The student is responsible for all class work and assignments. Instructors will provide students who have excused absence the opportunity to make up missed reports and exams, and if feasible, participation, if an absence has been for valid reasons.

Students are subject to policies and procedures approved in Regulation 661 which is printed in the Student Handbook. Instructors requiring physical presence and participation may reduce course grades after the student has missed four unexcused class hours.

Instructors have the right to recommend to the Division Administrator that a student be dropped for an excessive absence that precludes the possibility of passing the class whereupon the student will be given a grade of "F" or "W". Excessive absence will <U>not</U> be considered to be fewer than six unexcused class hours.

Make up dates will be announced in class. Additional details will be provided by the Instructor.

SUGGESTED SCHEDULE FOR CIS 105 (Spring 2002)

January 28 Advantage Computer Concepts

January 30 MS Windows XP

February 4 Quiz & Group Project Introduction

February 6 Word 2002 - Unit 1

February 11 Word 2002 - Unit 1/Unit 2

February 13 Word 2002 - Unit 2/Unit 3

February 18 Word 2002 – Unit 3

February 20 EXAM - Word 2002 (Objective Portion) & Group Project

February 25 EXAM - Word 2002 (Practical Portion) WORD HOMEWORK DUE

February 27 Excel 2002 – Unit 1

March 4 Excel 2002 - Unit 1/Unit 2

March 6 Excel 2002 – Unit 2

March 11 Spring Break

March 13 Spring Break

March 18 Excel 2002 – Unit 3

March 20 Excel Unit 3

March 25 EXAM - Excel 2002 (Objective Portion) & Group Project

March 27 EXAM - Excel 2002 (Practical Portion) EXCEL HOMEWORK DUE

April 1 Access 2002 – Unit 1

April 3 Access 2002 – Unit 1

April 8 Access 2002 – Unit 2

April 10 Access 2002 – Unit 2

April 15 Access 2002 – Unit 3

April 17 Access 2002 – Unit 3

April 22 GROUP PROJECT

April 24 GROUP PROJECT

April 29 GROUP PROJECT

May 1 GROUP PROJECT DUE

May 6 EXAM - Access 2002 (Objective Portion)/P>

May 8 EXAM - Access 2002 (Practical Portion)/P>

May 8 ACCESS HOMEWORK DUE

LETTER GRADES:

A = 351 - 390 Points (90 - 100%)

B = 312 - 350 Points (80 - 89%)

C = 273 - 311 Points (70 - 79%)

D = 234 - 272 Points (60 - 69%)

F = 0 - 233 Points (0 - 59%)

To Calculate Grade: Divide total points earned by total possible points.

Example: 319/390 = .817 x 100 = 81.7% - Grade B

INSTRUCTOR: Glenn P. Hoffman

OFFICE LOCATION: Hall 125OFFICE HOURS: Prior to and after class and by appointment

REFUND DATES FOR THIS COURSE: ___________ ____________ __________