Republic of the Philippines

POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

OFFICE of the VICE PRESIDENT for RESEARCH, EXTENSION and DEVELOPMENT
INNOVATION AND TECHNOLOGY SUPPORT OFFICE

JOURNAL PUBLICATION FORMAT

LAN-Based Faculty Scheduling System of Polytechnic University of the Philippines

Calauan Campus

Lyca G. Cariaga and Eugene Denielle Q. Quiroga

PUP Calauan, Polytechnic University of the Philippines, Philippines (Cariaga, Quiroga)

PUP Calauan, Polytechnic University of the Philippines, Philippines
PUP Calauan, Polytechnic University of the Philippines, Philippines (Mrs. Agnes M. Recaña,)

ABSTRACT
The LAN-Based Faculty Scheduling System of Polytechnic University of the Philippines Calauan Campus intends to
improve the current process of creating faculty and student timetables. The general objective is to create a faculty scheduling system
to manage and coordinate faculty teaching loads and schedules. The proposed system will have an important role for the faculty,
administrative staff of the institution, campus director and the institution itself as it will change the usual method of arranging the
flow of faculty and class schedules. The researcher used the Modified Waterfall Model because it allows the developers to go back to
a prior step if a fault is discovered at one stage. Because of this, the chance of changing the system before implementation is reduced.

The LAN-Based Faculty Scheduling System was evaluated and examined by five (5) IT Experts, ten (10) clients and thirty
(30) Non-IT Experts using ISO/IEC 25010 model of software evaluation. The evaluators remarked that the system was highly
acceptable with a general rating of 4.70 through the evaluation because the system passed the system qualification in terms of
Functional Suitability, Performance Efficiency, Compatibility, Usability, Reliability, Security, Maintainability and Security.

I. INTRODUCTION
Management of time is essential for running a school. Organizations employ scheduling systems to effectively assign and
manage their varied resources. These programs are used to schedule personnel, library hours, coordinate daily activities, and manage
calendars for both internal and external activity planning. A scheduling system software that allocates the workload of each instructor
for each course and year’s level is a must for any institution that handles the schedules of all its teachers and classes.
Prior to the advent of computerized scheduling systems, most schools used paper-based request combinations, Excel
spreadsheets and actual magnetic boards. Even though these techniques have been effective for some time, schedules frequently
become disorderly and challenging to maintain as a result. Fortunately, there is a more effective answer to every school's scheduling
problem.
30 out of 39 instructors at PUP Calauan are part-time employees who work a regular job off campus and teach in their spare
time. Administrators in PUP Calauan were coordinating with the faculty members one by one regarding their time-availability and
desired number of subjects faculty can teach in a semester. Thus, it would be convenient for the institution to have a faculty
scheduling system that can manage faculty loads and allow the user to assign schedules for every curriculum and teacher. The client
will be able to have a system that will arrange the flow of faculty schedules each semester by further exploring, studying, and
developing each system foundation and module.
The general objective is to create a LAN-Based Faculty Scheduling System to manage and coordinate faculty teaching loads
and schedules.

Specific objective

1. To create a module that will be able to generate the class section and course per program.
2. To design a module that will help the academic head to assign faculty members to teach for a course, assign teaching loads,
and class schedule for every faculty.
3. To design a module that will help the administrator to assign teaching loads and class schedules.
4. To develop a module that enables faculty members to set date and time availability and number of courses willing to teach.
5. To develop a module that will generate certification for faculty members that state their teaching loads.
6. To test, evaluate and to document the system.

4TH Floor South Wing, PUP A. Mabini Campus, Anonas Street, Sta. Mesa, Manila 1016
Trunk Line: 335-1787 or 335-1777 local 234
Website: www.pup.edu.ph | Email: itso@pup.edu.ph

THE COUNTRY’S 1st POLYTECHNICU ISO 9001:2015 CERTIFIED

CERTIFICATE NUMBER: AJA18-0190
 Republic of the Philippines
POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
OFFICE of the VICE PRESIDENT for RESEARCH, EXTENSION and DEVELOPMENT
INNOVATION AND TECHNOLOGY SUPPORT OFFICE

II. EXPERIMENTAL METHOD/S

The Modified Waterfall Model was used to develop the LAN-based Faculty Scheduling System of Polytechnic University of
the Philippines Calauan Campus It is made up of multiple discrete work stages that are each well-defined and used to represent the
requirements analysis, system design, implementation, testing, and maintenance processes. The Modified Waterfall Model ensures
that system flaws are corrected early in the development process by allowing developers to go back to a prior step if a fault is
discovered at one stage. Because of this, the chance of changing the system before implementation is reduced.

Modified Waterfall Model

