When students of the of the physical sciences transition from school to university, they discover that knowledge of calculus is as vital as arithmetic, and that there is precious little useful information written without calculus. However, the lack of calculus in pre-university physics studies persists, especially in its application to 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.

Naturally occurring gravity currents include events such as air flowing through an open front door, a volcanic eruption's pyroclastic flow down a mountainside, and the spread of the Bhopal disaster's methyl isocyanate gas. Gravity currents typically have a small height-to-distance ratio. Plastic models were designed and constructed with a…

Many high school and introductory college physics courses make use of mousetrap car projects and competitions as a way of providing an engaging hands-on learning experience incorporating Newton's laws, conversion of potential to kinetic energy, dissipative forces, and rotational mechanics. Presented here is a simple analytical and finite element…

In this exercise the US Standard Atmosphere is used as "data" that a student is asked to model by deriving equations to reproduce it with the help of spreadsheet and graphing software. The exercise can be used as a laboratory or an independent study for a student of introductory physics to provide an introduction to scientific research…

This article looks generally at spreadsheet modelling of feedback situations. It has several benefits as a teaching tool. Additionally, a consideration of the limitations of calculating at many discrete points can lead, at A-level, to an appreciation of the need for the calculus. Feedback situations can be used to introduce the idea of…

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)

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…