Data, charts and Sheets, oh my!

Google Charts video tutorial

Scroll down for video tutorial

Information and communications technology (ICT) skills are these days found across curriculum areas in education throughout the world. Much of the focus is on literacy based applications such as documents, presentations, etc. This is partly because these applications  tend to be much easier for educators and students to learn how to use.

The representation of numeric data using technology is sometimes overlooked in the classroom. There are many subject areas in K-12 education that benefit from the use of technology to represent data including:

  • mathematics
  • science
  • social studies
  • geography
  • design and technology
  • business, economics and commerce

Charts and graphs can be a powerful tool to visually represent numerical information.  For some educators and students, the idea of working with data is intimidating. The good news is, it doesn’t have to be.

Tools like Google Sheets, part of the Google Apps for Education and Google Drive suite of products, make it easy to create attractive, easy to read charts and graphs from your data.

The video tutorial below shows how quick and easy it is to create a chart in Google Sheets. The topic area is a social science subject, geography, and representing contributions to population changes across Australian States. And it all happens in just under 4 minutes:

Note:

At the time of writing, you will need to use the full, Chrome browser based version of Google Sheets in order to insert and edit charts. You can view them on the portable version of Google Sheets but you cannot insert or edit charts in these versions.

Did you find this article useful? Why not share it!

One thought on “Data, charts and Sheets, oh my!

  1. Nice job and Google Sheets is so Excel-like!

    Take your spreadsheets even further by considering data pooling with student activities, see “Oh Sheets!: A Tool for Online Collaboration in the Cloud ”

    Thanks,
    Scott

Leave a Reply

Your email address will not be published. Required fields are marked *