Detailed
Design
Requested by
Tim Lederman
Heather Addison
Matthew Begley
Scott Dakers
Dan Hopkins
Vicky Lee
Brian Rubsha
Table of Contents
Project
Overview
3
Prototypes
...4
Data Flows ..37
Data Dictionaries 50
Automatic Email .93
Database Design .97
Company Database
Student Database
Testing Requirements 98
Design Inventory ...99
The
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.
Prototypes
Creating An Account
First Name: Last Name:
Choose user type:
Your E-mail address will be your User Identification name.
E-mail Address:
Password:
Confirm Password:
Secret Question:
Answer:
If you are a new client or student. Click on link below: |
Login Username: password: Forgot Password? Click Here
|
Type in your Username.
Username:
Hint:
Answer:
Students: |
Worksites: |
||||||||||||||||||||||||
Student Lists:
|
Company:
|
||||||||||||||||||||||||
|
Student Last Name:
Supervisor Last Name:
-or-
Company Name:
Student:
Welcome to the Internship Site Web Page
Choose one of the following options below.
Update
Current Contact Information
Proposed Internship Programs:
Java
Consultant **Last Updated 10/6/2001
Web
Designer **Last Updated 9/23/2002
Add
New Project
Contact Information:
If the following information is incorrect please update it and press update.
Otherwise cancel will return you to the main page.
Supervisor Information:
First Name: |
Last Name: |
Job Title: |
Work Phone #: |
Fax #: |
Company Information:
Company Name |
Address |
Address 2 |
City: |
State: |
Postal Code: |
Project Proposal
Semester: Year:
Supervisor: Title:
Company: Telephone:
E-mail address: Fax:
Address:
City: State: Zip:
Please Check One:
I have not previously supervised a
I have previously supervised a
Is there any type of course or skills required?
For Computer Science Internships Only:
Language or application requirements:
Hardware type(s), operating system(s):
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
Yes No
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.
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
Grade |
Course Name |
Course Number |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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.
Site Evaluation by Intern
Top of FormStudent Name: |
|
Semester: |
||
Company Name: |
|
No. of Credits: |
||
Department: |
|
|
|
|
Supervisor Name: |
|
|
|
Please answer the Following Questions using the provided Scale:
1. The projects or Tasks you were assigned were academically challenging. |
|
2. The projects or tasks you were assigned were of reasonable magnitude (i.e. they could be done in the allotted time). |
|
3. You were NOT asked to perform non-academic tasks for others (i.e. photocopying, filing, glassware cleaning, animal care). |
|
4. A supervisor was available to introduce you to co-workers and show you the facilities, |
|
5. Someone was available to answer your questions. |
|
6. Your supervisor protected you from any internal disputes. |
|
7. You were provided with a work space and all the resources (equipment, computer time, etc) that you needed. |
|
8. You were adequately trained before being expected to work alone. |
|
9. Your supervisor did not expect too much of you. |
|
|
10. People with whom you came in contact with were friendly and courteous. |
11. Would you accept this particular assignment again,
knowing what you do now? (Select one)
Yes
No
12. Would you register for an internship again, knowing
what you do now? (Select one)
Yes
No
13. Describe the good points of your internship experience.
14. Describe the bad points of your internship experience.
15. Describe your internship as completely as possible in one paragraph. This paragraph will be used in reports submitted by the internship coordinator.
Final Requirements
Many of you have questions related to the final report. This is a significant part of the evaluation process. Here are some tips to help you prepare an acceptable report.
If you have done a research project, then a research paper format is a good model to use for your report. A well-written research paper will integrate virtually all of the points mentioned above. If your work is more applications oriented, then you should pay especially cose attention to the items listed above when organizing your report. While length is no indicator of quality, do not sacrifice completeness for the sake of brevity. I expect a paper of approximately 4 to 5 pages in length. Communications skills are essential in any professional position. Your report should reflect high standards of English composition: style, syntax and grammer.
Due Date: All logbooks/sheets, reports, and
site-evaluations forms are due in my office, Numbers Place 211 (if I am not in,
put the material in the "INTERN" box on the floor outside my door) by
DUE:
You have to submit three documents to me as part of the evaluation process
IF YOU FAIL TO TURN IN THESE DOCUMENTS, ON TIME, YOUR GRADE WILL BE LOWERED TO AN "F" (the course is Pass/Fail). Do not jeopardize your chances to graduate this May by neglecting to turn in these documents ON TIME!!!!
Internship
Informational Meeting
Mandatory for Science Division Students
Who will be Seniors in Spring 2002
And who are interested in
Science Division Internship, SCDV-480 (Spring 2002)
Friday, Nov. 2, from
Colbeth Common Area
Application forms will be available
To be eligible for SCDV-480, you must:
·
Be a
senior majoring in one of the departments of
· Have completed a minimum of 4 courses or 14 credits in the field of interest.
· Complete an internship application form.
· Be recommended by your academic department.
· Have a signed authorization to register slip from the Science Intern Coordinator.
If you cannot attend one of the meetings above, please see Dr. Egan (CD-207) as soon as possible.
SOME QUESTIONS AND ANSWERS ABOUT
THE
What are an Intern's qualifications?
How is an Intern assigned?
What is an Intern's workload?
How is an INtern supervised and supported?
Does an intern receive compensation?
REQUIREMENTS
FOR SCIENCE DIVISION INTERNS
Beginning of Semester
Durring the Semester
End of Semester:
Science
Division Summer Internship Program
Guidelines &
Procedures -- Summer
1. Students qualification. (A form is available from the Director or in the Science Division Office)
· See the Siena College Catalog for the campus-wide minimum regulations for internships.
· A 2.8 GPA overall, and in the student's major, and in the internship concentration (if not the student's major).
· A minimum of 84 credits completed towards the 120 credits needed for graduation.
· A program of study signed by the student's advisor outlining the completion of degree requirements within twelve months.
· Permission of the Director of the SDSIP, Dr. Mary Anne Egan, Colbeth Hall 207.
2. Credits earned and hourly time requirements.
· Limited to a total of 3 credits (Note: this credit counts as part of the 6-credit limit for internships).
· The intern will spend a minimum of 120 hours of internship activities on-site.
3. Internship location.
· Summer internships are not limited to the Capital District.
· Site is to be found by the student.
4. Starting date and ending date.
· The earliest starting date is the day after the Spring final exam period.
·
The
latest ending date is the date that
5. Approval of Internship Site and Registration.
· After the student officially qualifies for a summer internship (see #1 above), the student will obtain a "Summer Internship Site Qualification Form" from the Director. In addition, the student will obtain a "Summer Internship, Schedule of Activities". These forms must be completed by the site supervisor and the student and returned to the Director no later than May 15.
· The Director will inform the student by electronic mail (usually with two week days) if the site has been approved.
·
If
the site is approved, the student will obtain an "Authorization to
Register" slip from the Director and then the student will proceed to
register for the course as part of
6. Reporting during the summer to the Director of the Science Division Summer Internship Program.
·
Each
Monday, by
· On the last day of the internship (the date indicated by the student on the "Schedule of Activities" form), the student will fax to the Director a 4-5 page Final Report on the entire internship experience.
7. Grading.
· SCDV-480 is designated as a "pass/fail" course. Therefore, you will earn a grade of either "pass" or "fail".
· The grade will be based on the timeliness of all required reporting and the quality of the Final Report.
Data Flows
And
Data Dictionary