*ISTE Workshop: Transitioning to the Common Core with Google Apps – Join me!
Teachers who regularly collect information via forms or use forms to create online rubrics can send students emails directly from the spreadsheet with a script called FormEmailer. The screencast below demos how to install and use FormEmailer.
Just remember you always want to collect the student’s:
- Name
- Email address
You will also want to add a column titled “Feedback” or “Comments.” This is where you will record specific feedback you want to send in the email to students.
Quick Tip: If you want to process many emails, input the number of the line you want to start with, followed by an asterisk (i.e. 15*) and FormEmailer will process from that line to the end.
I hope this saves other teachers as much time as it has saved me! Please feel free to share your favorite script and any resources that helped you to use it!
*ISTE Workshop: Transitioning to the Common Core with Google Apps – Join me!
This is blowing my mind! Do you have students submit their own forms for each rubric, so that they are the ones to submit their names and email addresses?
Hi Mary,
I have all of my students fill out a “student info” form at the beginning of the year with their names, class name and emails. This way their information is easy to grab whenever I need it for a form I am using to assess their individual work (i.e. essay). If I am grading a presentation as they present, then I have the group enter their info at the top of the form before they present and I complete it as I evaluate in real time.
I cannot believe how much this simple script has changed the way I evaluate student work online. It is awesome!
Catlin
Pingback: Digital Storytelling: Get Creative with the Common Core | Catlin Tucker, Honors English Teacher