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…

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)

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)

Focuses on the place of discrete mathematics in the grades 9-12 mathematics curriculum and discusses how the topic of recursion should be taught. Presents several examples of recursion involving LOGO, spreadsheets, sequences, Pascal's triangle, and the Tower of Hanoi to illustrate its teaching. (MDH)

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)

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)

The use of computer spreadsheet programs in the physics laboratory is discussed. An example of this application with a conservation of energy laboratory is presented including the cases of a rolling sphere and a sliding sphere. (CW)

Presents the use of spreadsheets as an alternative method for precalculus students to solve maximum or minimum problems involving surface area and volume. Concludes that students with less technical backgrounds can solve problems normally requiring calculus and suggests sources for additional problems. (MDH)

U.S. mathematics education has been criticized for being too broad. This article examines ways middle school students use simple problems and situations to foster a deeper understanding of underlying concepts. Presents a sample area and perimeter problem, describes extending the problem using tiles to determine minimum perimeter, and discusses…

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)

Described is how spreadsheet and problem solver microcomputer programs may assist students in performing mathematical calculations. Discussed is the application of the equation solver "MathCAD" to various areas in the undergraduate curriculum. (KR)

Describes spreadsheet activities that illustrate a problem-solving approach to teaching statistical concepts, allowing students to explore properties underlying descriptive statistics before being introduced to computational rules. (MKR)

Explores alternative strategies to solve algebraic equations that do not lend themselves to traditional methods. Examines one nontraditional equation by a graphical approach using a graphing utility and by a numerical approach using spreadsheets. Discusses new basic skills for algebra utilizing technology. Provides a computer program to solve…

Discussed are the possible uses of spreadsheets in the undergraduate curriculum in chemical engineering classes. The advantages and flexibility of spreadsheets, spreadsheet instruction, graphing capabilities, assignment examples, and conclusions are described. (KR)

Investigates the probability of winning the largest prize at Bingo through a series of five simpler problems. Investigations are conducted with the aid of either BASIC computer programs, spreadsheets, or a computer algebra system such as Mathematica. Provides sample data tables to illustrate findings. (MDH)