3 Credit Hours
Instructor: Chet Cunningham Semester: Spring 2002
Office: 261 JHG Lecture:
TR 8:00 9:15 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. Introductory
Concepts and Techniques.
Shelly, Cashman and Vermaat. Course Technology.
2000.
The
impact of computers on society, and ethical issues are presented. Students use
a microcomputer and application software, including word processing, database,
spreadsheets, and the Internet, to prepare elementary documents and reports.
Course Competencies
Upon completion of this
course the student can:
1.
Use a word-processing program to create, save, print, modify,
spell-check, and grammar-check a simple document.
2.
Use a word processing program to enhance the appearance of a simple
document by using centered, right-justified, boldfaced, underlined, and
italicized text.
3.
Use a word processing program to change the default margins and line
spacing.
4.
Use a word processing program to create a document with headers, footers,
and footnotes.
5.
Use an electronic spreadsheet to create, save, print, modify and obtain
graphs from a simple spreadsheet.
6.
Use an electronic spreadsheet to perform basic mathematical operations
including, but not limited to, addition, subtraction, multiplication, and
division.
7.
Use an electronic spreadsheet to calculate averages and percents.
8.
Use an electronic spreadsheet program to enhance the appearance of a
spreadsheet by changing fonts, foreground and background colors; and centering
text across columns.
9.
Use a database management program to create, maintain, and print reports
from a simple relational database.
10.
Use a database management program to customize the user interface by
creating and maintaining forms and reports.
11.
Use a database management program to query tables using basic query
operations such as and, or, not, etc.
12.
Print in landscape and portrait orientations.
13.
Use the component of the operating system that helps the user manipulate
files and folders to copy, move, rename, and delete files; and to create, copy,
move, rename, and delete folders.
14.
Use a World Wide Web browser to navigate hypertext documents and to
download files.
15.
Use Internet search engines and understand their advantages and
disadvantages.
16.
Use an electronic mail program to send and receive electronic mail.
17.
Discriminate between ethical and unethical uses of computers and
information.
18.
Demonstrate a basic understanding of issues regarding software copyright,
software licensing, and software copying.
19.
Demonstrate an awareness of computer viruses and a basic understanding of
ways to protect a computer from viruses.
20.
Demonstrate a basic understanding of the impact of computers on society.
21.
Use and understand basic computer terminology.
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
Basic typing skills.
Supplies
Two
3 ½ floppy disks. Each Student is required
to obtain an e-mail address for this course.
Grading
|
|
% of |
|
Grading Scale |
|
|
Announced examinations
(4) |
40 |
|
A |
90- 100% |
|
Laboratory and
out-of-class assignments |
55 |
|
B |
89 - 80 % |
|
Attendance/participation |
5 |
|
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 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:
Four 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 schools 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.
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.
Only
in extreme cases are children allowed in classroom or laboratory facilities,
and then only with approval of the instructor prior to class.
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: WFs 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.
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 100
Spring 2002
|
Class Meeting |
Reading Assignment |
Laboratory Assignment
|
|
1/15 |
1. Course Introduction |
|
|
1/17 & 1/22 |
1. Introduction to
Computers |
|
|
1/24 & 1/29 |
1. Introduction to Win
2000 & Office 2000 |
|
|
1/31 & 2/5 |
1. Word Project 1 |
1/31 Intro project lab
due |
|
2/7 & 2/12 |
1. Word Project 2 |
2/7 - Word project 1 lab
due |
|
2/14 & 2/19 |
1. Word Project 3 2. Word Web Feature |
2/14 - Word project 2 lab
due |
|
2/21 |
1. Excel Project 1 |
2/21 Word project 3 lab
due |
|
2/26 |
Exam 1 Word |
|
|
2/28 |
1. Finish Excel Project 1 |
|
|
3/5 & 3/7 |
1. Excel Project 2 |
3/5 Excel project 1 lab
due |
|
3/19 & 3/21 |
1. Excel Project 3 2. Excel Web Feature |
3/19 Excel project 2
lab due |
|
3/26 |
1. Access Project 1
|
3/26 - Excel project 3
lab due |
|
3/28 |
Exam 2 Excel
|
|
|
4/2 |
1. Finish Access
Project 1
|
|
|
4/4 & 4/9 |
1. Access Project 2 |
4/4 Access project 1
lab due |
|
4/11 & 4/16 |
1. Access Project 3 2. Access Web Feature |
4/11 Access project 2
lab due |
|
4/18 |
1. PowerPoint Project 1 |
4/18 - Access project 3
lab due |
|
4/23 |
Exam 3 Access |
|
|
4/25 & 5/2 |
1. PowerPoint Project 2 |
4/25 PP project 1 lab
due |
|
5/9 |
Comprehensive Final Exam |
5/9 PP project 2 lab due |