¹Cris Edison U. Villanueva, ²Mary Rose Pelindiana-Villanueva

^1,2Lutucan Integrated National High School, Sariaya, Quezon, Philippines 4322

DOI : https://doi.org/10.58806/ijsshmr.2025.v4i1n10

Google Scholar Download Pdf
ABSTRACT

This action research investigates the effectiveness of the SMART Excel Tool, which is a user-friendly Microsoft Excel spreadsheet, custom-designed to enable the smooth calculation and analysis of student grades. This study addresses issues of time consumption and proneness to errors resulting from manual calculations, usually incurred by teachers, improving workload efficiency. A teacher survey (n=48) investigated current practice in the analysis of student Mean and Mean Percentage Score. Current practices were generally agreed to (Overall WAM: 3.19), although some areas of best practice emerged, including the manual categorization of scores (WAM: 3.10) and highlighting MPS scores (WAM: 3.10). Following the implementation of the SMART Excel tool and a related training session, teacher perceptions had changed significantly to the positive (Overall WAM: 3.42). It was reported by teachers that they found the tool very useful with a WAM of 3.64, easy to use with a WAM of 3.44, and accessible technical support with a WAM of 3.30. These findings suggest that the SMART Excel Tool has great potential to reduce teachers' workload around data analysis. These findings suggest that the SMART Excel Tool should be implemented more widely within the school division. Supplemental training in video format and user guides can provide individuals with different learning styles the ability to have a reference for teachers for continuing use. Future research at this point in time should examine if the tool has a long-term effect of reducing teacher workload while improving student learning outcomes, along with any shifts in teaching practice. It would also be interesting to examine the applicability of the SMART Excel Tool in other educational contexts, such as its application in elementary schools or other subject areas. In view of taking up these recommendations and continuing to explore, this research can help lessen teacher workload, increase the efficiency of data analysis, and engender a more streamlined and supportive educational environment.

KEYWORDS:

data automation, learner assessment, excel tool, teacher efficiency, technology integration

REFERENCES

1) EdSurge (n.d.). EdSurge. Retrieved from https://www.edsurge.com/

2) Fulton, K. (2018, March 12). How teachers can subtract hectic workloads. Edutopia. Retrieved from https://www.edutopia.org/article/how-teachers-can-subtract-hectic-workloads/

3) INTERNATIONAL JOURNAL OF MULTIDISCIPLINARY: APPLIED BUSINESS AND EDUCATION RESEARCH 2021, Vol. 2, No. 7, 587 – 590 http://dx.doi.org/10.11594/ijmaber.02.07.06 How to cite: Raganit, A. A. (2021). A Comparative Analysis of Mean Percentage Scores (MPS) of Senior High School Classes. International Journal of Multidisciplinary: Applied Business and Education Research. 2(7), 587 – 590. doi: 10.11594/ijmaber.02.07.06 Research Article A Comparative Analysis of Mean Percentage Scores (MPS) of Senior High School Classes Ariel A. Raganit Department of Education, Leyte Division Article history: Submission July 2021 Revised July 2021 Accepted July 2021 A

4) National Council of Statistical Software (NCSS). (2023). Required Sample Size to Detect a Problem in a Pilot Study [PDF]. Retrievedfromhttps://www.ncss.com/wpcontent/themes/ncss/pdf/Procedures/PASS/Required_Sample_Size_to_Detect_a_Problem_in_a_Pilot_Study.pdf

5) Moseley, P., O'Malley, C., & Várnai, G. (2017). Time to automate? Exploring the potential of e-assessment to reduce teacher workload. Studies in Educational Evaluation, 53, 142-153.

6) Public Broadcasting Service (PBS). (2021, April 14). SEL for Teachers: Understanding Stress and Burnout Video file]. Retrieved from https://www.pbs.org/video/sel-for-teachers-understanding-stress-and-burnout-ud5idy/

VOlUME 04 ISSUE 01 JANUARY 2025