Nothing Special   »   [go: up one dir, main page]

Final Report Dynamic Timetable

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 50

ABSTRACT

In this final year we have developed the project that will help people in different
sections for solving their needs and requirements.

Our project entitles “Dynamic Timetable” is meant to scheduling process in collages


which could minimize the human work and maximize the efficiency and the timetable was stored
in database which could be easy to access.
Dynamic timetable concerns all activities with regard to producing a schedule that must
be subjective to different constraints. Timetable can be defined as the optimization of given
activities, actions or events to a set of objects in space-time matrix to satisfy a set of desirable
constraints.
A collage timetable is a temporal arrangement of set of lectures and class rooms in which
all given constraints are satisfied. Creating such timetable manually is complex and time-
consuming process.
By automating this process with Dynamic Timetable can save a lot of precious time of
administrator who are involved in creating and managing timetable.
This project introduces a practical timetabling algorithm capable of taking care of both
strong and week constrains effectively.
INDEX

Sr. Chapter Name Page


No. No.

1 Introduction 1
1.1. Need for the System
1.2. Problem Definition

2 Requirement analysis & feasibility studies 3


2.1. Hardware Specification
Software Requirements:
2.2. Client server requirement
2. 3 Feasibility Study:
Technical Feasibility
Financial Feasibility
Operational Feasibility

3 System design and architecture 5


System Architecture
3.1.E-R Diagram
3.2.Activity Diagram
Activity Diagram 1(Admin login)
Activity Diagram 2(HOD Login)
Activity Diagram 3(Staff login)
3.3.Use Case Diagram
4 Coding and Screenshots 11
4.1.Screenshots
4.2.Code of software
5 Testing 19
5.1.1.Types of Tests
5.1.2.Unit Testing
5.1.3.Integration Testing

5.1.4. Functional test


5.2.System Testing
5.2.1.WhiteBox Testing
5.2.2.Black Box Testing
5.2.3.Acceptance Testing
5.3 Test cases

6 Costing 29
6.1 Cost of project

7 Other Aspects 30
7.1.Advantages
7.2.Applications
7.3.Future Scope

8 Future Scope 31
9 Conclusion and References 32
Figures: -

Fig. Name of figure Page


No. No.
1 System Architecture 5

2 E-R Diagram 6

3 Activity Diagrams 7
Activity Diagram (Admin Login)
Activity Diagram (HOD Login)
Activity Diagram (Student Login)
Activity Diagram (Registrar Login)

Index of Tables: -

Tab. Title of Table Page


No no

1 Test case table 21


CHAPTER 1
INTRODUCTION

A key factor in running an educational centre or basically an academic environment is the


need for a well-planned, well throughout and clash free timetable. Back in the days when
technology was not in wide use, timetable were manually created by academic institution.
Every collage prepares the timetable every here. To create timetable, they require much
time. Sometimes some mismatch will happen then again, they have to change the timetable. We
here with solving the problem by providing a software which can solve most of the problems.
Timetable development process starts when each Head of Department provide the following
information to be used for timetable scheduling. The information provides the modules with
class, staff, practical labs suitable constraints:
 Specified Times for lecture to be held (lecture can be scheduled).
 The venues of the scheduled lectures.
A timetabling problem consist of following parameters and they are:
 T (set of time),
 R (set of available resources),
 C (set of constraints).
This problem assigns time and resources to the contacts on a such a way that the
constraints will be satisfied. In various timetabling problems, educational timetabling has been
generally examined from practical stand point.
Dynamic timetable concerns all activities with regard to producing a schedule that must
be subjective to different constraints. Timetable can be defined as the optimization of given
activities, actions or events to a set of objects in space-time matrix to satisfy a set of desirable
constraints.

Purpose for the System:


The main purpose of this dynamic timetable system project is to update the timetable
dynamically on a particular time. There are many situations where a particular period might be
wasted because that respective subject lecturer might be busy in some other important work. Our
dynamic timetable application gathers information about all the lecturers with their respective
courses.

Detailed Problem Definition:


