Computer Laboratory Digital Logbook system

A Capstone Project
Presented to the
Faculty of the
School of Information and Communication Technology
PASSI CITY COLLEGE
City of Passi, Iloilo

In Partial Fulfilment
Of the Requirements for the Degree
BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY

by

Arnie James Alalin

Daisyrie Catipunan
Jennifer Cabrera
Ken Jhon Bela-Ong
Joven Chavez
Clarince Balitor
Menard Alivar
 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

CHAPTER I
INTRODUCTION
This chapter will discuss the context of the problem,

the statement of the problem, the purpose and description,

the objectives of the project, its scope and limitation and

the significance of the project.

Project Context
The Computer Laboratory Digital Logbook project aims to

develop a digital system that will replace the traditional

logbook used in computer laboratories. In most educational

institutions, logbooks are used to keep track of the usage

of computer equipment, users, and other resources in the

laboratory.

However, these logbooks are often outdated,

inefficient, and prone to errors. With the advancement of

technology, there is a need to develop a more modern and

effective system that can streamline the management of

computer laboratory resources. The project aims to have

digital logbook in the computer laboratory of Passi City

College to keep track of each person who has previously used

the computer.

With the increasing demand for computer usage in

schools, computer laboratories have become a common facility

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

in educational institutions. These laboratories provide

students with access to computer systems and other necessary

equipment to aid their learning.

Managing and monitoring the usage of these computer

laboratories can be a challenging task for the

administration. One of the essential tasks is keeping track

of the usage of the computer systems and equipment by

students and faculty members. A manual logbook system is

often used to record these details, but it can be tedious

and time-consuming.

To address this issue, the Computer Laboratory Digital

Logbook will be develop that can record and monitor the

usage of computer laboratories in an educational

institution. This digital system will provide a more

efficient and accurate way of keeping track of computer lab

usage.

The project will develop a user-friendly digital

platform accessible by students and faculty members. The

system will enable the recording of various details,

including the user's name, time and date of usage, duration

of usage, and computer system used. This system's

implementation will ensure that computer laboratories are

used efficiently and can help identify any misuse of

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

equipment, ensuring that the computer laboratory's resources

are used optimally.

The project's primary objective is to develop a

computer laboratory digital logbook system that is easy to

use and efficient in managing computer lab usage. The system

will enable the administration to keep track of the usage of

computer labs by students and faculty members effectively.

Objectives of the Study

General Objective

To develop a Computer Laboratory Digital Logbook that

can efficiently and accurately monitor the utilization and

maintenance of computer laboratory equipment and determine

its acceptability.

Specific Objectives

1. design a Computer Logbook for Passi City College. The

application will allow the user to view the information

and contents of the computer’s previous user’s

identity.

2. determine its acceptability in terms of its usability

Scope and Delimitation of the Study

The system will be designed to record the use of

computers in the laboratory, including the date and

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

time of use, the name of the user. The system will not

include any other features beyond the aforementioned

purpose.

The development of the system will follow the SDLC -

Agile Model Method, which will guide the researchers in the

iterative and incremental development of the system.

The system will be accessible only on the computers in

the laboratory and won’t require a unique login credential

to access the system. The users will be allowed to record

their computer usage in the logbook, but they will not be

allowed to modify or delete any existing entries.

The evaluation of the usability of the Computer

Laboratory Digital Logbook system will be conducted by the

laboratory staff and randomly chosen students. The

evaluation will be based on a standardized questionnaire

checklist, which will assess the usability and effectiveness

of the system.

This study will be conducted solely in the computer

laboratory of the institution where the system will be

implemented. The timeline of this study will be from the

first semester of the academic year 2023-2024.

Significance of the Study

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

This Computer Laboratory Digital logbook system will

benefit the following:

Students. The system will help students easily log

their laboratory activities and experiments, making it more

convenient for them to monitor their progress and ensure

that they are meeting their course requirements.

Faculty. The system will help faculty members easily

track and monitor the laboratory activities and experiments

of their students, making it easier for them to evaluate

their performance and provide feedback.

Administrators. The system will help administrators

