CIS 130

Microcomputer Applications

3 Credit Hours

Instructor:            Chet Cunningham                                   Semester:       Spring 2005

Office:                   261 JHG                                                Lecture:           Online

Office Phone:        (270) 824-8699                                      Room:              Online

Instructor E-mail: Chet.Cunningham@kctcs.edu                  Home Phone:  (270) 821-7909

Website:                http://www.madcc.kctcs.edu/ccunningham

 

Office Hours:

Tuesday & Thursday: 8:00 a.m – 9:00 a.m.

Tuesday & Thursday: 12:45 p.m – 2:15 p.m.

& others by appointment

 

Textbook: New Perspectives on Microsoft Office 2003 – Second Course.

Course Technology. 2004.

ISBN: 0-619-20659-4

 

Course Description

Students use a microcomputer and current word processing, database, spreadsheet and presentation software.  The requirements, capabilities, limitations and applications of these software packages are included.

 

Course Competencies

Upon completion of this course the student can:

1.       Use a word processing program to create, save, print, and modify documents including, but not limited to, several font styles and colors, text with borders, tables, images, sections, custom margins, custom tab settings, bullets, headers, footers, dropped capital letters, text art, and columns

2.       Use a word processing program to create, save, print and modify form letters and mailing labels

3.       Use a word processing program to address and print envelopes

4.       Use a word processing program to maintain a collection of records that can be used for mailing labels

5.       Use the macro language of a word processing program to automate repetitive tasks

6.       Use an electronic spreadsheet to create, maintain, and derive worksheets from templates

7.       Use an electronic spreadsheet to create and use multiple-page spreadsheets including, but not limited to, 3-D formulas and consolidation techniques

8.       Use an electronic spreadsheet to enhance the appearance of spreadsheets by adding text art, charts, clip  art, headers, footers, predefined formats, etc.

9.       Use an electronic spreadsheet’s macro language to automate repetitive tasks

10.   Use absolute and relative references in formulas and functions

11.   Use basic financial functions including, but not limited to, future value, present value, amortization schedules, and compound interest

12.   Use a database program to customize the user interface by designing custom reports, custom forms, and custom queries

13.   Use a database program to create multi-table relational databases including, but not limited to, databases       containing two or more related tables, fields containing OLE objects, fields containing URL’s, and databases containing customized user interface

14.   Use the database program’s macro language to automate repetitive tasks

15.   Use a query language to perform queries including, but not limited to, queries involving two or more related tables, update queries, delete queries, queries involving conditions that contain two or more logical operators, and queries containing calculated fields

16.   Create and use forms with sub-forms

17.   Use presentation software to create, maintain, and display presentations of varying degrees of complexity

 

Across the Curriculum Competencies

 

Writing Across the Curriculum:

To satisfy the new general education requirements of writing across the curriculum,

      "All faculty are expected to call attention to and penalize for errors in English usage and require the rewriting of papers which do not meet acceptable standards."  (CCS Rules, Section V, 2.32)

 

Writing: There will be exams, which will include questions that will require a written response. A written report may be required at the end of the semester.

Reading: Each homework assignment includes reading the appropriate section of the textbook as well as completing the assigned problems.

Integrated Learning: On exams, the students will be required to identify and solve problems that involve applying concept to particular situations.

Creative Thinking: On exams, students will be required to solve problems that integrating concepts to create appropriate processes.

Ethics/Values: All students are expected to comply with the MCC Code of Conduct. Plagiarism and cheating, as well as sanctions of these offenses, are defined in Article III of this Code.

 

Prerequisites

CIS 100 or Consent of Instructor

 

Online Prerequisites/Technical Requirements

 

  1. You must have access to a computer and the Internet.
  2. You must have access to Microsoft Office 2003 and SAM 2003 software.

 

Supplies

SAM 2003, Skills Assessment Manager software

 

The textbook and SAM 2003 software is available at the Madisonville Community College bookstore.  Their phone number is 270/821-2261.  The textbook and SAM 2003 software may be available at other college’s bookstores as well.

 

Grading

 


Course Grade


Points

 

Grading Scale

Grade

Points

Project Assignments (12)

 580

 

A

900 – 1000

Exams

 400

 

B

800 – 899

Discussion Board

   20

 

C

700 – 799

Total:

1000

 

D

600 – 699

 

 

 

F

Below 600

 

Instructional Methods

This course is an Internet course.  This means the majority of the work will be independent work.  This does not make the material any easier or require any less work than a class that meets regularly.

 

A combination of discussions, hands-on chapter labs, and exams will be utilized to help you gain proficiency in the application of computer concepts and principles.

 

There will be 4 discussion topics posted throughout the semester.  You are expected to respond to each topic at least once.  When you respond to each discussion topic, you will receive 5 points for a maximum of 20 points.

 

