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

2 responses

  1. […] For teachers who are using Google Sheets, Corey Aylen lists a few helpful add-ons for education. […]

  2. Hi there colleagues, how is the whole thing, and what you wish
    for to say regarding this piece of writing, in my view its in fact awesome for
    me.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: