Student Assessment

Scenario:

  • A teacher needs to create a performance assessment for his/ her students

  • The teacher wants to

    • Save the assessment data in a Google Sheet

    • Generate the assessment data as Google Doc and PDF

    • Send the PDF to the student's Email with a custom message

How to automate this process with Fillable Document

Step 1: Prepare the Assessment template

  • The teacher first needs to prepare an assessment template in Google Document.

  • He/She should add dynamic fields in ${field} format

1. Student Assessment

Step 2: Configure Setup

  • Click on Add-ons>> Fillable Document>> Start.

  • Click on Start setup to set up the document.

  • Click on Automatic Setup to set up the document automatically.

  • Click Manual Setup to set up the document automatically.

Note:

  • If Automatic Setup is selected a destination spreadsheet & a destination folder will be created automatically for saving the data.

  • If Manual Setup is selected you need to configure the destination folder & destination spreadsheet manually.

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, grade, mark, etc) and other configurations as required.

  • For example we have configured "From date" with a field type date and time zone.

Step 3: Publish Document

  • The teacher can make the Form available to all of the students by publishing the form

  • The Teacher will publish the template to his/her student by clicking Publish Form.

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

Step 4: The Teacher will submit data in the Form.

Important Note: You need to be signed in to your Google Account to see the below form.

Step 5: Submitted Data stored in Google Sheet instantaneously.

  • The Teacher can see the submitted data in the Google sheet immediately.

Note: If you have submitted the form in the previous step, you should see your submitted data here.

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

Test Demo - 123 - destination spreadsheet

Step 6: Deliver documents to students.

  • Setup the Email Template as required.

  • So once a document is submitted an email with the generated PDF will be attached to the email and send to the student.

Step 6: View Form Responses

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

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

  2. Click on "Open Web Form"

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

  4. Click on a record to select for generating the document.

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

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

Sample Generated Document

Hope you enjoyed the demo and now you can use it in practice.