31


Introduction
Although spreadsheet programmes are originally designed for business applications, they are good teaching and learning tools in mathematics, especially in investigating number patterns, drawing statistical graphs and answering what-if type questions. Using spreadsheets in learning mathematics does not require advanced computer programming skills. Automatic display of numerical results, mathematical manipulation and graph drawing can be operated by simple commands.

Spreadsheet Resources from the Web
The Center for Technology and Teacher Education in the University of Virginia provides
Excel Activities and;
Excel Interactive Projects.
Classrooms that Excel includes lessons, resources and online tutorial for users of different levels.
Interactive Excel Worksheets in Emaths
Spreadsheet and Excel section in MathsNet
To Excel in the Classroom provides examples about using Excel in elementary classes.
Ways of Using Excel in the Mathematics Lesson in Kent National Grid for Learning (NGfL)
Interactive mathematics lessons for KS3 & KS4 using Excel from the Mathematics Association
Tyrrell, S. (2006) Introducing Excel. Mathematics Teaching Incorporating Micromath. 194, 16-17
Sidney Tyrrell reveals how a novice at Excel can produce a nifty interactive spreadsheet from scratch in about 20 minutes.
Selecting the Right Chart or Graph Type, by J.W. Olsen
Spreadsheet Tutorial, from the Learning Math of AnnenbergMedia Learner.org

Suggested Readings
Wei P. (1999). Using Spreadsheets in Mathematics Book 1  Kew: TGS Press [E 510.2855369 E96 W]
Masalski, W.J. (1999). How to use the spreadsheet as a tool in the secondary school mathematics classroom. Reston, Va.: National Council of Teachers of Mathematics. [510.712 M39]
Green, D., Armstrong, P. & Bridges, R. (1993). Spreadsheets: Exploring their Potential in Secondary Mathematics. Leicester: The Mathematical Association [E 510.2854 G79]