Final Documents

A Proposed School Log Management System for Employees of
Montessori Educational Learning Center of Ubay
(MELCU)
A thesis presented to the of
Tapon, Ubay, Bohol
In Partial Fulfillment
of the Requires for the Degree
BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY
(BSIT)
By:
Ibale, Aurelio Jr. R.
Esperanza, Joseph U.
Merin, Mae Apple D.
Palaca, Caren V.
Malinao, Nicasio M.
2022
ii
APPROVAL SHEET
The thesis entitled School Log Management System for Employee of
Montessori Educational Learning Center of Ubay, prepared and submitted by
Aurelio R. Ibale Jr., Joseph U. Esperanza, Caren V. Palaca, Mea Apple Merin
and Nicasio M. Malinao Jr. in partial fulfillment of the requirements for the degree
of Bachelor of Science in Information Technology (BSIT) has been examined and
is recommended for acceptance and approval for Oral Examination.
THESIS COMMITTEE
JANNETH BUFE LIGAN,LPT

Adviser
ALMIRA G. LIM,MSCRIM CHRISTOPER S. BAMBA,PHD

Member Member
NORMA JUMAWID APAO,PHD,DIT,LPT

Chairman
PANEL EXAMINERS
Approved by the Committee on Oral Examinition with a grade of PASSED
JANNETH BUFE LIGAN,LPT

Adviser
ALMIRA G. LIM,MSCRIM CHRISTOPER S. BAMBA,PHD

Member Member
NORMA JUMAWID APAO,PHD,DIT,LPT

Chairman
Accepted and approved in partial fulfillment of the requirements for the degree of
bachelor of Science in Information Technology
LEONARDA D. LOAYON,edD ENGR.MARY PRECY T. SY,MAT-CS,(CAR)

Vice President for Academic Program Head, Computer Studies Department
School Log Management System

iii
ABSTRACT
A School Log Management System for Employee of Montessori
Educational Learning Center of Ubay, is an advance attendance system using a
Biometric fingerprint scanner. The system that will be developed to maintain the
details of all daily time records of employees working in Montessori Educational
Learning Center of Ubay. It would maintain the information about the personal
daily time records and payroll of employees, so that the non-teaching staff of the
Montessori Educational Learning Center of Ubay can easily know the daily time
records of all employees. It would be simple to understand and can be used by
anyone who is not even familiar with Biometric System. It would be user friendly
and just ask the user to follow step by step operations by giving user’s manual. It
would be fast and can perform many operations of daily records of employee,
including the payroll, under time, over time and also the health benefits deduction
of all employees. This system package would be developed using the powerful
coding PHP application sublime at the frontend with a XAMPP Control Panel
database at backend. For further enhancement or development of the system,
the user’s feedback will be considered. The School Log Management System
would make it easy for the administrator to keep track of all records of the
employees. This proposed system would bring about an easy way of maintaining
the daily time records of employees. The goal of this project is to design and
develop a School Log Management System to fill existing gaps in the electronic
management of employees.

iv
ACKNOWLEDGEMENT
We would like to express our sincere gratitude to our excellent teacher
and adviser, Mrs. Roseline Lorecan for giving us her good ideas so that we can
further improve the work of our system project for our thesis, and of course
because of the motivation that she gave us. So that we have more courage to
improve and cope we all the trials and problems that we may able to experience
in doing our system research project. She taught us what we should do to
achieve the desire outcome of our research study for our system. A wonderful
and rare opportunity with a great privilege and honor to work and study under her
guidance.
To Engr. Euludosa Rose T. Monticod and Mrs. Janneth B. Ligan, LPT was
our two advisers in terms of making a system and always correcting and teaching
us how to make a well-organized system.
To Mr. Godard V. Salaum MA-Eng., our English critic, for giving his time
patiently and meticulously reading and correcting our drafts.
To our beloved Dean Engr. Mary Precy T, Sy, MAT-CS, (CAR) for her
undying support since our first day in school as BSIT student. Thanks for the
kindness, love and understanding to all of us.
To Bohol Northern Star College thank you for giving as the opportunity to
learn and finish our study in your school.
The Researchers

v
DEDICATION
This study is wholeheartedly dedicated to our beloved parents, who have
been our source of inspiration and gave us strength when we thought of giving
up, who continually provide their moral, spiritual, emotional, and financial
support.
To our mentor, friends, and classmates for the help and support through
this process and journey whose steadfast encouragement made possible both
the conceptualization and completion of this project.
And lastly, we dedicated this book to the Almighty God, thank you for the
guidance, strength, power of mind, protection and skills and for giving us a
healthy life. All of these, we offer to you.
The Researchers

vi
TABLE OF CONTENT
APPROVAL SHEET.............................................................................................. ii
ABSTRACT...........................................................................................................iii
ACKNOWLEDGEMENT....................................................................................... iv
DEDICATION........................................................................................................ v
TABLE OF CONTENTS........................................................................................vi
LIST OF FIGURES............................................................................................... ix
LIST OF TABLES................................................................................................. xi
CHAPTER 1: THE PROBLEM AND IT’S SCOPE
Introduction
Theoretical Background
Legal Basis
Related Literature
Related Studies
THE PROBLEM
Statement of the Problem
SCOPE AND LIMITATION OF THE STUDY
OBJECTIVE OF THE STUDY
SIGNIFICANCE OF THE STUDY
RESEARCH METHODOLOGY
Research Design
Research Respondents
Research Flow
Research Environment
Research Instrument
Research Procedure
DEFINITION OF TERMS

vii
CHAPTER 2: PRESENTATION, ANALYSIS AND INTERPRETATION OF DATA
Profile of Respondents........................................................................................30
Data Processing..................................................................................................33
Data Updating..................................................................................................... 35
Data Inquiry.........................................................................................................36
Data Security.......................................................................................................37
Data Generating..................................................................................................40
Good Features.................................................................................................... 41
CHAPTER 3: TECHNICAL ASPECT AND DESIGN OF THE SYSTEM
ENVIRONMENTAL MODEL................................................................................44
NOTES OF THE CONTEXT DIAGRAM..............................................................45
EVENTS LIST..................................................................................................... 46
EVENT DIAGRAM...............................................................................................48
BEHAVIORAL DIAGRAM....................................................................................54
LEVELLED DATA FLOW DIAGRAM...................................................................55
DATA DICTIONARY............................................................................................59
PROCESS SPECIFICATION..............................................................................64
IMPLEMENTATION MODEL...............................................................................75
SYSTEM ANALYSIS AND DESIGN....................................................................76
DATABASE DESIGN.......................................................................................... 76
RELATIONAL DATABASE..................................................................................79
OVERALL PROGRAM DESIGN..........................................................................80
DETAILED PROGRAM DESIGN.........................................................................82
HARDWARE AND SOFTWARE REQUIREMENTS............................................90
TOTAL ANNUAL SAVINGS................................................................................93
COST RECOVERY SCHEME.............................................................................94
PAYBACK PERIOD.............................................................................................95

viii
CHAPTER 4: SUMMARY, FINDINGS, CONCLUSIONS, AND

RECOMMENDATION
SUMMARY..........................................................................................................96
FINDINGS........................................................................................................... 97
CONCLUSION.................................................................................................... 98
RECOMMENDATION..........................................................................................99
REFERENCES..................................................................................................100
APPENDICES................................................................................................... 102
APPENDIX A..................................................................................................103
APPENDIX B..................................................................................................104
APPENDIX C................................................................................................. 105
APPENDIX D................................................................................................. 109
CURRICULUM VITAE.......................................................................................113

ix
LIST OF FIGURES
Figure 1. Research Flow.....................................................................................23

Figure 2. Location Map........................................................................................24
Figure 3. Context Diagram..................................................................................44
Figure 4. Admin can add department..................................................................48
Figure 5 . Admin can update department.............................................................48
Figure 6. Admin can delete department..............................................................48
Figure 7. Admin can view department.................................................................48
Figure 8. Admin can add direct user....................................................................49
Figure 9. Admin can update direct user...............................................................49
Figure 10. Admin can delete direct user..............................................................49
Figure 11. Admin can view direct user................................................................49
Figure 12. Admin can view employee information...............................................50
Figure 13. Admin can add employee...................................................................50
Figure 14. Admin can update employee..............................................................50
Figure 15. Admin can delete employee...............................................................50
Figure 16. Admin can view employee logs..........................................................51
Figure 17. Admin can view employee payroll......................................................51
Figure 18. Admin can print employee payroll......................................................51
Figure 19. Admin can export employee payroll to excel......................................51
Figure 20. Staff can add department...................................................................52
Figure 21. Staff can update department..............................................................52
Figure 22. Staff can view department..................................................................52
Figure 23. Staff can view employee information..................................................52
Figure 24. Staff can add employee......................................................................52
Figure 25. Staff can update employee.................................................................52
Figure 26. Staff can view employee logs.............................................................53
Figure 27. Staff can view employee payroll.........................................................53
Figure 28. Staff can print employee payroll.........................................................53
Figure 29. Staff can export employee payroll to excel.........................................53

