This page provides some notes, ideas and examples about how Visual Basic (VB) programming in Excel can be used to learn and teach mathematics. This is based on an idea by F.R.Watson.
These are all Word files
| Notes | Read this first |
| BCME Tutorial | Tutorial used at BCME 6 |
| Note on arrays | A note on arrays |
These are all Excel files. When you open these you may get a message about disabled macros. You need macros enabled for these to work - see the Word notes about this.
| Buffon | Finding π using Buffon's needle |
| Function plotter | General purpose |
| Finding π | Finding π as a product |
| Sum of random numbers | Shows histogram |
| Collection | A set of short examples |
| Simpsons | Integration using Simpson's Rule |
| Vieta | Finding π using Vieta's method |
| Sequences and series | Various |
| Queue simulation | Cars at traffic lights |
| Monte Carlo | Finding π using a Monte Carlo method |