Badge Point(s): 2 points
Embedded Files
Creating a Classroom library checkout system
Creating a Classroom library checkout system
Classroom library organization can be a challenge. Maintaining a consistent and efficient library checkout system can be even trickier.
Classroom library organization can be a challenge. Maintaining a consistent and efficient library checkout system can be even trickier.
So if you’re looking for a quick and easy way to manage the library checkout process in your classroom, read on or watch the video below to see how mine works.
So if you’re looking for a quick and easy way to manage the library checkout process in your classroom, read on or watch the video below to see how mine works.
Created by J Huff
The Tasks
The Tasks
INFORMATION FROM HELLO, TEACHER LADY:
INFORMATION FROM HELLO, TEACHER LADY:
To officially “check out” a book from her library, students fill out a Google Form with their name, class period, and book title.
When students are done reading their book, they simply return it to a designated bin by my desk.
Then, every so often (usually every 2-4 weeks or whenever the bin gets too full), I open up the Form responses in Google Sheets. For each returned book in the bin, I place an X in an added column titled “Returned.”
Next, I use the filter tool in Google Sheets to quickly eliminate all rows containing an X so that only the blank rows remain. This allows me to see which books are still checked out, and I can follow up with students as needed.
WATCH THE VIDEOS TO THE RIGHT FOR AN OVERVIEW OF HOW TO SET UP YOUR GOOGLE FORM AND HOW TO USE THE FILTER TOOL IN GOOGLE SHEETS.
WATCH THE VIDEOS TO THE RIGHT FOR AN OVERVIEW OF HOW TO SET UP YOUR GOOGLE FORM AND HOW TO USE THE FILTER TOOL IN GOOGLE SHEETS.
*******************************
*******************************
Review the Following:
Review the Following:
EARN THAT BADGE:
EARN THAT BADGE:
Create a Google Form like suggested in the top video and review the blog post linked above.
Copy the view only link and attach to the Google Form provided below.
Have a student practice checking out a book and open the Google Sheet created automatically when creating the Form. Set the settings to Anyone with the link can view and past that link on the Google Form as well.
⬇ LET'S CONNECT ⬇
⬇ LET'S CONNECT ⬇
WEBSITE: http://www.helloteacherlady.com
YOUTUBE CHANNEL: https://www.youtube.com/channel/UCvU6A5-KorNYYgCkDZVZfjw
GET THAT BADGE!
GET THAT BADGE!
Create a Google Form like suggested in the top video and review the blog post linked above. Copy the view only link and attach to the Google Form provided below. Have a student practice checking out a book and open the Google Sheet created automatically when creating the Form. Set the settings to Anyone with the link can view and past that link on the Google Form as well.
Click HERE to go back to Badging main page
Report abuse