• Manual system of preparing time table is very time consuming and usually ends up with
same room or with same teachers having more than one class at a time
• Sometimes it is just due to common human errors which are difficult to prevent
• Sometime to overcome this, we can refer to modify previous years timetable and but still
it is an unexciting job to incorporate changes
• Sometimes due to mismatches again they have to change the timetable later on

1
Functionalities:

Over this Timetable it plays most important role that are:

• Stores the Information in database


• Human errors and efforts are reduce
• Systematic planning is done
• Personal schedular is provide (for staff)
• Manages Lectures and practical

2
CHAPTER 2
REQUIREMENT ANALYSIS & FEASIBILITY STUDIES [8]

Software Requirement Specification:

The software requirement specification is produced at the culmination of the analysis


task. The function and performance allocated to software as part of system engineering are
redefined by establishing a complete information description as functional requirement, a
representation of system behaviour, an indication of performance requirement and design
constraints, appropriate validation criteria.

Hardware Specification:

Content Description

Processors Pentium IV, i3, i5, i7.

HDD 20 GB Min
40 GB Recommended
RAM 1 GB Min
2 GB Recommended
Keyboard Standard 102 keys

Mouse 3 buttons

3
Software Specification:

Platform Windows

Language HTML,PHP

Database MySQL

Server Apache Server


Framework Bootstrap

Library Jquery

Feasibility Study:

(1) : -Technical feasibility

(2) : -Economic feasibility

(3) : -Operational feasibility

2.4.1 Technical Feasibility


As it is developed in the Windows platform using PHP and Sublime text , Brackets. It is
technically fit to run on any of Microsoft future Technology due to the Windows backward
compatibility.

2.4.2 Financial Feasibility


The project was basically constructed considering the financially feasibility of our institute, and
was completed under the expected financial restrictions.

2.4.3 Resources Feasibility


All the resources that were required to finish the project were identified and were used
according to their need to complete the project in the specified deadline.

4
CHAPTER 3 [7]
SYSTEM DESIGN AND ARCHITECTURE
E-R diagram:

5
Activity Diagram:

1. System overview

master
timetable
add
timetable

class room

log in dashboard
lab
user
staff

time

2. Module: Master Timetable:

day

master
class
timetable
add timetable
staff

class room
log in dashboard
lab
user
staff

time

3. Module: Add Timetable:

6
add
master timeslot teacher
timetable lecture
day
add subject
timetable
type
labs
class room
log in dashboard class name
practical batches subject
lab
user
teacher
staff

time

4..Module: class room

master
timetable
add timetable

add class
room
class room
log in dashboard delete
lab
user
staff

time

7
5. Module:Subject

Master

Add
Timetable

ClassRoom
Login Dashboard
Lab Sub_name
user Add
SubjectCourse
name
Delete
Time

6. Module:Lab

Master

ClassRoom
Add Lab_name
Login Dashboard Lab
Delete
user Subject

Time

8
7. Module: Timeslot

Master

Add
Timetable

Login Dashboard Lab

user Subject
Add
Add
Timeslot
Time
Delete

8. Module:Main Module

select days

Master Select class

Select Teacher

Timeslot
Sub_name
Lecture
Teacher
Add days name
Timetable Type
Labname

Class
Practical Batch Sub_name

Add ClassName Teacher


Login Dashboard ClassRoom
Delete
user
Add Lab_name
Lab
Delete

Sub_name
Add
Course
Subject
name
Delete

AddAdd
Time Timeslot
Delete

9
CHAPTER4
CODING AND SCREENSHOTS

Code for login:

<!DOCTYPE html>
<html lang="en">
<head>
<title>Timetable</title>
</head>
<body>
<div class="bg-page py-5" style="background-color: #3c8dbc ">
<div class="container">
<!-- main-heading -->
<h2 class="main-title-w3layouts mb-2 text-center text-
black">Admin Login</h2>
<!--// main-heading -->
<div class="form-body-w3-agile text-center w-lg-50 w-sm-
75 w-100 mx-auto mt-5">
<form method="post" action="" id="formval" >
<div>
<label>Username</label>
<input type="text" name="username" class="form-
control" placeholder="Username">
</div>
<div>
<label>Password</label>
<input type="password" name="password"
class="form-control" placeholder="Password">
</div>

