Alvin C. Dionson

Butuan City Senior High School – Stand Alone, P-9 Taguibo, Cabadbaran City, Agusan Del Norte, 8600, Philippines

DOI : https://doi.org/10.47191/ijsshr/v6-i11-47

Google Scholar Download Pdf
ABSTRACT

This research study investigates the effectiveness of Microsoft Excel as a tool for streamlining grading processes in educational institutions. The study examines whether MS Excel can minimize teacher workload or shorten the time required from checking periodical exam, recording of exam’s results, accomplishing item analysis, and generating SMEA (School Monitoring, Evaluation, and Adjustment) data particularly the MPS (Mean Percentage Score) results. The research adopts a mixed-methods approach, combining quantitative data analysis and qualitative feedback from participating teachers. The study begins by exploring the current grading practices and challenges faced by teachers in traditional paper-based grading systems. These challenges include time-consuming manual calculations, repetitive data entry, and the potential for errors during the grading process. The hypothesis is that utilizing Excel's features, such as formulas, functions, and automated formatting, can significantly improve the grading workflow. The two-sided p-value is reported as <.001 with 95% confidence interval. Therefore, there is strong evidence to reject the null hypothesis and conclude that there is a significant difference between the Traditional_Process and ExcelBased_Process. The results of this study suggest that implementing Microsoft Excel as a grading tool has the potential to streamline grading processes, minimize teacher workload, and shorten test paper checking time, recording scores, accomplishing item analysis, and generating SMEA-MPS results. The findings can inform educational institutions and educators about the benefits of leveraging technology to enhance grading efficiency. Further research can explore additional features of Excel or other software tools that could further optimize grading procedures.

KEYWORDS:

Streamlining Grading Processes, MS Excel Application, Optical Mark Recognition

REFERENCES
1) Abbas, A. A. (2009). An Automatic System to Grade Multiple Choice Questions Paper-Based Exams. Journal of Al-Anbar University for Pure Science, 3(1), 2009, ISSN: 1991-8941.

2) Alomran, M., & Chai, D. (2018). Automated Scoring System for Multiple Choice Test with Quick Feedback. International Journal of Information and Education Technology, 8(8), August 2018.

3) Churches, R. (2020). Supporting teachers through the school workload reduction toolkit. Education Development Trust.

4) D.O. 44 s, 2015. Guidelines on the Enhanced School Improvement Planning (SIP) Process and the School Report Card (SRC).

5) D.O. 31 s. 2020. the Interim Guidelines for Assessment and Grading in Light of the Basic Education Learning Continuity Plan

6) D.O. No. 8, s. 2015. Policy Guidelines on Classroom Assessment for the K to 12 Basic Education Program.

7) Estarez, A. R., Cheng, M. A., Libunao, S. M. P., & Manalastas, R. S. (2023). Teacher's experience in using ZipGrade as assessment tool. International Research Journal of Modernization in Engineering Technology and Science, 05(04), e-ISSN: 2582-5208.

8) Haleem, A., Javaid, M., Qadri, M. A., & Suman, R. (2022). Understanding the role of digital technologies in education: A review. Sustainable Operations and Computers, 3, 275-285

9) Kommey, B., Keelson, E., Samuel, F., Twum-Asare, S., & Akuffo, K. K. (2023). Automatic multiple choice examination questions marking and grade generator software. IPTEK The Journal for Technology and Science, 33(3), [DOI].

10) Selwyn, N. (2013). Education in a Digital World: Global Perspectives on Technology and Education. Routledge.

11) Zampirolli, F. A., Gonzalez, J. A. Q., & Neves, R. P. O. (2013). Automatic Correction of Multiple-Choice Tests using Digital Cameras and Image Processing. Conference Paper.

Volume 06 Issue 11 November 2023