Development of Guidance Record Management System with Exploratory Data Algorithm for Predicting Academic Performance

Abstract: This study produces a web-based Guidance Record Management System (GRMS) designed to simplify record-keeping in guidance offices. It allows students to submit and manage their records, which counselors can access for sessions. The system also includes exploratory data analysis (EDA) features for data-driven decision-making. The admin dashboard presents visualizations and insights using EDA with Python and a Decision Tree algorithm, offering valuable information on student behavior and academic performance.

The system is built using the PHP framework Laravel, CSS and Tailwindcss for styling, JavaScript, Python's Pandas library, along with Matplotlib and Seaborn for data visualization, MySQL as the database, and Apache as the server. It is evaluated according to the ISO 25010 standard, which provides a framework for assessing software quality, ensuring that the system meets key requirements for functionality, reliability, usability, and performance.

The study successfully identified the respondents' genders as male and female. Evaluation results reveal that both male and female users, as well as technical respondents, strongly agree on the acceptability and usability of the Guidance Record Management System. Male users provided an overall average mean of 3.4, while male technical respondents rated it slightly higher at 3.5. Similarly, female users and technical respondents both rated the system with an average mean of 3.5. These results indicate a consistent positive reception across both groups, affirming the system’s effectiveness and ease of use for its intended audience.

Web-based system, Guidance Record Management System (GRMS), Record-keeping, Exploratory Data Analysis (EDA)

1. 1. Aguilar-Ramat, G. (2022). Extent of implementation of the guidance program in the public schools of Urdaneta City. IJAMS-JULY-ISSUE-275-301. https://www.ijams-bbp.net/wp-content/uploads/2022/08/IJAMS-JULY-ISSUE-275-301.pdf [Google Scholar] [Crossref]

2. 2. American School Counselor Association. (2024, June). School counselor. https://schoolcounselor.org/ [Google Scholar] [Crossref]

3. 3. American Statistical Association (ASA). (2023, January 2). JEDI corner: From visualization to ‘sensification’. Amstat News. https://magazine.amstat.org/blog/2021/10/01/jedi-corner-october-2021/ [Google Scholar] [Crossref]

4. 4. Apolinar-Gotardo, M. (2019). Using decision tree algorithm to predict student performance. https://doi.org/10.29322/IJSRP.13.04.2023.p13704 [Google Scholar] [Crossref]

5. 5. Bai, N. (2023). Philippine Statistics Authority (PSA). Educational challenges in the Philippines. https://pids.gov.ph/details/news/in-the-news/educational-challenges-in-the-philippines [Google Scholar] [Crossref]

6. 6. Beloy, R. G. (2024). Because every learner matters: A journey on saving one learner at a time through intervention projects. Parañaque National High School-Main. https://pnhsmain.depedparanaquecity.com/uncategorized/intervention-projects/ [Google Scholar] [Crossref]

7. 7. Bernardo, A. B. I., Cordel, M. O. II, Lapinid, M. R. C., Teves, J. M. M., Yap, S. A., & Chua, U. C. (2022). Contrasting profiles of low-performing mathematics students in public and private schools in the Philippines: Insights from machine learning. Journal of Intelligence, 10(3), 61. https://doi.org/10.3390/jintelligence10030061 [Google Scholar] [Crossref]

8. 8. Bernardo, A. B. I., Cordel, M. O. II, Lucas, R. I. G., Teves, J. M. M., Yap, S. A., & Chua, U. C. (2021). Using machine learning approaches to explore non-cognitive variables influencing reading proficiency in English among Filipino learners. Education Sciences, 11(10), 628. https://doi.org/10.3390/educsci11100628 [Google Scholar] [Crossref]

9. 9. Cindy, G. de, Jesus, M. K. C., & Ledda, M. K. C. (2021). Intervention support program for students at risk of dropping out using fuzzy logic-based prescriptive analytics. 144-149. https://doi.org/10.1109/CSPA52141.2021.9377304 [Google Scholar] [Crossref]

