Last week, I started several different spreadsheet activities with my 3rd, 4th, and 5th grade students. I was struggling to find topics and activities that would engage and excite my 4th graders.
I decided to create a story they would use to create a basic spreadsheet. What better topic to use than ice cream! Suddenly, the Ice Cream Mania story was born!
I created a Google Presentation that I projected at the front of the class. We read through it together as the students created their spreadsheets.
We talked about what information we needed to take from the story and how we could organize it in a spreadsheet.
Once the students had gathered their data, they learned how to use the Functions Button to have the spreadsheet create sums for the total.
Finally, we began working on the bonus questions. We decided to create a second sheet to use for that data.
It was fun to see the students get excited about the outcome of their spreadsheets and become really interested in the numbers and data!