In today's global economy, the origin of the food we eat is becoming more and more difficult to identify. Verifying the authenticity of products to protect supply chains is a complicated problem that requires a multidisciplinary approach. Chemical authentication of foodstuffs often includes a mass spectrometer detector; however, they are costly…

This teaching brief describes an engaging, in-class exercise that introduces genetic algorithms as well as advanced Excel functions and capabilities by modeling the familiar Sudoku puzzle. Student groups are first asked to manually solve a given puzzle and then translate that solution methodology to a spreadsheet model. This exercise can be used…

A bachelor's degree program in chemistry typically starts with basic concepts in mathematics, physics, and chemistry. Those principles are very important because they pave the ground for future advanced studies and, therefore, one needs to present them in a clear but rigorous way. One example is provided by the mathematical notion of an iterative…

This paper develops the ideas of "The Pedagogical Power of Context: Iterative Calculus Methods and the Epidemiology of Eyam" (French "et al." 2018 "J. Phys. Educ."), where we considered the application of the Euler method to solve epidemiological problems. Our purpose was to convey some examples of school level work…

The scale-invariant way to analyze two-dimensional experimental and theoretical data with statistical errors in both the independent and dependent variables is revisited by using what we call the triangular linear regression method. This is compared to the standard least-squares fit approach by applying it to typical simple sets of example data…

The classical "brachistochrone" problem asks for the path on which a mobile point M just driven by its own gravity will travel in the shortest possible time between two given points "A" and "B." The resulting curve, the cycloid, will also be the "tautochrone" curve, i.e. the travelling time of the mobile…

This paper provides the formula for the elevation angle at which a projectile has to be fired in a vacuum from a general position to hit a target at a given distance. A spreadsheet application that models the trajectory is presented, and the problem of finding the points of shot and impact of a projectile moving in a vacuum if three points of the…

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 general systematic approach is proposed for the numerical calculation of multi-equilibrium problems. The approach involves several steps: (i) the establishment of balances involving the chemical species in solution (e.g., mass balances, charge balance, and stoichiometric balance for the reaction products), (ii) the selection of the unknowns (the…

A simple, conceptual method is described for using the spreadsheet scroll bar to find the composition of a system at chemical equilibrium. Simulation of any kind of chemical equilibrium can be carried out using this method, and the effects of different disturbances can be predicted. This simulation, which can be used in general chemistry…

The aim of this study is to scrutinize the characteristics of conceptual meaning making when students engage with virtual worlds in combination with a spreadsheet with the aim to develop graphs. We study how these tools and the representations they contain or enable students to construct serve to influence their understanding of energy resource…

An analysis of physical geology textbooks used in introductory courses shows that there is a systematic lack of clarity regarding flood risk. Some problems originate from confusion relating to statistical terms such as "100-year flood" and "100-year floodplain." However, the main problem is conceptual: statistics such as return…

This article describes a comprehensive treatment of experimental enzyme kinetics strongly coupled to electronic data acquisition and use of spreadsheets to organize data and perform linear and nonlinear least-squares analyses, all in a manner that promotes development of important reasoning skills. Kinetic parameters are obtained for the stable…

Discusses the use of a spreadsheet program to vary the parameters in multiloop circuit problems. Enables students to better understand how the elements in a multiloop circuit determine the current by allowing them to see the results of the changes immediately. (JRH)

Presented are several simple kinetic systems together with the spreadsheets used to solve them. A set of exercises in chemical kinetics appropriate for an introductory course in physical chemistry is given. Error propagation calculations with experimental data are illustrated. (CW)