ensure that the laboratory activities and experiments are

being properly recorded and that the necessary equipment and

resources are available for students to use.

Researchers. This study can provide insights into the

effectiveness of digital logbook systems and help

researchers identify areas for future improvement in this

field.

Future Researchers. This study will benefit future

researchers in developing a system that can help them give

an idea and basis to their future project.

Definition of Terms
 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

The following terms used in this study were defined to

ensure clarity and better understanding:

Computer Laboratory. A computer laboratory is a room

equipped with computer hardware and software used for

educational purposes, such as computer-assisted instruction

or scientific research. It is a designated space within an

academic institution or research facility that provides

access to computer resources for students, faculty, and

staff.

Digital Logbook. A digital logbook is an electronic

record-keeping system used to track and document laboratory

activities and experiments. It is a tool used to record and

store data in a digital format, making it easier to

organize, search, and analyse data. In this study, the

digital logbook refers to the specific system developed for

computer laboratories, allowing users to log and manage

their activities.

Usability. Usability refers to the quality of a user's

experience when interacting with products or systems,

including websites, software, devices, or applications.

Usability is concerned with effectiveness, efficiency, and

overall satisfaction. In the context of this study,

usability refers to the ease of use and user satisfaction

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

with the digital logbook system. In the context of this

study, usability refers to the ease of use and user

satisfaction with the digital logbook system. It focuses on

designing the system to be intuitive and user-friendly for

both students and administrators.

User Interface. It is the visual elements and layout

of a software application that allow users to interact with

the system. It includes buttons, icons, text boxes, menus,

and other graphical components that users can click or tap

to perform various tasks. In this study, the user interface

refers to the design and arrangement of these elements in

the digital logbook system, aiming to provide a clear and

intuitive interface for users.

Admin Account. It is an account created for a system

administrator or an authorized person who has complete

control and access to the system. An admin account allows

the user to manage the system settings, user accounts, and

other important aspects of the system. In this study, the

admin account refers to the privileged account with access

to edit logbook history and perform administrative tasks

within the digital logbook system.

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

Database. It is a structured collection of data that is

stored and organized in a computer system. The database

allows users to retrieve, store, and manage data

efficiently. In this study, the database refers to the

storage mechanism used in the digital logbook system to

store logbook entries and facilitate data retrieval.

CHAPTER II

REVIEW OF RELATED LITERATURE AND STUDIES

This chapter primarily presents the different

researches and other literatures from both foreign and local

researchers, which have significant bearings on the

variables included in the research. It focuses on several

aspects that will help in the development of this project.

The project is generally concentrating on the feasibility of

creating Computer Laboratory Digital Logbook for Passi City

College. The literatures of this project came from books,

journals, articles, electronic materials such as PDF, slide

shares, and other existing thesis and dissertations, foreign

and local literature that are believed to be useful in the

advancement of awareness concerning the project.

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

Related Studies

Computer Laboratory Digital Logbook system: A Systematic

Review

This systematic review examines the effectiveness of

Computer Laboratory Digital Logbook system. The authors
reviewed several studies that have used digital logbooks in
computer laboratory settings and found that they can improve
the effectiveness of computer laboratory by providing
students with a platform for recording their observations
and collaborating with their peers. The review also
identified several challenges to implementing digital
logbooks, including issues related to privacy and security.
(J. T. de Oliveira, V. Alves, and J. A. Dias)

COMPUTER-BASED LOGBOOK FOR SURGICAL REGISTRARS

The digital logbook system is designed to mimic the

existing paper logbook used by trainees. It retains the same
categories and information required for recording
procedures. The logbook starts with an initial registration
 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

page where trainees enter their name and a unique

identification number assigned by the College. These details
are automatically included in every procedure entry for easy
recall and analysis. Trainees also provide additional
information such as their parent hospital, supervising
surgeons, and the hospital of their current rotation. The
data entry page allows trainees to add records, with certain
fields like supervising surgeon, level of supervision,
hospital, and procedure type being selected from predefined
options. This ensures accuracy and prevents
miscategorization and transcription errors. The logbook
includes fields for complications, diagnosis, pathology, and
allows trainees to enter any other relevant information for
each procedure.
Brouwer, R., & Kiroff, G. (2002)

