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

By using a sample of 1st-year undergraduate business students, this study dealt with the development of simple (deterministic and non-optimization) spreadsheet models of income statements within an introductory course on business informatics. The study examined students' errors in doing this for business situations of their choice and found three…

Presents examples that illustrate how spreadsheets can be used to ask and answer all sorts of scientific questions given suitable automation of useful spreadsheet procedures. Examples include data exploration, data analysis, project presentation, simulations, and students writing their own models. (Author/JRH)

Describes when and how to carry out many of the most common statistical tests including mean, standard deviation, confidence limits, correlation, regression, t-test, Chi square test, and ANOVA. Uses Excel to perform these operations. (DDR)

This report discusses the methods, techniques, and software applications used in processing the data gathered in a survey of the physical condition and health of students in Guangdong Province, China. The introduction provides background on the survey. Survey grouping, data items, and survey procedures are then described. A discussion of…