COURSE REGISTRATION AND RESULT PROCESSING SYSTEM IN COMPUTER SCIENCE DEPARTMENT UNIVERSITY OF NIGERIA, NSUKKA

By

AMAH MARYLYN

Presented To

Department of Computer Science

ABSTRACT

Course Registration and Result processing system form the key activities in the life span of a student. The demand for effective and efficient result computation and output lead to the production of the automated result process. The digitalized process provides the capabilities of centralized repository for storage, management and dissemination of result information to those concerned. A study into the manual process reveals the inefficiencies and the rigorous nature of course registration and result processing, therefore the existing manual process was analyzed and converted into an automated system. The manual activities was modeled with an object-oriented methodology and the system was implemented with PHP(hypertext processor), a scripting language and MYSQL database management systems. It provides a robust database that generates various reports that is relevant to the department. The result of this research work is a system that automates the course registration and examination result processing for the Department of Computer Science, which can be used in any department of most universities in Nigeria.

TABLE OF CONTENTS

LIST OF ITEMS PAGE NUMBER

Title Page …………………………………………………………. i

Certification page …………………………………………………. ii

Approval Page ..………………………………………………… - iii

Dedication …………………………………………………………. iv

Acknowledgement Page ………………………………………… - v

Abstract …………………………………………………………….. vi

Table of Contents.………………………………………………… - vii

List of Figures…………………………………………………… - .. ix

List of Tables……………………………………………………… - xi

Chapter 1: Introduction ………………………………………… 1

1.0 Introduction …………………………………………….. 1

1.1 Statement of Problem .………………………………….. . 3

1.2 Objectives ……………………………………………… . 4

1.3 Scope of the Study ……………………………………….. 4

1.4 Significance of the Study…………………………………. 4

Chapter 2: Literature Review - - - - - - - - - -  5

2.0 Introduction……………………………………………….. 5

2.1 Theoretical Background ………………………………… - 5

2.2 Review of Related Literature………………………………. 10

Chapter 3: Systems Analysis and Design…………………………. 21

3.0 Introduction ……………………………………………… 21

3.1 Analysis of the Existing System………………………….. 22

3.2 Description of the Proposed System……………………… 25

3.3 Design of the Proposed System………………………… - 27

3.3.1 Design Methodology…………………………… - 27

3.3.2 Justification for the use of the design methodology. 27

3.3.3 Design tool………………………………………… 28

3.3.4 Database design…………………………………… 32

3.3.5 Input and output design…………………………… 35

3.4 Systems Architecture………………………………………. 45

Chapter 4: System Implementation………………………………… 46

4.0 Introduction………………………………………………… 46

4.1 Development Environment…………………………………. 46

4.2 Choice of Programming Language used……………………. 47

4.3 Implementations Architecture………………………………. 47

4.4 Software Testing……………………………………………. 48

4.5 Documentation……………………………………………… 49

4.5.1 Software Modules…………………………… - 49

4.5.2 User Guide/Manual…………………………… 52

4.5.3 Software Installation………………………… 54

4.5.4 Source Code Listing……………………… - .54

Chapter 5: Summary and Conclusion………………………………. 55

5.0 Summary……………………………………………………. 55

5.1 Conclusion………………………………………………….. 56

5.2 Recommendations………………………………………….. 56

References

Appendices

LIST OF FIGURES

Figure 3.1 The Use Case Diagram of the System - - - 28

Figure 3.2 The Class Diagram - - - - - 31

Figure 3.3 Screenshot of the Database tables - - - 32

Figure 3.4 The Student’s Login design Form - - - 35

Figure 3.5 Admin Login design Form - - - - 35

Figure 3.6 Student’s Course Registration design Form - - 36

Figure 3.7 Design form of an ongoing course registration - 37

Figure 3.8 Design input form for uploading student’s result - 38

Figure 3.9 Design input form for adding courses - - - 39

Figure 3.10 Design of the Course Registration Printout- - - 40

Figure 3.11 Design of the View Result Form- - - - 41

Figure 3.12 Design of the Semester Transcript Result - - 41

Figure 3.13 Design of the Lecturer’s Grade Sheet - - - 42

Figure 3.14 Design of the Official Semester Broadsheet - - 43

Figure 3.15 Design of the Official Cumulative Broadsheet- - 44

Figure 3.16 System Architecture- - - - - - 45

Figure 4.1 Design of the Implementation Architecture - - 47

Figure 4.2 Screenshot of the Homepage - - - - 60

Figure 4.3 Screenshot of the Admin Login Page - - - 61

Figure 4.4 Screenshot of the Add Course Form - - - 61

Figure 4.5 Screenshot of Uploaded Result file from excel- - 62

Figure 4.6 Screenshot of the Course Registration Form - - 62

Figure 4.7 Screenshot of the Error Registration Page - - 63

Figure 4.8 Screenshot of the Semester Broadsheet Report - 63

Figure 4.9 Screenshot of the Lecturer’s Grade Sheet - - 64

Figure 4.10 Screenshot of the Class List - - - - 65

Figure 4.11 Screenshot of the Semester Transcript Report - 65