x
Figure 30. Top Level Data Flow Diagram............................................................54

Figure 31. Process Recording.............................................................................55
Figure 32. Process Viewing.................................................................................56
Figure 33. Process Updating...............................................................................57
Figure 34. Process Deleting................................................................................58
Figure 35. Process Generate..............................................................................58
Figure 36. Automated Top Level Data Flow Diagram.........................................75
Figure 37. Relational Database...........................................................................79
Figure 38. Overall Program Design.....................................................................81
Figure 39. Login Admin / Staff Window...............................................................82
Figure 40.Dashboard Window.............................................................................83
Figure 41. Employees Window............................................................................84
Figure 42. Employees Log Window.....................................................................85
Figure 43. Manage Employee Window................................................................86
Figure 44. Manage Payroll Window.....................................................................87
Figure 45. Manage Department Window.............................................................88
Figure 46. Manage Direct User Window..............................................................89

xi
LIST OF TABLES
Table 1. Number of Respondents........................................................................22

Table 2. Distribution of overall respondents based on job description................29
Table 3. Profile of Respondents..........................................................................30
Table 4. Data Processing....................................................................................31
Table 5. Data Recording..................................................................................... 33
Table 6. Data Updating....................................................................................... 35
Table 7. Data Inquiry...........................................................................................36
Table 8. Data Security.........................................................................................37
Table 9. Data Generating....................................................................................40
Table 10. Good Featutes.....................................................................................41

CHAPTER 1
THE PROBLEM AND ITS SCOPE
Introduction
In the present age, it is quite common for the school to maximize the use
of computer technology. In the educational setting, different monitoring systems
were introduced tomonitor the process of getting the attendance of faculty and
staff, including their signing in and off. One of the major concerns of all
organizations, specifically in educational institutions, is the process of monitoring
their employees arrival and departure efficiently during their working days. To
resolve the issue, institutions started to rely on devices with sensors to improve
their monitoring capabilities. Such device, using a biometrics system. With the
convenience offered by a proper monitoring tool, the demand for them is high. A
simple monitoring system that can observe devices, infrastructures, applications,
services, and even business processes. Biometric technology that involves
identifying and verifying people by analyzing the human fingerprint characteristics
has been widely employed in various aspects of life for different purposes, most
significantly regarding this study, is the employees attendance. This system aims
to develop an accurate and extremely efficient automated attendance system
using the fingerprint verification technique.

2
Montessori Educational Learning Center of Ubay (MELCU) is one of the
well-known exclusive schools in Barangay Tapon, Ubay, Bohol, was founded on
September 15, 2008 . This school is one of the well-known exclusive private
schools because this is the distinguishing school that holds Primary, Junior high
school and Senior High teaching level.
School Log Management System for Employee has become an important
need for each school to work. No doubt. It holds numerous crucial functions to
confirm that school management runs smoothly. School management systems
help the institution trace who’s employee is entering the school on time, and the
time they are out.
A School Log Management System for Employee is important for the
overall functioning of any educational establishment. They increase productivity
and efficiency. Many schools are finding it useful to use School Log Management
System to organize the day-to-day functions of their educational institutes. As the
researcher of this research problem, our main objective is to help Montessori
Educational Learning Center of Ubay (MELCU) design and develop an advance
school log management system for employee’s using biometric technologies,
compared to there old bundy clock and DTR use as attendance records. School
log management system for employee’s system using biometric technologies can
manage the attendance and knows who is going to enter or exit to ensure safety
for every employee and generally.

3
Theoretical Background
With increasing identity fraud and emphasis on security, there is a growing
and urgent need to efficiently identify humans both locally and remotely on a
routine basis. We require biometric security. From the point of view of security,
biometric measures to prevent interference by unauthorized persons constitute a
particularly important means of protecting critical infrastructures. A global
breakthrough by biometrics in identity verification technology seems to be
imminent in the form of its use in identity documents and corresponding
biometrically-based controls at frontiers.
According to IBG (International Biometric group) report the estimated
value of biometrics market in 2007 is $3,000,000,000 which represents a huge
number. The market share of three core technologies that is fingerprint
recognition is >75% of total biometric services market, it shows that major
development occurred in these biometric measures. Number of people caught
since 2003 at UAE borders using biomitric recognition are >50,000. So above
numbers present that biometrics shows a better solution than we aspect not in
context of as a security measure but also in economic and social acceptance
point of view. Represent the total biometric industry revenues (copyright © 2006-
2007 International Biometric Group). So above numbers present that biometrics
shows a better solution than we aspect not in context of as a security measure
but also in economic and social acceptance point of view.

4
Legal Basis
This study was anchored in Section II Data Privacy Act of 2012 and It is
the policy of the State to protect the fundamental human right of privacy, of
communication while ensuring free flow of information to promote innovation and
growth. The State recognizes the vital role of information and communications
technology in nation-building and its inherent obligation to ensure that personal
information in information and communications systems in the government and in
the private sector are secured and protected.Whenever used in this Act, the
following terms shall have the respective meanings hereafter set forth:
Commission shall refer to the National Privacy Commission created by
virtue of this Act. Consent of the data subject refers to any freely given, specific,
informed indication of will, whereby the data subject agrees to the collection and
processing of personal information about and/or relating to him or her. Consent
shall be evidenced by written, electronic or recorded means. It may also be given
on behalf of the data subject by an agent specifically authorized by the data
subject to do so.
Data subject refers to an individual whose personal information is
processed. Direct marketing refers to communication by whatever means of any
advertising or marketing material which is directed to particular individuals.Filing
system refers to any act of information relating to natural or juridical persons to
the extent that, although the information is not processed by equipment operating
automatically in response to instructions given for that purpose, the set is

5
structured, either by reference to individuals or by reference to criteria relating to
individuals, in such a way that specific information relating to a particular person
is readily accessible.
Personal information refers to any information whether recorded in a
material form or not, from which the identity of an individual is apparent or can be
reasonably and directly ascertained by the entity holding the information, or when
put together with other information would directly and certainly identify an
individual. Personal information controller refers to a person or organization who
controls the collection, holding, processing or use of personal information,
including a person or organization who instructs another person or organization
to collect, hold, process, use, transfer or disclose personal information on his or
her behalf.

6
REVIEW OF RELATED LITERATURE AND STUDIES
Related Literature
Local Literature
“Makati fully implements biometric time keeping system”, 2014. MANILA,
Philippines - The Makati City government has fully implemented the use of the
Automated Biometrics Time keeping System in monitoring the daily attendance
of employees working in its offices at the City Hall complex in Barangay
Poblacion. Makati Mayor Jejomar Erwin Binay said “the move was in keeping
with the commitment of the city government to harnessing technology to promote
transparency and efficiency in its operations and services”.
In accordance with the city personnel officer,Vissia Marie Aldon, said
“using the system eliminated the possibility of employees making ‘proxy’ time-in
or time-out for other employees”.
As reported by The head of the Human Resource Development Office
(HRDO) also said 10 standalone fingerprint time recorders initially procured were
used for over 3,000 city personnel working in offices within the City Hall complex
during the dry run. Employees were required to sign in and out on a timesheet to
serve as back-up in case the system malfunctioned. And since the test run went
without a hitch, the HRDO has now fully implemented the biometrics attendance
system, Aldon said. She also said that the city government will be purchasing

7
additional fingerprint time recorders so that all 34 offices and departments of the
city government, including the University of Makati, Hospital ng Makati and other
agencies outside City Hall, would be served.
“Philippines uses biometrics for welfare payments”, 2013. The Philippines’
Department of Social Welfare and Development (DSWD)has announced that a
biometric payment system is being used to ensure cash grants are correctly
distributed to beneficiaries in its PantawidPamilya program. The biometric system
is now being used in the province of Maguindanao. As of January 9, 2013, the
national program had 3,843,502 household beneficiaries and operates in 1,605
cities and municipalities in 79 provinces in all 17 regions nationwide. The
biometric system uses fingerprint recognition to counter the reports of fraud and
misrepresentation.
Based on the report of Secretary of Social Welfare and Development,
Corazon Juliano-Soliman, “the system addresses numerous complaints that
there are false grant claimants, tampered IDs and people holding other
beneficiaries’ ATM cards”. With the new system, the identification and giving of
grants to the beneficiaries will be more efficient, the government said. The
system immediately displays the photo of the beneficiary and the amount of cash
grant to be received after the biometric identification.
“Philippines National Police (PNP) deploy NEC finger identification System”,
2015. NEC Corporation announced that NEC Philippines has deployed a new
Automated Fingerprint Identification System (AFIS) for the Philippine National

