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…

Thermodynamics, and in particular entropy, has been found to be challenging for students, not least due to its abstract character. Comparisons with more familiar and concrete domains, by means of analogy and metaphor, are commonly used in thermodynamics teaching, in particular the metaphor "entropy is disorder." However, this particular…

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…

We have designed an exercise suitable for a lab or project in an undergraduate physical chemistry course that creates a Microsoft Excel spreadsheet to calculate the energy of the S[subscript 0] ground electronic state and the S[subscript 1] and T[subscript 1] excited states of H[subscript 2]. The spreadsheet calculations circumvent the…

Despite their technological savvy, most students entering university lack the necessary computer skills to succeed in a quantitative analysis course, in which they are often expected to input, analyze, and plot results of experiments without any previous formal education in Microsoft Excel or similar programs. This lack of formal education results…

A fast and generally applicable alternative solution to the problem of determining the useful shelf life of medicinal solutions is described. It illustrates the power and convenience of the combination of numerical simulation and nonlinear least squares with a practical pharmaceutical application of chemical kinetics and thermodynamics, validated…

Using an ALTA II reflectance spectrometer, the USGS digital spectral library, graphs of planetary spectra, and a few mineral hand samples, one can teach how light can be used to study planets and moons. The author created the hands-on, inquiry-based activity for an undergraduate planetary science course consisting of freshman to senior level…

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…

A freely available, easy-to-use Excel spreadsheet for performing linear least-squares fits for (x, y) data with errors in both coordinates is described. (Contains 1 table and 1 figure.)

A simple spreadsheet program is presented that can be used by undergraduate students to calculate the lattice-site distributions in solids. A major strength of the method is the natural way in which the correct number of ions or atoms are present, or absent, at specific lattice distances. The expanding-cube method utilized is straightforward to…

A concise roadmap for using computational chemistry programs (i.e., Gaussian 03W) to predict the color of a molecular species is presented. A color-predicting spreadsheet is available with the online material that uses transition wavelengths and peak-shape parameters to predict the visible absorbance spectrum, transmittance spectrum, chromaticity…

A new type of DVD spectroscope, the periscope type, is described and the numerical analysis of the observed emission and absorption spectra is demonstrated. A small and thin mirror is put inside and an eighth part of a DVD is used as a grating. Using this improved DVD spectroscope, one can observe and photograph visible spectra more easily and…

We describe a computer tutorial that introduces the concept of the steady state in enzyme kinetics. The tutorial allows students to produce graphs of the concentrations of free enzyme, enzyme-substrate complex, and product versus time in order to learn about the approach to steady state. By using a range of substrate concentrations and rate…

As part of a first-year college Introductory Physics course, I have students construct an Excel[R]: spreadsheet based on the differential equation for pendulum motion (we take a pendulum having a light bar rather than a string, so it can go "over the top"). In extensive discussions with the students, I find that forcing them to make the…