College erp - This is a final year project document is helpful for software project management. PDF

Preview

Summary

This is a final year project document is helpful for software project management....

Description

IT-HUB SARGODHA COLLEGE MANAGEMENT SYSTEM

Version 1.3 Date: March 21, 2019

IT Hub Sargodha Affiliated with University of Sargodha

College Management System Version 1.3

© IT-HUB SARGODHA

1

IT-HUB SARGODHA COLLEGE MANAGEMENT SYSTEM

Version 1.3 Date: March 21, 2019

© IT-HUB SARGODHA

2

IT-HUB SARGODHA COLLEGE MANAGEMENT SYSTEM

Version 1.3 Date: March 21, 2019

Revision History

Date

Version

Description of Change

12 Feb 2018

1.0

Proposal Updated

13 March 2018

1.1

Document Updated

17 July 2018

1.2

Document Updated

7 Aug 2018

1.3

Document Updated

2 Feb 2019

1.4

Document Updated

Author Adil Hussian Rabia Shafique Tehseen Fatima Adil Hussian Rabia Shafique Tehseen Fatima Adil Hussian Rabia Shafique Tehseen Fatima Adil Hussian Rabia Shafique Tehseen Fatima Adil Hussian Rabia Shafique Tehseen Fatima

© IT-HUB SARGODHA

3

IT-HUB SARGODHA COLLEGE MANAGEMENT SYSTEM

Version 1.3 Date: March 21, 2019

TABLE OF CONTENTS CHAPTER 1: FINAL PROJECT PROPOSAL

3

1.1 INTRODUCTION 1.2. PROJECT TITLE: COLLEGE ENTERPRISE RESOURCE PLANNING 1.3. PROJECT OVERVIEW STATEMENT: 1.4. PROJECT GOALS & OBJECTIVES: 1.4.1. GOAL: 1.5. HIGH LEVEL SYSTEM COMPONENTS: 1.6. LIST OF OPTIONAL FUNCTIONAL UNITS: 1.7. EXCLUSIONS: 1.8. APPLICATION ARCHITECTURE: 1.9. GANTT CHART: 1.11. TOOLS AND TECHNOLOGIES USED WITH REASONING: 1.11.1 TOOLS 1.11.2.3 JAVASCRIPTS

3 3 3 3 4 4 4 5 5 5 6 6 6 7

CHAPTER 2: FIRST DELIVERABLE

7

2.2.1. Technical Feasibility 2.2.2. Operational Feasibility 2.2.4. Schedule Feasibility Requirements and specification of our project are no hard and not difficult to the users So this is feasible. 2.2.6. Information Feasibility 2.2.7. Motivational Feasibility 2.2.8. Legal & Ethical Feasibility

7 7 7 7 7 8 8

2.4.1. PROJECT COST ESTIMATION BY FUNCTION POINT ANALYSIS INFORMATION DOMAIN VALUES ARE DEFINED IN THE FOLLOWING MANNER: 8

2.4.2. Project Cost Estimation by using COCOMO’81 (Constructive Cost Model) 2.6. CPM - CRITICAL PATH METHOD 2.6.1 SPECIFY THE INDIVIDUAL ACTIVITIES: 2.8. INTRODUCTION TO TEAM MEMBER AND THEIR SKILL SET: 2.9. TASK AND MEMBER ASSIGNMENT TABLE:

9 10 10 12 13

2.10. TOOLS AND TECHNOLOGIES USED WITH REASONING: 2.10.1 TOOLS 2.10.2.3 JAVASCRIPTS 2.11 VISION DOCUMENT 2.12. Risk List

13 13 13 14 14

© IT-HUB SARGODHA

4

IT-HUB SARGODHA COLLEGE MANAGEMENT SYSTEM

Version 1.3 Date: March 21, 2019

CHAPTER 3: SECOND DELIVERABLE FOR OBJECT ORIENTED APPROACH

15

Chapter 1: Final Project Proposal 1.1 Introduction 1.2. Project Title: College Management System

