Popular posts from this blog
Communication Log - Web App
Positive communication, with students or their parents, can greatly impact the "experience" of a class, a teacher, or even school. Many schools have communication goals, and as a part of those goals, teachers are the expected first voice heard by parents. Unfortunately, even while teachers make their phone calls, send their post cards, and digitally show the might of student learning, group cooperation, and efforts of social wellbeing through email and the web, school boards are drilled by parents who claim they are unaware of the happenings within the walls of their community schools. Likewise, administrators, when dealing with academic or behavioral concerns turn to teachers for a "record" of communication. Paper logs lead to confidentially concerns, especially when one is teaching from a cart, wheeling around the school like a nomad. Most electronic logs are either docs that are endlessly long, slow to log, or time consuming to copy and paste content. So, I
Google Form Quizzes - Find Max Score - Apps Script
If you have ever created a quiz for mastery, you may have discovered you can have students take the quiz as many times as they want. As an educator, you can use the number of retakes a evidence of growth or opportunities to provide overall performance gains while also providing short penalties to discourage frequent and rapid retakes. For example, students can take the quiz as many times as they wish, but for each time they take the quiz, the score is reduced by 2.5%. If you have this information in a spreadsheet, you are golden. In this tutorial, we will create an App Script file to filter out Google Form scores to quickly upload the marks to our SIS or online Gradebook. Problem: If using multiple quizzes in a year where students can retake quizzes, reimplementing formulas to filter the data can be a pain. Solution & Skills: We will create one Google Spreadsheet where future forms can be pointed. We will use Apps Script to pull and format the scores, creating a new sheet with