| Instructor
Information: |
|
|
Textbook: |
|
| Microsoft Office
Access
2007 (Author:
Adamski, Finnegan; Publisher:
Course Technology; ISBN:
978-1-4239-0569-9)
This course covers tutorial 1-5.
|
| Prerequisite: |
Working Knowledge of Windows. |
| Course Description: |
This course introduces database concepts and techniques to users and
designers of database systems using Access. .
Topics include relational database concepts, building and
customizing tables, creating queries, and constructing basic forms and
reports. |
| Class
Policies: |
|
Quizzes |
|
There will be five in-class quizzes. No
make-up quizzes will be given unless an arrangement is made
PRIOR to the time of the quiz. |
|
In-Class Assignments |
|
These assignments will be done in class and checked
by the instructor in class. If you have to miss a class, you
will need to make up the work on your own and submit the file to
Desire2Learn. |
|
Take-Home Assignments |
|
There will be a take-home assignment after each Tutorial which
will be finished outside of the class. No
late assignments will be accepted in this class. To provide some
flexibility in your schedule, each student is allowed to submit
one assignment late for the entire semester. |
|
Incomplete: |
|
To receive an
"Incomplete", you must have completed at least 75% of
the required work unless you have a documented medical
condition. It is your responsibility to provide a written request
for the "Incomplete". |
Grade
Book Keeping:
Your
grades will be kept at D2L course site. You can check your
grades anytime during the semester. If you have disputes regarding
the score of a specific item, you must talk to the instructor
within two weeks from the time the score becomes available at
D2L. |
|
The "W" grade:
|
If you have
decided not to participate in this class during the semester, it is
important that you officially withdraw from the class at the registration
office. Otherwise, your grade for this class will be F on your
transcript. The last day to withdraw from this class for the "W" grade is
November 25th.2009.
|
|
| Grading: |
Your
final grade will be determined based on the total points you earn on the quizzes, in-class assignments, take-home assignments, and
three exams.
- In-class assignments: This is the result of following
the tutorial in the book. I will walk you through the steps in
class.
- Take-home assignments: You will be asked to create
Word files using the skills you have learnt in class. You will
need to figure out the steps on your own.
- Quizzes: A quiz will be given after each tutorial. Each quiz contains 20 multiple choice questions. All quizzes are closed book.
- Final Exam: This exam contains projects similar to your take home
assignments.
In general, 91-100% guarantees
an A, 81-90.9% for B, 71-80.9% for C, 61-70.9% for D, and a
percentage below 61% is an F.
| Category |
Number
of Units |
Points |
Percentage
(approximate) |
| Points
per Unit |
Category
Total |
|
Quizzes |
5 |
20 |
100 |
29% |
|
In-Class Assignments |
6 |
5 |
30 |
9% |
|
Assignments |
6 |
20 |
120 |
18% |
|
Final Exam |
1 |
100 |
100 |
44% |
| Total |
|
|
350 |
100% |
|
|
|
|
Special Needs: |
Students
with special needs should contact me or the Disability Services Office
located at L-224 (phone, 651/450-8628; TTY, 651/450-8369). |
Tentative Calendar: |
| Dates (Tuesday) |
Class Contents |
|
8/25 |
-
Syllabus
- IHCC Network Account
- Desire2Learn
- Managing Your Files and Office 2007
|
|
9/1 |
- Tutorial #1: Creating a Database
- Take-Home Assignment #1 due 9/7
|
|
9/9 |
- Quiz #1
- Tutorial #2: Building a Database and Defining Table Relationships
- Take-Home Assignment #2 due 9/14
|
|
9/15 |
- Quiz #2
- Tutorial #3: Maintaining and Querying a Database
- Take-Home Assignment #3 due 9/21
|
|
9/22 |
- Quiz #3
- Tutorial #4: Creating Forms and Reports
- Take-Home Assignment #4 due 9/28
|
|
9/29 |
- Quiz #4
- Tutorial #4: Creating Forms and Reports
- Take-Home Assignment #5 due 10/5
|
|
10/6 |
- Quiz #5
- Tutorial #5: Creating Advanced Queries and Enhancing
Table Design
- Take-Home Assignment #6 due 10/12
|
|
10/13 |
|
|
10/20 |
|
|