1.3. Project Overview statement: College Management System provides a simple interface for maintenance of student information can be used by educational institutes or colleges to maintain the records of students easily. The creation and management of accurate, up-to-date information regarding a students’ academic career is critically important in the university as well as colleges. Student information system deals with all kind of student details, academic related reports, college details, course details, curriculum, batch details, placement details and other resource related details too. It will also have faculty details, batch execution details, students’ details in all aspects, the various academic notifications to the staff and students updated by the college administration. It also facilitate us explore all the activities happening in the college, Different reports and Queries can be generated based on vast options related to students, batch, course, faculty, exams, semesters, certification and even for the entire college The placement officer is responsible for updating the placement related information like eligible criteria for a particular company, arriving date for the company which is coming for recruitment, the list of students who are eligible for attending the recruitment process. /The design and implementation of a comprehensive college Management System and user interface is replacing the current paper records. College Staff are able to directly access all aspects of a student’s academic progress through a secure, online interface embedded in the college’s website. The system utilizes user authentication, displaying only information necessary for an individual’s duties. Additionally, each sub-system has authentication allowing authorized users to create or update information in that subsystem. All data is thoroughly reviewed and validated on the server before actual record alteration occurs. In addition to a staff user interface, the system plans for student user interface, allowing users to access information and submit requests online thus reducing processing time. All data is stored securely on SQL servers managed by the college administrator and ensures highest possible level of security. The system features a complex logging system to track all users’ access and ensure conformity to data access guidelines and is expected to increase the efficiency of the college’s record management thereby decreasing the work hours needed to access and deliver student records to users.

© IT-HUB SARGODHA

5

IT-HUB SARGODHA COLLEGE MANAGEMENT SYSTEM

Version 1.3 Date: March 21, 2019

Project Overview Statement Template Project Title: College Management System Project Manager: Syed Muntazir Mehdi Bukhari Project Members: Name

Registration #

Email Address

Adil javed

[email protected]

Rabia shafique

[email protected]

Signature

Tahseen Fatima

Project Goal: Provide a state-of-the-art technical infrastructure to better serve students, faculty, staff, and other members of the College Community. Develop  new, more efficient processes that fully leverage the technology investment. Replace inefficient systems with one that is functionally integrated. Objectives: Sr.# 1

Collecting data

2

Planning

3

Designing

© IT-HUB SARGODHA

6

IT-HUB SARGODHA COLLEGE MANAGEMENT SYSTEM

Version 1.3 Date: March 21, 2019

4

Implementation

5

Testing of different modules

6

Maintenance

Project Success criteria: Our project will be successful if implemented efficiently and work properly. Assumptions, Risks and Obstacles: 1. 2.

It is assumed that we have all resources required to design this software. There may come operational risk. It might be possible that the organization where the system will be deployed cannot operate this system. User manuals will be created to encounter this risk. 3. Scalability: Our data may grow on a large scale that cannot be handled properly by database and will be integrated Big Data in future. 4. Operating system may crash due to some technical fault. Organization Address (if any): IT-Hub 113/3 Stadium road Sargodha Type of project:

Research

Development 

Target End users: Development Technology: Platform:

Object Oriented

Web based

Desktop based

Structured

Distributed Setup Configurations

Other_____________________

1.4. Project Goals & Objectives: 1.4.1. Goal: Provide a state-of-the-art technical infrastructure to better serve students, faculty, staff, And other members of the College Community. Develop new, more efficient processes that fully leverage the technology investment. Replace inefficient systems with one that is functionally integrated.

1.4.2 Objectives: ● ● ●

Collecting data Planning Designing

●

Implementation

● ●

Testing of different modules Maintenance

1.5 High level system components: 1.5.1 Admission and Fee This module helps the management in managing the complete admission process with ease. It integrates operations and processes of admission and fees at colleges. It administers set-up of faculty members of all departments. This includes medium of © IT-HUB SARGODHA

7

IT-HUB SARGODHA COLLEGE MANAGEMENT SYSTEM

Version 1.3 Date: March 21, 2019

instruction, fee cashbooks, fee heads and fee types etc. It also enables feeding and restoring data of course details and caste category. Below are the basic features of this module: • Students receive SMS and email alerts of fees transactions • All details of admissions can be fed on the software Operations that are processed in this Module: • Student registration

