Kasyfi Rifqi Mouromadhoni, Heru Kuswanto





This study examines the visualization of the creation and operation of lissajous waves on the oscilloscope screen using a spreadsheet on Microsoft Excel 2013. The purpose of this research is to produce a visualization and how to operate lissajous waves using Microsoft Excel. The subject of this research is a spreadsheet program on Microsoft Excel software. Research location in the Yogyakarta State University Postgraduate Program building. The results of the study are expected to produce a visualization of how and how to operate a lissajous wave using Microsoft Excel. The data used uses fixed amplitude, frequency ratio 1:1 (a=1, b=1) with different phases at special angles ie 0o, 30o, 60o dan 90o. As well as other data with different frequency comparisons but using fixed amlitudes and phase differences of 90o. Comparison of frequency, amplitude and phase difference has the main role in forming lissajous wave patterns. It can be concluded that the speadsheets program on Microsoft Excel 2013 can be used to create simulations and describe lissajous wave patterns on oscilloscope screens in physics learning. Through simulation of lissajous wave patterns using spreadsheets on Microsoft Excel can make it easier for students and teachers to understand the lissajous curve on the oscilloscope screen.


Penelitian ini mengkaji tentang visualisasi pembuatan dan pengoperasian gelombang lissajous pada layar osiloskop menggunakan spreadsheet pada microsoft excel 2013. Tujuan penelitian menghasilkan visualisasi dan cara pegoperasian gelombang lissajous menggunakan microsoft excel. Subjek penelitian ini adalah program spreadsheet pada software microsoft exel. Lokasi penelitian di gedung Program Pascasarjana Universitas Negeri Yogyakarta. Hasil penelitian diharapkan dapat menghasilkan visualisasi pembuatan dan cara pegoperasian gelombang lissajous menggunakan microsoft excel. Data yang digunakan menggunakan amplitudo tetap, perbandingan frekuensi 1:1 (a=1, b=1) dengan beda fase pada sudut istimewa yaitu 0o, 30o, 60o dan 90o. Serta data lain dengan perbandingan frekuensi yang berbeda namun menggunakan amlitudo tetap dan beda fase sebesar 90o. Perbandingan frekuensi, amplitudo dan beda fase memiliki peran utama dalam pembentukkan pola gelombang lissajous. Dapat disimpulkan bahwa program speadsheets pada miscrosoft excel 2013 dapat digunakan untuk membuat simulasi dan menggambarkan pola gelombang lissajous pada layar osiloskop dalam pembelajaran fisika. Melalui simulasi pola gelombang lissajous menggunakan spreadsheets pada microsoft excel dapat memudahkan siswa maupun guru dalam memahami kurva lissajous pada layar osiloskop.



Spreadsheets, Microsoft Excel, Kurva Lissajous, Osiloskop, Pembelajaran Fisika

Full Text:



Abramovich, S., Nikitina, G. V, & Romanenko, V. N. (2010). Spreadsheets and the development of skills in the STEM disciplines. Spreadsheets in Education (eJSiE), 3(3), 1-23.

Al-khazali, H. A. H., & Askari, M. R. (2012). Geometrical and Graphical Representations Analysis of Lissajous Figures in Rotor Dynamic System. IOSR Journal of Engineering, 2(5), 971–978.

Benacka, J. (2008). Spreadsheet numerical modelling in secondary school physics and biology. Spreadsheets in Education (eJSiE), 2(3), 289-298.

Blas, T. M. & Fernandez, A. S. (2009). The role of new technologies in the learning process: Moodle as a teaching toolin Physics. Computers & Education, 52 (2), 35-44.

Bryan, J. (2006). Technology for physics instruction. Contemporary Issues in Technology and

Teacher Education, 6 (2), 230-245.

Chattopdhyay, D. (1989). Fisika Universitas. Bandung : Graha Cipta.

Chambers, C., & Scaffidi, C. (2010). Struggling to Excel: A Field Study of Challenges Faced by Spreadsheet Users. IEEE Symposium on Visual Languages and Human-Centric Computing. 187-194.

Chen, B., Wei, L., & Li, H. (2016). Teaching complicated conceptual knowledge with simulation videos

in foundational electrical engineering courses. Journal of Technology and Science Education, 6(3), 148-165.

