Linear, quadratic, and exponential functions, as well as polynomial functions, are the most basic mathematical expressions. Despite being among the most basic expressions in algebra, these functions are often used to approximate more complicated functions. The Common Core State Standards for Mathematics provide the framework for a discussion of the basic functions presented here. To that extent, the content of this paper consists of the use of spreadsheet technology in experimentation with linear transformations in the plane; experimentation with the way quadratic functions behave; constructing and comparing linear, quadratic, and exponential models of real-life data; and automation of the computation of real zeros of polynomials where such calculations require implementation of time consuming iterative procedures. An iterative procedure based on the Rational Zeros Theorem will be used to find exact values of rational zeros of a polynomial. A second iterative procedure based on the Bounds on Zeros theorem and the Intermediate Value Theorem will be used to approximate all real zeros of a polynomial.
This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 4.0 License.
Spreadsheets: Laying a Foundation for Understanding Functions,
Spreadsheets in Education (eJSiE):
2, Article 1.
Available at: http://epublications.bond.edu.au/ejsie/vol8/iss2/1