Vibrational fine structure observed in the published He-I UV photoelectron spectra of H[subscript 2] and N[subscript 2] molecules recorded at room temperature and under microwave excitation or at 700 °C have been reexamined and compared with calculations of the Franck-Condon factors (FCFs) using simple harmonic oscillator wave functions and/or…

A Spreadsheet Excel application for chromatographic peak characterization is described in this article. Data are exported from HPLC specific program to an Excel file with macros to perform basic calculations as retention time, height, and area of the peaks. From these values, peak resolution, asymmetry, or theoretical plates are calculated and…

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…

The development and application of a simulator designed with Excel spreadsheets to teach procedural skills in atomic absorption spectrometry and atomic emission spectrometry are proposed. For the development of the simulator, different analytical procedures were followed including analysis of pharmaceutical, forensic, and environmental samples.…

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…

Chemistry is increasingly data centric and the undergraduate curriculum needs to adjust to keep up. To address this, we created the "Air Quality Activity," a new first-year undergraduate activity where students use Microsoft Excel to analyze a unique subset of atmospheric ozone (O[subscript 3]) and nitrogen dioxide (NO[subscript 2])…

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…

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…

Collecting data on learners' performance in different chemistry contents and analysing them to identify their knowledge and understanding in related content areas is a major task of Chemistry Education Research. The data collection process on the learners' content knowledge and understanding of content knowledge requires a standard measuring tool.…

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…

Powder diffraction is one of the most widely used analytical techniques for characterizing solid state materials. It can be used for phase or polymorph identification, quantitative analysis, cell parameter determination, or even full crystal structure analysis using the powerful Rietveld refinement method. As with much of modern crystallography,…

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…

Scientific Data Analysis Toolkit (SDAT) is a rigorous, versatile, and user-friendly data analysis add-in application for Microsoft Excel for Windows (PC). SDAT uses the familiar Excel environment to carry out most of the analytical tasks used in data analysis. It has been designed for student use in manipulating and analyzing data encountered in…

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…