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…

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…

Data-handling, processing, and analysis skills are an integral part of a chemist's skill set and, more generally, are highly sought by employers. We report a self-directed workshop to develop and advance these key skills using the popular spreadsheet program Microsoft Excel. Making use of its accessible user interface, various contextualized…

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…

A Microsoft Excel workbook has been developed to simplify the quantitative analysis of experimentally measured titration curves for diprotic and triprotic amino acids such as glycine, arginine, histidine, and glutamate. Students perform the titration, enter the data into the worksheet, and manually adjust the resulting pK[subscript a] values to…

The oxidation of iron is an important reaction due to its high economic impact. In this laboratory exploration, the total order of this reaction was determined using commercially available handwarmer packets that rely on the iron-oxygen reaction to generate heat. The active ingredient in the handwarmer packet is iron, which interacts with…

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…

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…

Equilibrator is a Microsoft Excel program for learning about chemical equilibria through modeling, similar in function to EQS4WIN, which is no longer supported and does not work well with newer Windows operating systems. Similar to EQS4WIN, Equilibrator allows the user to define a system with temperature, initial moles, and then either total…

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…

In this paper we describe an interdisciplinary course on dynamics that is appropriate for nonscience majors. This course introduces ideas about mathematical modeling using examples based on pendulums, chemical kinetics, and population dynamics. The unique emphasis for a nonmajors course is on chemical reactions as dynamical systems that do more…

An Excel file that performs self-consistent field (SCF) calculations for the two-electron atoms is described. It is readily constructed and is relatively simple to use, providing a visual demonstration of how the self-consistent field (SCF) procedure is applied and what issues are involved.

A new Microsoft Excel spreadsheet design that enables a prompt calculation of rate constant, k values and associated errors and also addresses less common features such as the choice of an experimental curve's extent is presented. To complete the spreadsheet design, several highlights and squared colored boxes were included to assist the user and…

Kinetics constitutes a core topic in both the lecture and laboratory components of lower- level chemistry courses. While textbook examples can ignore issues of time, temperature and safety, the laboratory can not. Reactions must occur slowly enough to be detected by students, occur rapidly enough for data collection in the few hours assigned to a…