1.5.2 Student Administration This is the most integral and essential module of the College . Details of students, faculty and staff with other details of certificates, documents, sections, and enrollment numbers are maintained on the software. Below is a list of few operations, the ERP automates: ● Creation of admitted student record ● Allotment of roll number, registration number, section and subjects ● Updating of student dues and fines

1.5.3 Program Management This most essential module of erp. Details of all programs related to College Management system added. And according to these modules students select their programs 1.5.4 Attendance This module automates the following operations: ● Course (subject) allotment ● Day to Day attendance entry by the faculty 1.5.5 HR and Payroll The HR management software for higher education institutions deals with staff recruitment, hiring, administration, and training of faculty.

1.5.6

Reports Management

It manages the following of the Reports: ● Daily Fees collection registers ● Fees abstract report ● Fees Write-Off report ● Bank-wise collection report ● Outstanding fee register ● Admission position report ● Students list reports like: courses, optional subjects, caste category fee type etc. ● MIS reports on the basis of faculty, cashbook, medium, sex, caste category and fees category

1.5.7

Account Management

Account management module automates the accounting of multiple schemes and cashbooks for end number of financial years. Finance module links fees with other modules like Stores, Hostel, Payroll and entries. Features: ● Entries of all kinds of fees collected online and offline ● Entries of payment vouchers and JVs ● Entries can be transferred to the Accounts module while collecting fees ● Transfer of Payroll entries to Accounts © IT-HUB SARGODHA

8

IT-HUB SARGODHA COLLEGE MANAGEMENT SYSTEM

Version 1.3 Date: March 21, 2019

Reports that can be generated: ● Income and Expenditure Statement 1.5.8 Accounts Configuration: ● Per entry narration or single narration ● Auto generated voucher number ● Enables SMS for every payment transaction ● Facility to upload voucher scanned copy with every transaction ● Auto-generates schedule number or manual numbering 1.5.9 Student Fees Fees collected for academic curriculum, exams, hostels, certificate gets archived within this module of university financial management system. Students’ Fees sub-module can generate receipts, challans and reports; likewise.

1.5

List of optional functional units: ● Online Transactions

1.6

Exclusions: ● ●

Online faculty interview Online paper Checking System Degree Verification

● ● Biometric Attendance ● E-Library

1.7

Application Architecture:

3 Tier Architecture is being used in our system:

1.9. Gantt chart:

© IT-HUB SARGODHA

9

IT-HUB SARGODHA COLLEGE MANAGEMENT SYSTEM

Version 1.3 Date: March 21, 2019

1.10. Hardware and Software Specification: 1.10.1.Hardware Dual core Processor 2 GB RAM 10 GB Hard Disk

1.10.2Software Operating System: Windows XP Professional/8.1/10 For Testing live: WAMP/XAMP Web Browser: Google Chrome, Internet Explorer etc.

1.11. Tools and technologies used with reasoning: 1.11.1 Tools 1.11.1.1 MS Word 2016 MS WORD is a graphical word processing program that user can type with.it is made by the computer Microsoft. The purpose of MS WORD is to allow the users type and save documents. In this project we used MS WORD to make our final year project documentation.

1.11.1.2 MS Visio 2013 MS VISIO 2013 is used to create simple or complicated diagrams. It offers a wide variety of built-in shapes objects and stencils to work with. We can also make your own shapes easily. That’s why we used MS VISIO in our project to make shapes and diagrams

1.11.1.3 MS Project MS PROJECT is used in developing plans, assigning resources to task, tracking progress, managing budgets and analyzing workloads.Therefor we used MS PROJECT to make our project planning task and manage budget.

1.11.1.4 Sublime Text Editor In sublime text editor we are using for coding

1.11.2 Technologies 1.11.2.1 HTML HTML (hypertext markup language) is the most basic building block of the web.it describe and defines the content of webpage. Other technologies besides the HTML are generally used to describe a webpages appearance.HYPERTEXT refer to link that connect webpages to one another, either within a single website or between websites Links ae a fundamental aspect of the web. By uploading content to the internet and linking it to pages created by other people, you become an active participant in the World Wide Web

1.11.2.2 CSS

© IT-HUB SARGODHA

10

IT-HUB SARGODHA COLLEGE MANAGEMENT SYSTEM

Version 1.3 Date: March 21, 2019