Electronic Logbook for Space System Integration & Test

Operations
E-Logbook is an electronic logbook system designed to
replace paper documentation in aerospace I&T operations. It
has been successfully utilized during the integration and
testing of the large area telescope (LAT) in the GLAST
satellite at SLAC. Over 41,000 records have been created
without data corruption, demonstrating its reliability. E-
Logbook features a shift log for improved project awareness
and a configuration log for instant reporting on the space
system's I&T state. Its ergonomic design with graphical user
interfaces reduces human error and enhances management
oversight. Operators and management prefer E-Logbook over
paper logbooks, recommending its use in the aerospace
 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

industry.
Kavelaars, A. T., Bloom, E., Claus, R., Fouts, K., & Tuvi,
S. (2009).

Digital Logbook System for the Management of Medical Records

The study by A. M. K. Al-Mahmood et al. (2020) focuses

on the development and evaluation of a digital logbook
system for managing medical records in a hospital setting.
The system aims to address the limitations of traditional
paper-based medical records by providing features such as
patient registration, medical history, medication records,
diagnostic test results, and treatment plans. The study
demonstrates that the digital logbook system is user-
friendly, efficient, and improves the accuracy and
completeness of patient records. It concludes that the
system has the potential to enhance healthcare delivery and
patient outcomes by providing a more efficient and accurate
means of documenting and managing patient information.
A. M. K. Al-Mahmood et al. (2020)

COMPACT ELECTRONIC LOGBOOK SYSTEM

Compact Electronic Logbook System (Clog) is designed

to record the events in an organized way during operation
and maintenance of an accelerator facility. Clog supports
functionalities such as log submission, attachment upload,
easy to retrieve logged messages, RESTful API and so on,
which aims to be compact enough for anyone to conveniently
deploy it and anyone familiar with Java EE (Enterprise
Edition) technology can easily customize the
 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

functionalities. After the development is completed, Clog

can be used in accelerator facilities such as BEPC-II
(Beijing Electron/Positron Collider Upgrade) and HEPS (High
Energy Photon Source). This paper presents the
designimplementation and development status of Clog.
M. T. Kang, Z. Zhao, J. Liu, D.P. Jin(2017)

Matrix of Related Studies

Related Study Relevance Difference
Computer Laboratory Develops a Provides a
Digital Logbook customized digital comprehensive
system: A Systematic logbook system for a overview of various
Review specific institution digital logbook
systems and their
impact on computer
laboratory
effectiveness
COMPUTER-BASED Introduces a digital Mimics the structure
LOGBOOK FOR SURGICAL logbook system for and categories of
REGISTRARS surgical registrars the existing paper
logbook
Electronic Logbook Introduces E- Specifically
for Space System Logbook, an developed for
Integration & Test electronic logbook aerospace I&T
Operations system for aerospace operations and used
I&T operations in the GLAST
satellite project at
SLAC
Digital Logbook Develops a digital Specifically
System for the logbook system for designed for
Management of managing medical managing medical
Medical Records records in a records in a
hospital setting hospital setting
COMPACT ELECTRONIC Focuses on recording Specifically
LOGBOOK SYSTEM events during designed for the
operation and operation and
maintenance of an maintenance of an
 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

accelerator accelerator
facility. It facility. Supports
provides functionalities
functionalities for tailored to the
log submission, needs of accelerator
attachment upload, facilities such as
retrieval of logged BEPC-II and HEPS.
messages, and
customization using
Java EE technology.

Synthesis

These studies highlights the development and

application of digital logbook systems in different domains,

including computer laboratories, surgical settings, medical

records management, and accelerator facilities. While each

system serves a specific purpose, they share common

objectives of improving efficiency, accuracy, data

management, and accessibility.

The Computer Laboratory Digital Logbook system

facilitates student observations and collaboration, while

the Surgical Registrar Logbook replicates the traditional

paper logbook for surgical trainees. The Medical Records

