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.
Teacher, Librarian, Writer, Technophile.