I have been told by a lot of experts that MS excel is a very powerful tool when it comes to performing complex mathematical operations.
My own expertise in Excel is limited to adding up the grades of the student every semester and calculating the averages.
So I would like to use MS Excel to teach numerical techniques including differentiation & solving differential equations, perhaps even more.
The experts better be right!!
Hi Atif,
ReplyDeleteI'm not an expert on MS Excel and would be interested to know how to do this myself. Good luck with working it all out! There are some great Youtube videos on this and maybe you could also set your students the task to find out how to use these techniques themselves and Blog about their discoveries.
Hi Atif,
ReplyDeleteI've used Excel a lot for some of the applications you mentioned. It can be a really useful tool once you start to understand some of the more advanced techniques for using functions. You can even do iterative functions (the kind of thing I imagine you would need for some of the numeric methods for differential equations), although you have to trick Excel into doing it.
Look in the library for a current book on Excel functions. A good one can teach you a lot very quickly.
Cheers,
Dean