Google Sheets is a powerful tool for the classroom, but can often be seen as intimidating and therefore may not be used to its potential for teaching and learning. The purpose of this session is to help educators feel comfortable and confident in their ability to use Google Sheets, as well as see a wide range of engaging educational activities their students can do with Sheets in their classes.
Details and examples of these use can be accessed at: https://docs.google.com/document/d/1uDTw5SoJex2oq72IQn2xYgRs--Pj8B9JOnQcj9bFYq0/edit
In this session we will explore the uses listed below:
Educational Games and Activities
Random Generator Activities
Conditional Formatting Feedback
The session will cover the following information. Note: live links to the resources referenced below can be accessed at https://docs.google.com/document/d/1uDTw5SoJex2oq72IQn2xYgRs--Pj8B9JOnQcj9bFYq0/edit
1) Analyzing Data - 20 minutes
In this section we will explore how students can collect real-world data and then analyze that data with Google Sheets tools including sorting, filtering, formulas, charts and graphs, conditional formatting, and more, to be able to identify patterns, draw conclusions, and make predictions.
2) Learning Databases - 10 minutes
In this section we will apply the same skills to non-numeric content, where students collaboratively create learning databases in Google Sheets where they research and record information about the content they are learning in class, then use inquiry to ask questions on the data and explore answers.
3) Educational Games and Activities - 15 minutes
In this section we will explore how teachers and students can use the free Google Sheets templates provided by Flippity to create interactive educational games and review activities, for individual and group review and interaction.
4) Random Generator Activities - 10 minutes
In this section we will explore how the randomizing tools in Google Sheets can be used to generate writing prompts for students to help them identify topics for their own writing including poetry, stories, and more.
5) Art Activities - 10 minutes
In this section we will explore how Google Sheets can be used for creative arts including such projects as digital pixel art and Mondrian art.
6) Tasks Checklists - 10 minutes
In this section we will explore how Google Sheets can help students stay organized and track their completion for classroom activities and projects with interactive tasks checklists.
7) Conditional Formatting Feedback - 15 minutes
In this section we will explore how Google Sheets can provide live feedback to students when they are practicing subject area skills. Through conditional formatting, Google Sheets can let students know when their answers are incorrect, and can provide support to help students learn and correct their mistakes.
Throughout the session, participants will be encouraged to test out the wide variety of sample Google Sheets templates, as well as create their own Sheets using the techniques demonstrated.
Several of the activities and approaches demonstrated in my session are listed as positive influences on student achievement in James Hattie's "Visible Learning" study including:
Providing formative evaluation
Technology in writing