This study aimed to enhance the efficiency of preparing junior high school forms through automation using a macro-enabled workbook in Excel. The primary objective was to evaluate the workbooks effectiveness in terms of accuracy, efficiency, and ease of use, while also assessing its functionality, compatibility, and scalability. A mixed-methods approach was used to gather both qualitative and quantitative data through surveys and feedback. Twenty-four class advisers evaluated the macro-enabled workbook for accuracy, efficiency, and ease of use, while three ICT experts reviewed its functionality, compatibility, and scalability. A prototype was created, tested by five teachers, and refined based on their suggestions to better meet user needs. The workbook was introduced during a School Learning Action Cell (SLAC) session, where additional evaluation and feedback from advisers and ICT experts were analyzed to guide further improvements. The results revealed that the macro-enabled workbook received very high ratings from class advisers for accuracy, efficiency, and ease of use, with some variation noted in perceptions of ease of use. ANOVA analysis identified differences in perceptions, prompting a post-hoc analysis, which revealed no significant differences among the variables. ICT experts validated the workbooks functionality, compatibility, scalability highlighting its operational characteristics. Feedback from class advisers emphasized the need for comprehensive training to enhance ease of use, while ICT experts suggested addressing scalability and compatibility using online applications for broader application. The study highlighted the workbooks effectiveness in automating junior high school forms, offering practical solutions to enhance efficiency in their preparation.

Accuracy

School Forms

Efficiency

Automation

Macros

Excel