AN ENHANCED ONLINE RESULT PROCESSING SYSTEM FOR THE INFORMATION MANAGEMENT TECHNOLOGY DEPARTMENT
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
Title page i
Certification ii
Dedication iii
Acknowledgement iv
Abstract v
Table of Contents vi
CHAPTER ONE
INTRODUCTION1
Background of Study1
Statement of the Problem5
Objectives of the Study7
Significance of the Study8
Scope of the Study8
Limitations of the Study 9
Definition of Technical Terms10
CHAPTER TWO
LITERATURE REVIEW14
Introduction14
Computer Systems and Other Related Concepts15
Result Processing and Associated Concepts23
Processing23
Problems Associated with Data Processing24
Formats of Result25
Computer Systems and Result Processing26
Result Processing Stages26
Modes of Result Processing27
CHAPTER THREE
METHODOLOGY AND SYSTEM ANALYSIS29
Introduction 29
Problem Identification30
Method of Data Collection31
Interviewing31
Observation32
Evaluation and Inspection of Documents32
Problems of the Existing System32
Analysis of the Current System33
The Organization and Its Environment34
Analysis of the Proposed System36
CHAPTER FOUR
SYSTEM DESIGN AND IMPLEMENTATION40
Introduction40
Objectives of the New System40
System Design42
Program Design44
General Flowchart of the Proposed System 45
Program Specification Flowchart46
Program Module Flowcharts47
Program Modules50
Database Specification51
Data Dictionary51
Input/Ouput Design60
Input Specifications and Design61
Output Specifications63
Choice of Programming Language64
Program Documentation and Implementation67
System Implementation67
Hardware and Operating System Requirement67
Software Specifications67
Requirements for Processor68
RAM Size68
Disk Space68
Run/Operate the Software 69
Detailed Implementation Plans69
File Conversion69
Training of Operators and Users70
CHAPTER FIVE
SUMMARY, CONCLUSION AND RECOMMENDATIONS71
Summary71
Conclusion72
Recommendations73
REFENRENCES
APPENDIX A: PROGRAM SCREENSHOTS APPENDIX B: PROGRAM SOURCE CODE
LIST OF FIGURES
Federal University of Technology, Owerri Organogram35
Block diagram of the system39
Conceptual Design of a System43
General Flowchart of the Proposed System46
Base Record Setup47
Enrolment Flowchart48
Validation Flowchart49
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
INTRODUCTION
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
S/NO FACULTY NUMBER OF
DEPARTMENTS
1 Engineering and Engineering Technology 9
2 Sciences 11
3 Management Technology 6
4 Agriculture and Agricultural Technology 7
5 Health Technology 5
6 Environmental Technology 6
* TOTAL 44
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.
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.
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.
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.
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.
Limitations of Study
In the course of this design, some factors led to constraints in the effective actualization of the project.
⦁ 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.
·
⦁ 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.
⦁ There is not sufficient knowledge in the programming languages chosen for this work which led to involving upper hands at an expense.
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).
.