DECISION SUPPORT SYSTEM ON COURSE ALLOCATION

  • Type: Project
  • Department: Computer Science
  • Project ID: CPU2105
  • Access Fee: ₦5,000 ($14)
  • Pages: 110 Pages
  • Format: Microsoft Word
  • Views: 641
  • Report This work

For more Info, call us on
+234 8130 686 500
or
+234 8093 423 853

DECISION SUPPORT SYSTEM ON COURSE ALLOCATION

(A CASE STUDY OF FEDERAL POLYTECHNIC BAUCHI)

 

BY

 

 

HABIB SALEH

FPTB/CS/HND/15/112953

 

 

 

 

 

 

 

 

 

DEPARTMENT OF THE COMPUTER SCIENCE, SCHOOL OF SCIENCE AND TECHNOLOGY, FEDERAL POLYTECHNIC, BAUCHI

 

 

 

FEBUARY, 2018

 

DECISION SUPPORT SYSTEM ON COURSE ALLOCATION

(A CASE STUDY OF FEDERAL POLYTECHNIC BAUCHI)

 

 

 

BY

 

 

HABIB SALEH

FPTB/CS/HND/15/112953

 

 

THE COMPUTER SCIENCE DEPARTMENT, SCHOOL OF SCIENCE AND TECHNOLOGY, FEDERAL POLYTECHNIC, BAUCHI, IN PARTIAL FULFILLMENT OF THE REQUIREMENT FOR THE AWARD OF THE HIGHER NATIONAL DIPLOMA IN COMPUTER SCIENCE

 

DEPARTMENT OF THE COMPUTER SCIENCE, SCHOOL OF SCIENCE AND TECHNOLOGY, FEDERAL POLYTECHNIC, BAUCHI

 

 

FEBUARY, 2018

APPROVAL PAGE

This project has been read and approved by the under signed on behalf of the Department of Computer Science, School of Science and Technology, Federal Polytechnic Bauchi as having met the requirement for the award of  Higher National Diploma in Computer Science.

 

 Muhammad Abubakar.

-----------------------------                        -------------------------                 ------------------------

Project supervisor                                            Signature                                 Date

 

 

Aliyu Muhammad

-------------------------------                     -------------------------                 -------------------------

Project Coordinator                                     Signature                                    Date

 

 

Sani Usman

-------------------------------                     -------------------------                 --------------------------

Head of Department                                    Signature                                    Date

 

-------------------------------                     -------------------------                 ----------------------------

External Examiner                                      Signature                                        Date

 

 

 

 

 

 

 

DECLARATION

This is to certify that this project work (Decision support system on course allocation) was carried out in the Computer Science Department, Federal Polytechnic, Bauchi under the supervision of Mallam Muhammad Abubakar.

This report is an original work carried out by me and has not been presented elsewhere for any degree. The works of other investigators are referenced to in this presentation.

 

.........................................                                                       ………………………

Habib Saleh                                                                             Date               

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

DEDICATION

 

This project is dedicated to Almighty God that made this research work a success and to our supervisor in the person of Mal. Muhammad Abubakar and also my beloved for their financial support toward  the successful completion of this research work. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ACKNOWLEDGEMENT

 

I wish to thank God Almighty for His mercy and protection on me from the time of birth through this academic journey.

My profound gratitude goes to my supervisor Mal. Abubakar Muhammad for the role he played throughout this project task, which helped to make the project a reality.

I will never forget my able head of department, Mal. Sani Usman, who would always give students the conducive environment to carry out their projects and academic activities successfully and to the staffs of the department for their impact and contribution, i pray that God reward you all.

Finally, I will not forget to show my sincere appreciation to my family and not forgetting my friends, Murtala Hassan, Mahmoud Haruna, Abdulmumini Buba esq, Abdullahi mubarak and colleagues who in one way or the other contributed to my academic pursuit and also for their immense support and contribution to the completion of this project. God bless you all.

 

 

 

 

 

 

 

 

 

 

 

 

ABSTRACT

Basically it can be discovered that there are heaps of files, available space in the office of head of department slowing down his or her work, making the place untidy and even frightening him or her from task to be accomplished. But it should not be in this era or period of paperless office which brought about the use of computer system. Decision support systems are computer based systems that aid decision making process. There are several types of decision support systems, some supporting simple decision making process, while others support complex decision processes. Decision support systems have their disposal bodies of knowledge that are capable of providing criteria and options that are optimal in decision making. Course allocation is a decision making process on departmental head in federal polytechnic Bauchi which  is done manually and needs decision support system to make it efficient. The criteria used includes ranking, area of specialization and interest, work load success and failure rate, long period of taking a course, work balance, and leave. This research intends to design and host an online decision support system that will aid departmental heads in performing course allocation. Departmental heads will be guided by the proposed decision support system to make efficient course allocation. At the end of this research work, a decision support system on course allocation for most departments in the polytechnic. This application is been designed and hosted on web server and can accessed online via www.fptbcourseallocation.info  using internet connection on any device.

 

 

 

 

 

 

 

 

 

 

 

 

 

TABLE OF CONTENT

 

