How to Organize Your Picture Books with a Google Sheet

I absolutely love picture books for teaching and modeling reading skills. But you know what? I can’t afford to buy them all. I can’t even remember which ones I have, which ones I use for what skill, or if I borrowed them from a friend.

The struggle is real, my friends.

Several years ago, I created a Google Sheet with all of my books. Actually, I had my high school helper type up most of the titles and authors for me! Then, as I used a picture book, I would jot down the skill that I taught. I also added books that I borrowed from friends or checked out from the library.

Using this File

Remember Where It Is Saved

Once you opt-in above, you can access it from your Google Drive at any time. I like to bookmark mine to access it quickly and easily. If you use Google Chrome, click the little star in the corner of your browser. Then, it will appear just under your address bar. 

Know How to Sort

Using the sort feature, you can sort your books by title, author, or reading skill! It will help you find your books faster. This is seriously the game changer!

To sort, click on the column that you want to organize your books by. Then, click “Data” and “Sort sheet by Column ___, A–>Z.” You can choose and of the columns listed here!

Record Where to Find the Book

Do you own it? Did you borrow it? It is a library book? Use the drop down menu to record how you’ll get your hands on it again next year.

Pull It Up on Your Phone

Have you ever been in a book store and found a classic book you love at a great price? Can’t remember if you own it? Pull up the spreadsheet on your phone and find the title. You can quickly see if you should snag the book or if you already own a copy! You’ll just need the Sheets app on your phone. 
Follow:
Share:

1 Comment

  1. Ac Jitu
    Author
    April 9, 2020 / 10:21 am

    CBD can be used effectively for the treatment of things like difficult to treat pains, anxiety, inflammation, depression and even help alleviate things like menstrual cramps and migraines. royalcbd.com/product/cbd-oil-1000mg/

Leave a Reply

Your email address will not be published. Required fields are marked *

Close Me
Looking for Something?
Search:
Post Categories: