Penerapan visual basic for application spreadsheet excel untuk simulasi konsep motor listrik tiga fasa dan aplikasinya sebagai media pembelajaran
DOI:
https://doi.org/10.12928/jrkpf.v7i2.17972Abstract
Abstrak. Penelitian ini merupakan studi yang bertujuan untuk: (1) membuat simulasi motor listrik tiga fasa dengan menggunakan Spreadsheet Excel; (2) mengetahui aplikasi Spreadsheet Excel pada media pembelajaran. Penelitian ini menggunakan VBA Spreadsheet Excel 2013 yang terdapat pada laptop. Semua tahapan penelitian dilakukan sepenuhnya di Laboratorium Komputer Pendidikan Fisika. Data hasil, terdapat beberapa hal yang menjadi catatan penting: (1) simulasi yang telah dibuat menggunakan Visual Basic for Application Spreadsheet Excel dapat menyesuaikan dengan keadaan nyata yang terjadi pada simulasi motor listrik tiga fasa dengan mengubah data parameter dan fungsi yang diasumsikan sesuai dengan keadaan yang sebenarnya, serta Macro VBA Excel sangat berguna untuk memberi tombol perintah pada cell yang datanya ingin kita ubah, sehingga dapat memberi kesan visual pada grafik yang telah dibuat; (2) berdasarkan hasil uji simulasi dapat dikatakan bahwa pembuatan simulasi motor listrik tiga fasa sebagai media pembelajaran dengan menggunakan fitur spreadsheets dan macro VBA dalam Ms. Excel dapat digunakan untuk mensimulasikan sebuah kasus yang berkaitan dengan motor listrik tiga fasa yang diberi arus akan timbul medan magnet yang dapat memutar rotor dan dapat menganalisis perubahan posisi setiap fasa pada motor listrik tiga fasa.
Kata kunci: Media pembelajaran, VBA for spreadsheet excel, simulasi motor listik tiga fasa
Abstract. This research is a study that aims to: (1) simulate a three-phase electric motor using an Excel spreadsheet; (2) knowing the Excel Spreadsheet application on learning media. This study uses the VBA Excel 2013 Spreadsheet found on a laptop. All stages of research are carried out entirely in the Physics Education Computer Laboratory. The result data, several things are important notes: (1) simulations that have been made using the Visual Basic for Application Excel Spreadsheet can adjust to the real situation that occurs in the simulation of a three-phase electric motor by changing the parameter data and assumed functions according to the circumstances actually, as well as Excel VBA Macros are very useful for giving command buttons to cells whose data we want to change, so that it can give a visual impression to the graph that has been created; (2) based on the simulation test results it can be said that the manufacture of a three-phase electric motor simulation as a learning medium using the spreadsheets and macro VBA features in Ms. Excel can be used to simulate a case related to a three-phase electric motor that is given a current, a magnetic field will arise that can rotate the rotor and can analyze changes in the position of each phase in a three-phase electric motor.
Keywords: learning media, VBA for excel spreadsheet, three phase electric motor simulation
References
Arsyad, Azhar. 2016. Media Pembelajaran. Jakarta: PT Raja Grafindo Persada.
Hartanto, Fendi, Dwi. 2014. Pengembangan Media Pembelajaran Berbasis Software Simulasi pada Pokok Bahasan Pernapasan Manusia Kelas V Ilyas Madrasah Ibtidayah Perwanida Kota Blitar. Malang: Universitas Islam Negri Maulana Malik Ibrahim.
Hadidjaja Dwi, Onny Setyawati dan Didik Rahadi Santoso. 2015. Analisis Pengaturan Putaran Motor Satu Fasa dengan Parameter Frekuensi Menggunakan Power Simulator (PSIM). Jurnal EECCIS Vol. 9, No. 2.
Ita Sita Masita, dkk. 2020. Penggunaan Phet Simulation Dalam Meningkatan Pemahaman Konsep Fisika Peserta Didik. JPPF, Vol. 5 No. 2 April 2020, 136-141.
Zainudin. 2016. Pengembangan Simulasi Fisika Gelombang Elektromagnetik Menggunakan Easy Java Simulastions (EJS). Jurnal Pena Sains Vol. 3, No. 2.
Rahmat, Fahinu, Alfat, S., & Maryanti, E. (2019, October). The Effect of STAD cooperative model by GeoGebra assisted on increasing students’ geometry reasoning ability based on levels of mathematics learning motivation. In Journal of Physics: Conference Series (Vol. 1315, No. 1, p. 012028). IOP Publishing.
Nurhayati. 2015. Penggunaan Media Animasi Berbasis Visual Basic (VBA) Spreadsheet Excel Untuk Meningkatkan Penguasaan Konsep Mahasiswa Pada Materi Potensial Osilator Harmonik Sederhana. Jurnal Edukasi Matematika dan Sains, Vol.3 No.1.
Yamani, Ahmad dan Abdel Wahab Kharab. 2001. Use of a Spreadsheet Program in Electromagnetics. IEEE Transactons On Education, Vol. 44. No. 3.
Pandiangan, Paken & Arkundato. 2012. Desain Model Eksperimen Virtual Fisika Berbasis Visual Basic Application. Batam: Universitas Terbuka.
Siswoyo. 2008. Teknik Listrik Industri. Jakarta: Direktorat Pembinaan Sekolah Menengah Kejuruan.
Sulistiyani, Putri & Pujayanto. 2015. Media Pembelajaran Menggunakan Spreadsheet Excel Untuk Materi Osilasi Harmonik Teredam. Surakarta: Universitas Sebelas Maret. ISSN: 2302-7827.
Risolawati, Ani. 2006. Profil Kesulitan Belajar Fisika Pokok Bahasan Kelistrikan Siswa SMA di Kota Semarang. JPFI Vol. 4, No 2.
Islami Diana. 2018. Analisis Miskonsepsi Siswa Pada Mata Pelajaran IPA Materi Listrik Statis Menggunakan Four Tier Test. Science Education National Conference.
Soewarno, Hasmiana, Faiza. 2016. Kendala-kendala yang Dihadapi Guru dalam Memanfaatkan Media Berbasis Komputer di SD Negeri 10 Banda Aceh. Jurnal Pesona Dasar Vol. 2 No.4.
Supardi U.S, dkk. 2012. Pengaruh Media Pembelajaran dan Minat Belajar Terhadap Hasil Belajar Fisika. Jurnal Formatif 2(1) ISSN: 2088-351X.
Purba, Jeremia. 2009. Simulasi Pengaturan Kecepatan Motor Induksi Tiga Phasa Dengan Direct Torque Control Dengan Menggunakan Matlab 7.0.1. Medan: Universitas Sumatra Utara.
Downloads
Published
Issue
Section
License
COPYRIGHT TRANSFER FORM
The copyright to this article is transferred to Universitas Ahmad Dahlan (UAD) if and when the article is accepted for publication. The undersigned hereby transfers any and all rights in and to the paper including without limitation all copyrights to UAD. The undersigned hereby represents and warrants that the paper is original and that he/she is the author of the paper, except for material that is clearly identified as to its original source, with permission notices from the copyright owners where required. The undersigned represents that he/she has the power and authority to make and execute this assignment.
We declare that:
- This paper has not been published in the same form elsewhere.
- It will not be submitted anywhere else for publication prior to acceptance/rejection by this Journal.
- A copyright permission is obtained for materials published elsewhere and which require this permission for reproduction.
Furthermore, I/We hereby transfer the unlimited rights of publication of the above mentioned paper in whole to UAD. The copyright transfer covers the exclusive right to reproduce and distribute the article, including reprints, translations, photographic reproductions, micro form, electronic form (offline, online) or any other reproductions of similar nature.
The corresponding author signs for and accepts responsibility for releasing this material on behalf of any and all co-authors. This agreement is to be signed by at least one of the authors who have obtained the assent of the co-author(s) where applicable. After submission of this agreement signed by the corresponding author, changes of authorship or in the order of the authors listed will not be accepted.
Retained Rights/Terms and Conditions
- Authors retain all proprietary rights in any process, procedure, or article of manufacture described in the Work.
- Authors may reproduce or authorize others to reproduce the Work or derivative works for the authors personal use or for company use, provided that the source and the UAD copyright notice are indicated, the copies are not used in any way that implies UAD endorsement of a product or service of any employer, and the copies themselves are not offered for sale.
- Although authors are permitted to re-use all or portions of the Work in other works, this does not include granting third-party requests for reprinting, republishing, or other types of re-use.
