Embedded Files
May 23, 2017
May 23, 2017
One of the great things about Google is the ease in which 3rd party developers (not Google) can create programs that add functionality to Google products. I’ve talked a lot about one of these examples, Chrome Extensions, in the past and have shared several of my favourites with you.
Add-ons are just as their name suggests, add-ons to Google Docs, Sheets, and Forms which add additional capabilities to Google Apps. Watch the quick tutorial video on the right to see how easy it is to find, add, and use Add-ons.
In this post, I will share a few of my favourite and some other popular Add-ons for Docs, Forms and Sheets.
Google Doc Add-ons
Google Doc Add-ons
The Bibliography Creator by EasyBib allows you to easily create a bibliography that is alphabetized and added to the end of a paper. Simply choose book, journal article, or website, enter the title or URL, choose your citation style (MLA, APA, Chicago, Harvard…) and select your source from the search results. When you're finished, Click Add Bibliography to Doc and your citations will be alphabetized and added to the end of your paper.
Google Form Add-ons
Google Form Add-ons
Choice Eliminator will eliminate options from a multiple-choice, list, or checkbox type of question. It is a great tool to use for any type of sign up whether it be for time slots or having students choose topics without doubling up.
Appends Google Form question responses to the bottom of selected Google Docs. In other words, it organizes the responses of a Google Form into one Google Doc. Form responses can be organized as a bulleted list, separate vertical tables, or new rows in a single horizontal table, they can be timestamped and can include username if needed.
Use to update and keep a daily agenda of class activities.
I have a Google Doc for each course I teach and use a simple form that asks for the course, date, lesson topic, and lesson description/assignment. It takes less than a minute for me to complete the form and then DocAppender takes that information and populates the appropriate Google Doc which is shared on my website. My daily agenda is now available for everyone to see! See it HERE!
Other Ideas for DocAppender:
Other Ideas for DocAppender:
Keep a Google Doc per student where you log a running record of observations around a particular skill, like reading or numeracy.
Great for peer review protocols on student Docs that you have editing rights on. Give all students the link to your form and their peer assessments will all paste into the bottom of the selected student doc
Google Sheets Add-ons
Google Sheets Add-ons
Flippity is a series of web apps that easily and quickly turn Google Sheets into a variety of useful tools.
For example you can create:
Online Flashcards
Quiz Show (Jeopardy Like).
Hangman, MadLibs, Crosswords, Bingo...
One of my favourite features is the ability to create random student groups using the Random Name Picker.
Doctopus gives teachers the ability to mass-copy (from a starter template), share, monitor student progress, and manage grading and feedback for student projects in Google Drive.
Its tentacles copy and "hand out" Drive files to a roster of students, giving teachers full control over starter template, sharing configuration, folder organization and file naming, as well as visibility over all work in progress -- including the ability to bulk revoke and revert student editing rights around submission deadlines, as well the ability to fetch word, revision, and comment counts on all student files.
If you use Google Forms for assessment Flubaroo is the best add-on to Google Forms/Sheets (I like it even better than than the Forms Quiz setting). Flubaroo lets you quickly grade and analyze student performance on multiple choice and fill-in assignments.
By running Flubaroo you'll be able to:
Get scores for each student, and identify students in need of extra help.
View average score, and a histogram of scores.
Quickly identify questions which a majority of the students missed.
Share scores with students via email or Google Drive, along with optional notes to the class and/or to each student.
Assign your own score to open-ended questions.
Report abuse