FLOOD LEVEL TRACKER

A Capstone Project

Presented to
The Faculty of Information Technology Department
Buenavista Community College
Buenavista Bohol

In Partial Fulfillment
Of the Requirements for the Degree
Bachelor of Science in Information Technology

By:

Francis Jay T. Socajel

Jeannalou O. Vitor
Ramie M. Bequilla
Pedro M. Revilla

June 2023
 FLOOD LEVEL TRACKER

A Capstone Project

Presented to
The Faculty of Information Technology Department
Buenavista Community College
Buenavista Bohol

In Partial Fulfillment
Of the Requirements for the Degree
Bachelor of Science in Information Technology

By:
Francis Jay T. Socajel
Jeannalou O. Vitor
Ramie M. Bequilla
Pedro M. Revilla

June 2023
 ii

APPROVAL SHEET
Thesis of: FRANCIS JAY SOCAJEL, JEANNALOU VITOR, RAMIE
BEQUILLA, PEDRO REVILLA
Title: FLOOD LEVEL TRACKER

Recommending Approval: RESEARCH COMMITTEE

CHONA C. LAMBOJON, Comp.E _________________

Program chair, College of Information Date
Technology Education, Chairperson

JINNYVEBS.ABRENICA __________________
Technical and Documentation Adviser Date

RODULFO A. BOLO, M.E.,J.D Ph.D.,E.M. __________________

VP for Administration, Bcc Date

LOURDES A. BOLO, Ph.D.,E.M. __________________

Dean, Education Department Date

MARIA LOUISA L. NINANG, Ph.D., Ed __________________

Director, Research and Extension Services Office Date

CHERYL ANN M. PACALDO, MAEd-Math __________________

Capstone Adviser Date

KAREMINA L. SOTES, LPT __________________

English Editor Date

JULINA LANZUELA, LPT __________________

Citation Assessor Date

Approved:

ANALIZA L. CHUA, Ph. __________________

College President Date
 iii

CERTIFICATE OF THESIS ACCEPTABILITY

This project, “LGU BUENAVISTA HUMAN RESOURCE INFORMATION

SYSTEM” prepared and submitted by KIRBY O. MASIN, RAYMOND V.
PETALCORIN, UVICEL S. KILESTE, JOHN BENJIE S. OHENDRAS in partial
fulfilment of the requirements for graduation for the degree of Bachelor of
Science in Information Technology (BSIT) is hereby accepted.
Approved by the Panel Members during the Final Defense conducted in
June, 2023 with a grade of __________.

PANEL MEMBERS

ANALIZA L. CHUA, Ph.D., E.M.

College President

MR. RAYMUNDO T. MELECIO

External Panel

MARIA LUISA L. NINANG, Ph.D., Ed. LOURDES A. BOLO, Ph. D., E.M.
Director, Research and Extension Services Office Dean, College of Teacher Education
Technology Education, Chairperson

RODULFO A. BOLO, M.E.,J.D Ph.D.,E.M CHONA C. LAMBOJON,

Comp.E
VP for Administration, BCC Program chair, College of Information
Technology Education, Chairperson

Accepted and approval in partial fulfilment of the requirement for

graduation for the degree of Bachelor of Science in Information Technology.

CHONA C. LAMBOJON, Comp.E

Program chair, College of Information
Technology Education, Chairperson

Recorded:

DAISY GRACE L. MOLINA, RL

 iv

College Librarian
 v

ACKNOWLEDGEMENT

The researcher would like to express their sincere appreciation to the

people who contributed a lot for the success of the Capstone Project.

To Hon. Dave D. Duello for putting his life on the line every day to keep

the community a safe learning environment.

To Dr. Analiza L. Chua for her love, hard work and dedication to our

school, thank for the genuine love and support.

To Dr. Rodulfo A. Bolo for sharing his brilliant ideas in giving suggestions

to make our capstone project success.

To Dr. Lourdres A. Bolo for her great help among the researchers, giving

a good critique about the study.

To Dr. Maria Luisa L. Ninang who contributed a lot of ideas in making

our capstone project and sharing her expertise and dedication to make the study

successful.

To Engr. Chona C. Lambojon, for the help and advice to make us

motivate to continue this study.

To Mr. Raymundo T. Melecio for sharing his deep knowledge and

expertise in making our capstone project productive and effective.

To Mrs. Cheryl Ann Pacaldo, our Capstone Project adviser for her

guidance and support in order to make the study successful.

 vi

To Mrs. Jinnyveb S. Abrenica, our technical and documentation adviser

for her guidance, moral support and encouragement in order to make this study

possible.

To Mrs. Felipa Damgo for hardwork in assistance of managing task

associated with our project.

Finally, we would like to thank God, for answering our prayers, for giving

us strength to plod on despite of the problems we encounter. He is guiding us to

make the study successful. Thank you very much.

The Researchers
 vii

DEDICATION

This documentation is dedicated to all the people who help us to reach the

peak of success and to those who have provide suggestions and motivation to

make our project successful. And also, to our heavenly father who gave us

strength and blessing.

To our beloved and supportive parents and families to our brother and

sisters, lovers, classmates, friends and to our beloved Alma mater, this work is

dedicated, and we highly appreciated your support to us.

Francis Jay

This research is lovingly dedicated to my family who have been constantly

giving me the support and become my inspiration. Without their love and support

this project would not have been possible.

Jeannalou

To my beloved parents thank you for supporting me and also for your

love, care and support. I hope this achievement fulfil the dream envisioned for

me.

Ramie

I dedicate this thesis to my parents. Without their patience,

