Describes the use of a spreadsheet in running a hands-on prey/predator simulation that enables students to see the effect of selection pressure on one allele in a gene pool. Discusses setting up and running the simulation, class discussion issues, exploring assumptions, and extensions. (JRH)

Describes research using a pedagogic strategy developed during an exploratory work called Active Graphing in which access to spreadsheets allows graphs to be used as analytic tools within practical experiments. Identifies aspects of student interaction with the experiment itself, the data collected and the graphs, and traces the emergence of…

Describes the use of spreadsheets to discuss mathematical concepts without using algebraic notation. Presents examples using Fibonacci numbers and factorials. (MKR)

Discusses the use of a spreadsheet program to vary the parameters in multiloop circuit problems. Enables students to better understand how the elements in a multiloop circuit determine the current by allowing them to see the results of the changes immediately. (JRH)

Describes two spreadsheets for producing acid-base titration curves, one uses relatively simple cell formulae that can be written into the spreadsheet by inexperienced students and the second uses more complex formulae that are best written by the teacher. (JRH)

Discusses a method that uses spreadsheets to calculate the exact distribution of the sum of two or more discrete random variables with arbitrary distributions. Demonstrates how this method can be used to investigate several problems that would be found interesting at the elementary level. (Author/ASK)

Describes the use of spreadsheets as an alternative means of teaching complex mathematical concepts through simulation using the topic of the statistical power of tests as an example. Through the simulation it is possible for the learner to explore the design factors that influence power. Also provides a simple way of calculating power as a…

Describes student-friendly data sets accessible over the Internet that enable students to use large sets of real data to create graphs, apply basic statistical techniques, construct models, and draw conclusions about how the earth functions. Lists useful online data sets. (JRH)

This book seeks to develop, enhance, and expand students' understanding of mathematics by using technology. Topics covered include the advantages of spreadsheets along with the opportunity to explore the 'what if?' type of questions encountered in the problem-solving process, enhancing the user's insight into the development and use of algorithms,…

The structure, execution, uses, and software specifications for this spreadsheet file are discussed. Availability and modifications of this program are described. (CW)

Shows how to model Newton's method for approximating roots on a spreadsheet. (MKR)

Discusses "REFLEX," a software package for scheduling. Explores the program's applications in preparing a departmental class schedule. Explains that "REFLEX" includes a filter function and some attributes of a spreadsheet but lacks the ability to interact with other databases. Concludes that the program can make scheduling…

Explains how to use the AppleWorks spreadsheet application for estimating labor, time, and materials costs in the construction industry. (SK)

Describes a spreadsheet model for approximating square roots then extends that model into the intriguing domain of chaos. Focuses on the use of a dynamic model to promote habits of mathematical reasoning, conjecturing, and graphing analysis that support mathematics learning across grade levels. (ASK)