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

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

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…

Simple numerical data analysis is described, using a standard spreadsheet program, to determine distance, velocity (speed) and acceleration from voltage data generated by a skateboard/longboard speedometer (Hare 2012 "Phys. Educ." 47 409-17). This simple analysis is an introduction to data processing including scaling data as well as…

Titration experiments are ideal for generating large data sets for use in quantitative-analysis activities that are meaningful and transparent to general chemistry students. We report the successful implementation of a sophisticated quantitative exercise in which the students identify a series of unknown acids by determining their molar masses…

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…

How useful are the standard deviations per se, and how reliable are results derived from several least-squares coefficients and their associated standard deviations? When the output parameters obtained from a least-squares analysis are mutually independent, as is often assumed, they are reliable estimators of imprecision and so are the functions…

Two methods of data analysis are compared: spreadsheet software and a statistics software suite. Their use is compared analysing data collected in three selected experiments taken from an introductory physics laboratory, which include a linear dependence, a nonlinear dependence and a histogram. The merits of each method are compared. (Contains 7…

Optimization of a chromatographic separation within the time constraints of a laboratory session is practically impossible. However, by employing a HPLC simulator, experiments can be designed that allow students to develop an appreciation of the complexities involved in optimization procedures. In the present exercise, a HPLC simulator from "JCE…

Seven p-nitrophenyl benzoate esters (p-nitrophenyl benzoate, p-nitrophenyl m-anisate, p-nitrophenyl p-anisate, p-nitrophenyl m-chlorobenzoate, p-nitrophenyl p-chlorobenzoate, p-nitrophenyl m-toluate, p-nitrophenyl p-toluate) were synthesized and characterized by students in a second-semester organic laboratory course. In a subsequent laboratory…

There are few studies of the impact of ubiquitous computing on high school science, and the majority of studies of ubiquitous computing report only on the early stages of implementation. The present study presents data on 3 high schools with carefully elaborated ubiquitous computing systems that have gone through at least one "obsolescence cycle"…

Presents an activity to integrate mathematics, science, and technology by using a computer spreadsheet to examine relationships between data collected about popcorn. (11 references) (Author/MKR)

Describes combining the simple activity of collecting monthly student height measurements with the technology of using a computer spreadsheet for a year-long activity that teaches measurement and data manipulation. (PR)

This article describes how Cahokia middle and high school students conduct inquiry-based science through a pitfall trap experiment. In a collaborative effort, students designed and conducted pitfall trap investigations that combined their interest in the natural world with their love of technology. The students set up their own experiments to…