This paper describes a way to simulate and visualise 3D representations of the resultant electric field vector propagation for plane, circular and elliptically polarised waves. These polarisation states are obtained by the superposition of two coherent linearly polarised waves oscillating in two mutually perpendicular directions. The required data…

In this paper, we present a demonstration of Ohm's law on a spreadsheet. Students can perform an experiment of Ohm's law like they perform in laboratories. The only difference is that the apparatus is virtual. The students record readings of current through the circuit and potential difference across a resistor. A graph is drawn between I and V to…

This paper gives an account of an experiment in which thirty-three high school students of ages 17-19 developed spreadsheet numerical models of satellite and space probe motion. The models are free to download. A survey was carried out to find out the students' opinion of the lessons.

This paper gives the solution and analysis of projectile motion in a vacuum if the launch and impact heights are not equal. Formulas for the maximum horizontal range and the corresponding angle are derived. An Excel application that simulates the motion is also presented, and the result of an experiment in which 38 secondary school students…

In the teaching of physics at upper secondary school level (K10-K12), the students are generally taught to solve problems analytically, i.e. using the dynamics describing a system (typically in the form of differential equations) to compute its evolution in time, e.g. the motion of a body along a straight line or in a plane. This reduces the scope…

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…

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)

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)

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 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)

Computers are revolutionizing activities in all areas of life. Physics researchers, accustomed to being at the forefront of technology, have been deeply affected by the computer revolution. This effect has serious implications for what is taught and how it is taught in the physics classroom. This conference was organized to allow physics teachers…