Blog Post 3: Collecting Daily Grades and Feedback with Google Forms

  • Blog Post 3: Collecting Daily Grades and Feedback with Google Forms

    By Susan Zielinski, posted August 29, 2016 —

    Do you spend too much time gathering, entering, and sharing homework grades? Would you like an easy way to see which homework problems were confusing to your students and gather their questions? My solution? Google forms!
     

    After a few terms of collecting daily homework grades in class, either on a paper grade sheet or using an app, I was frustrated. Some days I forgot; some days I ran out of time; and every day, I begrudged wasting class time collecting grades. Because I have students self-grade and then revise their homework (the subject of my last blog post), collecting homework was not an option. Even worse, once I had the grades on paper, I was also wasting time entering each homework individually into Canvas (software) so my students could see their grades. Further, it was ineffective to always be asking, “Which questions do you want to go over? Number two? Anyone else want to see that one? Any others?” The vocal kids would lobby for their problems, whether or not anyone else was interested, while their quieter classmates would rarely get their questions answered.

    So, in keeping with my goal of students taking responsibility for their work, I created a short Google form where students enter their daily self-grade, list the problems on which they are are stuck, and ask questions. Completing the form takes students less than two minutes, and they must submit their grade at least ten minutes before class starts.
     

    What a valuable ten minutes that is for me! Before each class, I take a quick look at the data. On the basis of that info, I might decide to review a common problem with the whole class, group students who had the same question, pair a student with someone who can answer the question, ask a student to present, talk to a student individually, or simply move right along to the next topic if no one had questions. If a student’s question doesn’t get answered in class, I follow up with an email. Overall, more questions get answered more efficiently by more people.

    I also use the Google form to ask students if they want to present the “checkpoint” problem they were assigned as a preview of the upcoming material. I choose a student who volunteered to present. As an added bonus, I now have a record of who volunteered over the year that I use as a proxy for “prepared for class.”
     

    The Details

    When a student completes her homework, she checks the answers in the back of the book or other source and gives herself a grade. Then she goes to the Google form and enters her grade, any of her incorrect solutions, and any questions she has. Next, through the magic of Google and an add-in named RowCall (suggested by my colleague Melissa Poole), her data is updated in a Google sheet and then published to her own private web page. Now she can see exactly what she has submitted and what she still needs to correct.

    When students submit homework revisions, I change their homework grade directly in the Google sheet and note the old grade in a comment for tracking. At the end of the grading period, I use the sheet to tally up their grades and make one entry in Canvas. Check out this system for yourself, which is easier to use than to read about:
     

    Daily Submission Form

    Google Sheet with data

    Susie’s page (bookmarked once by Susie so she can refer to it all year)


    2016_08_15_ZielinskiAuPic



       

    Susan Zielinski, szielinski@sps.edu, teaches mathematics at St. Paul’s School in Concord, New Hampshire. She is currently a doctoral student at Northeastern University, researching collaboration and power sharing in the classroom, algebraic misconceptions, and engaging assessments. Before her teaching career, she served in the Air Force, worked as an industrial engineer, and homeschooled her children. In her free time, she loves to travel, spend time in the woods, and ballroom dance

    Leave Comment


    Please Log In to Comment

    All Comments


    Digital_Work Digital_Work - 1/24/2021 3:37:54 AM

    You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. Webdesign Limburg


    Digital_Work Digital_Work - 1/24/2021 3:30:50 AM

    This is my first visit to your web journal! We are a group of volunteers and new activities in the same specialty. Website gave us helpful data to work. Ramen en deuren


    Digital_Work Digital_Work - 1/23/2021 3:05:13 PM

    That is the excellent mindset, nonetheless is just not help to make every sence whatsoever preaching about that mather. Virtually any method many thanks in addition to i had endeavor to promote your own article in to delicius nevertheless it is apparently a dilemma using your information sites can you please recheck the idea. thanks once more.Wat is leadgeneratie


    doris soto - 1/22/2021 6:21:41 AM

    Im no expert, but I believe you just made an excellent point. You certainly fully understand what youre speaking about, and I can truly get behind that. PVC ramen en deuren Leuven


    doris soto - 1/22/2021 6:06:28 AM

    It proved to be Very helpful to me and I am sure to all the commentators here! Ramen Leuven


    doris soto - 1/22/2021 6:12:36 AM

    Im no expert, but I believe you just made an excellent point. You certainly fully understand what youre speaking about, and I can truly get behind that. Aluminium ramen


    Digital_Work Digital_Work - 1/21/2021 3:03:37 PM

    i am for the first time here. I found this board and I in finding It truly helpful & it helped me out a lot. I hope to present something back and help others such as you helped me. Webdesign Hasselt


    doris soto - 1/21/2021 2:04:12 PM

    Outstanding article! I want people to know just how good this information is in your article. Your views are much like my own concerning this subject. I will visit daily your blog because I know. It may be very beneficial for me.Webdesign bureau


    doris soto - 1/21/2021 2:07:49 PM

    Your blog is too much amazing. I have found with ease what I was looking. Moreover, the content quality is awesome. Thanks for the nudge! Leadgeneration


    doris soto - 1/21/2021 2:14:28 PM

    Keep up the good work , I read few posts on this web site and I conceive that your blog is very interesting and has sets of fantastic information. Leads genereren


    doris soto - 1/21/2021 4:41:26 AM

    Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work. SEO zoekmachine optimalisatie


    doris soto - 1/20/2021 1:42:50 PM

    Excellent post. I was reviewing this blog continuously, and I am impressed! Extremely helpful information especially this page. Thank you and good luck. Aluminium ramen en deuren Leuven


    doris soto - 1/20/2021 1:59:20 PM

    I got too much interesting stuff on your blog. I guess I am not the only one having all the enjoyment here! Keep up the good work. Webdesign bureau


    doris soto - 1/20/2021 1:53:45 PM

    You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. Webdesign bureau


    doris soto - 1/20/2021 1:48:59 PM

    It is my first visit to your blog, and I am very impressed with the articles that you serve. Give adequate knowledge for me. Thank you for sharing useful material. I will be back for the more great post. Houten ramen en deuren


    doris soto - 1/19/2021 6:59:36 AM

    Some truly wonderful work on behalf of the owner of this internet site , perfectly great articles . PVC ramen


    Ashley Dugas - 8/18/2017 5:16:46 PM

    How do you have the student's information sent to them?


    Ashley Dugas - 8/18/2017 3:47:53 PM

    What's a checkpoint problem?