SDSU Template, Version 11.1

61 Pages·2011·3.73 MB·English

by  Enrollment Services

GRADUATE ADVISOR AND FACULTY APPOINTMENT SYSTEM -
SDSU
_______________
A Thesis
Presented to the
Faculty of
San Diego State University
_______________
In Partial Fulfillment
of the Requirements for the Degree
Master of Science
in
Computer Science
_______________
by
Uday Kanth Ranganamyna
Fall 2011

iii
Copyright © 2011
by
Uday Kanth Ranganamyna
All Rights Reserved
iv
DEDICATION
I would like to dedicate this thesis work to my parents and brothers. It would not have
been possible without their boundless love, continuous motivation and support.
v
ABSTRACT OF THE THESIS
Graduate Advisor and Faculty Appointment System - SDSU
by
Uday Kanth Ranganamyna
Master of Science in Computer Science
San Diego State University, 2011

A large institution like San Diego State University (SDSU) has a huge numbers of
students visiting the professors everyday for different reasons. Given that these professors are
really busy teaching classes and doing research, the students might sometimes be forced to
wait in long queues near the office of the advisors or professors thereby creating a busy
pathway near the offices. This situation can therefore create disappointment among the
students who may not get a chance to talk to the advisor or professor due to time constraints.
This thesis project provides an effective time management solution to the current
problem using a web-based application which allows the professors and advisors to schedule
their timings in the application using a web browser from either a mobile device or a
computer. Also, this application will allow the students to make an appointment with a
professor during his/her available schedule. Once a student makes an appointment, they will
get a confirmation of their appointment using email. A professor can check all his/her
appointments on a given date using this web application. This application guarantees that the
students have a confirmed appointment time before meeting an advisor/professor.
vi
TABLE OF CONTENTS
PAGE
ABSTRACT ...............................................................................................................................v
LIST OF FIGURES ................................................................................................................. ix
ACKNOWLEDGEMENTS ..................................................................................................... xi
CHAPTER
1 INTRODUCTION .........................................................................................................1
2 TECHNOLOGY AND REQUIREMENTS ...................................................................3
2.1 Software and Languages ....................................................................................3
2.2 Libraries .............................................................................................................3
2.3 JAVA .................................................................................................................4
2.4 JavaScript ...........................................................................................................4
2.5 JSP......................................................................................................................4
2.6 HTML ................................................................................................................5
2.7 Ajax ....................................................................................................................6
3 ARCHITECTURE AND DATABASE DESIGN .........................................................7
3.1 Introduction ........................................................................................................7
3.2 Web Application (Client) ...................................................................................8
3.3 Database Design.................................................................................................8
3.3.1 Register Table ...........................................................................................8
3.3.2 Add Schedule Table ..................................................................................9
3.3.3 Appointment Type Table ........................................................................10
3.3.4 Appointment Register Table ...................................................................10
3.3.5 Add CPT Table .......................................................................................11
3.3.6 Add Reduced Course Load Table ...........................................................11
4 IMPLEMENTATION AND RESULTS ......................................................................13
4.1 Authentication Module ....................................................................................13
4.1.1 Role Based Login Authorization ............................................................13
4.1.2 Forgot Password......................................................................................16
vii
4.2 Admin Module .................................................................................................18
4.2.1 Add Professor..........................................................................................20
4.2.2 Edit Professor ..........................................................................................20
4.2.3 View Professors ......................................................................................22
4.2.4 Delete Professor ......................................................................................22
4.2.5 Edit Admin ..............................................................................................22
4.3 Advisor and Professor Module ........................................................................23
4.3.1 Advisor Module ......................................................................................24
4.3.1.1 Add Appointment Type .................................................................24
4.3.1.2 View Appointment Type................................................................26
4.3.1.3 Edit Appointment Type ..................................................................26
4.3.1.4 Delete Appointment Type ..............................................................27
4.3.1.5 Add Schedule .................................................................................27
4.3.1.6 Edit Schedule .................................................................................30
4.3.1.7 Delete Schedule .............................................................................30
4.3.1.8 View Schedule ...............................................................................30
4.3.1.9 View Appointments .......................................................................30
4.3.1.10 Edit Profile ...................................................................................30
4.3.1.11 View CPT Applications ...............................................................32
4.3.1.12 View Reduced Course Load Applications ...................................33
4.3.2 Professor Module ....................................................................................34
4.3.2.1 Add Schedule .................................................................................34
4.3.2.2 Edit Schedule .................................................................................36
4.3.2.3 Delete Schedule .............................................................................36
4.3.2.4 View Schedule ...............................................................................36
4.3.2.5 View Appointments .......................................................................37
4.3.2.6 Edit Profile .....................................................................................37
4.4 Student Module ................................................................................................38
4.4.1 View Appointments ................................................................................38
4.4.2 View Schedule ........................................................................................39
4.4.3 Make Appointments ................................................................................39
4.4.4 Apply CPT ..............................................................................................44
viii
4.4.5 Apply Reduced Course Load ..................................................................44
5 CONCLUSION ............................................................................................................47
5.1 Limitation .........................................................................................................47
5.2 Future Enhancements .......................................................................................47
REFERENCES ........................................................................................................................49
ix
LIST OF FIGURES
PAGE
Figure 1.1. Home page. ..............................................................................................................1
Figure 1.2. Advisor home page. .................................................................................................2
Figure 2.1. JSP workflow...........................................................................................................5
Figure 3.1. Architecture. ............................................................................................................7
Figure 3.2. Register table. ..........................................................................................................8
Figure 3.3. Add schedule table. .................................................................................................9
Figure 3.4. Add appointment type. ..........................................................................................10
Figure 3.5. Appointment register table. ...................................................................................11
Figure 3.6. Add CPT table. ......................................................................................................12
Figure 3.7. Add Reduced Course Load table. ..........................................................................12
Figure 4.1. Login page. ............................................................................................................14
Figure 4.2. Login not successful. .............................................................................................15
Figure 4.3. Forgot password page. ...........................................................................................16
Figure 4.4. Forgot password mail. ...........................................................................................17
Figure 4.5. Invalid email. .........................................................................................................18
Figure 4.6. Admin use case diagram. .......................................................................................19
Figure 4.7. Admin page. ..........................................................................................................19
Figure 4.8. Add professor. .......................................................................................................21
Figure 4.9. Add user java script. ..............................................................................................21
Figure 4.10. Edit professor in admin page. ..............................................................................22
Figure 4.11. Edit admin profile page. ......................................................................................23
Figure 4.12. Advisor use case diagram. ...................................................................................25
Figure 4.13. Advisor home page. .............................................................................................25
Figure 4.14. Add appointment type. ........................................................................................26
Figure 4.15. View appointment type........................................................................................27
Figure 4.16. Add schedule calendar. ........................................................................................28
Figure 4.17. Add schedule time picker. ...................................................................................28
x
Figure 4.18. View advisor schedule. ........................................................................................31
Figure 4.19. View advisor appointments. ................................................................................31
Figure 4.20. Print CPT. ............................................................................................................32
Figure 4.21. Print Reduced Course Load. ................................................................................33
Figure 4.22. Professor use case diagram. .................................................................................34
Figure 4.23. Professor home page............................................................................................35
Figure 4.24. Add professor schedule. ......................................................................................36
Figure 4.25. Edit professor profile. ..........................................................................................37
Figure 4.26. Student use case diagram.....................................................................................38
Figure 4.27. Student page. .......................................................................................................39
Figure 4.28. View student appointment1. ................................................................................40
Figure 4.29. View student appointment2. ................................................................................40
Figure 4.30. Student view schedule. ........................................................................................41
Figure 4.31. Office appointment. .............................................................................................42
Figure 4.32. Advising appointment. ........................................................................................42
Figure 4.33. Student appointment mail. ...................................................................................43
Figure 4.34. CPT application form. .........................................................................................45
Figure 4.35. Reduced Course Load form. ................................................................................46