Design And Implementation Of An Enhanced Online Result Processing System

---

Abstract

---

The end-of-course grades assigned by lecturers are intended to convey the level of achievement of each student in the class. These grades are used to make a multitude of decisions. Unless a sufficiently accurate and efficient method is used for the grading, the grades are apt to convey misinformation and lead the decision-maker astray. In itself, the processing of results is found to be rather tedious, especially when carried out manually, and when the number of students is large. It is time-consuming and error prone. The process, however, becomes a lot easier and much more accurate when carried out with a computer running a suitable software application. To find a sufficiently fast and accurate method of carrying out this processing is a problem that is both challenging and interesting. In this work, a computer software application was developed to facilitate the automated processing of the results. The software was developed in Java programming language in the form of a database, employing PostgreSQL Relational Database Management System. The developed software performed well and produced expected results on completion. With it, it was possible to compute Grade Point Average and Cumulative Grade Point Average for each student based on examination scores entered being the core idea behind the design.

---

Table Of Contents

---

Preliminary Page(s)

• Title page
• Certification
• Dedication
• Acknowledgement
• Abstract
• Table of Contents

---

Chapter One

1.0 Introduction

• 1.1 Background of Study
• 1.2 Statement of the Problem
• 1.3 Objectives of the Study
• 1.4 Significance of the Study
• 1.5 Scope of the Study
• 1.6 Limitations of the Study
• 1.7 Definition of Technical Terms

---

Chapter Two

2.0 Literature Review

• 2.1 Introduction
• 2.2 Computer Systems and Other Related Concepts
• 2.3 Result Processing and Associated Concepts
• 2.3.1 Processing
• 2.3.2 Problems Associated with Data Processing
• 2.3.3 Formats of Result
• 2.4 Computer Systems and Result Processing
• 2.4.1 Result Processing Stages
• 2.4.2 Modes of Result Processing

---

Chapter Three

3.0 Methodology And System Analysis

• 3.1 Introduction
• 3.2 Problem Identification
• 3.3 Method of Data Collection
• 3.3.1 Interviewing
• 3.3.2 Observation
• 3.3.3 Evaluation and Inspection of Documents
• 3.4 Problems of the Existing System
• 3.5 Analysis of the Current System
• 3.6 The Organization and Its Environment
• 3.7 Analysis of the Proposed System

---

Chapter Four

4.0 System Design And Implementation

• 4.1 Introduction
• 4.2 Objectives of the New System
• 4.3 System Design
• 4.4 Program Design
• 4.5 General Flowchart of the Proposed System
• 4.6 Program Specification Flowchart
• 4.6.1 Program Module Flowcharts
• 4.6.2 Program Modules
• 4.7 Database Specification
• 4.8 Data Dictionar
• 4.9 Input/Ouput Design
• 4.9.1 Input Specifications and Design
• 4.9.2 Output Specifications
• 4.10 Choice of Programming Language
• 4.11 Program Documentation and Implementation
• 4.11.1 System Implementation
• 4.11.2 Hardware and Operating System Requirement 6
• 4.11.3 Software Specifications
• 4.11.4 Requirements for Processor
• 4.11.5 RAM Size
• 4.11.6 Disk Space
• 4.11.7 Run/Operate the Software
• 4.11.8 Detailed Implementation Plans
• 4.11.10 File Conversion
• 4.11.11 Training of Operators and Users

---

Chapter Five

5.0 Summary, Conclusion And Recommendations

• 5.1 Summary
• 5.2 Conclusion
• 5.3 Recommendations
• References
• Appendix A: Program Screenshots
• Appendix B: Program Source Code

---

List Of Figures

---

• 3.1 Federal University of Technology, Owerri Organogram 35
• 3.2 Block diagram of the system 39
• 4.1 Conceptual Design of a System 43
• 4.2 General Flowchart of the Proposed System 46
• 4.3 Base Record Setup 47
• 4.4 Enrollment Flowchart 48
• 4.5 Validation Flowchart 49

---

List Of Tables

---

• 1.1 FUTO Faculties and associated number of departments 4

---

Database Tables

---

