COMPUTERIZATION OF SEMESTER RESULTS OF STUDENTS

CHAPTER ONE

INTRODUCTION

1.1 Background of the Study

Every academic institution, from the secondary school to the university, is under an obligation to accurately record, compute, store and disseminate the results of the continuous assessments and examinations undertaken by its students at the end of every semester or term. For decades, this task was carried out through wholly manual means: a class teacher, subject lecturer, exam officer or result-processing clerk would rely on pen, pencil, ruler, mark sheets, ledgers and broad sheets to record raw scores, add them up, convert them to grades, and finally compute a student's Grade Point (GP) and Cumulative Grade Point Average (CGPA). This manual approach, though it served its purpose for a long time, is slow, laborious, and highly susceptible to arithmetical and clerical errors, particularly as student population grows and the volume of data to be processed increases.

The grading system presently in use across most Nigerian tertiary institutions is the five-point grading scale approved by the regulatory bodies that oversee university, polytechnic and college of education education, a scale that requires every course score to be converted into a letter grade, a grade point, and eventually combined with the credit load of the course to yield a student's semester Grade Point Average and, cumulatively, the CGPA (Eyo & Ofoegbu, 2012). Carrying out this chain of computation by hand for hundreds or thousands of students every semester is not only tedious but also opens the door to inconsistencies that can affect a student's standing, scholarship eligibility or even class of degree at graduation.

The rapid development of computer hardware and software over the last few decades has made it possible to replace these error-prone manual routines with reliable, fast and secure electronic systems. Computerization refers to the process of introducing computer systems and software applications to automate tasks that were previously performed manually. In the context of academic administration, computerization of semester results involves designing a database-driven application that allows authorized personnel to input scores, automatically compute grades, GPA and CGPA, store the records securely, and retrieve or print statements of result and transcripts on demand (Abel & Abu, 2013). Several researchers have demonstrated the practicability and benefits of this shift. Aghware and Ogala (2014) developed an automated result management system specifically to verify and replace the manual processes used for generating students' examination results in a Nigerian tertiary institution, reporting a marked improvement in speed and accuracy of result generation. Similarly, Nmaju, Nwachukwu and Ugwu (2013) designed a web-based student academic records information system that eliminated the delays traditionally associated with computing results and processing academic documents, while also providing an interface through which students could conveniently access their own academic records.

More recent efforts have gone beyond simple automation to explore how emerging technologies can further improve result processing. Ise (2015), for instance, proposed a cloud-based framework for student result computation, arguing that hosting the result-processing service on the cloud removes the burden of expensive on-premises infrastructure while still delivering the core benefits of automation: speed, accuracy, security and easy access. Taken together, this growing body of work confirms that computerization is now widely regarded, both within Nigeria and internationally, as the most practical solution to the age-long problems associated with manual semester result processing. It is against this background that this study sets out to design and implement a computerized system for the processing of students' semester results, one that will allow authorized users to insert, update, compute, store, retrieve, and protect student academic records with a level of speed, accuracy and security that the manual method can never match.

1.2 Statement of the Problem

Despite the well documented advantages of computerized result processing, a considerable number of educational institutions, departments and even individual lecturers still rely, in whole or in part, on manual methods to compute and manage students' semester results. This manual approach is cumbersome and stressful for the staff involved, and it exposes the entire result-processing exercise to a number of serious problems. First, computing GP and CGPA by hand for a large number of students is time-consuming, and any single arithmetical slip in one course score can distort a student's entire semester result. Second, records kept on paper, in ledgers or on loose broad sheets are vulnerable to damage, misplacement or outright loss, a situation that can lead to disputes over a student's genuine academic standing and, in the worst cases, delay a student's graduation. Third, because manual records are not password protected, they are easily accessed, altered or tampered with by unauthorized persons, which raises serious concerns about the integrity and security of academic records (Ise, 2015).

Furthermore, retrieving a particular student's result from among thousands of paper records, or generating a comprehensive class list, statistical summary, or transcript, is an extremely tedious undertaking when performed manually. This inefficiency does not only affect the examination officers and lecturers who prepare the results, but also the students, who often experience unnecessary delay in the release of their results, and the institution's management, who may lack timely and accurate data on which to base academic decisions. It is these persistent challenges of speed, accuracy, security, storage and easy retrieval that this study seeks to address through the design and implementation of a computerized semester result processing system.