Requirement Analysis
The researchers ensured to have a clear understanding of the
requirements and goals of the project with the use of conducting meetings,
creating requirement documentation, and reviewing project scopes before
proceeding to the next stage. When the information is complete, the
researcher finally proceeds to system design.
Design
In this phase, the researchers/developers conducted a thorough
discussion with the client about the outputs, inputs, and functionalities of
the system before proceeding to implementation.
Implementation
The researchers/developers listed the modules and features to be add weekly, and by the end of the week, the researchers
made sure to discuss the features to see if the client approves.
Testing
The researcher installed the system on the client’s personal computer. The researchers do the testing while the clients check
the features in the system.

Maintenance
The product will be delivered to the client and will be used. As issues arise, the developers may need to create patches and
updates to address them.

III. RESULTS AND DISCUSSION

The LAN-Based Faculty Scheduling System of Polytechnic University of the Philippines Calauan Campus, which is a LAN-
based scheduling system has been evaluated. This system may compile pertinent data, including qualifications for faculty members,
the preferred number of subjects they are willing to teach, their time availability, the scheduling of their class schedules, and the
production of reports on their teaching loads. The evaluators remarked that the system was acceptable and satisfactory through the
evaluation that was conducted.
The Functional Suitability of the system is evaluated as highly acceptable because the system functions have met the standards of
clients. In terms of Performance Efficiency is interpreted as highly acceptable because the system response and fast when performing.
Compatibility is evaluated as highly acceptable because the system can perform its function efficiently while sharing a common
environment with other products. In terms of Usability, it is interpreted as highly acceptable because it is an easy to use and user-
friendly scheduling system. Reliability is evaluated as highly acceptable because the system can retrieve the data and information in
case of system failure. In terms of Security, the developed system was evaluated as highly acceptable because the system ensures that
data are accessible only to those authorized to have access. In terms of Maintainability the system was evaluated as highly acceptable
because the system can be restored and retained. Portability was evaluated as highly acceptable because it was easy to install and
modify.
IV. CONCLUSION
Based on the evaluation result the following conclusion and generalization are made the developers prove that the system will be
great help to Polytechnic University of the Philippines Calauan Campus. The developers concluded that the system could generate
sections and courses per program.
1. The developed system can help the academic head assign faculty member qualified to teach a certain course.
2. The developed system can help administrators assign teaching loads and class schedule for every faculty.
3. The developed system enables the faculty members to set time and date availability and number to subjects willing to teach.
4. The developed system can provide printable faculty teaching loads and certifications for faculty members.
5. The developed system was tested, evaluated, and documented.

4TH Floor South Wing, PUP A. Mabini Campus, Anonas Street, Sta. Mesa, Manila 1016
Trunk Line: 335-1787 or 335-1777 local 234
Website: www.pup.edu.ph | Email: itso@pup.edu.ph

THE COUNTRY’S 1st POLYTECHNICU ISO 9001:2015 CERTIFIED

CERTIFICATE NUMBER: AJA18-0190
 Republic of the Philippines
POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
OFFICE of the VICE PRESIDENT for RESEARCH, EXTENSION and DEVELOPMENT
INNOVATION AND TECHNOLOGY SUPPORT OFFICE

V. REFERENCES
References must be numbered. Keep the same style.
1. Aksu and Kaya, 2018, The advantages and disadvantages of block scheduling as perceived by college students. Retrieved
from: (PDF) The advantages and disadvantages of block scheduling as perceived by middle school students
(researchgate.net)

2. Bordea. 2018, Automated Scheduling System for Thesis and Project Presentation Using Forward Chaining Method with
Dynamic Allocation Resources. Retrieved from: (PDF) Automated Scheduling System for Thesis and Project Presentation
Using Forward Chaining Method with Dynamic Allocation Resources (researchgate.net)

3. Bellardo, 2019, Preference driven university course scheduling system of California Polytechnic State University, San Luis
Obispo. Retrieved from: "PREFERENCE DRIVEN UNIVERSITY COURSE SCHEDULING SYSTEM" by Heather A.
Bellardo (calpoly.edu)

4. Davidson, 2020, Manual Scheduling Methods vs. Computerized Scheduling Methods. Retrieved from: Computerized VS
Manual Scheduling System - Office+Work (officeandwork.com)

5. Dwayne, 2018, Intelligent Agent based Student-Staff Scheduling System. Retrieved from: [PDF] Intelligent Agent based
Student-Staff Scheduling System | Semantic Scholar
6. European Institute of Operational Research, 2020, Design and implementation of a course scheduling system using Tabu
Search. Retrieved from: Design and implementation of a course scheduling system using Tabu Search (researchgate.net)

7. European Institute of Operational Research, 2019, Staff scheduling and rostering: A review of applications, methods and
models. Retrieved from: Staff scheduling and rostering: A review of applications, methods and models | Request PDF
(researchgate.net)

8. Kelly, 2019, The Pros and Cons of Block Scheduling System. Retrieved from: The Pros and Cons of Teaching in Block
Schedules (thoughtco.com)

9. freeCodeCamp.org, 2019, What is HTML – Definition and Meaning of Hypertext Markup Language. Retrieved from: What
is Hypertext Markup Language (HTML)? - Definition from Techopedia

