The Nolan Index (NI) is a normed, quantitative measure for comparing the degree of resemblance (similarity or dissimilarity) between free listings with an Excel program for calculating it. This article enhances that effort with the addition of an R program and additional applications. Free-list resemblance measures have been used to investigate…

Functions and formulas in spreadsheets provide an instructional opportunity to help students build their skills in identifying errors in their own work and identifying a path to go about correcting the errors. This paper provides examples of functions and equations used to create two approaches to calculating the solution to one problem, such as a…

Most physics courses begin with one-dimensional kinematics, which is usually restricted to the case of constant acceleration. Here we report a unique exercise for an introductory algebra-based physics course involving the running and non-constant acceleration of the theropod dinosaur "Dilophosaurus wetherilli" and the world-famous…

Solution equilibria diagrams are excellent tools for understanding chemical speciation in multireaction chemical systems. They are usually plotted using software packages that efficiently perform advanced calculations, giving the possibility to graphically visualize thermodynamic and composition information. However, this approach frequently…

The drive in computational methods and more intuitive software has seen a rise in the number of publications in this area in recent years. Computational simulations can be found in many areas of science from computational biology and chemistry to fundamental physics. These may help synthetic chemists in their drug discovery endeavors and…

The Birthday Paradox problem can be investigated either with a carefully constructed spreadsheet (for greatest precision) or a calculator process (for reasonable precision). A number of ways of approaching this problem as a class activity are provided.

In this article, the degrees of freedom of the sample variance are simulated by using the Visual Basic for Applications of Microsoft Excel 2010. The simulation file dynamically displays why the sample variance should be calculated by dividing the sum of squared deviations by n-1 rather than n, which is helpful for students to grasp the meaning of…

A spreadsheet project that enables students to construct chemical potential vs temperature plots, [mu](T), of liquid and gaseous mercury and all three phases of diiodine and ammonia is presented. Statistical thermodynamics is used to determine the entropies of the substances in the gas phase. For the solid and liquid phases, students start with…

A spreadsheet-based project is presented that is designed to enhance and expand student understanding of phase transition properties of pure water and ideal and nonideal (electrolyte) aqueous solutions. Using fundamental principles of classical and statistical thermodynamics, students calculate the melting and boiling points, the enthalpies and…

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 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,…

For the least-squares analysis of data having multiple uncertain variables, the generally accepted best solution comes from minimizing the sum of weighted squared residuals over all uncertain variables, with, for example, weights in x[subscript i] taken as inversely proportional to the variance [delta][subscript xi][superscript 2]. A complication…

The effects of substitution on reaction rates are at the heart of both physical chemistry and organic chemistry. In this paper, we present a computational laboratory module to explore the effects of group substitution and isotopic substitution on reaction rates by using a readily accessible graphical interface, a computational engine, and…

In the field of physics teaching, the simple pendulum provides a very simple way to study the harmonic oscillator, the source of some fundamental concepts such as periodicity, relaxation time and anharmonicity. As such, its experimental study is frequently integrated into high school or first year university programs. With this in mind, in this…

This article describes the use of a spreadsheet to reinforce basic calculus that is expected of all university-level chemistry majors. The example provided shows a calculation using Excel to estimate, using a Riemann summation, the radiant exitance of a hot object using Planck's Law of Blackbody Radiation. The approach reinforces the elementary…