1.3 Aim and Objectives of the Study

The study aims to develop a computerized school assessment system. The following are the objectives of the study:

• The time spent during semester result processing will be reduced due to the speed of computer system.

• A database for managing students' semester results.

• To develop a query, modules, for easy interaction with the database.

• To have a database on student semester result, record, were query and validation check can be carry out.

• To eliminate the various problem associated with the manual method and alleviate a flexible method of processing.

• To improve proper documentation of semester result which a computer is capable of.

• Storing large volume of data over a long period of time.

1.4 Research Questions

In order to achieve the objectives stated above, the study seeks to provide answers to the following research questions:

• What is the extent of the challenges associated with the manual method of processing students' semester results?

• How can a computerized system reduce the time and effort spent in generating semester results compared with the manual method?

• What database structure and query modules are required to efficiently manage and retrieve student semester result records?

• How can the automated system ensure adequate security and restrict access to student records to only authorized personnel?

• To what extent can a computerized result processing system improve the accuracy, storage and documentation of students' semester results over a long period of time?

1.5 Significance of the Study

This study is significant to a wide range of stakeholders within the educational sector. To the examination officer or result-processing officer, the proposed system will drastically cut down the time and effort required to compute, verify and release semester results, while the built-in password protection will safeguard student records from unauthorized access, alteration or loss. To students, the system promises faster release of accurate results and, ultimately, a more reliable academic record on which their grade point and cumulative grade point averages are based. To the institution's management, an automated result database provides an easily searchable, well-documented and long-term store of academic performance data that can support planning, accreditation exercises and policy decisions.

The study is equally significant to the academic community, as it adds to the growing body of literature on the computerization of academic administrative processes in Nigerian and other developing-country institutions, building on and extending the work of scholars such as Aghware and Ogala (2014), Nmaju et al. (2013) and Ise (2015). Finally, the study will serve as a useful reference material for future researchers, students and software developers who may wish to design, improve upon, or adapt similar semester result processing systems for other institutions.

1.6 Scope of the Study

This study is limited to the design, development and implementation of a computerized system for processing the semester results of students within an academic department or institution. The scope covers the registration and maintenance of student bio-data and course records, the entry of continuous assessment and examination scores by an authorized result-processing officer, the automatic computation of grades, Grade Point and Cumulative Grade Point Average, the secure storage of these records in a database, and the retrieval, editing and printing of individual or class result statements. The study does not extend to the computerization of other unrelated academic administrative functions such as fee payment, admission processing, or hostel allocation, which, though important, fall outside the immediate focus of this project.

1.7 Limitations of the Study

Like most system development projects of this nature, this study was subject to a number of constraints. The time available for the design, coding, testing and documentation of the system was limited, which restricted the scope of features that could be incorporated into the final application. Access to a large, real-world dataset of student results for extensive testing was also limited, so the system was largely tested with sample and simulated data. In addition, financial constraints limited the extent to which more advanced infrastructure, such as cloud hosting or biometric authentication, could be incorporated into the prototype developed for this study. Notwithstanding these limitations, every effort was made to ensure that the system developed meets the core objectives set out for the study.

1.8 Definition of Terms

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.

Semester Result: The official record of a student's performance in the courses offered during a given semester, usually expressed in scores, grades and grade points.

Grade Point (GP): A numerical value assigned to a letter grade obtained by a student in a course, often multiplied by the credit unit of the course to determine the student's weighted performance.

Cumulative Grade Point Average (CGPA): The average of a student's grade points across all courses taken from the point of admission up to a given point in the academic programme.

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

System: A set of interrelated components, including hardware, software and procedures, that work together to achieve a specific objective, such as processing student results.

Query: A request made to a database to retrieve, update, insert or delete specific pieces of information.

REFERENCES

Abel, U. O., & Abu, M. (2013). Data analysis and result computation (DARC) algorithm for tertiary institutions. IOSR Journal of Computer Engineering, 14(1), 63–69.

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

Nmaju, O., Nwachukwu, E. O., & Ugwu, C. (2013). A novel web-based student academic records information system. West African Journal of Industrial and Academic Research, 7(1), 45–56.