Abu Yazid Raisal, Rosynanda Nur Fauziah, Heru Kuswanto


Teaching physics is sometimes difficult to convey without using props or visualizations. Simulations can help teachers create and demonstrate real conditions in front of the class. In this article, we describe the usage of spreadsheets in simulating Gibbs free energy in mixing polymer solutions. We have created an model for the simulation consisting of a main spreadsheet and several secondary spreadsheets. A spreadsheet was chosen to simulate Gibbs free energy because spreadsheets can perform numerical representations in tables. This simple simulation can be used when discussing the topic of polymer thermodynamics. Teachers can start by deriving mathematical equations and then show simulations to visualize the equations. Another option is for students to be asked to create their simulations after deriving a mathematical equation. Using simulation in learning can make learning more interactive and help students understand material physics subjects more easily. Spreadsheets can be an alternative for teachers when explaining abstract material to students. Furthermore, simulations with spreadsheets can also support physics learning remotely.


Simulation, Spreadsheet, Free energy

Full Text:



Azevedo, J., & Pedrosa, A. (2017). Using a spreadsheet to support e-assessment. Proceedings of the European Conference on E-Learning, ECEL, 1, 39–47.

Barros, L. A., Custodio, R., & Rath, S. (2016). Design of a new molecularly imprinted polymer selective for hydrochlorothiazide based on theoretical predictions using Gibbs free energy. Journal of the Brazilian Chemical Society, 27(12), 2300–2311.

Carson, E., & Watson, J. (2002). Undergraduate students’ understandings of entropy and Gibbs free energy. University Chemistry Education, 6(1), 4–12.

Cowie, J. M. G., & Arrighi, V. (2007). Polymers: Chemistry and Physics of Modern Materials. CRC Press.

Del Mar Olaya, M., Reyes-Labarta, J. A., Serrano, M. D., & Marcilla, A. (2010). Vapor-liquid equilibria: Using the gibbs energy and the common tangent plane criterion. Chemical Engineering Education, 44(3), 236–244.

Eso, R. (2018). Simulation of 1D Gaussian Wave Packet and 2D Waves in Square Membrane Using Excel Spreadsheet with Visual Basic for Teaching Activity. Journal of Physics: Conference Series, 1120(1), 1–9.

Eso, R., Safiuddin, L. O., Agusu, L., & Arfa, L. M. R. F. (2018). Simulation of 2D Waves in Circular Membrane Using Excel Spreadsheet with Visual Basic for Teaching Activity. Journal of Physics: Conference Series, 1120(1), 1–7.

Finkenstaedt-Quinn, S. A., Halim, A. S., Kasner, G., Wilhelm, C. A., Moon, A., Gere, A. R., & Shultz, G. V. (2020). Capturing student conceptions of thermodynamics and kinetics using writing. Chemistry Education Research and Practice, 21(3), 922–939.

Grigore, I., Miron, C., & Barna, E. (2015). Exploring Excel spreadsheets in the teaching and learning of certain concepts of Statistical physics and Thermodynamics. Proceedings of the 10th International Conference on Virtual Learning, 399–405.

Grigore, I., Miron, C., & Barna, E. S. (2016). Exploring the graphic facilities of excel spreadsheets in the interactive teaching and learning of damped harmonic oscillations. Romanian Reports in Physics, 68(2), 891–904.

Irvan, Basit, L., Maulana, H., Nasution, M. R., & Wahyudi, R. (2021). Google Workspace for Education untuk Pebelajaran Berbasis ICT di Sekolah Muhammadiyah Kota Binjai. JURNAL PRODIKMAS Hasil Pengabdian Kepada Masyarakat, 6(2), 157–162.

Knychała, P., Timachova, K., Banaszak, M., & Balsara, N. P. (2017). 50th Anniversary Perspective: Phase Behavior of Polymer Solutions and Blends. Macromolecules, 50(8), 3051–3065.

Lazar, A. L., Konradt, S. C., & Rottengruber, H. (2019). Open-source dynamic MATLAb/Simulink 1D proton exchange membrane fuel cell model. Energies, 12(18), 1–12.

Mitchell, B. S. (2003). An Introduction to Materials Engineering and Science. A John Wiley & Sons, Inc.

Oliveira, M. C., & Nápoles, S. (2010). Using a Spreadsheet to Study the Oscillatory Movement of a Mass-Spring System. Spreadsheets in Education (EJSiE), 3(3), 1–23.

Oliveira, M., & Nápoles, S. (2017). Functions and Mathematical Modelling with Spreadsheets. Spreadsheets in Education (EJSiE), 10(2), 1–30.

Perdana, R., Wahyu, A., & Kuswanto, H. (2019). Simulation using VBA in Microsoft Excel to Enhance Pre-service Physics Teachers’ Motivation. International Journal of Science and Business, 3(3), 114–123.

Pratidhina, E., Dwandaru, W. S. B., & Kuswanto, H. (2020). Exploring Fraunhofer diffraction through Tracker and spreadsheet: An alternative lab activity for distance learning. Revista Mexicana de Fisica E, 17(2), 285–290.

Pratidhina, Elisabeth, Kuswanto, H., & Dwandaru, W. S. B. (2020). Visualising Spatial Light Intensity Distribution on Optical Fibre Core with Spreadsheet. Revista Brasileira de Ensino de Física, 42(1), 1–6.

Putranta, H., & Kuswanto, H. (2018). Spreadsheet For Physics: Lissajous Curve. International Journal of Recent Scientific Research, 9(5), 26942–26948.

Putranta, H., Kuswanto, H., Purnama, A. Y., & Rani, S. A. (2022). Visualization of Body Centered Cubic Energy Bands Based on Spreadsheet-Assisted Tight Binding: Solutions for Distance Material Physics Lectures. Trends in Sciences, 19(12), 2–11.

Raisal, A. Y., Sukma, M., & Ritonga, M. (2022). Simulasi Perhitungan Waktu Salat Menggunakan Spreadsheet. Al-Marshad: Jurnal Astronomi Islam Dan Ilmu-Ilmu Berkaitan, 8(1), 11–26.

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.

Sokolova, T. S., Dorogokupets, P. I., Litasov, K. D., Danilov, B. S., & Dymshits, A. M. (2018). Spreadsheets to calculate P–V–T relations, thermodynamic and thermoelastic properties of silicates in the MgSiO3–MgO system. High Pressure Research, 38(3), 193–211.

Wilberforce, T., El-Hassan, Z., Khatib, F. N., Al Makky, A., Baroutaji, A., Carton, J. G., Thompson, J., & Olabi, A. G. (2017). Modelling and simulation of Proton Exchange Membrane fuel cell with serpentine bipolar plate using MATLAB. International Journal of Hydrogen Energy, 42(40), 25639–25662.

Zhang, W., Gomez, E. D., & Milner, S. T. (2017). Predicting Flory-Huggins χ from Simulations. Physics Review Letter, 119(1), 1–5.


Article Metrics

Abstract view : 71 times
PDF - 33 times


  • There are currently no refbacks.

Copyright (c) 2023 Abu Yazid Raisal, Rosynanda Nur Fauziah, Heru Kuswanto

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.


Jurnal Pendidikan Fisika
p-ISSN : 2252-732X | e-ISSN : 2301-7651
Organized by The Magister of Physics Education Departement in State University of Medan in collaboration with Physical Society of Indonesia (PSI) 
E : (principal contact)

StatCounter - Free Web Tracker and Counter


Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.