Pengembangan Matriks Penilaian Program Sarjana Sembilan Standar Berbasis Excel dan Visual Basic for Application (VBA)
DOI:
https://doi.org/10.24090/insania.v26i2.5982Keywords:
development, Visual Basic for Application (VBA), Excel matrix IAPS, study program accreditation, nine-standards formAbstract
This research develops a Microsoft Excel application based on the Visual Basic for Application (VBA) Assessment Matrix of 9 Standard Bachelor Programs with product advantages. They are a matrix display with simpler sentences, accreditation assessment, a dashboard of assessment results, and an information system following LKPS to facilitate the manufacture of LEDs based on Quadrant Evaluation. The 4-D development design method is carried out through 4 stages: define, design, develop, and dissemination. The defined stage includes an analysis of the needs of study program managers facing accreditation, an assessment matrix of 9 standard study programs, and dashboard analysis. The design stage includes the selection of the calculation format, dashboard format, and the initial design of the Excel program (prototype I). The development stage is the validation of the initial product design, with the results of the assessment of the content aspect being 4,6250 valid criteria, displaying 4,3750 valid criteria and 4,1250 valid criteria for programmers (prototype II). Limited trials were carried out on all members of SPMI UNUGHA. Each item scored more than or equal to 3.75, with an average of 4.3276, which means it is feasible with a very good rating. (prototype III). The first year the field trial was conducted at the Nahdlatul Ulama University Mathematics Study Program, Purwokerto. Each item scored more than or equal to 3.75, with an average of 4.1354, which means it is feasible with a very good rating. (prototype IV). The dissemination stage (prototype 4) is carried out in two forms: scientific publications in SINTA accredited national journals (INSANIA: Journal of Alternative Educational Thought) and intellectual works: Microsoft Excel applications based on Visual Basic for Application (VBA) Undergraduate Program Assessment Matrix 9 Standards. (Final project).Downloads
Download data is not yet available.
References
Andriyani, D., Harahap, E., Badruzzaman, F. H., Fajar, M. Y., & Darmawan, D. (2019). Aplikasi Microsoft Excel Dalam Penyelesaian Masalah Rata-rata Data Berkelompok. Matematika Jurnal Teori Dan Terapan Matematika, 18(1), 41–46. https://doi.org/10.29313/jmtm.v18i1.5078
Astuti, I. A. D., & Bhakti, Y. B. (2018). Interactive Learning Multimedia Based Microsoft Excel on the Temperature and Heat. Unnes Science Education Journal, 7(1), 1–6. https://doi.org/10.15294/usej.v7i1.21355
Budiyono. (2003). Metodologi Penelitian Pendidikan. UNS Press.
Budiyono. (2009). Statistika Untuk Penelitian. UNS Press.
Budiyono. (2011). Penilaian Hasil Belajar. UNS Press.
Fatmawati, N. L. (2021). Pengembangan Video Animasi Powtoon sebagai Media Pembelajaran Bahasa Inggris Usia Sekolah Dasar di Masa Pandemi. INSANIA : Jurnal Pemikiran Alternatif Kependidikan, 26(1), 65–77. https://doi.org/10.24090/insania.v26i1.4834
Hakim, A. L. (2019). Pengembangan Matriks antar Standar Nasional Pendidikan Tinggi, Akreditasi Perguruan Tinggi dan Akreditasi Program Studi. Jurnal Ilmiah Kesehatan, 18(2), 42–48. https://doi.org/10.33221/jikes.v18i2.219
Harmastuti, & Setyowati, D. (2018). Pemanfaatan Microsoft Excel untuk Pembelajaran Matematika dan Grafik. Jurnal Dharma Bakti, 1(1), 57–66. https://doi.org/10.34151/dharma.v1i1.294
Hasana, S. N., & Maharany, E. R. (2017). Pengembangan Multimedia Menggunakan Visual Basic For Aplication (VBA) untuk meningkatkan Profesionalisme Guru Matematika. Jurnal Pendidikan Matematika, 3(2), 30–40.
Kardoyo, & Nurkhin, A. (2016). Analisis Kepuasan Pelayanan Perguruan Tinggi (Kasus pada Prodi Magister Pendidikan Ekonomi Unnes). Cakrawala Pendidikan, XXXV(2), 164–175. https://doi.org/10.21831/cp.v15i2.9881
Marjuki, Mardapi, D., & Kartowagiran, B. (2018). Pengembangan Model Akreditasi Sekolah Menengah Atas/Madrasah Aliyah (SMA/MA). Jurnal Penelitian Dan Evaluasi Pendidikan, 22(1), 105–117. https://doi.org/10.21831/pep.v22i1.9860
Pane, I. Z. (2015). Pemanfaatan Microsoft Excel Sebagai Perangkat Pengembangan Prototipe Piranti Lunak Visual. Ultima InfoSys : Jurnal Ilmu Sistem Informasi, 6(1), 20–26. https://doi.org/10.31937/si.v6i1.275
Peraturan Badan Akreditasi Nasional Perguruan Tinggi Nomor 2 Tahun 2020 Tentang Instrumen Suplemen Konversi, Pub. L. No. 2 (2020).
Peraturan Badan Akreditasi Nasional Perguruan Tinggi Nomor 4 Tahun 2019 Tentang Pengajuan Permohonan Akreditasi Program Studi dan Perguruan Tinggi, Pub. L. No. 4 (2019).
Peraturan Badan Akreditasi Nasional Perguruan Tinggi Nomor 5 Tahun 2019 Tentang Instrumen Akreditasi Program Studi, Pub. L. No. 5 (2019).
Raditya, A. A., Kartono, & Raharjana, I. K. (2016). Sistem Dashboard untuk Persiapan Akreditasi Program Studi Sarjana Berdasarkan Standar BAN-PT. Jurnal Sistem Informasi, 8(1), 871–882. https://doi.org/10.36706/jsi.v8i1.2956
Raharjo, S. B. (2012). Evaluasi Trend Kualitas Pendidikan di Indonesia. Jurnal Penelitian dan Evaluasi Pendidikan, 16(2), 511–532. https://doi.org/10.21831/pep.v16i2.1129
Santika, S., Nugraha, D. A., & Solihat, A. N. (2019). Efektivitas Penggunaan Lembar Kerja Berbasis Masalah Dengan Bantuan Microsoft Excel Pada Mata Kuliah Program Komputer. Teorema: Teori dan Riset Matematika, 4(1), 23–30. http://dx.doi.org/10.25157/teorema.v4i1.1723
Saputro, F. C., Anggraeni, W., & Mukhlason, A. (2012). Pembuatan Dashboard Berbasis Web Sebagai Sarana Evaluasi Diri Berkala untuk Persiapan Penilaian Akreditasi Berdasarkan Standar Badan Akreditasi Nasional Perguruan Tinggi. Jurnal Teknik ITS, 1(1), 397–402. http://dx.doi.org/10.12962/j23373539.v1i1.1141
Sugiarti, Bahri, S., & Setiawati, D. (2018). Rancang Bangun Aplikasi Akreditasi Teknik Informatika Pada Studi Kasus Standar 7. Journal Informatic Technology And Communication, 2(3), 27–33. https://doi.org/10.36596/jitu.v2i3.41
Supit, J. W., Tulenan, V., & Sentinuwo, S. R. (2021). Rancang Bangun Simulasi Akreditasi Program Studi Berbasis Web. Jurnal Teknik Informatika, 15(3), 163–170.
Syaharuddin, Febriana, E., & Mandailina, V. (2021). Kombinasi Delphi XE8 dan Ms Acces Dalam Desain DASS. Jurnal Riset Teknologi Dan Inovasi Pendidikan, 1(2), 1–8.
Ulum, I. (2019). Intellectual Capital Framework Perguruan Tinggi di Indonesia Berdasarkan Instrumen Akreditasi Program Studi (IAPS) 4.0. Jurnal Reviu Akuntansi dan Keuangan, 9(3), 309–318. https://doi.org/10.22219/jrak.v9i3.10227
Astuti, I. A. D., & Bhakti, Y. B. (2018). Interactive Learning Multimedia Based Microsoft Excel on the Temperature and Heat. Unnes Science Education Journal, 7(1), 1–6. https://doi.org/10.15294/usej.v7i1.21355
Budiyono. (2003). Metodologi Penelitian Pendidikan. UNS Press.
Budiyono. (2009). Statistika Untuk Penelitian. UNS Press.
Budiyono. (2011). Penilaian Hasil Belajar. UNS Press.
Fatmawati, N. L. (2021). Pengembangan Video Animasi Powtoon sebagai Media Pembelajaran Bahasa Inggris Usia Sekolah Dasar di Masa Pandemi. INSANIA : Jurnal Pemikiran Alternatif Kependidikan, 26(1), 65–77. https://doi.org/10.24090/insania.v26i1.4834
Hakim, A. L. (2019). Pengembangan Matriks antar Standar Nasional Pendidikan Tinggi, Akreditasi Perguruan Tinggi dan Akreditasi Program Studi. Jurnal Ilmiah Kesehatan, 18(2), 42–48. https://doi.org/10.33221/jikes.v18i2.219
Harmastuti, & Setyowati, D. (2018). Pemanfaatan Microsoft Excel untuk Pembelajaran Matematika dan Grafik. Jurnal Dharma Bakti, 1(1), 57–66. https://doi.org/10.34151/dharma.v1i1.294
Hasana, S. N., & Maharany, E. R. (2017). Pengembangan Multimedia Menggunakan Visual Basic For Aplication (VBA) untuk meningkatkan Profesionalisme Guru Matematika. Jurnal Pendidikan Matematika, 3(2), 30–40.
Kardoyo, & Nurkhin, A. (2016). Analisis Kepuasan Pelayanan Perguruan Tinggi (Kasus pada Prodi Magister Pendidikan Ekonomi Unnes). Cakrawala Pendidikan, XXXV(2), 164–175. https://doi.org/10.21831/cp.v15i2.9881
Marjuki, Mardapi, D., & Kartowagiran, B. (2018). Pengembangan Model Akreditasi Sekolah Menengah Atas/Madrasah Aliyah (SMA/MA). Jurnal Penelitian Dan Evaluasi Pendidikan, 22(1), 105–117. https://doi.org/10.21831/pep.v22i1.9860
Pane, I. Z. (2015). Pemanfaatan Microsoft Excel Sebagai Perangkat Pengembangan Prototipe Piranti Lunak Visual. Ultima InfoSys : Jurnal Ilmu Sistem Informasi, 6(1), 20–26. https://doi.org/10.31937/si.v6i1.275
Peraturan Badan Akreditasi Nasional Perguruan Tinggi Nomor 2 Tahun 2020 Tentang Instrumen Suplemen Konversi, Pub. L. No. 2 (2020).
Peraturan Badan Akreditasi Nasional Perguruan Tinggi Nomor 4 Tahun 2019 Tentang Pengajuan Permohonan Akreditasi Program Studi dan Perguruan Tinggi, Pub. L. No. 4 (2019).
Peraturan Badan Akreditasi Nasional Perguruan Tinggi Nomor 5 Tahun 2019 Tentang Instrumen Akreditasi Program Studi, Pub. L. No. 5 (2019).
Raditya, A. A., Kartono, & Raharjana, I. K. (2016). Sistem Dashboard untuk Persiapan Akreditasi Program Studi Sarjana Berdasarkan Standar BAN-PT. Jurnal Sistem Informasi, 8(1), 871–882. https://doi.org/10.36706/jsi.v8i1.2956
Raharjo, S. B. (2012). Evaluasi Trend Kualitas Pendidikan di Indonesia. Jurnal Penelitian dan Evaluasi Pendidikan, 16(2), 511–532. https://doi.org/10.21831/pep.v16i2.1129
Santika, S., Nugraha, D. A., & Solihat, A. N. (2019). Efektivitas Penggunaan Lembar Kerja Berbasis Masalah Dengan Bantuan Microsoft Excel Pada Mata Kuliah Program Komputer. Teorema: Teori dan Riset Matematika, 4(1), 23–30. http://dx.doi.org/10.25157/teorema.v4i1.1723
Saputro, F. C., Anggraeni, W., & Mukhlason, A. (2012). Pembuatan Dashboard Berbasis Web Sebagai Sarana Evaluasi Diri Berkala untuk Persiapan Penilaian Akreditasi Berdasarkan Standar Badan Akreditasi Nasional Perguruan Tinggi. Jurnal Teknik ITS, 1(1), 397–402. http://dx.doi.org/10.12962/j23373539.v1i1.1141
Sugiarti, Bahri, S., & Setiawati, D. (2018). Rancang Bangun Aplikasi Akreditasi Teknik Informatika Pada Studi Kasus Standar 7. Journal Informatic Technology And Communication, 2(3), 27–33. https://doi.org/10.36596/jitu.v2i3.41
Supit, J. W., Tulenan, V., & Sentinuwo, S. R. (2021). Rancang Bangun Simulasi Akreditasi Program Studi Berbasis Web. Jurnal Teknik Informatika, 15(3), 163–170.
Syaharuddin, Febriana, E., & Mandailina, V. (2021). Kombinasi Delphi XE8 dan Ms Acces Dalam Desain DASS. Jurnal Riset Teknologi Dan Inovasi Pendidikan, 1(2), 1–8.
Ulum, I. (2019). Intellectual Capital Framework Perguruan Tinggi di Indonesia Berdasarkan Instrumen Akreditasi Program Studi (IAPS) 4.0. Jurnal Reviu Akuntansi dan Keuangan, 9(3), 309–318. https://doi.org/10.22219/jrak.v9i3.10227
Downloads
Published
2021-12-31
How to Cite
Fadjrin, N. N., & Agustin, N. (2021). Pengembangan Matriks Penilaian Program Sarjana Sembilan Standar Berbasis Excel dan Visual Basic for Application (VBA). INSANIA : Jurnal Pemikiran Alternatif Kependidikan, 26(2), 322–334. https://doi.org/10.24090/insania.v26i2.5982
Issue
Section
Articles
License
Authors who publish with this journal agree to the following terms:
Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative CommonsAttribution-ShareAlike License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
