A little Google docs win – almost

Today I played the Deer Game with my grade nines to illustrate population dynamics, limiting factors and carrying capacity. We usually iterate a dozen or so times, counting and recording the dear population on each turn, and then enter the results on a spreadsheet and graph it when we get back to the classroom.

Well, this year I did something a little different. I created a Google sheet, and created a chart based on a set of (presently empty) cells. I left this display up in the classroom when we went outside. During the game, I recorded the results each round on my phone, in the same spreadsheet. So when we wrapped up and went back to class the graph was already waiting for us on the screen. As a bonus, we ran this activity with two classes combined, and both classes could see the same data.

This was a great little timesaver, and I would rave about it, except for one little thing – scatter plots. The scatter plots in Google sheets do not show connecting lines or curves, just the scatter points. For this activity a line graph is sufficient, because we are iterating equal intervals, but uncovering a glaring hole in the capabilities of Google sheets slightly tarnished my esteem for this set of tools.

Leave a Reply