In science labs, data often requires the calculation of standard deviations and acceptable ranges. The Google Sheet shown is a sample "calculator" that determines the standard deviation for a data set, and then uses that standard deviation to calculate acceptable upper and lower ranges.
This screen cast will cover the following aspects of using Google Sheets for basic data analysis:
Entering spreadsheet data
Creating a graph
Determining an equation (curve fit) for the graph
Determining an "r-squared" correlation value
This is the format used for full science labs in Chemistry. This format was developed with input from science professors at the three main state universities - Iowa State University, The University of Iowa, and The University of Northern Iowa. A sample of this lab is also shown.
Occasionally, a different lab report format may be required for a given lab. "Column" and "Poster" lab report formats are shown. Poster lab reports are created with Google Slides or PowerPoint.
Some colleges and universities use the "Science Writing Heuristic" as a a lab report writing format. The writing heuristic was developed by the University of Iowa and is used extensively in U of I science courses. The main advantage of the science writing heuristic is its focus on explaining observations and conclusions in a lab report as opposed to just restating findings.
PhET simulations are a unique set of computerized sims developed by the University of Colorado. These sims include a number of science and math scenarios modeled for a computer environment. Sims may be used in Chemistry and Physics as practice tools or for introductory labs. Students using Chromebooks must remember to use only HTML5 sims. Click on the PhET icon to explore these educational tools.