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 work we discuss the intricacies of a simulation using the MS Excel spreadsheet that allows to study in detail the process of heat transfer between two reservoirs at different temperatures through a conducting rod when heat losses are neglected. The proposed physical model computes the time dependence of the reservoir temperatures and…

The present article demonstrates a way of programming using an Excel spreadsheet to teach Fourier series expansion in school/colleges without the knowledge of any typical programming language. By using this, a student learns to approximate partial sum of the n terms of Fourier series for some periodic signals such as square wave, saw tooth wave,…

Excel spreadsheets are used as an excellent tool in physics laboratory experiments related to wave optics. This paper presents a simple way to simulate diffraction of waves through a slit using Excel spreadsheets without any tedious programming. These simulations are used to visualize the effect of variation of different parameters such as number…

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…

This paper investigates some of the physics behind the remarkable supersonic freefall of Felix Baumgartner accomplished with the "Red Bull Stratos" project on 14 October 2012. The underlying problem is complex: a freefall with air resistance through a medium of changing density. We developed a model for the motion within the framework of…

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…

A spreadsheet simulation of a modern particle detector has been developed and can be readily used as an instructional tool in the physics classroom. The spreadsheet creates a three-dimensional model that can be rotated and helical trajectories can be highlighted. An associated student worksheet is also presented.

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)

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)