SUBSCRIBE
SUBSCRIBE
SLJ Blog Network +
  • 100 Scope Notes
  • A Fuse #8 Production
  • Good Comics for Kids
  • Heavy Medal: A Mock Newbery Blog
  • Teen Librarian Toolbox
  • The Classroom Bookshelf
  • The Yarn
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • About/Contact
  • Fusenews
  • Reviews
  • Librarian Previews
  • Best Books
    • Top 100
    • Best Books of 2022
    • Best Books of 2021
    • Best Books of 2020
    • Best Books of 2019
    • Best Books of 2018
    • Best Books of 2017
    • Best Books of 2016
    • Best Books of 2015
    • Best Books of 2014
    • Best Books of 2013
  • Fuse 8 n’ Kate
  • Videos
  • Press Release Fun

April 22, 2011 by Betsy Bird

Announcing a New Poll . . . But First!

April 22, 2011 by Betsy Bird   28 comments

There’s a baby on my horizon.  A big beautiful time-consuming baby (helloooo, new blogging thrice a week schedule).  With that in mind it’s time for . . .

YET ANOTHER FUSE #8 PRODUCTION POLL!!!

Yeah.  I’m not sure exactly when I will have said poll what with the aforementioned Bird spawn, but it’s going to be in 2011, you bet.  And I’m going to keep the nature of the poll a secret for now.  In the past we had the Top 100 Picture Books Poll and the Top 100 Children’s Novels Poll (which lost ALL its images when we moved to a new site, consarn it).  I’m not a YA person so we’ll eschew a Top 100 Young Adult Novels Poll for now (Persnickety Snark, amongst some others, already covered that territory more than adequately anyway).  So what will it be?  It’ll be good, you bet.  But more on that later.

For now, I need your help, citizens of the world.  Here is how a typical poll has worked the last two times:

  1. Betsy announces poll.
  2. Betsy receives votes from one to ten in the order of a person’s preference, with their number one choice getting 10 points, their number two choice getting 9, etc.
  3. Betsy then systematically calculates each one of these numbers onto a spreadsheet, eating up sheer hours of time that could be better spent rewatching old episodes of The Good Neighbors (also known as The Good Life to you Brits out there).

I think it is time for the madness to end.  How?  One little word: Algorithm.  Is there any way for someone to create an Excel or similar spreadsheet algorithm wherein the poll’s creator plugs in the data and the spreadsheet calculates the points?  I have no idea.  Spreadsheets aren’t really my thing, but my faith in them (as of right now) is extreme.

SCROLL TO KEEP READING THIS POST

ADVERTISEMENT

ADVERTISEMENT

So I appeal to you, oh readers who are cleverer than I.  Does anyone know of such a program?  Or, better yet, how to create one?  Once we get that little detail down the poll will officially begin.  Stay tuned . . .

Filed under: Uncategorized

SHARE:

Read or Leave Comments

About Betsy Bird

Betsy Bird is currently the Collection Development Manager of the Evanston Public Library system and a former Materials Specialist for New York Public Library. She has served on Newbery, written for Horn Book, and has done other lovely little things that she'd love to tell you about but that she's sure you'd find more interesting to hear of in person. Her opinions are her own and do not reflect those of EPL, SLJ, or any of the other acronyms you might be able to name. Follow her on Twitter: @fuseeight.

ADVERTISEMENT

Related Posts

March 2023

Announcing the Stinetinglers Winner! The Kettle's Dark Secret by Clara J.

by Betsy Bird

March 2023

Bologna Presentations: IBBY Doing the Good Work That Needs to Be Done, Worldwide

by Betsy Bird

February 2023

Sydney Taylor Book Blog Award Tour Interview: Featuring Mari Lowe of Aviva Vs. the Dybbuk!

by Betsy Bird

January 2023

The Top Ten Most Disappointing Edibles and Potables of Children's Literature

by Betsy Bird

January 2023

Announcing the 2023 Newbery/Caldecott/YMA Pre-Game Show!

by Betsy Bird

ADVERTISEMENT

SLJ Blog Network

100 Scope Notes

U.S. Gov: ‘All Books Must Have Round Corners’

by Travis Jonker

