Wells College Computing Department Information Management System

1
Wells College Computing Department Information
Management System

• Jocelyn L. Becraft
• Senior Thesis Presentation
• Spring 2000

2
Information Management System(IMS)

• Why I chose this as my senior project
• My background
• Why an IMS
• Simplify
• Makes information quickly and readily accessible
• Organize
• Allows for easy updates
• Economize
• Decreases time wasted on searching in a
  non-organized system

3
Wells Computing DepartmentIMS
4
IMS Users

• Who are they?
• Computing Support Group
• Computer Lab Assistants (CLA)
• CLA Manager(s)
• Faculty / Staff
• Students

5
Information Organization

• Microsoft Access
• Tables
• Hardware entity relationship (ER) diagram
• Software ER diagram and table
• Queries
• Access SQL example

6
Hardware ER Diagram
ISA
7
Software ER Diagram Table
version
quantity
manufacturer
platform
name
software
8
Query Example
Dim varPlatform Set varPlatform
Request.Form(platform) Dim rsUser, sql rsUser
Server.CreateObject("ADODB.Recordset") sql
"SELECT FROM UserPC WHERE platform "
varPlatform "" rsEquip.Open sql, "DSNWCCSDB",
adOpenForwardOnly,adLockOptimistic, adCmdText
9
Implementation Environment

• Windows NT Server 4.0
• Integrated security
• Communication services
• Internet Information Server 4.0 (IIS)

10
Web Interface Design

• Active Server Pages (ASP)
• What is ASP?

HTML
11
So what did I do?

• http//10.3.4.197
• Faculty/Staff Students
• Personnel Form
• Equipment Request Form
• Equipment Problem Form
• Computing Staff
• Tech Main Menu
• CLA / CLA Manager(s)
• Lab Equipment Problem Form

Link
12
An example of how the system works

• How does a problem entered into the form by a CLA
  help the Support Technicians and other CLAs?

Processes all inputs and requests
link
13
What next?

• System that tracked sign out equipment
• Would send an email to the requester letting them
  know if their request was approved, and another
  to the technicians for information purposes only
• System that automatically tracked hardware
  problems
• Would alert the technicians if a piece of
  equipment had a re-occurring problem
• Form for students to enter hardware problems that
  occur in academic labs

14
Acknowledgements

• Prof. Carol Shilepsky
• Ami Dudzinski
• The Entire Computing Staff
• All MPS Seniors
• My Family and Friends