Title page - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - i

 

Approval page - - - - - - - -  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ii

 

Declaration - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  - - - - - - - - - - - - - -iii

 

Dedication  - - - - - - - - - --- -  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -iv

 

Acknowledgement - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -v

 

Abstract -- - -  - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - vi

 

Table of content -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -vii

 

 

CHAPTER ONE

 

Introduction

 

1.0       Background of the Study- - -  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  1

 

1.1       Decision Support System (DSS)- -  - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - 1

 

1.1.1    Course Allocation System- - -  - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -2

 

1.1.2    Automatic Course Allocation System- - - - - - - - - - -  - - - - - - - - - - - - - - - - - - - - - - 2

 

1.1.3    Common Error in Course Allocation Process- - - - - - - - - - - - -  - - - - - - - -- - - - - - - -3

 

1.1.4    Course Allocation in Federal Polytechnic Bauchi - - -  - - - - - - - - - - - - - - - - - - - - - -3

 

1.2       Statement of the Problem- - - - - - - - - - - - - - - - - - - -- - - - - - - - - -  - - - - - - - - - - - -4

 

1.3       Aims and Objectives - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 5

                                       

1.4       Scope and Limitations - - - - - - - - - - - - - - - - - - - - - - -- - - -  - - - - -- - - - -- -  - - - -- 6

 

1.5       Justification of the Study - - - - - - - - - - - - - - - - - - - - - - - - - -  - - - - - - - - - - - - - - - 6

 

1.6       Definition of Terms- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  - - - - - - -- - - - -7

 

1.7       Methodology - - - - - - - - - - - - - - -  - - - - - - - - - - - - - - - - - - - - - - - -  - - - - - - - - - - 7

 

 

CHAPTER TWO

 

LITERATURE REVIEW

 

2.0       Decisions support system- - - - - - - - - - - - - - - - -  - - - -  --- - - - - - - - - - - - - - - - - -8

 

2.1       Course Allocation System- - - - - - - - - - -  - - - -  - - - - - - - - - - - - - - - - - - - - - - - - 13

 

2.1.1    Manual Course Allocation System- -- -- - - -  - - - - - - -- - - - - - - - - - -- - - - - - - -  - 13

 

2.1.2    Automated Course Allocation- - -  - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - --16

 

2.2       Course Management System- - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - 17

 

2.3       Web Technology - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  -  - -20

 

2.3.1    My SQL Database - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  - - - -  - -  - - 21

 

2.3.2   PHP- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  - - - - - - - - -24

 

 

 

 

CHAPTER THREE

 

3.0       Methodology - - - - -  - - - - - - - - - -- - - ----- - - - - - - - - - - - - - - - - - - - - - - - - - - - 26

 

3.1       Types of Models - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 26

                                                                                                                   

3.1.1    Criteria used in Course Allocation by Department - - - - - - - - - - - - - - - - - -   - - - - -28

 

3.1.2    Academic Rank Criterion - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  -  - - - -  - 33

3.1.3    Leave Criterion - - - - -  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 33

3.1.4    Area of Specialization /Interest Criterion - - - - - - - - - - - - - - - - - - - - - - - - -  -- - - -34

 

3.1.5    Long Term Experience Criterion - - - - - - - -  - - - - - - - -- - - - - - - - - - - - - - - - - - - 34

 

3.1.6    Workload Criterion - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - -  - 34

 

3.1.7    Load Balance Criterion - - - - - - - - - - - - - - - - - - - - - - - - -   - - - - - - - --  - - - - - - -35

 

3.1.8    Past Success /Failure Criterion - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -35

 

3.1.9    List of Courses in Department - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - -  - 35

 

3.2       System Design - - - -  - - - -  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -36

 

3.3       System Analysis & Design - - - - -  - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - -36

                          

3.3.1    Program  Flowchart - - - -   - - - - - - - - - -  - - - - - - - - -  - -- - - - - - - - - - - - - -  - - - -38

 

3.3.2    Use Case Diagram - - - - - - - - - - --  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -39

 

3.3.3    Software Architecture - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  - -  - - - -40

 

3.3.4    Database Design - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  - - - - - - - - -- - - - - - - - - 40

 

3.4       Web Service - - - - - - - - - - - - - - - - -  - - - - - - - - -  - - - - - - - - - - - - - - - - - - - - - - - 43

 

3.5       Output Interface Design - - - - -  -- -  -- - - - - - - - - - - - - - - - - - - - - - - - - -- - - - -43           

3.5.1    Input Interface Design - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 43

3.5.2     Logical Layer Design - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - --  -- - - - - -- - 46                                                                                                                                   

CHAPTER FOUR

IMPLEMENTATION AND DOCUMENTATION

4.1       System Overview- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  - - - -- - - - - - - - - -  48

 

4.2       Hosting and Domain - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  - - - - - -  - - - - - - - - - 49

 

4.3       Database Structure - - - - - - - - - - - - - - - - - - - - - - - -  - - -  - - - - -  - - - - - - - -  -- - -  -50

 

4.4       Result - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - -- - -  - - - - - - - - - - - -- - - -51

 

