Specification
Requested by
Tim Lederman
October 28, 2002
SCIPAnet
Digital Foundry
Heather Addison
Matthew Begley
Scott Dakers
Dan Hopkins
Vicky Lee
Brian Rubsha
Table of Contents
Section 1: Product Overview and Summary 3
Section 2: Development, Operating and Maintenance Environments 5
Section 3: External Interfaces and Data Flows 7
Mockups 8
Data Flows 23
Data Dictionary 33
Section 4: Functional
Requirements 67
Section 5: Performance Requirements 70
Section 6: Exception
Handling 72
Section 7: Early Subsets and Implementation Priorities 74
Section 8: Foreseeable
Modification and Enhancements 76
Section 9: Acceptance Criteria 78
Section 10: Testing Requirements 80
Section 11: Glossary of Terms 82
Section 1:
Project
Overview
The Siena College internship program is an important and crucial part of the development of its students. The science portion of this program is responsible for many students getting successful internships during their tenure at Siena College. Currently Dr. Tim Lederman runs the science divisions’ internship program by using volumes of paper documents outlining student applications, work site applications, contact information and other necessary information. A current student begins his internship process by filling out a paper application and submitting a transcript to the internship coordinator. The coordinator then approves or disapproves the student’s application. If the application is approved then a site that works primarily in the student’s given interest is found. The work sites follow a similar pattern in their application process. From a written proposal given to the coordinator, students are assigned based on their expertise and qualifications. At the end of the internship the student and the worksite fill out evaluations of each other’s work experience.
However, with expanding class sizes and an increasing need for real world experience before graduation, Dr. Lederman has been forced to take more responsibility, involving greater amounts of paperwork. SCIPAnet is proposed as a complete replacement to the current paper-based system of internship management. Through the use of an Oracle database it will be possible to maintain a centralized record of internship information both student and work-site related. The database will be a resource used to keep track of individual student experiences in the program allowing for an internet based application, transcript submission, and evaluation. It will also allow work sites to submit project proposals to the coordinator, update contact information and fill out evaluations about current interns. Finally, SCIPAnet will allow the Coordinator to perform queries using multiple search criteria.
Section 2:
Development, Operating and Maintenance Environments
Development:
.
All development of SCIPAnet will be performed by Digital Foundry using Siena College computing facilities. Siena College’s computing facilities involves multiple computer labs running either Windows 2000 or XP. The database portion of the system will be developed in the production Oracle 9i database. When the system is complete it will be running on Computer Science’s web server.
Operation:
.
The coordinator, students and work-site are the three users that need to interact with SCIPAnet. All three of these interactions will make use of an Internet based graphical user interface that is easy to use and has substantial power. There will be no training or user manuals created and the users will have to rely on help given in the form of popup dialog boxes generated from the website itself. The three users will log in through a general log in screen. From here they will be presented with different screens based on their status. The coordinator will be given options to either query the database, review student applications and information or perform other various tasks. The work sites will be able to update contact information, update or submit new project proposals, or fill out evaluations. The students will be able to update or newly submit an application for an internship. They will also be able to fill out an evaluation about their work experience.
Maintenance:
.
The only maintenance considerations that are being explored are those of the coordinator maintaining student records. The database itself will have to be maintained by the DBMA himself in order to maintain consistency and troubleshoot problems in Oracle. Student records and work sites will either have to be maintained by the coordinator himself or by the actual student or worksite. Mostly, however, it will fall on the coordinator to maintain and expand student records.
Section 3:
External
Interfaces
and Data
Flows
|
|
||
|
Welcome to the Siena Science Internship Program Home
Page |
||
|
Login: |
|
|
|
|
Student |
|
|
|
Internship |
|
Internship Work Site Login:
|
User Name: |
|
|
Password: |
Forgot
Password?
Have not registered yet?
Student Login
|
Email Address: |
|
|
Password: |
Welcome Coordinator if you would just like to enter your password we can
begin:
Password:
Forgot Password?
Insert your E-mail address below and your login and password will be automatically sent to your E-mail account.
E-mail Address:
Internship Work Site Login:
|
User Name: |
|
|
Password: |
Forgot
Password?
Have not registered yet?
Welcome, NAME OF STUDENT, to the Science Division Internship Program.
Student
Application Form
Contians a form to fill out in order to apply for an internship.
Also allows for student to update there exsisting applications.
Student
Evaluation Form
This will allow you to fill out a Evaluation of your internship.
Only AFTER completion of your internship.
|
Queries:
Messaging Center:
|
Welcome Dr. Lederman:
|
|
Science Intern
Information
Sheet
Last Name: First Name:
Major:
Class During Internship: Expected Graduation Date:
Academic Advisor:
You may earn up to a maximum of 6 internship credits,
1-3 credits per semester.
A student intern works 40 hours on site for each credit.
Credits: (hours) Session for Internship:
Description of specific interests:
Major GPA Overall GPA
Students #
Name:
Local Address:
City: State: Zip:
Phone
Home Address:
City: State: Zip:
Phone
Course Name Course Number Grade Indicate Transfer or Current or Intend to take in future
Thank you for filling out the intern information sheet.
Once you press the summit button your form will be emailed to the Science Division Internship Coordinator.
You will be contacted within a couple of days and will be giving further directions at that time.
Siena College
Science Intern Evaluation
|
Name of Intern: |
|
Date: |
||
|
Name and Title of Supervisor: |
|
|
|
|
|
Company Name: |
|
|
|
Reliability
|
|
Excellent |
Good |
Fair |
Poor |
Not Applicable |
|
Arrive at expected time: |
|
||||
|
Preparation for assignment: |
|||||
|
Completion of assignments on time: |
Initiative
|
|
Excellent |
Good |
Fair |
Poor |
Not Applicable |
|
Planning |
|||||
|
Aptitude |
|||||
|
Ability to work without supervision |
|||||
|
Innovation |
|||||
|
Drive, perseverance |
Quality of Work
|
|
Excellent |
Good |
Fair |
Poor |
Not Applicable |
|
Organization |
|||||
|
Work with others |
|||||
|
Written expression |
|||||
|
Oral expression |
|||||
|
Accuracy |
|||||
|
Capacity to learn new skills |
Comments:
Suggested Grade:
Would you like to have a Siena science intern next semester? Yes No
School of Science
Internship Program
Site of Qualification
Session ,
(year)
Name of Organization:
Address:
City State Zip
Phone Number: Fax Number:
E-mail Address:
Name of Intern Supervisor:
Title of Intern Supervisor:
Job Description/Project Description/Description of Internship:
School of Science
Internship Program
Site of Qualification
Session ,
(year)
Name of Organization:
Address:
City State Zip
Phone Number: Fax Number:
E-mail Address:
Name of Intern Supervisor:
Title of Intern Supervisor:
Job Description/Project Description/Description of Internship: