Using Google Forms for Summer Reading Tracking

4

April 7, 2017 by Andrea

Google forms! yes! free! good! easy!

Our Library has used Google Forms to register and log minutes in the summer.  Google Forms allows you to get any information you want (Name, Grade, School, etc.) and inputs the information into a Google Sheet. From there you can sort, add, or any other computation you want.

Things you need:
– 
a Google account
– A place to link from / embed the form……We created an image with the logos that linked to a wordpress.com page which has the forms embedded….you could also just link directly to the Google form. The image was on our library’s website. (Hopefully that sentence is not too confusing, basically a picture on our website linked to the form)

How to begin:

Once you’ve logged in to your google account, find Google Forms from the apps menu (the little tiled logo in the top right corner). The templates are super easy to use and pretty straightforward. Once you’ve completed the form, the Send button is how you can share the link or embed the form on your site.Google Form

How I worked our club:

In terms of registering and logging minutes, I used two different forms, one to register and one to log. The registration log is where I gathered name, grade, school…and our logging form I gathered name, minutes read, and name of the book. I made both forms input to one sheet on separate tabs, so I could see all those who registered and then those who were logging books and minutes. I could easily sort the logging information by names and then used how many minutes the kids read to pull for raffle prizes. When you’re looking at your form, click the response button and then you’ll see a little Google Sheet icon or click the three dots to select a response destination and pick a sheet.

Here is our response sheet:

Google Form Response

The Best Features:

What’s really nice is you can share the sheets with any other staff member that has a gmail account….if you do not use gmail, you can just create a generic account for your department and share the login so everyone has access.

The sheets templates are really nice and fun, and you could even upload official CSLP artwork.

WordPress.com and Google are all free!

Suggestions:

  • Toy around with Google Forms to get familiar with how each button or short answer works. You can make some field required or some voluntary.
  • Google sheets works very similar to Excel, but there are some easier features. I find sorting better with Google sheets (it defaults to sorting the whole sheet rather than Excel which typically asks if you want to or not) and freezing part of the sheet easier by just using the little hand icon from the x or y axis.

Please feel free to email with any further questions or help needed!

 

Advertisements

4 thoughts on “Using Google Forms for Summer Reading Tracking

  1. Shawn Brommer says:

    Hi Andrea! Did your google form allow participants to return to their registration information to keep running track of the no. of hours spent reading/no. of books they read throughout the summer? Were they able to somehow log back in to update their reading logs/progress through the summer? Thanks so much!

    • Andrea says:

      I set it up so there were 2 separate Google Forms, 1) They registered and I received their information like school, age, etc. and then 2) a form where they would simply enter their name and number of minutes read…..The form just enters into a Google sheet, so I could do a quick sort and sum for the participant. There are also automatic time stamps for each entry. So I do weekly drawings, and I could just total the amounts for each specific week.

  2. Marian Wynn says:

    I would like to do this for our SRP. I was wondering if you could share your form. I have not done this before and would like to see a template of sorts. Also, I know the patrons will be using the form multiple times. How does Google forms keep the stats for each one? Patron 01 read 5 books during week one. Patron logs number for week one. Patron 01 logs 3 books on week 2. How will the stats from week one and week two be recorded for Patron 01?

    • Andrea says:

      Hi Marian! So the form is embedded on your website (so basically there will be a box that then has whichever information boxes you ask for, name….grade…school….whatever it may be) Once they hit enter on the form, the information goes directly onto a Google Sheet with each entry automatically filling out a row. So when I have kids log minutes, they’ll enter their name, book title and minutes read. At the end of the week I will sort the Google Sheet and total their minutes. I don’t have the summer reading form up right now, but here is the link to our reader of the month which uses Google Forms for submission (http://kidzone.radnorlibrary.org/submit-an-entry/). Feel free to email me at aelson@radnorlibrary.org if you have any other questions. I would suggest playing around with Google Forms. Once you’ve created your form, hit the “Send” button to get the HTML embed code.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

ABOUT ME

Me! My name is Andrea and I'm a Children's Librarian in the Philadelphia area.
Follow Me on Pinterest

Archives

Flannel Friday!

%d bloggers like this: