Collaboration and Pooling Laboratory Measurements in the Cloud

Enhancing both online collaboration and data interpretation and analysis skills in students by pooling class data for comparison via a cloud-based application. Here are a variety of activities we have used in workshops or general chemistry. The data collecting forms, sheets, and docs are linked in the table below.
For items in Google Drive, use File > Make a copy... to obtain a copy of the file to use or modify.


Laboratory Activity

Cloud Components in Google Drive

penny flipping 

(good demo for a group)

form > sheet with real time graph (averages over increasing number of trials)

Investigating the Height of a Stack of Cookies

form > sheet with real time graph (averages with plus/minus one standard deviation error points)

radioactive decay via M&M flipping

form > sheet with real time graph (averages to get better statistics especially at small numbers)






Investigating Mass-Volume Relationship

form > sheet with real time graph an computations with collaborative report as doc

(Technology logistics diagram)


Spreadsheet Simulations - to use as extension

Further Exploration of the Mass-Volume Relationship (interactive Google sheet)


Would it sink or float? (Excelet examining two blocks glued together of differing materials)


Beer’s Law - Spectral data comparison by groups

(in development)

sheet with real time graph plus online chat and PhET simulation with collaborative report as doc

Nuts and Bolts of Extrapolation

form > sheet and online chat about data quality

Nuts and Bolts of Let’s Make an Error

form > sheet and online chat about data quality and possible errors

Flipping a Penny:  Real or Fabricated Data (Excel)form > sheet (plots frequency of runs)
Unstacking Penniessheet (editable, please Make a copy...)