CIS 130
3 Credit Hours
Instructor: Chet Cunningham Semester: Fall 2009
Office: 261 JHG Lecture: Online
Office Phone: (270) 824-8699 Room: Online
Instructor E-mail: Chet.Cunningham@kctcs.edu Home Phone: (270) 884-7540
Website: www.madisonville.kctcs.edu/ccunningham
|
Office Hours: |
|
Monday & Wednesday: 12:00 p.m. – 1:00 p.m. |
|
Tuesday & Thursday: 9:30 a.m. – 10:30 a.m. |
|
& others by appointment |
Textbook: Exploring Microsoft Office 2007. Volume 2.
Grauer. Pearson.
2007.
ISBN: 0-13-613037-2
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)
General Education Competencies:
I. Communicate
Effectively
1. Read with comprehension.
Assessment:
Complete comprehensive Word, Excel, Access, and PowerPoint projects after
reading the text.
2. Interact cooperatively with others using
both verbal and non-verbal means.
a. Students will communicate with instructor
and other students via e-mail and required discussion board assignments.
Assessment:
Student will be graded on required discussion board posts.
Assessment:
Complete comprehensive Word, Excel, Access, and PowerPoint projects after reading
the text.
II. Think Critically
1. Demonstrate problem solving through
interpreting, analyzing, summarizing, and/or integrating a variety of
materials.
a. Students will demonstrate problem solving skills by
successfully completing the assignments.
Assessment:
Complete comprehensive Word, Excel, Access, and PowerPoint projects after
reading the text.
III. Learn Independently
1. Apply learning in academic, personal, and public situations.
a. Students will apply learning and be expected to work
and learn independently using appropriate resources in this online environment.
Assessment:
Apply all acquired skills when constructing required materials for other
courses, for self, or in career situations.
Prerequisites
CIS 100 or Consent of Instructor
Online
Prerequisites/Technical Requirements
Supplies
myITLab software
The textbook and myITLab software is available at the
Grading
|
|
|
|
Grading
Scale |
|
|
Grade |
Points |
|||
|
Project Assignments (13) |
630 |
|
A |
945 – 1050 |
|
Exams |
400 |
|
B |
840 – 944 |
|
Discussion
Board |
20 |
|
C |
735 – 840 |
|
Total: |
1050 |
|
D
|
630 – 720 |
|
|
|
|
F |
Below 630 |
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 myITLab 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 cannot be submitted
after the due date/time. 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.
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 October 19. After this date, it is up to the instructor’s
discretion to grant a “W”.
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 139 JHG, 270-824-1708.
Students with documented disabilities that require individualized
accommodations should do two things: contact the Disability Resource
Coordinator at their
This syllabus is tentative and subject to change at the
discretion of the instructor to meet class needs.
Tentative Course Schedule
CIS 130
Fall 2009
|
Due Date |
Assignment |
Hands-on Projects
|
|
8/27 |
Getting
to Know You |
Getting
to Know You Assignment |
|
9/3 |
Word
– Chapter 6 |
Hands-On
Exercises & Capstone Exercise |
|
9/10 |
Word
– Chapter 7 |
Hands-On
Exercises & Capstone Exercise |
|
9/17 |
Word Exam Excel
– Chapter 5 |
Hands-On
Exercises & Capstone Exercise |
|
9/24 |
Excel
– Chapter 6 |
Hands-On
Exercises & Capstone Exercise |
|
10/1 |
Excel
– Chapter 7 |
Hands-On
Exercises & Capstone Exercise |
|
10/22 |
Excel Exam Access
– Chapter 6 |
Hands-On
Exercises & Capstone Exercise |
|
11/5 |
Access
– Chapter 7 |
Hands-On
Exercises & Capstone Exercise |
|
11/12 |
Access
– Chapter 9 |
Hands-On
Exercises & Capstone Exercise |
|
11/19 |
Access Exam PowerPoint
– Chapter 5 |
Hands-On
Exercises & Capstone Exercise |
|
12/3 |
PowerPoint
– Chapter 6 |
Hands-On
Exercises & Capstone Exercise |
|
12/8 |
PowerPoint
– Chapter 7 PowerPoint Exam (Last Day of Class) |
Hands-On
Exercises & Capstone Exercise |
* All assignments will be available about a week
before they are due