I have decided this year I do not want paper. Nothing is worse than carrying that giant stack of papers home… only to not touch them and haul them right back to school. Just looking at that giant stack to grade is depressing.

Instead, I am having students turn in their work digitally to a Google Form. I have the form embedded on my website so students always know where to go to turn in work.

The beauty of this is that I have ONE place to find all my work to grade. It is in a Google Spreadsheet which I can access on any computer that connects to the internet. I have a list of all the assignments, I can sit on the couch and go through everything that needs to be graded.

I particularly enjoy that I can sort the spreadsheet by student, by assignment, by if it has been graded, etc..

How you can do it…

Create a Google Form that asks for

  • Students SID number (data is always best when linked to a unique identifier.. more specifically a number)
  • Students name
  • Assignment number (Again data is easiest to sort when it is a single number rather than text.  I number all of my assignments.)
  • Assignment title
  • Permalink (What weblink are students submitting their work to, I have them create a WordPress. Could be a Google docs page, photo uploaded to photobucket, etc..)
  • Self Assessment (What percentage does the student think they deserve. You do not have to ask this, but I find it interesting. If the score I give them is far off of the self assessment score I send them an email or talk with them so they understand why they did not meet expectations.)
  • Student email address (makes it easy to email student if you want to give them feedback or ask a question).
  • Note (just in case the student wants to tell you something)
In the spreadsheet itself I create 3 columns.
  • Graded
  • Score
  • Feedback
I mark an X if I grade it. This allows me to sort the spreadsheet by the graded column to easily see what I need to grade.  I will also put a “no” in the column if I did not give them credit.
Now go to the data menu and choose Pivot table report
You will need to add your rows and columns.  For your row you want to show “SID number” and name.  For column you want to show the “graded” column.  For values choose “score” (make sure it is summarizing by SUM for the values). 

There will be a column for each thing you put in for “graded.” I put an x if the student gets credit, so I get the student points from the x column and not the total column.

If you want you can create a mail merge and email students their scores and feedback.

Subscribe to the Alice Keeler Newsletter



WP Twitter Auto Publish Powered By : XYZScripts.com
%d bloggers like this: