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…

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…

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 general systematic approach including ionic strength effects is proposed for the numerical calculation of concentrations of chemical species in multiequilibrium problems. This approach extends the versatility of the approach presented in a previous article and is applied using the Solver option of the Excel spreadsheet to solve real problems…

A three-part project for students in physical chemistry, computational chemistry, or independent study is described in which they explore applications of valence bond (VB) and molecular orbital-configuration interaction (MO-CI) treatments of H[subscript 2]. Using a scientific spreadsheet, students construct potential-energy (PE) curves for several…

A problem that illustrates two ways of computing the break-even radius of insulation is outlined. The problem is suitable for students who are taking an introductory module in heat transfer or transport phenomena and who have some previous knowledge of the numerical solution of non- linear algebraic equations. The potential for computer algebra,…

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…

A project for students in an upper-level course in quantum or computational chemistry is described in which they are introduced to the concepts and applications of a high quality, ab initio treatment of the ground-state potential energy curve (PEC) for H[subscript 2] and D[subscript 2]. Using a commercial computational chemistry application and a…

A brief history of the development of the empirical equation that is used by prominent, Internet-based programs to estimate (or calculate) the extinction coefficients of proteins is presented. In addition, an overview of a series of related assignments designed to help students understand the origin of the empirical equation is provided. The…

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…

Students often enter biology programs deficient in the math and computational skills that would enhance their attainment of a deeper understanding of the discipline. To address some of these concerns, I developed a series of spreadsheet simulation exercises that focus on some of the mathematical foundations of scientific inquiry and the benefits…

An approach is presented that utilizes a spreadsheet to allow students to explore different means of calculating and visualizing how the charge on peptides and proteins varies as a function of pH. In particular, the concept of isoelectric point is developed to allow students to compare the results of their spreadsheet calculations with those of…

Phase thermodynamics is often perceived as a difficult subject with which many students never become fully comfortable. The Gibbsian geometrical framework can help students to gain a better understanding of phase equilibria. An exercise to interpret the vapor-liquid equilibrium of a binary azeotropic mixture, using the equilibrium condition based…