10
<button type="submit" name="btn_login" class="btn
btn-primary error-w3l-btn mt-sm-5 mt-3 px-4"
id="login">Login</button>
</form> </div> </div> </div>
</body></html>
<?php
include "database.php";

if (isset($_POST['btn_login'])) {

if (isset($_POST['username']) and isset($_POST['password']))


{
$username = $_POST['username'];
$password = $_POST['password'];
$query ="SELECT * from admin where username= '$username'
and password= '$password'";
$result = mysqli_query($connection, $query);
$count =
mysqli_num_rows($result); if
($count == 1)
{
//$_SESSION['username'] = $username;
header("location:dashboard.php");
}
else
{
echo "<script type='text/javascript'>alert('Invalid Login
Credentials')</script>";
//echo "invalid credentials";
header("location.href= 'index.php';");

}
}
}
11
?>

12
Code for lab add:

<!DOCTYPE html>
<html>
<head>
</head>
<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">

<header class="main-header">

<!-- Logo -->


<a href="index2.html" class="logo">
<!-- mini logo for sidebar mini 50x50 pixels -->
<span class="logo-mini"><b>Admin</b></span>
<!-- logo for regular state and mobile devices -->
<span class="logo-lg"><b>Admin</b>Panel</span>
</a>

<!-- Header Navbar: style can be found in header.less -->


<nav class="navbar navbar-static-top">
<!-- Sidebar toggle button-->
<a href="#" class="sidebar-toggle" data-toggle="push-menu"
role="button">
<span class="sr-only">Toggle navigation</span>
</a>
<!-- Navbar Right Menu -->
<div class="navbar-custom-menu">
<ul class="nav navbar-nav">
<!-- Messages: style can be found in dropdown.less-->
<!-- Notifications: style can be found in dropdown.less -->
<li class="dropdown notifications-menu">

13
<li>
<!-- inner menu: contains the actual data -->

<!-- Tasks: style can be found in dropdown.less -->

<!-- User Account: style can be found in dropdown.less -->


<li class="dropdown user user-menu">
<a href="#" class="dropdown-toggle" data-
toggle="dropdown">
<img src="img/index.jpg" class="user-image" alt="User
Image">
<span class="hidden-xs">Admin</span>
</a>
<ul class="dropdown-menu">
<!-- User image -->
<li class="user-header">
<img src="img/index.jpg" class="img-circle" alt="User
Image">

<p>
Government Polytechnic Nashik
</p>
</li>

</li>
<!-- Menu Footer-->
<li class="user-footer">

<div class="pull-right">
<a href="index.php" class="btn btn-default btn-flat"
style="color: red">Sign out</a>
</div>
</li>
</ul>

14
</li>
<!-- Control Sidebar Toggle Button -->
<!-- <li>
<a href="#" data-toggle="control-sidebar"><i class="fa fa-
gears"></i></a>
</li> -->
</ul>
</div>

</nav>
</header>
<!-- Left side column. contains the logo and sidebar -->
<aside class="main-sidebar">
<!-- sidebar: style can be found in sidebar.less -->
<section class="sidebar">
<!-- Sidebar user panel -->
<div class="user-panel">
<div class="pull-left image">
<img src="img/index.jpg" class="img-circle" alt="User
Image">
</div>
<div class="pull-left info">
<p>Admin</p>
<a href="#"><i class="fa fa-circle text-success"></i>
Online</a>
</div>
</div><br><br>
<!-- search form -->
<!-- <form action="#" method="get" class="sidebar-form">
<div class="input-group">
<input type="text" name="q" class="form-control"
placeholder="Search...">
<span class="input-group-btn">
<button type="submit" name="search" id="search-btn"
class="btn btn-flat">

15
<i class="fa fa-search"></i>
</button>
</span>
</div>
</form> -->
<!-- /.search form -->
<!-- sidebar menu: : style can be found in sidebar.less -->
<ul class="sidebar-menu" data-widget="tree">
<li class="header">MAIN NAVIGATION</li>
<li>
<a href="dashboard.php">
<i class="fa fa-dashboard"></i>
<span>Dashboard</span> </a>
</li>

<li>
<a href="addttdemo.php">
<i class="fa fa-files-o"></i>
<span>Add Timetable</span> </a>
</li>

