Visualization of non-linear continuous wave dispersion effects on fiber grating with spreadsheets in online learning


  • Sabarudiin Yogyakarta State University
  • E. Pratidhina Yogyakarta State University
  • H. Kuswanto Yogyakarta State University
  • S. Alkiram Yogyakarta State University



spreadsheet, dispersion, linear-nonlinear


Spreadsheet software is a practical and straightforward computing and graphics tool. The use of Spreadsheets can reduce the risk of practicum in class and can be used remotely. This research presents a simple way to build a physics simulation based on mathematical equations in spreadsheet software. The simulation aims to visualize the effect of non-linear continuous wave dispersion on fiber gratings. Simulations can visualize different modes. The mathematical equations in fiber optics for non-linear effects are quite complex. Visualization can assist students in interpreting mathematical equations and making connections between theoretical and experimental modeling.


L. K. Smetana and R. L. Bell, Computer simulations to support science instruction and learning: A critical review of the literature, International Journal of Science Education 34 (2012) 1337.

J. Gobert, et al., Examining the relationship between students’ epistemologies of models and conceptual learning in three science domains: Biology, Physics, & Chemistry, International Journal of Science Education 33 (2011) 653.

M. Develaki, Methodology and epistemology of computer simulations and implications for science education, Journal of Science Education and Technology 28 (2019) 353.

N. Chaamwe and L. Shumba, ICT integrated learning: Using spreadsheets as tools for e-learning, a case of Statistics in Microsoft Excel, International Journal of Information and Education Technology 6 (2016) 435.

I. Benning and D. D. Agyei, Effect of using spreadsheet in teaching quadratic functions on the performance of senior high school students (2016).

Y. Kim and J. Kim, Effect of data science education program using spreadsheet on improvement of elementary school computational thinking, Journal of The Korean Association of Information Education 21 (2017) 219.

M. I. González, Lens ray diagrams with a spreadsheet, Physics Education 53 (2018) 035016.

N. Nurhayati, Penggunaan Media Animasi Berbasis Visual Basic (Vba) Spreadsheet Excel Untuk Meningkatkan Penguasaan Konsep Mahasiswa Pada Materi Potensial Osilator Harmonik Sederhana, JEMS: Jurnal Edukasi Matematika dan Sains 3 (2015) 54.

J. Benacka, Projectile general motion in a vacuum and a spreadsheet

simulation, Physics Education 50 (2014) 58.

I. Singh, B. Kaur, and K. K. Khun, Simulating longitudinal vibrations of coupled oscillator using the fourth-order Runge– Kutta method by programming spreadsheet, European Journal of Physics 40 (2019) 045003.

P. A. Govind et al., Nonlinear fiber optics, Optics and Photonics, Academic Press, San Diego, California (2001).

N. M. Litchinitser, B. J. Eggleton, and D. B. Patterson, Fiber Bragg gratings for dispersion compensation in transmission: theoretical model and design criteria for nearly ideal pulse recompression, Journal of Lightwave Technology 15 (1997) 1303.

X. Huang, et al., Cancer cell imaging and photothermal therapy in the near-infrared region by using gold nanorods, Journal of the American Chemical Society 128 (2006) 2115.

T. F. Siahaan, S. Saktioto, and M. Edisar, Penentuan Gelombang Soliton Pada Fiber Bragg Grating Dengan Menggunakan Metode Step-Split, Ph.D. thesis, Riau University (2015).

S. Choi, et al., Conductive hierarchical hairy fibers for highlysensitive, stretchable, and water-resistant multimodal gesturedistinguishablesensor, VR applications, Advanced Functional Materials 29 (2019) 1905808.

A. Becker and H. Nguyen, Defects in an optical fiber, Wolfram Demonstrations Project (2016).




How to Cite

Sabarudiin, E. Pratidhina, H. Kuswanto, and S. Alkiram, “Visualization of non-linear continuous wave dispersion effects on fiber grating with spreadsheets in online learning”, Rev. Mex. Fis. E, vol. 21, no. 2 Jul-Dec, pp. 020203 1–, Jul. 2024.