My fourth grade class reviewed data landmarks this week.  On Monday the class explored examples of the maximum, minimum, median, mean and mode.  I had to review the terms multiple times throughout all of Monday.  Kids kept on asking about the difference between median and mean.  During this process I was finding that students needed additional practice with the terms.  They seemed to need another way to remember the difference between the data landmarks.  After contemplating a few different review lessons I decided to check out my school’s laptops.  I vaguely remember reading about a teacher that used spreadsheets to reinforce math terms.  I decided to go that route for Tuesday.

So Tuesday arrived and students received their laptops.  I modeled the different components of Excel.  This took more time than I thought it would.  I reviewed the idea of a cell and the components of a spreadsheet.  During this time I had a lot of hands fly up in the air with questions.  The questions revolved around how to change the column/row size, what a cell is, where’s the formula bar and many others.  To get the ball rolling I had the students take some personal data and use it for this project.  The class formatted the spreadsheet and we were about ready to start putting in formulas and then … class ended.

We started back up on Wednesday and began the lesson by explaining how to use formulas in Excel.  I modeled the first formula of how to find the maximum of the data set =maximum(b2:b14).  Students followed the example with their own data.  We then moved on to minimum, which they easily constructed.  Median and mean were a bit more challenging but the students explored and found the formulas using the first example. The magic started when students were asked to manipulate the data in the non-formula cells.  Students started to observe how the data landmarks change when the data changes.  This sparked a classroom conversation on the difference between the mean and median and which indicator might represent the data better.

Afterwards, students were able to print out their creation and take it home.  The class will be discussing this in more detail next week.

## Author: Matt Coaty

I've taught elementary students for the past 14 years. I enjoy reading educational research and learning from my PLN. Words on this blog are my own.