Document Type


Publication Date



Using spreadsheets one can develop an exploratory environment where mathematics students can develop their own understanding of the relationship between the parameters of commonly encountered families of functions (linear, logarithmic, exponential and power) and a natural interpretation of “rate of change” for those functions. The key to this understanding involves expanding the concept of rate of change to include percent changes. Through the use of the spreadsheet model, students can explore and easily determine which type of change is most natural for a given family of functions. This, in turn, provides a mechanism for interpreting the parameters of the function numerically, rather than graphically, as is common.


This version is pre-publication.

Final version published as Green, K. (2008), Using spreadsheets to discover meaning for parameters in nonlinear models. Journal of Computers in Mathematics and Science Teaching, 27(4):423-411.

Additional Files