Resources

readwhatyouwant.com/looker

Our current Exemplar Dashboard

I embedded this one so that you can see how it interacts
This dashboard is "filtered by email", so most data from the spreadsheet won't show up for you, since you aren't students from my school.
But you will see some of the data from the spreadsheet--all of the Exemplars themselves are pulled directly from each grade's spreadsheet.
If you do embed a dashboard, I have learned to grab the embed URL, not the embed code--it's much easier to manipulate and not set at a certain size.

Sandbox for today

Google Form for a basic reading challenge--make a copy

You'll need a Google Sheet, but you'll want to make it once you have your Google Form, so just wait on that.

Link to current 40 Book Challenge LookerStudio--make a copy

A formula for pulling out the first name from an email address that is formatted like our state school email addresses:
=UPPER(ARRAYFORMULA(IF(B2:B="",,{RegexExtract(B2:B, "([a-zA-Z]+)\."),RegexExtract(B2:B, "\.([a-zA-Z]+)@"),RegexExtract(B2:B, "@(.+)")})))