CENTRAL MINDANAO UNIVERSITY
College of Information Sciences and Computing
DEPARTMENT OF INFORMATION TECHNOLOGY
“Web-based Queue Management System for
Bukidnon Provincial Hospital – Kibawe, Bukidnon (Out Patient Department)”
A research proposal
Presented to the faculty of
Department of Information Technology
IT100.1 Capstone 1
Preseted by:
Emar Vince L. Oliveros
Jea May S. Pamotongan
Jelvsz Emmanuel B. Camello
Donah Rae P. Verula
Adviser
March 2023
Chapter 1
Introduction
Background of the Study
Staying healthy has ever been so important as the need to remain in good
health can have a positive effect on almost every aspect of our lives as we are all
only Steward’s and must live the best of it, Because Health is the greatest of human
blessings (Hippocrates). Medical resources are highly in demand in every state as
well as medical facilities and accommodation. More resources and greater
organization are two key recommendations made to increase the capacity of
healthcare systems to meet the requirements and expectations of the general public.
It evaluates the relationship between the accessibility of healthcare resources and
the degree to which patients' positive ratings of their healthcare experience and their
utilization of services are related. Findings indicate that patients’ evaluations of their
care experience and use of services were higher when the availability of resources
was either limited or average. In no case were positive ratings of services and
greater use of them associated with greater resource availability. Thus, simply
adding resources runs the risk of diminishing, rather than improving, user’s
healthcare experience. There are over 1000 hospitals in the Philippines including the
private and public hospitals in cities and some of the municipalities all of them has
different facilities in their way of service and liabilities.
Out Patient Department or (OPD office) in Bukidnon Provincial Hospital in
Kibawe, Bukidnon, Philippines an area of the hospital designated for the care of
outpatients, or people with health issues who visit the facility for diagnosis or
treatment but do not currently need a bed or to be admitted for overnight care. One
of the issues of the particular department is the lack of doctors on duty for check ups
and tests that makes the office much crowded and populous due to everyday
transactions who really needs their attention.
The OPD inside the office system structure caters many kinds of healthcare
proceedings. The utmost responsibility belongs to the doctors in charge or in duty to
cater all the patients need and concerns. It can’t be denied that beside the quantity
of patient and clients, each of them takes enough time inside with the nurses and the
doctor depending on their cases and health issues. In BPH Kibawe the OPD office
also takes responsible in providing medical test results and doctor approval for
outside requirements, application and etc. Healthcare facilities are under enormous
pressure to provide an improved quality of care to more patients while coping with
limited resources. For hospitals, in particular, this often means a stressful experience
for both patients and staff alike (Henk Varkevisser February 2021).
The said office has their own system, sequence and proper execution of task
inside, the only thing they are looking forward is the convenience and comfort they
can offer to people waiting outside, for some of them are pregnant women, others
are bitten by animals that needs direct penetration, and others are old enough to wait
for a long period of time without assurance to be entertained in an exact time due to
the huge number of patients every day to accommodate. The researchers long to
solve the particular concern through implementing the Web-based Queue
management system. According to Saeid Jafarzadeh Ghoushchi (Mar 2022) “It is
widely recognized that a well-designed healthcare process must provide timely and
easy access to healthcare facilities for all patients.” The concern is addressed to all
the patients waiting outside and make a probable way to assess discomfort.
Objectives of the study
The primary objective of this capstone project is to design, develop, and
deploy a web-based queue management system that will assist the hospital staffs of
Kibawe Bukidnon Provincial Hospital, in accommodating their patients in the
Outpatient department by providing them the best way in terms of waiting through a
Queue Management generated by the system. Specifically, it aims to:
1. Gather and analyze each data, provide the list of service of the said
office generated by the web-based Queue Management system.
2. Design a web-based Queue management system that will provide the
following:
a. Application/System that is both interactive and user-friendly.
b. Generate a personalized accommodation by providing a
priority number for each individual. In a faster and more easier
way.
3.Develop a web-based queue management system that can generate
client data management and give an accurate schedule notification to each client.
4. Evaluate the web-based queue management system.
Significance of the study
The study aims to address the stress and difficulty on waiting and will give help
for all the patients according to their needs and transaction offered by the said office.
Setting up standard service and less hustle line system through providing a web-
based priority number. This study will show how the created system by the
researchers will be a subtle guide in which the clients won’t have the overwhelming
pressure.
CUSTOMERS/PATIENTS
This system/study will give an assurance to the patients for them to be
accommodated by the hospital within the day. And also become more beneficial for
them that they can do other concern and priority while waiting for each queue turn
through the system at the same time.
ADMIN.
The system will help the admin office workers even the doctors in doing their
work better,and appropriate, for it improves proper sequential execution for the
patients. And improve the number of people having each transaction to the said
office everyday that makes it more productive. Through a versatile way of service by
the help of the system to all the Out Patient individual.
FUTURE RESEARCHERS.
This research will be a useful reference and basis for the researchers who
would plan to make any Web-based queuing management related studies. This
study will give them enlightenment to give more and any other features or depth to
their study based on this particular topic.
Scope and Limitations
This research focuses on providing much better service in assisting patients
outside the OPD office in BPH Kibawe in waiting for their queue turn, through a web
based system design. The study is addressed and intended only for BPH Kibawe,
the system’s data collection and accommodation is conducted to all the patients who
has individual appointment to the OPD according to the specific services offered by
the said office.
The study limits its coverage and will not cover all the entire offices of BPH
kibawe,but only the Out Patient Department. And prioritize the proper execution of
queue turn by providing a web-based priority number in sequence to each patients.
Statement of the problem
The main problem that this particular office area needs to be solve is the long
patient waiting time that result from a poor appointment system, poor resource
allocation, and poor patient flow management in outpatient department. The area
has to be time relevant for it is very important to cater all the patient need
accordingly. By the help of the proponents’ proposed system design, the queue
management system will help the people who has transaction to the said
department to be assured of their accommodation and time, while the hospital staff
assigned to the same department will be able to properly handle the flow of their
patients through some interface that provides the logs of their patients provided by
the system.
Listed specific issue:
1. Lack of office specific service information list.
2. Difficulty in getting priority number and no assurance of accommodation due
to a crowded facility, that causes unfortunate type of service.
3. No direct Data and Information gathering..
CHAPTER II
TECHNICAL BACKGROUND
1 HTML
The term HTML stands for HyperText Markup Language. HTML is a language.
used to produce electronic documents known as pages, as well as the standardized
system for tagging text files in order to achieve visuals and linking effects on the
World Wide Web.
The computer language used to create websites is known as HyperText
Markup Language (HTML). The language, which contains code words and grammar
like any other language, is reasonably straightforward to understand and, as time
goes on, becomes increasingly powerful in terms of what it allows someone to
produce. HTML continues to evolve to satisfy the demands and expectations of the
Internet under the aegis of the World Wide Web Consortium, the group that designs
and maintains the language; for example, with the transition to Web 2.0.
2 CSS
CSS is stand for Cascading Style Sheet and it is a simple design language that
is meant to make the process of making web pages presentable easier. The CSS
framework is used on most pages in this module to provide a better user experience
with the system interface. CSS was employed by the developer since it allows for the
separation of an element's content. Moreover, the system progress of HTML
document was basing on its style and layout of the creator.
CSS is a language used to describe the appearance of Web pages, such as
color, layout, and fonts. It enables the presentation to be adapted to many types of
devices, such as huge screens, small screens, or printers. CSS is not dependent on
HTML and can be used in conjunction with any XML-based markup language. The
separation of HTML from CSS makes it easier to maintain sites, share style sheets
across pages, and tailor pages to different environments.
The developer used this CSS because it is a great tool that allows us to create
great-looking web pages. After all, CSS can be used for very basic document text
styling especially in changing color and size of headings and links.
3 Sublime Text 3.0
Sublime Text is a Windows text editor. It is a fantastic tool to use when creating
code, markdown, or any other text-based format. It also includes numerous
capabilities that enable you to edit quickly and efficiently.
Another feature that the developer appreciate about Sublime Text is that it is
excellent for programming. Using Sublime, The Text has a very good and simple UI.
It has lovely colors and fonts, and it is simply lovely to look at. Basically, Sublime
Text is an excellent choice if we are a programmer or use a lot of code. It contains
several capabilities, including a very beautiful syntax highlighter. In addition, the
syntax highlighter will highlight the code in a way that makes it easier to read. It also
does an excellent job of auto-completing the context code.
4 PHP
A PHP is a hypertext preprocessor, which is a widely used programming
language created for web development and the creation of dynamic web pages. A
PHP code will be placed within the HTML source document for the same purpose.
This document will be interpreted by the web server and a processing module that
generates web pages. Because of the compatibility factor, the developer picked PHP
as the serverside programming language. ASP is another server-side scripting
language, although it is reported to be slow and is a proprietary system that is
natively utilized solely on Microsoft Internet Information Server, according to
(Spencer, 2017).
5 My SQL
MySQL is an open source relational database management system. Basically,
MySQL is a SQL-based relational database management system designed for use
as a web database. It is utilized in a variety of applications, including data cleaning.
Significantly, it is the standard language for relational database management
systems, according to ANSI (American National Standards Institute).
During the development process, the developer discovered that SQL is quite
important. SQL is used in the development stage to get massive volumes of records
from a database rapidly and efficiently. SQL is commonly used to insert, update,
delete, and retrieve records from a database. However, while getting records, it is
also feasible to use SQL to connect two or more tables and display them as one
object.
6 Bootstrap
Bootstrap provides various tools for developing web applications and websites.
It is a framework embedded with HTML. As we can see Bootstrap is an open-source.
In terms of web page designing, the developer finds out that Bootstrap is the most
popular CSS Framework for developing responsive and mobile-first websites. With
this, Bootstrapping is the process of designing how different frames and menus are
positioned on the page and in relation to one another.
The developers choose this because it quite easy to use. It comes with HTML +
CSS templates that can be used for typography, buttons, navigation, forms and
various other components with an ease. After all, it contains JavaScript extensions
as well.
7 JavaScript
In creating websites, JavaScript is quite simple to use and it enables the
creator to design highly responsive interfaces that improve the user experience and
give dynamic functionality without having to wait for the server to respond and
display another page.
The developer used this JavaScript because is suited to the system project and
all web sites now include JavaScript, a scripting programming language that runs in
the visitor's web browser. The developer will also use this because we discovered
that it is extremely suited for system advancement, and JavaScript is an easy-tolearn
Web programming language.
8 Laravel
Laravel is an open-source PHP framework that is both sturdy and simple to
use. Laravel is also known as a web application framework that has expressive and
elegant syntax. It adheres to the model-view-controller design pattern.
The system progress of Laravel reuses existing components from other
frameworks, which aids in the development of a web application. The resulting web
application is more organized and pragmatic. In testability, The developers found
that the Laravel contains tools and helpers that aid in testing by running multiple test
scenarios. This feature aids in the maintenance of the code in accordance with the
criteria.
2.9 Web Hosting
Web hosting is a service that allows businesses and individuals to publish their
websites or web pages on the Internet. This kind of platforms provides website that
is hosted to be viewed in the internet. In addition, the system progress of this web
hosting, is that most hosting providers require users to have their own domain name.
Web hosts provide the technology and resources required for the effective and
secure operation of your website. They are responsible for keeping the server up
and running, implementing security measures, and ensuring that data.
CHAPTER III
REVIEW OF THE RELATED LITERATURE
This chapter discusses the existing study into the context of proceeding related
research. These research study cited articles and systems, which are pragmatic that
are based on research and design of the developer to meet the user’s need.1
Review of Related Concept
2 Review of Related Systems
Local Related Study
QueueRite System
QueueRite is a complete enterprise software system for customer queue
management system. This software allows businesses to systematize the procedure
for customers as they line up and wait for their turn to be served. By using the
Queuerite software, customer services at the reception area will become more
efficient and the confusion brought by customers’ long lines will be minimized. SMS
Capability that allow the customers more convenience while waiting for their turn, our
system can send out SMS notifications as the customer’s queue number is getting
near. Software Customization to recognize that each business is unique, so the
queuing software can be configured to your specific needs. In-house programmers
that can customize the features and functionalities of the existing QueueRite System
to specifically suit the requirements of your business. Security-enabled the Ivant
Queue Management System requires a username / password log-in as an initial
security feature. The starting numbers for queuing are also randomized to further
safeguard the queuing process. (“Customer Queue Management System, Leading
Enterprise Software with SMS Notifications and Online Appointments.” Accessed
March 17, 2018.)
Development of Payment Queuing System with Android Application
Transactions involving basic utilities have long been universally accepted to
constitute long waiting-lines. This could be observed in health services, government
offices and school enrollment procedures. However, more often than not, taking
DLSU-D enrollment seasons to be observed and serve as an example, the mixing of
minor and major transactions not only lengthens the waiting-lines longer than is
necessary, but also inconvenience students only requiring simple and non-time-
consuming transactions as well as leaving them stranded. The group decided on
pursuing “Development of Payment Queuing System with Android Application” to
help solve and alleviate these issues through transaction categorization and
separation, and service time estimation functionalities.
The system had 4 different types of application developed, namely: a server
program; client terminal application; cashier program; and an android application.
The system as a working whole was composed of a client program that accepts
user input regarding transaction information, a MySQL server serves as a backend
database, and a P.O.S (point of sale) program allows the user to view and process
transactions in queue. In addition, a separate notification program outputs to a
monitor the current transactions being serviced and its corresponding P.O.S
terminal, it also displays as well the current queue length of both minor and major
transactions. The interfacing of all involved components is managed by a wireless
router hosting a local area network. All components are connected through cat5
cables with the exception of the android client program which interacts wirelessly.
(“Development of Payment Queuing System with Android Application.” Accessed
March 17, 2018.)
Bank of the Philippine Islands Express Assist (BEA) Online
BEA Online is an off-shoot of the BPI Express Assist (BEA) terminals installed
in the branches. BEA eliminates the need to fill-up paper forms since it now allows
branch customers to input their branch transaction details into a touch-screen
terminal instead. Upon submission, the transaction details are automatically
transmitted to the tellers and customers are issued queue numbers. Rather than
waiting in line, customers can just sit down and relax while waiting for their queue
numbers to be called.
This facility has effectively reduced the customers waiting time at the branch.
Likewise, with BEA Online, customers can now choose time-slots for their branch
transactions in advance. Customers simply need to log-in to
www.bpiexpresssonline.com, click on Other Services, and then click on BPI Express
Assist Online. After which they may choose their preferred BPI branch, date, and
time for they will fulfill the transaction, then input their transaction details. Electronic
queue numbers will be issued for the Deposit, Withdrawal, Encashment, or Bills
Payment Transactions they encoded online. (“Pattawi, Jarel. “II. RELATED
LITERATURE REVIEW.” Accessed March 17, 2018.)
Foreign Related Concept/Studies
Wireless remote queuing system and method
The disclosure describes methods and systems of allowing people to virtually
queue in a line via text messaging or mobile phone calls. The person wishing to get
in the line sends a text message or cellphone call to queuing system. Alternatively,
the person can register via a computer network connection. The queuing system the
sends a text message back to that person when it is nearly time for them to receive
the benefit of being at the front of the time. (Backer, Alejandro, and Timothy Ross
McCune. Wireless remote queuing system and method. United States
US20080133283A1, filed November 16, 2007, and issued June 5, 2008. )
Automatic Queuing Model for Banking Applications
Queuing is the process of moving customers in a specific sequence to a
specific sequence to a specific service according to the customer need. The term
scheduling stands for the process of computing a schedule. This may be done by a
queuing based scheduler. This paper focuses on the bank lines system, the different
queuing algorithms that are used in banks to serves the customers, and the average
waiting time. The aim of this paper is to build automatic queuing system for
Organizing the banks queuing system that can analyses the queue status and
take decision which customer to serve. The new queuing architecture model can
switch between different scheduling algorithms according to the testing results and
the factor of the average waiting time. The main innovation of this work concerns the
modeling of the average waiting time is taken into processing, in addition with the
process of switching to the scheduling algorithm that gives the best average waiting
time. (S.A, Ahmed, and Dr. Huda. “Automatic Queuing Model for Banking
Applications.” International Journal of Advanced Computer Science and Applications
2, no. 7 (2011).)
Automated Queue Management System
Automated queue management system is a system that helps service provider
to manage customers in efficient way. The system can ease the customer flow
management which is useful for manager of the service provider. The purpose of this
project is to develop an Automated Queue Management System for organizing
queuing system that can analyze the queue status and take decision which customer
to be served first.
This project focuses more on the banks queuing system, different queuing
algorithm approaches which are used in banks to serve customer and the average
waiting time. This queuing architecture model can switch between different
scheduling algorithms according to the testing result i.e. the average waiting time by
using two different queue control systems, which have developed. There are several
processes undergo, which control by Intel Galileo Microcontroller that is software-
compatible with the Arduino software development environment. Finally, the systems
have been tested under different conditions to evaluate its performance. (Uddin,
Md.Nasir, NA Nithe, and SZ Ahmed. “Automated Queue Management System.”
Global Journal of Management and Business Research 16 (December 31, 2015):
51–58.)
Related Systems
Queuing System Related Systems
Table 1: Related Systems
Table 1 shows features of the proposed system in the first column, whereas
the following columns are the features of the related systems.
The system that was presented were obtained from both foreign and local
system that we made basis for creating the queuing system. It additionally portrays a
feature that accessible on the system and the next system who does not accessible
to have.
All the related system discussed the different characteristics of the system that
helps to manage the customers in efficient way. The systems innovation work
concerns the factors of the average waiting time. Also, we observed absence of
security in keeping the records and statistical reports.
The system discussed are correlated to the proponent’s system, the ABC
Online Queuing System. The researchers analyzed precisely and assessed the
related system based on its modules and its functions.
The related system has made the proponents realized some capacities and
factors that would help the proposed system to be further developed, efficient and
effective for the users. Furthermore, the proponents gather some features in the
related study and merged it to the system to be greater beneficial for each student
and staff in Registrar’s office.
