Monday, January 21, 2019

Make your spreadsheet do the hard work for you in your data collection

On January 8, 2019 I created a blog post about "How to use Google Forms and Wakelet to take your data collection to the next level".

In this post you will take that data and have the spreadsheet do the work for you.

I decided to use numerical data in my example. I used 1 for yes and 0 for no. This could then be calculated in a numerical form later on using the average function.

In the 1 minute and 47 second video embedded below you will see how to take the spreadsheet that the Google Forms collects and then select a cell (somewhere you feel appropriate). In this example I used averages for the data collection.

  • In the sheet select Insert > Function > Average
    • Make sure to select the cells you want to include
      • Even include future dates as the sheet will collect your data for you

Take care,
Brad

No comments:

Post a Comment