Being a classroom teacher comes with a lot of books. You want to borrow them to co-workers and students, but there is not an easy or cost effective way to keep track of all of them. Most systems commercially available for library tracking are expensive.
That is where this system steps in. Using the easily accessibly Google Sheets format, this series of sheets will allow you to keep track of your books.
This System comes as a PDF file, with links to 5 Files:
Instruction Document- 5 pages of instructions on how to modify each sheet to work with your system and within your own Google Drive. Includes pictures and step by step instructions to make these sheets work for you!
Master Sheet- One central place that houses all of your Inventory Data: Title, inventory number (complete with a naming system), link to image file, link to more data, availability, author, who the item is checked out to, what the location of the item is, and notes. Once created, this is the only sheet you will ever need to change or modify.
Data Sheet- This sheet automatically populates and changes based on the data in the Master Sheet. Sorts items by Item Type, so you can easily open each tab and see exactly how many of each item you have available.
QR Sheet- This sheet automatically populates a QR code that links scanners directly to the link provided in the Master Sheet. It also populates the Inventory number, so you can easily cut out the QR with Inventory Number to attach to your books. This is a great way to provide book reviews!
Awesome Table Sheet- This sheet is automatically populated and once linked to Awesome Table's website (directions included), creates a visual table that is able to be linked or embedded into a website. Users can then see all inventory or can choose to sort by availability, Title, or author.
Follow my Teachers Pay Teachers Store for additions to this system and additional Inventory Systems coming out soon!