The Effect of the Microsoft Excel based Interactive Learning Media on the Physics Problem Solving

Irnin Agustina Dwi Astuti, Yoga Budi Bhakti


The physics problem solving is needed students to overcome the phenomenon of physics.  The development of technology in physics learning is able to explain the concept of abstract physics. This study aims to know effect of use interactive learning media based Microsoft Excel on the physics problem solving. The subject on this media is Heat and Temperature. The research method used is pretest-postest controlled group design. The analysis technique is used t-test with SPSS 16.0 with a margin of error of 5%. The results of this study showed that the mean scores of post-test treatment class students significantly better than the average score post-test control class indicated by the average score of students' post-test treatment class at 80.26 and scores the average post-test control class at 68.00 and with SPSS analyze sig value is 0.000. While the average score gain results-physics students learn physics class treatment significantly better than the average score gain results Physics students learn physics-control class indicated by the average score of physics problem solving gain of 0.77 and the treatment class the average score gain control class student physics problem solving of 0.63.


physics problem solving, interactive learning media, microsoft excel, physics learning

Full Text:



Syukri M, Soewarno S, Halim L, Mohtar L E, The Impact Of Engineering Design Process In Teaching And Learning To Enhance Students’ Science Problem-Solving Skills, Jurnal Pendidikan IPA Indonesia, vol. 7, no. 1, 2018, pp. 66-75.

Hoellwarth, C., Moelter, M. J., & Knight, R. D, A direct comparison of conceptual learning and problem solving ability in traditional and studio style classrooms, American Journal of Physics, vol 73, no. 5, 2005, pp. 459-462.

Tuminaro, J., & Redish, E. F, Student Use of Mathematics in the Context of Physics Problem Solving: A cognitive model U, of Maryland preprint, 2005.

Walsh, L. N., Howard, R. G., & Bowe, B, Phenomenographic study of students’ problem solving approaches in physics, Physical Review Special Topics-Physics Education Research, vol. 3, no. 2, 2007, pp. 020108.

Matsuo. K, Barolli. L, Xhafa F, Koyama A & Durresi A, New Function for stimulating learners' motivation in a web-based e-learning system. Journal of Distance Education Technologies, 2008, pp. 34-49.

Sakat.A A, Mohd Zin. M Z, Muhamad. R, Ahmad. A, Ahmad. N A., & Kamo. M A, Educational technology media method in teaching and learning progress. American Journal of Applied Science, 2012, pp. 874-888.

Astuti, IAD & Bhakti, YB. Interactive Learning Multimedia Based Microsoft Excel On The Temperature and Heat. Unnes Science Education Journal, vol. 7, no. 1, 2018, pp. 1-6.

Dagiane. V, Ignatova. N & Kubilinskiene. S, ICT-based learning personalization affordance in the context of implementation of constructionist learning activities, Informatics in Education - An International Journal, vol. 14, no. 1, 2015, pp. 53-67.

Sukarno & Sutarman D, The Development Of Light Reflection Props As A Physics Learning Media In Vocational High School Number 6 Tanjung Jabung Timur, International Journal of Innovation and Scientific Research, vol. 12, no. 2, 2014, pp. 346-355.

González,M Á, Martín M E, Llamas C, Martínez Ó, Vegas J, and Hernández C 2017 Teaching and learning physics with smartphones. In Blended Learning: Concepts, Methodologies, Tools, and Applications (pp. 866-885). IGI Global.

Bharathy J B, Importance of Computer Assisted Teaching & Learning Methods for Chemistry, Science, vol. 3, no.4 , 2015, pp. 11-16.

Syukri M, Soewarno S, Halim L, Mohtar L E, The Impact Of Engineering Design Process In Teaching And Learning To Enhance Students’ Science Problem-Solving Skills, Jurnal Pendidikan IPA Indonesia, vol. 7, no. 1, 2018, pp. 66-75.

Lee M K, & Erdogan I, The effect of science–technology–society teaching on students’ attitudes toward science and certain aspects of creativity. International Journal of Science Education, vol. 29, no. 2, 2007, pp. 1315-1327.

Halim A, Yusrizal Y, Susanna S, & Tarmizi, T, An analysis of students’ skill in apply¬ing the problem solving strategy to the physics problem settlement in facing AEC as global competition. Jurnal Pendidikan IPA Indonesia, vol. 5, no. 1, 2016, pp. 1-5.

Rahman MJA, Ismail. M A & Nasir. M, Development and evaluation of the effectiveness of computer-assisted physics instruction. International Education Studies, vol. 7, no. 13, 2014, pp. 14.

Bhakti, YB & Astuti, IAD. The Influence Process of Science Skill and Motivation Learning with Creativity Learn. Journal of Education and Learning, vol. 12, no. 1, 2018, pp. 30-35.

Bruce. W C & Meehan. A M, Microsoft Excel™ as a tool for teaching basic statistics. Teaching of Psychology, vol. 28, no. 4, pp. 295-298.

Brown. A M, A step-by-step guide to non-linear regression analysis of experimental data using a Microsoft Excel spreadsheet, Computer methods and programs in biomedicine, vol. 65, no. 3, pp. 191-200.

Hegde B & Meera B N, How do they solve it? An insight into the learner’s approach to the mechanism of physics problem solving, Physical Review Special Topics - Physics Education Research, vol. 8, no. 1, 2012, pp. 01010.

Yang, Ya-Ting Carolyn, Building virtual cities, inspiring intelligent citizens: Digital games for developing students’ problem solving and learning motivation, Computers & Education, vol. 59, no. 2, 2012, pp. 365-377.

Firdaus T, Setiawan W, & Hamidah, I, The Kinematic Learning Model using Video and Interfaces Analysis, In Journal of Physics: Conference Series, vol. 895, no. 1, 2017, pp. 012108. IOP Publishing.

Chandler P D, Middle years students’ experience with new media, Australian Journal of Education, vol. 57, no. 3, 2013, pp. 256-269.

Mayer R E, The promise of multimedia learning: using the same instructional design methods across different media, Learning and instruction, vol. 13, no. 2, 2003, pp. 125-139.



  • There are currently no refbacks.

Copyright (c) 2018 Universitas Ahmad Dahlan

License URL:

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

Indonesian Review of Physics
Kampus 2 Universitas Ahmad Dahlan
Jalan Pramuka No. 42, Pandeyan, Umbulharjo, Yogyakarta - 55161
Telp. (0274) 563515, ext. 4902; Fax. (0274) 564604

p-ISSN: 2621-3761 | e-ISSN: 2621-2889


View My Stats