// you’re reading...

Online Tools

Google Spreadsheet Forms for class/meeting sign-ups

I was trying to think of a quick and easy way to have my staff sign up for classes. Right before I sat down to whip something up with a little php/mysql I realized I could just use a google form.

To get started, log into Google Docs and under the New button, one of the options is Form.

From there you can create your form. I only needed two pieces of information, their name and which class. For the user to enter their name I created the first item as a text field in which they would enter their name (and Google makes this easy for you since that’s what the first item defaults to. I did set it to be a required field though. For the class list I used a dropdown field. Each choice I labeled with the date of the class, the class title, and the time of the class. I didn’t go into great depths like a description of the class since that is emailed to the staff and available on the Technology Staff Development site in Moodle. Now the staff can easily sign up for classes, I can quickly find out how many people are in each class, and I can remove the class when the sign up deadline is past or when the class is full. The spreadsheet can also be used to take attendance.

Discussion

2 comments for “Google Spreadsheet Forms for class/meeting sign-ups”

  1. Thanks for the tutorial! I used it for the first time today and it was a big timesaver!

    Posted by Jenni | February 25, 2009, 4:21 pm
  2. We’re using Google Forms to create classroom observation walk-through forms for administrators to use. It’ll all get dumped into a shared spreadsheet.

    I plan on using the forms to gather background knowledge from students next year when introducing new topics. For example, “On a scale from 1 to 10, how much do you know about Egyptian contributions.” With a few clicks, I get a snapshot of prior knowledge from 165 kids.

    Posted by Ryan M | July 2, 2009, 8:32 am

Post a comment