WACHEMO UNIVERSITY DURAME CAMPUS

COLLEGE OF ENGINEERING AND TECHNOLOGY

DEPARTMENT OF COMPUTER SCIENCE

Project on
Web Based Class Scheduling System for WCU/DU
Prepared by: -………………………………….ID N.o

[Link] Aref………………………14D/3008
[Link] Legesse…………………..14D/2956

Advisor Name: Inst. Selamu S.

Final project I
Submitted to Department of Computer Science, college of engineering and technology of
WCU/DC, in Partial fulfillment for the requirement of the Degree of Bachelor of
Science in (Computer Science)
WCU/DC, ETHIOPIA
May, 2017
 CHAPTER ONE
Introduction
Scheduling is the process of arranging, controlling and optimizing work and workloads in a production process or manufacturing process. Timetabling concerns all activities with regard to producing schedule that must be subjective to different constraints.

The problem is to manage a time table of all classes of school, according to the teacher, for any school class scheduling management is very complex and time consuming task.
The school used the manual way of preparing the class schedule. With the manual system, more time and labor force is required to plot, arrange, and revise the class schedules, room utilization and teacher load provided by the program committee.
With these problems, the project team will propose a project of creating an automated class scheduling system that uses its own algorithm to assign resources in most efficient and accurate manner. This schedule management system module automatically creates schedules for the class and the class teacher.
1.2 Background of the project

Scheduling is used in different educational areas such as: colleges, and universities
(higher educational institutions) and doing this takes a lot of time and resources. Based
on this we proposed to solve the problem of the existing scheduling system of Wachemo
University Durame Campus for Colleges by developing web based scheduling system.
Our proposed system will eliminate weaknesses of the existing system by providing fast
and easy class scheduling system.

Students and Instructors can view their class schedule online. This system will also
provide benefits for the college by providing simple mechanism to schedule classes.
Generally the proposed system will be able to improve previous resources, time
consuming and tedious way of scheduling system.
1.3 Statement of the Problem

The existing Class Scheduling System at WCU/DC is susceptible to different labor and time
problems. The main problems of the current Class Scheduling System are as follows.

Repetition of work: if there are any changes to be made during scheduling class manually the data
will have to be entered again. At times the worker would forget to make the changes or forget that they
had already altered it and might redo it again, it’s again time consuming.

Time conflict: during scheduling class one class can have more than one course at the same time.
And class duplication is also based on the time conflict.

Inconsistency of data: there will be unavailability for future use, since data might get misplaced
during manual scheduled class .so data won’t be preserved properly for future use.
Slow retrieval of data: the information of instructors list, students list, building list, course list, lecture
classroom list stored in a paper it takes a long time to retrieve the data (information).

Too much paper work: since everything and every detail like instructors list, students list, building
list, course list, lecture classroom list and so on in the current class schedule are written down
manually in paper there will be too much paper work.

Scheduling all classrooms take lot of time.

Besides, it is highly error prone because it is done by human not by computer and a number of human
labor is required.

The loss of manpower (employee power),wastage of time to prepare manually class scheduling
system.

Hence, the development of this project is critically important to address the problems listed above.
1.4 Objectives of the project
The objective of this project is to clearly understand the problem of manual class scheduling
management system in Wachemo University Durame Campus (WCU/DC) and develop web based class schedule
system which minimize work load and time consuming, improve the quality of service delivered to the student

1.4.1 General Objective

The general objective of this project is to develop Web based class scheduling system for Wachemo University
Durame Campus.

1.4.2 Specific Objectives

The specific objective of this project includes: -
 Identify the user requirements using interviews, questionnaires and document analysis
 Design the system for implementation with detailed UML specifications.
Develop a system that can replace the manual class scheduling system based on the UML design
specifications.
 Test the system for any defects using different white and black box test mechanisms
 Integrate help facilities with respect to the use of the application
1.5 Scope of the project

This project focuses on the current work flow of class scheduling system of WCU/DC. The scope of this
project is hence bounded to replacing the manual class scheduling system activities that are currently
undertaken at ADU by a more convenient web-based system that removes the obstacles stated in the
statement of problem. Generally the scope of the new proposed system includes:-
 Class scheduling
 View class scheduled
 The new system is going to perform storing data for:-
 Offered courses of each department.
 Assigned instructors of each offered courses.
 Assigned class rooms.
 Allocated time (period) of each course.
1.6 Limitation of the project
The Project does not include:
The system doesn’t provide service for disable peoples such as peoples that can’t visualize, unable to
hear and the like.
Make up class
Add and Drop Students
Weekend classes and extension
Exam scheduling system

1.7 Significance of the Project