8
Police (PNP) in Manila in an effort to maintain a database of fingerprint records
used for criminal identification purposes. The new AFIS will enable law
enforcement to compare sets of fingerprints recovered from crime scenes and
match them against a database of known and unknown fingerprints. The system
provides three times faster search capabilities to identify crime suspects when
compared to the previous system, along with five times more storage capacity for
storing fingerprint records. Additionally, the new system will be able to connect
with other compatible AFIS locally or abroad, with export and import capabilities.
On the reported of Agnes A. Gervacio, president of NEC Philippines
“through our research and development efforts, NEC continually pushes the
boundaries of innovation to enhance our biometric technology to benefit our
customers, we are glad to work with the Philippine National Police to implement
our “solutions for society” offerings and contribute towards law enforcement
efforts in the Philippines. NEC’s vision is to contribute towards a society where
safe and secure services are provided to people efficiently and equally, and we
look forward to continuing our partnership with the PNP in their technology
advancement.”
Foreign Literature
Carval HR Unity Software (2017). Carval Computing has
announced that Cottage Delight, provider of speciality foods to independent food

9
retailers, has selected Carval’s HR Unity Payroll solution, Uniwage and Time and
Attendance software,Unitend, to manage working hours and Payroll for over 200
staff. Cottage Delight provides over 700 specialty foods, either made by the
company or sourced from artisan producers across the UK and Europe, to
garden centers, farm shops, delicatessens, traditional grocers, selected
department stores, as well as fine food festivals and markets. Since
implementing Carval’s solution, Cottage Delight has seen significant time savings
in Payroll, with the time taken to administer the weekly and monthly payroll
reduced from five days to just 10 hours a month.
As reported by to Gary Bowcock, IT Manager at Cottage Delight
said;“Ourprevious system was installed over ten years ago, was completely
outdated and didn’t meet our needs today. We needed something completely
different. Carvel’s HR softwaredoes everything that we wanted. The look and feel
is modern and it’s easy and intuitive to operate. Carvel just came up on top.”
As stated in John Ovington, Sales and Support Director at Carval said;
“Companies like Cottage Delight that excel in their business field and expand
rapidly often find that their existing HR IT systems can no longer support their
operations effectively. Our integrated HR solutions provide the tools that
managers and HR require to manage and administer complex working hours
andPayroll transparently and accurately. Customer feedback is that having
greater flexibility in recording attendance and visibility for managers is also more
motivating for staff.”

10
Related Studies
Local Study
Michael Indico (2016), conducted a study entitled “Development of
Employee Attendance and Payroll System using Finger Biometrics.” The study
focuses on the design and development of the system for recording the
employee’s attendance and processing of payroll using the fingerprint scanner
for teaching and non-teaching staff in a tertiary institution. The system provides
an alternative solution of many companies or institutions for generating the DTR
and payroll of their employees. Also, the system uses the network to make the
features (recording of the attendance, printing the pay slip, generating of payroll)
installed or used by the other departments in the institution.
Jhadiebellere (March 2014), conducted a study entitled “Time and
Attendance System”, the study was focused on how to record the time of
employee in a more accurate and easiest way. The system will be using a
barcode reader for fast accessing of the database of the crew. The study was
developing a stand-alone system that cannot be accessed online and was made
only for the employee’s time keeping and a payroll system for the accounting of
the Premium Bee Food Corporation.

11
Foreign Study
Rao S and Satoa KJ with the same study, uses the biometric technology
to automate the process of taking the attendance of employees in the
organizations. The study aims to develop an accurate, fast and efficient
attendance system using the fingerprint verification technique. The fingerprint
verification is done by using extraction of minutiae techniques.
A study developed by Adeoye, addresses the problems of various schools
and institutions using the biometric technology. The study uses for the students
in class absenteeism and debtor during examinations. The system is
programmed to record the class attendance, and screening of tuition fee
payment before and after examination of the students. In addition, it can also be
used to verify whether such students are in debit to the institution or whether the
students have paid the required percentage of the tuition before being allowed to
take the examination. Also, the system eliminates impersonation during
examinations, stress of manual class attendance taking and record keeping.
Another study conducted by Adewole, uses the biometric technology for
solving the problem of manual attendance. The system employs to calculate
attendance of staff in an organization and do the further calculations of monthly
attendance summary in order to reduce human errors during calculations. The
proposed system employs in curbing the problems of lateness, buddy punching
and truancy in any institutions or organizations.

12
Further study conducted by Ami-Narh, investigates the impact of the
adoption and usage of biometric time and attendance management systems
among the Ghanaian business community in the Greater Accra Metropolis. The
result of the study indicates that biometric timekeeping technologies are more
secured than traditional timekeeping methods. Moreover, the use of biometric
timekeeping technologies has better effect on organization labor cost as
compared with the traditional methods.

13
THE PROBLEM
Statement of the Problem
This study aims to design and develop a School Log Management System
for Emplyee’s of Montessori Educational Learning Center of Ubay.
To fully understand this system, the following must be addressed:
1. Safety and secure in handling personnel records and inaccessibility of
information when needed.
2. Prevent proxy in terms of using daily time record.
3. Manual process of liquidation of monetary amount of using bundy clock
and DTR system.
4. Takes time to generate report by using bundy clock and DTR system.
5. Need toimproved the current attendance process using old bundy clock
and DTR of the Montessori Educational Learning Center of Ubay, Inc.

14
SCOPE AND LIMITATION OF THE STUDY
Scope
The main goal of this study is to help the administrator of Montessori
Educational Learning Center of Ubay, by using the system eliminated the
possibility of employees making ‘proxy’ time-in or time-out for other
employees.The biometric system uses fingerprint recognition to counter the
reports of fraud and misrepresentation.
Below are the areas covered in this study along with their respective
definition and functions:
Scope of the Study:
 Encrypted password protection will be used to secure the information
of all the employees.
 It will lessen the time of finding the attendance of employees.
 Employee will have a computerized biometric attendance system that
will automatically save to the database of our system.
 Date and time of attendance are included.
 School logs management system regarding the employees attendance
will have on time equality to their worked hours.

15
 School logs management system record the attendance of total time
for a day and automatically compute the total salary of the employee.
Dashboard
This module showed the number of employee’s entering the campus and
employee’s leaving the school campus..
Employees
This module will showed all the information of the employees.
Employees Logs
This module showed the logs (in and out) of employee’s and can export
their logs to Microsoft excel.
Manage Employee
This module will be responsible for adding, updating, deleting and viewing
the employees information.
Manage Payroll
This module showed the payroll of the employees, print payroll and can
export their payroll to Microsoft excel.
Manage Department

16
the department information.
Manage Direct User
the direct users information.
Limitations of the Study
 This system is only exclusive at Montessori Educational Learning Center
of Ubay.
 The biometric scanner can only accept 1 – 127 unique fingerprints, 1
finger, 1 employee.

17
OBJECTIVE OF THE STUDY
This study aims to develop a School Log Management System for
Employee’s of Montessori Educational Learning Center of Ubay, that will help the
establishment to monitor employee’s in and out of the school and ensure the
safety monitoring of everyone.
SIGNIFICANCE OF THE STUDY
The study aims to develop a system that can help the faculty and
employee’s of Montessori Educational Learning Center of Ubay, to monitor
employees attendance.
The following will be benefited from the result of the study:
If this system will be implemented this will be the first School Log
Management System for Emplyee’s of Montessori Educational Learning Center
of Ubay.
Administrator

18
Administrators also benefited from this study because they can easily
track the login and out of the employees and print out the logs or records.
Teaching staff
They can easily find out the flow of the advance biometric system,in
monitoring there attendance, Time-in and Time-out easily and hassle-free.
Non-Teaching staff
They can easily manage the attendance records of the employyees,
andthe payable salary from the staff will lessen.
Researchers
The researchers are aiming to help Montessori Educational Learning
Center of Ubay, in monitoring the attendance,Time-in and Time-out of employees
easily and hassle-free.
Future Researchers
This study may help future researchers to use this as a guide to their
study or enhance this system for the school. The researchers also recommend
that future researchers configure all of the features that a School Log

19
of Ubay, has.
RESEARCH METHODOLOGY
In this chapter, the proponent introduces the research strategy and
techniques in the research.
Research Design
The research design used for the study was aDescriptive method
approach by designing a questionnaire because the data collection
instrumentsupports fingerprint matching biometric technologies. The design is
pondered descriptive because it allows the researcher to generate data through
standard collection procedures based on highly structured research instruments
and precise study concepts and related satiable.
Research Respondents
The main respondents of this study are the school administrators, non-
teaching staff, and the teaching staff of Montessori Educational Learning Center
of Ubay Bohol. Twenty one (20) respondents are needed in this study and were
surveyed. Eighteen (18) of the respondents are the teaching staff and Two (2) of

20
the respondents are school maintenance and office staff.Moreover, the study will
only take place at Montessori Educational Learning Center of Ubay.
Table 1
Number of respondents
Respondents No. of Respondents

Teaching Staff 18
Non-Teaching staff 2
Total 20
Table I shows the profile of the respondents. The respondents are the
school Teaching staff, and the school Non-Teaching staff which has only
Eighteen Teaching (18) staff, and Two (2) Non-Teaching staff a total of Twenty
(20) respondents.
Research Flow
The research flow in figure 1 illustrates how the researchers conducted
their study. It is composed of three parts namely: INPUT, PROCESS, and
OUTPUT.
INPUT encloses the statement of the problem in which the research was
purposely conducted.

