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

Presents a new approach for the determination of the temperature coefficient of resistance of a resistor and a thermistor. Advantages include teaching students how to linearize data in order to utilize least-squares techniques, continuously taking data over desired temperature range, using up-to-date data-acquisition techniques, teaching the use…

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)

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)

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)

A mechanism for using personal computer spreadsheet software to generate unique laboratory and problem assignments in optics for each student and provide corresponding solutions that can be checked quickly is described. The method minimizes some students' tendency to inspect others' solutions without solving problems themselves. Another…

Spreadsheets can help teachers manage a variety of routine tasks with ease. From creating class lists to taking surveys and graphing results, spreadsheet programs have limitless classroom potential. This article offers six ways to put spreadsheets to work, including class lists, all-about-me surveys, name tags, calendars, skill-building games, and…

Explores the study of ordered pairs to allow students to demonstrate their own creativity, apply previously learned computer skills, evaluate their own work, and draw connections to other mathematical strands. Using a spreadsheet, students construct a drawing composed of connected ordered pairs, the inverse, and the negative of the drawing. (ASK)

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)

Presents the Fibonacci sequence in a format that is readily implemented using the table and list features of the Texas Instruments TI-82 graphing calculator or a spreadsheet. Includes questions and investigations that can be explored using these tables and lists. (MKR)

Investigates potential uses for spreadsheets that generate graphical representations, and explores complex sheets that can be used purely as demonstrations, which require far less time and expertise than writing equivalent computer programs. Includes several spreadsheet examples using Microsoft Excel. (JJK)

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)

Explores a birthday-related problem that asks about the probability of having people with the same birthday in a room. Utilizes spreadsheets to work on the problem and discusses related teaching issues. Contains 20 references. (ASK)