Abstract
Efficient management of academic and administrative data remains a challenge for many teachers in Indonesia, including those at UPTD SD 187 Barru. This training program was designed to enhance teachers' skills in utilizing Microsoft Excel, a crucial tool for data management in education. The one-day training covered topics such as Excel interface introduction, basic formulas like SUM and IF, and advanced features such as dropdown lists and complex IF formulas. Employing an interactive learning approach, the sessions combined theory and hands-on practice. Evaluation results showed significant improvements in participants' understanding and skills, as evidenced by their ability to independently create student assessment tables. The collaborative approach between lecturers and students played a key role in the training’s success. This program is expected to contribute to increased efficiency and accuracy in school data management while motivating teachers to further develop their technological competencies.
Introduction: The Administrative Bottleneck
In many developing educational contexts, teachers are often overwhelmed by administrative tasks that detract from their primary role: teaching. At UPTD SD 187 Barru, a specific bottleneck was identified: manual data management. Educators struggled to efficiently process student grades, rank classes, and generate reports due to a lack of fundamental spreadsheet skills. This manual entry is not only time-consuming but also prone to human error, limiting the potential for data-driven interventions in the classroom. This initiative sought to bridge this digital divide by upskilling teachers in the use of Microsoft Excel.
Methodology: A Four-Stage Collaborative Framework
The program followed a structured "Community Service" (Pengabdian Masyarakat) framework consisting of four key stages:
- Needs Assessment: Interviews were conducted with school principals and Teacher Working Groups (KKG) to pinpoint specific pain points in daily data management.
- Curriculum Design: A progressive module was developed, moving from basic interface management to complex logical operations like nested
IFformulas and data validation. - Interactive Execution: A one-day workshop was held, blending theoretical instruction with immediate hands-on application.
- Collaborative Mentoring: A unique aspect of the methodology was the inclusion of university students as technical assistants, providing real-time, low-stakes support for participants.
Key Insights and Technical Growth
The training emphasized contextual learning. Rather than teaching Excel functions in isolation, every formula was applied to real-world scenarios such as grading or class ranking. This immediate relevance fostered high levels of engagement. A significant cognitive milestone was observed during the transition from simple arithmetic (e.g., SUM) to logical functions (IF). Once teachers grasped the underlying logic, they began to envision automated feedback systems and more complex administrative workflows.
The presence of student mentors acted as a catalyst for learning, reducing the intimidation factor often associated with new technology and allowing for personalized troubleshooting.
Results and Impact
The program yielded measurable improvements in technical proficiency:
- Quantitative Gains: Post-test evaluations revealed a 14% increase in overall understanding, with average task completion accuracy rising from 65% to 79%.
- Skill Acquisition: Participants successfully demonstrated the ability to create functional assessment tables utilizing
Data Validationfor error-free input and complexIFformulas for automated grading. - Qualitative Feedback: Teachers expressed strong enthusiasm, often staying after sessions to discuss further applications and requesting future training on other productivity tools.
Limitations and Sustainability
While the initial results are promising, the authors note that a one-day workshop is insufficient for deep mastery. Future iterations should adopt a longitudinal approach to ensure long-term skill retention. Additionally, there is a clear demand for expanded training covering data visualization and other suites like Google Sheets. To ensure sustainability, a "post-training monitoring" phase is recommended to audit school workflows and ensure that the newly acquired skills are being integrated into daily operations.
Summary updated