Exploration with spreadsheets and reliance on previous skills can lead students to determine the line of best fit. To perform linear regression on a set of data, students in Algebra 2 (or, in principle, Algebra 1) do not have to settle for using the mysterious "black box" of their graphing calculators (or other classroom technologies).…

Spreadsheets provide a rich setting for first-year algebra students to solve problems. Individual spreadsheet cells play the role of variables, and creating algebraic expressions for a spreadsheet to perform a task allows students to achieve a glimpse of how mathematics is used to program a computer and solve problems. Classic optimization…

Generalizing is a foundational mathematical practice for the algebra classroom. It entails an act of abstraction and forms the core of algebraic thinking. Kinach (2014) describes two kinds of generalization--by analogy and by extension. This article illustrates how exploration of fractals provides ample opportunity for generalizations of both…

Software programs such as Tinkerplots ® or Geometer's Sketchpad ® can help students solve problems in mathematics classes, but may not be available to them after high school. In contrast, many students who become familiar with Internet tools and programs in office packages (word processing, spreadsheets, etc.) may use them daily to enhance their…

The simple process of iteration can produce complex and beautiful figures. In this article, Robin O'Dell presents a set of tasks requiring students to use the geometric interpretation of complex number multiplication to construct linear iteration rules. When the outputs are plotted in the complex plane, the graphs trace pleasing designs…

If the prospective students of probability lack a background in mathematical proofs, hands-on classroom activities may work well to help them to learn to analyze problems correctly. For example, students may physically roll a die twice to count and compare the frequency of the sequences. Tools such as graphing calculators or Microsoft Excel®…

"When making mathematical models, technology is valuable for varying assumptions, exploring consequences, and comparing predictions with data," notes the Common Core State Standards Initiative (2010, p. 72). This exploration of the recursive process in the Devil and Daniel Webster problem reveals that the symbolic spreadsheet fits this bill.…

Logistic growth displays an interesting pattern: It starts fast, exhibiting the rapid growth characteristic of exponential models. As time passes, it slows in response to constraints such as limited resources or reallocation of energy. The growth continues to slow until it reaches a limit, called capacity. When the growth describes a population,…

Simulation is an important learning tool that allows students to grasp probability concepts, especially when the actual scenario does not need to be replicated entirely. In the cases of tossing coins and rolling dice, gathering the data before analyzing them can be laborious and might be a waste of precious class time--time that might be better…

This article presents lesson plans that use downloadable spreadsheet tools that relate symbolic and graphical representations of functions. Instructions and a template allow readers to create personalized tools without programming. (Contains 14 figures.)

This article shows how Microsoft Excel's ability to vary parameters with sliders allows students to "stand on the shoulders of giants" and discover characteristics of polynomial functions.

Presents activities for teaching the logistic growth model using calculators and spreadsheets. (ASK)

This article outlines a linear regression activity that engages learners, uses technology, and fosters cooperation. Students generated least-squares linear regression equations using TI-83 Plus[TM] graphing calculators, Microsoft[C] Excel, and paper-and-pencil calculations using derived normal equations to predict the 2004 presidential election.…

Demonstrates the application of spreadsheet analysis in solving equations beyond quadratics. Considers the costs of interest, gasoline, and maintenance in deciding how long it pays to keep a car. (MKR)

Spreadsheets to explore regression with an algebra 2 class in a medium-sized rural high school are presented. The use of spreadsheets can help students develop sophisticated understanding of mathematical models and use them to describe real-world phenomena.