Premium
Teaching the numerical solution of ordinary differential equations using Excel 5.0
Author(s) -
Bilbao y Leon Sama,
Ulfig Robert,
Blanchard James
Publication year - 1996
Publication title -
computer applications in engineering education
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.478
H-Index - 29
eISSN - 1099-0542
pISSN - 1061-3773
DOI - 10.1002/(sici)1099-0542(1996)4:2<117::aid-cae3>3.0.co;2-g
Subject(s) - computer science , macro , focus (optics) , ordinary differential equation , simple (philosophy) , interface (matter) , differential equation , microsoft excel , computational science , algorithm , mathematical optimization , programming language , theoretical computer science , mathematics , parallel computing , mathematical analysis , philosophy , physics , epistemology , bubble , maximum bubble pressure method , optics , operating system
Personal computer‐based computational programs have begun to replace procedural programming as the tools of choice for engineering problem solving. These tools offer ease of use along with sufficient computational power to solve realistic problems. Hence, the development time is reduced while retaining sufficient complexity. These advantages are particularly important in the classroom, allowing students to focus initially on algorithms, with little time spent learning the use of the particular tool. Later, the students can develop more sophisticated solutions using the advanced capabilities of the tool. An example is given using Microsoft Excel 5.0, implementing algorithms for solving ordinary differential equations. The simple interface of the spreadsheet can be used to learn the fundamentals of the algorithm, and then the macro language (Visual Basic) can be used to produce more powerful equation solvers. The final result is an adaptive algorithm that can easily be used to numerically solve complex systems of differential equations. © 1996 John Wiley & Sons, Inc.