<li>
<a href="classroom.php">
<i class="fa fa-th"></i>
<span>Classroom</span> </a>
</li>

<li>
<a href="lab.php">
<i class="fa fa-pie-chart"></i>
<span>Labs</span></a>
</li>

<li>

16
<a href="staff.php">
<i class="glyphicon glyphicon-user"></i>
<span>Staff</span> </a>
</li>

<li>
<a href="subject.php">
<i class="app-menu icon fa fa-files-o"></i>
<span>Subject</span> </a>
</li>

<li>
<a href="time.php">
<i class="glyphicon glyphicon-time"></i>
<span>Time</span> </a>
</li>

</section>
<!-- /.sidebar -->
</aside>

<div class="content-wrapper">

<section class="content-header">
<h1> Lab </h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i>
Home</a></li> <li class="active">Lab</li>
<li class="active">Add Lab</li>
</ol>
</section>
<hr>
<hr>
<form id="formval" action="" method="post">

17
<div>
<div class="form-group col-md-3">
<label class="control-label">Lab</label>
<input class="form-control" type="text" placeholder=""
name="lab" id="lab" >

</div><br><br><br><br>

<div class="form-group col-md-2">


<a href=""> <button class="btn btn-success"
type="submit" name="addlab" id="addlab" ><i class="fa fa-fw fa-
lg fa-check-circle" ></i>Add Lab</button></a>
</div>
</div>
</form>
<!-- jQuery 3 -->
<script
src="bower_components/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap 3.3.7 -->
<script
src="bower_components/bootstrap/dist/js/bootstrap.min.js"></scrip
t>
<!-- FastClick -->
<script src="bower_components/fastclick/lib/fastclick.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.min.js"></script>
<!-- Sparkline -->
<script src="bower_components/jquery-
sparkline/dist/jquery.sparkline.min.js"></script>
<!-- jvectormap -->
<script src="plugins/jvectormap/jquery-jvectormap-
1.2.2.min.js"></script>
<script src="plugins/jvectormap/jquery-jvectormap-world-mill-
en.js"></script>
<!-- SlimScroll -->

18
<script src="bower_components/jquery-
slimscroll/jquery.slimscroll.min.js"></script>
<!-- ChartJS -->
<script src="bower_components/chart.js/Chart.js"></script>
<!-- AdminLTE dashboard demo (This is only for demo purposes) -
->
<script src="dist/js/pages/dashboard2.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
</body>
</html>
<?php
include("database.php");

