DESIGN AND IMPLEMENTATION OF STUDENT PROGRESS MANAGEMENT SYSTEM PDF

Preview

Summary

DESIGN AND IMPLEMENTATION OF STUDENT PROGRESS MANAGEMENT SYSTEM CASE STUDY Department of Physics and Computer Science Njala University BY NAME: Mohamed Sheriff Bah ID: 25834 NAME: David Sundifu Musa ID: 25836 NAME: Abdul Aziz Kanu ID:17086 A DISSERTATION SUBMITTED TO THE DEPARTMENT OF PHYSICS AND CO...

Description

DESIGN AND IMPLEMENTATION OF

STUDENT PROGRESS MANAGEMENT SYSTEM

CASE STUDY Department of Physics and Computer Science Njala University BY NAME: Mohamed Sheriff Bah ID: 25834 NAME: David Sundifu Musa ID: 25836 NAME: Abdul Aziz Kanu ID:17086

A DISSERTATION SUBMITTED TO THE DEPARTMENT OF PHYSICS AND COMPUTER SCIENCE SCHOOL OF TECHNOLOGY NJALA UNIVERSITY

In partial fulfillment for the award of Bachelor of Science with Honors in Computer Science

December, 2019

Acknowledgement First, we will want to express our obedience and gratitude to our creator God for giving us strength to complete this dissertation work properly then we would like to express of our special thanks to our parents for their continuous support of mental, physical and financial during our study at Njala University. We would especially like to thank our supervisor, Mr. Stephen S. Harvey, Senior Lecturer at the Department of Physics and Computer Science, Njala University for his continuous support and valuable ideas, knowledge with excellent comments to carry out this Dissertation work. His guidance and encouragement have provided us the proper knowledge and right way to go through the work. We would also like to thank our fellow academician fighting for excellent in Njala University for their cordial help and support during our Dissertation work. Special thanks to Ms. Rugiatu Sowe, Mrs. Georgiana Feika, Joyce Nyanda James and Annmarie Mansaray for their relentless support and effort towards our success. And special thanks to our Parents, Classmates, Friends, relatives and loved ones.

i

Certification

This is to certify that the work embodied in this project report entitled Student Progress Result Management System is the original work of Abdul Aziz Kanu(17086), David Sundifu Musa(25836) and Mohamed Sheriff Bah (25834) and has not been presented for an award of Bachelor’s Degree in this university or any other university.

I ……………………………………………………………., certify that this project was under my supervision and that this presentation is a true account of the result obtain by them.

Supervisor Mr. Stephen S. Harvey Sign:………………….. Date:…………………..

ii

Declaration

I Mohamed Sheriff Bah (25834), David Sundifu Musa(25836) and Abdul Aziz Kanu(17086) declare that this dissertation entitled “Student Progress Result Management System” is the result of our own research except as cited in the references. The dissertation has not been accepted for any degree and is not concurrently submitted in candidature of any other degree.

iii

Dedication This work is dedicated to God Almighty for giving us the opportunity, direction, protection, knowledge and strength to accomplish this innovative piece of work. We also stand to dedicate this work to Jamaal I. Kanu as a blueprint for him to follow, Ms. Rugiatu Sowe,Mrs. Chuwtor Lomax, Mrs. Georgina Feika, Mr & Mrs Emmanuel Saffa Musa , Joyce Nyanda James, Mrs. Isata Bah and Annmarie Mansaray for their relentless support and effort towards our success. And special thanks to our Parents, Classmates, Friends, relatives and loved ones , let our God in heaven pour his blessings upon them and lengthen their days of life with prosperity and peace. This day we pray to God Almighty for his blessing, wisdom, provision, courage, prosperity, peace and love to us all and a welcoming blessed and elevated New Year 2020.

iv

