Student Rubrics with Google Forms and docappender

Every other month, we give students an argumentative writing prompt which is then scored against a standard rubric. One of our school goals is to improve the quality of writing from our students, so we teach them not only the content, but how to make a good argument. Using things like facts along with application and persuasive writing techniques all blend into one piece.

With each prompt, students see the scoring rubric beforehand and then receive that back with their writing so they can see what needs to improve. I have a few (mostly organizational) problems with this:

  1. I'm usually not organized enough to print out half-sheet rubrics before the prompt (it's just a normal class day)
  2. That's a lot of paper because the prompt also needs to be printed, and it's nice to let kids write on the back of the prompt itself.
  3. My handwriting is awful, especially when I have 140 papers to grade and comment on.
  4. I am a notorious paper-loser.

I have wanted to try some of the New Visions CloudLabs add-ons for Google Docs for a long time, but didn't have a real need to. So, I dove into autoCrat because I knew it could take form data and push it over to a sharable and printable Google doc. It worked great, but it generates a separate doc for each student, which isn't something I want to manage (I know I could use Doctopus in conjunction to make it easier, but I'm not at that point yet). What I really wanted was something to add new entries as a table to a class-level document. I could print those out, cut them into slips, and distribute.

Karl Lindgren-Streicher to the rescue.

docappender was definitely what I needed.

In my Drive, I created a folder with six empty documents simply labeled with the class hour. Then, I created a Form I could use to add the student's name, their class hour, their score, and some comments.

Rubric form

Rubric form

docappender works by looking at your form for an identifying field (for me, class hour) and then finds the matching document in your folder.

Output after a form submit.

Output after a form submit.

Each time I submit a new score, the script runs and pops out a formatted rubric for the student. It's great.

Now, I can have a class set of rubrics for students to use while writing, they can write on the back of the prompt (cut my paper use by 2/3), and they get a typed scoresheet back. I also have a digital record, so no keeping track of these papers.

We're not one to one or GAFE right now, so I don't worry about sharing with students. If we head that direction, you could easily go paperless using some of the other New Visions add-ons in conjunction with one another.

One thought on “Student Rubrics with Google Forms and docappender

  1. […] months ago, I wrote up a way to automate rubric score reports using docappender in Google Drive. It worked great the first […]

Leave a Reply

Your email address will not be published. Required fields are marked *