Individualised reports from Google forms

This video explains how one can create a mail merged document from form submissions. A simple mail merged document will give one report per record. This video employs excel formulas to accomplish individualised report per student when there are multiple records for the same student.

The source files can be downloaded here.

Videos on incrementing cells can be viewed in the two videos from Mike Girvin’s excelisfun: 493, 692. Videos on Index and Small from excelisfun channel – EMT 616.

Youpd  lists various Goople Apps Scripts for educators. If you do not have Google Apps for Education and you would wish to receive confirmation of the submissions, you can employ Autocrat script.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s