Simulation using VBA in Microsoft Excel to Enhance Pre-service Physics Teachers’ Motivation

There are many difficult topics to teach directly in physics learning. Some concepts are abstract or difficult to show one by one. Not a few studies that use applications or media that serves to help the learning process. However, most of the media is offered use some of the most complex and complicated new apps. Even sometimes it’s make difficult for teachers. To overcome this, this study offers learning media using spreadsheets that simple and easy. Topics in this study is simple harmonic motion in physics lessons. The method is used VBA in Microsoft Excel. Sample of this research were 86 student on pre service students from Tanjungpura University. They were given a task to make this simulation and interviewed as randomly to know their motivation on physics learning. As the result, we created a studying media to simulate harmonic wave motion that can be varied according to the needs of teachers during the learning process. Their motivation also increase to learn more about physics simulation. The practical application of this paper is helping teacher to teach physics more effective especially in visualizing of simple harmonic motion. This article also adds intellectual property to easy and effective simulation-based learning.