if(isset($_POST['addlab']))
{
if($connection)
{
$lab=$_POST['lab'];
$query=mysqli_query($connection,"INSERT INTO lab (lab)
VALUES('$lab')");
if($query)
{
echo "added successfully";
}
else{

echo mysqli_error($connection);
}

}
}

?>

19
Code for lab module :

</head>
<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">

<header class="main-header">

<!-- Logo -->


<a href="index2.html" class="logo">
<!-- mini logo for sidebar mini 50x50 pixels -->
<span class="logo-mini"><b>Admin</b></span>
<!-- logo for regular state and mobile devices -->
<span class="logo-lg"><b>Admin</b>Panel</span>
</a>

<!-- Header Navbar: style can be found in header.less -->


<nav class="navbar navbar-static-top">
<!-- Sidebar toggle button-->
<a href="#" class="sidebar-toggle" data-toggle="push-menu"
role="button">
<span class="sr-only">Toggle navigation</span>
</a>
<!-- Navbar Right Menu -->
<div class="navbar-custom-menu">
<ul class="nav navbar-nav">
<!-- Messages: style can be found in dropdown.less-->
<!-- Notifications: style can be found in dropdown.less -->
<li class="dropdown notifications-menu">

<li>
<!-- inner menu: contains the actual data -->

20
<!-- Tasks: style can be found in dropdown.less -->

<!-- User Account: style can be found in dropdown.less -->


<li class="dropdown user user-menu">
<a href="#" class="dropdown-toggle" data-
toggle="dropdown">
<img src="img/index.jpg" class="user-image" alt="User
Image">
<span class="hidden-xs">Admin</span>
</a>
<ul class="dropdown-menu">
<!-- User image -->
<li class="user-header">
<img src="img/index.jpg" class="img-circle" alt="User
Image">

<p>
Government Polytechnic Nashik
</p>
</li>
</li>
<!-- Menu Footer-->
<li class="user-footer">

<div class="pull-right">
<a href="index.php" class="btn btn-default btn-flat"
style="color: red">Sign out</a>
</div>
</li>
</ul>
</li>
<!-- Control Sidebar Toggle Button -->
<!-- <li>

21
<a href="#" data-toggle="control-sidebar"><i class="fa fa-
gears"></i></a>
</li> -->
</ul>
</div>

</nav>
</header>
<!-- Left side column. contains the logo and sidebar -->
<aside class="main-sidebar">
<!-- sidebar: style can be found in sidebar.less -->
<section class="sidebar">
<!-- Sidebar user panel -->
<div class="user-panel">
<div class="pull-left image">
<img src="img/index.jpg" class="img-circle" alt="User
Image">
</div>
<div class="pull-left info">
<p>Admin</p>
<a href="#"><i class="fa fa-circle text-success"></i>
Online</a>
</div>
</div><br><br>
<!-- search form -->
<!-- <form action="#" method="get" class="sidebar-form">
<div class="input-group">
<input type="text" name="q" class="form-control"
placeholder="Search...">
<span class="input-group-btn">
<button type="submit" name="search" id="search-btn"
class="btn btn-flat">
<i class="fa fa-search"></i>
</button>
</span>

22
</div>
</form> -->
<!-- /.search form -->
<!-- sidebar menu: : style can be found in sidebar.less -->
<ul class="sidebar-menu" data-widget="tree">
<li class="header">MAIN NAVIGATION</li>
<li>
<a href="dashboard.php">
<i class="fa fa-dashboard"></i>
<span>Master Timetable</span> </a>
</li>

<li>
<a href="stafftt.php">
<i class="fa fa-user"></i>
<span>Staff Timetable</span> </a>
</li>
<li>
<a href="addttdemo.php">
<i class="fa fa-files-o"></i>
<span>Add Timetable</span> </a>
</li>

<li>
<a href="classroom.php">
<i class="fa fa-th"></i>
<span>Classroom</span> </a>
</li>

<li>
<a href="lab.php">
<i class="fa fa-pie-chart"></i>
<span>Labs</span></a>
</li>

23
<li>
<a href="staff.php">
<i class="glyphicon glyphicon-user"></i>
<span>Staff</span> </a>
</li>

<li>
<a href="subject.php">
<i class="app-menu icon fa fa-files-o"></i>
<span>Subject</span> </a>
</li>

<li>
<a href="time.php">
<i class="glyphicon glyphicon-time"></i>
<span>Time</span> </a>
</li>
</section>
<!-- /.sidebar -->
</aside>
<div class="content-wrapper">

<section class="content-header">
<h1> Dashboard </h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i>
Home</a></li>
<li class="active">Lab</li>
</ol>
</section><hr><hr>

<h3 class="tittle-w3-agileits mb-4" style="font: italic;">List of


Lab</h3>
<table class="table" style="background-color:
#3c8dbc;" border="5" id="table" >

24
<thead class="thead-dark">
<tr>
<th scope="col">Sr. No.</th>
<th scope="col">Lab</th>
<th scope="col">Action</th>
</tr>
</thead>
<tbody><br>

<a href='addlab.php' class="btn btn-success" style="float:


right;" >Add Lab</a><br><br><br>

<?php
include "database.php";
$query = mysqli_query($connection,"SELECT * FROM lab");
$n=1;
if($query) {
while($row = mysqli_fetch_array($query)){

?>
<tr>
<th scope="row"><?php echo $n; ?></th>
<td><?php echo $row['lab']; ?></td>
<td><a href='deletelab.php?srno=<?php echo
$row['srno']; ?>' class="btn btn-danger">Delete</a></td>
<?php $n++; ?>
</tr>
<?php

}
}
?>

</table >
</html>

25
SCREENSHOTS:

Log in:

Master timetable:

26
Staff Timetable :

Add timetable :

27
Lecture assign :

Overlapping:

28
Overlapping error:

Add practical :

29
Class module:

Add class :

30
Labs :

Add lab :

31
Staff :

Add staff :

32
Subject :

Add subject :

33
Add timeslot :

34
CHAPTER 5

TESTING
System testing

System testing tests the system as a whole. Once all the components are integrated,
the application as a whole is tested rigorously to see that it meets the specified Quality
Standards. This type of testing is performed by a specialized testing team.

System testing is important because of the following reasons:

a. System testing is the first step in the Software Development Life Cycle,
where the application is tested as a whole.
b. The application is tested thoroughly to verify that it meets the functional
and technical specifications.

Types of Tests

Unit testing

This type of testing is performed by developers before the setup is handed over to the
testing team to formally execute the test cases. Unit testing is performed by the respective
developers on the individual units of source code assigned areas. The goal of unit testing is to
isolate each part of the program and show that individual parts are correct in terms of
requirements and functionality.

Integration testing

Integration testing is defined as the testing of combined parts of an application to


determine if they function correctly. Integration testing can be done in two ways: Bottom
up integration testing and Top-down integration testing.

35
Functional test

Functional tests provide systematic demonstrations that functions tested are available
as specified by the business and technical requirements, system documentation, and user
manuals. Functional testing is centered on the following items:

Valid Input: identified classes of valid input must be accepted.

Invalid Input: identified classes of invalid input must be rejected.

Functions: identified functions must be exercised.

Output: identified classes of application outputs must be exercised.

System Test

System testing tests the system as a whole. Once all the components are integrated,
the application as a whole is tested rigorously to see that it meets the specified Quality
Standards. This type of testing is performed by a specialized testing team.

White Box Testing

White-box testing is the detailed investigation of internal logic and structure of the code.
White-box testing is also called glass testing or open-box testing. In order to perform white-box
testing on an application, a tester needs to know the internal workings of the code.

Black Box Testing

The technique of testing without having any knowledge of the interior workings of the
application is called black-box testing. The tester is oblivious to the system architecture and
does not have access to the source code. Typically, while performing a black-box test, a tester
will interact with the system's user interface by providing inputs and examining outputs
without knowing how and where the inputs are worked upon.

36
Acceptance Testing

This is conducted by the Quality Assurance Team who will gauge whether the
application meets the intended specifications and satisfies the client’s requirement.

Test Cases:
Login Model:
Sr. Test Test case Step I/P Data Expected Actual Status
no Case Objective Result Result
ID
1 TC1 If a user 1.open Enter the Username Login Pass
will be able the login username and successfully
to login form and password
with a valid 2.write password is valid ,so
username username login the
and valid and page
password password
TC2 If a user 1.open Wrong Message Invalid Fail
2 cannot the login password for invalid password
login with form password
a valid 2.enter
username the valid
and an username
invalid and
password invalid
password
TC3 When the Does not Message Message It required Fail
3 filed is enter for this for this username
blank and password filed filed and
submit and required required password
button is username username username
clicked and and
password password
TC4 If user is Enter Correct User User login Pass
4 able to username username should be to
login and and login to Dashboard
successfully password correct dashboard
password
5 TC5 Verify the Enter the Wrong Message Message Pass
message for invalid username for invalid for invalid
invalid password and password password
and password and and
username username username

37
2) MasterTimeTable Model:

