In this episode of the TechEducator Podcast, we explore powerful Add-ons for Google Forms and Google Sheets. Also in this episode, we have a visit from Andrew Stillman, one of the amazing authors of these Google Add-ons.
The TechEducator Podcast is a weekly round table discussion about current topics in educational technology. For more information, please visit www.techeducatorpodcast.com.
Many great ways to participate in the TechEducator Podcast.
TechEducatorPodcast.com

Follow us Live on Video: http://www.TeacherCast.tv
Leave a Voice Mail: http://www.TeacherCast.net/voicemail
Email: feedback@Teachercast.net
Twitter: @TechEdShow (http://www.twitter.com/techedshow)
Hashtag: #TechEducator

Hosts:

Jeff Bradbury - TeacherCast.net - @TeacherCast
Jeff Herb - InstructionalTechTalk.com - @JeffHerb
Sam Patterson - MyPaperlessClassroom.com - @SamPatue
Jennifer Judkins - TeachingForward.net - @JennJudkins
David Saunders @DesignSaunders
Josh Gauthier @mrgfactoftheday
Jennifer Scheffer - JennScheffer.com @JLScheffer

Google Forms & Add Ons - Beyond the Survey

Using Google Forms for automated workflows

“Tool kit” of Add-Ons for Forms & Sheets used for automation

Forms Add-Ons

formRanger - auto-populate a drop down list of response options from a spreadsheet

formLimiter - set maximum responses or close form to new submissions at specific time/date

Sheets Add-Ons

autoCrat - mail merge using spreadsheet data

syncData - pushes data from “master” sheet to other sheets

copyDown - Copy spreadsheet formulas down to any new rows that result in form submissions

Learn more about Data Validation in Google Forms - Blog Post

The TechEducator Podcast would like to thank Andrew Stillman for joining us on the program today.
Resources:

Google Forms Video Tutorials Playlist Anohttps://www.youtube.com/playlist?list=PL5ybNyowvZQcU-qr1QnAOxbMD-ZFbLq8V

Single-Approval Workflow w/ formMule Tutorial https://www.youtube.com/watch?v=zOOb7YxVNKI

Thank You For Your Podcast Reviews
Are you enjoying Educational Podcasting Today or other shows on the TeacherCast Network, please share your thoughts with the world by commenting on iTunes today. I enjoy reading and sharing your comments on the podcast each week.
Ask Me Your Podcasting or WordPress Question
Are you interested in starting your own podcast? Do you need help creating an awesome WordPress website? I am available for 1:1 consulting. Please visit my homepage and I will help you launch your personal brand today!
Contact Me

Host: Jeff Bradbury @TeacherCast
Email: info@teachercast.net
Voice Mail: http://www.TeacherCast.net/voicemail
YouTube: http://www.TeacherCast.net/YouTube
iTunes: http://www.TeacherCast.net/iTunes

Check Out More TeacherCast Programming

TeacherCast Podcast (http://www.teachercast.net/tcp)
TeacherCast App Spotlight (http://www.teachercast.net/appspotlight)
Educational Podcasting Today (http://www.educationalpodcasting.today)
The TechEducator Podcast (http://www.techeducatorpodcast.com)

View LIVE Professional Development from TeacherCast

Watch LIVE: http://www.TeacherCast.tv | Broadcasting Schedule (http://www.teachercast.net/showcal)
TeacherCast Broadcasting Community: http://www.TeacherCast.net/broadcastingcommunity

Need a Presenter?

Jeff Bradbury (@TeacherCast) is available as a Keynote Speaker, Presenter, or to Broadcast your conference LIVE!