As an Academic Specialist I have been introduced to a huge number of new to me online tools. The one that blew my mind the most was an extension to Google Sheets called Form Mule. This extension is incredible. This extension allows you to take information that has been input into a Google Sheet, and email the information to individual students. How incredible is that. I use this tool when I am emailing a whole middle school their most recent MI and RI scores. I am able to collect the necessary data, organize it in Google Sheets(which is another skill I had to learn this year), create a general letter template, and then email a whole school of students their MI and RI scores. I like being able to do this so that all students have a place to go to find their scores. (Unfortunately not all students write down their scores as they are suppose to.) This helps teachers because they have a common place to tell students to go to locate their past scores. This is especially helpful at the beginning of the school year. This would be helpful in a classroom as you could send out a similar email to students with test scores, RI and MI scores, or anything else that is helpful in your classroom. A strength of this tool is the ability to send out information to a large number of individuals. The drawback, you have to make sure that your data in Google sheets is 100% spot on. If there are any mistakes, then the emails will send out incorrect information. Learning how to create these Google Sheets can be daunting and time consuming. Luckily, the first one is always the worst, and it can get more efficient as you use these tools more often. I spent a few hours with a coworker who has used this tool in the past. She helped me problem shoot, lay out my spreadsheets, and already knew which Aeries query was needed to pull the necessary information. I knew this was the right tool since it did work in the end and the students were able to access the correct data in their emails.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2020
Categories |