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 a graphing activity to show transverse and longitudinal waves using spreadsheets. (Author/NB)

Describes how to fit binocular observations of the planets to a theoretical model of circular orbits using a modern computer spreadsheet, from which fundamental data about the solar system may be deduced. (AIM)

Describes how a spreadsheet is used to fit a circular orbit model to observations of Jupiter's moons made with a small telescope. Kepler's Third Law and the inverse square law of gravity are observed. (AIM)

Proposes activities that promote students' awareness of the structure of the information involved in their everyday activities, and builds the concept of function from students' mental representations of phenomena. Recommends the use of spreadsheets to provide external representations of these functions. (DDR)

Describes when and how to carry out many of the most common statistical tests including mean, standard deviation, confidence limits, correlation, regression, t-test, Chi square test, and ANOVA. Uses Excel to perform these operations. (DDR)

To answer students' questions about predicting grade averages or projecting grades needed to attain specific grade goals, academic advisors can use computerized grade calculations. Spreadsheet and HyperCard versions of grade calculation software are discussed and illustrated, and suggestions are offered for using them in specific advising…

The Optimizer in Quattro Pro and the Solver in Excel software programs make solving linear and nonlinear optimization problems feasible for business mathematics students. Proposes ways in which the Optimizer or Solver can be coaxed into solving systems of linear equations. (ASK)

This guide is designed to meet the following goals: provide information that reflects the changes in technology in the 1990s; provide basic information to teachers, aides, and students who are not computer literate; and provide review information for individuals who are computer literate. The information provided may be used either for specific…

The National Council of Teachers of Mathematics has stated that computer technology is an important factor in the improvement of mathematics instruction and an important tool in mathematics instruction. Computer spreadsheets are readily adaptable for problem solving, can enhance the user's insight into the development and use of algorithms and…

Given are instructions for teaching spreadsheet use for problem solving in mathematics. Examples of relevant problems from algebra through calculus are provided. The advantages of using computer spreadsheets in this application are stressed. (CW)

Explored are ways in which spreadsheets can be used in the teaching of chemistry. Some of the limitations of using algebraic modelling tools are highlighted. Several example applications are provided. (CW)

Presented is an illustration of the use of a computer spreadsheet program, Microsoft Excel version 1.5, for solving complicated chemical problems. Examples of spreadsheet output are provided. (CW)

Evaluates a pair of workshops conducted by the Physics Courseware Evaluation Project. Presents data collected on computer tool needs of the teachers, microcomputer-based laboratory probes usage, spreadsheet usage, software usage, effectiveness of technology in the classroom, and teacher involvement with computers. Reports that high school teachers…

This paper describes a training program which was designed to train teachers how to use computer applications such as database management systems and spreadsheets in their classrooms; how to modify applications according to their teaching practices; and how to learn from their experiences in using computer applications in the classroom. A group of…