Management Logbook focuses on accurate and comprehensive

patient records, and the Logbook System for the accelerator

facility streamlines event recording and maintenance.

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

Despite their differences, these studies collectively

demonstrate the advantages of digital logbook systems over

traditional paper methods, such as increased efficiency,

improved accuracy, enhanced data management, and better

access to information. These findings indicate the growing

recognition of digital logbooks and their potential to

optimize data recording and management practices in various

fields.

Overall, advancements in technology provide

opportunities for further customization and development of

digital logbook systems, allowing them to meet the specific

needs of different domains and contribute to overall

operational efficiency and effectiveness in data management.

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

Chapter III

METHODOLOGY

This chapter presents the project development, project

requirement specification, and project design of the system.

Project Development

System Development Life Cycle

Figure 1. SDLC Agile Model

The researchers will employ the principles of Systems

Development Life Cycle (SDLC) specifically; the SDLC Agile

model was used as discussed in the following:

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

Planning. In this phase, the researchers will submit an

approved letter from the Dean and thesis adviser to conduct

the study. Then, the researchers will determine the

different phases to be conducted. Gantt chart was drafted

for the schedule of tasks and guided the researchers on the

activities to be accomplished.

Requirements Analysis. The researchers will submit an

approved letter from the Dean and capstone adviser to gather

user requirements through interviews to the Passi City SOICT

Dean Coordinator and Staff to gather necessary data needed

that could help to develop the system.

The researchers will also identify the minimum hardware

and software requirements needed in executing the system

based on the compatibility, operability, storage capacity,

and screen resolutions. As for the majority, most of the

students and faculty members will be using the Computer

Laboratory.

The researchers will also use their computer as an

emulator to run the system.

Design. The researchers will work together to execute

the logical design to make the system relevant and

beneficial. The researchers created a prototype for the

system to be developed. The system will also be designed

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

based on the data gathered and conceptualized using the

block diagram representation that served as the basis for

the implementation.

The researchers used the Visual Studio Code in

developing the system.

Coding/Implementation. In this phase of SDLC, the

researchers implemented the Digital logbook on the system

flowchart and the prototype created.

Project Requirement Specification

i. operational Feasibility

Functional Decomposition Diagram

Figure 8. Use Case Diagram

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

ii. Technical Feasibility

Software Specification

The researcher will use Pycharm in developing the

system. The researcher will also use the minimum software

components with the following specification

Operating System. Intel(R) Core(TM) i5-10210U CPU @

1.60GHz 2.11 GHz

Installed RAM: 4.00 GB

System Type: 64-bit operating system, x64-based

processor
 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

iii. Schedule Feasibility

Gantt chart

Legend :
Planning

Requirements
 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

Analysis

Design

Coding and Implementation

iv. Economic Feasibility

Cost and Benefit Analysis

Development Cost of the Project Table 1. System

Development Cost

Technical
Analyst Developer
Writer/QA
Project Total
No. Cost No. Cost No. Cost
Task/Phas Cost
of (P150/ of (P300/ of (P150
e
Days day) Days day) Days /day)
Project
Initiation
Project
Planning
Requirements
Analysis
Design
Implementation
Unit Testing
Acceptance
Testing
Project
Monitoring &
Controlling
Project
Closing
Total

Project Design

i. Requirements Modelling

IPO Chart

The Input-Process-Output (IPO) Diagram was used in

this study. It is presented in figure 9. It displays

the variables of the study. Computer Laboratory Digital

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

Logbook is the input used in developing the system. The

researcher used the System Development Life Cycle

(SDLC) method in developing the system. The application

was subjected to evaluation of its usability. The

developed system, Computer Laboratory Digital Logbook,

and the evaluation results were the outputs.

Figure 9. Input-Process-Output diagram

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

Context Diagram

Figure 10. Context Diagram

The context diagram illustrates the flow of how the

system works otherwise, it shows the interaction between a

system and other external factors which the system is

designed to interface.

From the Digital Logbook System, the User of the Home

page will either choose Faculty or Student to start using

the system or either choose Dashboard display to view the