4.5       Testing  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  - - - - -  - - -57

 

4.5.1    Sample Output - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -  - - - - - - - -  -- - -58

 

4.6       Major Achievement - - - - - - -  - - - - - - - - - - - - - - - - - - - -- -- - - - - -  - - - - - - - - - - 59

 

4.7       Minimum system Requirement - - - -  - - - - - - - -  - - - - - - - - - - - - - - - - - - - - - - - - -59

 

4.8       Deployment - - - - - - - - - - - - - - - - - - - - - - - -  - - - - - - -  -- - - - - - - - - - - - - - - - - - 59

 

4.9       Code Listing - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -60

 

4.9.1    Activity Diagram - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  - - - - -61

 

                                                                                                                         

CHAPTER FIVE

 

SUMMARY, RECOMMENDATION AND CONCLUSION

 

5.1       Summary - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  - - - - - - - - - - - - 62

 

5.2       Conclusion - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  - - - - -  --  - - 63

 

5.3       Recommendation - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  - 64

 

References - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 65

 

Appendix: Program source code - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  - - - - - - -66

 

DECISION SUPPORT SYSTEM ON COURSE ALLOCATION
For more Info, call us on
+234 8130 686 500
or
+234 8093 423 853

Share This
  • Type: Project
  • Department: Computer Science
  • Project ID: CPU2105
  • Access Fee: ₦5,000 ($14)
  • Pages: 110 Pages
  • Format: Microsoft Word
  • Views: 641
Payment Instruction
Bank payment for Nigerians, Make a payment of ₦ 5,000 to

Bank GTBANK
gtbank
Account Name Obiaks Business Venture
Account Number 0211074565

Bitcoin: Make a payment of 0.0005 to

Bitcoin(Btc)

btc wallet
Copy to clipboard Copy text

500
Leave a comment...

    Details

    Type Project
    Department Computer Science
    Project ID CPU2105
    Fee ₦5,000 ($14)
    No of Pages 110 Pages
    Format Microsoft Word

    Related Works

    TABLE OF CONTENTS CHAPTER ONE:  INTRODUCTION 1.1 Background of the Study 1.2 Statement of Problem   1.3 Aim and Objectives Scope of the Project Significance of the Study Research Methodology Project Feasibility and Plan Economic Feasibility Schedule Feasibility Organization of Subsequent Chapters CHAPTER TWO: LITERATURE REVIEW 2.1 Introduction... Continue Reading
    TABLE OF CONTENTS CHAPTER ONE:  INTRODUCTION 1.1 Background of the Study 1.2 Statement of Problem   1.3 Aim and Objectives Scope of the Project Significance of the Study Research Methodology Project Feasibility and Plan Economic Feasibility Schedule Feasibility Organization of Subsequent Chapters CHAPTER TWO: LITERATURE REVIEW 2.1 Introduction... Continue Reading
      CHAPTER ONE GENERAL INTRODUCTION 1.1 INTRODUCTION Before the advent of computer in Nigeria manufacturing firms, just like other areas of the society were used to manual method operation. This is to say, the operation which involves the production, transaction, customer registration stock system and balancing of account were carried out... Continue Reading
      CHAPTER ONE GENERAL INTRODUCTION 1.1 INTRODUCTION Before the advent of computer in Nigeria manufacturing firms, just like other areas of the society were used to manual method operation. This is to say, the operation which involves the production, transaction, customer registration stock system and balancing of account were carried out... Continue Reading
    Numerous studies have shown that the quality of health care is inadequate, and healthcare organizations in developed nations are increasingly turning to clinical decision support systems to address this problem. This study aims to optimize health care delivery by creating a clinical decision support system tool to aid health care clinical... Continue Reading
    ABSTRACT This study is concerned with the design of a Decision Support System for finding the Shortest path to a destination. The objectives of the study is to determine the optimal shortest/fastest path to a given destination or optimal shortest distance/fastest time to a given destination amongst others. The shortest path algorithm used is... Continue Reading
    ABSTRACT The development in science and technology has vital contribution towards improving the country's economy. One of the sectors that contribute to the country's economy is agriculture which needs the improvement of science and technology from time to time such as in its fertigation system. The manual applications of fertilizer that are... Continue Reading
    ABSTRACT The challenges faced by telecommunication industries are many, there is need to eliminate or curb some of these challenges and that is when a decision support system comes into play. A decision support system (DSS) is one which can aid to strategize management within industries to make vital decisions in relation to customer and network... Continue Reading
    ABSTRACT This project examines and addresses the problems and challenges facing student’s registration in Godfrey Okoye University, Enugu. The objective of this research work is to find out solutions to the challenges facing the bulk paperwork of student’s hostel allocation in the university. At the end of the study, it is concluded that to an... Continue Reading
    ABSTRACT This project examines and addresses the problems and challenges facing student’s registration in Godfrey Okoye University, Enugu. The objective of this research work is to find out solutions to the challenges facing the bulk paperwork of student’s hostel allocation in the university. At the end of the study, it is concluded that to an... Continue Reading
    Call Us
    whatsappWhatsApp Us