21
PROCESS refers to the method of collecting data being used, which was
a direct interview and questionnaire method where data is copied, tabulated,
presented, analyzed, and interpreted.
OUTPUT indicates the recommendation based on the findings gathered
for implementation. As a result, the researchers seek ways to improve the
proposed project’s advancement and accessibility.
INPUT
 Employees information
 Employees attendance
 Data management system
PROCESS
 Descriptive method of research using questionnaires with

interviews.
 Data gathering, analyzing, processing and interpreting the
system.
 Designing and developing the proposed School log
OUTPUT
School Log Management System for Employee’s

22
Figure 1. Research flow
Research Environment
The Montessori Educational Learning Center of Ubay, was the locale of
the study. This is located in Barangay Tapon, Ubay, Bohol. The Figure below
illustrates the location of MELCU.
Figure 2. Location Map
The Montessori Educational Learning Center of Ubay, is a private non-
sectarian co-educational institution of higher learning in Ubay,
Bohol,Philippines.The institution is located in barangay Tapon along the high

23
way. It was established as the Montessori Educational Learning Center of Ubay
on September 15, 2008. It is the opening of the preschool course with temporary
permit. Thus, it was recognized by the government started on 2010.Montessori
Educational Learning Center of Ubay, “MELCU” continuity of the legacy would
mean a challenges, the Montessori Educational Learning Center of
Ubayenriched its curricular offerings.
Research Instrument
The self-made questionnaire was used to gather the desired information
from the school non-teaching staff, and the teaching staff. The researcher also
interviewed the teachers, and employee’s in Montessori Educational Learning
Center of Ubay, to gather supplemental information on items undecipherable in
the questionnaire.
Research Procedure
The researcher submitted the project proposal to the school head of
Montessori Educational Learning Center of Ubay for approval. After the approval
was granted, the researcher interviewed the MELCU teaching staff, and non-
teaching staff for additional information. Then the researchers personally
distributed the questionnaire to the 20 respondents and give them enough time to
answer the said questionnaire efficiently. Afterward, the researchers collected the
answered questionnaire from the respondents and recorded their responses with
sensitivity, unbiased, and treated with strict confidentiality.

24
Statistical Treatment & Data
For the purpose of analysis and interpretation, the responses to the terms
on the questionnaires were tailed and recorded accordingly and the following
assessment tools will be used:
Frequency and Percentage. This is used to determine the proportions of
employee’s who answered in a certain way.
The formula will be:
f
P= x 100
n
Where:
P = percentage
f = frequently resources
n = number of respondents
100 = percent (%)

25
DEFINITION OF TERMS
This system is a computerized technique that is using biometric system and
finger print scanner of the individuals employees, to secured the daily time
records and information of the Employees.
Employee
The Dialy time records of employees is properly secured on the database
of the system, sorts, and stores log data and employees information logs from a
variety of sources in one centralized location, both Teaching and Non-Teaching
staff.
Database
An integrated collection of data which provides amore efficient way of storage
and retrieval of data and is capable of processing large portions of data
immediately.
System

26
The sets of related components that produces specific results.
Generating reports
Data in the form of tables from database files to be merged with a document to
provide a complete report, based on the daily time records.
Good Feature
This is the process of what are the good features that the researchers
proposed School log management system for employees of Montessori
Educational Learning Center of Ubay.

27
CHAPTER 2
PRESENTATION, ANALYSIS AND INTERPRETATION OF DATA
This chapter presents the data gathered using the questionnaires
distributed to the respondents that contain their profile that includes information
of the Teaching staff and non-Teaching staff.
This chapter provided the gathered data and the researcher’s analysis and
interpretation of the results of the distributed surveys. The data were presented in
a clear and concise form, most which used tables.
Table 2
Distribution of overall respondents based on job description
EMPLOYEES FREQUENCY PERCENTAGE
Teaching Staff 18 80%
Non-Teaching Staff 2 20%
TOTAL 20 100%

28
The table 2 shows that 80% of our respondents are Teaching and 20% of
them are Non-Teaching staff, we have a total of Twenty respondents and the
table shows that the majority of them are the Teaching staff with eighteen
respondents and the remaining two are the Non-Teaching staff.
Profile of Respondents
Table 3
Profile of Respondents
N=20
ITEM FREQUENCY PERCENTAGE
Age:
25 years old below 0 0
26 - 30years’ old 2 20%
31 years old above 18 80%
Gender:
Male 1 10%
Female 19 90%
Civil Status:
Single 10 50%
Married 10 50%
Widow 0 0
Position:
Teaching Staff 18 80%
Employment Status:
Regular 0 0
Contractual 20 100%
Job Order 0 0
Table 3 shows the responses of the respondents on their profile; for the
position, 80% of the respondents are Teaching staff and 20% of the respondents

29
are Non-Teaching staff. For their gender,10% of them are male and 90% are
female. For their age, 0% of the respondents are 25 years old below and 20%
are 25-30 years old and their employment status are 100% of the respondent are
contractual. Lastly 50% of the respondents are single, 50% of the respondent are
married.
Table 4
Data Processing
N=20
1. Have you ever used school log

management system before?
Yes 20 100%
No 0 0
2. What school log management

