Figure 1. Simple Harmonic Motion Wave (Stanford & Tanner, 2014) Method The method in this research is using Visual Basic of Application (VBA) in Microsoft excel. There are 86 pre-service teacher asked to create the simulation using VBA. This VBA is one of the features in Microsoft excel program. Through this feature the user can create various work function in accordance with the desired. In this research the form of VBA is to make the equation of wave function by making definition on some symbols. The following coding data on VBA is designed to simulate wave equations. 117 International Journal of Science and Business Email: [email protected] Website: ijsab.com Published By
IJSB Volume : 3, Issue : 3, Year : 2019 Page : 114-123 Figure 2. VBA of the Wave Equation Each coding data in the image has a different meaning. In the first column the code " Private_sub stop_click end end sub", this code means that the key provided to stop working function. The purpose of this code is when the stop button is pressed the resulting simulation will stop working. This makes it easy for the user to make the image annotations do not keep moving. In the second column, "Private_sub Start_click Dim n for n = 1 to 200 etc.", this code means that on start / play button provided run function. The purpose of this code is that when the button is pressed, the simulation will start working from 1 to 200. This facilitates the user when starting an explanation of simple harmonic motion. In the next column, each shows three variables that can be changed. The three variables are amplitude (A), angular velocity (w) and time (t). By using the scroll bar principle, the three variables can be changed according to the desired value. In this development all variables have a minimum value of 0 and a maximum of 50. This value can be set according to the needs of users when will explain the concept of waves in simple harmonic motion. After coding the data on the VBA sheet, the user can directly use the coding result on Microsoft excel sheet 2016. However, before running this application the user needs to restart the document, by first selecting the developer menu, then selecting macro security option, sub macro setting. Then proceed by clicking enable all macros. The goal is that all the coding from VBA that has been done can run. Simulation with Microsoft excel not only can display simple harmonic waveform waveform. In this study it will also be shown that the excel can automatically calculate the size of the deviation and the speed at which time, certain amplitude, and a certain angular velocity. To display this, separate tables should be created on the document. As shown in the following figure: 118 International Journal of Science and Business Email: [email protected] Website: ijsab.com Published By
IJSB Volume : 3, Issue : 3, Year : 2019 Page : 114-123 Figure 3. Variable Column In column B5 denotes the amplitude symbols (A) and C5 indicates the number of the amplitude value of the scroll bar of column D5. In column B6 shows the symbol of angular velocity (w) and C6 indicates the number of angular velocity values resulting from scroll bar column D6. The Last, in column B7 denotes the time symbol (t) and C7 indicates the number
You've reached the end of your free preview.
Want to read all 11 pages?
- Spring '18
- Dr. Moez
- Physics, International Journal of Science