Three simple tips for working with data in Google Sheets

We can get frustrated with spreadsheets because they don’t do what we want them to do, or we just think that they are used by statisticians. With more data around than ever before, especially in schools, it can be hard to use the data well. Here are three simple tips for working with data in Google Sheets that allow you to be able to analyse and display your data like an expert.

Three simple tips for working with data in Google Sheets that allow you to be able to analyse and display your data like an expert.! Click To Tweet

 

1.Automatically suggested formulas

This feature will automatically suggest simple formulas to use based on the data you have entered when you hit the ‘=’ key. Currently the only functions that appear are sum and average, which are used frequently by students when they are measuring data. Watch this short video to see how to use this feature.

Google Sheets

2.Creating and embedding charts

It is easier to ‘see’ what is going when data is presented graphically. Just highlighting the data and selecting Insert -> Chart will put a chart on the sheet. It is possible to change the chart type and customise it by using the chart editor. Watch this 2 minute video to see how to create and edit a chart.

Often we use data in a presentation or write up. In a classroom, it may be data collected via a form that the whole class contributes to, and as a teacher you want students to complete an individual write up. This can be done by linking or embedding the chart in a Doc or Slide. The great thing is that it will update in the Doc or Slide as the data changes. This can also be turned off so that the analysis doesn’t have to be adjusted. Watch this short video (1.5 minutes) demonstrating how to do this.

3.Using Explore

This tool is just getting better all the time. Not only can it assist in helping analyse and display categorical data (which often students collect), but it will help you find answers to your data when you type in a question. This is super handy when you have a lot of data and you don’t want to spend time cleaning and isolating what you are looking for.

The Google Sheets Explore tool is super handy when you have a lot of data and you don’t want to spend time cleaning and isolating what you are looking for. Click To Tweet

 

Another fantastic feature is that Explore also shows you the formula it uses to find your answers. This way you can use and adapt the formula for other sheets you may have, or if you want to impress someone with your spreadsheet ninja skills! This short 3 minute video shows how to access Explore and use some of the functions. The demonstration sheet be accessed here.

These three simple tips for working with data in Google Sheets allow you to tap into the features of Google Sheets and help you start to master the data you have.

Do you want to learn even more G Suite tips and tricks? Join our online professional learning community.


Skills Checklist Will Help You Find Out.

Download Free Guide

Latest Blog Posts, New Tips And Tricks

Sign Up Now

5 ways to develop creative STEAM projects.

It is possible to deliver a STEAM project to students which kills creativity. Without significant and purposeful learning design STEAM learning can inhibit the very things we are trying to support students to develop. Here are five tidbits of thought to help you think critically about STEAM and creativity.

VIEW POST

UTB Newsletter 2020 – Issue 4

Flying through April and super excited to be bring you the latest updates, tips and tricks.
As always, we’re delighted that you choose to read our newsletter each fortnight – thank you! We hope you find something useful in each issue.

VIEW POST

UTB Newsletter 2020 – Issue 10

October – wow! How did that even happen? Our team continues to be blown away by the dedication and hard work of educators all around the world, working in a multitude of ways to support their learners whether they are online or face to face. The capacity and willingness of so many teachers to throw themselves out of their comfort zone and not only learn, but put into practice new skills, is a credit to the education community.

VIEW POST

Here’s What
Our Clients Say

PR Industrya

Client

In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices

VIEW FULL CASE STUDY

FREE PDF DOWNLOAD

Are you at a beginner, intermediate, or advanced level? This skills checklist will help you find out.

×

FREE PDF DOWNLOAD

Are you at a beginner, intermediate, or advanced level? This skills checklist will help you find out.

We will only send you awesome stuff!

×

Download your skills checklist to see how you score...