• 4.1 Academic Session 52
• 4.2 User Country 52
• 4.3 Course 53
• 4.4 Degree 53
• 4.5 Degree Class 54
• 4.6 Department 54
• 4.7 Faculty 55
• 4.8 Grade 55
• 4.9 Level of Study 56
• 4.10 Result 56
• 4.11 Semester 57
• 4.12 Sex 57
• 4.13 Staff 58
• 4.14 State 59
• 4.15 Title 59
• 4.16 Validation Record 60

---

Chapter One

---

1.0 Introduction

1.1 Background of Study

The errors associated with the existing manual method of processing of students’ results in most universities in Nigeria, including the Federal University of Technology, Owerri, make it not only desirable but imperative that computerized approach be used to the full in measuring students’ academic progress. The manual methods being employed suffer a number of set-back. They make the process to be time-consuming and prone to errors even as they lead to late publication of examination results. Worst still, sometimes wrong grades are being entered and students’ grade point averages are computed wrongly. Consequently, the cumulative errors being generated are ultimately linked to awarding of erroneous class of degree. Some students could end up with undeserved good classes of degree, while others could be unfairly victimized, bringing about frustration. In this case, the image of the department(s) concerned and the whole University alike could become tarnished. The problem, therefore, that arises is to find a method of processing examination results that would be sufficiently accurate and reasonably timely.

Result processing is a routine activity. Every semester in the higher institution calls for assessment of the performances of the students. This assessment usually comes in the form of examinations, tests, practicals, labs, and the like. Without an assessment of the students, there will not be the need to work hard.

Assessment takes the form of a reward system. Students are interested in a competitive environment. Tracing this to the primary and secondary school systems where the students are graded in positions; each student works very hard to make the best results. The higher institution system is no difference. At the end of each academic semester, the results of the semester academic activities are computed. The issue here is in the conversion of the levels of involvement and expertise of the students into relative figures which ranks the students.

There are over forty (40) departments in the Federal University of Technology, Owerri (FUTO), each having an average of over four hundred students. A simple calculation here surfaces that there are over sixteen thousand students in FUTO; excluding the post graduate and pre degree students. Each of the students in every level has results to be computed. The task of result processing and other academic activities mandates the assignment of course advisers to take care of such functions.

Result, by way of definition is the consequence of an action; the conclusion of a problem, or experiment after a period of time. At the end of each academic semester, the results of the exams, tests, practicals and labs are calculated and the grades are correspondingly computed. This is done by the various course coordinators of the courses. The next phase of the result processing process is done by the level course adviser. Each level of every department has its own dedicated course adviser. The course adviser acts on the list of results of all the students in his/her level and those of other students who sat for courses in other levels; either as borrowed courses or as carry over courses. The task ahead of the course adviser is to convert the grades of the students submitted to him into grade equivalents.

The Federal University of Technology, Owerri (FUTO) is characterized by six faculties. The faculties with the associated number of departments are tabulated below.

Table 1.1: FUTO Faculties and associated number of departments

In Universities like FUTO, the need for automated method of keeping data has been there. There have been several attempts to develop systems for automating result processing, but most of the work of this project will be on the processing of the results of the students at the undergraduate levels; and also span across other course advisers’ functions. With Information Management Technology department as the organization’s case study, this work is focused on providing alternative solutions to the general problems associated with result processing, adding and dropping of courses, registration of extra course units, timely computation of students’ grades, course registrations, and above all, security issues which hinders unauthorized access to results by students and lecturers.

---

1.2 Statement of the Problem

The problems posed by manual methods of result processing are enormous. The situation is the same in Federal University of Technology, Owerri and correspondingly, Information Management Technology department. The issues here can only be addressed by employing upper hands. The effort expended in the process of registration of students and computation of their examination results is tedious. Quite worrisome is the fact that these processes are carried out every academic session, putting the operators in a continuous and ever demanding cycle. The computation of examination results and registration of students is obviously an object-centered activity, the student being the dominant object in this case. Hence, the need to evolve not just a computerized process, but an object-oriented software design and implementation that will effectively and efficiently capture all the important objects associated with the registration and examination result processing within the University and the interactions among the objects.

This genuine and noble desire necessitated the design and implementation of a result processing application for a course program, with Information Management Technology as the organization in question.

