Winter 2004
Instructor:
Name: Jon Huhtala Office: Business 366 Phone: 231-591-2477 (extension 2477 on campus) E-mail: When sending e-mail, mention ISYS 200 in the subject line or your e-mail will be deleted.
My Classroom and Office Schedule:
M
T
W
R
F
8:00
9:00
10:00
11:00
12:00
1:00
ISYS 216 ISYS 216 ISYS 216 2:00
3:00
Office Office Office Office 4:00
ISYS 200 ISYS 200 ISYS 200 ISYS 200 5:00
" " " "
Course Description:
Introduces the basic concepts of relational databases, tables, records, and fields. This course is an introduction to database design, and implementation using Microsoft Access. Relational database structures, normalization techniques, and integrity constraints are introduced. Beginning and intermediate query, form, report, and web publishing facilities are demonstrated and utilized.
Course Outcomes:
Upon successful completion of this course, you will be able to:
1) Understand the basic concepts of relational databases.
2) Create tables, define data types, create data input rules and define relationships between tables.
3) Use automated query, form, report, and web publishing tools in Access.
4) Manually create multiple query types in Access that include joins and intermediate selection criteria.
5) Manually create forms in Access from tables and queries that include subforms.
6) Manually create reports in Access from tables and queries that include subreports.
7) Demonstrate the ability to integrate tables, queries, reports, and web publishing for use in database management.
Prerequisite:
ISYS 105 - Microcomputer Applications or competency
Text:
Microsoft Access 2002 Comprehensive by Adamski and Finnegan. ISBN 0-619-02089-X.
Web Resources:
The primary course Web site is Java Help. From the opening page, follow the links to "Courses from Ferris State University" and "ISYS 200 - Database Design and Implementation". There you will find links to the course syllabus, tutorial help, class schedule with links to assignments, and your current grade.
Required Supplies:
A Zip disk (either 100MB or 250MB) - For high-speed database development and storage. Dedicate the disk to ONLY this course and bring it with you whenever you come to class or my office.
Data Files for Tutorials:
All the files you need to complete textbook tutorial "sessions" can be copied directly to your zip disk from the following College of Business network folder:
L:\BTC\JON HUHTALA\DATABASE\Data Files
This may be done at any time in any College of Business lab. Simply copy the entire "Data Files" folder to the root directory of your zip disk.
The "Data Files" folder contains the following subfolders:
Tutorial.01 - Contains files needed for Access tutorials 1 through 4 in the book.
Tutorial.05 - Contains files needed for Access tutorials 5 through 7 in the book.
Tutorial.08 - Contains files needed for Access tutorials 8 and 9 in the book.
Tutorial Solutions - These are useful for checking your work. Because the tutorials are progressive and must be done in order, the solution files also make it possible to continue with the next tutorial having "messed up" the previous one. For example, if you want to do tutorial 7 but "botched" tutorial 6, you could copy the database solution file for tutorial 6 and proceed from that point.
Data Files for Cases:
All the files you need to complete case problems can be copied directly to your zip disk from the following College of Business network folder:
L:\BTC\JON HUHTALA\DATABASE\Case Problems
This may be done at any time in any College of Business lab. Simply copy the entire "Case Problems" folder to the root directory of your zip disk.
The "Case Problems" folder contains subfolders named "Case 1", "Case 2", etc. for each of the 9 cases you must complete this semester. Within each subfolder are the necessary database files along with a Word document that describes what you must do within the case.
Class Time:
Every class session will be an open lab. Working within the guidelines of the class schedule, use this time to complete the 23 "sessions" in Access tutorials 1 through 9 of the book, the 9 required case problems, or the major project. I will be available to help if you have problems.
Case Problems:
Each of the 9 Access tutorials has an accompanying case problem. The necessary files and a Word document describing the case must be copied from the College of Business network (see Data Files for Cases, above). For credit, you must send me an e-mail with answers to any case questions and the attached data base (.mdb) solution file on or before the due date listed in the class schedule. You will receive a return e-mail with your score within a few days of the case's due date.
Major Project:
After completing all Access tutorials and cases, you will design and develop a comprehensive database solution to a problem of your choice. Minimum requirements will be specified in the project assignment. For credit, you must send me an e-mail with the necessary attachments no later than the due date listed in the class schedule. I will send an e-mail reply with your score within a few days of the project's due date.
Competency Exam:
At the end of the semester, you must design and develop in class a small database that shows your competency in the material covered. You will have 100 minutes to complete the work independently.
Grades:
Your final grade will be based on the following:
Graded Item
Points Possible
Case problems 90
Major project 90
Competency exam 60
Total
240
Letter grades will correspond to the following:
Points Earned
Final Grade
216 and up A
192 - 215 B 168 - 191 C 144 - 167 D 0 - 143 F Note that:
I do NOT give "+" and "-" grades.
NO extra credit, case or project re-submits, or exam re-takes will be allowed.
In keeping with University policy, an "I" grade (incomplete) can ONLY be given if at least 75% of all graded work has been completed with a passing grade.
Classroom Policies and Attendance:
It is expected that everyone will conduct themselves in a professional manner by following these rules:
Attendance is optional but recommended. All class sessions will be open labs at which you may work on Access tutorials, case problems, or the major project and get immediate help.
Inform me of any serious health problems. This is for your own safety.
Treat everyone with dignity and respect. Language, attire, actions, and attitudes that may offend others will NOT be tolerated.
Don't bring friends or children to class. If you have young children and can't get a sitter, stay home with your children.
Don't disrupt class. Pagers, cell phones, CD players, tape players, and other distractions will NOT be tolerated.