A laboratory experiment characterized by a whole-class data-pooling approach to generate a data set that can be used to test a model of the influence of ionic strength on electrolyte solubility is described and discussed. The design of the experiment makes efficient use of the laboratory period and releases time for instructional and dialogic…

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 exercise for students is described in which they are challenged to explain and reproduce the disparate temperature dependencies of the heat capacities of gaseous F[subscript 2] and N[subscript 2]. For F[subscript 2], C[subscript p,m] increases from 300 K, reaches a maximum at 2200 K, and then decreases to 74% of the maximum…

EXCEL spreadsheet algorithms were developed at Villanova University to efficiently and consistently retrieve information from ASPEN® flowsheets and used for grading work in senior design. The challenge is to take a large volume of data that is in the stream and unit operations reports and quickly and consistently calculate a list of key grading…

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…

Here we present an inexpensive proposal to experimentally study Faraday's law of induction. The experiment uses low-cost materials, a computer with a sound card and a smartphone, both running free software. A value proportional to the induced electromotive force is measured with the computer's sound card and the data related to the magnetic field…

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…

Through the experiments described in this article, students become acquainted with the principles behind ternary liquid-liquid systems and/or Aqueous Two-Phase Systems (ATPS), and their characterization by the determination of the binodal curve, tie-lines, tie-line lengths and critical point, as well as in applying the non-random two-liquid model…

A series of Microsoft Excel spreadsheets were developed to simulate the process of separation optimization under isocratic and simple gradient conditions. The optimization procedure is performed in a stepwise fashion using simple macros for an automatic application of this approach. The proposed optimization approach involves modeling of the peak…

What follows is a description of the procedure for a directed-study in which a student, guided by a faculty member, attempted to identify potentially habitable exoplanets using actual data available online from NASA's "Kepler" Mission.

A low-cost chaos dynamics lab is developed for quantitative demonstration of the butterfly effect using a magnetic pendulum. Chaotic motion is explored by recording magnetic time series. Students analyze the data in Excel® to investigate the butterfly effect as well as the reconstruction of the strange attractor using time delay plots. The lab…

A simple Excel spreadsheet-based program for simulating atomic emission spectra from the properties of neutral atoms (e.g., energies and statistical weights of the electronic states, electronic partition functions, transition probabilities, etc.) is described. The contents of the spreadsheet (i.e., input parameters, formulas for calculating…

3-D topographic surfaces ("topos") can be generated to visualize how pH behaves during titration and dilution procedures. The surfaces are constructed by plotting computed pH values above a composition grid with volume of base added in one direction and overall system dilution on the other. What emerge are surface features that…