Skip to main content

Using Spreadsheets for Life Decisions

The best projects build current content on previous units and have an application that carries beyond the classroom. Occasionally, I create a culminating unit project that gets it right. 

We just finished a unit on spreadsheets: everything from basic construction to formulas and graphs. For me, the point of spreadsheets are to make sense of data collected. 

Organizing, sorting and charting helps us see the picture through the volume of data. This naturally leads to reporting what we find in the data. Without application, without impacting change, the data loses its meaning. 

"Truth that is learned but not applied, forms callouses on the soul."

This project asks students to compare five colleges in a total of nine areas. The way the data is organized and presented is intentionally left up to their discretion. This gives students the thrill of discovery. The focus is not on getting it right but telling the story. By pulling the data from their personal choices, they begin to tell their own story.

My favorite part of the project is involving parents. What an opportunity for parents to engage their child in a discussion about choosing a college. By grounding choices in data, much of the disagreement looses its emotional punch. Parents can look at the same data and come up with a totally different interpretation, which helps students see different perspectives.

The College Comparison Report is available on Google Drive. Feel free to make a copy and tweak it for your classroom.

Popular posts from this blog

Classcraft Interactive Notebook Page

Finished crafting interactive notebook pages for Classcraft, an engaging classroom management tool.

This fall I plan to add interactive notebooks to my classroom procedures. The goal is to provide students with something tangible to take home at the end of the semester. So that means creating or borrowing resources to guide students in developing their notebook.

Classcraft is a classroom management tool, an elaborate punishments and reward system designed like an epic role play game. Students create avatars and can upgrade pets and outfits based on experience and gold points earned. They can also lose points and suffer minor penalties. Everything is done in a fun, game like environment.

The computer lab is already divided into five or six stations, which lends itself easily to guilds or teams of students who work together in the game. I want students to develop their own backstory and choose their characters for the good of the group. I also need students to keep their login info some…

Exploring Science and Math through Music and Messes

If you have ever seen a music video by the music group OK Go, you know that they enjoy experimentation and quirky effects. Now all that energy is available for teachers in the classroom, with maybe slightly less mess.

In cooperation with Google and Morton Salt, they have produced a set of three STEM related lesson plans complete with tie-ins to their most popular videos. You can get your hands dirty in this wonderful playground at the OK Go Sandbox.

Lego Mindstorm Maze Runner

Students were tasked with writing a program for their robot to successfully navigate a preset maze. This used only directional command blocks (no sensors). The goal was to recognize sequencing, patterns and to become comfortable with testing and making modifications based on test results.