DEVELOPMENT OF A REPORTING SYSTEM FOR FACILITATING ONLINE ANALYTICS OF STUDENT ACADEMIC RECORDS

Abstract

This study identified an existing challenge in the area of analysis of student records and the use of reports for decision making process in higher institution. It thereafter developed a computerized web-based online reporting system that can be adopted by academic institutions to assess and review academic performance based on student academic records by identifying the requirements of the system, specifying the design and implementing the designed system. In order to meet the outlined objectives, a review of literature was carried out to understand the existing systems and their limitations after which informal interviews were conducted with prospective users so as to identify the requirement of the system which was the designed using appropriate unified modelling language (UML) diagrams. Finally, the system was implemented with Microsoft’s ASP.NET MVC framework for the frontend, Microsoft SQL Server for the database and C# as the scripting language. This study at the end of its implementation delivered a web-based reporting system that allows users of three varying roles to access different levels reports of academic performance of student based on their roles dashboards as well as allow course lecturers to create and administer online quizzes to student which results will then be used to generate different new reports on the dashboard. The study is then concluded with a summary of the result and recommendation of future actions in relation to this study