Analysis of the Islamic Religious Education Achievement Test Instrument Using Microsoft Office Excel 2019 : Spearman-Brown Reliability Test

Authors

  • Atabik Atabik Universitas Islam Negeri Prof. K. H. Saifuddin Zuhri Purwokerto
  • Khafifatul Fian Universitas Islam Negeri Prof. K. H. Saifuddin Zuhri Purwokerto

DOI:

https://doi.org/10.61806/al-tatawur.v3i3.66

Keywords:

Instruments, Microsoft Office Excel 2019, Quantitative Research, Reliability Test, Spearman-Brown

Abstract

In quantitative research, there is often a biased study because it does not understand the steps or testing that must be passed. One of the tests that researchers must go through to conduct quantitative research is the instrument reliability test. The purpose of this paper is to analyze the types of reliability tests that the author then tested on the data that the author compiled using the  2019 version of Microsoft Office Excel. The type of research used is library research through data collection techniques by searching for sources either from articles, books, or other sources relevant to the topic of discussion. After the data is collected, it is then selected, and analyzed based on content or content, then draw conclusions. The results showed that the reliability test aims to find out how fixed the respondents' answers to an instrument even though it is done several times. There are several choices of techniques used to conduct reliability tests, including external or internal reliability. Researchers can choose the type of reliability test technique according to their abilities and needs. In addition, the use of Microsoft Office Excel 2019 as a tool in conducting the Spearman-Brown reliability test demonstrates that statistical analysis in educational research can be performed using software that is accessible and widely used. Excel, with its built-in functions and add-ins, allows researchers—especially beginners—to conduct basic reliability tests without requiring more complex statistical software.

References

Abduloh, et al. (2022). Peningkatan dan pengembangan prestasi belajar peserta didik. Ponorogo: Uwais Inspirasi Indonesia.

Amiruddin, Z. (2010). Statistika pendidikan. Yogyakarta: Teras.

Amruddin, et al. (2022). Metode penelitian kuantitatif kualitatif. Jawa Barat: Media Sains Indonesia.

Asfiati. (2020). Visualisasi dan virtualisasi pembelajaran pendidikan agama Islam. Jakarta: Kencana.

Chaerunisa, Z., & Latief, J. (2021). Pengaruh disiplin belajar terhadap prestasi belajar IPS di sekolah dasar. Edukatif: Jurnal Ilmu Pendidikan, 3(5), 2952-2960. https://doi.org/10.31004/edukatif.v3i5.1043

Hanafi, H. (2018). Ilmu pendidikan Islam. Yogyakarta: Deepublish.

Harefa, D. (2020). Peningkatan prestasi belajar IPA siswa pada model pembelajaran learning cycle dengan materi energi dan perubahannya. Trapsila: Jurnal Pendidikan Dasar, 2(1), 25-36. https://doi.org/10.30742/tpd.v2i01.882

Hidayat, A. A. (2021). Menyusun instrumen penelitian & uji validitas-reliabilitas. Surabaya: Health Books Publishing.

Indriyaningrum, K., et al. (2022). Pelatihan metodologi penelitian kuantitatif bagi guru-guru SMK Bhina Tunas Bhakti, Juwana-Pati. Jurnal Penamas, 6(2), 143-148.

Jaya, I. M. L. M. (2020). Metode penelitian kuantitatif dan kualitatif: Teori, penerapan, dan riset nyata. Yogyakarta: Anak Hebat Indonesia.

Kurniawan, H. (2021). Pengantar praktis penyusunan instrumen penelitian. Yogyakarta: Deepublish.

Marisa, S. (2022). Reliabilitas konstruk multidimensional pada structural equation modeling (SEM). Akrab Juara: Jurnal Ilmu-ilmu Sosial, 7(1), 361-368. https://doi.org/10.58487/akrabjuara.v7i1.1783

Misri, A. (2019). Perjuangan muslim di negara konflik. Banda Aceh: Ar-Raniry Press.

Mufidah, A. (2021). Analisis validitas dan reliabilitas instrumen pengukuran mengenal bentuk-bentuk geometri. Jurnal Kualita Pendidikan, 2(3), 192-296. https://doi.org/10.51651/jkp.v2i3.144

Mulyasana, D., et al. (2020). Khazanah pemikiran pendidikan Islam dari wacana lokal hingga tatanan global. Bandung: CV Cendekia Press.

