Since making the shift to standards based grading, I’ve wanted to make sure I communicate expectations and give feedback that fosters growth. My goal is to move students along on the path to proficiency. With each assessment, I want to show students what proficiency looks like and provide them a pathway to advancement.
Recently I had presentational assessments in Spanish 2 and decided to build a Google Form to organize data. The Form had checkboxes related to our specific proficiency standard criteria. Then I included some feedback checkboxes and an open place for me to write comments too. I filled out a form for each student while assessing.
So then I had a Google Sheet of data. Cool. How could I get this and deliver this to my students? I tried about 5 different tools and then finally fell in tech-love with a Google Sheet add-on called formMule.
In order to get this data to the students, I needed to copy in their emails into the sheet (using an easy alphabetic sort copy and paste).
The add-on formMule will send a template email using the data in a Google Sheet.
The add-on walks you through the process nicely. I created a template for the email I wanted sent to the students. It uses the merge tags from the Google Sheet and I just placed the info in there the way that I wanted.
When I clicked send, I wasn’t 100% sure what was going to happen. But the emails went through and they looked exactly like what I wanted. I was happy to get the feedback back to the students in digital form. (I was even happier when a student validated me later that day.)