Developing E-College System

Sarmad M. Hadi *    Yousif N. Younis **  
* Assistant Lecturer, Al-Nahrain University, College of Information Engineering, Iraq, Baghdad.
** Undergraduate Student, Al-Nahrain University, College of Information Engineering, Iraq, Baghdad.

Abstract

Modern technologies are capable of solving problems quickly, cheaply and effortlessly. Our college with all its departments needs a well automated system for managing its resources such as Financial Department, Registration Department or the Library And/or the Warehouse. IBECS is an intranet- based system that replaces the handwork with a well-designed and easy to use computer software that is accessible from smart phones, PC and other devices allowing the employees to manage and control theirs data easily in just a few clicks. Reliability and security are the major advantages that an employee gets from IBECS. The system contains many features to improve the user experience and get the tasks done as fast as possible. It has takes care of GUI (Arabic, English) to suit all types of users.

Keywords :

Introduction

E-College system comprises four components to replace the paperwork done in college departments.

The E-College system is a software that manages college related information. It has SQL database as backend. Some of the components are programmed using C# and others, written in PHP depending on the requirements.

The system's GUI is user friendly very easy to use and no previous skills or knowledge are needed to use it.

IBECS organizes and manages data that the employees enter in the system and do some operations on that data such as insert, delete, update and/or query for all departments (financial, registration, warehouse and the library).

The requirements were gathered from the heads of departments in the college and they provided us with the key points, i.e the main problems in the current applications which they were facing before using this work.

Vision

Extend the system to handle the whole university.

1. Previous work

EduSec has a suite of selective modules specifically tailored to the requirements of education industry. EduSec is engineered and designed considering a wide range of management functions within the university. With the use of EduSec, staff can be made more accountable as it helps to know the performance of each department in just a few seconds. Almost all departments within education industry (e.g. admission, administration, time table, examination, HR, finance etc.) can be synchronized and accessed. EduSec helps to assign the responsibilities to employee staff and can reduce time wastage and can speed up the administrative functions. Core functions like admissions, library management, transport management, students' attendance, in short entire range of university functions can be well performed by EduSec. [1]

Panacea ERP Online College Automation Software brings an effective system to manage all the aspects of a college. From Enquiry Management, to Registration Admission Exams, Timetable Management process, with the college and outside, maintaining student records etc are integrated its one system. Thus Panacea Online College Automation System provides an integrated solution for complete computerization for Colleges. [2]

Awapal Solutions College Management Software is a fully loaded web-based Software. Web based computing method helps in saving money, time, and infrastructure; It help in managing the entire work, hassle free. It is a fully integrated software suite, user friendly and tailor-made, which is designed as a complete suite of all modules and features, which makes it most versatile School Management Software for play schools, medium or senior secondary schools.

Its versatile scheduling system allows to administer all aspects and functionalities of institutional organizations. It gives a cutting-edge performance, solves complicated tasks and connects all the staff, teachers, students, and parents. It fulfils the entire administrative requirements in real time.

The objective of Awapal Solutions College Management Software is to provide a comprehensive view that provides complete control that allows track of inside and outside activities, vital information and helps the staff to execute their work on time and in the proper method. [3].

Goal

Replace paperwork with a well automated system that fulfill all the needs.

2. Objectives

 

3. Design Overview

The system has been designed to comprise four main components:

3.1 Inventory System.

An inventory control system is a system that encompasses all aspects of managing a company's inventories; purchasing, shipping, receiving, tracking, warehousing and storage, turnover, and reordering. Computerized inventory control systems make it possible to integrate the various functional subsystems that are a part of the inventory management into a single integrated system. [4]

The inventory application is software made using C# programming language based on windows platform, composed of GUI and a database. It has the capabilities to delete, modify, add, search and print the database using a few clicks. The database used is SQL database that is stored locally.

3.2 Library Intranet-based Application

Library Systems are the means and methods of organizing a library. Librarians increasingly depend on technology to manage and organize resources for the benefit of users. These resources are diverse and require increasingly sophisticated systems. [5]

The library application is an intranet application that runs on any platform using any web browser, and could be reached using the internet from anywhere, any time. It is planned to be set on the college's server. Library application, implemented uses many script languages for instance PHP, HTML, J Query and Java Script. The application could be used by multiple users at the same time, and also by the librarian who has the absolute control on the data (delete, add, update, search, print).Many features exist such as:

 

3.3 Registration Department Application:

It is software to manage all the day to day operations for a university.

