Streamlining Grading Processes: A Study on the Efficacy of Microsoft Excelas a Tool for Minimizing Teacher Workload and Shortening Test Paper Checking Time

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