10. 10. Courtney, M. B. (2021). Exploratory data analysis in schools: A logic model to guide implementation. International Journal of Education Policy & Leadership, 17(4). https://doi.org/10.22230/ijepl.2021v17n4a1041 [Google Scholar] [Crossref]

11. 11. Damie, L., Jayson, K. P., Julian, R., Ralph, M. P., Caparas, G. L. D., & Intal, G. L. D. (2019). MyCounselor: Guidance and counseling support system for higher education institute in the Philippines. https://doi.org/10.1145/3374549.3374578 [Google Scholar] [Crossref]

12. 12. DataHeadhunters. (2022, February 20). How to use Python for data-driven decision making in education. https://www.dataheadhunters.com/how-to-use-python-for-data-driven-decision-making-in-education/ [Google Scholar] [Crossref]

13. 13. Dhami, M. (2020, December 28). The importance of guidance and counselling in adolescents’ life. Times of India. https://timesofindia.indiatimes.com/readersblog/manisha-dhami/the-importance-of-guidance-and-counselling-in-adolescents-life-28624/ [Google Scholar] [Crossref]

14. 14. Estrellado, C. J. (2023). Artificial intelligence in the Philippine educational context: Circumspection and future inquiries. International Journal of Scientific Research and Publications, 13(4), 16-23. https://doi.org/10.29322/IJSRP.13.04.2023.p13704 [Google Scholar] [Crossref]

15. 15. Fernandes, J. (2023). The role of data-driven decision-making in effective educational leadership. ABAC Journal, 27(Special Issue 2). [Google Scholar] [Crossref]

16. 16. Flores, I. M. (2023, May 12). Philippine student employability correlation heatmap (Python: pandas & seaborn). Medium. https://www.geeksforgeeks.org/how-to-create-a-seaborn-correlation-heatmap-in-python/ [Google Scholar] [Crossref]

17. 17. Hein, G. E. (1991, October). Constructivist learning theory: The museum and the needs of people. CECA (International Committee of Museum Educators) Conference, Jerusalem, Israel. Lesley College, Massachusetts, USA. [Google Scholar] [Crossref]

18. 18. IBM. (2024, June). Exploratory data analysis. https://www.ibm.com/docs/en/fci/6.6.0?topic=developing-exploratory-data-analysis [Google Scholar] [Crossref]

19. 19. IBM. (n.d.). Definition of decision tree. IBM. https://www.ibm.com/topics/decision-trees [Google Scholar] [Crossref]

20. 20. Leeway Hertz. (2024). AI use cases & applications across major industries. https://www.leewayhertz.com/leewayhertz-next-gen-generative-ai-development-services-transform-global-businesses/ [Google Scholar] [Crossref]

21. 21. Laravel Documentation. (n.d.). https://laravel.com/docs/11.x/installation [Google Scholar] [Crossref]

22. 22. Maphosa, M. W., Doorsamy, W., & Paul, B. S. (2023). Student performance patterns in engineering at the University of Johannesburg: An exploratory data analysis. IEEE Access, 11, 48977-48987. https://doi.org/10.1109/ACCESS.2023.3277225 [Google Scholar] [Crossref]

23. 23. Masters in Data Science. (2024). What is a decision tree? Retrieved June 29, 2024, from https://www.mastersindatascience.org/learning/machine-learning-algorithms/decision-tree/ [Google Scholar] [Crossref]

24. 24. Matthew B. Courtney. (2021). Exploratory data analysis in schools: A logic model to guide implementation. International Journal of Education Policy & Leadership, 17(4). https://doi.org/10.22230/ijepl.2021v17n4a1041 [Google Scholar] [Crossref]

25. 25. Mienye, I. D., Sun, Y., & Wang, Z. (2019). Prediction performance of improved decision tree-based algorithms: A review. Procedia Manufacturing, 35, 698-703. https://doi.org/10.1016/j.promfg.2019.06.011 [Google Scholar] [Crossref]

