Saint Francis College, Guihulngan, Negros Oriental, Incorporated

Acad Performance Monitoring Tracking and Certificate Generator

A Capstone Project
Presented to the Faculty of the
Department of Computer Studies
Saint Francis College,
Guihulngan, Negros Oriental, Incorporated
In partial Fulfilment of the Requirements
for the Capstone 1 Project of Bachelor of Science in Information Systems

By:
Cañete, Hansel Y.
Aniñon, Jemcel B.
Fabor, Gio T.
Aplicador, Jebert S.
Acabodillo, Edison G.
Faburada, Winmar V.

Mr. Rex Agapito A. Geopano, MAT-CS

Subject Adviser

Mr. Joseph T. Aliling

Project Adviser

June 2025
 TABLE OF CONTENTS

Title Page

CHAPTER 1

INTRODUCTION

Rationale of the Study 1

Review of Related Theories 6

Review of Related System/Projects 9

TECHNICAL BACKGROUND OF THE PROJECT/STUDY 19

Software Specification 21

Hardware Specification 39

THE PROBLEM

Statement of the Problem 54

General Objectives of the Project 54

Specific Objectives 55

Scope of the Project 60

Limitation of the Project 63

Significance of the study 66

Project Highlights 73
RESEARCH METHODOLOGY 76

Project Environment 82

Locale 82

Organization Structure 85

Requirements Specifications 87

Operational Feasibility 87

Fishbone Diagram 87

Functional Decomposition Diagram 89

List of Modules 99

Technical Feasibility 109

Schedule Feasibility 113

Gantt Chart 113

Requirements Modelling 116

Input-Process-Output Diagram 117

Data and Process Modelling 118

Context Diagram (Level 0) 119

Data Flow Diagram 123

Object Modelling 140

 Use Case Diagram 140

Sequence Diagram 155

Activity Diagram 164

Analysis 176

Cost and Benefits Analysis 176

Development Cost 177

Benefits 178

Risk Assessment Analysis Plan 180

Design 182

User Interface Design 182

Form Design 189

Data Design 196

Entity Relationship Diagram

197

Data Dictionary 200

System Architecture 216

Network Topology 218

Development 219
 Software Specifications 219

Hardware Specifications 219

Test Plan 220

Unit Testing 220

Integration Testing 221

Definition of Terms/Glossary 222

CHAPTER 2

PRESENTATION, ANALYSIS AND

INTERPRETATION OF DATA

Analysis 237

Cost and Benefit Analysis 238

Development Cost 238

Benefits 239

Risk Assessment Analysis 241

Testing Analysis 244

Unit Testing 244

Integration Testing 253

CHAPTER 3

SUMMARY OF FINDINGS

Summary of Findings 245

BIBLIOGRAPHY 248

LIST OF FIGURES

Figure 1: DepEd LIS Dashboard Interface 9

Figure 2: MyUP Portal Student Dashboard 11

Figure 3: Canvas LMS Student Grades Page 12

Figure 4: PowerSchool SIS Performance Tracking Module 13

Figure 5: CEU Student Portal Grades Page 14

Figure 6: HTML Logo 23

Figure 7: CSS Logo 25

Figure 8: JavaScript Logo 28

Figure 9: Hypertext Preprocessor Logo 30

Figure 10: MySQL Logo 32

Figure 11: Visual Studio Code Logo 34

Figure 12: Draw.io Logo 36

Figure 13: XAMPP Logo 38

Figure 14: Lenovo AMD Ryzen 5 Laptop 43

Figure 15: Lenovo Intel Core i3 Laptop 44

Figure 16: Printer 47

Figure 17: Star Topology 49

Figure 18: Hard Disk Drive 52

Figure 19: Random Access Memory 53

Figure 20: Illustration of Prototyping Model of SDLC 78

Figure 21: Location Map of the Study 84

Figure 22: Organizational Chart 85

Figure 23: Fishbone Diagram 87

Figure 24: Functional Decomposition Diagram for

Account Management 90

Figure 25: Functional Decomposition Diagram

for Grade Management 91

Figure 26: Functional Decomposition

Diagram for Honor Tracking & Ranking 92

Figure 27: Functional Decomposition

Diagram for Certificate Generation 93

Figure 28: Functional Decomposition Diagram

for Report & Archiving 95

Figure 29: Functional Decomposition Diagram

for Notification & Transparency 97

Figure 30: Functional Decomposition

Diagram for Audit & Security 97

