1 of 19

Evaluating Data:

Utilizing Google Sheets and Add-ons to make data matter

Google Track iTECH Class Level 2

Attendance- goo.gl/uF34AL

2 of 19

Class Objectives

  • Analyze graphs from data
  • Sort and filter large amounts of data
  • Explore using Pivot Tables
  • Use Google Add-ons to Enhance your Spreadsheet
  • See how data can inform classroom practices

​

3 of 19

Digital Citizenship

Permanence

of online activity

​

Think before you share student data, including grades, online.

​

4 of 19

Evaluating Data

Collecting and evaluating data using a Google Spreadsheet can help you make data-driven decisions.

Example Chart 1

​

Example Chart 2

​

5 of 19

Evaluating Data

Using a Spreadsheet to generate a class discussion:

Example Spreadsheet

​

Find the tabs at the bottom of the Spreadsheet labeled Class Discussion Chart #1/ Class Discussion Chart #2

​

6 of 19

Make a Copy

Make a copy of the

Example Spreadsheet

​

The Example Spreadsheet was created using a Google Form to collect answers to a quiz and then installing the Add On - Flubaroo

​

​

7 of 19

Classroom Applications

  • Spreadsheets can be used to collect student data, such as grades or quiz responses

​

8 of 19

Sorting and Filtering

Sorting: You can sort a range of cells according to rules set for one or more columns

Filtering: The filter feature in Google Sheets makes it easier to analyze and view your data by hiding the data that you temporarily want to take out of view.

Conditional Filtering: Use conditional formatting rules to get a visual summary of complex or changing data. You can format cells to change the text or background colors if they meet certain conditions, for example if the cells contain certain words or number.

9 of 19

Conditional Formatting

  • Use conditional formatting to highlight correct answers for each question
    • highlight column, select conditional formatting

10 of 19

What are Add Ons?

  • Extends the power and functionality of Google Sheets, Forms and Docs
  • Program written with code similar to Java Script
  • Created by third parties
    • Read the Terms of Use carefully!

11 of 19

How do I install an Add On?

  • Open a Google Doc, Sheet or Form
  • Different Add-ons for each
  • Add once - available always

12 of 19

Add Ons in Google Sheets

Flubaroo

Flubaroo is a FREE add-on to Google Forms/Sheets which lets you quickly grade and analyze student performance on multiple choice and fill-in assignments.

​

Flubaroo works in conjunction with a Google Form.

​

13 of 19

Add Ons in Action

Click here to participate in a demo of Flubaroo

​

Flubaroo tips:

  • Include questions asking for first and last name. Student username is IDnumber@ccpsnet.net
  • Fill in the blank- use %or to accept multiple answers
  • Use %to to accept a numerical range.

​

14 of 19

Add Ons in Google Sheets

GClassFolders

gClassFolders (gCF) helps teachers manage digital classroom workflow when using Google Apps with their students. It does this by creating folders with specific permissions. Each Classroom will be setup with:�~ “Assignment” folders, �~ “Class Edit”, �~ “Class View”�~ “Teacher” folder�Once the folders are created teachers can manage students and distribute files.

​

15 of 19

Add On in Google Sheets

Doctopus

gives teachers the ability to mass-copy (from a starter template), share, monitor student progress, and manage grading and feedback for student projects in Google Drive.

  • Works with GClassFolders

​

16 of 19

Do you want to learn another advanced feature?

Explore more on your own!

The next few slides cover using Pivot Tables in a Spreadsheet.

Please see your integrator if you have questions.

17 of 19

Using Pivot Table

A pivot table report is a dynamic table that lets you interpret data in different ways without ever having to enter a formula. Pivot table reports are particularly useful when you want to narrow down a large data set or analyze relationships between data points.

Creating pivot tables

​

18 of 19

More about Pivot Tables

  • Always organize your data into columns. Column headers become the fields that you add into your pivot table report.

​

  • You can create multiple pivot table reports from the same set of data. Simply go back to the data source and create a new pivot table report. It will create a new pivot table report on a separate sheet.

​

  • You can use pivot tables to generate graphs and charts

​

​

19 of 19

Classroom Application

Create a Leaderboard for your Class

with a Spreadsheet and Pivot Table

​

Identifying Struggling Students

with a Google Form and a Pivot Chart

​