recruitment registrar design presentation by jason vipond, jim sodam, joe klug, ajay dharna november...
TRANSCRIPT
![Page 1: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/1.jpg)
Recruitment RegistrarDesign Presentation
By
Jason Vipond, Jim Sodam, Joe Klug,
Ajay Dharna
November 21, 2002
![Page 2: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/2.jpg)
Project Overview
• Admissions Marketing Dept. schedules events for prospective students
• Students sign up on website
• Information keyed into Access database
• Secretary runs queries/reports and prints mailing labels from info.
![Page 3: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/3.jpg)
Old System Refresher
Telephone Secretary
DatabaseE-mail
Website
Printer
![Page 4: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/4.jpg)
Proposed System
Telephone
Website
Secretary
Client computer
![Page 5: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/5.jpg)
Types of Users
• Prospective Student User
• Administrative User
• Read Only Administrative User
![Page 6: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/6.jpg)
Student Functions
• Edit Personal Information
• Retrieve Password
• Register / Un-register for Events
![Page 7: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/7.jpg)
Student Login
![Page 8: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/8.jpg)
Register (Personal Info) Page
![Page 9: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/9.jpg)
Event Info Page
![Page 10: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/10.jpg)
Personal Page
![Page 11: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/11.jpg)
Admin Functions
• Add/Edit/Delete Students Info
• Add/Edit/Delete Event Info
• Add/Edit/Delete Holidays
• Add/Edit/Delete Majors & Major Links
• Predefined Queries
• Predefined Reports
• Download Database
![Page 12: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/12.jpg)
Admin Main Page
![Page 13: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/13.jpg)
Add/Delete/Edit Student Page
![Page 14: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/14.jpg)
Student Search Page
![Page 15: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/15.jpg)
Add/Edit/Delete Major Links
![Page 16: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/16.jpg)
Add/Edit/Delete Major
![Page 17: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/17.jpg)
Add/Edit Event
![Page 18: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/18.jpg)
Add/Edit/Delete Holiday
![Page 19: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/19.jpg)
Update Student Attendance
![Page 20: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/20.jpg)
Update Student Attendance
![Page 21: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/21.jpg)
Mailing Labels
![Page 22: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/22.jpg)
Mailing Labels (cont.)
![Page 23: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/23.jpg)
Personalized Letters
![Page 24: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/24.jpg)
Personalized Letter (cont.)
![Page 25: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/25.jpg)
Delete Old Entries
![Page 26: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/26.jpg)
Weekly Event Report
![Page 27: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/27.jpg)
Weekly Event Report (cont.)
![Page 28: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/28.jpg)
Student List for Event
![Page 29: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/29.jpg)
List All Students In System
![Page 30: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/30.jpg)
Registrations by School
![Page 31: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/31.jpg)
Registrations Per Major
![Page 32: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/32.jpg)
List Students by School
![Page 33: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/33.jpg)
List Students by Grad. Date
![Page 34: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/34.jpg)
Heard about How List
![Page 35: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/35.jpg)
Add/Edit/Delete Admin
![Page 36: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/36.jpg)
Download Database
![Page 37: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/37.jpg)
Class Diagram
Holiday
holidayNameholidayDate
Admin
levelusernamepassword
User
usernamepasswordfirstNamelastNamesexssnemailstreetcitystatezipphonehighSchoolgradDatecollegemajorAmajorBregDatedelDate
SignupExtraInfo
signupIdeventFieldIdchoice
EventFieldChoice
eventFieldIdchoiceName
Signup
userIdeventIdnumAttendingdateAttendinghowHeardAbout
*
1
*
1
*1 *
EventField
fieldNameeventIdtype
1
*
1
*
*1 *1
EventDate
eventIddatetime
Event
eventTitledescriptionlink
*
1
*
1
*1 *1
*
1
*
1
MajorLink
majorCodelinkLabellinkURL
Major
majorCodemajorName
*1 *1
1
![Page 38: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/38.jpg)
Security
• Password Encryption
• Database Encrypted, Password Protected
• Administrator Script Security
![Page 39: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/39.jpg)
Have we met requirements?• Efficiently capture data from the web page
• Must make sure appropriate data is filled in and validated
• Reduce data redundancy
• Must be able to update the database
• Provide queries
• Create a user friendly interface
![Page 40: Recruitment Registrar Design Presentation By Jason Vipond, Jim Sodam, Joe Klug, Ajay Dharna November 21, 2002](https://reader035.vdocuments.us/reader035/viewer/2022062308/56649efe5503460f94c13292/html5/thumbnails/40.jpg)
Questions?
• What is the meaning of life?
• Where do babies come from?