SR. Test Test case step I/P data Expected Actual Status
No case objective result result
id
1 TC2 To check 1.select Select the Does not Does not Fail
add the the day day submit submit
day and 2.click successfully successfully
does not submit
add class button
Whether
is submit
or not
2 TC2 To check 1.select Select the It show the It show the Fail
does not the class class message message
add day 2.click on please add please add
and add submit the day the day
class
Whether
is submit
or not
3. TC3 To check 1.does Does not show the It show the Fail
does not not select select message message
select class and class and please add please add
day and day day the day the day
class 2.click on
submit
4 TC4 To check 1.does select show the It show the Fail
does not not select teacher message message
add day day please add please add
and add 2.click on the day the day
teacher submit
Whether
is submit
or not

38
3) Add Time Tabel Model:

Sr. Test Test case Step I/P Data Expected Actual Status
No case objective result Result
id
1 TC1 Does not 1.select Does not Show the It show Fail
select on other select message the
timeslot module timeslot enter message
2.does timeslot
not select
Timeslot
3.click
on
submit
2 TC2 Does not 1.select Does not Show the It show Fail
select on other select type message the
type module model select the message
model 2.does item
not
select
type
model
3.click
on
submit
3 TC3 Does not 1.select Does not Show the It does Pass
select on other select day message not show
day module select the the
2.does item message
not
select
day
3.click
on
submit
4 TC4 If select 1.select select same It show the It does pass
same all item timeslot, message not show
timeslot, 2.click same day teacher are the
same day on and same already message
and same submit class name assign
class This class
name and this
timeslot