Hands-on Chapter Projects

You will be responsible for reading and understanding each assigned chapter.  Each assignment should be properly labeled with your name and exercise number.

 

Library Information

Library information can be found on the Internet at http://www.kctcs.edu/distancelearning/libraries.htm.

 

Program Help

For student registration and student login issues, contact KYVU at

Toll Free:  877-740-4357 or www.kyvu.org

 

Student instructions for activating KCTCS email accounts are available online at:  http://www.kctcs.edu/student/email.html

 

 

Course Policies

 

Examination Policy:

Four examinations will be given utilizing the SAM 2003 software. No make-up exams will be allowed without prior arrangements being made.  Make-up exams must be taken when scheduled.

 

Late Assignment Policy:

Laboratory assignments should be submitted prior to the specified due date/time.  The course management system being used for this online class states all times in Eastern Standard Time.  Therefore, if you are not in the Eastern Standard Time Zone, you will need to adjust your due time in accordance to the time zone you are in.  For example, if a student is in the Central Time Zone, they would have to submit their assignment one hour prior to the stated due time.  Laboratory assignments handed in after the due dates are considered late.  No assignments will be accepted late.

 

Cheating Policy:

Students are expected to uphold the school’s standard of conduct relating to academic honesty. Students assume full responsibility for the content and integrity of the academic work they submit. The guiding principle of academic integrity shall be that a student's submitted work; examinations, reports, and projects must be that of the student's own work. Students shall be guilty of violating the honor code if they:

 

1.       Represent the work of others as their own.

2.       Use or obtain unauthorized assistance in any academic work.

3.       Give unauthorized assistance to other students.

4.       Modify, without instructor approval, an examination, paper, record, or report for the purpose of obtaining additional credit.

5.       Misrepresent the content of submitted work.

 

The penalty for violating the honor code is severe. Any student violating the honor code is subject to receive a failing grade for the course and will be reported to the Office of Student Affairs. If a student is unclear about whether a particular situation may constitute an honor code violation, the student should meet with the instructor to discuss the situation.

 

For this class, it is permissible to assist classmates in general discussions of computing techniques. General advice and interaction are encouraged. Each person, however, must develop his or her own solutions to the assigned projects, assignments, and tasks. In other words, students may not "work together" on graded assignments. Such collaboration constitutes cheating. A student may not use or copy (by any means) another's work (or portions of it) and represent it as his/her own. If you need help on an assignment, contact your instructor, not other classmates.

 

Incomplete Policy:

Incompletes will only be considered in the most extreme cases of hardship.

 

Make-up Policy:

Make-up exams will be given ONLY in the most extreme cases of hardship or unavoidable interruption of participation. These are handled on an individual basis.

 

Student Conduct In Class Policy:

Any acts of classroom disruption that go beyond the normal rights of students to question and discuss with instructors the educational process relative to subject content will not be tolerated, in accordance with the Academic Code of Conduct described in the Student Handbook.  The Student Code of Conduct is available on the web at http://www.kctcs.edu/student/code.htm.

 

Withdrawal Policy:

The last day for a student to officially withdraw from class with a grade of "W" at his or her discretion is March 14, 2005. After March 14, the instructor’s signature is required to withdrawal.

 

Disabilities Policy

If you have a documented disability and need any type of accommodation, you are required to register with the Disability Resource Coordinator.  Contact Valerie Wolfe, Disability Resource Coordinator, Room 112 LRC, 270-824-1670.

 

 

This syllabus is tentative and subject to change at the discretion of the instructor to meet class needs.

 

Tentative Course Schedule

CIS 130

Spring 2005

 

Week

Assignment
Hands-on Projects

1

Getting to Know You

Getting to Know You Assignment

2

Word – Tutorial 5

Tutorial & Case #1

3

Word – Tutorial 6

Tutorial & Case #1

4

Word – Tutorial 7

Tutorial & Case #1

5

Word Exam

 

6

Excel – Tutorial 5

Tutorial & Case #1

7

Excel – Tutorial 6

Tutorial & Case #1

8

Excel – Tutorial 7

Tutorial & Case #1

3/7 – 3/11

Spring Break

 

9

Excel Exam (will be available during break)

 

10

Access – Tutorial 5 (will be available during break)

Tutorial & Case #1

11

Access – Tutorial 6

Tutorial & Case #1

12

Access – Tutorial 7

Tutorial & Case #1

13

Access Exam

 

14

PowerPoint – Tutorial 3

Tutorial & Case #1

15

PowerPoint – Tutorial 4

Tutorial & Case #1

16

PowerPoint Exam (Last Day of Class)

 

            * All due dates will be posted under the Assignments link on the course web site.