Figure 4.12 Screenshot of the Student’s CGPA Report - - 66

LIST OF TABLES

Table 3.1 Sample Table for Calculating Student’s GPA- 24

Table 3.2 Student’s Bio-data Table - - - - 33

Table 3.3 Admin Table - - - - - 33

Table 3.4 Course Table - - - - - 33

Table 3.5 Course Registration Table - - - 34

Table 3.6 Result Table - - - - - - 34

CHAPTER 1: INTRODUCTION

1.0 INTRODUCTION

Automated course registration and exam processing system is a software that facilitates the students course registration and processing of examination result. It will build in an automated information system capability that will ease the stress and enhance all the activities involved in course registration and result processing. The occurrence of examination and assessment irregularities can seriously damage public confidence in the validity and legitimacy of examination and assessment results and should be dealt with as a matter of urgency within the judicial framework established for this purpose[12]. There are different computer programs in different tertiary institutions for computing examination results. However, beyond examination result computation, not many programs in use provide multi-level aggregated data of student population and academic progress at various stages of studentship. The need for data use to inform administrative decisions in tertiary institutions have been emphasized for the purpose of better planning[1]. Almost every section of the educational system requires information processing. With the deployment of a good information system, wear and tear occasioned during data retrieval and handling, and sometimes loss is greatly minimized. Data sharing is less difficult and reproduction becomes a lot more cheaper. Furthermore, information system when employed to the educational sector, prompts the following:- prompt access to students’ personal and course information, instant student information updating, automatic computation of the Grade Point Average (GPA), monitoring of failed courses, quick production of result, storing course information such as course code, course description, course unit and scores for the purpose of GPA computation, and producing user-friendly data entry screens for ease of use. It is unfortunate that most universities in Nigeria still adapt the manual system of course registration and examination result processing. The errors associated with the existing manual method of results computation make it not only desirable but imperative that automated approach be used to the full in measuring students’ progress. The manual methods being employed suffer a number of set-backs. They make the process to be time-consuming and prone to error. They lead to examination results being published late, sometimes with wrong grades being entered and students’ grade point averages being wrongly computed. They also lead to loss or misplacement of student’s result. In some cases, it leads to incoherent course registration. However some departments in some universities in Nigeria are gradually advancing with the new information system processes. Taking the University of Nigeria, Nsukka as a case study,

The current course registration in the university of Nigeria, Nsukka takes the following format. Students on resumption renew their registration and register for courses every new semester. Before the current system was implemented, students register their courses with the different lecturers handling the courses. The list is compiled and sent to the appropriate centre. Later the system improved, a better system came into place where students go online and upon entering their registration number and department, the list of available courses for a particular level for a semester is shown and they register for them by selecting the appropriate box against their chosen courses. This is then submitted online and a printed copy is taken to the appropriate centre for approval. Examination result processing draws all the registered courses together and applies a criteria to process each student’s result at different semesters, session and at the end of the school programme. But the system currently in use poses challenges to the exam officers in the departments. It is observed that students do not register courses as required by the department. This could either be because the students deliberately registered wrongly or the system cannot enlist all the semester courses at a time. Secondly, the current system is unable to enlist all failed courses that were taken in the previous semesters and does not compel students to register them before proceeding to the new ones. It does not have the capability to efficiently reconcile all registered courses with their respective result. Therefore this project work is targeted to eliminate most of the problems inherent in the current system. It would provide a set of structures that keeps databases of all registered courses at all levels enlisting the core courses, electives and required ancilliary courses, it keeps student’s personal information. It will also keep past record of student’s result and a database of all components required for processing results. It will have component that extract each student’s result corresponding to the registered courses and computes the required result at any level and time.

1.1 STATEMENT OF THE PROBLEM

The problems identified in the old system are as follows:

1. The old system does not have a unified database system.

2. There is no structure that compels students to register all outstanding courses before proceeding to the recent ones.

3. Student’s test and exam scores may be entered wrongly when manually done.

5. It is very cumbersome to manually reconcile all registered courses from different files sources into their work sheet for the purpose of result computation.

1.2 AIM AND OBJECTIVES

The main aim of this project work is to provide a centralized database system that prompts correct course registration and keep all result information of a student.

The objectives to realize the aim of this project work are as follows:

1. Enforce a system that would automatically pool fail courses into the student’s registration portal and allow them to register them before they can register new ones.

2. Put in place a unified database system that coordinates course registration and exam processing.

3. Provide a mechanism of transmitting course registration and examintion results to all stakeholders especially Department, Exams and Registry.

4. Produce all kinds of results expected from the university.

1.3 SCOPE OF THE STUDY

The new system designed is meant to handle course registration and exam result processing for the Computer Science department in UNN only.

1.4 SIGNIFICANCE OF THE STUDY

Students stand to greatly benefit from this project work. The new system will enable students to see all failed courses and give them the opportunity to register and rewrite them on time. There would be reduced case of overstay.

Result computation would be easier and convenient for the exam officers as all result information will be kept and generated from the system.

The new system would enhance the result processing performance as it will reduce delay in computing student’s result.