Describes a spreadsheet that can be used to show the changes in intensity of Fraunhofer diffraction patterns produced by a single and double slits arrangement. Discusses a practical demonstration of diffraction that allows data to be logged and entered into the spreadsheet. (DDR)

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

Shows how some of the simple ideas in complexity can be investigated using a spreadsheet and a macro written in Visual Basic. Shows how the sandpile model of Bak, Chao, and Wiesenfeld can be simulated and animated. The model produces results that cannot easily be predicted from its properties. (Author/MM)

Creating a stock market simulation for the classroom computer reinforces math skills and can help students gain a good sense of how current events affect the economy, how to manage money and understand profit and loss, and how to use spreadsheet software. (IAH)

Analyzes the mathematics of rotational and translational motion and how one can influence the other in the context of cams and cranks. Describes how the individual components can be brought together to simulate a four-stroke engine and how the engine animates again using the same simple macro. (Author/ASK)

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)

Discussion of the use of computers in education focuses on ways to teach with limited computer resources. Learning processes with computers are described, the teacher-student relationship is examined, and examples of instruction using only one computer are given, including simulation programs in physics and the use of spreadsheets in mathematics.…

Described is the generation of a scale model of the solar system and the milky way galaxy using a computer spreadsheet program. A sample spreadsheet including cell formulas is provided. Suggestions for using this activity as a teaching technique are included. (CW)

Illustrated is the use of spreadsheet programs for implementing finite difference numerical simulations of chromatography as an instructional tool in a separations course. Discussed are differential equations, discretization and integration, spreadsheet development, computer requirements, and typical simulation results. (CW)

Describes a computer simulation of the Compton effect designed to lead students to discover (1) the relationship of the electron's final kinetic energy to its angle of scattering and (2) the relationship between the scattering angles of the outgoing electron and photon. (MDH)

This document consists of a curriculum guide combined with separately published "Simulations" and "Test Bank" volumes designed to support instructors using the curriculum guide. The curriculum guide for "business computer applications I" provides office education instructors with detailed units of instruction…