Posts

Showing posts with the label excel for genealogists

Born on St Patrick's Day: Happy 115th Mary

They say that its good luck to be Irish, and that the luckiest of all are those who are born on St Patrick's Day. No doubt this is what was said the day that my great grandmother was born. However, her life was not necessarily filled with the good luck that the superstition had predicted. As much as she had a hard life, her life was also an "ordinary" one of a young British immigrant to Canada. Despite that, the simple life she led in youth was filled with fun. She embrace the changing times, new found freedoms, and innovations. Its the heirlooms from that chapter of her life that fascinate me the most because they show a side to her that none of my relatives knew - a woman who was happy. So today, I am going to share the side of her - that one that the heirlooms tells. I have a small black autograph book that was hers.  At almost 100 years old, the book binding has all but disintegrated yet the leather cover is in near pristine condition and the partially bound pages are...
Post a Comment
Read more

How to Make a FAN Club Table in Excel

FAN club research is one of the most valuable types of research that a genealogist can perform. It can help breakdown brick walls and give you a better idea of what a person's life looked like. One of the main challenges we face when attempting this type of research is how we want to organize our information. In a previous post I explained how I use a network diagram to illustrate these relationships. Although this is a great way of interpreting the FAN club, it often lacks the space to properly record all of the information. I like to use a combination of a table and the network diagram.  How to Create the Table Sortable tables are a great way of displaying genealogical information in Excel. When they are created correctly, they allow you to quickly locate and/or group similar pieces of information. The tutorial on the Microsoft website provides a good walk through of the process.  Selecting the Headers The main focus of creating this table should be the headers. You want t...
Post a Comment
Read more

7 Tips to Become a More Efficient Genealogist

Image
Over the years my research practices have changed. Each revision I make is to shift my research towards becoming a more efficient and streamlined process. Maybe this is because of my professional background in process design, or maybe it is my inner desire to have everything as organized as it can be. Regardless it has caused me to develop ways of organizing my research that I have not seen anywhere else. Efficient research is not necessarily about having your research expertly organized in one form, but rather in many. Its about knowing which way of looking at the information will make it the easiest to understand for a particular research question.  Tip #1: Handwritten notes are not outdated To many the concept of using a pen and paper to take notes is a thing of yester-year, but to me it is one the easiest ways to capture an abundance of information in a concise space. When I was going through university I was one of the few students that still used a pen and paper for notetakin...
Post a Comment
Read more

Popular posts from this blog

Born on St Patrick's Day: Happy 115th Mary

They say that its good luck to be Irish, and that the luckiest of all are those who are born on St Patrick's Day. No doubt this is what was said the day that my great grandmother was born. However, her life was not necessarily filled with the good luck that the superstition had predicted. As much as she had a hard life, her life was also an "ordinary" one of a young British immigrant to Canada. Despite that, the simple life she led in youth was filled with fun. She embrace the changing times, new found freedoms, and innovations. Its the heirlooms from that chapter of her life that fascinate me the most because they show a side to her that none of my relatives knew - a woman who was happy. So today, I am going to share the side of her - that one that the heirlooms tells. I have a small black autograph book that was hers.  At almost 100 years old, the book binding has all but disintegrated yet the leather cover is in near pristine condition and the partially bound pages are...
Read more

Ford's Folly and the Slum of Little Hell

Image
Battersea: The Sinkhole of Surrey During the Victorian Era, Battersea had gained the reputation as being “the sinkhole of Surrey” due to its widespread poverty and slum-like conditions. Many of the poor in Battersea were subject to irregular income from the building trades. For a family to scrape by in the winter they would have to apply thrift spending during the summer. This was often complicated by the reliance on alcohol which was used as a means of escape from the depression of living in such widespread poverty. The irregular income caused many of Battersea’s poor to frequently be on the move. On average a family lived in one place for less than two years before moving no more than a few streets away. After hopping from neighbourhood to neighbourhood the family would eventually return to where they were once exiled from, moving in only a few doors away from their former address. Ford’s Folly and the slum of Little Hell In Keith Bailey’s report Orville Road, Battersea: a Victor...
Read more

F.A.N. Club: How to perform a Hub Analysis

Image
FAN club analysis is one of the most valuable tools at a genealogists disposal. Conventionally it is used to build a network of people around a single ancestor or family, however the process can be reversed to determine the nature of unknown relationships. The Hub analysis is a method that I came up with that helps break a large group of people into small social circles that are centered around something that they all have in common. For example, this could be a place of employment, worship, or even a club/hobby. By grouping the people in this way we can identify what subgroups exists within the FAN club (I wrote a post here on how these subgroups can be visually represented used a net diagram).  The easiest way to explain the process is by using an example. Lets take a look at a list of names that I found of people who called the family following my great grandfather's death.  **Please note that for privacy reasons I have redacted the full surname and addresses of any person...
Read more