This paper presents the usage of an Excel spreadsheet for studying charged particle dynamics in the presence of uniform electric and magnetic fields. The equation of motion of the charged particle is developed under different conditions and the data is obtained in an Excel spreadsheet under variation of parameters such as the velocity of charged…

Each year our physical science class for pre-service elementary teachers launches water-powered rockets based on the activity from NASA. We analyze the rocket flight using data from frame-by-frame video analysis of the launches. Before developing the methods presented in this paper, we noticed our students were mired in calculation details while…

We present an iterative procedure that does not rely on calculus to model heat flow through a uniform bar of metal and thus avoids the use of the partial differential equation typically needed to describe heat diffusion. The procedure is based on first principles and can be done with students at the blackboard. It results in a plot that…

A simple interface between VPython and Microsoft (MS) Office products such as Word and Excel, controlled by Visual Basic for Applications, is described. The interface allows the preparation of content-rich, interactive learning environments by taking advantage of the three-dimensional (3D) visualization capabilities of VPython and the GUI…

Discusses how computers can help students learn to design experiments, collect data, and quickly analyze that data both mathematically and graphically. Demonstrates some of the capabilities of the spreadsheet for these purposes with examples of data from gas law experiments. (JJK)

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)

Presented is an activity in which students work in research teams to gather data, integrate computer analyses, and discover the relationships between variables by using a second class lever. A diagram of the lever, a list of processes involved in this activity, and an idealized data table are included. (KR)

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)

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.…

Explains how a spreadsheet can be an effective modeling and simulation tool for studying electrical circuits. Highlights include Kirchoff's rules and matrices algebra; a pilot experiment with preservice teacher education students in a physics class; the teacher's role; student attitudes; curricular aspects; and the effectiveness of the spreadsheet…

Describes how spreadsheets can be used for helping students learn about direct current electrical circuits. (PR)

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…

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)