26. 26. Muliani, S., & Sihombing, V. (2024). Implementation of exploratory data analysis and artificial neural networks to predict student graduation on-time. Sinkron, 8(2), 1188-1199. https://doi.org/10.33395/sinkron.v8i2.13658 [Google Scholar] [Crossref]

27. 27. Muraina, I., Aiyegbusi, E., & Abam, S. (2023). Decision tree algorithm use in predicting students’ academic performance in advanced programming course. International Journal of Higher Education Pedagogies, 3, 13-23. https://doi.org/10.33422/ijhep.v3i4.274 [Google Scholar] [Crossref]

28. 28. Osborne, J. B., & Lang, A. (2023). Predictive identification of at-risk students: Using learning management system data. Journal of Postsecondary Student Success, 2, 108–126. https://doi.org/10.33009/fsop_jpss132082 [Google Scholar] [Crossref]

29. 29. Parreño, S. J. (2023). School dropouts in the Philippines: Causes, changes, and statistics. Sapienza: International Journal of Interdisciplinary Studies, 4(1), e-23002. https://doi.org/10.51798/sijis.v4i1.552 [Google Scholar] [Crossref]

30. 30. Patacsil, F. F., Dina, P., & Roaring, B. (2023). Analyzing flexible learning implementation using decision tree approach. Journal of Educational Science and Technology. https://doi.org/10.26858/est.v9i2.36677 [Google Scholar] [Crossref]

31. 31. Sonza, R., & Tumibay, G. (2020). Decision tree algorithm in identifying specific interventions for gender and development issues. Journal of Computer and Communications, 8, 17-26. https://doi.org/10.4236/jcc.2020.82002 [Google Scholar] [Crossref]

32. 32. Stanley, C., Petscher, Y., & Pentimonti, J. (2019). Classification accuracy. Washington, DC: U.S. Department of Education, Office of Elementary and Secondary Education, Office of Special Education Programs, National Center on Improving Literacy. Retrieved from https://improvingliteracy.org [Google Scholar] [Crossref]

33. 33. Steele, Katie and H. Orri Stefánsson, "Decision Theory", The Stanford Encyclopedia of Philosophy (Winter 2020 Edition), Edward N. Zalta (ed.), URL = <https://plato.stanford.edu/archives/win2020/entries/decision-theory/>. [Google Scholar] [Crossref]

34. 34. University of the Philippines Mindanao. (2019). Complete handbook on FCG and RRDS. https://www2.upmin.edu.ph/images/2020/Student%20Handbook%20-%20pages%20.pdf [Google Scholar] [Crossref]

35. 35. Vivek, V., Patil, D. S., Patil, S., & Tayade, S. (2023). Student record management system using Django. International Journal for Science Technology and Engineering, 11(5), 18-23. https://doi.org/10.22214/ijraset.2023.51366 [Google Scholar] [Crossref]

36. 36. Wilkinson, L.A. (2011). Systems Theory. In: Goldstein, S., Naglieri, J.A. (eds) Encyclopedia of Child Behavior and Development. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-79061-9_941 [Google Scholar] [Crossref]

37. 37. Young, A., & Kaffenberger, C. (2018, September). Data as easy as 1-2-3. School Counselor. https://www.schoolcounselor.org/Newsletters/October-2018/Data-as-Easy-as-1-2-3?st=NJ [Google Scholar] [Crossref]

• Exploring the Concept of Generative Artificial Intelligence: A Narrative Review
• Design, Development, and Evaluation of a Critiquing-Based Mobile-Web Employment Recommender System
• Integrating Bhagavad Gita Principles with Modern Supply Chain Management: A Framework for Ethical and Resilient Operations
• Soilless Indoor Farming: A Systematic Review of Iot-Based Monitoring Systems and Physiochemical Characterization Methods for Lactuca Sativa
• Financial Awareness: A Survey of Students in Bhopal