Describes a spreadsheet activity for the iodine-clock reaction which follows the concentrations of all reactions and products for 200 seconds and gives the induction period. Explains that, although there are limitations to the spreadsheet, it is nevertheless illuminating. (Author/ASK)

Analyzes the results of a Mexican/British project that used the sociocultural approach to investigate ways in which mathematics is used in the practice of school science and the role of spreadsheets as a mathematical modeling tool. Suggests the possibility of enhancing students' capability to shift between a wider range of representations using…

Compares phase diagrams relating to the solubilities and melting points of various substances in textbooks with those generated by a spreadsheet using data from the literature. Argues that differences between the diagrams give rise to new chemical insights. (Author/MM)

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)

Discusses reasons for using spreadsheets in science teaching. Presents a list of possible applications together with examples of these from very simple to more complex uses including animation of dynamic systems. Also provides a list of references for materials for beginners and more advanced users. Contains 12 references. (Author/ASK)

Explains that thinking like a physicist involves an understanding of the scientific methods of inquiry and the ability to use these methods in investigations. Describes two simple experiments in which high school and college students measure physical constants and make an easy analysis of their experimental data by applying the tools offered by…

Presented is an example of this use of spreadsheet software. The basic case is considered with an extension and suggestions for other applications. Emphasized is the use of this method at the introductory level. (CW)

Describes two types of star charts commonly available for astronomical viewing and outlines a strategy by which teachers can have students use a computer spreadsheet to prepare their own easy-to-use star charts appropriate for the location, date, and time of viewing. (Author/MKR)

Addresses some basic aspects of Archimedes' law. Focus is on potential energy relationships so as to elucidate some common misunderstandings and to facilitate making bridges with other physical topics. A spreadsheet model is used as a simulation tool. (Author/NB)

Many believe that technology offers the most benefit to students and teachers when it is integrated into the core curriculum rather than being taught as a separate discipline. This publication is intended to assist teachers in incorporating technology into learning activities in mathematics and science. Chapters emphasize issues concerning…

Provides an activity which measures the heat transfer through an insulated cylindrical tank, allowing the student to gain a better knowledge of both the physics involved and the working of spreadsheets. Provides both a spreadsheet solution and a maximum-minimum method of solution for the problem. (MVL)

Scientists need to measure and communicate, to handle information, and model ideas. In essence, they need to process information. Young scientists have the same needs. Computers have become a tremendously important addition to the processing of information through database use, graphing and modeling and also in the collection of information…

Many teachers have found that, no matter how enjoyable ecological studies are, students tend to dislike the computation of the large amounts of data gathered. Included is a description of an experiment that utilized time-saving features as well as the instructional and motivational benefits of using a computer spreadsheet program to analyze and…

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)

Described is an approach that uses a computer spreadsheet program to calculate entropy change at constant temperature and pressure. The calculated values can be used in an associated graphing program. (CW)