Like pretty much anything good I do in my Algebra class, this is simply a slight modification of something someone else has created - in this case, Dan Meyer. Please go read his post - and the comments - for all the goodness.
But let me briefly summarize the activity here. Students go to United Airlines' website and select one-way, non-stop flights to a variety of destinations from Denver. They then collect some information about those flights, including time, distance and cost. They then create a time vs. distance graph and a cost vs. distance graph. We then talk about lines of best fit (just eyeball at this point of the course), come up with an equation in slope-intercept form, and then talk about what the slope means and what the y-intercept means in each graph, as well as why the time vs. distance graph appears to be a much better linear fit than cost vs. distance. (More discussion of that in Dan's original post if you're interested).
The modification I made from Dan's original idea was using Google Drive instead of Microsoft Excel, and having the students collect the information outside of class so we could use class time to discuss. So I gave them these directions and had them make a copy of this Google Spreadsheet, then share it back to me (this allowed me to copy and paste their data and come up with my own graphs with more data points than the 8 flights they had to do). I also had them print out their graphs so that it was easier to sketch a line of best fit.
My hope is that this would provide students with a reasonable real-world application of slope-intercept, allow them to work with some actual data that they collected, and allow us to discuss the meaning of the slope (rate of change) and the y-intercept in context.
What do you think?
- Can you see using this in your Algebra classroom? Why or why not?
- Is there anything you would change (add, remove, modify) to make this better or to extend it?
- Can you think of other topics in Algebra 1 where we could do something similar with Google Drive/Data Collection/Graphing/etc?


