Design and Evaluation of a GUI-Based GPA Tracker System Using Python and Sqlite for Student Academic Record Management

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.

GPA Tracker, Python, SQLite3, Graphical User Interface, Student Records, Academic Record Management

1. 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 [Google Scholar] [Crossref]

2. 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 [Google Scholar] [Crossref]

3. 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 [Google Scholar] [Crossref]

4. 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., [Google Scholar] [Crossref]

5. 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. [Google Scholar] [Crossref]

• Enhancing Formation Control of Multi Agent Systems Using Ann Based Technique
• Improving Sliding Mode Control with Chattering Reduction using Fuzzy Based Technique
• Cooking Quality, Fasting Blood Glucose, Glycemic Index and Load of High–Fiber Noodles Made from Wheat, Tiger Nut Residue and Cassava Flour Blends
• Matrix Rhythm Therapy Versus Interferential Therapy Combined with Lumbar Stabilization Exercises in Chronic Non-Specific Low Back Pain: A Randomized Comparative Trial
• Formulation and Sensory Evaluation of Functional Cake Prepared from Sweet Potato Powder