So many softwares have been developed and even sold worldwide to solve this problem but most of such softwares have been discovered to be inefficient. Another problem which these softwares have posed is non-user specific problems as they are rather general use softwares, than specific use softwares. Students as well has researched and developed their own software but they could not give or develop error free software that will assist in result generation, automated course registration to keep or build a database of results in the university that will facilitate students’ transcripts.

This problem has been procrastinating the results of graduating or graduated students hence, delay in leaving for the National Youth Service when they ought to have gone. This problem has dominated the system especially in the department of case study, Information Management Technology Department.

To arrest this problem, there is a need to develop software that is accurate, error free, and that can run on the web (using real time) in order to give students access to their results as at when needed. This will also help reduce the queue usually seen at the course advisers’ office during result’s check and in turn tackle the so much stress on both exams and record and the management in Universities.

---

1.3 Objectives of the Study

The objective of this project is to design and develop system that can:

1. Provide a reliable solution to result processing that is corruption free.
2. Ensure that normal credit load in line with the school is maintained.
3. Provide a software that will generate result that is accurate, timely and error free.
4. Maintain a reliable database for storage of students’ records and update as the need arises.
5. Restrict unauthorized access to the students’ record.
6. Provide an advice engine based on the current status of the student advices the student result which on the next course of action to take in his/her academic pursuit.
7. Produce relevant report of students’ general performance at the end of every academic semester, presented in the form of tables, charts and graphs, etc.

---

1.4 Significance of the Study

The project work will help in a good number of ways to ease the delay in manual examination processing. The software developed will help schools management to achieve efficient Information Management System. There are many other advantages, and some of them are listed below.

1. It saves time during examination processing.
2. Database for course registration and examination result is maintained.
3. References are very fast and delays can be avoided.
4. It allows easy access to stored information.
5. It provides a medium for the students to interact and discuss their results and the way forward of their academics.
6. It helps in reducing the costs such as labor, inventory and stationery.
7. Generation of accurate results/information on transactions is ensured.
8. It guarantees the students unshared access to their individual results.

---

1.5 Scope of the Study

This research work will concentrate on course registration and examination processing system, as well as course adviser functions provided in an automated format which enables the course adviser, the Head of Department, seen here as the enroller and the validator respectively, as well as the student to interact with the application effectively. This work will also use Information Management Technology department as the organization in question for its development. The system developed will only cover registration of students, course registration, result processing, advising functions, course creation and mapping and security of students’ record functions.

---

1.6 Limitations of Study

In the course of this design, some factors led to constraints in the effective actualization of the project.

1. The duration for this project was too small for the study to be carried out in a more complex scope. There were some other programmes like exams, to be attended to which curtailed the time spent on the project. The above constraint led to limiting the application functionalities.
2. The limited resources available for carrying out this project posed a major constraint. There was much work to be done but, limited cash was available. The available related materials in this research topic were insufficient and some of the respondents were unwilling to supply useful information.
3. There is not sufficient knowledge in the programming languages chosen for this work which led to involving upper hands at an expense.

---

1.7 Definition of Technical Terms

Information System:

It is a collection of procedures, people, instructions and equipment to produce information in a useful form.

Technology:

It is study of techniques or process of mobilizing Resource (such as information) for accomplishing objectives that benefits man and his environment.

Information:

Information can be defined as the process of gathering, transmitting, receiving, storing and retrieving data or several items put together to convey a desired message.

Computer Network:

Computer Network is a system that connects two or more computers together using a communication link.

Databases:

A systematically arranged collection of computer data, structured so that it can be automatically retrieved or manipulated. It is also called databank.

File Transfer:

Any kind of computer file can be sent via the Internet from one Internet user to another. Table of accounts on spreadsheets, design by a graphic artists, music sound files etc, can all be exchanged in this way.

Database Table(s):

It is a collection rows and columns where in the database which are used for logical data storage and retrieval in the database.

Database Management System (DBMS):

This is the software that performs the task of database management.

Transaction:

This is a group of operation (database operations) that must be executed as one.

Encapsulation:

This is the concept of hiding specific behavior and attributes from a user.

