K. E.

SOCIETY’S
RAJARAMBAPU INSTITUTE OF TECHNOLOGY’S (POLYTECNIC)
LOHEGAON, PUNE-47

MICRO PROJECT
ON
College Management System

SUBMITED TO
MAHARASHTRA STATE BOARD OF TECHNICAL EDUCATION
INPARTIAL FULFILLMENT OF THE REQUIRMENTS FOR THE AWARD OF
DIPLOMA IN COMPUTER ENGNEERING
BY

Aditya Nagane
Vishwajeet Ranjwan
Sarthak Pawar

UNDER THE GUIDANCE

Mrs. Komal Lokhande
DEPARTMENT OF COMPUTER ENGINEERING
RAJARAMBAPU INSTITUTE OF TECHNOLOGY’S POLYTECHNIC
LOHEGON PUNE-411047 (2020-21)
 RAJARAMBAPU INSTITUTE OF TECHNOLOGY’S (POLYTECHNIC)
LOHEGAON PUNE -411047

CERTIFICATE

This is to certify that, the project entitled “College Management

System” has been successfully completed By Aditya Nagane impartial
fulfilment of the Requirement of Engineering Diploma Program in
COMPUTER ENGINEERING of Maharashtra State Board of Technical
Education during Academic Year 2023-2024

Mrs. K Lokhande Mr. V Jadhav Dr. K. Munde

(subject Teacher) (Head of Department) (Principal)
 DEPARTMENT OF COMPUTER ENGINEERING
RAJARAMBAPU INSTITUTE OF TECHNOLOGY’S POLYTECHNIC)
LOHEGON PUNE-411047 (2023-24)

RAJARAMBAPU INSTITUTE OF TECHNOLOGY’S (POLYTECHNIC)

LOHEGAON PUNE -411047

CERTIFICATE
This is to certify that, the project entitled “College Management
System” has been successfully completed By Vishwajeet Ranjwan
impartial fulfilment of the Requirement of Engineering Diploma
Program in COMPUTER ENGINEERING of Maharashtra State Board of
Technical Education during Academic Year 2023-2024

Mrs. K Lokhande Mr. V Jadhav Dr. K. Munde

(subject Teacher) (Head of Department) (Principal)
 DEPARTMENT OF COMPUTER ENGINEERING
RAJARAMBAPU INSTITUTE OF TECHNOLOGY’S POLYTECHNIC)
LOHEGON PUNE-411047 (2023-24)

RAJARAMBAPU INSTITUTE OF TECHNOLOGY’S (POLYTECHNIC)

LOHEGAON PUNE -411047

CERTIFICATE

This is to certify that, the project entitled “College Management

System” has been successfully completed By Sarthak Pawar impartial
fulfilment of the Requirement of Engineering Diploma Program in
COMPUTER ENGINEERING of Maharashtra State Board of Technical
Education during Academic Year 2023-2024

Mrs. K Lokhande Mr. V Jadhav Dr. K. Munde

(subject Teacher) (Head of Department) (Principal)
 Acknowledgement

We have an opportunity to express our deep sense of graduate to Mrs.

Komal Lokhande (project guide), Department of Computer, for her valuable
guidance and suggestions during the course of this project work. Her
encouragement at all stages has contribution greatly to complete this project
We thank you to Mr. V. B. Jadhav Head of Department for his continuous
Support to complete this project work.
We are also thankful to Dr. K. Munde Principle of Rajarambapu Institute of
Technology’s (polytechnic) Lohegaon, Pune-411047, for allowing us to carry out
this project.
Action Plan.

Sr No Details of Activity Planned start Date Planned Finished Signature Of Guide

Date

1 Create the group

2 Then discuss with my

group member about
topic

3 Searching information
on the computer

4 Prepare abstract of
microproject

5 Prepare report of
Microproject

6 Correct the correction

as per suggestion

7 Prepare final report

8 Submit with hard copy

