Teacher Tech

Paperless Is Not A Pedagogy

Menu
  • Teacher
    • Blog Posts
    • Teacher Tech Facebook Group
  • Google Certified Innovator
    • CoffeeEDU
    • Tour of Google Classroom
    • Back to Classroom
  • Author
    • Alice Keeler Books on Amazon
    • Bulk Order Books
  • Developer
    • Schoolytics
    • Google Developer Expert
    • Add-ons By Alice Keeler
      • Doc to Slides by Alice Keeler
      • Roster Extras by Schoolytics
      • TemplateTab
      • toTabs
      • Form Printer
      • Quiz Helper
      • Dice Slides by Alice Keeler
      • Scheduler by Alice Keeler
      • Document Outline by Alice Keeler
      • Missing From (Google Forms™)
      • Randomize Slides by Alice Keeler
      • Speaker Notes by Alice Keeler
      • sheetPusher
      • Seating Chart Slides
      • Hyperlink Slides Choice Board
      • Add-a-Date
      • QuickShare Screenshot
      • Anyone Can View
      • Drive 20
    • Apps Script Tutorials
    • Templates
  • EdTech Coach
    • Premium Membership
    • Free Newsletter
  • Hire Alice
Menu

Send Custom Feedback from a Google Form to a Google Doc Report

Posted on January 28, 2022January 28, 2022 by Alice Keeler

We all love Google Forms! But what if you want to give students feedback after they fill out the Google Form? There are multiple ways to do this.

FREE – Join Alice Keeler Feb 3rd 2022

I will be doing a webinar on this topic on February 3rd, sponsored by OTIS. You will need to register for a FREE OTIS account. You can also check out their calendar of upcoming webinars. Find all of Alice Keeler’s webinars for OTIS by clicking here.

Register Free for Otis Webinar with Alice Keeler

Webinar Description

Google Forms is an amazing tool for allowing students to submit answers and letting you see all student responses in one place. Forms saves you from wasting time opening individual documents and also provides you with the data you need to adjust instruction and differentiate. The feedback features in Google Forms are okay, but you can make them even better with Google Apps Script. If you can copy and paste you can code! In this workshop, Alice Keeler will introduce you to the basics of coding with Google Apps Script and help you to skip using email as the method for communicating feedback to students. Instead, provide a feedback document that you coded yourself!

Feedback in Google Forms

When a Google Form is NOT a quiz, there is no option to provide feedback in the Google Form. Turning on Quiz, even if you make all the questions worth 0 points, will allow you to enter feedback for students. But how do they see the feedback? Students will have to come back to the quiz results to see custom feedback you leave after the Form.

Quiz Helper by Schoolytics

I have had so many requests by teachers for how to export the feedback they enter into a Google Form that I ended up coding it as an Add-on. After leaving feedback in your Google Form, use the puzzle piece Add-on menu in Forms to select Quiz Helper by Schoolytics. In the Sidebar you can select to create Google Doc reports from the Form feedback.

Quiz Helper is a Free Add on
Install the FREE Add-on Quiz Helper by Alice Keeler. Collects NO user data.

Autocrat Add-on

Autocrat is a popular Add-on from Google Sheets that allows you to create custom Google Doc reports using merge tags. After using Quiz Helper by Schoolytics to export your feedback from the Google Form to the spreadsheet, use the Autocrat Add-on in the sheet to customize the feedback report. Note that there are 2 options in Quiz Helper. One to export the feedback to the spreadsheet and another to export to individual Google Doc reports.

Roster Extras by Schoolytics

Another Add-on coded by me (Alice Keeler) is Roster Extras by Schoolytics. You want a spreadsheet with student names in Column B and student emails in Column C. If you are a Google Classroom user you can export your roster at schoolytics.com. Roster Extras allows you to make columns of custom feedback. This will export as a Google Doc, shared with the student, in a report.

Google Apps Script

Nothing is more custom than coding it yourself! The above solutions allowed you to use a pre-made Add-on that someone (me!) coded in Google Apps Script. However, did you know you can code your own Add-ons?! Google Apps Script is easier than you think. It is based on JavaScript and uses codes like form.getResponses(); The code is easy to read and it is multiple choice!! Join me for my webinar, sponsored by OTIS, to see how it is possible to code Google Forms for custom feedback!

Register Free: OTIS Webinar with Alice KEeler
Add-Ons
Grab a Spreadsheet Cell from Each Student

on 26 May, 2022 by Alice Keeler

Finally! A way to grab a spreadsheet cell from individual student spreadsheets. This allows you to easily review all students responses to a question in one place.

Forms
Award Badges to Your Students with Certify’em

on 24 May, 2022 by Alice Keeler

Gamification works! Use Google Forms to award students badges using the Forms Add-on Certify’em

Drive
Help! I Am Moving Schools. How Do I Move Google Drive Files?

on 24 May, 2022 by Alice Keeler

How do you copy or move Google Drive files? If you are retiring or moving schools or simply want a backup of your school files here are 5 ways you can move Google Drive files.

Add-Ons
How to Update Student Spreadsheets

on 22 May, 2022 by Alice Keeler

You make a copy of a spreadsheet per student, but what if you have a typo or want to add to the spreadsheet? sheetPusher by Alice Keeler and Heather Lyon helps you update student spreadsheets. Here is…

Docs
Google Docs Google Play App Store Install

on 21 May, 2022 by Alice Keeler

If you use Google Docs you want to be sure to have the mobile version as well. Use google play app store install

Related

Related Alice Keeler Blog Posts:

  1. How to Hyperlink in Google Docs
  2. Give Checklist Feedback in Google Docs using Google Keep
  3. SlidesMania with Doc to Slides by Alice Keeler
  4. At Your Google Doc

Continue Reading

Next Post:
How to Delete the Shared With Me Folder in Google Drive
Previous Post:
4 Steps to Design Your Own Google Slides Theme

Leave a Reply Cancel reply

You must be logged in to post a comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Alice Keeler is a mom of 5. Current High School math teacher. Developer for Schoolytics.com. Google Certified Innovator, Microsoft Innovative Educator, Google Cloud Innovator Champion, and Google Developer Expert. Founder of #coffeeEDU
Teaching with Google Jamboard
Developer Schoolytics
Schoolytics is FREE for teachers.

Find ALL My Blog Posts


Link to List

Google Classroom Books

Alice Keeler: Mom of 5. Current High School math teacher. Developer for Schoolytics. Founder #coffeeEDU. Google Certified Innovator. Microsoft Innovative Educator. Google Developer Expert. EdTech Specialist.

My Referral Links


Custom Stickers, Die Cut Stickers, Bumper Stickers - Sticker Mule

 

©2022 Teacher Tech | Theme by SuperbThemes