COMPUTERIZED TRANSCRIPT MANAGEMENT SYSTEM

CHAPTER ONE

INTRODUCTION

1.1 Background of the Study

A student transcript, the official, cumulative record of the courses taken, grades earned and qualifications attained by a student over the course of an academic programme, is one of the most consequential documents produced by any educational institution. It is relied upon by employers, graduate schools and professional bodies as authoritative evidence of a student's academic history, and its accuracy, security and ready availability are therefore of paramount importance. For decades, the generation and management of transcripts in many institutions has been carried out largely through manual means: student records kept in paper files, academic officers manually compiling grades from multiple semesters, and transcripts typed or handwritten on request. This manual approach to transcript management is not only slow but also highly vulnerable to the misplacement of student records, inconsistent or inaccurate record keeping, and poor overall information management within the school (Abdulkareem & Hatif, 2019).

The growth of database technology and computer-based information systems over the past few decades has offered a clear alternative to this manual approach. Computerization, in this context, refers to the process of migrating student academic records and the transcript-generation workflow from paper-based systems to an electronic database in which records can be entered once, validated, securely stored, and subsequently retrieved and compiled into a transcript with minimal manual intervention. Abdulkareem and Hatif (2019), in their design and implementation of a transcript system for a college of engineering, demonstrated that such a system could retrieve student data directly from a structured database and generate transcripts in a fraction of the time required by manual methods, while also reducing the data-entry and transcription errors that commonly arise, such as mistakes in a student's name or computed average, when records are compiled by hand.

This shift toward computerized transcript management mirrors a broader movement within academic administration toward the automation of student-record processes more generally. Aghware and Ogala (2014) demonstrated the benefits of an automated result management system in verifying and streamlining the manual processes previously used to compile students' examination results, while Ise (2015) proposed extending such systems onto cloud infrastructure in order to make result and, by extension, transcript computation services more affordable and accessible to a wider range of institutions. Eyo and Ofoegbu (2012) similarly showed that a well-designed software application for university students' result processing could substantially reduce the errors and delays associated with the existing manual system. Taken together, this body of work underscores the practicability and value of a computerized transcript management system, one that is capable of easily retrieving and reporting student records with increased data security, reducing the cost and resource burden of transcript processing through reduced data redundancy, easing the workload of school personnel, cutting down the time needed to retrieve student files, reducing the bulkiness of physical files and records, and freeing up storage space previously dedicated to the archiving of paper files. It is the design and implementation of such a system that forms the focus of this study.

1.2 Statement of the Problem

Notwithstanding the well-established benefits of computerized academic record systems, a considerable number of institutions continue to manage student transcripts largely through manual means, with student records kept in physical files and transcripts compiled by hand upon request. This manual approach exposes institutions to a range of persistent problems: student records and transcripts are frequently misplaced or damaged; the retrieval of a particular student's file from among large volumes of stored paper records is slow and labour-intensive; data redundancy across multiple paper files increases both the resources required for record keeping and the likelihood of inconsistencies between records; school personnel responsible for compiling transcripts are often overworked as a result of the manual effort involved; and the physical storage of bulky paper files consumes space that could otherwise be put to more productive use. These problems not only slow down the delivery of transcripts to students, employers and other institutions that rely on them, but also compromise the overall security and integrity of academic records. It is these specific problems inherent in the existing, largely manual system of transcript management that this study seeks to identify in greater detail and to remedy through the design and implementation of a computerized transcript management system.

1.3 Aims and Objectives of the Study

The aim of this study is to identify the problems inherent in the existing system of transcript management, and to proffer a remedy to the existing problem. The specific objectives, framed as the solutions the proposed system is intended to deliver, are as follows:

• Records and reports of students will be easily retrieved, with increased data security.

• There will be a reduction in the amount of resources required, which in turn will lower the cost of processing students' transcripts, since information will be stored in a database with reduced data redundancy.

• School personnel can attend to many students without being overworked.

• There will be a reduction in the time used in the retrieval of students' files.

