ABSTRACT
This research work focused on the development of a Dossier Record System using State College in Ikot Ekpene as a case study. The study was necessary because of the problems of the existing system which included: manual documentation of student information which is ineffective, accumulation of paper files, student information in existing system is not secure and reports cannot be instantly presented in the existing system. The aim of this research work is therefore to develop a dossier record system for secondary school that will facilitate proper management of students information. The significance of the study is that it will provide the school with a system to properly manage staff and student information and it will serve as a management information system to the management of the institution. The software development methodology used is Object Oriented Analysis and Design (OOAD) model. The programming language used is Hypertext pre-processor (pHp) and the database used is MySql.
TABLE OF CONTENTS
Title Page – – – – – – – – i
Certification – – – – – – – – – ii
Approval Page – – – – – – – – iii
Dedication – – – – – – – – iv
Acknowledgment – – – – – – – – v-vi
Abstract – – – – – – – – vii
Table of Contents – – – – – – – – viii-x
CHAPTER ONE: INTRODUCTION
1.0 Introduction – – – – – – – 1
1.1 Background of the Study – – – – – – 1-2
1.2 Statement of the Problem – – – – – 2
1.3 Aim and Objectives of the Study – – – 3
1.4 Significance of the Study – – – – – – 3
1.5 Scope of the Study – – – – – – – 3
1.6 Organization of the Research – — – – – 4
1.7 Definition of Terms – – – – – – 4
CHAPTER TWO: LITERATURE REVIEW
2.1 Introduction – – – – – – – – 5
2.2 Application of ICT in Secondary School to Manage
Dossier Information – – – – – – – 5-6
2.3 Manual Processing of Students Information and
Associated Problems – – – – – – – 6-7
2.4 Database and Database Management System – – – 8
2.4.1 Advantages of DBMS – – – – – – 9
2.5 Student Records/Data Management – – – – 9-11
2.6 The Need for Dossier Record Management in Schools – 11-14
2.7 Concept of School Records Management – – – – 14-16
CHAPTER THREE: SYSTEM ANALYSIS AND DESIGN
- Introduction – – – – – – – – 17
3.1 Research Methodology – – – – – – 17
3.2 Analysis of the Existing System – – – – – 17-18
3.2.1 Disadvantages of the Existing System – – – – 18
3.3 Analysis of the Proposed System – – – – – 18-19
3.3.1 Advantages of the Proposed system – – – – 19
3.4 System Design – – – – – – – – 19
3.4.1 Input layout – – – – – – – – 20
3.4.2 Output Layout – – – 21
3.4.3 Algorithm – – – 21-22
3.4.4 Program Flowchart – – – 23-27
3.4.5 Database Design – – – – – – 28
CHAPTER FOUR: SYSTEM IMPLEMENTATION AND DOCUMENTATION
4.0 Introduction – – – – – – – 29
4.1 System Design Diagram – – – – – – 29
4.2 Choice of Programming Language – – – 29
4.3 Analysis of Modules – – – – – 30
4.4 Programming Environment – – – – – 30
4.4.1 Hardware Requirements – – – – – – 31
4.4.2 Software Requirements – – – – – – 31
4.5 Implementation – – – – – – – 31-32
4.6 Software Testing – – – – – – – 32-33
CHAPTER FIVE: SUMMARY, CONCLUSION AND RECOMMENDATIONS
5.0 Introduction – – – – – – – – 34
5.1 Constraints of the Study – – – – – – 34
5.2 Summary – – – – – – 34-35
5.3 Conclusion – – – – – – 35
5.4 Recommendations – – – – – – 35-36
References – – – – – – 37-38
Appendix A (Source Code)- – – – – – 39-52
Appendix B (Output) – – – 53-55
CHAPTER ONE
INTRODUCTION
1.0 Introduction
This chapter presents the introduction to dossier record system. It presents the following: introduction, background of the study, statement of the problem, aim and objectives of the study, significance of the study, scope of the study, organization of the research and definition of terms.
1.1 Background of the Study
A dossier is a collection of documents about a person or thing. Every institution maintain records of their students and as such it is important that these records are properly maintained in electronic format to enable them get needed information. Over the past few decades, institutions all over the world have been experiencing new paradigms in the way they handle and manage students’ information due to the proliferation of ICTs and its applications such as dossier record system. With the adoption of such systems as the dossier record system in academic institutions, the experience is that it has now become easy to harness and fast track all students’ records in one centralized database via the internet technology. While the benefits of web based database model for secondary school, it has not been implemented in many secondary schools in Africa to completely go digital in their operations due to poor ICT infrastructures that seem to be prevalent in the region (Eludire, 2011).
With the advent of computers and internet technology, students’ information can be easily management and this will facilitate effective administration. Institutions all over the world have realized the benefits of the web based system in managing records and verifying the existence of records in a few milliseconds. This advantage of the computer system has brought about a migration from manual ways of operations to computerized means so as to facilitate the management of large volumes of information. Every institution recognizes the possibility of identity fraud and to overcome the problem, they need to adopt the computer system so that the information of students can be easily captured and retrieved when needed. This will mitigate the risk of data loss in the traditional flat file organization (Mohd and Sultan, 2013). It is in view of the need to properly manage the information of secondary school students that necessitated this study on dossier record system.Â
1.2 Statement of Problem
The following are the existing problems that necessitated this study:
- Manual documentation of student information is ineffective.
- Accumulation of paper files
- High security risk student information in existing system is not secure.
- Reports cannot be instantly presented in the existing system.
1.3 Aim and Objectives of the Study
The aim of thisresearch work is to develop a dossier record system for secondary school that will facilitate proper management of students information. The objectives of the study are
- To develop a web-based dossier record system that can be used to register secondary school student information to a database
- To design a system that can be used to update the information of students admission information in the database.
- To develop a system that can provide student information reports.