Figure 31: Gantt Chart 113

Figure 32: Input-Process-Input (IPO) of the system 117

Figure 33: Context Diagram Level 0 122

Figure 34: Data Flow Diagram Level 1 126

Figure 35: Data Flow Diagram Level 2

User Authentication & Access Control 128

Figure 36: Data Flow Diagram Level 2

User Account Management 129

Figure 37: Data Flow Diagram Level

2 Academic & Curriculum Management 131

Figure 38: Data Flow Diagram Level 2 Grade Management 133

Figure 39: Data Flow Diagram Level 2

Honor Tracking & Ranking 134

Figure 40: Data Flow Diagram Level 2 Certificate Generation 135

Figure 41: Data Flow Diagram Level 2 Report & Archiving 136

Figure 42: Data Flow Diagram Level 2

Notification & Transparency 137

Figure 43: Data Flow Diagram Level 2 Audit & Security 138

Figure 44: Use Case Diagram for Admin User 143

Figure 45: Use Case Diagram for Registrar User 145

Figure 46: Use Case Diagram for Chairperson User 147

Figure 47: Use Case Diagram for Principal User 148

Figure 48: Use Case Diagram for Instructor User 150

Figure 49: Use Case Diagram for Class Adviser User 151

Figure 50: Use Case Diagram for Students User 153

Figure 51: Use Case Diagram for Parents User 154

Figure 52: Sequence Diagram for the Admin user 155

Figure 53: Sequence Diagram for the Registrar user 156

Figure 54: Sequence Diagram for the Instructor user 157

Figure 55: Sequence Diagram for the Class Adviser user 158

Figure 56: Sequence Diagram for the Chairperson user 159

Figure 57: Sequence Diagram for the Principal user 160

Figure 58: Sequence Diagram for the Student user 161

Figure 59: Sequence Diagram for the Parent user 162

Figure 60: Sequence Diagram for the System 163

Figure 61: Login User Account Activity 166

Figure 62: Strand Management Activity 167

Figure 63: Subject Management Activity 168

Figure 64: Set Management Activity 169

Figure 65: Grade Management Activity 170

Figure 66: Course Management Activity 171

Figure 67: Honor List Generation Activity 172

Figure 68: Certificate Generation Activity 173

Figure 69: Report Generation Activity 174

Figure 70: System main page 183

Figure 71: User Interface design to admin dashboard 184

Figure 72: User Interface design to users in admin 185

Figure 73: User Interface design to students in admin 186

Figure 74: User Interface design to subjects 187

Figure 75: User Interface design to reports 188

Figure 76: Login Form Design 189

Figure 77: Add New User Form Design 190

Figure 78: Add New Student Form Design 191

Figure 79: Import New Students Form Design 192

Figure 80: Add New Subject Form Design 193

Figure 81: Import New Subjects Form Design 194

Figure 82: Add Departments Form Design 195

Figure 83: Entity Relationship Diagram of the System 198

Figure 84: SAINT FRANCIS COLLEGE GUIHULNGAN,

NEGROS ORIENTAL INCORPORATED ACAD

PERFORMANCE MONITORING TRACKING

AND CERTIFICATE GENERATOR 126

LIST OF TABLES

Table 1: Comparative Matrix 16

Table 2: Context Diagram Elements and Symbols 120

Table 3: Data Flow Diagram Elements and Symbols 124

Table 4: Use Case Diagram Elements and Symbols 141

Table 5: Activity Diagram Elements and Symbols 164

Table 6: Admin Table 200

Table 7: Registrar Table 201

Table 8: Instructor Table 202

Table 9: Class adviser Table 203

Table 10: Chairperson Table 204

Table 11: Principal Table 205

Table 12: Student Table 207

Table 13: Parent Table 208

Table 14: Strand Table 209

Table 15: Course Table 210

Table 16: Subject Table 211

Table 17: Grades Table 212

Table 18: Honor Roll Table 213

Table 19: Certificates Table 214

Table 20: Leaderboards 215

Table 21: Risk Management Plan 241

Table 22: Test name number U001-U006 245

Table 23: Test name number U007-U013 247

Table 24: Test name number U014-U016 248

Table 25: Test name number U017-U019 249

Table 26: Test name number U020-U021 250

Table 27: Test name number U022 251

Table 28: Test name number U023-U027 252

Table 29: Test name number 1001-1005 253

Table 30: Summary of Risk Assessment Plan 255