• There will be a reduction in the bulkiness of files and records.

• It will make available the storage room that was previously used for the storage of files.

1.4 Research Questions

This study seeks to provide answers to the following research questions:

• What are the specific problems inherent in the existing manual system of transcript management?

• How can a computerized transcript management system improve the retrieval speed and security of student records and reports?

• To what extent can a computerized system reduce data redundancy and the cost of processing students' transcripts?

• How can the proposed system reduce the workload of school personnel involved in transcript processing?

• What effect will the computerized system have on the physical storage requirements currently associated with paper-based student records?

1.5 Significance of the Study

This study is significant to school administrators and academic records officers, who stand to benefit directly from a system that reduces the time, cost and physical effort involved in managing and retrieving student transcripts. To students and alumni, who are frequently the ones requesting transcripts for employment, further study or professional certification, the proposed system promises faster turnaround times and greater assurance that the records issued are accurate and free from the transcription errors that can arise in manual processing.

The study is equally significant to the wider body of literature on the computerization of academic administrative processes, extending and applying the design principles demonstrated by Abdulkareem and Hatif (2019), Aghware and Ogala (2014), Eyo and Ofoegbu (2012) and Ise (2015) to the specific problem of transcript management. Finally, the study will serve as a useful reference for future researchers, students and software developers seeking to design, improve upon, or adapt similar computerized transcript management systems for other academic institutions.

1.6 Scope of the Study

This study is limited to the design, development and implementation of a computerized transcript management system for an academic institution. The scope covers the storage of student bio-data and academic records in a structured database, the retrieval and validation of these records, the generation of student transcripts, and the security measures put in place to protect the integrity and confidentiality of the stored data. The study does not extend to other, unrelated academic administrative processes such as admissions processing or fee payment, which, though important, fall outside the immediate focus of this project.

1.7 Limitations of the Study

This study, like most system development projects of its kind, was subject to a number of constraints. The time available for the design, development, testing and documentation of the system was limited, restricting the scope of additional features that could be incorporated into the final application. Access to a large-scale, real-world dataset of student transcripts for extensive testing was similarly limited, meaning that the system was largely tested using sample and simulated data. Financial and resource constraints also limited the extent to which more advanced features, such as blockchain-based verification or biometric authentication, could be incorporated into the system developed for this study. Notwithstanding these limitations, every effort was made to ensure that the resulting system meets the core objectives set out for the study.

1.8 Definition of Terms

Transcript: The official, cumulative record of the courses taken, grades earned and qualifications attained by a student over the course of an academic programme.

Computerization: The process of introducing computers and computer-based systems to perform tasks that were previously carried out manually, with the aim of improving speed, accuracy and efficiency.

Database: An organized collection of structured data stored electronically, which can be easily accessed, managed and updated.

Data Redundancy: The unnecessary duplication of the same piece of data in multiple places within a system, which increases storage requirements and the risk of inconsistency.

Data Security: The set of measures and practices employed to protect stored data from unauthorized access, alteration, loss or theft.

Data Retrieval: The process of accessing and extracting specific pieces of information from a database or storage system.

Academic Records Officer: A member of an institution's administrative staff responsible for the maintenance, processing and issuance of students' academic records.

REFERENCES

Abdulkareem, S. A., & Hatif, Y. N. (2019). Design and implementation a student's transcript system. Diyala Journal of Engineering Sciences, 12(2), 65–70. https://doi.org/10.24237/DJES.2019.12206

Aghware, F. O., & Ogala, J. O. (2014). Automated result management system for students' results processing. Agbor Journal of Science and Science Education (AJOSSE), 2(1).

Eyo, O. U., & Ofoegbu, F. A. (2012). A software application for university students' results processing. Journal of Theoretical and Applied Information Technology, 35(1), 32–41.

Ise, O. A. (2015). A novel framework for student result computation as a cloud computing service. American Journal of Systems and Software, 3(1), 13–19. https://doi.org/10.12691/ajss-3-1-2