1. Logo (thesis topic: flipping/inverting choral classroom in order to teach students a more holistic music curriculum based on the National Music Standards. 2. Branching Google Form Click here. 3. REVIEW OF GOOGLE FORM ADD-ONS A. Flubaroo allows me to collect large amounts of student data via a quiz-like google form, take the quiz myself, and then have students' answers tallied (graded) based on how their answer exactly correlates with mine. It is most effective for multiple choice question assessments. It can not possibly grade short answer or paragraph responses. B. Powertools allowed me to count how many shaded-in cells in a chosen range on google sheets appear in my selected range. This allowed me to tally points for paragraph responses on students' final exams last week as I had color coded their responses to reflect the quality of their response/grade. C. Mail Merge allows me to bulk email my students and parents with individualized information by only creating one draft with general variables that pull from columns and rows in a Google Sheet. This has saved me HOURS of time over the past school year.
2 Comments
Joe Hall
6/17/2017 07:40:14 am
Hi Colby,
Reply
Kelley S. Miller
6/17/2017 09:37:39 am
Thanks for the clear, concise review of add-ons. Powertools is new to me, and while I'm familiar with the idea of Mail Merge, I've never tried it myself. But any time a teacher used the phrase, "saved me HOURS", he's got my attention.
Reply
Leave a Reply. |
AuthorColby enjoys racquetball, playing the piano, and hanging with his beautiful wife, Madilyn. Archives
June 2017
Categories |