Cascading style sheet (css) are a stylesheet language used to describe the presentation of a document written in HTML or XML.CSS describe how element should be rendered on screen, on paper, on screen, in a speech, or on other media. CSS is one of the core languages of the open web and has a standardize w3c.

1.11.2.3 JAVASCRIPTS Java scripts is a lightweight, interpreted programming language.it is designed for creating network centric application.it is complimentary to and integrated with javascripts is easy to implement because integrated with HTML.it is open and cross platform.

1.11.2.4. MYSQL MYSQL is a relational database management system (RDBMS) that runs as a server providing multi user access to a number of database MYSQL is a popular choice of database for use in web application and is an open source product. The process of setting up a MYSQL database varies from host to host however we will end up with a database name a user name and password. Before using our database we create a table. A table is a section of the database for storing information.

1.11.2.5 BOOTSTRAP BOOTSTRAP is the most popular HTML, CSS and JAVASCRIPT framework for developing responsive, mobile-first web sites. BOOTSTRAP has a few easy ways to quickly get started, each one appealing to a different skill level and use case.

Chapter 2: First Deliverable 2.1 Introduction 2.2 Project Feasibility Report 1.7.13 2.2.1. Technical Feasibility Our project is technically feasible because it is just manage all moduels. We have all technical skills needed to design this system. We have the ability to design an attractive front end for the end user and a proper back end to make the system efficient.

1.7.14 2.2.2. Operational Feasibility No doubt the proposed system is fully GUI based that is very user friendly and all input to be taken all self-explanatory even to a layman. Besides, a proper training has been conducted to let know the essence of the system to the users so that they feel comfortable with new system. As far our study is concerned the clients are comfortable and happy as the system has cut down their loads and doing

2.2.3. Economic Feasibility Since this project is developed using codinignter with PHP and SQL Server which is more commonly available and even the cost involved in the installation process is not high. Similarly it is easy to recruit persons for operating the software. Even if we want to train the persons in these area the cost involved in training is also very less. Hence this project has good economic feasibility. The system once developed must be used efficiently. Otherwise there is no meaning for developing the system. For this a careful study of the existing system and its drawbacks are needed. The user should be able to distinguish the existing one and propose done, so that one must be able to appreciate the characteristics of the proposed system, the manual one is not highly

1.7.15 2.2.4. Schedule Feasibility All requirements are clear. So our project will be according to our schedule that are in our Gantt chart. © IT-HUB SARGODHA

11

IT-HUB SARGODHA COLLEGE MANAGEMENT SYSTEM

Version 1.3 Date: March 21, 2019

2.2.5. Specification Feasibility Requirements and specification of our project are no hard and not difficult to the users So this is feasible.

2.2.6 Information Feasibility System is very reliable. It can properly college ERP and generate accurate reports

2.2.7 Motivational Feasibility All information about the system is available. We can motivate the team members to develop an acceptable and efficient management system

2.2.8. Legal & Ethical Feasibility In our Project there is no legal and non-Ethical issue .We make our project according to all ethical and legal rules. That’s why this feasible.

2.3. Project/ Product Scope Our project has a big scope. We can store information of all the student & college record. College Management system is categorized according to various streams. Student and college can maintain their information and can update it.Notification are sent to student and parents Student and college department can access previous information about college There are following modules and forms are used:

2.3.1

Admission and Fee

This module helps the management in managing the complete admission process with ease. It integrates operations and processes of admission and fees at colleges. It administers set-up of faculty members of all departments. This includes medium of instruction, fee cashbooks, fee heads and fee types etc. It also enables feeding and restoring data of course details and caste category. Below are the basic features of this module: • Students receive SMS and email alerts of fees transactions • All details of admissions can be fed on the software Operations that are processed in this Module: • Student registration

2.3.2 Student Administration This is the most integral and essential module of the College . Details of students, faculty and staff with other details of certificates, documents, sections, and enrollment numbers are maintained on the software. Below is a list of few operations, the ERP automates: ● Creation of admitted student record ● Allotment of roll number, registration number, section and subjects ● Updating of student dues and fines

2.3.3 Program Management This most essential module of erp. Details of all programs related to College Management system added. And according to these modules students select their programs 2.3.4 Attendance This modul...