International Journal of Current Engineering and Technology E-ISSN 2277 – 4106, P-ISSN 2347 – 5161
©2015INPRESSCO
®
, All Rights Reserved Available at http://inpressco.com/category/ijcet
General Article
849| International Journal of Current Engineering and Technology, Vol.5, No.1 (Feb 2015)
College Office Automation System
Praful Gavaskar
†
, Sachin Gupta
†
, Diksha Patil
†*
and Vikas More
†
†
Department of Computer Engineering, Mumbai University, Rajendra Mane College of Engineering and Technology, Ambav, Devrukh, India
Accepted 22 March 2015, Available online 29 March 2015, Vol.5, No.2 (April 2015)
Abstract
This is an Intranet application used to automate operations related to a typical office management of a college. This
allows a user to log in and add details of fees accounts, payments and Recruitment. It also provides search of fees
accounts, payments report and easy access to the databases. This based on workflow technology, Office Automation
system, office, and many other items can be integrated with the work. Overall project is divided into two main parts.
One part contains admin panel which is in control of user manager/engineer/super user. Second part contains the
different users of application like office user for add or update student database, examination cell user for update
pass or fail status of students in the database (This will help to various department user to maintain student
promotion record and make attendance sheets as well as the corrections in student info), department user allowed to
view the database and correct the mistakes in student data, but not allows to delete any entry. This also allows a user
to log in and add details of fees accounts, payments and Recruitment. It also provides search of fees accounts,
payments report and easy access to the databases. The database lies on a central system or Server and the same can
be accessed via HTML browser on a system connected peer-to-peer in network. The concept of Office Automation
System provides key advantage of data integrity, no data duplication, and easy data backup. This is an user-friendly
interface.
Keywords: Intranet Application, Student Database, Employee Database and Recruitment.
1. Introduction
1
Almost every office and college has adapted a digital
system to control their basic information of staff and
students to eliminate paper work. But use of traditional
database softwareǯs compiled are difficult to use,
requires huge amount of space and are actually not
user-friendly. An Intranet based College Automation
System for enhance the ease of access to student
database and accounting of payments. Reduce multiple
copies of database. Machine independent system
running in a local area network. A centralized
database is a database located and maintained in one
location, unlike a distributed database. One main
advantage is that all data is located in one place.
Acentralized database holds all of an organizationǯs
data on a central computer such as a mainframe
computer or server. Users in the organization can
access the data from their own PC or terminal.
An intranet is a computer network that uses Internet
Protocol technology to share information, operational
systems, or computing services within an organization.
This term is used in contrast to extranet. Sometimes,
the term refers only to the organization's internal
*Corresponding author: Diksha Patil
website, but may be a more extensive part of the
organization's information technology infrastructure,
and may be composed of multiple local area networks.
The objective is to organize each individual's desktop
with minimal cost, time and effort to be more
productive, cost efficient, timely, and competitive.
An intranet is a computer network that uses Internet
Protocol technology to share information, operational
systems, or computing services within an organization.
This term is used in contrast to extranet, a network
between organizations, and instead refers to a network
within an organization. Sometimes, the term refers
only to the organization's internal website, but may be
a more extensive part of the organization's information
technology infrastructure, and may be composed of
multiple local area networks. The objective is to
organize each individual's desktop with minimal cost,
time and effort to be more productive, cost efficient,
timely, and competitive. Office Automation system is
based on php code which can be accessed via a web
browser from any PC, hence any authorized individual
can access his/her data at any time & anywhere with
user-friendly interface.
2. Proposed Method
Application have separate student database for each
section/branch of college. Multiple users are allowed to