Setup Fillable Document in Google Classroom

What is Google Classroom?

Google Classroom is a free web service developed by Google for schools that aims to simplify creating, distributing, and grading assignments. The primary purpose of Google Classroom is to streamline the process of sharing files between teachers and students.

Quiz Scenario

  • A Teacher wants to conduct a quiz for the students.

  • The Teacher want publish the quiz through Google Classroom.

  • Then the students will attend the quiz and submit the answer

How to automate this process with Fillable Document

Step 1: Prepare the quiz

The staff first prepares an quiz template in Google Document.

He can add dynamic fields in ${field} format

Step 2: Configure the Dynamic Fields

Open Fillable Document on the prepared Google Document Template

Dynamic fields found in the template will be automatically identified by Fillable Document

By default, the field types are text.

Configure different types (name, date etc) and other configuration as required.

Step 3: Configure Settings

Go to settings tab and configure the destination folder and spreadsheet here

  • Setup Destination spreadsheet to store the form submissions

  • Setup Destination folder to store the generated documents and PDFs

  • Setup Email Template

Step 4: Publish Document

  • Teacher will publish the template to his students by clicking Publish Form.

  • If you don't want to keep track of user activity (like user email) switch off Always ask Google Login

  • Copy the published URL.

Configuring Google Classroom

  • Create class.

  • Mention the Class Name.

  • Mention the section name.

  • Mention the subject name.

  • Mention the room name.

  • Click on Create.

  • Select Quiz assignment.

  • Mention the required Title.

  • Mention the required instruction.

  • Click on ADD

  • Select the type as Link.

  • Paste the published URL from Fillable Document setup there.

  • Click on Assign to assign people.

  • Click on People.

  • Click on the add contact icon to add students to the list or add teacher to the list.

  • The Quiz is created in Google Classroom .

Now the students need to submit the quiz so that the results will be saved in Google Sheets.

How students need to submit the Quiz?

  • Students needs to login to classroom.google.com.

  • It will show you the assigned quiz.

  • Open the quiz form and submit the quiz.

  • Once the form is submitted by student they can view their scores by clicking on the view score.

Step 6: Submitted Data stored in Google Sheet instantaneously.

  • Teachers can see the submitted data in the Google sheet immediately.

If you are not able to see the data you have added, then please refresh the page and try

To see the submitted records, Teacher need to follow the steps below.

  1. Open "Fillable Document" add-on from the Google Document

  2. Click on "Open Form as Web App"

  3. Click on "Form Responses" icon on the toolbar

  4. Click on a record to select for generating document

5. Click on "Generate Document" to generate the merged document

Below is a sample generated document and screenshot for email delivery.

Teacher can generate multiple documents based on records needed. (have a look)