Educate Management system

My client currently managing its student’s data using the system called Educate which is a web-based and built on Java platform. The Educate system uses MySql as it database management system. One of the most critical student’s data that being handle by this system is the student’s assessment and exam result. The grading is based on the Grade Point Average (GPA) calculation. They has intent to improve the performance of the Examination module in the following areas: 1) Mark entry interface 2) Semester based assessment (assignment, attendance, etc.) mark distribution schema 3) Report on student’s subject enrolment status Detail Description a. Mark entry interface The current interface provides access to administrator of the Exam Unit to enter marks for both assignments as well as exam result. The lecturers are also given the access to enter their students’ marks. The Educate system has a control panel to manage the access to the lecturer. The new interface shall provide better interface in such a way that it will allow the use of arrow keys to move around the mark text box fields easily between one student’s records to the other. The page must also implement AJAX technology whereby the totalling and checking of marks validity will be done instantaneously. The auto saving feature shall also be incorporated to avoid any loss of data in the case of any unforeseen circumstances such as loss of connection, electricity cut off or other problems. b. Semester based schema The current system allows only one schema of mark distribution for each subject to be set. One the schema is set and utilize, administrator is not allowed to change it because it will affect the whole calculation of the grade point average (GPA) for the student. The new engine of GPA calculation need to be developed which will allow administrator to change the mark distribution schema for assessment every semester whenever required. The newly calculated GPA data will be inserted to the existing final result table. The final result data will be consumed by the existing Student Transcript module to display the result transcript to the student. c. Subject enrolment status The current system has not implemented this feature fully. The new engine to be developed will provide the function for exam or school administrator to create the subject required schema for each program offered by my client. The subject schema will be the reference to generate the report for each student subject enrolment status. The subject schema for a programme may vary for different intake or batch of student. This reporting module must allow the user to change the schema according to any particular student. A list of taken and need to be taken with other detail info shall be listed by the reporting engine. Some filtering function such as choice of school, programme or intake must be implemented. A dedicated screen for individual student access must also be provided. 1. External Interface Requirements The module to be developed will be deployed on an application server. The server will run an Apache application server. The MySql database system will be hosted on a different server on the same network. The vendor must be able to deploy the newly developed engine in this environment. 2. Other Requirements The interface developed for task a) and b) as described above – Detail Description, will be deployed in a few different portals, the student portal as well as lecturer portal and others. So the design of the interfaces must be independence of each other to make the deployment on different web-based portal possible.