Monopoly 2014

In the board game, Monopoly, does a property’s distance from GO correlate to its rent when you land on it ?

Using Brian’s spread sheet (list of properties, distance from GO, rent and rent with properties) students create scatter plots.  They graph points, draw lines of best fit, find average (X ,Y) values, judge outliers, and make predictions about new properties.

As the teacher, you can choose to assign this activity to be done by hand or to be completed with the tools and skills of manipulating Excel spreadsheets.   (Question 8 on the Word document uses property names that are related to our room and our school in Newton. You can easily change the document to relate to your room and school.)

monopoly2014.pdf

Activity as questions and separate Excel data:

For member we have solutions and an editable Word doc:

CCSS: 5.G., 6.SP.3, 6.SP.5, 8.F.4, 8.SP, S-ID

Share

1. February 12, 2015 at 10:11 am

I have never had such quick success with so little effort (on my part) with constructing & understanding line of best fit, correlation and using functions to make meaningful predictions. All seamlessly embedded into one rich lesson. And students are now intrigued by the power of Excel.

• March 7, 2015 at 8:44 am

Great to hear Dawn. We are glad they liked the activity and that students are appreciating Excel. 🙂

2. Jenni
December 14, 2012 at 12:49 pm

This is quickly becoming one of my favorite websites. This project is outstandingly done and I really enjoyed reading about it. I would use this in my class in the future, hands down. Thanks for sharing your wonderful ideas!!

• December 17, 2012 at 8:13 pm

Thanks for the feedback Jenni. Hope you and your students find the activities interesting and useful! 🙂

3. December 12, 2012 at 12:49 am

This is my new favorite problem-based lesson for teaching scatter plots. Thanks for sharing!

• December 13, 2012 at 8:28 am

Thanks Robert! And let us know if you have any great ideas to add to this activity!