After implementing this automated system it is very easy to schedule class. This system solves the
previous time consuming and tiresome system it saves a lot of time and money, scheduling is very fast
and delays can be avoided and it helps the university in reducing costs such as labor and stationary.
And it avoids wastage of time in teaching and learning process.
1.8 Existing Problem
The existing Class Scheduling System at WCU/DC is susceptible to different labor and time problems.
The main problems of the current Class Scheduling System are as follows.

Repetition of work: if there are any changes to be made during scheduling class manually the data
will have to be entered again. At times the worker would forget to make the changes or forget that they
had already altered it and might redo it again, it’s again time consuming.

Time conflict: during scheduling class one class can have more than one course at the same time. And
class duplication is also based on the time conflict.

Inconsistency of data: there will be unavailability for future use, since data might get misplaced
during manual scheduled class .so data won’t be preserved properly for future use.

Slow retrieval of data: the information of instructors list, students list, building list, course list, lecture
classroom list stored in a paper it takes a long time to retrieve the data (information).
1.9 Proposed Solution
The main purpose of our project which is Web Based Class Scheduling System is to justify the problems
which are found on the existing class scheduling system that we describe above.

Because of the existence of the new system it changes the use of manually system application forms to
the computerized system. This System can be improved quality or increased predictability of quality and
improved robustness (consistency), of processes or product. This project is centered on the design and
implementation of computer software’s that handle class scheduling system for WCU/DC. It aims at
providing applications that will make the processing of WCU/DC very easy and reliable.

[Link] Scheduler:
 The system will save the time to schedule time table.
 it also enable the scheduler to easily manage records
 Reduce errors and overlapping of time table.
2. For Student: The student gets quickly service (i.e. view their class schedule) due to Web Based Class
Scheduling System.

3. For Instructor: The instructor gets quickly service (i.e. view their class schedule) due to
Web Based Class Scheduling System.

1.9.1 Feasibility Study

Feasibility is the measure of how the new system is viable or beneficial from the existing system. It is an
ongoing process done frequently during systems development projects in order to achieve a creeping
commitment from the user and to continually assess the current status of the project.

1.9.2 Technical Feasibility

Usually new systems established in order to overcome the technical illness of the previous system. In the
same way, this system is technically big enough to be applied easily to the problem identified in the
existing system. In addition that, both hardware’s and software’s for this system are highly available and
can be owned with small cost. Therefore, it can be concluded that the system is technically feasible
1.9.3 Operational Feasibility

The system will operate on any operating systems or platforms which have apache installed.
Therefore the system will operate in any kind of platforms .so the entire team member expects the system
to be operationally feasible.

1.9.4 Political Feasibility

The system is politically feasible cannot cause any harm or it does not have an influence in the
environments. The project is beneficial because it satisfies the objectives of the customer or the
university. System is free from any problems because there is no negative side to user or workers to
university.

1.9.5 Economic Feasibility

This feasibility is used for evaluating the effectiveness of a new system. In economic analysis the
procedure is to determine the benefits and savings that are expected from a candidate system and
compare them with costs. If benefits outweigh costs, then the decision is made to design and implement
could also be referred to as cost/benefit analysis.
 Hardware cost
Materials Quantity Unit price Total price

DVD-RW 2 140.00 Birr 280.00 Birr

Flash 16GB 3 200.00 Birr 600.00 Birr

Paper 500 1.00 Birr 500.00 Birr

Print 5 times (proposal 40.00 Birr 200.00 Birr

phase, analysis phase,
design phase,
implementation and
Table 1: hardware cost presentation)
Total 800.00 Birr

Materials Quantity Unit price Total price

Programming PHP Trial 0

Software Cost tools
Database tool MYSQL Trial 0
Table 2: software cost
database
1.9.6 Schedule feasibility

Schedule feasibility is used to determine how the proposed system accomplished with the given
Timetable. It implies effective time management for the system, and the project should finished within
deadline. So the team implemented and configured the system on time without any delay.
The project schedule is according to the time it has schedule the documentation and the time to time
activities will be done on time.

1.10Team composition
Project title Web Based Class Scheduling system

Prepared by S. Name ID Email Responsibility

Table 3:Team composition No.
1 Yirga Aref 14D/3008 Yirgaaref71@[Link] Code developer
m
Data collector
2 Yared Legesse 14D/2956 Data collector

Date 2026 G.C

advisor Selamu S
1.11 Task and Time schedule

We have conducted our study in a team of two students, each of which is responsible for the project to
accomplish. We have met twice in a week for two weeks, and we stayed on to observe our work for about
16 hours during the two weeks.
Activities Month

No March April May June July August September October November December

1 Project title 14
Submitted
2 Analysis phase 21

3 Proposal 2

4 Design phase 19

5 Coding 19 29

6 Implementation & 30 30
Testing

7 Project 23
close-up

Table 4:Task and Time schedule