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 simple spreadsheet based simulation activity that can be performed by students at the undergraduate level. This simulation is implemented in free open source software (FOSS) LibreOffice Calc, which is available for both Windows and Linux platform. This activity aims at building the probability distribution for the…

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)