Using Google Forms and Sheets to create large datasets that allow for a rich analysis of student-collected inquiry data (SNC1P)
Title: Investigating the effects of humans on the local school ecosystem using the Google Suite for Education with SNC1P students
Technology Focus: Using the power of Google Forms and Sheets to create large datasets that allow for a rich analysis of student-collected inquiry data.
Description: Students will fill out a Google Form on the ecosystem data that they collect, which will then be exported into a Google Sheet and analyzed so that students can see trends in their class’s dataset without much effort on either the student or teacher’s part. The students are empowered to analyze their own data while teacher is a guide on the side. |
Level: Low-medium. Teachers should have a basic grasp on how to post Google Docs, Forms, and Sheets to google classroom or another learning management software. Teachers should understand the relationship between a Google Form and its linked Sheet so that they can show students where their inputted data has been analyzed. Teachers should also feel comfortable using the chart editor in Google Sheets to change the axis titles. See additional resources for support. |
Audience: Secondary. Main use was designed to match the SNC1P curriculum during Strand B: Biology, but this could also be used in a SNC1D classroom to cover Strand B: Biology as well. Students at this level are most engaged when they participate in hands-on activities related to their own lives and environmental experiences such as their local school environment. |
Tool Highlights: Google Forms and Sheets |
Body: Big Ideas:
Ministry Expectations (overall expectations, STSE expectations, specific expectations):
Key Concepts: Students collect data on their school grounds to examine how human disturbance has caused changes in their ecosystems. Prior Skill Sets: Students will be familiar with using Google Apps for Education. The students will also understand the concept of human disturbance and what effects that can have on the environment. They will also be able to read basic graphs and interpret trends from them. A reminder checklist can be given to the students using the following PDF: http://club.cciproject.org/charts/media/checkBar.pdf Materials and Equipment:
Instructional strategies:
Safety (both in the classroom and online - using third party tech tools):
Teaching Suggestions/Hints:
|
Assessment strategy Assessment for learning:
Assessment as learning:
Assessment of learning (Rubric):
|
Next Steps/Extensions/Accommodations/Other Topics for this Tech Tool: |
Additional Resources: Using Google Docs: Google. (2018) GSuite Learning Centre. Retrieved from https://gsuite.google.com/learning-center/#!/ Creating forms: Johnson, A. (2016). Google Forms - Recommended Way to Collect Data [Video file]. Retrieved from https://www.youtube.com/watch?v=oMdljepMERA Modifying Graphs in Sheets: Cool, S. (2013). How to Make a Graph in Google Sheets (Scatter Plot) [Video file]. Retrieved from https://www.youtube.com/watch?v=st7DFULsP0M Safety: OPHEA. (2015) A Safe Space to Play, Learn & Grow. Retrieved from https://www.ophea.net/article/safe-space-play-learn-grow STAO. (2011) Safe on Science. Toronto, ON: STAO. |