ABSTRACT This project, Student Progress Results Management System was carried out to automate the manual processes of compiling Students Examination Results at the Njala University, Department of Physics and Computer Science. It was necessitated because of some setbacks in manual result processing. The system was designed to automatically take raw scores from excel files and store them in a SQL database. It used past processed results to help the next course registration prior to results upload. Its result processing features includes the computation of grade point average (GPA) expressed as a percentage. A computerized input using file upload saves lecturers a lot of effort and time of data entry. This system uses the student's course registration data to match the uploaded results. The essence is to design an efficient computerized system that will replace manual result processing which is prone to lot of paper work and errors. This reduces the tedious tasks involved, and enhances students' performance through timely publication of results. Student Progress Results Management System is developed using Microsoft Access and Jet Engine. The user interface design is made from Interactive macros and specific code builders. Here, Student can check their results by entering MAT- id. Admin can create & manage Classes, subjects. Add & Manage students and Declare Results. This project is done in PHP. It’s easy to operate and understand by users. The design is pretty simple and the user won’t find it difficult to understand, use and navigate. This report describes the capabilities that will be provided by the software application Student Progress Results Management System It also states the various constraints by which the system will abide. The intended audience for this document is the development team, testing team and end users of the product. The application will have capability to maintain information about the students enrolled in the course, the subjects offered to students during different semesters, the marks obtained by the

v

students in different subjects in various semesters. The software will also generate summary report regarding student information, semester wise marks list and performance reports

vi

Table of Contents Acknowledgement............................................................................................................................. i Certification .................................................................................................................................... ii Declaration ..................................................................................................................................... iii Dedication ...................................................................................................................................... iv Chapter One: Introduction .............................................................................................................. 6 1.1

Overview .......................................................................................................................... 6

1.2

Problem Statement ........................................................................................................... 8

1.3

Aim of the Project ............................................................................................................ 9

1.4

Objectives of the Study .................................................................................................... 9

1.4.1 Specific Objectives ...................................................................................................... 10 1.5

Significance of the Study ............................................................................................... 10

1.6 Scope and Limitations ........................................................................................................ 11 1.6.1 Scope ............................................................................................................................ 11 1.6.2 Limitations ................................................................................................................... 11 1.7 List of Abbreviations .......................................................................................................... 12 Chapter Two: System Analysis ..................................................................................................... 13 2.1 Introduction ........................................................................................................................ 13 2.2 Requirement Determination ............................................................................................... 14 2.3 Requirement Specification ................................................................................................. 14 2.4 Interviewing ........................................................................................................................ 14 2.4.1 Advantages of Interviewing ......................................................................................... 14 2.5 Questionnaires .................................................................................................................... 15 2.6 Review of Records, Procedures, and Forms ....................................................................... 15 1|Page

2.6.1 Advantages ................................................................................................................... 15 2.7 Analysis of the Current System .......................................................................................... 15 2.7.1 Drawbacks of the Current System ............................................................................... 15 2.8 Goals of Proposed System .................................................................................................. 17 2.9 Feasibility Study ................................................................................................................. 18 2.9.1 Technical feasibility ..................................................................................................... 19 2.9.2 Economic Feasibility ................................................................................................... 20 2.9.3 Operational Feasibility ................................................................................................. 21 2.9.4 Schedule Feasibility ..................................................................................................... 21 2.10 Hardware and Software Requirements ............................................................................. 21 2.10.1 Recommended Operating Systems ............................................................................ 21 2.10.2 Hardware Requirements............................................................................................. 21 2.10.3 Application Software Requirement............................................................................ 22 2.11 Database Management Systems ....................................................................................... 22 2.11.1 Splitting the Database ................................................................................................ 22 2.11.2 Front End and Back End Users .................................................................................. 23 2.11.3 Repairs in Microsoft Access ...................................................................................... 24 2.11.4 Element of the DBMS Environment .......................................................................... 24 2.12 Data Flow Diagram .......................................................................................................... 25 2.12.1 Method of Data Collection ............................................................................................ 27 2.12.2 Logical Database Requirements .................................................................................... 27 2.12.3 Data Dictionary.............................................................................................................. 30 Chapter Three: Systems Design .................................................................................................... 32 3.1 Introduction ........................................................................................................................ 32 2|Page

