Google sheets
Link: https://docs.google.com/spreadsheets/
Google Sheets is a web-based office suite for the organisation and analysis of data, similar to the popular computer-based program Microsoft Excel. With its incorporation with Google Drive, spreadsheets can be automatically saved, stored, shared online and accessed by different device, particularly useful for students to organise experimental data for group projects.
Google Sheets is a web-based office suite for the organisation and analysis of data, similar to the popular computer-based program Microsoft Excel. With its incorporation with Google Drive, spreadsheets can be automatically saved, stored, shared online and accessed by different device, particularly useful for students to organise experimental data for group projects.
Student Activity and Engagement
Using Google Sheets, students will perform a group activity studying the physical properties of elements from the Periodic Table. Each group will choose one property, e.g. atomic radius, to gather information on to be placed on a spreadsheet and produce a computerised graph. The groups are to present their findings to the class and compile data with other groups with different physical properties, with discussion to explain the trends and patterns between element position in the Periodic Table and the properties.
Syllabus Outcomes:
NSW Chemistry Stage 6 Syllabus
Students:
- 8.3.3.3.2 use computer-based technologies to produce a table and a graph of changes in one physical property across a period and down a group
- 11.1 identify data sources to:
d) identify and use correct units for data that will be collected
e) recommend the use of an appropriate technology or strategy for data collection or gathering information that will assist efficient future analysis
- 12.3 gather information from secondary sources by:
c) extracting information from numerical data in graphs and tables as well as from written and spoken material in all its forms - 12.4 process information to:
c) best illustrate trends and patterns by selecting and using appropriate models including computer-assisted analysis