Google Sheets

THE WHY

Google Sheets Links to an external site. provides an opportunity for students to apply critical thinking while analyzing and evaluating data. Students can use digital tools to represent the data in creative ways, sorting and filtering the data, and designing graphs. They can draw conclusions, make predictions, formulate their hypothesis, and experiment with the data. Using Google Sheets provides the opportunity to foster digital literacy.

Since the spreadsheet can be shared, it can support collaboration and communication. The ability to publish a spreadsheet can give students an authentic audience of learners and experts outside of the classroom. The comment feature facilitates feedback.

THE WHAT

Learning Outcomes

1. Instructors will use Google Sheets in their lessons.
2. Students will use Google Sheets to demonstrate their learning.

Classroom Application

Browse these ideas and start to formulate a plan for using Google Sheets in your classroom. If you are new to Google Sheets, look at the Basic section. If you are an experienced user, check out the Advanced section.

Basic

• Graphing Counting Bears with Kindergarteners Links to an external site. 
• Skittles and Measures of Center Links to an external site.
• Evaluating options: Sheets are a great tool to teach problem-solving or critical thinking. Using the native formulas, students can statistically evaluate most number-intensive options, like when developing a budget. 
• Graph the Weather Links to an external site.: Template Links to an external site. and Tutorial Links to an external site.
• A Student's Guide to Using Sheets Links to an external site. and how to use a sheet to have students submit answers to which you can easily leave feedback.
• Create and Graph in Google Sheets Links to an external site.: Google Sheets templates allow students to manipulate items in a Google Drawing, graph the items they manipulated, and complete sentence frames.

Advanced

• Student Built Learning Databases Links to an external site.
• Models and Equations in Google Sheets Links to an external site.
• Battlesheets! Links to an external site.
• Pixel Art Activities for any Subject with Google Sheets Links to an external site.
• Discovering Pi with Google Sheets Links to an external site.
• Random Writing Prompt Generator with Google Sheets Links to an external site.
• 5 Great Google Sheets Add-ons for Teachers Links to an external site.

 THE HOW

Use these resources to learn about Google Sheets, watching and reading just what you need to implement Google Sheets in your lessons.

Google Workspace Learning Center

Google Workspace Learning Center: Google Sheets Training and Help

Google Sheets Tutorial 2017

Additional Resources

• Google Sheets Cheat Sheet from Shake Up Learning  Download Google Sheets Cheat Sheet from Shake Up Learning 

• Google Sheets Help Links to an external site.
• 27 Incredibly Useful Things You Didn't Know Google Sheets Could Do Links to an external site.

Using Google Sheets in Canvas and Google Classroom

• Google Assignments LTI 1.3 Links to an external site.
• How to embed Google apps into Canvas Links to an external site.
• How materials are shared in Classroom Links to an external site.

EARN THE BADGE

See the attached rubric to know how your submission will be assessed (click 3 dot Options menu at the top and choose Show Rubric). To earn the badge, you must obtain 6 of the possible 7 points.

1. 1. Design a lesson in which you apply what you have learned for use in your classroom, either by using Sheets yourself for instruction, or by having your students use it. See the Designing Tech Amplified Lesson for guidance on creating a lesson plan that uses digital tools.
   2. Click Reply below and reflect on your lesson. In your reply include:
      • Did students demonstrate understanding of the learning target? If yes, how? 
      • How did the use of Sheets amplify your lesson? Did it add value to the learning goal though engagement, enhancement or extension? Did it make you or your student more efficient and effective?
      • If you had the opportunity to teach this lesson again to this same group of students, what would you do differently? Why?
      • In your reply, you can choose to share an artifact or your lesson plan in the form of a shared link, screenshot (Links to an external site.), attached file (Links to an external site.), or embedded image (Links to an external site.). This is not required.

Once you've posted your reply, you will be able to view posts from other teachers. Feel free to like or comment on others' submissions.