Textbook: (Optional) Excel for Scientists and Engineers by E. Joseph Billo, ISBN: 978-471-38734-3
Despite the title, this will be a fun “tools” class. Many, many engineering (and living) problems require some type of numerical solution or analysis. Mostly this is performed by purchased codes, however it is important for engineers to understand the usage and limitations of numerical methods and at least the basics of what is behind the black box solution.
We will use Excel to explore the basics of interpolation, systems of linear equations, nonlinear equations, curve fitting, numerical integration, differentiation, ordinary differential equations, partial differential equations, and Monte Carlo simulation.
Class will consist of students completing Excel workbooks based upon real world problems such as: a) how to get rich in the stock market, b) river flow measurement, c) heat transfer in soil, and d) spread of disease throughout the world.
The context will illustrate the importance of the methods being taught. Subsequent to the class the student will be better prepared to address a variety of engineering and life problems.