CIS 230

Advanced Microcomputer Applications

3 Credit Hours

Instructor:            Chet Cunningham                       Semester:       Spring 2002

Office:                    261 JHG                                     Lecture:          TR 9:30 – 10:45 a.m.

Office Phone:         (270) 824-8699                          Room:              248 JHG

Instructor E-mail:  chet.cunningham@kctcs.net       Home Phone:   (270) 821-7909

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

 

 

Office Hours:

Tuesday & Thursday: 1:30 p.m – 3:00 p.m.

Wednesday: 9:00 a.m. - 11:00 a.m.

& others by appointment

 

Textbook: Microsoft Office 2000. Post-Advanced Concepts and Techniques.

Shelly, Cashman and Vermaat. Course Technology. 2000.

 

Course Description

Students use advanced functions of current software packages (word processing, spreadsheets, database management, presentation developers). Topics include working with complex documents, spreadsheets, and databases.  Additionally, students will create sophisticated presentations and prepare data for distribution on the Web.

 

Course Competencies

Upon completion of this course the student can:

  1. Use a word processing program to create an index and a table of contents for a document.
  2. Use a word processing program to apply advanced formatting to a document.
  3. Use a word processing program to create on-line forms.
  4. Use a word processing program to create and edit templates.
  5. Use an electronic spreadsheet to solve complex business problems.
  6. Automate data entry in spreadsheets.
  7. Use advanced features such as data validation, solver, data mapping, goal seek, auditing tools, and scenario manager in an electronic spreadsheet.
  8. Use an electronic spreadsheet to create and edit complex charts including pivot charts and pivot tables.
  9. Use the data management feature of spreadsheets to manipulate and extract data.
  10. Use a database to create and edit multilevel reports.
  11. Use a database to create calculated fields in reports and queries.
  12. Use a database to define and edit relationships.
  13. Use a database to replicate data.
  14. Use a database to modify table design.
  15. Use a database to create and modify forms.
  16. Use a database to demonstrate data integrity and security features.
  17. Create and modify presentations with animation effects.
  18. Prepare presentations for distribution to remote audiences.
  19. Use the capabilities of each software type to prepare a document for placement on the Web.
  20. Integrate software by importing and exporting data between applications and by linking data between applications.
  21. Customize the working environment of applications.

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 - Introduction to Computers

CIS 130 - Microcomputer Applications

 

Supplies

Two 3 ½” floppy disks.  Each student is required to obtain an e-mail address for this course.

 

Grading

 


Course Grade

% of
Grade

 

Grading Scale

Announced examinations (3)

  30

 

A

90- 100%

Laboratory and out-of-class assignments

  50

 

B

89 - 80 %

Office Integration Project

  20

 

C

79 - 70 %

Total:

100%

 

D

69 - 60 %

 

 

 

F

Below 60%

 

Instructional Methods

A combination of classroom lectures/discussions, hands-on chapter practices, chapter tests, and end of chapter exercises will be utilized to help you gain proficiency in the application of computer concepts and principles.

 

Hands-on Chapter Projects

You will be responsible for reading and understanding each assigned chapter. Additionally, most students will have to spend time outside of class to complete hands on projects. Each assignment should be properly labeled.

 

Make sure your name, student ID, and exercise number appear in the upper-left corner. If an exercise has multiple sheets, then staple them together. Do not staple different assignments together. Disorganized assignments (pages out of order, mislabeled, unreadable, etc.) will receive a grade of zero. If there are multiple sheets are to be handed in, then sequence them according to the order you were told to print them in the exercise.

Course Policies

 

Hands-on Classroom Rules:

This class will be held in a computer classroom and the following rules must be understood and followed:

 

1.       NO FOOD OR DRINK ALLOWED IN THE CLASSROOM AT ANYTIME!!!!!!

2.       Please arrive on time and expect to stay the entire class period.

3.       Please do not use your computer during class discussions unless told to do so.

4.       Turn in your assignments on time! Use the class time wisely. If you miss class, it is your responsibility to get your assignments done outside of class. However, excessive classroom assignments done outside of class will not be evaluated.

5.       Please pay attention during class instructions and demonstrations.

6.       Unless directed otherwise, use the same computer each class.

7.       Use courtesy when using the printer, it is shared.

8.       If you have questions please ask the instructor instead of disturbing your neighbor.

 

Examination Policy:

Three announced examinations will be given. 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 handed in immediately BEFORE lecture begins on the specified due date. Laboratory assignments handed in after lecture begins are considered late.  No assignments will be accepted more than one week late. Late assignments receive a 50% penalty.

 

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.

 

Children In Class Policy:

Only in extreme cases are children allowed in classroom or laboratory facilities, and then only with approval of the instructor prior to class.

 

Electronic Devices In Class Policy:

Cellular phones, pagers, CD players, radios, and similar devices are prohibited in the classroom and laboratory facilities. Calculators and computers are prohibited during examinations and quizzes, unless specified. Reasonable laptop-size computers may be used in lecture for the purpose of taking notes.

 

Attendance Policy:

Attendance is strongly recommended. Good attendance will translate into better grades, higher retention of subject matter, greater success. Since much of the work is done in class under the supervision of the instructor, poor attendance will usually translate into poor grades.

 

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 11, 2002. After March 11, the instructor may grant a W, WP, or WF.  Note: WF’s are averaged into you GPA the same as an F.

 

Inclement Weather Policy:

In cases of inclement weather please listen to area radio and television stations for cancellations.

 

Disabilities Policy

Any student requiring individualized classroom accommodations due to a disability should schedule a conference with the Disability Resource Coordinator (Valerie Wolfe, Room 112 LRC) at your earliest convenience.

 

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

 

Tentative Course Schedule

CIS 230

Spring 2002

 

Class Meeting

Reading Assignment
Laboratory Assignment

1/15

1. Course Introduction

 

1/17 & 1/22

1. Word Project 7

 

1/24 & 1/29

1. Word Project 8

1/24 – Word project 7 lab due

1/31 & 2/5

1. Word Project 9

1/31 – Word project 8 lab due

2/7

1. Excel Project 7 & Exam Review

2/7 - Word project 9 lab due

2/12

Exam 1 – Word

 

2/14

1. Finish Excel Project 7

 

2/19 & 2/21

1. Excel Project 8

2/19 – Excel project 7 lab due

2/26 & 2/28

1. Excel Project 9

2. Excel Web Feature

2/26 – Excel project 8 lab due

3/5

1. Access Project 7 & Exam Review

3/5 - Excel project 9 lab due

3/7

Exam 2 – Excel

 

3/19

1. Finish Access Project 7

 

3/21 & 3/26

1. Access Project 8

3/21 – Access project 7 lab due

3/28

Lab Day

 

4/2 & 4/4

1. Access Project 9

2. Access Web Feature

4/2 – Access project 8 lab due

4/9

1. PowerPoint Project 5 & Exam Review

4/9 - Access project 9 lab due

4/11

Exam 3 – Access

 

4/16

1. Finish PowerPoint Project 5

 

4/18 & 4/23

1. PowerPoint Project 6

4/18 – PP project 5 lab due

4/25

Lab Day

4/25 - PP project 6 lab due

4/29 & 5/2

Prep for integration presentations

 

5/9

Final Exam - Integration Presentations