CIS 230-7501

Advanced Microcomputer Applications

3 Credit Hours

Instructor:            Chet Cunningham                       Semester:       Fall 2001

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

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

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

 

Office Hours:

Monday: 1:30 - 3:00 p.m. ; 5:00 - 6:00 p.m.

Tuesday & Thursday: 11:00 a.m – 12:00 p.m.

Wednesday: 10:00 a.m. - 12:00 p.m.

& others by appointment

 

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

Shelly, Cashman and Vermaat. Course Technology. 2000.

Microsoft Publisher 2000.  Complete Concepts and Techniques.

Shelly, Cashman and Starks. 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

  30

 

B

89 - 80 %

Office Integration Project

  40

 

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 and an unspecified number of quizzes will be given. No make-up exams will be allowed without prior arrangements being made. Make-up exams must be taken when scheduled. No quiz make-ups are allowed.

 

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 October 15, 2001. After October 15, 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

Fall 2001

 

Class Meeting

Reading Assignment
Laboratory Assignment

1

1. Course Introduction

 

2 & 3

1. Word Project 7

 

4 & 5

1. Word Project 8

4 – Word project 7 lab due

6 & 7

1. Word Project 9

6 – Word project 8 lab due

8

1. Excel Project 7 & Exam Review

Word project 9 lab due

9

Exam 1 – Word

 

10 & 11

1. Excel Project 8

10 – Excel project 7 lab due

12 & 13

1. Excel Project 9

2. Excel Web Feature

12 – Excel project 8 lab due

14

1. Access Project 7 & Exam Review

Excel project 9 lab due

15

Exam 2 – Excel

 

16 & 17

1. Access Project 8

16 – Access project 7 lab due

18 & 19

1. Access Project 9

2. Access Web Feature

18 – Access project 8 lab due

20

1. PowerPoint Project 5 & Exam Review

Access project 9 lab due

21

Exam 3 – Access

 

22 & 23

1. PowerPoint Project 6

22 – PP project 5 lab due

24

1. Publisher Project 1

PP project 6 lab due

25 & 26

1. Publisher Project 2

25 – Publisher project 1 lab due

27 & 28

1. Publisher Project 3

2. Prep for integration presentations

 

Final Exam

Integration Presentations