to guide
 Table of content

 OBJECTIVES
 INTRODUCTION TO OUR S/V
 E-R DIAGRAM OF ENTIRE PROJECT
 Accounts
 Academic
 Training & Placement
 Examination Cell
 Data Flow Diagram
 Library
 Laboratory
 Hostel
 Cafeteria
 Transportation
 OBJECTIVE

The objective of our project is to develop a GUI (Graphical User Interface) based
software i.e. platform independent & user friendly and which can be fit into any
college system. It will remove data redundancy and will be fast in operation.

The main problems with the present college management softwares are:

 Platform dependency.
 Data redundancy problems.
 Slow in execution.
 Do not cover all the modules that should be present for a college
management software.
 Threat to security levels.
 Improper beginner tutorials.
Our software will overcome all these problems faced by any college management
software.
Though a college management software is actually custom based, as it is
developed for meeting the requirements of a particular college but we have
created the project as a global one which can satisfy the needs of all college
systems.
Features included in our software are:-
 Platform Independent
As our software is coded in java so it is platform independent i.e. it can work on
any operating system whether it be any version of Microsoft windows (98, Me. XP,
Vista (all versions), 7), Linux. Unix or any other.
  Reduced Data Redundancy
As we are using RDBMS (Relational Database Management System) in the back
end of our software, so it will overcome the problems of data duplicacy.

 Fast Execution
As our software is GUI based and it contains many new features which will make
the execution faster than any other pre-existing softwares.

 Cost Efficient
Due to the removal of data redundancy from the software, duplicity of data is
eliminated and wastage of memory is also overcome. As we know that storage
devices are cost consuming so by saving space we are saving money and providing
cost effective software.

 Inbuilt Security
Our software includes better security levels with inbuilt anti-virus & anti-hacking
facilities which will support the pre-installed anti- virus and anti-hack softwares.
 INTRODUCTION TO OUR S/V

The topic of our project is very diverse as it will manage a college which is itself a
huge organization which imparts knowledge but for its proper working many
other things work all the time along with studies.

The aim of this project is to manage each and every required section a software
can handle with accuracy eliminating many mistakes that a person on job
performs due to any reason and makes the operations even faster. Every
department for us is a module and has independent working criteria but in one
way or the other they are related with one other and collecting these modules a
college is formed which we have to manage.
E-R DIAGRAM OF ENTIRE PROJECT
 ACCOUNT

A transparency in economic balance sheet is needed by every organization, so

that it will look like a open book to all users. This will need a well maintained and
organized account system. This college management software has vast look upon
this section. In the account module we have worked on how the work can be
performed in a more easy and descent way. The scenes of concern are:-

 Proper database management

 Regular report generation
 Transparency in data for all users
In addition to this, it includes all the records related to technical and
non-technical staff. As all the possible aspects are worked upon here, so this
will definitely help in fulfilling all the user needs.
 ACADEMICS

Academics is the back bone of any college. The main point of concern for the
college management is the Academic Section, so a software developer has to keep
in mind the sub-modules according to the need of the users, which are mentioned
below:

 Dean Academics
 H.O.D.
 Faculty
 Students

However, the above sub-modules have been categorized into different points but
actually, if we notice them in depth all the sub-modules may affect each other in
one or the other way.
All the records have to be maintained and with different access privileges for
students, faculties & heads like view, view and update, update & managing
facilities respectively as it is concemed with student records or faculty records,
etc.
Apart from this, other privileges provided along with them are: The capability to
manage schedules, meetings and other tasks which are not in the tabular form
but are very necessary to maintain.
 TRAINING & PLACEMENT CELL

The Department of Training & Placement is the major concern of any institute.
From the very beginning the college lays greater emphasis on in-campus industrial
training. Practical Training for Technical Students is an integral part of the
curriculum and in-built into the programs of study. The students are introduced to
industrial practices through training in the college workshops and in factories.
Installations , work etc.

Of course, arranging for the Training and Placements of students is the primary
function, the department also takes initiative for developing right attitudes, soft
skills-especially that of verbal communication, motivating our students to have
strong technical as well as analytical capabilities, and exposing them to the
nuances of economic and financial aspects related to their professional careers.
This college management software has covered all maintenance of record.
 EXAMINATION CELL

