AN ENHANCED ONLINE RESULT PROCESSING SYSTEM FOR THE INFORMATION MANAGEMENT TECHNOLOGY DEPARTMENT


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).

.


TYPE IN YOUR TOPIC AND CLICK SEARCH.






RESEARCHWAP.COM

Researchwap.com is an online repository for free project topics and research materials, articles and custom writing of research works. We’re an online resource centre that provides a vast database for students to access numerous research project topics and materials. Researchwap.com guides and assist Postgraduate, Undergraduate and Final Year Students with well researched and quality project topics, topic ideas, research guides and project materials. We’re reliable and trustworthy, and we really understand what is called “time factor”, that is why we’ve simplified the process so that students can get their research projects ready on time. Our platform provides more educational services, such as hiring a writer, research analysis, and software for computer science research and we also seriously adhere to a timely delivery.

TESTIMONIES FROM OUR CLIENTS


Please feel free to carefully review some written and captured responses from our satisfied clients.

  • "Exceptionally outstanding. Highly recommend for all who wish to have effective and excellent project defence. Easily Accessable, Affordable, Effective and effective."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "I saw this website on facebook page and I did not even bother since I was in a hurry to complete my project. But I am totally amazed that when I visited the website and saw the topic I was looking for and I decided to give a try and now I have received it within an hour after ordering the material. Am grateful guys!"

    Hilary Yusuf, United States International University Africa, Nairobi, Kenya.
  • "Researchwap.com is a website I recommend to all student and researchers within and outside the country. The web owners are doing great job and I appreciate them for that. Once again, thank you very much "researchwap.com" and God bless you and your business! ."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "I love what you guys are doing, your material guided me well through my research. Thank you for helping me achieve academic success."

    Sampson, University of Nigeria, Nsukka.
  • "researchwap.com is God-sent! I got good grades in my seminar and project with the help of your service, thank you soooooo much."

    Cynthia, Akwa Ibom State University .
  • "Great User Experience, Nice flows and Superb functionalities.The app is indeed a great tech innovation for greasing the wheels of final year, research and other pedagogical related project works. A trial would definitely convince you."

    Lamilare Valentine, Kwame Nkrumah University, Kumasi, Ghana.
  • "Sorry, it was in my spam folder all along, I should have looked it up properly first. Please keep up the good work, your team is quite commited. Am grateful...I will certainly refer my friends too."

    Elizabeth, Obafemi Awolowo University
  • "Am happy the defense went well, thanks to your articles. I may not be able to express how grateful I am for all your assistance, but on my honour, I owe you guys a good number of referrals. Thank you once again."

    Ali Olanrewaju, Lagos State University.
  • "My Dear Researchwap, initially I never believed one can actually do honest business transactions with Nigerians online until i stumbled into your website. You have broken a new legacy of record as far as am concerned. Keep up the good work!"

    Willie Ekereobong, University of Port Harcourt.
  • "WOW, SO IT'S TRUE??!! I can't believe I got this quality work for just 3k...I thought it was scam ooo. I wouldn't mind if it goes for over 5k, its worth it. Thank you!"

    Theressa, Igbinedion University.
  • "I did not see my project topic on your website so I decided to call your customer care number, the attention I got was epic! I got help from the beginning to the end of my project in just 3 days, they even taught me how to defend my project and I got a 'B' at the end. Thank you so much researchwap.com, infact, I owe my graduating well today to you guys...."

    Joseph, Abia state Polytechnic.
  • "My friend told me about ResearchWap website, I doubted her until I saw her receive her full project in less than 15 miniutes, I tried mine too and got it same, right now, am telling everyone in my school about researchwap.com, no one has to suffer any more writing their project. Thank you for making life easy for me and my fellow students... Keep up the good work"

    Christiana, Landmark University .
  • "I wish I knew you guys when I wrote my first degree project, it took so much time and effort then. Now, with just a click of a button, I got my complete project in less than 15 minutes. You guys are too amazing!."

    Musa, Federal University of Technology Minna
  • "I was scared at first when I saw your website but I decided to risk my last 3k and surprisingly I got my complete project in my email box instantly. This is so nice!!!."

    Ali Obafemi, Ibrahim Badamasi Babangida University, Niger State.
  • To contribute to our success story, send us a feedback or please kindly call 2348037664978.
    Then your comment and contact will be published here also with your consent.

    Thank you for choosing researchwap.com.