39
40
4) All module:
Sr. Test Test case step I/P Data Excepted Actual status
No case objective output output
id
1 TC1 Add staff 1. click Add the Show the Add staff pass
on the staff message successfully
add add staff
button successfully
2. then
click on
submit
2 TC2 Delete 1. click Delete the Show the Delete staff pass
the staff on the staff message successfully
delete delete staff
button successfully
2. then
delete
the staff
3 TC3 add the 1.click add the Show the Add class pass
class on the class message successfully
add add class
button successfully

4 TC4 Delete 1.click Delete the Show the Delete class Pass
the class on the class message successfully
delete delete class
button successfully

5 TC5 add the 1. click add the lab Show the Add lab pass
lab on the message successfully
add add lab
button successfully
2. then
add the
lab
6 TC6 Delete 1. click Delete the Show the Delete lab pass
the lab on the lab message successfully
delete delete lab
button successfully
2. then
delete
the lab
7 TC7 add the 1.click add the Show the Show the pass
subject on the subject message message
add add subject add subject
button successfully successfully

41
2. then
add the
subject
8 TC8 Delete 1. click Delete the delete Delete pass
the on the subject subject subject
subject delete successfully successfully
button
2. then
delete
the
subject

42
CHAPTER 6
COSTING [8]

Cost of project:

Sr. No. Title Cost

1. Work hour 80

2. Group members 4

3. Charges per hour 500

4. Total work charges 80x500= 40,000 (per person)

5. Total charge 40,000x 4 = 1,60,000

6. Internet hours 40

7. Cost per hour 50

8. Total internet charge 2000

9. Printing and other costs 500

10. Computer charges 500

11. Total cost Rs.1,63,000

43
CHAPTER 7
OTHER ASPECTS

Advantages:

There are some of advantages for the using the Dynamic Timetable instead of manually
creating Timetable. Those are:

• Save time and efforts .


• Reduces error.
• Verification of timetable
• Secure and user-friendly.
• Substitution management : easy to allocate teacher in case of absent teacher .
• Smooth integration .
• Creating a paperless environment.
• Inexpensive
• Fast result because of dynamic nature
• Scalability
• Multiple timetable management
• Modularity

Disadvantage:
While we are using the Dynamic Timetable there are also 2 drawbacks those are:

• Limited scope: Only limited for the collage


• Time consuming : To implement this type of Timetable is complex task and manage.

44
CHAPTER 8
FUTURE SCOPE

SCOPE OF THE SYSTEM:


• generation of timetable,
• access the available timetables is easy
• modify/Delete an existing timetable are possible
• Add/modify faculty details of a department is possible.
• Add/modify semester wise subject details.
• Add/modify time scheduling and period allocation process.

FUTURE SCOPE OF SYSTEM:


 By making change and little bite modification ,system can be use for other institute and
organization also.
 Use for large institute also.

45
CHAPTER 9
CONCLUSION AND REFERENCES

The intension of the project is to update timetable dynamically. This aimed to


improve efficiency of scheduling. It also address the important hard constraint
of clashes between the availability of staff, class room and labs. The non-rigid
soft constraints that is optimization objectives are also effectively handled.
It eventually can be used to generate timetable of specific class, staff, class room
and labs and to generate master timetable. This complete process of storing data
and retrieving data from database and that can scheduled timetable by considering
constraints

References
 https://en.wikipedia.org/wiki/Bootstrap_(front-end_framework)
 https://www.guru99.com/what-is-php-first-php-program.html
 https://www.php.net/manual/en/intro-whatcando.php

46

You might also like