MIS300 LAB
       Introduction to Management Information Systems
Fall 2005
Lab: Mon 1:30-2:30 LX005
Lab: Mon 2:45-3:45 LX005

Course Materials on WebCT


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
Email: nguyen.34@wright.edu

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*
You must use Microsoft Access 2003 for your database projects!  Projects completed with Access 97 or 2000 will not be graded.

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.

Tentative LAB Schedule

(WEEK)

In class
Fall 2005

Cases/Homework
(Assignments due next lab after assigned)

 (2)-Sep 12

Access - Lab 1 - Intro and Create tables

ARF Adoption Database (Page C1.80)
 

(3)-Sep 19

Access - Lab 2 - Forms
 

ARF Adoption (Page AC2.62)

(4)-Sep 26

Access - Lab 3 - Reports

ARF Adoption (Page AC3.69)
(5)-Oct 3

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
(Student must use lab computers.)

Final disk with project files from Labs 4-6 due!!

(9)-Oct 31

 FrontPage - Project 1

Fairway Lawn Care - Page FP 74-77

(10)-Nov 07

 FrontPage - Project 2 and 3

Fairway Lawn Care - Page FP 226
Publish page on WSU website

 
 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.