3.1.1 Constraints of a System ............................................................................................... 33 3.1.2 Properties of a System ................................................................................................. 33 3.1.3 Elements of a System ................................................................................................... 34 3.1.5 Types of Systems ......................................................................................................... 36 3.2 Analysis of System Design ................................................................................................. 37 3.3 User Interface design .......................................................................................................... 39 3.3.1 Input Design ................................................................................................................. 40 3.3.2 Data Input Methods...................................................................................................... 41 3.3.3 Input Integrity Controls................................................................................................ 42 3. 4 Output Design .................................................................................................................... 42 3.4.1 Objectives of Output Design ........................................................................................ 42 3.4.2 Output Integrity Controls ............................................................................................. 43 3.5 Forms Design ...................................................................................................................... 44 3.5.1 Objectives of Good Form Design ................................................................................ 44 3.5.2 Types of Forms ............................................................................................................ 44 3.6 Interface Design .................................................................................................................. 45 Chapter Four ................................................................................................................................. 54 Methodology ................................................................................................................................. 54 4.1 Introduction ........................................................................................................................ 54 4.2 Database Development Methodology ................................................................................ 54 4.3 Requirements gathering ...................................................................................................... 56 4.4 Database Analysis............................................................................................................... 57 4.4.1 Analyze the data requirements, not the implementation .............................................. 57 4.5 Database Design ................................................................................................................. 58 3|Page

4.5.1 Using relational theory for formal design .................................................................... 59 4.6 Implementation ................................................................................................................... 61 4.6.1 Realizing the design ..................................................................................................... 61 4.6.2 Populating the Database ............................................................................................... 62 4.6.3 Supporting Users and user Process .............................................................................. 63 CHAPTER FIVE .......................................................................................................................... 64 5.0 SYSTEM IMPLEMENTATION AND TESTING ................................................................. 64 5.1 Introduction ........................................................................................................................ 64 5.2 Acquisition of Hardware and Software .............................................................................. 65 5.2.1 Financial Decision ....................................................................................................... 65 5.3 Criteria for Evaluating Vendor Proposals .......................................................................... 65 5.4 Installation of Hardware and Software ............................................................................... 65 5.5 Testing Techniques ............................................................................................................. 66 5.6 System Testing ................................................................................................................... 67 5.7 Software Quality Assurance ............................................................................................... 67 5.7.1 Software Quality Assurance (SQA) ............................................................................. 69 5.7.2 Procedures and standards ............................................................................................. 69 5.8 Software Quality Assurance Activities............................................................................... 69 5.9 Training .............................................................................................................................. 69 5.10 System implementation .................................................................................................... 70 5.11 System Security and controls ........................................................................................... 71 5.12 Hardware and Software Security ...................................................................................... 72 5.13 Back-up Procedures .......................................................................................................... 72 CHAPTER SIX ............................................................................................................................. 73 4|Page

6.0 REVIEW AND MAINTENANCE ......................................................................................... 73 6.1 Introduction ........................................................................................................................ 73 6.1.1 Corrective Maintenance ............................................................................................... 74 6.1.2. Perfective maintenance ............................................................................................... 74 6.1.3 Adaptive Maintenance ................................................................................................. 74 CHAPTER SEVEN ...................................................................................................................... 75 7.0 CONCLUSION AND RECOMMENDATION ...................................................................... 75 7.1 Introduction ........................................................................................................................ 75 7.2 Conclusion .......................................................................................................................... 75 7.3 Project Constraints .............................................................................................................. 76 7.4 Recommendations .............................................................................................................. 78 CHAPTER EIGHT ....................................................................................................................... 80 REPORTS ..................................................................................................................................... 80 8.1 Introduction ........................................................................................................................