Add-on Some Awesome Sauce
Drive
Add-ons
Google Confidential and Proprietary
CIANE GROSSMAN
Personalized Learning Coordinator
Dallas ISD
Google Certified Innovator
Google Certified Trainer
Connect with Me…
Connect with me...Share with Me...Learn with Me
Twitter:
Google+:
Gmail:
CIANE GROSSMAN • Google for Education Certified Trainer
Apps for Education
Backchannel
Apps for Education
Google Education Trainer
Goals
Google Education Trainer
What are Add-ons ?
tools built by third-party developers that add more functionality to your docs, forms, and sheets
Google Education Trainer
What’s all the fuss?
How do I get add-ons?
Google Education Trainer
How do I manage add-ons?
Once you install Add-ons, the bottom of the menu looks like this.
Google Education Trainer
What do I need?
Open this Link to the Folder of shared docs and folders
Open the folder in your Drive
Open the Doc and use this as a guide for Docs (make a copy)
Google Education Trainer
Change Case
EasyBib
Kaizena
Texthelp Study Skills
Gliffy
Lucidchart
Doc to Form
Charts
Sorted Paragraphs
Easy Accents
Speech Recognition
Google Education Trainer
So many Add-ons...
Where do I start ?
Add-ons for Docs
Google Education Trainer
EasyBib Bibliography Creator Manage citations and bibliographical references, help students create accurate product citations, avoid plagiarism, and how to evaluate websites.
Kaizena Teachers can easily give verbal feedback, make suggestions, or attach resources to student’s work.
Texthelp Study Skills Users can highlight important text on a doc and then access those highlights in a separate doc for easy access and studying.
Gliffy Easily create diagrams, flowcharts, and organizational charts in Google Docs.
Lucid Chart Create flowcharts, organizational charts, diagrams, mockups, and mind maps together in real time and insert them directly into your Google docs.
Doc to Form Create a Google Form from within a Doc by selecting text and clicking a button to add your questions.
Google Education Trainer
Add-ons for Docs:
Openclipart Contains over 50,000 images available for searching and inserting into your Google Doc.
Thesaurus Provides synonyms, antonyms and more !
Charts Build a chart from data in your Google Spreadsheet and insert it right into your document.
Change Case Make changes to the case of text in block selections: uppercase, lowercase, first letter capitals, invert, sentence and title case.
Sorted Paragraphs Sort paragraphs, lists, bibliography and individual table rows or columns in either alphabetical or reverse alphabetical order.
Easy Accents insert accents for different languages directly from the sidebar in your Doc.
Google Education Trainer
Add-ons for Docs:
Speech Recognition You can use speech recognition to write your Docs without typing.
Translate Highlight or right click text to either translate words or the entire text in your doc.
Avery Label Merge You can create a Doc with merged data from your Google Sheet to produce Avery address labels and name badges.
Twitter Curator Organize and format tweets inside your Doc. Great to use during events.
g(Math) Create graphs (including plotting points) and complex math directly in your Google Doc.
Google Education Trainer
Add-ons for Docs:
Save time by making a Work Cited page all within your document as you search for books, journal articles, and websites using the research tool.
EasyBib can help you teach students to accurately cite, avoid plagiarism, and easily evaluate websites.
.
Google Education Trainer
Give students personalized feedback on their work with voice and text comments. Teachers can also attach resources to students and receive voice and text comments from students.
.
Google Education Trainer
Highlight important text on a doc to group content together and then access those highlights in a separate doc for easy access and studying.�
This help students identify and group key facts together, indicate new words to learn, or collect research.
.
Google Education Trainer
Create flowcharts, organizational charts, diagrams, mockups, and mind maps in real time with collaborators and insert them directly into your Google docs.
.
Google Education Trainer
Create a Google Form from within a Doc by selecting text and clicking a button to add your questions.
.
premade questions
Google Education Trainer
Openclipart Contains over 50,000 images available for searching and inserting into your Google Doc.
.
Google Education Trainer
Charts Build a chart from data in your Google Spreadsheet and insert it right into your document.
.
Sample Pie Chart data
Google Education Trainer
Change Case Make changes to the case of text in block selections: uppercase, lowercase, first letter capitals, invert, sentence and title case.
.
Google Education Trainer
Sort paragraphs, lists, bibliography and individual table rows or columns in either alphabetical or reverse alphabetical order.
.
Google Education Trainer
Easy Accents allows you to insert accents for different languages directly from the sidebar in your Doc.
.
Google Education Trainer
g(Math) Create graphs (including plotting points) and complex math directly from the sidebar in your Google Doc.
.
Google Education Trainer
You can use speech recognition to write your Docs without typing.
This may be a useful when working with students with disabilities.
.
Google Education Trainer
Translate Highlight text to either translate words or the entire doc from languages including English, French, Japanese, Spanish, and
German.
.
Google Education Trainer
Avery Label Merge Allows you to create a Doc with merged data from a Google Sheet to produce Avery address labels and name badges.
.
Google Education Trainer
Twitter Curator Organize and format tweets inside your Doc. This tool is great to use during events.
.
Google Education Trainer
Hello Fax allows to to fax from right inside your document. No fax machines necessary! Just add the fax number, fill out your cover sheet and click, send.��
.
Google Education Trainer
VeritySpell is an advanced spell checker that corrects spelling and grammar mistakes in English texts.
Google Education Trainer
Consistency Checker is intended for long or formal documents. It finds hidden errors in writing such as numerals in the middle of sentences, hyphenations, and abbreviations that appear in two different forms.
Google Education Trainer
Add-ons for Sheets
Google Education Trainer
Flubaroo lets you quickly grade and analyze student performance on assignments. Teachers can quickly identify students in need of extra help, view average scores, and identify questions which a majority of the students missed.
Autocrat Document merge tool that automates the creation and sharing of personalized Docs or PDF email attachments from columns of data in a Sheet.
Doctopus An octopus for docs! Teacher-built tool for scaffolding, managing, organizing, and assessing student projects in Google Drive.
ForMule E-mail Merge Utility Allows you to send personalized e-mails from a sheet and can be run as a manual merge or as a triggered merged that runs on form submit.
SiteMaestro Copy, share, and manage Google Sites as e Portfolios with rosters of students. Teachers select a master site to copy and are able to copy and bulk-manage class websites and student ePortfolios.
Super Quiz Teachers create a quiz with a form and an answer key. Students submit responses, and submissions are graded. Teachers can also send custom feedback and have it emailed to students as soon as they submit a response.
Add-ons for Sheets:
Google Education Trainer
Save as Doc Convert any Google Sheet into a Google Doc.
QR Code Generator Generate QR codes directly from Google Spreadsheets.
Lab Scheduler is a resource scheduler that uses periods or blocks to schedule rather than times. The lab scheduler will continually take out the previous day and add a new one so that once it is set up, it will always be up-to-date.
Mapping Sheets Plot your own data onto a Google Map directly from Google Sheets
Online Rubric Create and send customizable rubrics and scores to students by email for any assignment.
Google Education Trainer
Add-ons for Sheets:
Flubaroo lets you quickly grade and analyze student performance on assignments as well as e-mail grades to students. Teachers can quickly identify students in need of extra help, view average scores, and identify questions that a majority of the students missed.
Google Education Trainer
Doctopus An octopus for docs! Teacher-built tool for scaffolding, managing, organizing, and assessing student projects in Google Drive.
Google Education Trainer
Autocrat Document merge tool that automates the creation and sharing of personalized Docs or PDF email attachments from columns of data in a Sheet.
Google Education Trainer
ForMule E-mail Merge Utility Allows you to send personalized e-mails from a sheet and can be run as a manual merge or as a triggered merged that runs on form submit.
Google Education Trainer
SiteMaestro Copy, share, and manage Google Sites as e Portfolios with rosters of students. Teachers select a master site to copy and are able to copy and bulk-manage class websites and student ePortfolios.
Google Education Trainer
Super Quiz Teachers create a quiz with a form and an answer key. Students submit responses, and submissions are graded. Teachers can also send custom feedback and have it emailed to students as soon as they submit a response.
Google Education Trainer
Save as Doc Take rows or columns from any Google Sheet and turn them into their own google doc.
Click here for a sample sheet
Google Education Trainer
QR Code Generator Generate QR codes directly from Google Spreadsheets.
Click here for a sample sheet
Google Education Trainer
Lab Scheduler is a resource scheduler that uses periods or blocks to schedule rather than times. You can use lab scheduler to schedule labs and other shared resources in your school.
Click here for a sample sheet
Google Education Trainer
Add-ons for Forms
Google Education Trainer
FormLimiter Close your survey automatically after a maximum number of responses is reached or for a specific date and time.
Form Values Store and pull from lists that you use regularly in Forms such as a list of staff, students, rooms, or resources.
Choice Eliminator This will eliminate options from a multiple-choice, list, or checkbox type of question. This is great for signing up for time slots or having students choose topics without doubling up.
DocAppender Appends form question responses to the bottom of a selected Google Doc.
formRanger Allows you to auto-populate the choices in list, multiple choice, checkbox or grid question options from columns of data in any Google Sheet or Doctopus roster.
Google Education Trainer
Add-ons for Forms:
FormLimiter Closes your form automatically after a maximum number of responses is reached, at a specific date and time, or
when a spreadsheet cell equals a specific
value.
Google Education Trainer
Form Values
Form Values Store and pull from lists that you use regularly in Forms such as a list of staff, students,
rooms, or
resources.
Google Education Trainer
Choice Eliminator eliminates an option from a multiple choice, list, or checkbox question after a user has
submitted it.
Google Education Trainer
DocAppender Appends form question responses to the bottom of a selected Google Doc.
Google Education Trainer
formRanger Allows you to auto-populate the choices in list, multiple choice, checkbox or grid question options
from columns of
data in any Sheet
or Doctopus
roster.
Google Education Trainer
CheckItOut will allow you to use a form as a check-in/out sheet for anything. It will create one question for items that are IN and another that are OUT. Items will be moved between the questions on submit.
Link to Form Responses
Google Education Trainer
Google Education Trainer
Now You Try.....
Let’s
Google Education Trainer
Revisit the Backchannel
Google Education Trainer
More Questions ?
Ciane Grossman
Personalized Learning Coordinator
Dallas ISD
Google Education Trainer
Resources
New Visions
http://cloudlab.newvisions.org/add-ons
Synergyse Blog https://www.synergyse.com/blog/top-10-google-docs-sheets-add-ons-for-education/
https://sites.google.com/site/monicassites101/add-ons
Matt Miller’s Ditch That Textbook Blog http://ditchthattextbook.com/2014/05/08/28-ways-googles-new-add-ons-can-help-teachers-now/
The Cool Cat Teacher Blog by Vicki Davis
http://www.coolcatteacher.com/best-google-drive-add-ons/
Build Your own Add-On with Apps Script:
https://developers.google.com/apps-script/add-ons/