This paper explores the use of spreadsheets to develop an exploratory environment where mathematics students can develop their own understanding of the parameters of commonly encountered families of functions: linear, logarithmic, exponential and power. The key to this understanding involves opening up the definition of rate of change from the…

This paper was prepared in response to the Conference Board of Mathematical Sciences recommendations for the preparation of secondary teachers. It shows how using trigonometry as a conceptual tool in spreadsheet-based applications enables one to develop mathematical understanding in the context of constructing geometric representations of unit…

Presents ideas for using a spreadsheet to reinforce teaching of enumerative combinatories in the secondary mathematics classroom. (PR)

This review examines the use of spreadsheets to introduce students to elementary concepts of mathematical dynamical systems. Key definitions from this field as well as specific assignments that were given as part of an elective mathematics course are discussed. (LZ)

This study proposes a model for training inservice science teachers to teach with electronic spreadsheets. A case study in which this model was implemented by 16 biology teachers during a training period and 3 teachers during an induction period is described. (LZ)

Describes two general spreadsheet templates to carry out all types of one-equation chemical equilibrium calculations encountered by students in undergraduate chemistry courses. Algorithms, templates, macros, and representative examples are presented to illustrate the approach. (PR)

Demonstrated in this article are some of the capabilities of a spreadsheet program using data obtained in gas law experiments and a computer interface system. The ability to organize and analyze data which a computer can provide for the student is emphasized. (KR)

Described are several spreadsheet templates which use the functions of iteration and logical look-up which allow students to calculate and graph quantum mechanical functions and to simulate rotational and vibrational energy level and spectra. The templates are listed in the appendix. (KR)

Explores some classic Fibonacci problems with the aid of AppleWorks spreadsheets calculations. Provides problems and spreadsheets for solving them. (Author/YP)

This article provides pedagogical techniques that require active student participation in the use of computer spreadsheets while determining recursive numerical solutions to equations. Included are several computer screen displays which illustrate the various advantages in using spreadsheets specific to synthetic division, the bisection method,…

Describes a step-by-step procedure that enables teachers to develop lessons that effectively use software or special calculators in the classroom. Problem-solving strategies and questions are determined that correspond to the technology through which students are able to construct their own knowledge. Illustrates the procedure using spreadsheets,…

Provides an annotated list of references on specific topics covering computers in general science and math. Topics include: artificial intelligence, CAI, LOGO, a heat capacity experiment, microcomputer tutorials, a Monte Carlo simulation, factoring, a geology simulation, polynomials, spreadsheets, a gas model simulation, integers, and…