EFEKTIVITAS PELATIHAN OTOMATISASI NILAI RAPOR BERBASIS MICROSOFT EXCEL: STUDI KASUS DI SEKOLAH DIGANTA PELITA DEPOK

Abstract

Information technology training for teachers has become an urgent need along with the increasing complexity of academic administration, particularly in schools that are still establishing their work systems. Newly established inclusive schools face dual challenges: limited human resources and the absence of standardized procedures in academic data management, including report card processing. However, research specifically examining the effectiveness of Microsoft Excel-based report card automation training in the context of new schools using an in-depth case study approach remains limited. This study aims to fill this gap by analyzing the effectiveness of Microsoft Excel-based report card automation training in improving teachers' administrative competence at a newly established inclusive school. The approach used is a mixed-method with a case study design involving three teachers as research subjects. Quantitative data were obtained through pre-test and post-test, while qualitative data were collected through in-depth interviews, participatory observation, and documentation. The results show an increase in the average teacher understanding score from 41.67% (pre-test) to 81.67% (post-test), with the highest improvement occurring in mastery of nested IF functions and VLOOKUP. Qualitatively, teachers reported a reduction in report card processing time from an average of 4 days to 1 day, as well as increased confidence in managing academic data. The novelty of this research lies in the development of a contextual training model that integrates intensive mentoring and digital report card templates tailored to the specific needs of new inclusive schools, as well as holistic impact measurement through a mixed-method approach. This study concludes that report card automation training is effective in improving teachers' administrative competence, especially in the context of new schools with limited resources. The practical implication of this research is the need for ongoing information technology training programs for teachers in new schools.

ABSTRAK

Pelatihan teknologi informasi bagi guru menjadi kebutuhan mendesak seiring dengan tuntutan administrasi akademik yang semakin kompleks, terutama di sekolah-sekolah yang masih membangun sistem kerja. Sekolah inklusi yang baru didirikan menghadapi tantangan ganda, yaitu keterbatasan sumber daya manusia dan belum adanya prosedur baku dalam pengolahan data akademik, termasuk nilai rapor. Namun, penelitian yang secara khusus mengkaji efektivitas pelatihan otomatisasi nilai rapor berbasis Microsoft Excel dalam konteks sekolah baru dengan pendekatan studi kasus mendalam, masih terbatas. Penelitian ini bertujuan mengisi kesenjangan tersebut dengan menganalisis efektivitas pelatihan otomatisasi nilai rapor berbasis Microsoft Excel dalam meningkatkan kompetensi administratif guru di sebuah sekolah inklusi yang baru didirikan. Pendekatan yang digunakan adalah mixed-method dengan desain studi kasus yang melibatkan tiga orang guru sebagai subjek penelitian. Data kuantitatif diperoleh melalui pre-test dan post-test, sedangkan data kualitatif dikumpulkan melalui wawancara mendalam, observasi partisipatif, dan dokumentasi. Hasil penelitian menunjukkan peningkatan rata-rata skor pemahaman guru dari 41,67% (pre-test) menjadi 81,67% (post-test), dengan peningkatan tertinggi terjadi pada penguasaan fungsi IF bertingkat dan VLOOKUP. Secara kualitatif, guru melaporkan pengurangan waktu pengolahan rapor dari rata-rata 4 hari menjadi 1 hari, serta peningkatan kepercayaan diri dalam mengelola data akademik. Kebaruan penelitian ini terletak pada pengembangan model pelatihan kontekstual yang mengintegrasikan pendampingan intensif dan template rapor digital yang disesuaikan dengan kebutuhan spesifik sekolah inklusi baru, serta pengukuran dampak secara holistik melalui pendekatan mixed-method. Penelitian ini menyimpulkan bahwa pelatihan otomatisasi nilai rapor efektif meningkatkan kompetensi administratif guru, terutama dalam konteks sekolah baru dengan sumber daya terbatas. Implikasi praktis dari penelitian ini adalah perlunya program pelatihan teknologi informasi yang berkelanjutan bagi guru di sekolah baru.