Download The automated student result processing system and more Study Guides, Projects, Research Database Management Systems (DBMS) in PDF only on Docsity!
ABSTRACT
The conventional method of processing and accessing student result via a physical effort with the aid of conventional material like pen, pencil, book, ruler and so is cumbersome and very stressful. This project examined an automated student result processing system with respect to the different phases involved in the development of system today, such as system programming and design, program logic, change over style, documentation, and its significance over the manual system of result processing system. The automated student result processing system allow and ensure easy insertion and deletion of student record, and it also allow the user to add and update the record of student in any given semester after the conduction of their continuous assessment and examination in other to generate their Grade Point (GP) and Cumulative Grade Point (CGP) easily. The result processing is highly secured and protected from unauthorized users and this helps to reduce cases of missing student records. In this project work, the user must be given a password and access in which he/she will be the only one having access to every student record after the examination and test has being added together and submitted to him as result processing officer to generate the status and grade point or cumulative grade point of each student. The automated result processing systems enhance the reliability and convenience in computation of student score and generate their respective grade point in each course. The database contains the complete and comprehensive details of each student and their academic performance. This database keeps track of each student course like examination requirement and subject. The project work helps to overcome the problems associated with the manual method of result processing with the aid of the automated system. TABLE OF CONTENTS
Title page………………………………………………………………. …………i Certification……………………………………………………………… ……….ii Dedication……………………………………………………………… …..……iii Acknowledgement ………………………………………………………..……. iv Table of contents ……………………………………………………………..…. v Abstract………………………………………………………………… ….…….vi CHAPTER ONE : INTRODUCTION ....................................................................................... 1 1.1 BACKGROUND TO THE STUDY 1 1.2 STATEMENT OF THE PROBLEM 2 1.3 AIMS AND OBJECTIVES OF THE STUDY 3 1.4 SIGNIFICANCE OF THE STUDY 4 1.5 SCOPE AND LIMITATION OF STUDY 5 1.6 DEFINITION OF OPERATIONAL TERMS 5 CHAPTER TWO: LITERATURE REVIEW .............................................................................. 7 2.1 ACADEMIC PROGRAM EVALUATION 9 2.2 THE MERIT OF COMPUTERIZATION 9 CHAPTER THREE: SYSTEM ANALYSIS AND DESIGN .............................................. 11 3.0 ANALYSIS OF THE EXISTING SYSTEM 11 3.1 WEAKNESS OF THE EXISTING SYSTEM ………………………………………………………………………..
- 2 DATA CAPTURING TECHNIQUES ……………………………………... ………….. 3.3 ANALYSIS OF THE PROPOSED SYSTEM 12 3.4 SYSTEM FLOWCHART & ALGORITHM 13
CHAPTER ONE
INTRODUCTION
As we all know the application of computer is very relevant in every aspect of human life and there is need for everyone to be conversant with the new technology. The computer is used to carry out a task and assist man in business organization, research, education and many aspect of life. The development of computer to be used in office industries, homes as a replacement of manual method of data processing is the best technology that has ever happen to office management. In view of this, it is necessary for student result processing management system in Kogi State Polytechnic Lokoja to be computerized in other to aid the processing of student record on time. Computerization is the process of changing or converting a manual work done into an automated process using a computer. As a result of this, student result processing management system is an automated system that make use of software to enhance the reliability and convenience in computation of student score, generate their respective grade in each course, most of the report are simple text format, for the purpose of fast printing. It also has a document (that is database document) that contains complete comprehensive details of each student and their academic performance. The database keeps track of each student course like exams requirement and subjects. This project work aimed at computerizing the result processing management system in the Department of computer Science, Kogi State Polytechnic Lokoja Kogi State. BACKGROUND OF THE STUDY
HISTORY OF COMPUTER SCIENCE IN KOGI STATE POLYTECHNIC LOKOJA The Department of Computer Science in Kogi State Polytechnic Lokoja was established in 2002 as a unit in the Department of Mathematics/Statistics under the School of Technology. In 2003 there was a need for accreditation to meet up with the National Board of Technical Education (NBTE) requirements. In 2004 the Computer Science Department separated from Mathematic/Statistics Department to become autonomous Department as Mathematic/Statistics. Hall “A” was officially allocated to them and also Mr. Desmond Eneche was appointed as a pioneer Head of Department (HOD) till 2007. One of his responsibilities was to represent and speak for the Department in board meetings. In 2008 the successor of pioneer Head of Department (HOD), Miss Juliet Amadi was appointment as the head while the Department kept producing numerous National Diploma Graduate section by section. In 2009 HND was accredited and they had enough resources put in place to meet up with the requirements. But they were using the manual or conventional method of result processing system. After a new building was allocated to the new HND as a lecture theater 2009. In 2010 Mr. C.I Okoye was appointed as a new HOD in Department of Computer Science invented to produce an automated system of result processing system as he was hopeful that the end of 2010/2011 session the department would produce the first HND Graduate of Computer Science. In 2010/ session Mr. Stanley was appointed as Head of Department (HOD) who try to maintain the automated method of result processing system but Mrs ODEKINA Juliet was re-appointed as the Head of Department (HOD) who took them back to conventional method of processing. In the year 2012 the Department appointed 14 academic staff, 4 nonacademic staff in
1.3 AIMS AND OBJECTIVES OF STUDY
The aim and objective of this project work is to computerized the student result processing system in order to mitigate some of the problem encountered while using the manual method of processing and also to make an easy and fast approach to handle document or student record in the department of computer science. The project work also aims at achieving the following. The time spent during result processing will be reduced due to the speed of computer system. A database for managing students results To develop a query, modules, for easy interaction with the database To have a database on student result, record, were query and validation check can be carry out To eliminate the various problem associated with the manual method and alleviate a flexible method of processing To improve proper documentation of result which a computer is capable of Storing large volume of data over a long period of time. 1.4 SIGNIFICANCE OF THE STUDY There are so many benefit that could be derived from the proposed system when it is fully accepted and implemented. The system will make the student result processing management system Very effective, efficient.
Accurate student registration. Less time constraint Cost reduction of paper used Proper record keeping Better and effective computation of student result 1.5 SCOPE AND LIMITATION OF STUDY This project intends to develop a system that will take over a manual process of obtaining a student result using an automated system capable of handling student’s information and record for the Department of Science ND1 and NDII. It is also capable of data capturing, allow insertion and deletion, updating and viewing operation. This project work is design using Microsoft Access Database, Microsoft Visual Basic 6. (vb. 6.0) as front end. This project does not intended to process CGPA or the transcript of the student. LIMINATION OF STUDY In the course of carrying out this project research work the following are the limitations: Financial constraint Insufficient information from the institution 1.6 DEFINITION OF OPERATIONAL TERM The term use in this project work are defined as follows: AUTOMATED: refer to the use of machine to perform a certain task that is been done manually through human efforts.
COMPUTERIZATION: This is the act of computing a manual work done into an automated process via the use of computer. COMPUTER: This is an electronic device that accept data as an input and uses a set of instructions and logical series of arithmetic (Known as programs) to process the data and produce an output information at a very high and accurate speed.
CHAPTER TWO
LITERATURE REVIEW
According to Advanced Oxford Learners Dictionary “ 6 th Edition” review a student result processing system as an act of analyzing an experiment, practical, and examination being carried out by a student, a statement of good outcome or average grade point to that examination or experiment. In addition to this automated or a computerized students result processing system are discussed by different journals and different project work. OVERVIEW OF RESULT PROCESSING SYSTEM : Humans invented result to enable people and organization to conduct their affairs, experts have given many definitions and understanding about students result processing system. According to Inventional Standard Organization (ISO) in (1985), define result processing system as the act of analyzing an information or an outcome of any experiment practical examination to have a meaningful end point or an average grade point at the end. It also stated that is an act of analyzing an information created or received, and make it as an evident information or result in pursuance of legal obligation or in the examination scheme. In “ 2003 ”, International Committee on Archive (IOA) see result processing as a specific piece of record, information mark of an examination, test, homework and experiment generated, collected or received in the conduct or completion of examination that comprise
Automated Method: This is a computerized method of processing students result without human intervention of any manual or mechanical method. In the work of Oyewole & Obeta (2002) the above terms give a prove that students result processing system either manually or mechanically and automatically is the act of analyzing, collecting a student examination average total score of the student in his/her examination performance. 2.1 ACADEMIC PROGRAM EVALUATION The Polytechnic operates a system of continuous assessment which take into account, a spectrum of academic activities over the semester including formal examinations. According to comprehensives handbook revised edition 2010. Student must attend lecture, laboratory, workshop, training and practical project, undertaking (where applicable) Except in workshop or laboratory base course where a weighting of 20/10 hold practical text, the relative weighing for the entire semester are as follows: Examination = 70% Course work = 30% Assessment of Students, each course must depend on the performance in all course work, test and examination given in the course. Normally a student shall not be permitted to sit for the semester examination if he/she fail to meet the required point at 75% attendance (as applicable) level, the student in the Higher National Diploma (HND) and National Diploma (ND) shall take the prescribe course for four (4) semester.
However, during the period, National Diploma students shall undertake four (4) practical training scheme (SIWES), on passing the prescribe examination and successfully completed the program, such student will be awarded with the appropriate certificate. 2.2 THE MERIT OF COMPUTERIZATION The computerized student result processing system has a lot of advantage over a conventional manual method. This involve the following: Easy to Use: Computerization or an automated result processing system is very easy to use and less time is spent. Less Expensive: The manual method required a lot of expensive materials but an automated system save financial cost. This is because there is no need for the conventional material like pen, paper, and calculator, typewriter. Easy Access to Record: The computerized system enable a particular record to be accessed and retrieved by using a key field in the program. This is not the same with the manual method where a lot of time is wasted or spent in trying to locate a file jacket in a cabinet before getting a particular file. Deletion: The automated system enable a particular record or result to be deleted most especially any one that is no longer needed. Example an expelled student record can easily be deleted using a proposal system. Security: The computerized or an automated system provide adequate security using a password and username for the data or result to be save from an authorize access to record by an eternal body.
CHAPTER THREE
SYSTEM ANALYSIS AND DESIGN
3.0 ANALYSIS OF THE EXISTING SYSTEM
The existing system is a complete manual system. It is absolute and makes work flow in project analysis and monitoring look rigid. It consume a lot of time and does not generate results since it involve human effort to calculate and final computation of result. The existing system requires a lot of human efforts and time, as humans are involved in processing. Processing activities are very slow and not accurate. In order to understand the working operation of the proposed system, the researcher carefully studied existing system and its lapses observed. 3.1 WEAKNESS OF THE EXISTING SYSTEM Processing a large volume of data requires a lot of time It takes a long procedure to updating record The input and output method are tedious and stressful It accept only low or small volume of data due to small storage facilities. The above listed weakness brought about the need to design and implement an automated student result processing system to eliminate the conventional method of processing, support easy computation and save student record via a computer system.
3.2 DATA CAPTURING TECHNIQUE
Data capture technique refers to how data to be used in the project work are being captured. It refers to the medium in which data are supplied and inputted into the program in this project under study. In this project the following methods are used in capturing the data. Interview Method: This is a process of asking question about my project in the depth of Computer Science Department. During the process of data collection, personal interview was conducted with the (HOD) and student in the department which are as follows: What exactly does the old system achieve? What format does the input take? What input document are currently used? Is there any output from the current system or similar system that I can look at? What are the setbacks or problems associated with the current way of processing? What is the level of security? Do you want the system to be computerized? Library Research: The library research was consulted during the design stage to get the relevant information that is related to the project. Record Extract: This is a process of looking into or at an already made document abduct the present system. 3.3 ANALYSIS OF THE PROPOSED SYSTEM The analysis associated with the manual method has made the system almost a total failure, which gives rise to a system that will correct the problem of the existing manual system.
Program Flowchart Login Module
Finding Module
