We present a simple activity based on the liquid-drop model which allows secondary school students to explore the uses of mathematical models and gain an intuitive understanding of the concept of binding energy, and in particular the significance of positive binding energy. Using spreadsheets provided as supplementary material, students can…

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…

GRANTISM (GReenland and ANTarctic Ice Sheet Model) is an educational Excel™ model introduced by Pattyn (2006). Here, GRANTISM is amended to simulate the Svalbard-Barents-Sea Ice Sheet during the Last Glacial Maximum, an analogue for the contemporary West Antarctic Ice Sheet. A new name, "GRANTSISM," is suggested; the added S represents…

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.

In enzyme kinetic studies, linear transformations of the Michaelis-Menten equation, such as the Lineweaver-Burk double-reciprocal transformation, present some constraints. The linear transformation distorts the experimental error and the relationship between "x" and "y" axes; consequently, linear regression of transformed data…

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…

The current research article is based on a simple and practical way of employing the computational power of widely available, versatile software MS Excel 2007 to perform interactive computer simulations for undergraduate/graduate students in biology, biochemistry, biophysics, microbiology, medicine in college and university classroom setting. To…

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…

Discusses the effectiveness of offering science laboratories via distance education. Explains current delivery technologies, including computer simulations, videos, and laboratory kits sent to students; pros and cons of distance labs; the use of spreadsheets; and possibilities for new science education models. (LRW)

Presents a numerical simulation of a simple food chain together with a set of mathematical rules generalizing the model to a food web of any complexity. Discusses some of the model's interesting features and its use by students. (Author/JRH)

Describes the "ABCD" model for integrating spreadsheets into elementary science instruction, which consists of four steps: analyzing the software and curriculum; brainstorming connections between parts of the software and the content areas; creating connections among the curriculum, the brainstorming information, and noncomputer classroom…

Described is the generation of a scale model of the solar system and the milky way galaxy using a computer spreadsheet program. A sample spreadsheet including cell formulas is provided. Suggestions for using this activity as a teaching technique are included. (CW)

Describes how to place mathematical equations modeling population growth into a spreadsheet that performs calculations quickly and easily. Suggests experiments that can be performed with the spreadsheets. (WRM)