Use this Google Sheets template with Kindergarteners to explore graphing. Students use physical manipulatives to count and then represent the number in a graph.
This template has 4 graphing templates. Choose the template you want to use with students. Use the Add-ons menu to choose “Counting Activity.” Press the button for the template you would like to use. The other templates will be hidden and 5 copies of the chosen template will be created.
If the students are not counting bears, adjust the template before pressing the button in the Add-on sidebar. The picture can be changed by locating an image on the internet. I used cloudclipart.com to get the pictures of the bear. Right-click on the image and choose “Copy image address.” In row 14 replace the formula =image(“URL”), replacing the previous image address with the new one you obtained.
2. Pictochart with a Warning
3. Mark and Create
The third template has the student create the bar graph. Students can type anything into the cell to fill the cell with color. Work with students to start at the bottom in row 11. The cell shows what they used as their marker. For example, I was typing an x to fill in the cell, the x is visible.
4. Mark Invisibly and Create
5. Graph the Weather
Use this spreadsheet template to have students chart the weather.
Students mark anything into the cell to create a colored block. The font and the background color match to make the mark invisible.