Munte, S., & Polewangi, Y. D. (2022). Pengaruh harga, variasi produk dan kualitas produk terhadap keputusan pembelian keripik singkong saat pandemi COVID-19 di UKM Cap Rumah Adat Minang Medan. Jurnal Ilmiah Teknik Mesin dan Industri, 1(1), 53-68. https://doi.org/10.31289/jitmi.v1i1.1222

Nugroho, U. (2018). Metodologi penelitian kuantitatif pendidikan jasmani. Jawa Tengah: CV. Sarnu Untung.

Pasaribu, E. Z., et al. (2020). Belajar statistika siapa takut dengan SPSS. Indonesia: Yayasan Kita Menulis.

Pramdhan, K., et al. (2021). Pengaruh latihan menggunakan media karet ban dan skipping terhadap hasil long pass sepakbola. Journal of Physical and Outdoor Education, 3(1), 94-100. https://doi.org/10.37742/jpoe.v3i1.122

Riyanto, S., & Hatmawan, A. A. (2020). Metode riset penelitian kuantitatif penelitian di bidang manajemen, teknik, pendidikan, dan eksperimen. Yogyakarta: Deepublish.

Rosita, E., et al. (2021). Uji validitas dan reliabilitas kuesioner perilaku prososial. FOKUS (Kajian Bimbingan & Konseling dalam Pendidikan), 4(4). https://doi.org/10.22460/fokus.v4i4.7413

Rosyid, M. Z., et al. (2019). Prestasi belajar. Malang: Literasi Nusantara Abadi.

Salekha, R. D., et al. (2021). Studi komparasi pembelajaran kelas V SD N Sojomerto 01 Kabupaten Batang-Indonesia dan Feu Roosevelt College Inc Marikina Metro Manila-Filipina. Praniti, I(2), 87-91.

Setiarini, N. I. (2021). Muslim minoritas dan budaya Muslim Melayu masyarakat Pattani Thailand Selatan. Jurnal Penelitian Agama, 22(1), 127-137.

Sugiyono. (2016). Metode penelitian kuantitatif, kualitatif, dan R&D. Bandung: Alfabeta.

Sukesi, K., et al. (2017). Migrasi perempuan, remitansi dan perubahan sosial ekonomi pedesaan. Malang: UB Press.

Susanto, P. H. N., et al. (2022). Metodologi penelitian kebidanan. Sumatera Barat: PT. Global Eksekutif Teknologi.

Syakir, M., et al. (2021). Pengaruh stres kerja, komunikasi kerja dan kepuasan kerja terhadap prestasi kerja karyawan pada PT. Prima Karya Manunggal Kabupaten Pangkep. Amkop Management Accounting Review, 2(1), 20-27. https://doi.org/10.37531/amar.v2i1.141

Tugiman, et al. (2022). Uji validitas dan reliabilitas kuesioner model UTAUT untuk evaluasi sistem pendaftaran online rumah sakit. JATISI (Jurnal Teknik Informatika dan Sistem Informasi), 9(2), 1621-1630. https://doi.org/10.35957/jatisi.v9i2.2227

Ulfah, A. K. (2022). Ragam analisis data penelitian (sastra, riset, dan pengembangan). Madura: IAIN Madura Press.

Veronica, A., et al. (2022). Metodologi penelitian kuantitatif. Sumatera Barat: PT. Global Eksekutif Teknologi.

Yuliani, & Purwanto, E. (2022). Pendidikan Islam di Thailand. Educational Journal: General and Specific Research, 2(1), 51-61.

Yusup, F. (2018). Uji validitas dan reliabilitas instrumen penelitian kuantitatif. Jurnal Tarbiyah: Jurnal Ilmiah Kependidikan, 7(1), 17-23. https://doi.org/10.18592/tarbiyah.v7i1.2100

Downloads

Published

2025-08-27

How to Cite

Atabik Atabik, & Khafifatul Fian. (2025). Analysis of the Islamic Religious Education Achievement Test Instrument Using Microsoft Office Excel 2019 : Spearman-Brown Reliability Test. Al-Tatawur: International Journal of Social Science, 3(3), 49–56. https://doi.org/10.61806/al-tatawur.v3i3.66

Similar Articles

1 2 3 > >> 

You may also start an advanced similarity search for this article.