History


Help on query formulation
Capitalizing on the dynamic features of Excel to consider growth rates and limits. (English)
MathAMATYC Educ. 3, No. 2, 17-20 (2012).
Summary: It is common for both algebra and calculus instructors to use power functions of various degrees as well as exponential functions to examine and compare rates of growth. This can be done on a chalkboard, with a graphing calculator, or with a spreadsheet. Instructors often are careful to connect the symbolic and graphical (and occasionally the tabular) representations of the functions. However, the graphs that are typically used for this are static. The most recent versions of Microsoft Excel allow instructors to illustrate the connections between the symbolic, tabular, and graphical representations of the equations through quick generation of the function graphs. This requires only minimal input including three components: the equation of the function, its starting point, and the incremental changes between independent variable values. By formatting the spreadsheet to depend on these three things, the input values (and the calculated output values) are easily manipulated, allowing for changes in scale.
Classification: I20 U70
Valid XHTML 1.0 Transitional Valid CSS!