1 of 17

Education on Air

Awesome Assessment with Awesome Tables

Chris Webb

Education on Air

Education On Air

2 of 17

James Petersen

Montreal, QC. Canada

www.opensourceteacher.ca

Education On Air

3 of 17

Chris Webb

Montreal, QC. Canada

http://wwwebb.ca

Education On Air

4 of 17

Agenda slide

Introduction to Awesome Tables

Why Make Data Accessible?

Row Level Permissions

Deploying the WebApp

Publishing the Table

Education On Air

5 of 17

Intro to Awesome Tables

Education on Air

Education On Air

6 of 17

Google Edu on Air

What are Awesome Tables?

Speaker Name

Easy way to represent data on a Google Site

  • Searchable
  • Filterable
  • Access permissions

And we’re after…

  • Row level permissions

(Awesome)

Education On Air

7 of 17

Google Edu on Air

Why are they Awesome for Assessment?

Speaker Name

  • Students can access their row and only their row

  • Any data can be displayed

  • Live data from a Google Sheet

  • Students can see overview of progress

Education On Air

8 of 17

Awesome Table

Example of an Awesome Table with Filters

Education On Air

9 of 17

Deployment

Education on Air

Education On Air

10 of 17

Deployment

Google Sheet

Row 2 Table Config

Column 1 - Emails

Deploy via Drive

Create Table

Embed in Site

Markbook

WebApp Proxy

Awesome Table

Published View

Education On Air

11 of 17

Google Edu on Air

The Gradebook

Speaker Name

Row 2 are the Awesome Table Filters

Column 1, Row 2, must be Permissions - Hidden

Important Info

Education On Air

12 of 17

Gradebook

Filters & Configuration for Proxy

Education On Air

13 of 17

Resources

Education on Air

Education On Air

14 of 17

Google Edu on Air

Resources

Speaker Name

Proxy Script:

http://bit.ly/AwesomeProxy

Sample Data:

http://bit.ly/AwesomeData

Google Site:

http://bit.ly/EduOnAir16

Step by Step Instructions

http://bit.ly/AwesomeGradebook

Education On Air

15 of 17

Questions?

Education on Air

Education On Air

16 of 17

Q&A

Education on Air

Education On Air

17 of 17

Thank you

@crippit

+ChrisWebbYUL

wwwebb.ca

g.co/educationonair

Receive credit for required PD hours by filling out the form at: [link coming soon]

Education on Air

Education On Air