K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
Spreadsheets
iPad Classroom Tech Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple Mac Keynote Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

Google Classroom - Favorite Ice Cream Tally and Chart

Students Create a Chart of Favorite Ice Cream Flavors

Scenario:Teacher polls students with a show of hands of their favorite ice cream flavors.

Teacher takes a tally using the Google Classroom compatible tally sheet provided and shares the results with the students.

 

Assignment: Students create a simple spreadsheet and chart using the free Google Sheets template and ice cream tally results to illustrate their choices.

 

Grades 2+

 

 

Usage: Teachers download the files and make personal copies for themselves, then share the files with students as needed using Google Classroom or a Google Drive shared folder.

 

Download: google-sheets-favorite-ice-cream-chart-template

 

Download: google-sheets-favorite-ice-cream-chart-finished-example

 

 

 

Download: google-sheets-favorite-ice-cream-tally-sheet

 

Download: google-sheets-student-instructions-creating-a-simple-chart

 

 

Google Sheets - Simple Pie Chart Template

Download and share this Google Sheets template with students. Students enter their own title and spreadsheet data. Students create a chart using their data. Students add a relevant picture.

Google Classroom - Favorite Ice Cream Flavors Chart Template

 

 

Google Sheets - Favorite Ice Cream Chart - Finished Example:

A finished copy for teachers to download and use.

 

 

Favorite Ice Cream Flavor Tally Sheet

Download the tally sheet and poll students with a show of hands of their favorite ice cream flavors.

Google Sheets - Favorite Ice Cream Flavor Tally Sheet

 

 

Student Instructions: Google Sheets - Creating a Simple Chart

Download and make these instructions available to students to guide their Google spreadsheets creations. These instructions cover the basics of entering and formatting a chart title, entering data, and creating a chart.

Google Sheets - Create a Simple Chart

 

 

Google Sheets Video Tutorial - How to Make Your First Chart

Learn how to create a simple google spreadsheet with a chart. This video covers the basics of entering and formatting a chart title, entering data, and creating a chart.

Time to Learn = 75 seconds