Christie, D. S. (2018). Build your own Monte Carlo spreadsheet Build your own Monte Carlo spreadsheet. Spreadsheets in Education (eJSiE), 11(1), 1-16.

Demir, S. (2018). Excel VBA-Based Solution to Pipe Flow Measurement Problem Excel VBA-Based Solution to Pipe Flow Measurement Problem. Spreadsheets in Education (eJSiE), 10(3), 1-14.

Fellah, G. (2019). Excel Spreadsheet as a Tool for Simulating the Performance of Steam Power Plants. Spreadsheets in Education (eJSiE), 12(1), 1–19.

Gökalp, M. S. (2018). Multidimensional Perceptions of Physics. International Journal of Innovation in Science and Mathematics Education, 26(1), 27–45.

Guido, R. M. D. (2013). Attitude and Motivation towards Learning Physics. International Journal of Engineering Research & Technology (IJERT), 2(11), 2087-2094.

Himawan & Kuswanto. (2018). Spreadsheet for Physics: Lissajous Curve. International Journal of Current Research, 9(5), 26942-26948.

Jahnke, I., & Liebscher, J. (2020). Three Types of Integrated Course Designs for Using Mobile Technologies to Support Creativity in Higher Education. Computers & Education, 103782.

Kharisma, W. A., & Utama, J. (2013). Portable Digital Oscilloscope Menggunakan PIC18F4550 Portable Digital Oscilloscope Based on PIC18F4550, Telekontran, 1(2), 39-49.

King, G. C. (2009). Vibration and Waves. United Kingdom: John Wiley & Sons Ltd.

Lazzaro, C. (2015). On the Consideration of Adoption and Implementation of The Next Generation Science Standards in a Local Control Context: Supporting the Epistemology of Science Through Education Policy. United States: Columbia University.

Ogunsola, L. A. (2005). Information and Communication Technologies and the Effects of Globalization: TwentyFirst Century "Digital Slavery" for Developing CountriesMyth or Reality?. Electronic Journal of Academic and Special Librarianship. 6(2), 107–138.

Oliveira, M. (2012). Fourier Analysis : Graphical Animation and Analysis of Experimental Data with Excel Fourier Analysis : Graphical Animation and Analysis of Experimental Data. Spreadsheets in Education (eJSiE), 5(2), 1-18.

Pain. (2005). The Physics of Vibrations and Waves 6th Edition. England: John Wiley & Sons Ltd.

Raja, R., & Nagasubramani, P. C. (2018). Impact of modern technology in education. Journal of Applied and Advanced Research (JAAR), 3(1), 33–35.

Robinson, G., & Jovanoski, Z. (2011). The use of Microsoft excel to illustrate wave motion and fraunhofer diffraction in first year physics courses. Spreadsheets in Education (eJSiE), 4(3), 1-21.

Sahin, D., & Yilmaz, R. M. (2019). The effect of Augmented Reality Technology on middle school students’ achievements and attitudes towards science education. Computers & Education, 103710.

Seery, N., Canty, D., & Gumaelius, L. (2018). Visualization , inductive reasoning , and memory span as components of fl uid intelligence : Implications for technology education. International Journal of Educational Research, 90(May), 64–77.

Serway & Jewett. (2014). Physics for Scientists and Engineers with Modern Physics 6th Edition. USA: Lachina Publishing Services.

Shabrina & Kuswanto, H. (2018). Spreadsheet for Quantum Physics: Quantization of Particle Energy in One Dimensional Box. International Journal of Current Research, 10(3), 66393-66399.

Stanford & Tanner. (1985). Physics for Students of Science and Engineering. Florida: Academic Inc.

Stosic. (2015). The Importance of Educational Technology in Teaching. International Journal of Cognitive Research in Science, Engineering and Education (IJCRSEE), 3(1), 111–114.

Wagner, J. E. (2007). Using Spreadsheets to Assess Learning. The Physics Teacher, 45(1), 34–37.

DOI: Abstract - 0 PDF - 0


  • There are currently no refbacks.

@ EDUSAINS.  P-ISSN:1979-7281;E-ISSN:2443-1281

This is an open access article under CC-BY-SA license


Web Analytics Made Easy - StatCounter View My Stats