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.

Screen Shot 2018-02-06 at 9.06.35 AM
Google Form with checkboxes of assessment criteria and checkboxes for feedback. 

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.

 

Screen Shot 2018-02-06 at 9.04.12 AM
Google Sheet of data from Google Form.

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.

 

 

Screen Shot 2018-02-06 at 9.05.09 AM
The formMule email template

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.)

 

 

Advertisements

One thought on “Google Tools to Assess and Provide Feedback

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s