10. Techterms.com, 2020, What is CSS – Definition and Meaning of Cascading Style Sheet.
11. Oracle.com, 2019, What-is-database. Retrieved from: CSS (Cascading Style Sheet) Definition (techterms.com)

12. https://laravel.com/, Retrieved 16 February 2022, What is Laravel?

13. Wells, C. (2022). The Waterfall Model. Retrieved 27 February 2022. Retrieved from
https://www.technologyuk.net/computing/softwaredevelopment/systemsanalysis/waterfall-model.shtml.
14. What is CSS? Definition. (2022). Retrieved 16 February 2022, https://techterms.com/definition/css

15. What is MySQL? Definition from WhatIs.com. (2022). Retrieved 16 February 2022,
https://searchoracle.techtarget.com/definition/MySQL
16.  
ACKNOWLEDGMENTS
The developers would like to acknowledge and thank the important people who have given their support and guidance
throughout the system development. The completion of this project could not have been possible without the participation and
assistance of so many people whose names may not be enumerated. However, the group would like to express deep appreciation
particularly to the following:

First and foremost, the Almighty God, for giving the developers strength and wisdom to face all the struggles that they
encounter while making the research.

Prof. Agnes Recaña, for the endless support, for encouraging and being a mentor to us in order for us to complete the system.

The Clients, for their cooperation and patience in answering the questions of the developers and giving ideas that may add in
the system.

To our dearest classmates, for support and extending their efforts in completing this project.

To our parents, for giving moral encouragement, financial, and spiritual support to finish the project.

4TH Floor South Wing, PUP A. Mabini Campus, Anonas Street, Sta. Mesa, Manila 1016
Trunk Line: 335-1787 or 335-1777 local 234
Website: www.pup.edu.ph | Email: itso@pup.edu.ph

THE COUNTRY’S 1st POLYTECHNICU ISO 9001:2015 CERTIFIED

CERTIFICATE NUMBER: AJA18-0190
 Republic of the Philippines
POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
OFFICE of the VICE PRESIDENT for RESEARCH, EXTENSION and DEVELOPMENT
INNOVATION AND TECHNOLOGY SUPPORT OFFICE

To our Sintang Paaralan, the Polytechnic University of the Philippines Calauan Campus, all the staffs and admins, for giving
us the chance to grow and show the better versions of ourselves.

*Appendices/Supplementary Data
Evaluation Instrument (IT Experts, Client, and Non-IT Experts)

Evaluation Results

IT Experts

4TH Floor South Wing, PUP A. Mabini Campus, Anonas Street, Sta. Mesa, Manila 1016
Trunk Line: 335-1787 or 335-1777 local 234
Website: www.pup.edu.ph | Email: itso@pup.edu.ph

THE COUNTRY’S 1st POLYTECHNICU ISO 9001:2015 CERTIFIED

CERTIFICATE NUMBER: AJA18-0190
 Republic of the Philippines
POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
OFFICE of the VICE PRESIDENT for RESEARCH, EXTENSION and DEVELOPMENT
INNOVATION AND TECHNOLOGY SUPPORT OFFICE

4TH Floor South Wing, PUP A. Mabini Campus, Anonas Street, Sta. Mesa, Manila 1016
Trunk Line: 335-1787 or 335-1777 local 234
Website: www.pup.edu.ph | Email: itso@pup.edu.ph

THE COUNTRY’S 1st POLYTECHNICU ISO 9001:2015 CERTIFIED

CERTIFICATE NUMBER: AJA18-0190
 Republic of the Philippines
POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
OFFICE of the VICE PRESIDENT for RESEARCH, EXTENSION and DEVELOPMENT
INNOVATION AND TECHNOLOGY SUPPORT OFFICE

Non IT Experts

4TH Floor South Wing, PUP A. Mabini Campus, Anonas Street, Sta. Mesa, Manila 1016
Trunk Line: 335-1787 or 335-1777 local 234
Website: www.pup.edu.ph | Email: itso@pup.edu.ph

THE COUNTRY’S 1st POLYTECHNICU ISO 9001:2015 CERTIFIED

CERTIFICATE NUMBER: AJA18-0190
 Republic of the Philippines
POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
OFFICE of the VICE PRESIDENT for RESEARCH, EXTENSION and DEVELOPMENT
INNOVATION AND TECHNOLOGY SUPPORT OFFICE

Client

*Author/s note
Name Email Address Permanent House Address
Lyca G. Cariaga lyccariaga@gmail.com Brgy. Masiit Calauan Laguna
Eugene Quiroga Q. Quiroga vinniequiroga@gmail.com Los Baños Laguna

4TH Floor South Wing, PUP A. Mabini Campus, Anonas Street, Sta. Mesa, Manila 1016
Trunk Line: 335-1787 or 335-1777 local 234
Website: www.pup.edu.ph | Email: itso@pup.edu.ph

THE COUNTRY’S 1st POLYTECHNICU ISO 9001:2015 CERTIFIED

CERTIFICATE NUMBER: AJA18-0190