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 lever rule applies to any two-component system existing in a state of two-phase equilibrium. Here, several classroom demonstrations are described to help students understand liquid--liquid coexistence and the lever rule using a set of isobutyric acid + water + dye samples ranging in composition from water + dye to isobutyric acid + dye. The…

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

Here, students determine aspirin (acetylsalicylic acid) mass in pharmaceutical tablets using a colorimetric method. Aspirin, salicylate, and salicylic acid do not absorb visible light. Thus, in alkaline medium, acetylsalicylic acid was hydrolyzed to salicylate; then, it was reacted with an acidic Fe(III) solution, and a violet complex was formed.…

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…

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…

Students in 12 secondary schools in three states of Malaysia were taught to use worksheets on the chemical kinetics topic which had been pre-created using the MS Excel worksheets. After the teaching, an opinion survey of 612 Form Six students from these schools was conducted. The results showed that almost all the students felt that MS Excel…

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…

Students who are strong in logical-mathematical intelligence have a natural advantage in learning and understanding chemistry, which is full of abstractions that are remote from the material world. Simulations provide more-inclusive learning activities for students who are weak in logical-mathematical intelligence. A second advantage of using…