Google Sheets Unit

About:

Students were introduced to Google Sheets and it's capabilities. The unit began with a basic overview of spreadsheets and how to name/locate cells and cell ranges. We formatted a practice spreadsheet together using Nearpod, screencasts of each step, the projector, and their own computers. Students followed along as I walked them through using the toolbar.

In an effort to connect our learning to other content areas and provide an authentic use for spreadsheets, I worked with the Science teachers to use principles, data, and questions from their recent Physics unit to create a Google Sheets practice activity. Students recorded data, formatted the data, created custom formulas to calculate speed at certain points, and created graphs of movement. At the end of this activity, students reflected on their learning in this Unit by using FlipGrid and discussing what they already knew, the coolest "tricks and tips" they learned, and advice they would give to other students learning how to use Google Sheets.

Finally, we returned to Google Sheets after learning how to use Google Forms to create a survey. Students shared their surveys with peers and provided peer feedback on the creation of their surveys. Students then used Google Sheets to format and analyzed their survey results.

Learning Targets:

• Learn about spreadsheets and basic functions.
• Locate and name a cell and cell range.
• Use the toolbar to format work.
• Analyze data
• Create charts and graphs.
• Use ready-made and custom functions
• Cross-curricular connection-Science.

Tech Tool(s):

• Google Slides
• Google Forms
• Google Sheets
• Nearpod
• Screencast-O-Matic
• Quizizz
• Kahoot
• Flipgrid

SAMR:

Augmentation

• Students used spreadsheets to collect and analyze data.
• Kahoot and Quizziz were used as a substitute for formative assessment throughout the unit.

Modification

• Screencast-o-matic and Google Slides took the place of direct teaching, allowing students to work through lessons/activities at their own pace.

Redefinition

• Students used FlipGrid to produce short videos to share their learning and tips for other students.

5 C's:

Collaboration

• Students worked in teams during Kahoot and Quizziz games to discuss and come to a consensus for the answers.

Communication & Creativity

• FlipGrid allowed students the chance to communicate their ideas with their peers in a fun and creative way.

Critical Thinking

• Students connected their recent learning in their Science class (Physics) and their learning in Tech Apps by using lab data to practice recording, analyzing, and drawing conclusions about data.
• Students participated in a self-assessment and reflection using a Google Form at the conclusion of the unit.