Thursday, June 8, 2017

Spreadsheet Fun in First Grade

First grade math standards ask students to organize, represent, and interpret data with up to three categories; ask and answer questions about the total number of data points, how many in each category, and how many more or less are in one category than in another. CCSS.MATH.CONTENT.1.MD.C.4

Recently, I visited a first grade class where we worked on some graphing and data fun using Google Sheets!


We started by taking a whole-class poll through a Google Form, through which we learned that CHOCOLATE was the favorite flavor. The students each used their Chromebook to vote on the form, which had been posted in their Google Classroom.

 

The students were excited to see their results instantly! Because they had voted, the data was meaningful and relevant to them! We had a discussion to dive into the results just a little deeper. We discussed a friend who was absent, and what the implications for the data would be depending on his vote. “What if Miguel voted for….?”

Next, I modeled how to enter our ice cream data into this spreadsheet template that is already set up to show results as both a bar graph and a pie chart. I showed how I could enter our vote totals into each of the cells, and how the charts adjusted automatically. Modeling is essential when working with little learners. They CAN do it! It just takes practice!

Blank Template

Our Ice Cream Data

Once I had modeled the process, we shared the template to Google Classroom. First the students replicated the model by using our class ice cream data. Then we started experimenting with the numbers. For example, I asked, “What if 100 people voted for chocolate? Predict how that graphs will change.” This kiddos enjoyed playing with the numbers and watching the data adjust on the graphs. This allowed them to further develop number sense as they witnessed that bigger numbers make the graphs grow larger.

Now YOU try it!

Pairs of students were tasked to develop a unique question to ask their peers. Some examples of the questions they created:

  • What is your favorite pet?
  • What is your favorite Pokemon Character?
  • Which is your favorite Superhero?

ELA Standards, including writing and speaking, were reinforced in this Math activity, as students had to develop their own questions and ask them aloud to their classmates.

Once we had all voted on each other’s survey, the students entered the data they collected and created their own graphs using templates linked in their Google Classroom. Because they are naturally curious, it didn’t take long for the students to click around to customize colors and other settings in their charts.






The kids had so much fun. The math conversations were amazing! I can’t wait to see what else these little learners will do with spreadsheets as they continue to develop their skills.



Tips for Little Learners:

  • Don’t hesitate to use proper spreadsheet vocabulary, including “rows”, “columns”, and “cells.”
  • Model, model, model! 
  • Use Google Classroom to distribute the templates.
  • Pair students up as necessary to maximize success for all! 


The links below will create your OWN copy of the templates we used. Feel free to use, modify, and share!

Google Forms and Spreadsheets with Second Graders: Representing Data

The Second Grade Common Core Math standards ask students to create picture and bar graphs to represent data sets with up to four categories. (CCSS MATH 2.MD.D.10)

Drawing bar graphs is plenty fun, but we decided to kick it up a notch and create some bar graphs in Google Spreadsheets!



We started with a simple question from the whole class:

What is your favorite color?

All students voted by hand and then we worked together to make a bar graph of the results on the Promethean board.

The students then logged into their Chromebooks and used the same data to create a graph on their own spreadsheet.




Here are the steps for creating a bar graph in Google Spreadsheets:










So that was all fun, but now it was time to go even further! Students each wrote their own survey question and then created a one-question Google Form to collect their data. They pasted their form links into a Google Classroom announcement so all students could fill out each others' forms. After, they used their survey data to create individual bar graphs in Google Spreadsheets.





The students learned so much! And guess what? They wanted to repeat this project over and over again. Oh darn, the students want to take surveys and make graphs to represent data. I suppose we can let them!



So many people are terrified of spreadsheets, but this project proved that everyone has to start somewhere, and why not in second grade?!?!  By giving students a relevant purpose and some basic guidance through the tools, they can accomplish amazing things!

Even our youngest students can create using Google!

Saturday, February 25, 2017

Dr. Seuss, BreakoutEDU, Chromebooks, and First Grade... OH MY!

My title in my school district is technically "Instructional Technology Coach." But based on how I've spent a lot of my time this year, I should probably be called the #BreakoutEDU Coach. I've now had the pleasure of sharing BreakoutEDU with over 1400 different students, and many more than once!

Really though, I do want to retitle myself as the "Innovative Learning Specialist," because it covers all the random things I do and because it certainly doesn't always take a computer to innovate in the classroom! #jobgoals

Since I am the Tech Coach, I often do feel like I need to try and spread technology fairy dust everywhere I go. This week, I worked up some puzzles and clues for a Dr. Seuss-inspired, technology-enhanced BreakoutEDU game for Read Across America next week. I included multiple activities that would require the students, even kinders and first graders, to log into their Chromebooks to solve their puzzles and clues.

