CIS 209 / Computer
Applications II
Instructor: Laurie Pewitt
Office:
Web Site: http://lpewitt2.columbiastate.edu
E-mail: Laurie.Pewitt@Columbiastate.edu
Office Hours: Posted on door and on Web site. Appointments are highly suggested.
Required Materials:
Microsoft Office 2003: Introductory Concepts and Techniques by Shelly, Cashman, and Vermaat
Microsoft Office 2003: Advanced Concepts and Techniques by Shelly, Cashman, and Vermaat
Flash drive
Course Description:
This course uses commercial software to develop advanced skills in spreadsheets and database management. (Prerequisites: DSPM 0800 or Satisfactory Placement Scores in Math and CIS 109)
Instructional
Methods:
Class Lectures will introduce the student to microcomputers and facilitate the understanding of how microcomputers operate and are used.
Lab assignments provide the student with hands-on experience using the microcomputer hardware and software.
Class discussions and online discussions involve the student in the discussion of various topics relating to computers and their impact on society.
Consultations with the instructor allow an additional opportunity for the student to clarify the course material and to review his/her grades.
Course Objectives:
1. Understand and appropriately utilize advanced Windows terminology and related procedures;
2. Properly solve advanced application problems including:
a. Using Excel 2003 to create, modify, and store spreadsheets such as reports, analysis models, and budgets. Students will learn the algebraic rules of formula construction for use in spreadsheet applications.
b. Using Access 2003 to create, modify, and store databases. You will learn to perform queries, edit, add, and delete records using forms and datasheets, construct validation rules for data entry accuracy, sort records, and construct reports.
3. Understand and perform advanced file and disk management procedures using the Explorer program and the Windows applications studied in the course.
Your Responsibilities:
1. Permit only one person to speak at a time and raise your hand to be recognized in class
2. Treat all students and faculty with the utmost in respect and professionalism
3. Read the text and other assigned reading material as instructed
4. Complete assignments according to both written and oral instructions. Specific details for each assignment will be provided throughout the term
5. Work independently on all assignments unless instructed otherwise and meet the deadlines for completing and submitting all work
6. Take all exams
7. Check e-mail frequently
Policies:
1. Please notify me at the first class period if any special accommodations that fall under the Americans with Disabilities Act are required.
2. Students not attending class on time will be counted as late. If you are late 3 times, it will count as an absence.
3. Exams can not be made up: however, if an exam is missed, the grade made on the Final Exam will be substituted for the missed exam. No more than one exam may be missed.
4. Class assignments must be turned in at the beginning of class on the day the assignment is due. There will be a 24 hour grace period during which assignments may be accepted, but there will be an automatic 20% grade reduction. Assignments turned in after 24 hours will receive the grade of zero.
5. The Final Exam must be taken and must be taken at the scheduled time. Failure to take the final exam will result in an F for the course
6. Each student is responsible for all material distributed or discussed in class and for all assignments. Absences do not constitute an exception to this policy.
7. Other policies of CoSCC are contained in the College Catalog under “Standards and Regulations” and should be reviewed by the student on matters not specifically covered by this syllabus.
Course Evaluation:
2 Exams @ 200 points each = 400 points
18 Projects/Lab assignments @ 20 points = 360 points
Total 760 points
Grading Structure:
A = 760 - 681
B = 680 - 605
C = 604 - 529
D = 528 - 453
F = 452 - 0
Exams:
There will be two exams requiring a student to demonstrate their competence with the concepts and application software taught in this course. Students may be expected to complete specified tasks using a personal computer within a certain period of time and submitted via e-mail. No make-up exams will be given. Exams may be taken early if the situation so warrants.
Attendance:
Roll is taken at the start of class. Class attendance is mandatory. Regardless to the cause or nature of an absence, students are responsible for all class work covered or assigned during the absence. Class work is still expected on time. Each absence reduces the overall final grade by 1 point. If you are late 3 times, it counts as an absence. If the absence cannot be helped because of a valid reason (sick or death in the immediate family) a note is required for the absence to be excused and not reduce your final grade. You have one free absence.
Important Dates:
March 5 – 9 - Spring Break
March 29 – Last day to drop
April 6 – Good Friday
April 30 – Class Ends
May 6 – Final Exam at 8am
Learning
Disabilities:
If you have a learning disability that may require
assistance or accommodations, or you have questions related to any
accommodation for testing, note takers, readers, etc., please speak with me as
soon as possible. Students needing special assistance are also required to
contact the Counseling and
Electronic Devices:
Cellular phones and pagers and other electronic devices are NOT allowed in the classroom. They need to be turned OFF.
Internet Usage:
The use of the Internet is permitted for class related purposes only.
In compliance with the American
with Disabilities Act, students are encouraged to register with the office of
Counseling/Disability Services for possible assistance with
accommodations. It is the student's responsibility to voluntarily and
confidentially provide appropriate documentation regarding the nature and
extent of a disability. Students requesting special accommodation are
(strongly) encouraged to contact the office of Counseling/Disability Services
at the beginning of the semester.
Web for Students
Students should use Web for
Students to access their final grades at the end of the semester.
Emergency Evacuation
In the event of an emergency,
students should follow faculty’s instructions and reference the college's
Emergency Procedures guide, which is posted in all classrooms.
Changes to the
Syllabus:
I reserve the right to modify this syllabus as necessary.