final synopsis
final synopsis
S
MAHARAHTRA STATE BOARD OF TECHNICAL EDUCATION,
MUMBAI
Project Report on
Guided By
Prof. P.W.Gadpayle
CERTIFICATE
This is to certify that the project of computer 3 rd year satisfactorily completed project
entitled “COLLEGE MANAGEMENT SYSTEM” for the partial fulfillment of
diploma in Computer Engineering (CO) of Institute of Engineering and Technology
(Polytechnic), Kannad for academic year 2024-2025.
Name Enrollment No
Miss. Gauri Mukund Nilakhe 2211570103
GUIDED BY
Prof. P.W.Gadpayle
I would like to express my sincere gratitude to all those who have contributed to the successful
completion of this project synopsis for the College Management System.
First and foremost, I extend my heartfelt thanks to my project guide, [Guide’s Name], for their
invaluable guidance, continuous encouragement, and constructive feedback throughout the planning
and development of this project. Their expertise and advice have been instrumental in shaping the
direction of my work.
I would also like to thank the faculty members of the [Department Name] at [College Name] for
providing a solid foundation of knowledge, which enabled me to approach this project with
confidence. Special thanks to [Supervisor/Instructor's Name] for their support and assistance, which
greatly facilitated my work.
I am grateful to my peers and colleagues, who offered helpful insights and feedback during
discussions. Their perspectives contributed significantly to refining my ideas and approach.
Finally, I would like to thank my family and friends for their constant support and motivation, which
kept me focused and motivated throughout this project.
Thank you all for your valuable contributions to making this project successful.
Introduction:
The "College Management System" has been developed to override the problems prevailing in the
practicing manual system. This software is supported to eliminate and in some cases reduce the
hardships faced by this existing system. Moreover this system is designed for the particular need of
the company to carry out operations in a smooth and effective manner.
The application is reduced as much as possible to avoid errors while entering the data. It also
provides error message while entering invalid data. No formal knowledge is needed for the user to
use this system. Thus by this all it proves it is user-friendly. College Management System , as
described above, can lead to error free, secure, reliable and fast management system. It can assist the
user to concentrate on their other activities rather to concentrate on the record keeping. Thus it will
help organization in better utilization of resources.
Every organization, whether big or small, has challenges to overcome and managing the informations
of Course, College, Faculty, Exam, Students. Every College Management System has different
College needs, therefore we design exclusive employee management systems that are adapted to your
managerial requirements. This is designed to assist in strategic planning, and will help you ensure
that your organization is equipped with the right level of information and details for your future
goals. Also, for those busy executive who are always on the go, our systems come with remote access
features, which will allow you to manage your workforce anytime, at all times. These systems will
ultimately allow you to better manage resources.
Background:
With the rapid advancement of technology, educational institutions are increasingly moving toward
digital solutions to manage their administrative and academic processes. Traditional methods of
handling student records, faculty information, course schedules, and communication often involve
manual work, which can be inefficient, error-prone, and difficult to maintain as institutions grow in
size. Colleges today are seeking integrated, mobile solutions to streamline these processes, reduce
workload, and enhance accessibility for all stakeholders.
The College Management System addresses these needs by providing an Android-based platform
developed in Java. This system is designed to automate and simplify various tasks, such as student
registration, attendance tracking, grading, and course scheduling. By creating a centralized system
accessible via mobile devices, colleges can improve efficiency, reduce paperwork, and provide
students, faculty, and administrative staff with convenient access to the information they need.
The growing use of mobile devices among students and educators has made Android a popular choice
for educational applications. An Android-based management system allows users to access data and
perform tasks anytime and anywhere, making it easier for colleges to ensure real-time information
flow and communication. This accessibility supports a more organized and responsive academic
environment, where students and faculty can actively engage with the institution and keep track of
important updates and tasks.
This project’s background highlights the need for digital transformation in college management,
aiming to provide an intuitive and reliable system that can handle the complexities of academic
administration. The College Management System is a response to these requirements, offering a
mobile-friendly, secure, and efficient way to manage essential college operations.
Abstract:
The purpose of College Management System is to automate the existing manual system by the help of
computerized equipments and full-fledged computer software, fulfilling their requirements, so that
their valuable data/information can be stored for a longer period with easy accessing and
manipulation of the same. The required software and hardware are easily available and easy to work
with.
College Management System, as described above, can lead to error free, secure, reliable and fast
management system. It can assist the user to concentrate on their other activities rather to concentrate
on the record keeping. Thus it will help organization in better utilization of resources. The
organization can maintain computerized records without redundant entries. That means that one need
not be distracted by information that is not relevant, while being able to reach the information.
The aim is to automate its existing manual system by the help of computerized equipments and full-
fledged computer software, fulfilling their requirements, so that their valuable data/information can
be stored for a longer period with easy accessing and manipulation of the same. Basically the project
describes how to manage for good performance and better services for the clients.
Literature Survey:
The evolution of digital technologies has significantly impacted the educational sector, prompting
many institutions to adopt information management systems to improve efficiency and service
delivery. Numerous studies highlight the importance of such systems in enhancing operational
effectiveness, streamlining communication, and reducing administrative overhead. This literature
survey examines existing works on management systems, particularly those tailored to colleges, to
understand the strengths and limitations of current solutions and identify areas where a mobile-based,
Android application could add value.
The main objective of the Project on College Management System is to manage the details of
College, Course, Batch, Faculty, Students. It manages all the information about College, Exam,
Students, College. The project is totally built at administrative end and thus only the administrator is
guaranteed the access. The purpose of the project is to build an application program to reduce the
manual work for managing the College, Course, Exam, Batch. It tracks all the details about the Batch,
Faculty, Students.
Provides the searching facilities based on various factors. Such as College, Batch,
Faculty, Students
Editing, adding and updating of Records is improved which results in proper resource
management of College data.
Our project aims at Business process automation, i.e. we have tried to computerize
various processes of College Management System.
In computer system the person has to fill the various forms & number of copies of the
forms can be easily generated at a time.
In computer system, it is not necessary to create the manifest but we can directly print it,
which saves our time.
To assist the staff in capturing the effort spent on their respective working areas.
To utilize resources in an efficient manner by increasing their productivity through
automation.
The system generates types of information that can be used for various purposes.
It satisfy the user requirement
Be easy to understand by the user and operator
Be easy to operate
Have a good user interface
Be expandable
Delivered on schedule within the budget.
Modules:
College Management Module: Used for managing the College details.
Students Module: Used for managing the details of Students
Batch Module: Used for managing the Batch details
Faculty Module: Used for managing the Faculty information
Login Module: Used for managing the login details
Users Module: Used for managing the users of the system
Input Data and Validation:
All the fields such as College, Batch, Students are validated and does not take invalid
values
Each form for College, Course, Exam can not accept blank value fields
Preparation of the possible test data with all the validation checks.
In the first step, we will select the test factors and rank them. The selected test
factors such as reliability, maintainability, portability or etc, will be placed in the
matrix according to their ranks.
The second step is for identifying the phases of the development process. The
phase should be recorded in the matrix.
The third step is that identifying the business risks of the software deliverables. The
risks will be ranked into three ranks such as high, medium and low.
Features:
The old manual system was suffering from a series of drawbacks. Since whole of the
system was to be maintained with hands the process of keeping, maintaining and retrieving the
information was very tedious and lengthy. The records were never used to be in a systematic
order. there used to be lots of difficulties in associating any particular transaction with a
particular context. If any information was to be found it was required to go through the different
registers, documents there would never exist anything like report generation. There would
always be unnecessary consumption of time while entering records and retrieving records. One
more problem was that it was very difficult to find errors while entering the records. Once the
records were entered it was very difficult to update these records.
The reason behind it is that there is lot of information to be maintained and have to be
kept in mind while running the business. For this reason we have provided features Present
system is partially automated (computerized), actually existing system is quite laborious as one
has to enter same information at three different places.
Documents and reports that must be provided by the new system: there can also be few
reports, which can help management in decision-making and cost controlling, but since
these reports do not get required attention, such kind of reports and information were also
identified and given required attention.
B. Technical Feasibility
This included the study of function, performance and constraints that may affect the
ability to achieve an acceptable system. For this feasibility study, we studied complete
functionality to be provided in the system, as described in the System Requirement Specification
(SRS), and checked if everything was possible using different type of frontend and backend
platforms.
C. Operational Feasibility
No doubt the proposed system is fully GUI based that is very user friendly and all inputs
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.
System Design of College Management System
In this phase, a logical system is built which fulfils the given requirements. Design phase of
software development deals with transforming the clients’s requirements into a logically
working system. Normally, design is performed in the following in the following two steps:
The general tasks involved in the design process are the following:
The following steps are various guidelines for User Interface Design:
2. The screen should be formatted so that various types of information, instructions and
5. Default values for fields and answers to be entered by the user should be specified.
7. The system user should never get an operating system message or fatal error.
Preliminary Product Description:
The first step in the system development life cycle is the preliminary investigation to
determine the feasibility of the system. The purpose of the preliminary investigation is to
evaluate project requests. It is not a design study nor does it include the collection of details to
describe the business system in all respect. Rather, it is the collecting of information that helps
committee members to evaluate the merits of the project request and make an informed judgment
about the feasibility of the proposed project.
Benefit to Organization
The organization will obviously be able to gain benefits such as savings in operating cost,
reduction in paperwork, better utilization of human resources and more presentable image
increasing goodwill.
The initial cost of setting up the system will include the cost of hardware software (OS,
add-on software, utilities) & labour (setup & maintenance). The same has to bear by the
organization.
Running Cost
Besides, the initial cost the long term cost will include the running cost for the system
including the AMC, stationary charges, cost for human resources, cost for update/renewal of
various related software.
The users along with the administrator need to be trained at the time of implementation
of the system for smooth running of the system. The client will provide the training site.
We talked to the management people who were managing a the financial issues of the
center, the staff who were keeping the records in lots of registers and the reporting manager
regarding their existing system, their requirements and their expectations from the new proposed
system. Then, we did the system study of the entire system based on their requirements and the
additional features they wanted to incorporate in this system.
Reliable, accurate and secure data was also considered to be a complex task without this
proposed system. Because there was no such record for keeping track of all the activities, which
was done by the College Management System on the daily basis.
The new system proposed and then developed by me will ease the task of the
organization in consideration. It will be helpful in generating the required reports by the staff,
which will help them to track their progress and services.
Thus, it will ease the task of Management to a great extent as all the major activities to be
performed, are computerized through this system.
Project Category:
Relational Database Management System (RDBMS) : This is an RDBMS based project which is
currently using MySQL for all the transaction statements. MySQL is an opensource RDBMS
System.
RDBMSs have become a predominant choice for the storage of information in new databases
used for financial records, manufacturing and logistical information, personnel data, and much
more since the 1980s. Relational databases have often replaced legacy hierarchical databases and
network databases because they are easier to understand and use. However, relational databases
have been challenged by object databases, which were introduced in an attempt to address the
object-relational impedance mismatch in relational database, and XML databases.
Implementation Methodology:
Model View Controller or MVC as it is popularly called, is a software design pattern for
developing web applications. A Model View Controller pattern is made up of the following
three parts:
Model - The lowest level of the pattern which is responsible for maintaining data.
View - This is responsible for displaying all or a portion of the data to the user.
Controller - Software Code that controls the interactions between the Model and View.
MVC is popular as it isolates the application logic from the user interface layer and supports
separation of concerns. Here the Controller receives all requests for the application and then works
with the Model to prepare any data needed by the View. The View then uses the data prepared by
the Controller to generate a final presentable response. The MVC abstraction can be graphically
represented as follows.
MVC (Model View Controller Flow) Diagram
Software
Requirements:
Name of component Specification
Operating SystemWindows 98, Windows XP, Windows7,
Linux
Language Java 2 Runtime Environment
Database MySQL Server
Browser Any of Mozilla, Opera, Chrome etc
Web Server Tomcat 7
Software Development Kit Java JDK 1.7 or Above
Scripting Language Enable JSP (Java Server Pages)
Database JDBC Driver MySQL Jconnector
Software Requirements:
Hardware Requirements:
System analysis is a process of gathering and interpreting facts, diagnosing problems and
the information about the College Management System to recommend improvements on the
system. It is a problem solving activity that requires intensive communication between the
system users and system developers. System analysis or study is an important phase of any
system development process. The system is studied to the minutest detail and analyzed. The
system analyst plays the role of the interrogator and dwells deep into the working of the present
system. The system is viewed as a whole and the input to the system are identified. The outputs
from the organizations are traced to the various processes. System analysis is concerned with
becoming aware of the problem, identifying the relevant and decisional variables, analyzing and
synthesizing the various factors and determining an optimal or at least a satisfactory solution or
program of action. A detailed study of the process must be made by various techniques like
interviews, questionnaires etc. The data collected by these sources must be scrutinized to arrive
to a conclusion. The conclusion is an understanding of how the system functions. This system is
called the existing system. Now the existing system is subjected to close study and problem areas
are identified. The designer now functions as a problem solver and tries to sort out the
difficulties that the enterprise faces. The solutions are given as proposals. The proposal is then
weighed with the existing system analytically and the best one is selected. The proposal is
presented to the user for an endorsement by the user. The proposal is reviewed on user request
and suitable changes are made. This is loop that ends as soon as the user is satisfied with
proposal. Preliminary study is the process of gathering and interpreting facts, using the
information for further studies on the system. Preliminary study is problem solving activity that
requires intensive communication between the system users and system developers. It does
various feasibility studies. In these studies a rough figure of the system activities can be
obtained, from which the decision about the strategies to be followed for effective system study
and analysis can be taken.
Existing System of College Management System:
In the existing system the exams are done only manually but in proposed system we have to
computerize the exams using this application.
Lack of security of data.
More man power.
Time consuming.
Consumes large volume of pare work.
Needs manual calculations.
No direct role for the higher officials
This is normally represented as the data about data. It is also termed as metadata some
times which gives the data about the data stored in the database. It defines each data term
encountered during the analysis and design of a new system. Data elements can describe files or
the processes.
= equivalent to
+ and
[] either/ or
() Optional entry
1. Words should be defined to understand for what they need and not the variable
need by which they may be described in the program .
2. Each word must be unique. We cannot have two definition of the same client.
3. Aliases or synonyms are allowed when two or more enters shows the same
meaning. For example a vendor number may also be called as customer number.
4. A self-defining word should not be decomposed. It means that the reduction of any
information in to subpart should be done only if it is really required that is it is not
easy to understand directly.
Data dictionary includes information such as the number of records in file, the frequency a
process will run, security factor like pass word which user must enter to get excess to the
information.
Conclusion:
Our project is only a humble venture to satisfy the needs to manage their project work.
Several user friendly coding have also adopted. This package shall prove to be a powerful
package in satisfying all the requirements of the school. The objective of software planning is to
provide a frame work that enables the manger to make reasonable estimates made within a
limited time frame at the beginning of the software project and should be updated regularly as
the project progresses.
A description of the background and context of the project and its relation to work
already done in the area.
Made statement of the aims and objectives of the project.
The description of Purpose, Scope, and applicability.
We define the problem on which we are working in the project.
We describe the requirement Specifications of the system and the actions that can be
done on these things.
We understand the problem domain and produce a model of the system, which
describes operations that can be performed on the system.
We included features and operations in detail, including screen layouts.
We designed user interface and security issues related to system.
Finally the system is implemented and tested according to test cases.
Future Scope of the Project:
In a nutshell, it can be summarized that the future scope of the project circles around
maintaining information regarding:
The above mentioned points are the enhancements which can be done to increase the
applicability and usage of this project. Here we can maintain the records of College and Course.
Also, as it can be seen that now-a-days the players are versatile, i.e. so there is a scope for
introducing a method to maintain the College Management System. Enhancements can be done
to maintain all the College, Course, Batch, Faculty, Students.
We have left all the options open so that if there is any other future requirement in the
system by the user for the enhancement of the system then it is possible to implement them. In
the last we would like to thanks all the persons involved in the development of the system
directly or indirectly. We hope that the project will serve its purpose for which it is develop there
by underlining success of process.
Limitation:
Although I have put my best efforts to make the software flexible, easy to operate but
limitations cannot be ruled out even by me. Though the software presents a broad range of
options to its users some intricate options could not be covered into it; partly because of logistic
and partly due to lack of sophistication. Paucity of time was also major constraint, thus it was
not possible to make the software foolproof and dynamic. Lack of time also compelled me to
ignore some part such as storing old result of the candidate etc.
Considerable efforts have made the software easy to operate even for the people not related
to the field of computers but it is acknowledged that a layman may find it a bit problematic at
the first instance. The user is provided help at each step for his convenience in working with the
software.
Excel export has not been developed for College, Course due to some criticality.
The transactions are executed in off-line mode, hence on-line data for Batch, Faculty
capture and modification is not possible.
Off-line reports of College, Students, Batch cannot be generated due to batch mode
execution.
References and Bibliography:
Google for problem solving
http://www.javaworld.com/javaworld/jw-01-1998/jw-01-Credentialreview.html
Database Programming with JDBC and Java by O'Reilly
Head First Java 2nd Edition
http://www.jdbc-tutorial.com/
Java and Software Design Concepts by Apress
https://www.tutorialspoint.com/java/
http://www.javatpoint.com/java-tutorial
https://docs.oracle.com/javase/tutorial/
http://www.wampserver.com/en/
http://www.JSP.net/
http://www.tutorialspoint.com/mysql/