Valentine’s Day Projects

Using Excel

This lesson can be easily adapted for any grade level. I decided to do it with my third graders. Each student (or student pair) will get a box of conversation hearts. They will make a prediction of what color is represented the most. Teacher can make a word cloud at http://www.wordle.com/ and/or using Google document students can type in their prediction. The collected data can be used in various ways. Also, students will make a prediction before the box of candy is opened of how many colors are respectfully represented in the box. After the students open the box they will sort the colors on the sheet of paper by color to create a bar graph. They will then count each color and record each color total in the Conversation Hearts Graph in Excel or other spreadsheet program or online tool. They will compare their real conversation hearts graph on paper to the one created in Excel or other spreadsheet program or online tool.

Using PowerPoint

The students can create a slide show of the different things that they love.