DESIGN AND IMPLEMENTATION OF ACADEMIC TRANSCRIPT MANAGEMENT SYSTEM
ABSTRACT
This research paper examined the inadequacies involved in the manual method of generating students’ transcript in Akwa Ibom State Polytechnic. To achieve that, preliminary investigations about the current manual record keeping were carried out at the school. The problems with the manual result processing were identified and a new system was proposed, designed, and implemented. In this work, a computer software application was developed to facilitate the automated processing of the results. The software was developed Java programming language and MYSQL (My Structural Query Language), a relational database management system in designing the database; tested and found to have produced the expected results. Teachers do not need to draw vertical/horizontal lines on a broad sheet of paper for recording students test and exam scores, and also need not to do any form of calculations, as the system does virtually everything. Similarly, there is no need of printing result booklet for each student. Results can be printed on A4 size paper or on embossed cardboard paper cut into A4 size and which appears like a certificate and looks more beautiful at a lower cost compared to the cost of printing result booklets and the stress teachers have to undergo to prepare students results. The software will make the teacher’s job less stressful by cutting down the time and effort spent on result preparation, thereby, allowing the teacher more time for teaching and other instructional issues. This new system is flexible and can be modified to suit any kind of students’ record keeping and data processing in both public and private secondary schools.