Spreadsheet activity

The use of Google docs is an imperative online tool for students to consider when creating spreadsheets. Google doc spreadsheets can be used to organise sets of quantitative and qualitative data to ensure data is interpreted easily.

Students will find this web tool useful for organizing experimental data.

As an activity for incorporating the use of spreadsheets, students will undertake a first-hand investigation to demonstrate the effect of dissolved carbon dioxide on pH of water using a pH meter data logger.

As an activity for incorporating the use of graphs, students will undertake a first-hand investigation examining the effects of carbon dioxide in water and the measurements of pH will be recorded at specific time intervals. The data will be organised in Google doc spreadsheet and the numerical data will then be converted into an appropriate graph (i.e. line graph) for further analysis. Google Apps. Google Drive. Screenshot: Google Docs. Learning outcomes and content. Screenshot: Effect of CO2 in water.