Design and Evaluation of a GUI-Based GPA Tracker System Using Python and Sqlite for Student Academic Record Management
Article Sidebar
Main Article Content
compute student academic records efficiently. Manual recording of student grades often results in errors, misplaced records, and time-consuming computations, especially when handling multiple students. To address these concerns, the proposed system was developed using Python, Tkinter/CustomTkinter for the graphical user interface, and SQLite3 for database management. The system allows users to add, edit, search, delete, and view student records while automatically computing the Grade Point Average (GPA) based on encoded grades and subject units. Input validation was also integrated to prevent incomplete entries, invalid grades, duplicate student IDs, and other common recording errors. The results of the system testing showed that the GPA Tracker successfully performed its intended functions, including accurate GPA computation, record storage, data retrieval, report generation, and error handling. Overall, the system provides a more organized, accurate, and user-friendly approach to managing student academic records compared to manual methods. This project may also serve as a practical reference for future developers and students studying GUI design, database integration, and academic record management systems.
Downloads
References
Buditjahjanto, I. G. P. A. (2022). Analyzing factors of GUI simulation as learning media toward students’ learning outcomes. Journal of Technology and Science Education, 12(1), 83–95. doi: 10.3926/jotse.1317
Davis, F. D. (1989). Perceived usefulness, perceived ease of use, and user acceptance of information technology. MIS Quarterly, 13(3), 319–340. doi: 10.2307/249008
DeLone, W. H., & McLean, E. R. (2003). The DeLone and McLean model of information systems success: A ten-year update. Journal of Management Information Systems, 19(4), 9–30. doi: 10.1080/07421222.2003.11045748
Gaffney, K. P., Prammer, M., Brasfield, L. C., Hipp, D. R., Kennedy, D. R., & Patel, J. M. (2022). SQLite: Past, present, and future. Proceedings of the VLDB Endowment, 15(12), 3535–3547. doi: 10.14778/3554821.3554842 Virtanen, P., Gommers, R., Oliphant, T. E., Haberland, M., Reddy, T., Cournapeau, D., Burovski, E., Peterson, P.,
Weckesser, W., Bright, J., van der Walt, S. J., Brett, M., Wilson, J., Millman, K. J., Mayorov, N., Nelson, A. R. J., Jones, E., Kern, R., Larson, E., ... SciPy 1.0 Contributors. (2020). SciPy 1.0: Fundamental algorithms for scientific computing in Python. Nature Methods, 17(3), 261–272. doi: 10.1038/s41592-019-0686.
This work is licensed under a Creative Commons Attribution 4.0 International License.
All articles published in our journal are licensed under CC-BY 4.0, which permits authors to retain copyright of their work. This license allows for unrestricted use, sharing, and reproduction of the articles, provided that proper credit is given to the original authors and the source.