Site hosted by Angelfire.com: Build your free website today!

INTRODUCTION TO MICROCOMPUTER SOFTWARE FOR BUSINESS
CIS 105
COURSE SYLLABUS
FALL 2000


DIVISION: Workforce and Economic Development Division

COURSE: Computer Information Systems 105 - Introduction to Microcomputer Software for Business - 3 Credits

CATALOG DESCRIPTION: 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.

TEXTS: Advantage Computer Concepts, Simply Microsoft Windows 95, Microsoft Word 97 For Windows, Microsoft Excel 97 for Windows, Microsoft Access 97 For Windows; by Hutchinson and Coulthard; The McGraw Hill Companies, 1997

SUPPLEMENTAL: A sufficient number of disks for assignments and back up purposes

OBJECTIVES: 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

    TOPICAL OUTLINE


  • Introduction to Microcomputers
    1. Inside the Microcomputer System
    2. Input and Output Devices
    3. External Storage Devices
  • Windows 95 Fundamentals
    1. Introduction to Screen Components
    2. Executing Tasks and Getting Help
    3. Introduction to My Computer
    4. Managing Disks and Files
  • Word Processing - Word 97
    1. Starting Word 97
    2. Entering, Editing, and Selecting Text
    3. Getting Help
    4. Character and Paragraph Formatting
    5. Editing and Proofing Tools
    6. Printing
    7. Document Management
  • Spreadsheets - Excel 97
  • Starting Excel 97
  • Entering and Editing Text and Numbers
  • Getting Help
  • Cells (ranges, references, copying, adjusting, formatting)
  • Printing
  • Working with Functions
  • Charts (creating, moving, sizing, deleting, embedding, printing)
  • Database - Access 97
  • Starting Access 97
  • Opening A Database
  • Manipulating Table Data
  • Getting Help
  • Printing
  • Queries (creating, criteria, calculations)
  • Creating Reports
    METHODOLOGY:

  • Hands-on exercises
  • Lecture
  • Overheads
  • Technology devices
  • Class participation

    COURSE REQUIREMENTS:

    Grades will be determined by the following measures:
  • Exams (Objective - 38.5%) (Performance - 38.5%);
  • Homework assignments - 11.5%;
  • Quiz - 5%;
  • Other - 6.5%.

    Exams:

    The objective portion (multiple choice) of each exam is worth 50 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 50 points. Each student will have a maximum of 50 minutes to complete the performance portion and may use any personal reference materials.

  • Exam 1 Word Processing and Windows 95
  • Exam 2 Spreadsheet and Windows 95
  • Exam 3 Database and Windows 95 (given during Finals week)

    Homework Assignments

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

    Quiz

    The written quiz will be given early in the course and will cover the fundamentals of the microcomputer and some portions of Windows 95 theory.

    Other

    Each instructor will determine how these points will be earned.

    GRADING SYSTEM:
    EXAMS
    		 POINTS TOTAL
    Word/Windows 95100
    Excel/Windows 95100
    Access/Windows 95100
    300
    HOMEWORK ASSIGNMENTS
    Word 9715
    Excel 9715
    Access 97>15
    45
    QUIZ
    Microcomputers and Windows 9520 20
    OTHER
    To be assigned by Instructor25 25
    TOTAL390


    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 COLLEGE ATTENDANCE 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 not 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 (Fall 1999)

    WEEKACTIVITY
    (NOTE: The letter S stands for Session)
    1Advantage Computer Concepts, Simply Windows 95 (S1 -- Fundamentals; What is Windows 95, Features of Windows 95, The Windows 95 Advantage, Working With Windows 95, Loading Windows 95, Executing Tasks, Switching Tasks, Manipulating Windows and Icons - pages 2 - 28); Simply Windows 95 (S3 -- Managing Files and Disks; What is File Management, What is Disk Management, File-and Disk-Naming Conventions)
    2Quiz; Simply Windows 95 (S3 -Using “My Computer” to Manage Files, Using “My Computer” To Manage Disks and Folders, Using Windows Explorer - pages 76 - 104); Word 97 (S1 -- Fundamentals; pages 2 - 41); Word 97 (S2 -- Character and Paragraph Formatting; pages 50 - 90)
    3 & 4Word 97 (S3 -- Editing and Proofing Tools; pages 100 - 120); (S4 -- Printing and Document Management; pages 130 - 164)
    5Word 97 (S4 -- concluded)
    6EXAM; Excel 97 (S1 -- Fundamentals; pages 2 - 40)
    7 & 8Excel 97 (S2 -- Working with Spreadsheets; pages 52 - 87); Excel 97 (S3 -- increasing Your Productivity; pages 96 - 116)
    9Excel 97 (S5 -- Creating Charts; pages 174 - 203)
    10EXAM
    11 & 12Access 97 (S1 -- Fundamentals; pages 2 - 40); (S2 -- Working With Tables; pages 48 - 91; skip Defining and Removing Indexes, pages 63-64; skip More On Creating Tables, pages 83-87)
    13 & 14Access 97 (S3-Retrieving Information; p100-135; skip Using Filters (p. 106-111) and Querying Multiple Tables, 131-134); Access 97 (S4 -- Presenting Your Data; pp 142 - 172; do only Creating New Report, pp 143-152)
    15Access 97 concluded
    16EXAM: Finals Week


    LETTER GRADES:PointsPercentage
    A351 - 390 Points90 - 100%
    B312 - 350 Points80 - 89%
    C273 - 311 Points70 - 79%
    D234 - 272 Points60 - 69%
    F0 - 233 Points0 - 59%


    To Calculate Grade: Divide total points earned by total possible points. Example: 319/390 = .817 x 100 = 81.7% Grade B

    Grade Sheet for CIS 105

    1. ___________ Microcomputers and Windows Quiz

    2. ___________ Word Homework

    3. ___________ Word Exam

    4. ___________ Excel Homework

    5. ___________ Excel Exam

    6. ___________ Access Homework

    7. ___________ Access Exam

    8. ___________ Other


    INSTRUCTOR: Glenn P. Hoffman
    OFFICE LOCATION: Off Campus (Hall 125)
    OFFICE HOURS: Prior to and after class and by appointment

    REFUND DATES FOR THIS COURSE: