The Starred Reviews spreadsheet collates the stars from six different journals: Booklist, the Bulletin of the Center for Children’s Books, Horn Book, Kirkus, School Library Journal, and Publishers Weekly. I started this spreadsheet in 2011 and continue to update it monthly.
For each year, there is a page with the starred titles listed and a page listing the journal issues for the year. After I enter the stars from a journal issue, I highlight the cell for that issue in blue on the journal page.
On the title pages the different colors indicate how many stars a title has because that helps me to visually sort titles. Here’s the key:
- 6 stars=Orange
- 5 stars=Purple
- 4 stars=Green
- 3 stars=Blue
- 2 stars=Peach
- 1 star=no fill
In the top row to the far right is the count of how many 3, 4, 5, and 6 star books there are for the year. For each title that receives a star, I note the following: Journal, Issue Date, Title, Author, Illustrator, Age, Format, and Genre. Starting in 2015 based on reader suggestions, I’ve also added columns with Release Date and Number of Stars. The first four categories are pretty basic, but here’s a few notes on the other columns:
- Illustrator: If this cell is blank it means that either there is no illustrator or the author is the illustrator.
- Age: Taken from the review – you’ll notice that journals often do not agree on the age range for titles.
- Format: I choose what goes in this column depending on what makes sense to me, but sometimes it’s a toss-up. Is that a longer picture book that has non-fiction content or is it non-fiction? I take my best guess.
- Genre: Some of the journals will designate a genre on their reviews. Others don’t. If I think I know the genre, I’ll list it here. Sometimes I leave this blank if it doesn’t seem obvious or if it’s something that hits several genres and I’m not sure which is dominant. This is the most subjective column.
- Release Date: Again – some of the journals contain the precise date (thanks Kirkus!), others just contain a month, others a year. If all I have is the year I don’t put anything. Sometimes when I’m not too busy (so….not very often), I’ll go back and look up release dates in Baker & Taylor.
- Number of Stars: Makes it easier to sort the spreadsheet.
You’ll occasionally see other data to the right of these columns depending on what I was interested in each year.
You’re welcome to use the data on this spreadsheet for personal projects or collection development. The spreadsheet is set to view only, but if you would like to add your own additional data or manipulate it you can create a copy and edit that. Please attribute me as the source of your data if you use it for school projects or anything you publish online or in print.