Student registration system is a structure that provides a simple set-up of programs for student enrollment. It is an approach that enables colleges and universities to supervise better a growing number of enrollments.

Student registration system radically reduces the work and cost involved by getting rid of paper work. [6]

The registration application is a windows based application designed and implemented using C# programming language, and it performs all essential operations on data such as add, delete, update, search and print. Each student will have a profile with all his/her information stored on a database that is locally stored. The database used is SQL.

3.4 Finance Department Application:

Financial software is built on the principles of financial information management. It may be executed as standalone software or as part of a financial information system (IS).Most financial software incorporates all facets of personal or business finance. [7]

Finance application is an application designed and implemented using C# programming language and it supports the basic operations on data such as add, delete, update, search and print. It is a well automated software that reduces effort and time. The data base used is SQL database and is locally stored.

The constituent components are illustrated in Figure 1.

Figure 1. Proposed System Components

4. System Overview

The whole data is stored in the database. In intranet applications the database is located in the server, whereas in windows applications they are stored locally on the same computer. Figure 2 and Figure 3 illustrates the system:

Figure 2. E-College System Architecture (Desktop Apps)

Figure 3. E-College System Architecture (Intranet Apps)

 

The proposed system uses the server as a bridge between the application and the SQL database.

The Windows based application interaction model sends the data requested by the client to the local SQL database and gets the results after querying, to display it to the user.

In intranet application (Library software) the server is responsible for the communication between the users or the librarian and the database. The server should control the access to the database to protect the system and enhance the level of security.

5. Problem Domain

This paper proposes a system that can replace paper work at the college with a well automated software that can help to push the productivity forward and it can handle any potential problem.

The proposed system will help to achieve the following:

 

6. The proposed System Design

The entire system provides the essentials functions:

 

6.1 Library application flow chart

Figure 5 depicts the library application flowchart

6.2 Login Page

The library application requires the librarian (admin) username and password to manage books and perform other operations. Figure 5 shows the login page.

Figure 4. Library Application Flowchart.

Figure 5. Login Page

6.3 library application home page

If the username and password provided in the login page are valid, then the admin will be directed to the home page. Figure 6 shows the home page.

Figure 6. Library Application Home Page.

6.4 Inventory application

Another component of the system is the inventory application, which allows the user to do the five basic operations (add, delete, update, print and search) on records. Figure 7 shows the inventory application user interface.

Figure 7. Inventory Application GUI.

6.5 Registration Application

The registration application is another component of the system which deals with the student registration. It also lets the employees at registration department to do the required operations on data. Figure 8 shows the registration application GUI.

Figure 8. Registration Application GUI.

6.6 Finance Application

The fourth component of the system is the finance component, which also allows the user to search, delete, add, print and update the information. Figure 9 shows the finance application user interface.

Figure 9. Finance Application GUI.

7. Research Methodology

 

8. Suggestions for Future Works

There are many aspects that can be used to improve and develop the proposed system. Some of the suggestions are:

 

Conclusion

The proposed project was taken to the next level by offering the required set of tools to reduce the time required to do the job, and lessen the efforts. The four components of the system do the job of replacing the paperwork and provide the features that should exist to be used by each division of the college. The system is well automated and has user friendly GUIs.

References

[1]. EduSec, (2015). EduSec College Management Software, RudraSoftech. http://www.rudrasoftech.com/ product/edusec-college-management-software
[2]. ERP, ERP for Colleges | Universities, Web Era, http://www.panaceaerp.com/panacea_college/index. html
[3]. AWAPAL, College Management Software System, Awapal Solution Pvt.Ltd., 2012- 2014, http://www.awapalsolutions.com/college_managemen t_software.aspx
[4]. Andel, Tom, and Daniel A. Kind, Baljko, Jennifer, Bergin, Sarah, Eskow, Dennis, Haaz, Mort, Harris, Angela D, Safizadeh, M. Hossein, and Larry P. Rizman, Udo, Godwin J, Weisfeld, Barry (2015), Inventory Control Systems, “Thursday, July 9, 2015”, http://www.inc.com/ encyclopedia/inventory-control-systems.html
[5]. Jeremy Nelson (2015), “Introduction to Library Systems”, Friday, July 10, http://intro2libsys.info/textbook/ chapters/one/one.html
[6]. Atheer .s (2015), “Definition of Student Registration Syste”, Friday, July 10, https://prezi.com/ztuwn8pyjbal/ definition-of-student-registration-system/
[7]. Cory Janssen (2015), “Financial Software”, “Friday, July 10, 2015 ”,http://www.techopedia.com/definition/ 173/financial-software.