Design and Development of Student Admission System Case Study: St Pius Senior Secondary School

TABLE OF CONTENTS

DECLARATION

APPROVAL

DEDICATION

ACKNOWLEDGEMENT

LIST OF ACRONYMS

ABSTRACT

CHAPTER ONE 1

INTRODUCTION 1

1.0 Introduction - 1

1.1 Background ofthe study 1

1.2 Statement ofthe problem 2

1.3 Research Objectives 2

1.3.1 Main objective 2

1.3.2 Specific Objectives 2

1.3.3 Research questions 2

I .4iustification 3

1.5 Scope ofthe study 3

1.6 Significance of the study 3

1.7 Conceptual frame works 4

1.8 SCHOOLS’ ADMISTRATION HIERACHY 4

CHAPTER TWO 5

LITERATURE REVIEW 5

2.0 Introduction

2.1 Facts finding technique

2.2 Software design

2.2.1 Waterfall model 6

PROJECT WATERFALL MODEL 6

CHAPTER ThREE 7

METHODOLOGY 7

3.0 Introduction 7

3.1 Sources ofdata 7

V

3.2 Method of Data Collection ~

3.2.1 Interview

3.2.2 Questionnaire form 7

3.2.3 Observation

3.2.4 Feasibility Study 8

3.4 Target population and Sampling method 8

3.4.1 Sample size 8

3.4.2 Sampling technique 8

3.5 Data analysis 8

3.6 System development and tools 8

3.6.1 SQL server 2008R2and VB.Net 2010 9

3.7 System analysis

3.7.1 SQL — Structured Query Language 9

3.7.2 Visual Basic Net (VB.Net) 9

3.8 System design 10

3.9 S stem requirei~ents 10

1-lardware requirements are’

Software requirenients are’ 10

People 10

3.10 Database formulation 10

3.12 Validation 11

CHAPTER FOUR 12

SYSTEM DESIGN AND IMPLEMENTATION 12

4.1 STATUS OF THE EXISTING ADMISSION SYSTEM 12

4.2 SYSTEM DESIGN 14

4.2.1 CREATING SYSTEM DATABASE 14

4.1.2 DESIGNING USER INTERFACE 15

4.1.2 USERS 17

DATA ENTRY 18

ADMIN1STRATION 18

4.1.3 DEFAULT INTERFACE 18

4.1.4 NEW USER ACCOUNT INTERFACE 19

vi

4.1.5 ADMISSION INTERFACE .20

4.1.6 REGISTRATION FORM INTERFACE 21

4.1.7 UPDATING REGISTERED STUDENTS ADMISSION DETAILS 23

4.1.8 UPDATING SYSTEM USERS ACCOUNTS 24

4.1.9 VIEW ALL STUDENTS 25

4.1.10 VIEW TERMINATED STUDENTS 26

4.2 SEQUENTIAL DIAGRAMS THAT SHOWS DATA FLOW STUDENT ADMISSION SYSTEM .27

4.2.1 SEQUENTIAL DIAGRAM THAT SHOWS SYSTEM USER ENTITY 27

4.2.2 SEQUENTIAL DIAGRAM THAT SHOWS STUDENTS ENTITY 28

4.2.3 DATA FLOW DIAGRAM FOR STUDENT ADMISSION SYSTEM . 29

4:2 SYSTEM INSTALLATION 29

4.3 SYSTEM IMPLEMENTATION 30

4.4 USEFUL CODES 30

4.4 USER MANNUAL 32

4.4.1 INTRODUCTION 32

CHAPTER FIVE 34

DISCUSSION OF RESULTS/FINDINGS 34

5.1 PROJECT SUCCESS 34

5.2 LESSONS LEARNT 34

CHAPTER SIX 36

RECOMMENDATIONS AND CONCLUSION 36

6.1 RECOMMENDATIONS 36

6.2 CONCLUSIONS 36

REFERENCES 38

APPENDICES 39

APPEN[)IX A: TIME FRAME OF RESEARCH 39

APPENDIX B: THE BUDGET 40

APPENDIX C: GUIDING QUESTIONS WE USED TO INTERVIEW STAFF 41

APPENDIX D: QUESTIONNAIRE FOR STUDENTS 42

APPENDIX E: SYSTEM LOGIN 43

APPENDIX F: ADMISSION FORM INTERFACE 44

APPENDIX G: ALL ADMITTED STUDENTS 45