Category Archives: Add-ons

Google Sheets Add-ons for Education

Screen Shot 2015-04-25 at 7.36.36 pm

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.

Screen Shot 2015-04-25 at 7.20.26 pm

Here are the Google Sheets Add-ons I have found to be very useful for education.

autoCrat

Screen Shot 2015-04-24 at 5.17.01 pmautoCrat 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

Screen Shot 2015-04-24 at 4.49.22 pm

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

FlubaroScreen Shot 2015-04-24 at 5.00.54 pmo 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

Screen Shot 2015-04-24 at 5.29.05 pm

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.

Advertisements

Google Docs Add-ons for Education

images

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.

Screen Shot 2015-04-15 at 10.03.37 pm

Here are the Google Docs Add-ons I have found to be very useful for education.

 

Easybib Bibliography Creator

Screen Shot 2015-04-14 at 7.50.14 pm

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

Screen Shot 2015-04-15 at 8.55.51 pm

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

Screen Shot 2015-04-14 at 8.05.30 pm

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

Screen Shot 2015-04-14 at 7.50.33 pm

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

Screen Shot 2015-04-14 at 7.50.00 pm

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

Screen Shot 2015-04-14 at 7.49.40 pm

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.