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.