Teaching Differential Equations to Mechanical Engineering Students Using Excel VBA

Abstract

The ability to solve differential equations is necessary for mechanical engineering students, as these equations model real-world engineering systems such as fluid flow, heat conduction, thermodynamics, and structural integrity. This aim of this study is to develop a complete teaching module by utilizing the Excel VBA to facilitate the numerical solution of differential equations in mechanical engineering. Unlike MATLAB or Python, Excel VBA provides an open platform for students with  minimal coding experience, thus enabling them to understand numerical methods while working within a spreadsheet. The research follows the Design, Development, Implementation, and Evaluation (DDIE) framework to create an interactive and practical learning experience for the students. The study evaluates student engagement, understanding, and problem-solving ability by using both the qualitative and quantitative assessments. The module was tested in an undergraduate engineering classroom and  demonstrated strong quantitative impact,  receiving high validation scores from both the students and faculty members with a 35% average score improvement, 85% student preference for Excel VBA, and faculty reporting 30% increased confidence, 25% better problem-solving, 20% more experimentation, and 25% improved conceptual understanding. The results demonstrate that the Excel VBA is an effective tool for teaching numerical methods by providing the students with an intuitive and interactive approach to solve differential equations.

https://doi.org/10.63236/ijmar.1.1.2