A Fuse #8 Production

Review of the Day – Bear and Bird: The Picnic and Other Stories by Jarvis

by Betsy Bird

Good Comics for Kids

Review: Swim Team

by Esther Keller

Heavy Medal

March suggestions: early Mock Newbery possibilities

by Emily Mroczek-Bayci

Teen Librarian Toolbox

Write What You Know. Read What You Don’t, a guest post by Lauren Thoman

by Amanda MacGregor

The Classroom Bookshelf

The Classroom Bookshelf is Moving

by Erika Thulin Dawes

The Yarn

Jarrett and Jerome Pumphrey Try Something New

by Travis Jonker

ADVERTISEMENT

Related Articles on SLJ

2 World War II Memoirs for Middle Grade & YA Readers

Organizations Respond to Virginia Suit Against Barnes and Noble and More | Censorship Roundup

Books Restricted, Removed in MS, IA, OR, and FL Districts; 'Out of Darkness' Stays at NC High School | Censorship Roundup

Exploring Civil Rights, Year By Year!

SPONSORED

Making a Mark on Musical History: Flack, Franklin, and Beach | Biography Spotlight

About Betsy Bird

Betsy Bird is currently the Collection Development Manager of the Evanston Public Library system and a former Materials Specialist for New York Public Library. She has served on Newbery, written for Horn Book, and has done other lovely little things that she'd love to tell you about but that she's sure you'd find more interesting to hear of in person. Her opinions are her own and do not reflect those of EPL, SLJ, or any of the other acronyms you might be able to name. Follow her on Twitter: @fuseeight.

Reader Interactions