Some of the tasks for this game were inspired by or copied from the existing Dr. Seuss Breakouts In the BreakoutEDU collection by both Knela Newton and Patti Harju. This Breakout we are doing is the ULTIMATE Dr. Seuss mashup! I love how willingly everyone in the BreakoutEDU Facebook community shares their resources! I will try my best to give credit to the borrowed items.


It all starts with this letter from Thing One and Thing Two:

Letter by Knela Newton

Those silly little dudes STOLE the Cat's Hat and LOCKED it in the Breakout Box! We have to get it back to him!

The QR code leads to a YouTube read aloud that isn't necessary for the game, but is a good distractor :)

I changed up one of the tasks from the original lost hat game to include these apples in honor of the Seuss book, Ten Apples up on Top. I cut the apples out individually and spread them around the table. The number of apples indicated the 3-digit combo to the small lock box. For the first graders, I also included the three colored circles and taped them to the box as a hint for the order of the apple numbers.



Inside the small lock box, there was a UV flashlight, a strip of paper with a website link for a later task, and a Seuss ABC chart to solve the next puzzle, which was inspired by a couple of Patti Harju's games. 

Inspired by the "old snowman" puzzle by Patti Harju. 

I wanted to make sure the text and task were appropriate for the little ones, so I only had them decode part of this message: Oh a place you should look... is in a book! I put a key to a key lock inside of a copy of The Cat in the Hat which was hidden nearby.

Also inspired by Patti Harju

To bring in some technology, I put an image of the Google Classroom logo on the table to indicate there would be a clue linked from Google Classroom. 



Those first graders sure knew what that symbol meant! When they got to their Google Classroom, they found a link to this puzzle at Jigsaw Planet. Find it here: goo.gl/TFNfgq

From jigsawplanet.com

The first graders frequently use the website PebbleGo.com for researching everything! This is a paid subscription, but it's a great, safe place where little ones can search and learn. The first graders knew that Pebble Go would be the perfect place to find the answer to the question on the Jigsaw Planet puzzle. Those first graders browsed to that familiar website, typed in the keyword SEUSS, and found the information they needed about when Dr. Seuss was born! The year of his birth opened a 4-digit lock.

Screenshot of Pebble Go by Capstone


For the answer to the directional lock, students had to solve this maze. I made this puzzle some time ago and don't remember if the maze came from another Breakout. I can't seem to find it anywhere to give it credit! I know I added the Seuss images. This maze requires seven directions, so the new multilock won't work. You'll either need a regular directional lock, or perhaps you can adapt the maze? Maybe you can start the students off by drawing in the first two legs of the route, and then they need to draw the other five. Their drawings would be five directions, which would fit on the multilock.



We used one of the posters from Patti Harju's game, Oh the Places You Will Go! I wrote the word AUTHOR on the poster in invisible ink. Without fail, the students always first try to spell out AUTHOR on the 5-letter lock. Once they realize they don't have enough letters to spell out that word, they usually come to realize WHICH author we are talking about!

Poster and task by Patti Harju
I put this crossword puzzle out on the table as a distractor with some kids, and had to use it as an alternative task for the older kids because many of them had already played Oh the Places You Will Go. I highlighted five random letters from the puzzle solutions as the combination for the five-letter lock.



Since we have played so much BreakoutEDU this year, I have purchased some additional locks along the way. One of those locks is a 4-letter lock. I used the copy of a page from Knela Newton's game and highlighted the letters R-E-A-D randomly on the page. Even the little ones were able to put them together to open that 4-letter lock!

Clue by by Knela Newton

The last puzzle is for our 5-digit locks, but could easily be adapted to be used with a 4-digit lock. The website link that was in the small lock box reads http://tinyurl.com/SSseuss and will take students to a force-copy link of a Google Drawing. If kiddos are logged into a Google account, the item below will appear, and they can drag the character images into the table. The students should use the rainbow clue on the page to determine the order of the numbers. So far, the rainbow hasn't been anyone's first guess! They usually try to put them in by value from smallest to largest. I added a sixth unnecessary image to keep the students on their toes!

Google Drawings Rainbow Sequence

This Breakout has SEVEN LOCKS! The kids did amazing though, and all of the groups broke out in under 45 minutes. I tried this game with first graders, fourth graders, and with kindergarteners this week, and have a long list of classroom visits planned for our Read Across America celebration next week! 



My messy collection of resources for this version of the Dr. Seuss games can be found in one doc here: goo.gl/j0PYDJ. Find Patti Harju and Knela Newton's original games at BreakoutEDU.com.

See my previous post, Little Learners Love BreakoutEDU, for tips and tricks about using BreakoutEDU with primary-aged students.