Overview
Executive Summary
Staff in the University’s Student Disability Service (SDS), have 2 web-based ColdFusion applications, RADIUM and KELSO, which run against a SQL Server database.
The KELSO database is the source of the SDS’s 2 waiting lists:
- Educational Psychologist waiting list
- Needs Assessment waiting list
The Student Disability Service (SDS) needs to handle over 650 appointments annually. This consists of +250 Needs Assessments for Advisors to assess a disabled students needs, and over 400 appointments for students to see an Educational Psychologist.
The SDS also helps students to apply for Disabled Student Allowance (DSA). It’s a large part of the work carried out by the service as SDS Advisors carry out over 250 Needs Assessments each year. This brings in about £85,000 of income which is crucial to the running of the service.
This project is concerned with the following enhancements to the Kelso database system:
- Added functionality and overhaul of the two waiting list systems listed above
- A more efficient Needs Assessment, repeat DSA process
Other Enhancements:
The initiation of this project has identified that the SQL Server Database has to be upgraded and that the ColdFusion version of the waiting lists needs to be upgraded. Before any changes can be made to the waiting lists or DSA process, the upgrades will need to be carried out.
There is also the potential that the framework (Fusebox) will need to be changed as the current framework is not one widely used in the University at this time.
Business Objectives and Project Deliverables
No | Description | New or Changed (Y/N) |
O1 | To upgrade the existing Database and application to the most recent versions (of SQLServer & CF) | N |
D1 | To investigate and implement an upgrade for the SQL Server database from version 2000 to 2008 | N |
D2 | To investigate which version of ColdFusion to upgrade the lists to (9 or 10) | N |
D3 | To implement the changes required to upgrade ColdFusion to the recommended version | N |
D4 | Acceptance from the business area that the upgrade has not had an impact on the current waiting lists | N |
D5 | Acceptance from IS that the database and applications are on supported versions | N |
O2 | To establish the required changes to the constituent elements of the information systems used by the Student Disability Service. | Y |
D1 | A set of business requirements that list the modifications that need to be made to the 2 waiting lists in use by the Disability Service | Y |
D2 | A set of business requirements that list the modifications that need to be made to the DSA Needs Assessment, and repeat DSA process | Y |
D3 | To obtain sign-off that the business anaylsis meets the business requirements. | Y |
O3 | To implement the listed enhancements in each relevant part of the information systems used by the Student Disability Service | Y |
D1 | Update the Educational Psychologist waiting list with the required changes | Y |
D2 | Update the Needs Assessment waiting list with the required changes | Y |
D3 | An updated and more efficient Needs Assessment, repeat DSA process | Y |
D4 | To obtain sign-off that the changes made to the information systems running the waiting lists and DSA process meet their agreed business requirements. | Y |
O4 | To investigate the possibility of upgrading the framework from Fusebox to Mach II | Y |
D6 | Technical Analysis of what is required to transfer the framework and a decision on whether to include the work in this project or a recommendation that it be done under a future project. | Y |
Success Criteria
The success of the project will be determined by the achievement (or not) of the above objectives and the deliverables.
Scope
The scope of this project includes the following:
- Upgrading the Kelso database to the supported version of SQL Server
- Determining what version of ColdFusion to upgrade the applications to
- Upgrading the applications to the agreed version of ColdFusion
- Analysis of whether the framework needs to be transferred from Fusebox to Mach II (at the time of submitting the TOR the actual transfer of the framework is excluded from the scope)
- Business Analysis of what is needed to incorporate the requirements for an updated Educational Psychologist waiting list , Needs Assessment waiting list and a more efficient Needs Assessment, repeat DSA process
- Analysis of how the business requirements can be incorporated into the information systems used by the Student Disability Service staff.
- Estimating the effort required to make the necessary changes to the information systems used by the Student Disability Service staff.
- A decision on the priorities for any enhancements and a decision of which elements can be included in the project or will need to be planned as part of a future project.
- Developing the code to implement the agreed changes for the Educational Psychologist waiting list , Needs Assessment waiting list and the Needs Assessment, repeat DSA process.
- Testing these changes before release for UAT.
- Moving the successful changes into the TEST versions of the systems listed above and undertaking UAT to test the upgraded functionality/ processes.
- Obtaining user sign-off of the modified versions of the Educational Psychologist waiting list , Needs Assessment waiting list and the Needs Assessment, repeat DSA process.
- Deploying these changes into LIVE
- Updating the Technical Architecture Document and any other relevant support documentation.
Category
Compliance