If you have your students complete an assessment via a form, and you have multiple choice and fill-in-the-blank questions, Flubaroo will grade them for you!  Some of our teachers have already enjoyed using this tool, so I created a guide for others who might be interested in giving Flubaroo a try!

The Autocrat Add-On is a great way to take a spreadsheet and input the data into a Doc or PDF template.  You can make certificates, letters, and more using that.  At NBC, we have used it to take student test submissions from a form to create separate documents. Then teachers can grade and/or comment and share back with each individual student.  Here is a Google Doc I created to give step-by-step assistance with the staff in that process:

Merge Values is an add-on that you can use on Google Sheets.  This is great when you have items in columns in a spreadsheet where you would like them to merge into one cell.  The concatenate formula I have used in the past allows you to do this, but I have had to maintain the data in the cells being combined or use extra steps to extract the combined cells.  For example, I create spreadsheets with student names and user IDs on them.  Their Google apps account requires the email address, so I need to append @schooldomain.com to each student's user id.  Merge Values allows me to do this very easily.

After I installed the Add-on, I created a spreadsheet with the names and User Ids.  Then I created a column with @schooldomain.com down the entire column.  When I started the Merge Values Add-on, a sidebar appeared with various options:

There is a variety of options, but by clearing the contents of the selected cells and deleting options to separate the values, I was able to create the student IDs as email addresses much more quickly than I had in the past.

If you would find it useful to merge data from cells in a spreadsheet, open a new spreadsheet, go to Add-ons, go to Get Add-Ons, and install the Merge Values add on.