2025 ASEE Annual Conference & Exposition

Scientific learning involves experimentation, mathematical modeling of physicochemical processes, and rigorous statistical analysis. These methods lead to discoveries in science and engineering, which are often implemented in commercial applications through the effective use of mathematical models. This process enables engineers to predict system performance and design equipment efficiently and economically. However, engineering students frequently find it difficult to apply theoretical principles to real-world problems, particularly those encountered in commercial settings. To address this challenge, we developed an innovative, Excel-based computational tool, CHE CALCULATOR®, at the University of X. This tool allows students to apply fundamental concepts from various chemical engineering courses—such as thermodynamics, fluid mechanics, and process control—to solve complex, commercially relevant problems with confidence.

CHE CALCULATOR®, powered by a VBA engine in Microsoft Excel, serves as a state-of-the-art platform that is easily accessible and adaptable for students. It enables them to extend and enhance the software with their own models and calculations, fostering both learning and creativity. The integration of this tool into the curriculum has strengthened students’ theoretical understanding while providing them with the practical skills necessary for success in industry.

In this paper, we will provide an overview of CHE CALCULATOR®, its applications in areas such as heat and mass transfer and chemical kinetics, and how it engages students in active learning. We will also discuss student feedback and engagement, as well as strategies for further enhancing the tool for future cohorts. Our goal is to illustrate how this integrated approach equips students to tackle the complex challenges they will face in their professional careers.