Google Sheets Add-ons for Education
Add-ons are tools created by third party developers that enhance the functionality of Google Docs, Sheets and Forms. This allows users access to more features and creative freedom.
You can install an Add-on from ‘Get add-ons’ under the ‘Add-ons’ tab in Google Docs and Sheets.
Here are the Google Sheets Add-ons I have found to be very useful for education.
autoCrat
autoCrat is a mail merge tool that takes data from a Google Sheet and merges it in a personalised Google Doc or another Sheet. This data can be collected via a Google Form or entered manually into a Sheet. Users can map data using <<merge tags>> as placeholders to insert data from the Sheet into their template. autoCrat can be set to run its merge on submission of a Google Form, enabling the template to be automatically populated as a personalised Doc. This newly created Doc can be emailed to the user as a PDF or a view only Google Doc. autoCrat can be used in many different ways including creating certificates, feedback, rubrics, portfolio pieces and letter writing.
EZ Query
EZ Query allows users to manipulate spreadsheet data without having to know how to write any formulas. Users can add numerous filters to columns to sort data in a new sheet. Any additional data entered into the spreadsheet will automatically be sorted by the filters that the user has set up.
Flubaroo
Flubaroo allows teachers to immediately view and analyse assessment results. Teachers create a Google Form assessment, multiple choice questions work best. Once students complete the Form teachers run the Flubaroo Add-on for the populated Google Sheet to grade the assessment. A new ‘Grades’ sheet is created with an overview of all students results.
- If less than 60% of students get a question correct, that question is highlighted orange.
- If students scored less than 70% on the assessment they are highlighted in red.
This allows teachers to focus their teaching at the point of needs of their students. Teacher’s have the ability to email results to students.
Split Names
Split Names separates names in a Google Sheet that have been collected from a Google Form. Names can be split by first, middle, surname and title. This is an easy to use tool to separate students names when they are entered in the wrong convention.
Google Docs Add-ons for Education
Add-ons are tools created by third party developers that enhance the functionality of Google Docs, Sheets and Forms. This allows users access to more features and creative freedom.
You can install an Add-on from ‘Get add-ons’ under the ‘Add-ons’ tab in Google Docs and Sheets.
Here are the Google Docs Add-ons I have found to be very useful for education.
Easybib Bibliography Creator
Create a bibliography page from within the Doc. Select and manage citations from books, journal articles and websites. Users have the option to use MLA, APA or Chicago citation style.
Kazeina
Kazeina allows users to add audio comments to a Google Doc rather than typing. Users also have the option to link resources to highlighted text. This is the perfect tool to leave verbal feedback on student work.
Mindmeister
Mindmeister allows users to turn a bullet point list of ideas into a mind map than insert it directly into your Doc. This is a great tool to quickly brainstorm or visualise ideas.
Openclipart
Search more than 50,000 images to insert into your document. All images are free to use, change, modify, even commercially making for an excellent source for student use.
Table of Contents
Create a table of contents in the sidebar to navigate the Doc. When a user clicks on the link in the table of contents it will take you directly to that point of the Doc.
Thesaurus
Find synonyms for selected words in your Doc. Suggestions will be given for synonyms and antonyms. A fantastic quick and easy tool to help students expand their vocabulary.