| Instructor: Joan Brady
Lumpkin Email: joan.lumpkin@wright.edu Office: 212-T Rike Hall Office Hours: Monday 8:30-9:30; Wednesday 8:30-9:30; 1:30-4:30; Friday 8:30-9:30 or by appointment Phone: 775-2895 or 775-3304 Graduate Assistant: Khanh Nguyen |
COURSE PREREQUISITE: CS 205 with grade of C or better
COURSE OBJECTIVES:
This lab is designed to give hands-on experiences in working with information
systems, specifically electronic communication systems and personal database
systems. At the end of this lab you will be able to:
TEXTS:
LAB: O'Leary, Timothy and Linda; Microsoft Access 2003, Introductory Edition (ISBN: 0-07-283559-1), McGraw-Hill; 2004; Shelly/ Cashman/ Mick, Microsoft FrontPage 2003: Introductory Concepts and Techniques (ISBN: 0-619-25523-4); Course Technology, 2004.
*Important Note*Supplies: At least 4 blank, formatted 3 1/2" floppy
disks or CDs. Disks will be used to regularly backup assignments and to hand in
projects. In the past, computer viruses have destroyed student diskettes
requiring many hours to recreate assignments.
Regular and consistent backups of your work will help ensure that this does not
happen to you!
If you would like to use a zip disk or CD’s to turn in your assignment that will be fine. Both of these items will allow you to save quicker and with fewer errors. All CD’s, floppies, and zip disks will be returned to you in the next class period.
Requirements, Grading and Policies
Successful completion of the lab requires regular attendance, reading lessons before each class session and completion of weekly assignments.
The lab portion of MIS 300 will comprise 25% of the total MIS 300 course grade. Students must pass the lab portion of MIS 300 at a 70% (210 points or more) level to pass the MIS 300 lecture course! Assignment details will be posted on WebCT as will the lecture power point slides. Students receive points for successfully completing each requirement:
|
Access Projects (5@15 points each) |
75 points |
|
Access Project 6 (check disk also) |
35 points |
| Access Quiz ** | 100 points |
|
FrontPage Exercise 1 |
15 points |
|
FrontPage Exercise 2 |
25 points |
|
FrontPage Quiz |
50 points |
|
Total |
300 points |
**Note: The Access Quiz must be done on a PC from the lab not a laptop.
* You cannot earn more than 300 points in the lab portion of the class. If you earn extra credit points, they may only be applied to the lab portion of your grade for MIS 300, the points will not carry over to the lecture portion of your grade.
*Extra credit assignments may be offered at the lab instructor's discretion.
Do quality work! Neatness, spelling, grammar, typographical errors, and not following instructions, will all result in assignment point deductions.
Homework and Assignments
In addition to formal lab assignments, your homework each week includes reading the assigned chapters and/or handouts, and completing the assigned exercises.
Assignments should be from Access computer output as required. Include your full name, lab section number and page and question number on all work turned in for this course. Make copies of your disks before you hand them in.
Late Work Policy
Assignments are due at the beginning of class. Do not expect to come to class and finish or print the assignment due that day. Once class has begun, if you have not handed your assignment to the instructor, the assignment is late and points will be deducted. Late assignments need to be turned in at the MIS Department Office. Please do not slide it under my office door as it could get lost.
Assignments will be accepted late, but will be subjected to a 10% penalty each day it is late. Instructors reserve the right to use their own discretion regarding late assignments.
If changes are made, the student will be advised as part of the in-class lecture or lab.
|
|
In class |
Cases/Homework |
|
|
Access - Lab 1 - Intro and Create tables |
ARF
Adoption Database (Page C1.80) |
|
|
Access - Lab 2 - Forms |
ARF Adoption (Page AC2.62) |
|
(4)-Sep 26 |
Access - Lab 3 - Reports |
ARF Adoption (Page AC3.69) |
|
|
Access - Lab 4 - Relationships and Queries |
ARF Adoption (Page AC4.64) |
|
(6)- Oct 10 |
Access - Lab 5 - Form/Sub-form |
ARF Adoption (Page AC5.61) |
|
(7)-Oct 17 |
Access - Lab 6 - Advanced Reports, Labels, and Switchboard | ARF Adoption ( Page AC6.71) Include a switchboard for items done in lessons 4, 5, and 6. |
|
(8)-Oct 24 |
Access Exam - Hands-on during LAB session |
Final disk with project files from Labs 4-6 due!! |
|
|
FrontPage - Project 1 |
Fairway Lawn Care - Page FP 74-77 |
|
|
FrontPage - Project 2 and 3 |
Fairway Lawn Care - Page FP 226 |
|
|
FrontPage exam will be included with lecture Final exam. (Exam is composed of Multiple Choice questions.) |
Plagiarism/Academic Dishonesty
Academic dishonesty, of any kind, will not be tolerated in this course. As outlined in the student handbook, any student caught cheating, copying files, etc. will receive a minimum punishment of an "F" for the assignment, repeated or flagrant violations will be punished more severely.
Lab Attendance
Lab attendance is very
crucial! Labs may be subject to last minute changes which you will not be
aware of unless you attend lab. Any questions about the assignments that may
arise can be answered during the lab. If you do not attend you will not benefit
from the help and advice of your lab instructors.
Testing: All Lab exams will be done on lab computers not
personal PCs.
Examinations are expected to be taken at the
times scheduled, and make-up work will be permitted only for the following
reasons:
1) Death of an immediate family
member.
2) Personal
illness requiring attention by physician.
3) Illness of an immediate family
requiring your personal attention.
4) Military TDY.
5) Travel out-of-town required by
your employer.
6)
An emergency and/or situation at the discretion of the instructor.