Time flies

I had forgotten about this activity until I checked into this infographic.

Selection_003

The complete infographic and the story behind it is available at

How the Average Working Adult Spends Days.

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.

Selection_006

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.

Google Sheets

From the Insert Menu, select your data, select Chart, and then decide what type of chart would be represent this data.

Selection_004

Excel Online

The Insert menu flies out a number of options.  Don’t forget that, under each type, there are a number of additional options.

Selection_007

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.

Advertisements

2 Replies to “Time flies”

  1. This might also make the passage of time more concrete. I remember that elapsed time was a very hard concept for most Grade 5 students to understand. I wonder if this would help. Thanks Doug!

    Aviva

    Like

  2. P.S. The infographic wouldn’t display properly for me when I initially commented, so I thought the time was tracked by hours. I wonder if it still could be though, and then people could look at trends over the course of a day. This would help with elapsed time as well as the interpretation of data.

    Like

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