data that was previously submitted into the database through

the system, after choosing which path to choose in the

Faculty side the only requirements to submit the users data

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

is the name for while the student needs to submit their

information from Name, School ID, Year and Section.

Data Flow Diagram (Level 0)

Figure 11. Data Flow Diagram (level 0)

A data flow diagram (DFD) was also used in this study.

Data flow diagram shows representation to describe the

system operation through the data movement. Data flow

diagram was used by the researchers as it helps to

understand process or system operation to improve efficiency

and develop better processes and it shows exactly where the

data is going so that you can make sure every step is

understandable.
 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

System Flowchart or Program Flowchart

Figure 12. System Flowchart or Program Flowchart

The system flowchart explain the functionality of an

entire system while, program flowchart explains how a

particular program solves a given task in the system. In the

figure above, it displays the relationship among the input,

processing and output of an Automatic Identification System

(AIS), it also illustrates the sequence of logical

operations performed by the executing program or system.

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

Data Design

i. Entity Relationship Diagram

Figure 13. Entity Relationship Diagram

An Entity Relationship Diagram (ERD) also known as

relationship model was also utilize in the system. The

figure above shows the graphical representation that

depicts relationship about the user among the faculty,

student and dashboard. The researchers used the Entity

Relationship Model which is essential for modelling the

data stored in a database. ER diagrams specify what data

will be stored and which database is built.

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

ii. Data Dictionary

Field Name Data type Data Format Field Size Description Example

Log ID Integer NNNNNN 100 Auto increment 1

numbering
system
Name Text 20 Full name of Arnie
user
School ID Text 20 User school id 001-0001

Course Text 20 User college BSIT

course
Yr/Section Text 20 User college 3-A
year/section
Date/Time Date/Time YYYY/MM/DD 10 User time of 2001/11/05
use

The data dictionary includes the following fields: Auto

Increment Number, Name, School ID, Course, Year/Section, and

Date/Time. It outlines the data types, descriptions, and

constraints for each field. The data dictionary serves as a

reference for understanding and maintaining the structure

and properties of the data within your project. It ensures

consistency, integrity, and clarity in data management and

provides valuable documentation for your project's data

requirements.
 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

Output and User-Interface Design

Form

Home Page Faculty user interface

Student User Interface

Student Dashboard
Interface
 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

Faculty Dashboard Interface Password Promt

Report

Home Page. The First thing the user will see when

opening the computer program that shows 3 buttons to

choose on which user are you or just to view the data

stored in the database.

Faculty user interface. The Faculty user interface is

when the user identifies her/his self to submit user’s

own data in the Digital Logbook that only requires a name

with two buttons underneath for Register and Return to

main or home page.

Student User Interface. The user interface for the

Student to submit his/her name, ID number, course, and

year/section with two buttons underneath for Register and

Return to main or home page.

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

Student Dashboard Interface. In this page when clicking

the Open Dashboard in the Home page it will take you to

the table of content of the Digital logbook which shows

the data submitted of previous users which it a tables

next to it for Faculty Dashboard Interface.

Password Prompt. The Password prompt will appear when

the user tries to edit the data in the table which will

require a password to save the edited data.

System Architecture

i. Network Model
 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

ii. Network Topology

Star Topology

Security

The System will use Access Control: Implement

mechanisms to control access to your system, such as user

authentication (e.g., username and password) and

authorization (assigning appropriate privileges and roles to

users). This ensures that only authorized individuals can

access and perform specific actions within the system.

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

Project Testing and Evaluation

i. Evaluation of the Project

System Testing

The researcher will conduct system testing to test the

functionality of the developed application. The

researchers will create a summary and sample for the test

case that will be conducted. A sample test case is shown

figure 10.

Figure 10. Sample Test Case

 PASSI CITY COLLEGE
City of Passi, Iloilo

School of Information and Communication Technology

ii. Evaluation instrument

The researchers will make use of questionnaire

checklist of John Brooke 1986 in determining the

usability of the developed system. The evaluation

is shown in figure 11.

Figure 11. Evaluation Instrument