Data Landmarks and Spreadsheets

screen-shot-2016-09-30-at-8-48-43-pm

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.

screen-shot-2016-09-30-at-8-45-26-pm

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

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s