ISSN: 2226-6348
Open access
Statistics courses are vital across scientific and non-scientific disciplines, yet many students struggle with fundamental concepts, leading to high failure rates and difficulties in applying statistical techniques. Addressing these challenges, this paper introduces HypothEase, an innovative learning tool developed using Microsoft Excel and Visual Basic for Applications (VBA), designed to enhance students' understanding of hypothesis testing. HypothEase offers a user-friendly interface and interactive features to facilitate self-guided learning of key statistical concepts, including hypothesis formulation, critical value determination, and test statistic calculation. The tool provides automated feedback and practical exercises, aiming to improve comprehension and reduce statistics anxiety among students. The development process involved iterative testing and refinement based on educator and student feedback. Initial results suggest that HypothEase significantly aids in mastering hypothesis testing by providing a comprehensive and accessible learning experience. This approach highlights the potential of integrating technology into statistical education, offering a cost-effective and engaging alternative to traditional methods.
Akugizibwe, E., & Ahn, J. Y. (2020). Perspectives for effective integration of e-learning tools in university mathematics instruction for developing countries. Education and Information Technologies, 25(2), 889-903.
Asmat, A., Samsudin, S. S., & Wahid, S. N. S. (2020). Learning statistics course using computer_aided software: a case study among furniture technology students. International Journal of Modern Trends in Social Sciences (IJMTSS), 3(11).
Banda, G., Tailoka, F. P., & Muma, E. (2021). Effect of e-learning on the academic performance of third year students in statistics at Mukuba University. Journal of Mathematics and Science Teacher, 1(2), 24-56.
Bernard, M., Akbar, P., Ansori, A., & Filiestianto, G. (2019, October). Improve the ability of understanding mathematics and confidence of elementary school students with a contextual approach using VBA learning media for Microsoft Excel. In Journal of Physics: Conference Series (Vol. 1318, No. 1, p. 012035). IOP Publishing.
Burckhardt, P., Nugent, R., & Genovese, C. R. (2021). Teaching statistical concepts and modern data analysis with a computing-integrated learning environment. Journal of Statistics and Data Science Education, 29(sup1), S61-S73. https://doi.org/10.1080/10691898.2020.1854637
Castro, M. G. A. D. and García-Peñalvo, F. J. (2021). Erasmus+ educational projects on elearning and related methodologies. Information Technology Trends for a Global and Interdisciplinary Research Community, 111-133. https://doi.org/10.4018/978-1-7998-4156-2.ch006
Chaamwe, N. and Shumba, L. (2016). 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(6), 435-440. https://doi.org/10.7763/ijiet.2016.v6.728
Garrison, D. R. (1997). Self-directed learning: Toward a comprehensive model. Adult education quarterly, 48(1), 18-33.
Hadi, A., Mohd Yusop, N., Mohd Razali, N., Khairudin, Z., and Mohd Razali, N. (2018). Perceiving statistical knowledge through digital apps: an exploratory study/Az’lina Abdul Hadi...[et al.]. Journal of Academia, 6(2), 53-57.
Hunt, B. W., Mari, T., Knibb, G., Christiansen, P. and Jones, A. (2023). Statistics anxiety and predictions of exam performance in UK psychology students. PLoS ONE 18(8): e0290467. https://doi.org/10.1371/journal.pone.0290467.
Egodawatte, G. (2019). Some suggestions for teaching undergraduate business statistics courses. Asian Journal of Economics, Business and Accounting, 1-9. https://doi.org/10.9734/ajeba/2019/v11i330130
Kabulunze, J. G., Mwangi, H., & Ogada, K. (2023). Improve student performance in the psychiatry subject with 3d animation. Journal of Agriculture, Science and Technology, 22(3), 79-99. https://doi.org/10.4314/jagst.v22i3.7
Luo, L., Cheng, X., Wang, S., Zhang, J., Zhu, W., Yang, J., & Liu, P. (2017). Blended learning with Moodle in medical statistics: an assessment of knowledge, attitudes and practices relating to e-learning. BMC medical education, 17, 1-8.
Mousa, B., Mohd Zaid, N. B., Abuhassna, H., & Mohammed, G. K. (2024). Examining the correlation between the use of e-learning platforms' tools and instructors' performance using a bibliometric study. International Journal of Academic Research in Business and Social Sciences, 14(5). https://doi.org/10.6007/ijarbss/v14-i5/21501
Razali, F. A., Wahid, S. N. S., Adnan, N. I. M., Badrul, N. M. F. H. N., & Hilmi, Z. A. G. (2023). The effect of students’ attitudes and concerns on statistical concepts performance: A SEM approach. International Journal of Education and Practice, 11(3), 669-680.
Ruqoyyah, S., Murni, S., & Wijaya, T. T. (2020, August). The Effect of VBA for Microsoft Excel as Teaching Material to Improve Prospective Elementary School Teachers' Mathematical Conceptual Understanding. In Elementary School Forum (Mimbar Sekolah Dasar) (Vol. 7, No. 2, pp. 251-268). Indonesia University of Education. Jl. Mayor Abdurachman No. 211, Sumedang, Jawa Barat, 45322, Indonesia. Web site: https://ejournal. upi. edu/index. php/mimbar/index.
Pérez, M. L. R., Martínez, H. A., Espinoza, R. S., & Lugo-Armenta, J. G. (2023). Exploring challenges and strategies in teaching hypothesis testing to engineering students from the perspective of educators. EURASIA Journal of Mathematics, Science and Technology Education, 19(12), em2371.
Strong, R. L. (2012). Investigating students’ satisfaction with elearning courses: the effect of learning environment and social presence. Journal of Agricultural Education, 53(3), 98-110. https://doi.org/10.5032/jae.2012.03098
Tawil, N. M., Ismail, N. A., Asshaari, I., Osman, H., Nopiah, Z. M., & Zaharim, A. (2012). Comparing lecture and e-learning as learning process in mathematics and statistics courses for engineering students in Universiti Kebangsaan Malaysia. Procedia-Social and Behavioral Sciences, 60, 420-425.
Thottoli, M. M. M., Islam, M. A., Ahamad, S., & Hassan, M. S. (2023). Does e-learning enhance accounting students’ employability skills? a qualitative study of university students in Oman. Business, Management and Economics Engineering, 21(1), 46-58.
Ulfa, A. F., & Laily, N. (2023). VBA (Visual Basic for Applications) Based Learning Media Development in Accounting Practice Learning. Journal of Accounting and Business Education, 7(2), 25-40.
Veress-Bágyi, I. (2023). Mobile devices in hungarian university statistical education. Teaching Mathematics and Computer Science, 21(1), 19-48. https://doi.org/10.5485/tmcs.2023.0543
Zhang, Z. (2018). Construction of the multimedia teaching platform of cost accounting course based on excel vba program. International Journal of Emerging Technologies in Learning (iJET), 13(05), 177. https://doi.org/10.3991/ijet.v13i05.8436
Zulfira, R., Halim, A., Khaldun, I., Mahzum, E., Nazar, M., & Kasli, E. (2024). Effect of interactive learning media using visual basic for application excel spreadsheet to reduce misconception in physics learning. Jurnal Penelitian Pendidikan IPA, 10(1), 28-36. https://doi.org/10.29303/jppipa.v10i1.6387
Yusop, N. M., Wahab, N. A. A., Hadi, A. A., Razali, N. M., & Azlan, N. (2024). Utilising Microsoft Excel and VBA to Develop Learning Tool for Statistics Education. International Journal of Academic Research in Progressive Education and Development, 13(3), 3384–3396.
Copyright: © 2024 The Author(s)
Published by HRMARS (www.hrmars.com)
This article is published under the Creative Commons Attribution (CC BY 4.0) license. Anyone may reproduce, distribute, translate and create derivative works of this article (for both commercial and non-commercial purposes), subject to full attribution to the original publication and authors. The full terms of this license may be seen at: http://creativecommons.org/licences/by/4.0/legalcode