So, you’ve finished PiBoIdMo, and now you have all these great ideas. You’re on the road to publication!
Except, you still have to write the books. And that’s not an easy path.
A lot of people think that finding ideas is the hardest part of writing. It’s not. Finding ideas is very difficult, but figuring out which ideas to focus on first and which ones to let linger—that’s the killer. So that’s what I’ll try to help you with today.
Step 1: Get the easy stuff out of the way.
Some stories write themselves, or at least flow out of your mind effortlessly. Get those down on paper first—there’s no reason to not take the path of least resistance.
Step 2: Organize and analyze.
You’ve got 30 picture book ideas. Maybe more. Do you write manuscripts for them in alphabetical order? Chronologically? By order of the number of feet the main character has?
You could do any of those things, but it’s probably not the most efficient route to publication. So instead, I have a system. Here’s where I get nerdy.
You know that program called Excel that math people use but us creative types stay away from? Find it on your computer and start it up. We’re going to create a spreadsheet of ideas.
The idea here is to sort your ideas by various relevant characteristics to make sure you end up with a varied portfolio. After all, just like an illustrator has a style but needs more than paintings of bunnies to create a portfolio that will get him or her contracts, writers need to show range, too. You don’t want your own books to compete with each other —you want every book to have its own independent niche.
Column headings. The column headings will give you a way to list the relevant characteristics and sort your ideas using these.
Everyone may have different column headings, but here are some common ones that everyone should have:
- Title (Obviously)
- Character type (What kind of animal? How old of a human? Etc.)
- Theme
- Setting
- Problem type (Is it a monster? A bad teacher? A parent? A wild animal?)
- Age range (will this be a young PB or one for older kids?)
- Hook (I may actually separate this into sub-categories to make it easier to sort.)
– Institutional hook
– Holiday tie-in
– Developmental milestone
You can add any more headings that make sense to your work.
Create the spreadsheet. Now take all your PB ideas and start filling in the blanks. Now, you may not have a fully fleshed-out plan for each idea—that’s fine, just fill in as much as you can. And this is a place to do some research, too. Look at the market—are there hooks that are more popular than others?
Analyze your data. So you’ve entered your 30 ideas. Now we’re going to rank them.
You probably don’t want to write 16 books about pigs. It would be hard to get them all published before you establish a reputation. Same thing with 6 books about monsters or 3 books about pirates. So look at your spreadsheet and start seeing how you can sort the data.
If you’ve never used Excel, here is a quick tutorial: use the mouse to highlight all your data (not the column headings) and then click on Sort & Filter (in the Data tab of my version of Excel). You should then be able to sort by any of the columns. So if you sort by the column of Character Types (Column B in my spreadsheet) and sort on Values with the Order set to A to Z, all your entries will be rejiggered so you can see all your pig ideas next to each other and all your monster ideas will be next to each other.
Now look more closely at those similar ideas. Is there one that is particularly appealing? Stronger than the others? Incorporating more hooks? Move that to the top of the list. To create that varied portfolio, go through and pick only one idea from each “type” to work on first. When you notice ideas that seem too similar, delete one of them.
Step 3: Write!
I recommend getting a list of about 6 ideas to work on at a given time. Fewer than 6 and you may hit writer’s block, more than 6 and it is hard to keep everything straight. So keep looking at the ideas until you pull 6 good ones. Now you have a plan! From here, all you have to do is write a great manuscript, revise until it is perfect, market it until you find a home, wait for the illustrations, plan for the release, figure out promotions…well, that’s a post for a different day, isn’t it?
In the meantime, go figure out what to work on….
.
Sudipta Bardhan-Quallen is the award-winning author of many, many books for children, including picture books, nonfiction for young readers, and a forthcoming chapter book series called THE SPECTACLES OF DESTINY (due out in 2014). Her newest release is THE WORST TWELVE DAYS OF CHRISTMAS, illustrated by Ryan Wood. In this spirited reworking of the classic song “The Twelve Days of Christmas,” Joy has to deal with her first Christmas with a new baby brother—and nothing could be worse. A sweet surprise turns the tables on Joy, who eventually appreciates what her baby brother adds to the holiday.
Sudipta speaks at conferences, educator events, and schools across the country, teaching the craft of writing to children and adults. She lives outside Philadelphia with her three children and an imaginary pony named Penny. Learn more about her and her books at www.sudipta.com. She also blogs at NerdyChicksRule.com, so go subscribe for witty bookish quotable things.
40 comments
Comments feed for this article
December 7, 2012 at 3:31 pm
laurimeyers
I LOVE a good spreadsheet and this is a wonderful idea. I have a word document but it just goes on and on and I’m rarely inspired by it. This will help!
December 7, 2012 at 3:35 pm
juliebehm
I love this idea. So much easier than trying to go through a ton of notebooks and journals. Plus easily accessible from my iPad and iPhone. Wonderful, thank you!
December 7, 2012 at 3:37 pm
Sue Heavenrich
I’m pretty sure one of my column headers will be number of feet…. just sayin’.
December 7, 2012 at 3:53 pm
Jacqueline Adams
Thanks for the tips! I like the suggestion to work on 6 ideas at a time–that’s something I’ve never tried.
December 7, 2012 at 3:54 pm
Jenn DesAutels Illustrator
Great advice – thank you Sudipta!
December 7, 2012 at 4:33 pm
wendy greenley
The spreadsheet is an interesting idea–I’m betting just the act of reorganizing the ideas in a different format will help me revisit them with fresh eyes. Thanks, Sudipta!
December 7, 2012 at 4:38 pm
Valarie Giogas
Very interesting idea, Sudipta. I’ll have to keep it for after the holidays. Thanks!
December 7, 2012 at 4:46 pm
Robyn Campbell
Excellent tips! So appreciated. Organizing is so important. I needed this. *waves*
December 7, 2012 at 4:52 pm
Saba
Thank you for the post. I never thought to use excel to organize my ideas.
December 7, 2012 at 5:04 pm
Jill Proctor
What a great idea. I have never used excel, but I will give it a try! Thanks, Sudipta!
December 7, 2012 at 5:24 pm
LeslieG
Excellent (pun intended) idea!
December 7, 2012 at 5:58 pm
Genevieve Petrillo
Spread sheets scare me, but I do love the idea of working on more than one story at a time. It keeps me block-proof.
December 7, 2012 at 6:02 pm
Anjali Amit
What a great way to sort and analyze. We do tend to bumble along the same path — sixteen pig stories, eleven monsters and robots — good heavens. Thanks for showing an easy way to avoid that.
Anjali
December 7, 2012 at 7:14 pm
Jarm Del Boccio
What a unique way to sort and flesh out our ideas…thanks so much, Sudipta! And, your new books sounds like a fun read…
December 7, 2012 at 7:28 pm
The Backdoor Artist
Great post-PiBoIdMo post…Thanks!
December 7, 2012 at 8:00 pm
tinamcho
What a great idea to use an Excel spreadsheet. I’ll have to try it. Wow, 6 ideas at a time?! I’ve never had that many at once. Thanks, Sudipta! Your new book looks fun!
December 7, 2012 at 8:54 pm
Jenny Boyd
Thanks for the EXCEL-lent advice!
December 7, 2012 at 9:24 pm
Beth Gallagher
Fabulous idea, especially for a super organizer like myself. 🙂 Thanks for the inspiration and direction to getting my ideas into a concise list.
December 8, 2012 at 12:07 am
Talynn Lynn
But I love my notebook whet I can add folders for pictures and research:) I will, however, try a spreadsheet. At least for my master list. One glance and I know what my ideas include for inspiration!! Thanks for such a helpful post!
December 8, 2012 at 4:31 am
mona
Sudipta, your ideas and lessons never get boring! Thank you for this spreadsheet idea. For the rest of you here on BiBo, wish you could all take one (or 2) of Sudipta’s picture book workshops in person-fantastic!
December 8, 2012 at 7:58 am
Alison Hertz
Sudipta, I like the spreadsheet suggestion. My crit group mocks me for my detailed spreadsheet of ms submissions. This sounds like a sorting that I need to do with my idea list.
December 8, 2012 at 10:23 am
B.J. Lee
So that’s how Excel works! Thanks for the tip. I’m going to try it out! BTW, love your books.
December 8, 2012 at 10:54 am
Joanne Roberts
A concise plan is a huge help to me. It is great to know a seasoned writer like yourself has 6 ideas she’s juggling. Thanks for the advice.
December 8, 2012 at 11:53 am
Brenda Harris
As I read your great organization hint, my inner “live by the moment” self admired your creativeness. I’ve saved your post to meditate on. I hope to use it. Thanks. 🙂
December 8, 2012 at 12:11 pm
thiskidreviewsbooks
Thanks for helping me! 🙂 “The Worst 12 Days of Christmas” looks really good!
December 8, 2012 at 1:17 pm
Penny Klostermann
What a helpful post! Thanks! Organization is something I can always use more of!!!
Your books are incredible!
December 8, 2012 at 3:18 pm
Sheri Rad
Thank you for structuring this so I can see past the trees and get something done now that I have the ideas and only a few that wrote themselves.
December 8, 2012 at 3:54 pm
Sharon Putnam
Thanks for the great advice! I’ve never worked on 6 ideas at once, however I usually work on 2-3 manuscripts at the same time
December 8, 2012 at 10:46 pm
Melanie Ellsworth
I started using Excel to keep track of submissions, but I like your idea of using it to track and compare ideas as well. I just may give that a try!
December 8, 2012 at 11:45 pm
SevenAcreSky
Sudipta, yes, it’s gonna take a plan…and since I am not a natural planner, this post is priceless. I’m printing it to put it on my wall. Thanks!
December 9, 2012 at 8:41 am
Angela De Groot
How clever! And I love Excel so I’m game to start this right now.
December 9, 2012 at 9:27 am
Felicia Lilley
I found this post to be extremely helpful. One of the best things I’ve read so far. Thank you so much for this idea. I am an illustrator, not a writer. I have lists of certain types of things that I need in my portfolio when I go to the SCBWI conferences. This is going to help me so much as I write.
December 9, 2012 at 9:55 am
Dawnyelle
Pinning this post up in the studio
December 9, 2012 at 2:13 pm
Carolyn Cory Scoppettone
Thanks for a big help to those among us who are organizationally challenged.
December 9, 2012 at 6:47 pm
ptnozell
Very familiar with excel, but had never thought to sort PB ideas (or the manuscripts I’ve written) in this way. Thanks so much for your very helpful suggestions!
December 9, 2012 at 9:10 pm
Jennifer Rumberger
Love this post! As an organizer, having a new way to sort ideas is very helpful. Never imagined excel could be used in this way. Thanks!
December 9, 2012 at 9:12 pm
Pat Miller
This is just what I need to take the next step with all these ideas. Thanks so much!
December 11, 2012 at 11:02 pm
Linda Graden
What a great idea! Who would have thought? Thank you. Very impressive bio!
December 12, 2012 at 12:38 pm
Rachel Hamby
I love this idea! Thx.
December 15, 2012 at 6:42 pm
Elizabeth Rose Stantone
Very helpful post…and quite timely for me. Thank you!