Comments

  1. Jed says

    April 22, 2011 at 10:20 am

    OK… I’m a musician, not a data analyst, but here’s what I would do.

    Use Google Forms to create the poll, and it’ll generate the spreadsheet for you. Imagine that the names of voters are in the first column, with their book titles in columns B-K.

    So what you do is create a row beneath all voters for each book receiving votes (the only major data entry, and I can’t think of a way around it). There is a formula (countif) that counts how many times a particular string characters appears in any given column or row, so you just use that in each row to count how many times that book appears. Then a little addition/multiplication formula in column L and you’re set!

    Sample formulas:

    For each book, use something like =countif(B1:B335, “Uncle Shelby’s ABZ Book”) in each column, B-K.
    and then in column L, it would be something like =B336*1+C336*2+D336*3 all the way till +K336*10, etc.

    The biggest hurdles is typing in every book that receives a vote, but you can probably find a shortcut for that. The one challenge is that you’re depending on accurate typing by all voters in the poll…if someone mistypes a word, it won’t be counted using my system above. (You can create a double check, adding all the spreadsheet-totaled votes in each column to make sure it matches the number of votes.)

    Gosh, that sounds much more confusing written down than in my head. Hopefully someone else has a simpler explanation or method…

    • Elizabeth Bird says

      April 22, 2011 at 12:17 pm

      Considering the kind of poll I’m thinking of, I do indeed have a shortcut in mind. Thanks! This is far better than what I’ve been working with, after all.

  2. Jennifer Schultz says

    April 22, 2011 at 12:23 pm

    Aww. For a second I thought this was going to be a baby name poll! 😉 Regardless, looking forward to a new poll, whatever it may be.

  3. Matt Phelan says

    April 22, 2011 at 1:43 pm

    I don’t know anything about algorithms but Good Neighbors is a great show.

  4. Sharon says

    April 22, 2011 at 2:13 pm

    Ooh, a new poll. How exciting. I didn’t get to participate in the picture book poll, but I did have fun with the chapter book poll. Betsy, I don’t know how you do it, but I’m glad you do!

    • Elizabeth Bird says

      April 22, 2011 at 3:00 pm

      I love the idea of a baby name poll. My fear, however, is that my readers have too good a sense of humor and I might end up with a Chronicle Bird after all (which, let’s face it, is an AWESOME name). And Matt, next time I see you we are talking Tom & Barbara.

  5. Kiera says

    April 22, 2011 at 4:02 pm

    Maybe Survey Monkey? You might be able to configure a survey that is poll-esque by using the Rating question type. It’s pretty easy to use, the basic version is free, and you can download the data into an Excel spreadsheet.

  6. Ed Spicer says

    April 22, 2011 at 4:23 pm

    A table with 13 columns. A is author, B is title. C-L are 1st through tenth place. In C you put in the formula: # (of votes) times 10. In D you put # times 9, etc. In the last column (M) you put in a formula that sums C-L. And when you have all your data, you sort by M (and then by A and then by B). If you want other information, add more columns and adjust accordingly.

  7. Eric Carpenter says

    April 22, 2011 at 6:52 pm

    I’ll send you an email sometime this weekend.

  8. Mark Flowers says

    April 22, 2011 at 7:24 pm

    My co-workers did a Baby Name poll for my son and told me I had to name him Dewey Hugo Flowers.

    I went with Taran (which, you probably don’t recall from my Chapter Book Poll entry, is the hero of one of my ten favorite children’s book – it all ties together).

  9. Sarah McClure says

    April 22, 2011 at 7:54 pm

    When is this little baby due, by the way? I find myself checking your (wonderful) blog not only excited for Fusenews but for baby news, too! I do NOT mean this in any kind of weird way, promise.

    • Elizabeth Bird says

      April 22, 2011 at 9:53 pm

      Thank you, Eric. I knew I could count on you.

      And Sarah the wee bird is due June 12th! Which, if I know anything about my family history, probably means June 26th instead. I did a big post on it a while ago, but the name of it eludes me. “Bird” was certainly in the title in some way. Hmmm…

  10. Jeannie B. says

    April 22, 2011 at 11:41 pm

    Sarah! I didn’t know. How very extremely exciting. Secret Garden, yes?

  11. Karen Gray Ruelle says

    April 23, 2011 at 12:03 am

    Oh, I was hoping for a New-Baby-Naming-Poll, too. By the way, I Love Good Neighbors, too!

    Say, if Baby Bird is five days late s/he will be born on MY birthday! (I’m just sayin’.)

  12. Sister says

    April 23, 2011 at 2:17 am

    My company has used SurveyMonkey in the past, I recommend it (user friendly and free!). And maybe you could do two polls, the rather being not of the name, but of the due date? That seems more up in the air!

    • Elizabeth Bird says

      April 23, 2011 at 2:44 am

      Well, the only problem with online sites like SurveyMonkey (and correct me if I’m wrong) is that you can’t plug in the info yourself, right? Wouldn’t these work better if a better laid out the choices and then people voted? I want people to list whatever name they want, nothing pre-established.

      All due dates are up in the air, little sis. Just because you have one doesn’t mean it’s a go necessarily. Ya gotta give it some time, just in case.

  13. Jeannie B. says

    April 24, 2011 at 7:04 pm

    Okay, so I realized in the middle of the night that I’d gotten my Burnett novels mixed up. Of course I meant the other one about the Princess. Whose name was spelled Sara, I think, not Sarah. Maybe I’ll change my whole tack and guess that you’re naming Baby Bird after he second sister in ALL OF A KIND FAMILY. Signing off in embarrassment . . .

  14. Yukari says

    April 25, 2011 at 7:13 am

    I asked my husband, who is getting his PhD in Social Research Methodology (basically, running stats programs), and just off the top of his head he also thought that creating a Google forms poll might be a good way and then exporting the data into Excel. (I’m sure you encountered this in past polls, but one of the problems is that each person will submit and input data (i.e., titles) differently and it becomes time-consuming to standardize that. Hence, it may be a good idea to have people submit via a poll/survey website.) He was rambling off ways to plug in pretty simple formulas to assign points to titles, but somewhere along the way I totally lost him. Of course, he would prefer to run the data in his stats programs but I have no idea how to even begin describing how to do that. I would be more than happy to get more details from him if you’d like … he kind of got excited when I asked him about it; he doesn’t usually get excited when I talk about children’s literature.

  15. Briar says

    April 25, 2011 at 7:16 pm

    Just another voice of encouragement to use a Google Form since it populates a spreadsheet automatically. If you play around with the different poll formats and see what the results are like, you’ll get an idea of how it might best work. The first comment here gave the formula you will probably want to use (COUNTIF). I use Google Forms for student work and polls all the time and I just look in the Google help forums whenever I run into trouble. Someone always has it spelled out for me perfectly clearly. Can’t recommend the whole setup highly enough.

  16. My Boaz's Ruth says

    April 25, 2011 at 7:50 pm

    Here is the post when you announce the wee one: https://blogs.slj.com/afuse8production/2010/11/29/for-when-you-announce-youre-brooding/comment-page-2/#comment-83702

    (I have it bookmarked because I keep looking for updates)

    I’d use a database for what you want — better reporting capabilities.

  17. Kathy J says

    April 25, 2011 at 9:16 pm

    LOVE The Good Neighbors — Penelope Keith is my idol. If you’ve never seen TO THE MANOR BORN, it’s a hoot!

  18. Beth S says

    April 26, 2011 at 4:00 pm

    I have no idea, but my husband, an economist, says:
    Have individuals supply the ISBN number in addition to the title. Then you can sort and sum on the ISBN number.

  19. IF says

    April 27, 2011 at 3:41 pm

    So, my entry in the baby naming poll: Free.

    (Sorry, couldn’t resist.)

  20. IF says

    April 27, 2011 at 3:42 pm

    Assuming last name Bird, of course.

  21. Sondy says

    April 28, 2011 at 2:36 pm

    Ooo! If the baby comes on June 14th, we will share a birthday! And your baby will be proud all his or her life that her birthday is a HOLIDAY! The best holiday in the year: Flag Day!

  22. RM1(SS) (ret) says

    August 10, 2011 at 1:43 am

    So. A poll….

    • Elizabeth Bird says

      August 10, 2011 at 1:12 pm

      Yep yep yep. Just as soon as that baby starts eating up slightly less time, I finish my nonfiction book (this month), and I’m back to work (next month) we’ll get that poll ah-rolling.

  23. Tayyab Saeed says

    August 16, 2011 at 9:57 am

    Wow! I’m REALLY excited! I just recently found out about the previous polls. Good lists, (though many times I disagreed with some of the choices and such) so a new one would be even better! So what is it going to be this time, huh? Top 100 Nonfiction books? I would love that one (especially because Snowflake Bentley was not in the Picture Books list).