system is currently used in the
school?
Manually (using record book) 0 0
Computerized (Using MS Word or MS 0 0
Excel
Biometric or Fingerprint scanner 0 0
Bundy Clock and DTR 20 100%
3. How important is school log

management system?
Very important 20 100%
Slightly important 0 0
Important 0 0
Not important 0 0
4. Do you expect that the proposed

School Log Management System will
make the school log faster?
Yes 19 90%
No 0 0
Maybe 1 10%

30
Table 4 shows the responses of the respondents on data processing;
100% of the respondents have used school log management system.100% of the
respondents used Bundy Clock and DTR. 100% of the respondents have
answered school log management system is very important. 90% of the
respondents expect that the proposed school log management system will make
the school log faster and 10% of them is maybe.

31
Table 5
Data Recording
N=20

32
1. Who is responsible for data

recording of the employees who
are entering and leaving the
school campus?
Teaching Staff 0 0
2. What are the data that needed to

be recorded?
Employees Information 0 0
Daily time records of employees 20 100%
Leave and absents of employees 0 0
3. How do you record the

information of the employees
entering and leaving the school
premises?
0 0
Manually (Using record book) 0 0
Computerized (using MS Word or
MS Excel 20 100%
Bundy clock and DTR system 0 0
Biometric Finger print scanner
4. Did the current way of

attendance login system in to the
school hassle free?
18 80%
Yes 2 20%
No 0 0
Maybe
5. Did the current system time-
consuming during logging in? 20 100%
Yes 0 0
No 0 0
Maybe
Table 5 shows the responses of the respondents on data recording; 100%
of the respondents said that the school non-Teaching staff is responsible for data
recording of the employees who are entering and leaving the school campus.

33
100% of the respondents said that the data that needed to be recorded is the
time and date during entering and leaving of the school campus. 100% of the
respondents have record the information of the non-Teaching staff and Teaching
staff entering and leaving the school premises by manually (Bundy clock and
DTR). 80% of the respondent’s do not feel hassle in the current way of logging in
to the school while 20% of the respondents feel hassle in the current way of
logging in to the school. 20% of the respondents said that the current school log
is time-consuming.
Table 6
Data Updating
N=20

34
1. Does the current school log can

easily update the information of
the employees?
Yes 0 0
No 20 100%
Maybe 0 0
2. Who is responsible for updating

the information of the employees
of MELCU?
Teaching Staff 0 0
Non- Teaching Staff 20 100%
Table 6 shows the responses of the respondents on data updating; 100%
of the respondents said that the current school log can’t easily update the
information of the employees. 100% of them said that the Non-Teaching staff is
responsible for updating the information of employees of MELCU.
Table 7
Data Inquiry
N=20

35
1. Does the current school log can

easily trace the logs of the
employees leaving the school
campus?
Yes 18 80%
No 0 0
Maybe 2 20%
Table 7 shows the responses of the respondents on data inquiry; 80% of
the respondents said that the current school log can easily trace the logs of the
employees leaving the school campus while 20% of the respondents said maybe.
Table 8
Data Security
N=20

36
1. Is data security important for

keeping and securing logs?
Yes 20 100%
No 0 0
Maybe 0 0
2. Is data security important for

keeping and securing the
information of everyone?
Yes 20 100%
No 0 0
Maybe 0 0
3. Is there any possibility of losing

the logs of the employees in the
current system?
Yes 18 80%
No 1 10%
Maybe 1 10%
4. Are you satisfied with the current

school logs?
Yes 16 60%
No 0 0
Maybe 4 40%
5. How secure is the current school

log used in MELCU?
Very secure 10 50%

Secure 10 50%
Not sure 0 0
Not secure 0 0
6. How effective is the current way

of logging in used in the school?
Very effective 10 50%
Moderately effective 0 0
Slightly effective 10 50%
Not at all effective 0 0

37
7. Do you feel secure in filling up

your information on the log
book? 12 60%
Yes 0 0
No 8 40%
Maybe
8. How satisfied are you with the

current school log? 10 50%
Very satisfied 5 25%
Satisfied 5 25%
Slightly satisfied 0 0
Not satisfied
9. How will you secure the data of

everyone entering and leaving
the campus? 17 70%
By saving in the computer with a
password 0 0
By saving in the cabinet with a
padlock 3 30%
By having a backup file
Table 8 shows the responses of the respondents on data security; 100%
of the respondents said that data security important for keeping and securing
logs.100% of the respondents said that data security important for keeping and
securing the information of everyone. 80% of the respondents said that there is a
possibility of losing the logs of the employees in the current system while 10%
said no and 10% said maybe. 60% of the respondents satisfied with the current
school logs while 40% of them said maybe. 50% of the respondents said that the
school, non-teaching staff, and the teaching staff of Montessori Educational
Learning Center of Ubay Bohol, is very secure and 50% of the respondents only
said secure. 50% of the respondents said that the current way of logging in used

38
in the school is very effective while 50% of them said it is slightly effective. 60%
of the respondents feel secure in filling up your information on the log book and
40% of them are maybe. 50% of the respondents are very satisfied in the current
school log while the other 25% are slightly satisfied and the 25% of them are
satisfied. 70% of the respondents said that they secure the data of everyone
entering and leaving the campus by saving in the computer with a password and
30% of the respondents said that by having a backup file.
Table 9
Data Generating
N=20

39
1. Does the current system can

easily generate reports?
Yes 0 0
No 20 100%
Maybe 0 0
2. What are the different reports

being generated?
Teaching Staff logs 10 50%

Non-Teaching Staff logs 5 25%
Daily time records 5 25%
Table 9 shows the responses of the respondents on data generating;
100% of the respondents said that the current system can’t easily generate
reports. 50% of the respondents said that the different reports being generated
are Teaching Staff logs while 25% of the respondents said Non-Teaching Staff
logs and 25% of the respondents said Daily time records.
Table 10
Good Features
N=20

40
1. Do you think it is necessary to

develop a School Log
Management System for
Employees of MELCU?
20 100%
Yes 0 0
No 0 0
Maybe
2. Do you prefer of using a School

Log Management System? 19 90%
Yes 0 0
No 1 10%
Maybe
3. Do you think the school can be

benefitted from the proposed
system? 19 90%
Yes 0 0
No 1 10%
Maybe
4. If given a chance, do you want to

implement the proposed system
in MELCU? 20 100%
Yes 0 0
No 0 0
Maybe
5. Do you think this proposed

system will give a big impact on
the school?
Yes 18 80%
No 1 10%
Maybe 1 10%
6. What are the good features that

you want to be offered in the
proposed school log
management system?
User-friendly 2 20%
Secured 0 0
Paperless 0 0
41
Faster information processing 18 80%
Table 10 shows the responses of the respondents on good features;
100% of the respondents said that it is necessary to develop a school log
management system for Employees of Montessori Educational Learning Center
of Ubay Bohol, 90% of the respondents are prefer in using school log
management system while 10% of them are maybe. 90% of the respondents said
that the school can be benefitted from the proposed system while 10% of them
are maybe. 100% of the respondents want to implement the proposed system in
Montessori Educational Learning Center of Ubay Bohol. 80% of the respondents
believed that this proposed system will give a big impact on the school while 10%
of them said no and 10% are maybe. 80% of the respondents wants faster
information processing to be offered in the proposed school log management
system for Employees of Montessori Educational Learning Center of Ubay Bohol
while the 20% wants user-friendly
CHAPTER 3
TECHNICAL ASPECT AND DESIGN OF THE SYSTEM

42
This chapter tackles the Environmental Model, Behavioral Model,
Implementation Model, and System Design, Environment composed of context
diagram, note of context diagram, event list, and event diagram. The behavioral
model comprises a top-level data flow diagram, level data flow diagram, data
dictionary, and process specification. The implementation model includes an
automated top-level data flow diagram and an automated top-level data flow
diagram and an automated-level data flow diagram. System Design is composed
of the design of the School Log Management System.

43
ENVIRONMENTAL MODEL
Figure 3. Context Diagram

44
NOTES OF THE CONTEXT DIAGRAM
Admin
The admin has full authority over the system. He/she is responsible for
adding, updating, deleting and viewing employee, department and direct users.
He/she can also view and export employee logs to excel and view, print, export
employee payroll to excel.
Staff
The staff can view, add and update employee, department and
direct users. He/she can also can also view and export employee logs to excel
and view, print, export employee payroll to excel.

45
EVENTS LIST
1. Admin can view employee information
2. Admin can view employee logs
3. Admin can add employee
4. Admin can update employee
5. Admin can delete employee
6. Admin can view employee payroll
7. Admin can print employee payroll
8. Admin can export employee payroll to excel
9. Admin can add department
10. Admin can update department
11. Admin can delete department
12. Admin can view department
13. Admin can add direct user
14. Admin can update direct user
15. Admin can delete direct user
16. Admin can view direct user
17. Staff can view employee information
18. Staff can view employee logs
19. Staff can add employee
20. Staff can update employee
21. Staff can view employee payroll
22. Staff can print employee payroll

46
23. Staff can export employee payroll to excel
24. Staff can add department
25. Staff can update department
26. Staff can view department

47
EVENT DIAGRAM

48

49

50

51

52
BEHAVIORAL DIAGRAM

53
Figure 30. Top Level Data Flow Diagram
LEVELLED DATA FLOW DIAGRAM

54

55

56

57
DATA DICTIONARY
Table 11
Department
Department – It contains the information of the department

Field that handles the ID of the department
{interger}
id
{0-9}
Auto increment
Field that handles the name of the department
name {text}
{A-Z}{a-z}
Field that handles the creation date of the department
datecreated {varchar}
{A-Z}{a-z}{0-9}
30 characters

58
Table 12
direct_users
Direct Users – It contains the information of the direct users

Field that handles the ID of the direct users
{interger}
id
{0-9}
Auto increment
Field that handles the role of the direct users
role {text}
{A-Z}{a-z}
Field that handles the first name of the direct users
fname {text}
{A-Z}{a-z}
Field that handles the middle name of the direct users
{text}
mname
{A-Z}{a-z}
Field that handles the last name of the direct users
lname {text}
{A-Z}{a-z}
Field that handles the username of the direct users
username {varchar}
{A-Z}{a-z}{0-9}
50 characters
Field that handles the password of the direct users
{varchar}
password
{A-Z}{a-z}{0-9}
50 characters
Field that handles the full name of the direct users
Fullname {varchar}
{A-Z}{a-z}{0-9}
50 characters

59
Table 13
Employee
Employee – It contains the information of the Employee

Field that handles the ID of the employee
emp_id {interger}
{0-9}
Auto increment
Field that handles the picture of the employee
picture {text}
{A-Z}{a-z}
Field that handles the first name of the employee
{text}
fname
{A-Z}{a-z}
Field that handles the last name of the employee
lname {text}
{A-Z}{a-z}
Field that handles the middle name of the employee
mname {text}
{A-Z}{a-z}
Field that handles the gender of the employee
{text}
gender
{A-Z}{a-z}
Field that handles the email of the employee
email {text}
{A-Z}{a-z}
Field that handles the contact of the employee
contact {text}
{A-Z}{a-z}
Field that handles the position of the employee
{text}
position
{A-Z}{a-z}
Field that handles the date hired of the employee
dateHired {text}
{A-Z}{a-z}
Field that handles the department of the employee
department {text}
{A-Z}{a-z}
Field that handles the salary of the employee
{interger}
salary
{0-9}
11 characters
Field that handles the username of the employee
username {varchar}
{A-Z}{a-z}{0-9}

60
50 characters
Field that handles the fingerprint_id of the employee
fingerprint_id {interger}
{0-9}
11 characters
Field that handles the fingerprint_select of the employee
{tiny interger}
fingerprint_select
{0-9}
1 characters
Field that handles the time in of the employee
time_in {time}
Field that handles the del fingerprint id of the employee
{tiny interger}
del_fingerid
{0-9}
1 characters
Field that handles the add finger id of the employee
add_fingerid {tiny interger}
{0-9}
1 characters

61
Table 14
employee_logs
Employee Logs – It contains the information of the employee logs

Field that handles the ID of the employee logs
{interger}
id
{0-9}
Auto increment
Field that handles the username of the employee logs
username {varchar}
{A-Z}{a-z}{0-9}
50 characters
Field that handles the finger print id of the employee logs
fingerprint_id {interger}
{0-9}
5 characters
Field that handles the date of the employee logs
checkindate
{date}
Field that handles the time in of the employee logs
timein
{time}
Field that handles the time out of the employee logs
timeout
{time}

62
PROCESS SPECIFICATION
PROCESS 1.0: PROCESS RECORDING
Process 1.1 Process Recording of Department
START
Open Department,
For there are department information to be recorded
Enter department Information
Display department Information
Department Information saved
END
Process 1.2 Process Recording of Direct Users
START
Open Direct Users,
For there are direct users information to be recorded
Enter direct users Information
Display direct users Information

63
Direct users Information saved
END
Process 1.3 Process Recording of Employee
START
Open Employee,
For there are employee information to be recorded
Enter employee Information
Display employee Information
Employee users Information saved
END
PROCESS 2.0: PROCESS VIEWING
Process 2.1 Process Viewing of Department
START
Open Department Information,
For there are processes to be viewed

64
Search department
If found
Display department Information
Else
Display Message “Department Information not found”
End if
END
Process 2.2 Process Viewing of Direct Users
START
Open Direct Users,
Search direct_users
If found
Display Direct Users
Else
Display Message “Direct Users not found”

65
End if
END
Process 2.3 Process Viewing of Employee
START
Open Employee,
Search employee
If found
Display Employee
Else
Display Message “Employee not found”
End if
END
Process 2.4 Process Viewing of Employee Logs
START
Open Employee Logs,

66
Search employee_logs
If found
Display Employee Logs
Else
Display Message “Employee Logs not found”
End if
END
PROCESS 3.0: PROCESS UPDATING
Process 3.1 Process Updating of Department
START
Open Department Information,
For there are processes to be updated
Search department
If found

67
Display Department Information
Department Information updated
Else
Display Message “Department Information not found”
End if
END
Process 3.2 Process Updating of Direct Users
START
Open Direct Users,
Search direct_users
If found
Direct Users updated
Else

68
End if
END
Process 3.3 Process Updating of Employee
START
Open Employee,
Search employee
If found
Display Employee
Employee updated
Else
End if
END

69
PROCESS 4.0: PROCESS DELETING
Process 4.1 Process Deleting of Department
START
Open Department,
For there are processes to be deleted
Search department
If found
Display Department
Department deleted
Else
Display Message “Department not found”
End if
END

70
Process 4.2 Process Deleting of Direct Users
START
Open Direct Users,
Search direct_users
If found
Direct Users deleted
Else
End if
END
Process 4.3 Process Deleting of Employee
START
Open Employee,

71
Search employee
If found
Display Employee
Employee deleted
Else
End if
END
PROCESS 5.0: PROCESS GENERATING
Process 4.4 Process Generating of Logs and Payroll
START
Open Logs and Payroll,
For there are processes to be generated
If not empty
Display Logs and Payroll

72
Logs and Payroll generated
Else
Display Message “Logs and Payroll not found”
End if
END

73
IMPLEMENTATION MODEL
Figure 36. Automated Top Level Data Flow Diagram
SYSTEM ANALYSIS AND DESIGN
DATABASE DESIGN
Table 15

74
department
DATA ITEMS FIELD TYPE WIDTH DECIMAL
Department ID id integer 11 0
Department Name name text 50 0
Date Creatt datecreated varchar 50 0
Table 16
direct_users
Direct Users ID id integer 11 0
Role role text 50 0
First Name fname text 50 0
Middle Name mname text 50 0
Last Name lname text 50 0
Username username varchar 50 0
Password password varchar 50 0
Full Name fullname varchar 50 0

75
Table 17
employee
Employee ID emp_id integer 11 0
Picture picture text 50 0
First Name fname text 50 0
Last Name lname text 50 0
Middle Name mname text 50 0
Gender gender text 50 0
Email email text 50 0
Contact contact text 50 0
Position position text 50 0
Date Hired dateHired text 50 0
Department department text 50 0
Salary salary integer 11 0
Finger Print ID fingerprint_id integer 11 0
Finger Print Select fingerprint_select tiny int 1 0
Time In time_in time 0 0
Delete Finger ID del_fingerid tiny int 1 0

76
Add Finger ID add_fingerid tiny int 1 0
Table 18
employee_logs
Employee Logs ID id integer 11 0
Finger Print ID fingerprint_id integer 5 0
Check In Date checkindate date 0 0
Time In timein time 0 0
Time Out timeout time 0 0

77

78
RELATIONAL DATABASE
Figure 37. Relational Database

79
OVERALL PROGRAM DESIGN

80
Figure 38. Overall Program Design
DETAILED PROGRAM DESIGN
Figure 39. Login Admin / Staff Window
Log in form is the security access of the authorized user of the program,
type the username and password in order to open this School Log Management
System.

81
Figure 40. Dashboard Window
This figure shows where you can view the total employee, Present
employee, absent employee, late employee and the monthly attendance report.

82
Figure 41. Employees Window
This figure shows the list of the employees and their information.

83
Figure 42. Employees Log Window
These figure shows where you can view employees logs and you can
export their logs to Microsoft excel.

84
Figure 43. Manage Employee Window
This figure shows where you can add, update and delete employees.

85
Figure 44. Manage Payroll Window
These figure shows where you can view employees payroll and you can
export their payroll to Microsoft excel.

86
Figure 45. Manage Department Window
This figure shows where you can view, add, update and delete
department.

87
Figure 46. Manage Direct User Window
This figure shows where you can view, add, update and delete direct user.

88
HARDWARE AND SOFTWARE REQUIREMENTS
Cost of Implementation
Hardware
 PC Unit (Existing)
 Printer (Existing)
 Biometric Device P 1,100
Software
 PHP, HTML, CSS (Existing)
 Windows 10 P 3,000.00
 Schoo Log Management System P 20,000.00
TOTAL HARDWARE & SOFTWARE COST P 24,100.00

89
ANNUAL OPERATING COST OF THE PRESENT SYSTEM
 Supplies
Bondpaper long (10 rims*300) P 3,000.00
Bondpaper short (10 rims*270) P 2,700.00
Ballpen (5 cartoons*150) P 750.00
Pencil (1 cartoons*150) P 150.00
White ink (2 cartoons*180) P 360.00
Printer ink (5 carton*360) P 1,800
Stapler (5 pcs*85) P 425.00
Folder (50 pcs*6) P 300.00
Fastener (2 cartoon*65) P 130.00
Marker (2 cartoons*100) P 200.00
TOTAL ANNUAL OPERATING COST P 9,815.00

90
ANNUAL OPERATING COST OF THE PROPOSED SYSTEM
 Supplies
Bondpaper long (5 rims*300) P 1,500.00
Bondpaper short (5 rims*270) P 1,350.00
Ballpen (2 cartoons*150) P 300.00
Pencil (1 cartoons*150) P 150.00
White ink (1 cartoons*180) P 180.00
Printer ink (2 carton*360) P 720
Stapler (3 pcs*85) P 255.00
Folder (30 pcs*6) P 180.00
Fastener (1 cartoon*65) P 65.00
Marker (1 cartoons*100) P 100.00
TOTAL ANNUAL OPERATING COST P 4,800.00

91
TOTAL ANNUAL SAVINGS
Total Operating Cost of the Present System (TOCPS1) P 9,815.00
Total Operating Cost of the Proposed System (TOCPS2) P 4,800.00
Total Annual Saving (TAS) = (TOCPS1-TOCPS2)
= P 9,815.00 – P 4,800
TOTAL ANNUAL SAVING (TAS) = P 5,015.00

92
COST RECOVERY SCHEME
Formula for Cost Recovery Scheme
f
P=
( 1+l ) n
Where:
P = Present Value l = Interest of 10%
F = Future Value n = Number of Years
1 = Constant Value
Cumulative
Year Future (1+l)n Present Value
Present Value
1 5,015.00 1.1 4,559.09 4,559.09
2 5,015.00 1.21 4,144.62 8,703.71
3 5,015.00 1.33 3,770.67 12,474.38

93
PAYBACK PERIOD
Cost of Implementation
(Development Cost) P 24,100.00
LESS: Cumulative Present Cost P 4,559.09

Unpaid Value After 1 Year P 19,540.94
Unpaid Value After 1 Year P 19,540.94

Present Value Next Year P 4,144.62
Payback Period = 4.71
Therefore, the cost of implementation will be paid within the 4 years and 7
months.

94
CHAPTER 4
Summary, Findings, Conclusions, and Recommendation
This chapter presents the summary of the proposed School Log
of Ubay. The main objective of this study was to help the administrator of
Montessori Educational Learning Center of ubay to monitor the attendance and
school logs of the school by implementing this proposed system, wherein the
proponents have a conclusion and recommendation according to their findings of
the system.

95
SUMMARY
The researchers conducted at study about Biomitric Attendance
systems to create an easier, faster, and hastle free school logs management
system for the Montessori Educational Learning Center of ubay. Through the use
of this system, will help the establishment to monitor employee’s in and out of the
school and ensure the safety monitoring of everyone and easily track the login
and out of the employees and print out the logs or records.
The main objectives of study aims to develop a system that can help the
administrator and employee’s of Montessori Educational Learning Center of
Ubay, to monitor employees attendance.

96
FINDINGS
The researchers found out that the Montessori Educational Learning
Center of Ubay was using the old Bundy Clock DTR school logs management.
Moreover, the employees of MELCU teaching and non-teaching staff using
manual recording of there dialy attendance.

97
CONCLUSION
The researchers conclude that the proposed system is functional and
friendly user. The system allow the establishment to monitor employee’s in and
out of the school and ensure the safety monitoring of the dialy attendance

98
records of everyone. The proposed School logs manangement system for
Montessori Educational Learning Center of Ubay, using biometric fingerprint
scanner is offline system, Threfore no internet connection required to acces the
system. The implementation cost of this system is not so expensive; The
Montessori Educational Learning Center of Ubay, it will benefits to have thier
School Logs Manangement system, using Biomitric fingerprint scanner.

99
RECOMMENDATION
The School logs manangement system for Montessori Educational
Learning Center of Ubay, was able to perform all the features that had been
stated in the scope and objectives. The system is effective in delivering the
content and the function by each users. The Non-Teaching staff is can easily
manage the attendance records of the employees, the payable salary of the
employees and generate all dialy time records. For future researchers configure
all of the features that a School Log Management System for Emplyee’s of
Montessori Educational Learning Center of Ubay, has.

100
REFERENCES
https://www.researchgate.net/publicatioin/315411315
An Impact of Biometric System Application Services on Biometric Service
Market.
Article in International Journal of Computer Application; August 2013
https://www.selio.com/identity-thief-dtatistic-gallup-poll
M.Theofanos, B. Stanton, R. Micheal, and N. Zhang, in “Usability testing of ten-
print fingerprint Capture” National Institute of Standards and technology(NIST),
Tech. Rep., 2007
https://ijdri.com/me/wp-content/uploads/2021/06/65.pdf
“Makati fully implements biometric timekeeping system”, 2014. MANILA,
Philippines - The Makati City government has fully implemented the use of the
Automated Biometrics Timekeeping System in monitoring the daily attendance of
employees working in its offices at the City Hall complex in Barangay Poblacion.
https://doc-pak.undip.ac.id/1665/1/rochim2019.pdf

101
Philippines uses biometrics for welfare payments”, 2013.
Based on the report of Secretary of Social Welfare and Development, Corazon
Juliano-Soliman, “the system addresses numerous complaints that there are
false grant claimants, tampered IDs and people holding other beneficiaries’ ATM
cards”.
https://onlinelibrary.wiley.com/doi/abs/10.1002/ett.4272
On the reported of Agnes A. Gervacio, president of NEC Philippines.
https://link.springer.com/article/10.1007/s11227-019-02853-2
http://hdl.handle.net/10400.13/2989\
http://dspace.uiu.ac.bd/handle/52243/117?show=full
http://dspace.uiu.ac.bd/handle/52243/117?show=full
Michael Indico (2016), conducted a study entitled “Development of Employee
Attendance and Payroll System using Finger Biometrics.”
http://www.ijiet.org/vol10/1446-ET028.pdf
Jhadiebellere (March 2014), conducted a study entitled “Time and Attendance
System”, the study was focused on how to record the time of employee in a more
accurate and easiest way.
http://www.ijiet.org/vol10/1406-ET021.pdf

102
Rao S and Satoa KJ with the same study, uses the biometric technology to
automate the process of taking the attendance of employees in the
organizations.
http://103.109.52.4/handle/52243/1663
A study developed by Adeoye, addresses the problems of various schools and
institutions using the biometric technology.
https://theijire.com/assets/pdf/archives/1653993121_61134778c305565f77b0.pdf
Another study conducted by Adewole, uses the biometric technology for solving
the problem of manual attendance.
Further study conducted by Ami-Narh, investigates the impact of the adoption
and usage of biometric time and attendance management systems among the
Ghanaian business community in the Greater Accra Metropolis.

103
APPENDICES

104
APPENDIX A
TRANSMITTAL LETTER
BOHOL NORTHERN STAR COLLEGE, INC.
Poblacion, Ubay, Bohol
Tel #: (038) 518-0279/ 331 – 1037 Fax No. (038) 518 – 0279
Email Address: [email protected] /
[email protected]
August 24, 2022
DR. VINCENT M. ENTERO

Owner
Tapon, Ubay, Bohol
Dear Mr. Entero,
We, the group of Information Technology students from Bohol Northern

Star College, Inc. (BNSC) would like to ask your permission to conduct a system
on making a “School Log Management System for Employees of Montessori
Educational Learning Center of Ubay”. This is a requirement for the degree of
Bachelor of Science in Information Technology (BSIT).
In the contract of the group, the undersigned would like to ask your approval to
conduct the study. Any information for your valuable time and cooperation would
be very grateful for the success of this study. We are hoping for your favorable
response.
Sincerely yours,
AURELIO R. IBALE JR.

Group Leader
Recommended by:
JANNETH BUFE LIGAN, LPT

Capstone Project Adviser
Noted by:
ENGR. MARY PRECY T. SY, MAT-CS (CAR)

Program Head

105
Approved by:
DR. VINCENT M. ENTERO

Owner

106
APPENDIX B
LETTER FOR GRAMMARIAN
BOHOL NORTHERN STAR COLLEGE, INC.
Poblacion, Ubay, Bohol
Tel #: (038) 518-0279/ 331 – 1037 Fax No. (038) 518 – 0279
Email Address: [email protected] /
[email protected]
August 24, 2022
GODARD V. SALAUM, MA-Eng.

English Teacher
San Roque National High School
San Roque, Mabini, Bohol
Dear Mr. Salaum,
Warmest Greetings!
We are the Bachelor of Science in Information Technology (BSIT)

students from Bohol Northern Star College (BNSC) are conducting a study
entitled “School Log Management System for Employees of Montessori
Educational Learning Center of Ubay”. Your support and approval are much
appreciated for the success of our capstone project.
God bless you always.
Sincerely yours,
AURELIO R. IBALE JR.

Group Leader
Recommended by:
JANNETH BUFE LIGAN, LPT

Capstone Project Adviser
Noted by:
ENGR. MARY PRECY T. SY, MAT-CS (CAR)

Program Head
Approved by:
GODARDV.SALAUM, MA-Eng.

107
English Teacher
APPENDIX C
Montessori Educational Learning Center of Ubay (MELCU)
High-way Tapon, Ubay, Bohol
Tel #:
Email Address:
A Proposed School Log Management System for Employees of Montessori

Educational Learning Center of Ubay (MELCU)
Questionnaire for the Employee’s Teaching & Non-Teaching

Direction: Please check the box that is appropriate to your answer.
I. Profile of the respondents in terms of
Age: ______________
Gender:
Male
Female
Civil Status:
Single
Married
Widow
Separated
Educational Attainment:
Bachelor’s Degree
Bachelor’s Degree w/ MA Units
Mastered Degree
Doctorate Degree
Other, specify: ______________

108
Employment Status:
Full-Time Instructor
Part-timer Instructor
Other, specify: _________
1. What log management system is currently used in the school?

Manually (using Bundy clock)
Computerized (using MS Word or MS Excel)
Biometric or Fingerprint scanner
Others, please specify ______________
2. How is the current Log Management System for you?

Very important
Slightly important
Important
Not important
3. How was your experience using the current school log?

Very Good
Good
Average
Fair
Poor
4. Is the current school log frustrating?

Yes
No
Maybe
5. What are the data that need to be recorded?

Employees Information
Time and date during entering and leaving of the school campus
Reasons for leaving or under time the school campus
On leave or sick leave
6. How do you record the information of the employees in the current log
system?
Others, please specify _____________
9. Is the current log system time-consuming during logging in?

Yes
No

109
Maybe
10. Does the current school attendance log can directly trace the logs of the
employee’s?
Yes
No
Maybe
11. Does the current school attendance Bundy clock log can easily update
the information of the employees?
Yes
No
Maybe
12. Is there any possibility of losing the logs of the employees in the current
log system?
Yes
No
Maybe
13. Are you satisfied with the current logging system in the school?
Yes
No
Maybe
14. How secure is the current school log system used in Montessori
Educational Learning Center of Ubay?
Very Secure
Secure
Not Sure
Not Secure
15. How effective is the current way of logging in used in the school?
Very effective
Moderately effective
Slightly effective
Not at all effective
16. Do you feel secure in filling up your information on the time sheet/card?
Yes
No
Maybe
17. Does the current system Bundy clock can easily generate reports?
Yes

110
No
Maybe
18. What are the different reports being generated?
Employees attendance
Others, please specify ____________
19. Have you ever used a biometric log system before?

Yes
No
20. Do you expect that the proposed Log Management System will make the
school log faster?
Yes
No
Maybe
21. Do you think it is necessary to develop a Log Management System in

Montessori Educational Learning Center of Ubay?
Yes
No
Maybe
22. Do you think the school can be benefitted from the proposed system?
Yes
No
Maybe
23. If given a chance, do you want to implement the proposed system in

Yes
No
Maybe
24. Do you think this proposed system will give a big impact on the school?
Yes
No
Maybe
25. What are the good features that you want to be offered in the proposed
Log Management System?
User-friendly -easy to use
Secured
Paperless
Faster information processing
Others, please specify ________

111

112
APPENDIX C
Montessori Educational Learning Center of Ubay (MELCU)
High-way Tapon, Ubay, Bohol
Tel #:
Email Address:
A Proposed School Log Management System for Employees of Montessori

Educational Learning Center of Ubay (MELCU)
Questionnaire for the Employee’s Teaching Staff

Direction: Please check the box that is appropriate to your answer.
II. Profile of the respondents in terms of:

113
Age: ______________
Gender:
Male
Female
Civil Status:
Single
Married
Widow
Separated
Educational Attainment:
Bachelor’s Degree
Bachelor’s Degree w/ MA
Units
Mastered Degree
Doctorate Degree
Other, specify:
______________
Employment Status:
Full-Time Instructor
Part-timer Instructor
Other, specify: ____________

1. What log management system is currently used in the school?
Biometric or Fingerprint scanner
Others, please specify ______________
2. How is the current Log Management System for you?

Very important
Slightly important
Important
Not important
3. How was your experience using the current school log?

Very Good
Good
Average
Fair
Poor
4. Is the current school log frustrating?

Yes
No
Maybe
5. Do you feel difficulty in the current way of logging in to the school?

Yes
No
Maybe
6. Is the current log system time-consuming during logging in?

Yes
No
Maybe
7. Does the current school attendance log can directly trace the logs of the
employee’s?
Yes
No
Maybe

2
8. Does the current school attendance Bundy clock log can easily update
the information of the employees?
Yes
No
Maybe
9. Is there any possibility of losing the logs of the employees in the current
log system?
Yes
No
Maybe
10. Are you satisfied with the current logging system in the school?
Yes
No
Maybe
11. How secure is the current school log system used in Montessori
Educational Learning Center of Ubay?
Very Secure
Secure
Not Sure
Not Secure
12. How effective is the current way of logging in used in the school?
Very effective
Moderately effective
Slightly effective
Not at all effective
13. Do you feel secure in filling up your information on the time DTR?
Yes
No
Maybe
14. How satisfied are you with the current school log?
Very Satisfied
Satisfied
Slightly Satisfied
Not satisfied
15. Does the current system Bundy clock can easily generate reports?
Yes
No
Maybe

3
16. What are the different reports being generated?

Employees attendance
Others, please specify ____________
17. Have you ever used a biometric log system before?

Yes
No
18. Do you expect that the proposed Log Management System will make the
school log faster?
Yes
No
Maybe
19. Do you think it is necessary to develop a Log Management System in

Yes
No
Maybe
20. Do you think the school can be benefitted from the proposed system?
Yes
No
Maybe
21. If given a chance, do you want to implement the proposed system in

Yes
No
Maybe
22. Do you think this proposed system will give a big impact on the school?
Yes
No
Maybe
23. What are the good features that you want to be offered in the proposed
Log Management System?
User-friendly -easy to use
Secured
Paperless
Faster information processing
Others, please specify ___________

4
CURRICULUM VITAE
Motto in life:
“The hardwork of today is the comfort Of Tomorrow”
Personal Background
Name : Aurelio R. Ibale Jr.
Nickname : Balas
Date of Birth : October 1, 2000
Place of Birth : Camambugan, Ubay, Bohol
Age : 22 years old
Height : 5’4
Weight : 62kg.
Gender : Male
Citizenship : Filipino
Civil Status : Single
Religion : Roman Catholic
Address : Purok 4, Camambugan, Ubay, Bohol
Name of Mother : Yolanda A. Reyes
Occupation : Barangay Nutrition Scholar
Name of Father : Aurelio S. Ibale Sr.
Occupation : Private Company Driver
Educational Background
Intermediate : Camambugan Elementary School
Secondary : Camambugan National High School
Tertiary : Bohol Northern Star College Inc.

5
Motto in life:
“Whatever you do in your life, Do it well.”
Personal Background
Name : Joseph U. Esperanza
Nickname : Jojo / Josh
Date of Birth : September 03, 1986
Place of Birth : Del Mar, Mabini, Bohol
Age : 36 years old
Height : 5’3
Weight : 62kg.
Gender : Male
Civil Status : Married
Address : Purok 2, Del Mar, Mabini, Bohol
Name of Mother : Falconieri F. Ugay
Occupation : Office Clerck
Name of Father : Gaulberto O. Esperanza
Occupation : Selecta Company Truck Delivery
Intermediate : Pomponan Elementary School
Secondary : San Roque National High School
Tertiary : DATAMEX Institute of Computer Technology
Bohol Northern Star College Inc.

6
Motto in life:
“Try harder if you want your life to be better.”
Personal Background
Name : Nicasio M. Malinao Jr.
Nickname : Jun Jun
Date of Birth : March 20, 1995
Place of Birth : Union, Ubay, Bohol
Age : 27 years old
Height : 5’5
Weight : 61kg.
Gender : Male
Address : Purok 4, Union, Ubay, Bohol
Name of Mother : Lucresia Mandaue
Occupation : Sari-sari’s Store Owner
Name of Father : Nicasio Malinao Sr.
Occupation : Driver
Intermediate : Union Elementary School
Secondary : Union National High School

7
Motto in life:
“Believe in yourself, Dream, Believe, and Survive.”
Personal Background
Name : Caren V. Palaca
Nickname : Ren
Date of Birth : November 11, 2000
Place of Birth : Bongbong, Ubay, Bohol
Age : 22 years old
Height : 4’9
Weight : 48kg.
Gender : Female
Address : Purok 2, Bongbong, Ubay, Bohol
Name of Mother : Merlina V. Palaca
Occupation : Housewife
Name of Father : Alberto G. Palaca
Occupation : Farmers
Intermediate : Bongbong Elementary School
Secondary : San Pascual National Agricultural High School

8
Motto in life:
“I will do my best, so that I can’t blame
myself for anything”
Personal Background
Name : Mae Apple D. Merin
Nickname : Apple
Date of Birth : May 23, 1987
Place of Birth : Butuan City
Age : 35 years old
Height : 5’3
Weight : 50kg.
Gender : Female
Religion : Seventh Day Adventist
Address : Purok 1, Katarungan, Ubay, Bohol
Name of Mother : Eunice D. Merin
Occupation : Housewife
Name of Father : Luis A. Merin
Occupation : Deceased
Intermediate : Ubay Multigrade School
Secondary : Bohol Northeastern Educational Foundation

9

Final Documents

Uploaded by

Copyright:

Available Formats

Final Documents

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Final Documents

Uploaded by

Copyright:

Available Formats

A Proposed School Log Management System for Employees of

Montessori Educational Learning Center of Ubay

A thesis presented to the of

Montessori Educational Learning Center of Ubay

Tapon, Ubay, Bohol

of the Requires for the Degree

BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY

Ibale, Aurelio Jr. R.

Merin, Mae Apple D.

The thesis entitled School Log Management System for Employee of

Montessori Educational Learning Center of Ubay, prepared and submitted by

of Bachelor of Science in Information Technology (BSIT) has been examined and

is recommended for acceptance and approval for Oral Examination.

JANNETH BUFE LIGAN,LPT

ALMIRA G. LIM,MSCRIM CHRISTOPER S. BAMBA,PHD

NORMA JUMAWID APAO,PHD,DIT,LPT

JANNETH BUFE LIGAN,LPT

ALMIRA G. LIM,MSCRIM CHRISTOPER S. BAMBA,PHD

NORMA JUMAWID APAO,PHD,DIT,LPT

LEONARDA D. LOAYON,edD ENGR.MARY PRECY T. SY,MAT-CS,(CAR)

School Log Management System

A School Log Management System for Employee of Montessori

Educational Learning Center of Ubay, is an advance attendance system using a

details of all daily time records of employees working in Montessori Educational

records of all employees. It would be simple to understand and can be used by

database at backend. For further enhancement or development of the system,

School Log Management System

We would like to express our sincere gratitude to our excellent teacher

in doing our system research project. She taught us what we should do to

us how to make a well-organized system.

patiently and meticulously reading and correcting our drafts.

kindness, love and understanding to all of us.

learn and finish our study in your school.

School Log Management System

This study is wholeheartedly dedicated to our beloved parents, who have

the conceptualization and completion of this project.

healthy life. All of these, we offer to you.

School Log Management System

CHAPTER 1: THE PROBLEM AND IT’S SCOPE

School Log Management System

CHAPTER 2: PRESENTATION, ANALYSIS AND INTERPRETATION OF DATA

CHAPTER 3: TECHNICAL ASPECT AND DESIGN OF THE SYSTEM

School Log Management System

CHAPTER 4: SUMMARY, FINDINGS, CONCLUSIONS, AND

School Log Management System

Figure 1. Research Flow.....................................................................................23

School Log Management System

Figure 30. Top Level Data Flow Diagram............................................................54

School Log Management System

Table 1. Number of Respondents........................................................................22

School Log Management System

THE PROBLEM AND ITS SCOPE

of computer technology. In the educational setting, different monitoring systems

organizations, specifically in educational institutions, is the process of monitoring

simple monitoring system that can observe devices, infrastructures, applications,

services, and even business processes. Biometric technology that involves

identifying and verifying people by analyzing the human fingerprint characteristics

to develop an accurate and extremely efficient automated attendance system

using the fingerprint verification technique.

Montessori Educational Learning Center of Ubay (MELCU) is one of the