Never Stop Learning
Edu on Air: Creating a culture: Google Apps add-on slam
Edu On Air 2015 event page: https://plus.google.com/u/0/events/c7cndlfsplecdcjfqgf5as1rj3c
#GoogleEduOnAir
My school went 1:1 this year which meant a whirlwind of change. Creating this new culture meant creating or adapting school workflows. I'll showcase the add-ons that have helped me like autoCrat for automated Mail Merges, Choice Eliminator for parent teacher conferences, CheckItOut and Lab Scheduler. Also my newest add-on EZ Query.
This session is part of Education on Air, the free online conference from Google. Register for free at http://goo.gl/Gkww6N.
The journey of creating a culture.
- Get everybody on board, starting with the office staff and administration
- Change common workflows
- Give teachers time to start using it in the classroom.
Workflows that I have changed and the tools I used to help me do it.
- Computer Labs:
- Add-on: Lab Scheduler
- Example: Lab Sign-out
- Check Out Spares:
- Add-on: CheckItOut
- Add-on: Fuzzy matches
- Example: Spare Checkout Form
- Example: Spare Checkout Form Results
- Activities schedule:
- Blog Post: =filter() or =query() functions
- Example: FHUHS using filters
- Example: EduOnAir using query
- Plays on website & lobby kiosk
- Parent Teacher Conferences:
- Add-on: Choice Eliminator
- Incident Report:
- Add-on: AutoCrat
- Add-on: CopyDown
- Example: Template report
- Example: Form
- Example: Dataset (CopyDown Formula used: =row())
- Print & Digital forms
- Forms, make a copy
- How-To: Infographic
- Examples: Letterhead, PO's
- Forms with lots of data:
- Add-on: EZ Query
- Add-on: Save As Doc
- Add-on: Fuzzy matches
- Example: Dataset
Author Links:
- EdListen Scripts (me): http://scripts.edlisten.com/
- New Visions Cloud Labs: http://cloudlab.newvisions.org/
Announcing EZ Query Add-on
EZ Query will help make spreadsheets and form data easily readable. The Add-on utilizes the built-in query function, so data is always up to date. With this add-on you can easily select the columns to show and add filters so you only see want.
Get unique values from a column in Google Sheets, without spaces
Example spreadsheet.
Column B is: =UNIQUE(A:A)
Column C is: =ARRAYFORMULA(if(B:B="","",cou ntif(A:A,B:B)))
Unique ~ pulls the unique values form the submissions. You can combine this inside a sort and at least variations of languages will show up close to each other.
ARRAYFORMULA ~ is a magic function that allows you to apply a formulat that is normally set for a single line to an entire dataset (aka row).
if(B:B="","", ~ is something I found on the internet that allows ArrayFormula to not process blank spaces.
If you are looking for unique matches in a data set that might contain variations of terms then I suggest the Sheet Add-on: Fuzzy Matches
=sort(UNIQUE(C2:C)) also works for grabbing a column and pulling just the unique values without spaces.
=sort(UNIQUE(C2:C)) also works for grabbing a column and pulling just the unique values without spaces.
Subscribe to:
Posts (Atom)




.png)