If you’re using a spreadsheet application to record and calculate grades, then each year you have to get your list of students into the spreadsheet. You either do this manually, or you copy and paste the names from some list of your students online.

But sometimes you might want a little more information next to your students’ names in the gradebook. Perhaps you want a nickname column. Perhaps you have your students create a blog and you want a clickable URL of the blog next to their name.  Maybe you want to know how many philosophy courses each of the students have taken.

In my case, I have a single course blog. But since the blog is publicly available, I permit my students to post under an alias. For me, it would be great if I could have each students’ alias right next to their real name in my gradebook.

I just figured out a way to easily do this all with Google Forms. With Google Forms your students can compile the gradebook spreadsheet for you. It’s very simple, and it takes each student almost no time at all. Here’s how to do it.

Construct a Gradebook with Google Forms

  1. Go to Google Documents and create a new spreadsheet
  2. Go to “Forms” and “Create New Form”
  3. Title your form, and start Adding Items.
  4. Add your Questions. For example, you could have questions like: Last Name, First Name, Blog Alias,  Email Address. Save your edits and close.
  5. You’ll be back in the spreadshet. Go back to the Forms menu, and select “Go To Live Form”
  6. Copy the URL and share it with your students however you’d like. I’m putting a link on the course web page.

Whenever a student submits a form, all of their entries will be laid out in a single row. Each column will be titled with whatever you titled your questions. When all of your students fill out the form, the result is a spreadsheet in Google Documents that is laid out exactly the way you would want a gradebook laid out.


Here’s an Example of What the Form Looks Like When the Students Click on the URL you give them. I’ve typed in some fake answers.

Here’s What the Spreadsheet looks like after I submitted the above form.

3 Responses to “Have Students Create Your Gradebook Spreadsheet with Google Forms”

  1. rafal

    Very cool, thanks!

  2. Steve

    Oh, this is brilliant. Using android, and google to take the tedium out of paperwork. Its fantastic, and I’m going to appropriate your idea with appropriate footnotes!

  3. Grade Student Papers Using Google Forms « Jolanda-Pieta van Arnhem, MFA

    […] not a pain at all. With a good email client like Thunderbird and an alphabetized email list (which the students can generate for you [3]) – emailing papers back to students is  one of the quickest and easiest administrative tasks […]

Leave a Reply

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


April 3rd, 2014

Ethics and Technology Panel This Week

I’m participated in a panel yesterday Fredonia on Ethics and Technology. The title of my presentation was “Grounding a Moral […]

March 27th, 2014

Gunshot victims to be suspended between life and death

This is unreal. Doctors in Pittsburgh will try to save the lives of 10 patients by placing them in a […]

March 26th, 2014

Diversity and Inclusiveness: Amy Ferrer over at newAPPS

The executive director of the American Philosophical Association is doing a series of guest posts this week over at newAPPS […]

March 20th, 2014

Thinking about moral realism may lead to better moral behavior.

This is really interesting. A recent article published in the Journal of Experimental Social Psychology suggests that being primed to think about […]

March 14th, 2014

APA Now Accepting Nominees for Leadership Positions

The APA now has an online nomination system. There are vacancies on all twenty APA committees. You can access the […]

February 27th, 2014

A Discovery Based Account of Intellectual Property Rights

One of the issues, that’s most interested me so far in the Ethics and Technology class I’m teaching is how […]

February 26th, 2014

How the MPAA inadvertently gave American Artists Leverage Against Hollywood

This is a very interesting read. For the most part it is an over-view of the global subsidy war between nations. Here’s […]

February 25th, 2014

Spritz – New Technology Aims to Boost Reading Speed to 500 words a minute

I just learned about Spritz today. It’s starts out to be pretty mind-blowing. The technology is designed to feed text […]

February 6th, 2014

Gettier Case in The Simpsons

If we assume that Bart (at some point) justifiably believed that the lemon-shaped rock was a lemon, then he had […]

February 4th, 2014

The Case of the Copyright Hoarder

I’m teaching an Ethics and Technology class this semester. I came up with a thought experiment today that I’m going […]