The objective of these modules is to capture information with respect to various

parameters that required during setting unto of Examination management
modules and process the captured data to churn out requirement results.
A technical college software's examination module is mainly concerned upon:

1) In-college examination including sessionals and practicals;

2) External exams management:

a) Admit card managing.
b) External exams managing of colleges centered in the college

3) Schedule management.

This module will look upon all basic as well as advanced needs of an
examination cell.

DATA FLOW DIAGRAM

 0-LEVEL DFD
 1-LEVEL DFD
LIBRARY
A library is a collection of information, sources, resources, books, and services,
and the structure in which it is housed. In this project we have given a good
concern to the corresponding field. As in this module we have emphasized on:
 Administrator privileges management
 Book circulation
 Advanced book search options
 Proper regulation of special items like CD's and journals. In this software we
have taken care of how the hectic store of book and information material
can be handled properly and easily.

LABORATORY

A Laboratory is the crucial part of any college. Laboratory is a testing ground as it

offers opportunities for observation, practice and experimentation.
We have defined the labs as a practical component to accompany lecture or
course material, which accompanies the student to enhance his knowledge and
not only limiting it to a theoretical base. It provides a platform for the students to
get exposure to the real world, under the guidance of experienced faculty. We
have designed this software, which mainly emphasizes on the following:

 Grading of individual practical.

 Accessibility of individual record by the students.
 Details of equipments & apparatus.
Thus, this software fulfills all the needs of an efficient & self operating laboratory.

HOSTEL
Hostel is also a very important entity when college management is point of
concern since everyone in the college does not belong to the same town in which
the college is so they should be provided hostel facility so that they feel
comfortable and do not feel any type of inconvenience in the town which they
would have to face if they stay very far from college.
College hostel should take care of its structure more than any other private hostel.
So hereby we are providing a system that manages the required data that a hostel
management system would require. Following are the sub-divisions that are to be
given individual emphasis on:

 Mess
 Sports
 Committees
 Academics classes
 Extra curricular

This is all to manage and the created software will definitely help cover all these
areas of concern.

CAFETERIA
Cafeteria or canteen in any organization is very important since we have to eat to
work efficiently and many times situation occurs when we are hungry but have no
food to eat then cafeteria is the only support. Cafeteria should also provide a wide
range of food of good quality and quality to provide. The cafeteria provider should
also be able to know what the customers want more than he is providing so that
he can make more money.
The owner of cafeteria has to keep record of salary of workers and the total
collection at the end of the day and quantity of each individual product sold and
whether there was a shortage of it or it was in excess. This is easy to say but very
difficult to manage and even more difficult on paper. A cafeteria management
system could manage all these things very easily as compared to paper work and
there would be less chance of mistakes in performing any task. Here are sub-
divisions which require concern:

 Sell & Purchase Record

 Menu Management

 Workers Record

TRANSPORTATION
Transportation is the need of any organisation. It makes a system efficient &
working. This software contains an entire module of transportation. Subjects of
matter covered in this module are:-

 Proper routine of buses:

 Transportation on specific events:

 Easily guided halt charts.

This software has included many new facilities as per the transportation module is
concern. In this software a student can easily access to the bus information just by
giving his details. After a verification process he will be able to search whether
which bus or route he should avail or what is the time of corresponding route.

The efficiency of this module in this software will help in making dynamic growth
of the organisation.

REFERENCES
 https://www.slideshare.net/akhilesh_551/college-management-project

 https://www.geeksforgeeks.org/dfd-for-library-management-system/

Teacher Evaluation Sheet for Micro Project

Course Title and Code: - Software Engineering(22413)
 Title of the Project: - .

Group No: - _

COs addressed by the Micro Project:

CO :

CO :

CO :

CO :

CO :

Marks: -
Marks obtained
Marks for by the Total
Roll No. Name Of Student Group Work individual Marks
(06) based on viva (10)
(04)

Name and designation of Faculty Member: Mrs. Komal Lokhande.