ADVERTISEMENT

Archives

  • External Links

    • A Fuse #8 Production Reviews
  • Follow This Blog

    Enter your email address below to receive notifications of new blog posts by email.

    This coverage is free for all visitors. Your support makes this possible.

    This coverage is free for all visitors. Your support makes this possible.

    Primary Sidebar

    • News & Features
    • Reviews+
    • Technology
    • School Libraries
    • Public Libraries
    • Age Level
    • Ideas
    • Blogs
    • Classroom
    • Diversity
    • People
    • Job Zone

    Reviews+

    • Book Lists
    • Best Books
    • Media
    • Reference
    • Series Made Simple
    • Tech
    • Review for SLJ
    • Review Submissions

    SLJ Blog Network

    • 100 Scope Notes
    • A Fuse #8 Production
    • Good Comics for Kids
    • Heavy Medal
    • Neverending Search
    • Teen Librarian Toolbox
    • The Classroom Bookshelf
    • The Yarn

    Resources

    • 2022 Youth Media Awards
    • The Newbery at 100: SLJ Celebrates the 100th Anniversary of the Award
    • Special Report | School Libraries 2021
    • Summer Reading 2021
    • Series Made Simple Spring 2021
    • SLJ Diverse Books Survey
    • Summer Programming Survey
    • Research
    • White Papers / Case Studies
    • School Librarian of the Year
    • Mathical Book Prize Collection Development Awards
    • Librarian/Teacher Collaboration Award

    Events & PD

    • In-Person Events
    • Online Courses
    • Virtual Events
    • Webcasts
    • About Us
    • Contact Us
    • Advertise
    • Subscribe
    • Media Inquiries
    • Newsletter Sign Up
    • Content Submissions
    • Data Privacy
    • Terms of Use
    • Terms of Sale
    • FAQs
    • Diversity Policy
    • Careers at MSI


    COPYRIGHT © 2023


    COPYRIGHT © 2023