Project Sallie

1
Project Sallie

• Troy University Adjunct Faculty Tracking System

Charles Carter COMP 6620 GUI Design Project
2
Project Description
Adjunct instructors apply to teach at a
particular site. The site director accepts the
application, and collects the supporting
documentation, such as transcripts,
certifications, licenses, recommendations,
letters of reference, etc. When the package is
complete, the site director sends the application
and all supporting documentation to the regional
Associate Director for Academics. The Associate
Director reviews the package, and accepts it or
rejects it. If she accepts the application, she
forwards it to the Vice Chancellor for University
College, who distributes it to the appropriate
certification body, such as an academic council
for a particular college. The college returns the
package with an approval or disapproval to the
Vice Chancellor, who forwards the approval or
disapproval to the region, who forwards it to the
site. At this point, the site director may assign
to the instructor the approved courses.
3
Glossary

• Certification approval to each a course
• Course one individual course, such as ENG 1001
• Credential an academic degree (PhD), license
  (CPA), certification (MSCE), or other official
  recognition of special knowledge or skill
• Field a field of study, such as history,
  accounting, software engineering, or architecture
• Institution a university, college, licensing
  body, or other credentialing agency
• Instructor a part time, contract faculty member
• Password an authentication token
• Person for this project, an instructor
• Role a specific permission (security) scope
• Status either an approved certification or a
  disapproval
• Username an identifier of a user of the system

4
Hardware/Software Requirements
HARDWARE Project Sallie is a web based
application, and as such, requires both a server
and a client. The target server is an X86 machine
with suitable storage. The client machine is an
X86 machine with an appropriate desktop operating
system, such as Linux, MacOS, or Windows.
SOFTWARE Clients must run a browser capable of
rendering HTML 4.0 or higher, CSS 2.0 or higher,
and JavaScript 1.4 or higher, such as NetScape
7.0, MSIE 6.0, and Mozilla 2.0. Servers. On the
server side, the application is written in Perl
5.8, and connects to a Postgres database server.
The operating system is FreeBSD 4.0, and the web
server is Apache 1.3 with mod_perl enabled.
5
Task Scenario 1
Alphonso, who has an M.S. in Computer Science,
applies to Troy University for a position of
adjunct instructor. John, the site director,
accepts Alphonsos application and collects the
supporting transcripts and recommendations. John
forwards these to Judy, the assistant region
director for academics. Judy reviews the package,
and gives it to Bill, the database administrator,
to input the data into the database. Bill adds
Alphonso to the database, enters his personal
information (address, telephone number, etc.),
and adds his credentialing information to the
database. Bill then adds the certification status
data to the database, but not the certifications.
6
Task Scenerio 2
Bill receives notification from University
College at Troy that Alphonso has been certified
to teach COMP 1400, Introduction to Programming.
Bill accesses the database, inserted the status
of Approved in the certification column, and
the date in the date column. He then notifies
John of Alphonsos certification status for this
course. John notifies Alphonso that he has been
approved to teach this course, and adds Alphonso
name to the list of approved instructors. In
scheduling courses for the next term. John
assigns Alphonso to teach a section of COMP 1400.
7
Task Scenario 3
John, a site director, is in the process of
scheduling course sections for the new term. He
needs to know the faculty that has been approved
to teach a new course, COMP 6677, Object Oriented
Interface Design. John accesses the database and
queries it for all instructors who have been
approved to teach this course. From this list, he
selects Martha and assigns her to teach one
section of COMP 6677. He then queries the
database to see what other courses Martha has
been approved to teach. He discovers that she has
been approved to teach COMP 1400, and he assigns
Martha one section of COMP 1400.
8
Work Schedule

• Phase 1, October 1
• Insert Person
• Select (All) Persons
• Update Person
• Delete Person
• Phase 2, October 15
• Insert Credential
• Select Credential by Person
• Update Credential
• Delete Credential
• Phase 3, November 1
• Insert Status
• Select Status by Person
• Select Status by Course
• Update Status

• Phase 4, November 15
• Implement Security Roles
• User
• Manager
• Director
• Phase 5, December 1
• Insert Credential by Person
• Insert Cert Status by Person
• Report Cert Status by Person
• Applied for
• Approved
• Disapproved
• Phase 6, December
• Place application on intranet server and begin
  testing prototype.

9
High Level Prototype
The following screen shots are taken from the
development application. They include a number of
hex dumps and other debugging messages. At some
point soon, I will move this to an internet
server so that the users can evaluate the
project. ASSUMPTION This project assumes that
the user is the database administrator who has
maintained these records by hand for a period of
time, and is familiar with the problem domain.
The application is NOT designed for a casual user
or one unfamiliar with the needs, functions, and
requirements of the system. Other than this, it
is assumed that the system is completely
intuitive, and therefore no help facility is
provided or is deemed necessary.
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
Project Sallie
Troy University Faculty Tracking System Southeast
Region
Charles C. Carter COMP 6620 Fall, 2005