Class:

This is the prototype from where an object can be created.

Object:

This is an instance of a class that which has both attributes and behaviors.

Inheritance:

This is the one of the features of Object Oriented Programming (OOP) that gives it the capabilities or properties of a class.

Entity:

This is an object with a set of properties that makes it easily identifiable.

Attributes:

There are the properties of an entity. They provide information about and entity and also differentiate one entity from anther.

Relationship:

This refers to the association among entities.

Entity Relationship Diagram:

This is the pictorial representation of a database. It lists the various components of a database and depicts the relationships between components in the database.

Programming Language:

This is the language used to give instructions to the computer.

Structure Query Language (SQL):

This is a very high level programming language that is used to query the database

Java Programming Language:

This is an object oriented programming language that is used to develop different types of software application.

Programmer:

Someone who can read, understand one or two programming(s) and has the ability to develop software applications using some programming languages.

Application Programming Interface (API):

This is a class library that provides a collection of classes which the programmer may take advantage of when programming.

Java Database Connectivity (JDBC):

This is a Java API for communicating with different database systems.

Method:

This is a data member of a class which is used by the objects of such class for performing its actions.

Constructor:

This is a method like construct that has the same name as the class. It is also used to create an object.

Java platform 2 Standard Edition (J2SE):

This is the technology platform used in developing standalone applications

Java platform 2 Enterprise Edition (J2EE):

This is the technology platform used in developing enterprise applications (web based applications).

Java platform 2 Micro Edition (J2ME):

This is the technology platform used in developing mobile applications (software for mobile devices).

---

Chapter Five

---

5.0 Summary, Conclusion And Recommendations

5.1 Summary

This research work focuses on the use of computer system with reference to course registration, result processing in Information Management Technology department of Federal University of Technology, Owerri.

The work covers the manual system of opertions as regards the problems identified, stating the aims of the new system, stating the various specifications and then implementing the programs. The work was successufully developed using Java programming language, a user- friendly programming language, and the package was tested and improved upon which yielded an automated course registration, examination processing and transcript processing system.

The project work cannot be said to be perfect, but however, its benefits cannot be overemphasized. It has led to the improvement in the speed of processing operation, efficiency, accuracy and improved storage of data.

An Enhanced Online Result Processing System for Information Management Technology Department, FUTO

---

5.2 Conclusion

Realizing a project of this nature is very exciting. However, the students encounter a lot a problem which I believe if looked into, will go a long way toward reducing the tension associated with the design implementation and construction of the project.

In spite of the constraints encountered during the implementation of this project, the aim of my project is well accomplished.

Moreover, an attempt to accomplish this project has taken care of the delay between examination and result processing with minimum mistakes. This has also forced me to learn, practically, what is involved in the design and implementation or computerization of project (existing or non-existing).

Finally, I wish to commend the university system and indeed the department of Information Management Technology for this project inclusion as a course that must be taken by graduating students it is a step in the right direction to withstand the future challenges in computing in companies, industries, institutions and the world at large.

An Enhanced Online Result Processing System for Information Management Technology Department, FUTO

---

5.3 Recommendations

Based on the achieved objective of this project and the experiences gained during its designed and implementation, I wish to make the following recommendations for future improvement.

1. Students should be exposed to serious practical exercise during the course of their studies. In this regard, the students of Information Management Technology department should be made to write at least a working program with veritable results before graduating. This could be accomplished by providing more computers qualified lecturers in the department.
2. Tertiary institutions should computerize their result processing system for greater efficiency, neatness, and reliability. This will go a long way to save the student all the trouble they go through trying to get their results in one form or the other.
3. Finally, the students’ project should be closely supervised and monitored to achieve more success.

---

How To Get The Complete Material For “Design And Implementation Of An Enhanced Online Result Processing System“

---

---

---

The Complete Material Will Be Sent to Your Email Address After Payment
( Quick & Simple)

FOR CLIENTS IN NIGERIA:

CLICK HERE TO MAKE PURCHASE (₦3,000)

---

FOR CLIENTS OUTSIDE NIGERIA:

CLICK HERE TO MAKE PURCHASE ($15)

---

  Contact Our Help Desk