This spreadsheet is the solution to all your clutter, disorganized classroom library frustrations! If your little lovelies were anything like mine, they borrowed books from your nonfiction, animal bin, and somehow, those books ended up in the fantasy bin or worse--random places around the classroom. After investing far too much time reshelving my classroom library books after my students, I decided enough was enough--time for an efficient system to help me and my library helpers reshelve borrowed books.
This tool is a comprehensive way to catalog and categorize your classroom library. In addition to 'Title' and 'Author' columns, there are columns for 'Genre', 'Subgenre', 'Guided Reading Level' (GRL F&P), 'Lexile' Level' (LEX), 'Grade Level Equivalent' (GLE), and 'Location'. You can sort your books however you'd like. I sorted mine by guided reading level, genre, and subgenre. Use the location column to return books to their proper book bin. 'Genre', 'Subgenre', 'Fountas and Pinnell Guided Reading Level', 'Grade Level Equivalent", and 'Location' columns have already divided into categories and each cell has a drop down list from which to choose.
Genres: I choose 9 of the most common genres in children's literature. Click the 'LISTS' tab and refer to column A for the genres included in this spreadsheet.
Subgenres: I chose common subgenres in literatures. Each subgenre category is labeled with the genre as well. For example, 'TL-fairy tale means the genre is Traditional Literature and the subgenre is fairytale.
Location: I developed a categorical system to easily find and reshelve all books. Each location is labeled by genre, subgenre, and bin. There are 5 bins for each subgenre. Authors with names ending with A-E are located in bin 1, F-J in bin 2, K-O in bin 3, P-T in bin 4, and U-Z in bin 5. For example, the book Pink and Say by Patricia Polacco would be located in HF-PER4. HF-historical fiction (genre), PER-period (subgenre), 4 (bin number).