Collaboration & Pooling Laboratory Measurements

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.

Collaborative Crowdsourcing Eye-ball Curve Fitting (GSheets) -  

Students try to eye-ball a straight line thru data that gets progressively more scattered (increased random noise) - click here

We present two examples in more detail, chemical reactions and discovering pi, which are very different in what data and how it is collected.  Our collaborative-pair computational spreadsheet projects are provided.

Here is a site that uses pooled data, Computer Supported Collaborative Science by Norman Herr at CSUN, that explores data pooling and formative assessment.  Herr's website has publications and a wealth of science activities in a variety of disciplines.