Organizing Your Classroom Library Check-Out System Using Google Forms & Sheets {A Video Tutorial}

Tired of losing books from your classroom library? Have a checkout system for students that's just not working? Wish you had a quick and easy way to figure out who checked out which book and when?

GOOGLE TO THE RESCUE! 

Here's a great way to think about your classroom library check-out system for the upcoming school year!

Use Google Forms and Sheets to create a classroom library checkout system that works! A step by step video tutorial to get you organized for the upcoming school year!

This is a system for students to check in/out books in your classroom library using a Google Form! All you have to do is create the Form, share it with students (through a QR code, Google Classroom, or make a web shortcut on any device including a computer, iPad, or even phone), and have them fill the form out any time they want to check in or out a book.

Use Google Forms and Sheets to create a classroom library checkout system that works! A step by step video tutorial to get you organized for the upcoming school year!

This will automatically generate a nice, pretty, organized Google Sheet where you'll have all of the information you need- the title of the book, who checked it in or out, and the date. AND you can sort the sheet however you want!

Use Google Forms and Sheets to create a classroom library checkout system that works! A step by step video tutorial to get you organized for the upcoming school year!

You can have one student be in charge of checking in/out books as a classroom job, or can have each student complete the form when they want to check in/out a book! 

Check out the video below for a step-by-step tutorial on how to do this!

 
Have questions? Need clarification? Leave me a comment below! I'd love to hear from you!

2 comments

  1. Hi Sandy! Great video-thanks for the instructions. I would love to create a QR code for this so that my students can use our class iPad for check-in/out. I've copied the link, generated a QR code, but when I scan it, it directs me to log into google only, doesn't take me to the form. Do you have any suggestions on how to get it so students can see the form without having to sign in?

    ReplyDelete
    Replies
    1. Hi there! It sounds like you might have the form set to collect email addresses from responders (which will force you to sign in and bring up the login screen instead of pulling up the actual form.) If you open the form to edit it, click the cog in the top right (settings) and make sure 'Collect email addresses' and 'Limit to 1 response' is unchecked. Then you should be good to go! :) -Sandy

      Delete