Through the recommendation and help of Laura Chandler I have created a searchable book list for all the books I have reviewed. I knew I was going to need something more than the label feature in the sidebar so when Laura suggested this, I jumped on it!
The spreadsheet lists title, author, theme, reading level, if I created a freebie to go with the book and the link to a complete packet created for the book. To make finding the blog post about that book easier I have linked the title, theme and freebie to the review page on my blog. This spreadsheet will give you the opportunity to search and sort depending on your need {are you looking just for titles, for author, theme or reading level}.
As I review books I will update this list so it will always be current. Right now I have mainly K-3rd grade level books but I have just gotten started! I will be diving into chapter books as well as picture books geared for older grades.
I do have a page {CLICK HERE TO GO TO IT} on my blog just waiting for book suggestions from you. If there is a book you would like to have reviewed and just don't want to do it yourself, leave me a comment and I will help you out!
Now getting on to the spreadsheet...
In the side bar you will find an image {that looks like the one below} of an excel spreadsheet with the title "Book List".
When you click on the image it will take you to a Google Docs page of the spreadsheet {it will look like the image below}.
From here you can download it as an Excel document {or whatever you want to download it as} I would recommend Excel if you want to sort it by author, theme, or reading level. To do this simply click the file button and select "Download as" and then select Excel. The picture below shows the File button.
The spreadsheet will then open up in an Excel spreadsheet. If you are unfamiliar with Excel I will help guide you through sorting the document.
1. Have the document open {make sure it is the Excel document and not the Google Docs document}.
2. Highlight everything in the document except for the title {just like the picture below...without the green part}.
3. Click on the Data button at the top and then select Sort.
4. The Sort window will open and then you can choose how you want to sort the document using the pull down arrow under Sort, your choices will be the document headings {title, author, theme, reading level, freebie, packet for sale}. Also make sure the Header button is selected.
5. Press OK and the spreadsheet should be sorted according to your criteria.
Just let me know if you have any questions or problems with this.
Happy searching!
13
The spreadsheet lists title, author, theme, reading level, if I created a freebie to go with the book and the link to a complete packet created for the book. To make finding the blog post about that book easier I have linked the title, theme and freebie to the review page on my blog. This spreadsheet will give you the opportunity to search and sort depending on your need {are you looking just for titles, for author, theme or reading level}.
As I review books I will update this list so it will always be current. Right now I have mainly K-3rd grade level books but I have just gotten started! I will be diving into chapter books as well as picture books geared for older grades.
I do have a page {CLICK HERE TO GO TO IT} on my blog just waiting for book suggestions from you. If there is a book you would like to have reviewed and just don't want to do it yourself, leave me a comment and I will help you out!
Now getting on to the spreadsheet...
In the side bar you will find an image {that looks like the one below} of an excel spreadsheet with the title "Book List".
The spreadsheet will then open up in an Excel spreadsheet. If you are unfamiliar with Excel I will help guide you through sorting the document.
1. Have the document open {make sure it is the Excel document and not the Google Docs document}.
2. Highlight everything in the document except for the title {just like the picture below...without the green part}.
3. Click on the Data button at the top and then select Sort.
4. The Sort window will open and then you can choose how you want to sort the document using the pull down arrow under Sort, your choices will be the document headings {title, author, theme, reading level, freebie, packet for sale}. Also make sure the Header button is selected.
Just let me know if you have any questions or problems with this.
Happy searching!
