1. Instructor Information:
a. Name Mr. Charles Kwiatkowski
b. E-mail address charles_kwiatkowski@ivcc.edu
c. Office hours Monday By
Appointment Only
Tuesday 4:00-7:00
Wednesday 3:00-6:00
Thursday 4:00-5:30
Friday By Appointment Only
d. Contact information Charles Kwiatkowski
A
Building, Room 330
IVCC
815
North Orlando Smith Road
Oglesby,
IL 61348
+1
(815) 408 0876
Course
description
This
comprehensive course in Access teaches the student basic concepts and continues
through advanced database topics. Students will use Access to create and
maintain databases, queries, SQL's and database relationships will be covered.
Students will also create mailing labels, input masks, validation rules, and
work with forms.
Prerequisite: None
Credit Hours: 3
2. Course Meeting Times
None.
This is independent study.
3. Expected learning outcomes
·
Student
will be able to create and manipulate records and fields
·
Student
will be able to create and link tables of related information together in a
single database.
·
Student
will understand what a query is, and how to form queries.
·
Student
will be able to create neat, professional looking reports.
Students
will be able to create neat, professional looking forms.
·
Student
will understand simple SQL statements and how to write them.
4. Disability statement :
a. If you need support or assistance
because of a disability, you may be eligible for academic assistance
accommodations through the Disability Services office. Stop by office B-204 or call Tina
815.224.0284 or Judy 815.224.0350.
5. Attendance Policy
This
is an independent study class. However, assignments must be completed by the
designated due date.
6. Assessment of student learning.
Students
are assessed by homework, a midterm exam, and a final exam.
7. Grading: All work will be done with myITlab. The grading of the course will fall into 3
categories:
Homework
This
is where you will develop and apply your knowledge relevant to the topic. There
shall be 1 homework per chapter. Each homework will consist of a pre-test,
training questions, and a post-test. I only care about your post-test grade.
Training is adaptive so you only get training on the questions you get wrong on
the pre-test. This saves you time. There shall be 12 Homeworks,
each is worth 100 points.
Midterm
exam
Based on the myITlab
exercises in Chapters 1-6. You will need to complete the exam in the Assessment
Center. The midterm exam is worth 200 points.
Final
Exam
Based on the myITlab
exercises in Chapters 1-6. You will need to complete the exam in the Assessment
Center. The final exam is worth 200 points.
Final
grade by percentage of possible points
90-100%
A
80-89%
B
70-79%
C
60-69%
D
<
60% F
Note:
Grades are not rounded up or down. Example: if you end up with an overall
course grade of 89.99%, you have earned a B.
8. Withdrawal policy
According
to IVCC, you may withdraw from this course with instructor permission.
You
may withdraw from this course for any reason you like. I shall not shame you
nor chide you for dropping the course, but I may inquire why. The only
exception for this rule shall be for people who have left their lab partner
"hanging". This applies only to classes with labs. See your course
specific info for more detail or ask me for clarification.
Note:
Just because you stop working on this class does not grant you a grade of I
(incomplete) or W (withdrawn). You must promptly contact me in order to receive
a grade of I or W.
For
Spring 2010:
Tuesday,
August 31 is the last day for refund.
Tuesday
November 9 is the Last Day for Student Withdrawal
Personal
advice: Education is not a race. There is no shame in strategic retreat. Drop
the class in which you are performing the worst in, not the one you like the
least. Always aim to keep your grade point average high as it will take you farther
than how long it took you to complete your degree/certificate/program.
9. Cell phone and text messaging policy.
Calculators,
PDA's, Cell Phones, laptops, iPods, and other electronic devices are not
allowed during exams and quizzes unless otherwise specified. failure to comply
with these rules will result in ejection from the exam and a grade of F for the
exam.
10. Financial aid statement
Withdrawal
from a course can affect financial aid.
Students who receive financial aid should see an advisor in the financial
Aid Office before withdrawing from a course.
11. Plagiarism statement/academic honesty
Policies
regarding cheating may be found under the heading of “Academic Integrity” in
the IVCC Student Handbook. Students should become familiar with these
policies and abide by them.
Furthermore,
don't even think about cheating. Cheating is not tolerated at all.
Although I encourage you to collaborate and discuss ideas and concepts from
this class with others, you are responsible for your own work. A (all too) common
example of cheating is to work together collectively in a group and each member
turns in his/her copy of the same document. This is completely unacceptable.
When
you cheat, you insult my intelligence.
12. Any classroom rules
None.
This is an independent study class.
Three
strikes
If
you have 3 unexcused absences of any combination class activity, (HW, quiz,
lecture, etc.) your course grade becomes F. Just because you stop showing up
for class does not grant you a grade of I (incomplete) or W (withdrawn). You
must promptly contact me in order to receive a grade of I or W.
13. Outline of assignments for the
semester
There shall be approximately 12
assignments, 1 per chapter.
Each chapter's assignment shall
contain:
·
a
pre-test section, which gives you hands on problems. This must be completed,
but does not count towards your grade as it is only practice.
·
a
training section, which gives further instructions on questions you missed on
the pre-test. This must be completed, but does not count towards your grade as
it is only practice.
·
a
post-test section, which is counted towards your grade.
14. Any hints on how to be successful in
the course
Most
questions allow 3 attempts. If you get it wrong, pay close attention to WHAT STEP
you get wrong. Often times, there is more than one way to accomplish a task BUT
myITlab is looking for a specific way. DO NOT AUTOMATICALLY
REPEAT THE SAME ACTIONS IF YOU GET A QUESTION WRONG. PAY CAREFUL ATTENTION TO THE
MESSAGES FROM MYITLAB!
15. Required text and materials
Textbook
GO!
with Access 2007 Comprehensive
Shelly
Gaskin
ISBN-10: 0132327627
ISBN-13: 9780132327626
16. Additional Resources
ISBN
013509383X PRENTICE H MIL SACC GRADER
2010 01
This should be bundled with your textbook from the IVCC bookstore.
Headset
(for listening to training)
17. Topic Schedule
This
schedule is tentative and subject to change.
|
Due Date |
Assignment Topic(s) |
|
Monday, August 30, 2010 |
Getting Started with myITlab |
|
Monday, September 06, 2010 |
Chapter 1 |
|
Monday, September 13, 2010 |
Chapter 2 |
|
Monday, September 20, 2010 |
Chapter3 |
|
Monday, September 27, 2010 |
Chapter 4 |
|
Monday, October 04, 2010 |
Chapter 5 |
|
Monday, October 11, 2010 |
Chapter 6 |
|
Monday, October 18, 2010 |
Midterm Exam |
|
Monday, October 25, 2010 |
Chapter 7 |
|
Monday, November 01, 2010 |
Chapter 8 |
|
Monday, November 08, 2010 |
Chapter 9 |
|
Monday, November 15, 2010 |
Chapter 10 |
|
Monday, November 22, 2010 |
Chapter 11 |
|
Monday, November 29, 2010 |
Take Thanksgiving Week |
|
Monday, December 06, 2010 |
Chapter 12 |
|
Monday, December 13, 2010 |
Final Exam |