MTF Numerical Methods

Workshop Plans

Workshop 1

Excel VBA 1

Today's workshop is really just to get people started on using Visual Basic for Applications

By the end of the workshop you should feel confident writing basic computer programs in VBA

Go to Introducing Excel VBA

Workshop 2

Finish programming techniques with conditional statements

Do prime number exercise as class exercise

Write matrix multiplication together as class exercise

Quickly overview section on excel objects

Mathematical Applications

The rest of this workshop will cover the areas of solving equations using Newton Rhapson and solving differential equations using the Rung-Kutta method. We will also look at numerical integration techniques and Monte Carlo methods

The notes can be found here: Mathematical Preliminaries

We may get to look at chapter 3: Advanced Topics as well, but this is beyond what is necessary for an introductory course