Changes I Have Made in Analyzing my Data

These past few days, I have been asked what I am doing differently in my research that is different and bringing me results. Well, let me start with the lecture I attended at Dupage Genealogical Society, I learned a great deal about analyzing my evidence in a new way (new to me). You can read about this lecture here. If you have not heard Jennifer Holik speak I recommend that you do. She really opened my eyes on how I can be a better researcher. In the past, as I found records that pertained to my family I would add the information to my tree whether on line on ancestry or in my Reunion database. Sometimes if it was a family I was really working on, I might fill out a Family Group Sheet so that I can look everything over. This has worked for me to see the big picture, but it never really opened my eyes to the BIG picture of what I was missing and where I should be looking to find it. A few weeks ago, I started creating some worksheets on my computer so that I could type the information in and not have so many papers in a hard file. That helped some as well, but again no huge eye opening moments. Then I attended the above mentioned lecture and changed how I am looking at my information. I never thought to pull my families into spreadsheets to see what I am missing and try to figure out where I should be looking. For example, I am researching the Jonas family from Morton Grove, IL and I have many questions on the family:

  1. Who is the unknown child that I cannot find reference to?
  2. Are John and Ida (Vick) Jonas related to this family?
  3. Is John the missing child?
  4. Is this Jonas Family related to the Jonas family in Park Ridge, IL (the two towns are close)

So, I put together a spreadsheet with address information from the US Census records, please click Jonas Family in the Census Records to view spreadsheet. All of the green shaded areas are missing information. All of the grey shaded areas tell me not to look there, they were not alive at this time. I also made any notations at the bottom of the sheet.

Now obviously this only tells me what I am missing, not want I want to know. That is the next step. Jen talked about using One Note (for PC users) to keep your notes on this family and that this is what she uses to start formatting the books she is writing. Well, I am not a PC user and was upset as we went through this because it just made sense.

Luckily, sitting in front of me was Patricia Biallas of GeneaJourneys and her husband. While Jen was talking, Mr. Biallas was looking online to see if there was a substitute for the Mac and there was. The Mac alternate is Growly Notes and it is a free download, double score for the night.

Well, once I downloaded Growly notes and played with it some, I started a file for the Jonas family adding information I had from the records I have already collected. Once the information was listed, I would add the questions I had and where I needed to look for the answers. Turns out I had some of the answers, I just was not truly looking at all the information I had.

You see, this second Jonas family has thrown me for a loop. They are buried right by my family, lived close in proximity and supposedly came from the same town in Germany. I originally thought they might be brothers and then I as I looked at the dates, I thought maybe my Jonas could be a son of the Park Ridge Jonas. Anything is possible, right?

Well as I went through each hypothesis I had I was able to dismiss them based on the records I had or was able to find once I knew what I was looking for and what I should be looking for. Click on Wilhelm Jonas  to see some of my information.

Here are some of my Notes that helped me work through my questions on this family and here are my notes about the two Jonas men, Are John and William related? Please click on each of these links to read my thought processes and see how I worked through all of the information. I was not in favor of putting my information into a third database, but it is obvious that it is helping me answer my questions about these families.

So it is definitely worth the time and effort it takes to use these methods to analyze and make you reread all the records you have.

What are your thoughts? Have you been utilizing spreadsheets to look at your information? What works for you?



Similar Posts


    1. Pat, thanks for reading. Her tips have really helped, hope you have the same amount of success. You are so welcome for the mention.

  1. Thanks for sharing your working notes. It’s so helpful to see how others analyze information. And for me, mired in transcriptions and scanning, it’s a taste of what’s to come when I can return to researching. Well done!

    1. Thanks Susan, it definitely opens my eyes when you watch what other people are doing. Good luck with all of the transcriptions and scanning, that’s a lot of hard work.

  2. GREAT post, Terri! I’m also finding that I need a way to document my thought processes, as well as the “facts” that I find. I started using OneNote for this several months ago and I need to get back into the habit. I love the spreadsheet you created to track the addresses of your Jonas family. I think that spreadsheets are an essential tool for genealogy that don’t get used enough. I saved yours to Evernote so that I can refer back to it.

    1. Thanks, Tonia. Glad I am able to help others, even if it is something I am just learning. I also received emails from people saying they wish more people would share what they do to analyze their data. Hopefully, this will help many others.

  3. I’m glad I came upon your blog, and your spreadsheet… that’s a good organizational tool, I haven’t seen that before. Thanks for sharing it!

  4. Terri,
    I loved your post and now want to find One Note. It didn’t come with my version of Office. I, too, have used spreadsheets, especially for land records. It really helps track the purchase and sale of land parcels.

    1. Thanks, Lisa.

      I hope you are able to find One Note, not sure about the price, but your local electronics store should carry it.

  5. Terri, this is amazing! I bet that I could also use my new love… Springpad. I can make notes and arrange/drag them around on a board to see connections, etc. I’ve got all of your docs opened up, and my notebooks are coming right behind them. I think I know how I’m spending my Tuesday. 🙂

    1. Thanks Steph! Is Springpad a PC based program? I know you have the Ipad as well. Let me know how it works for you! Glad I could give you something to do today!

      1. Springpad is fantastic! You can run it on your phone (iphone or android), your browser, and your ipad. It syncs everything just like a dream – and you can share with friends if you are working on the same project. I just haven’t gotten to that point yet. There are a lot of great posts on how to use it as well as a lot of great links to go through on their support site. And, it’s free. 🙂

        1. Thanks for leaving the link, I will check it out and I know other readers will too. Ohh, and I love that it is free!

    1. Thanks, Helen. They absolutely are. My hope that by blogging about them more people will begin to analyze their information in different formats to make sure they get all of the information, from every record.

      1. Thanks, Laura. I absolutely did! I am now spending time going through my past research to see if I can gleam some new information from records I already have copies of.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.