I had forgotten about this activity until I checked into this infographic.
The complete infographic and the story behind it is available at
So, check it out to see where all those hours (days) went.
The activity? In an elementary or secondary school, it would just be a guess since students have a lot of living to do yet. Part of that living should be spent mastering spreadsheets and the features that they include. Certainly, one of the more helpful is to take data and visualise it.
Data? What data?
Each of the individuals in your class has a story to tell about their time. In the activity, we would create a column for the activity and then columns for the week. Data is entered daily in terms of hours/minutes. Just be consistent.
At the end of the week, it’s just a matter of tallying the rows to get a weekly summary. Then the fun begins. Are there any trends? Can we convert each activity to a percentage? Where do we spend most of our time? Can we adjust our lives to change the time? Can we collect to the data for the entire class to see where we stand in comparison? Are there any activities that are out of whack with a happy life? The list goes on and one.
Even more powerful that looking at the raw data is converting it to a graphic form. Your spreadsheet application has you covered nicely there.
From the Insert Menu, select your data, select Chart, and then decide what type of chart would be represent this data.
The Insert menu flies out a number of options. Don’t forget that, under each type, there are a number of additional options.
The possibilities and options are almost endless.
In addition to a discussion about things that students do and how they spend their time, there’s a wealth of spreadsheet understanding embedded.