In the modern, information driven society managing and handling data is unavoidable. The most common form of data handling is to organize data into tables and complete operations on them in spreadsheets. Sprego (Spreadsheet Lego) is a programming-oriented methodology focusing on schemata construction and authentic problem-solving working with only…

Quantitative decision making (management science, business statistics) textbooks rarely address data cleansing issues, rather, these textbooks come with neat, clean, well-formatted data sets for the student to perform analysis on. However, with a majority of the data analyst's time spent on gathering, cleaning, and pre-conditioning data, students…

A simple organic chemistry experiment is described that investigates the kinetics of the reaction between 1-bromobutane (BuBr) and iodide (I[superscript -]) as followed by observing the disappearance of BuBr and the appearance of 1-iodobutane (BuI) using [superscript 1]H NMR spectroscopy. In small groups of three to four, students acquire data to…

Researchers are often distressed to discover that the data they wanted to use in their landmark study is not configured in a way that is usable by a Statistical Analysis Software Package (SASP). For example, the data needed may come from two or more sources and it may not be clear to the researcher how to get them combined into one analyzable…