• Complete OUAC data model [complete]
• Develop internal data model for OGSAS
• Review infrastructure requirements for OGSAS system [in progress]
• Review security and access control requirements for OGSAS system [in progress]
• Write a script to import normalized data into OGSAS database [in progress]
• Determine scanning requirements and procedures
• Develop an on-line supplementary information form.
• Develop an on-line research interests form (may not be needed)
• Develop an on-line confidential reference form
• Develop a pdf generator for reference form
• Develop a custom URL generator for reference form
• Write code for automatic email generation
• Develop a applicant interface screen
• Develop a coordinator interface screen
• Develop a faculty interface screen
• Develop a director interface screen
• Determine method for attaching scanned documents to an application
• Develop a "application view" screen
• Develop a "application edit" screen
• Develop a "intent to accept" form for faculty
• Develop a "annotate application" form for faculty and director
• Develop a way to generate a "recommendation to accept" form
• Develop a method to export data (of accepted students) to Grad Database (currently Filemaker)
• Develop a method for Grad office staff to generate letters based on data in OGSAS database
• Develop a form for the director to specify details of an offer
• Develop a migration plan for new system
• Develop an "accept/decline" offer screen for applicant
• Develop a general query screen
• Develop a "view relevant applications (sorted)" screen for faculty

-- JasonTestart - 06 Jun 2007