understanding, support and most of all love, the completion of this work would

not have been possible.

Pedro
 viii

ABSTRACT

FRANCIS JAY SOCAJEL, RAMIE BEQUILLA, PEDRO REVILLA,

JEANNALOU VITOR, Buenavista Community College, Buenavista, Bohol,
April 2023, FLOOD LEVEL TRACKER.

Adviser: JINNYVEB S. ABRENICA

This Capstone Project Flood Level Tracker was conducted to the Inabanga River
to easily monitor the water level throughout the areas near on Inabanga River. As
a matter of fact, the system itself would display the water level as long as the
guidelines on what to do before and during emergency situations in
communication of flooding. This opportunity can help the residents to be free
from accidental damages as it helps residents to guide them what to do before
the incidents happen. Since it is a system, the researcher use CSS, HTML, and
PHP for the development of the websites and uses Arduino, ultrasonic sensor
and nodemcu to make the whole system function well. The system was tested
and showed the current level of the water in Inabanga River.
 ix

TABLE OF CONTENTS

TITLE PAGE...........................................................................................................i

APRROVAL SHEET...................................................................................

….........ii

CERTIFICATE OF THESIS ACEPTABILITY.........................................................iii

ACKNOWLEDGEMENT........................................................................................iv

DEDICATION.........................................................................................................v

ABSTRACT...........................................................................................................vi

TABLE OF CONTENTS....................................................................................…vii

LIST OF FIGURES............................................................................................

….ix

LIST OF

TABLES...................................................................................................xi

CHAPTER I
INTRODUCTION
Project Context………...............................................................................1

Objective of the Study……….

………………………………………………...2

Purpose and Description………................................................................2

Scope and

Limitation……..........................................................................4
 x

CHAPTER II
Review and Related
Literature/System………….......................................5
CHAPTER III
Technical Background………...................................................................11

CHAPTER IV
METHODOLOGY, RESULT AND DISCUSSION
System Frameworks…….……………………………………………..….…14

Use case Diagram…..............................................................................16

Use case

Narrative……..........................................................................17

Activity Diagram……..............................................................................29

Entity Relationship Diagram………..........……........................................45

Development and Testing……...............................................................47

Follow the SDLC

Process………............................................................47

Testing Process…..................................................................................48

Recommendation…..............................................................................55

References …........................................................................................56

Appendices….........................................................................................59

Gantt chart………………………….………………………………………..60
 xi

Relevant Source Code………................................................................62

User Guide...............................…..........................................................77

Curriculum Vitae…….............................................................................75

LIST OF FIGURES

Figure Page

1. System Frameworks of Flood Level Tracker….

…………...........................14

2. Use Case Diagram for Flood River Tracker….…………............................

16

3. Register for Residents………....................

….............................................29

4. Log In as Residents…..……………………..

………………………………....30

5. View Notification for

Residents…………....................................................31

6. Daily Reports for

Residents…………………..............................................32

7. Weekly Reports for Residents…………..

………........................................33
 xii

8. SMS……………………………………………………………………………..34

9. Log-out for Residents………..…………………..........................................35

10. Log In as Admin….....................................................................................36

11. View Notification for Admin……………………….......................................37

12. View List of Residents……..…………………..............…...........................38

13. Monitor the Water

Level…………………………….....................................39

14. Daily Reports for Admin.

……………………………………………...............40

15. Weekly Reports………………………………………...................................41

16. Updates..………………………………………………………………............42

17. Send Notification…….………………………………………………………...43

18. Log-out for Admin…….……………………………………………………..…44

19. Entity Relationship of Flood Level Tracker……………….

………………....45

20. Screenshot of Landing Page………..……………………………………...…

48

21. Screenshot of Registration of Residents……………….

…………………....49

22. Screenshot of Log in for Residents…………….…..……………………..

….49

23. Screenshot of Residents View Dashboard……………...………………..…

50
 xiii

24. Screenshot of Residents Daily Reports…………………….……………..…

50

25. Screenshot of Residents Weekly Reports………………….

………………..51

26. Screenshot for Admin Log in………………………………….

……………....51

27. Screenshot of Admin View Dashboard……………………….………….

…..52

28. Screenshot of Admin View Notification…………….…………..

…………....52

29. Screenshot for View List of Residents…………….

………………………....53

30. Picture of Arduino Hardware…………..…………..…………..…………..

….53

31. Error Message……………………………………………………………….…54

 xiv

LIST OF TABLES

Table Page

1. Use case Narrative for

Register……………...............................................15

2. Use Case Narrative for Log

in……….........................................................16

3. Use case Narrative for View

Notification……………………………….........16

4. Use Case Narrative for Residents Daily Reports………………..…...

……..17

5. Use Case Narrative for Residents Weekly Reports………………..…..

…...17

6. Use Case Narrative for Residents SMS…………..…………………………

18

7. Use Case Narrative for Residents Log out……………..…….

……………..18

8. Use Case Narrative for Admin Log in………….……………..

……………....19
 xv

9. Use Case Narrative for Admin View Notification………………..

…………..20

10. Use Case Narrative for View List of Residents……………………..…..

…..21

11. Use Case Narrative for Monitor of the Water Level…………………......

….22

12. Use Case Narrative for Admin Daily Reports…………….

………………....23

13. Use Case Narrative for Admin Weekly Reports……………..……..…..…..23

14. Use Case Narrative for Updates………………………..…………………....24

15. Use Case Narrative for Send Notification……………..………….

………….25

16. Use Case Narrative for Admin Log-out………….………………..……..….26