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)

Described is a means of logging data from remote sensors in data files and then transferring the data to a spreadsheet for processing. The presentation of the data in tabular or graphical form is discussed. An example using temperature data from a model house is provided. (Author/CW)