- 25 Jan 2020 – Excel for Genealogists at the California Genealogical Society.
- Jun – Excel for Genealogists at Sutro Library.
- 25 Jun 2020 – LGBTQ Genealogy at California Genealogical Society.
- Citations – proposed
This two-hour presentation focuses on clues in the genealogical records to find ancestors that may have been Lesbian, Gay, Bisexual, Transgender or Queer. Stewart tells stories of many LGBTQ ancestors in the historical context of LGBTQ rights. Clues to ancestors can be found in photographs, census, newspapers, obituaries, cemeteries, military records, marriage records and LGBTQ Archive around the world. The presentation is both factual and emotional in portraying LGBTQ people in the past centuries.
The second part of the presentation focuses on current genealogical software and the difficulty faced by LGBTQ and adoptive family. Sometimes the software just doesn’t fit. Stewart makes recommendations on how software needs to evolve for today’s families.
Listen to a Podcast of Stewart discussing LGBTQ Genealogy on Bespoken Bones.
- Increase awareness of clues in the genealogical record that will raise a “rainbow flag”.
- Write about LGBTQ ancestors just like any other person in a tree, openly and honestly.
- LGBTQ, adoptive and step families all have similar struggles with current genealogy software.
Excel for Genealogist
Stewart loves spreadsheets! He uses spreadsheets at work every day as an IT Manager. He is an expert in Microsoft Excel using it in genealogy very frequently. Laying out all the data in Excel can help researchers see gaps in knowledge or correlations between data points. Breakthroughs can easily happen by visualizing data in spreadsheets. Stewart shows many examples of his use of spreadsheets to track newspaper clippings, a vital records catalog, tracking ancestor addresses over time, and tracking whole families over many census. Stewart trains users to use Excel filter, sorting, color coding, calculations and many other functions.
Spreadsheets are fun!
- Basic Excel functions that aid in analysis of genealogical data.
- Explore several methods for date calculation, especially date prior to 1900.
- Complete a 19-lesson exercise in class or at home.
A discussion for beginners on how to get started. After you’ve record all the oral histories from living relatives, especially the oldest, what to do with that information. I cover organization methods, citations, software – both desktop and online, paid and free online resources, where to look for offline resources. Most importantly I discuss an individuals purpose and end-goal which will also inform their level of effort and detail in preserving family history.
- How to get started documenting family history.
- Understand online and offline software options.
- Introduction to major online sources.
28 July 2019 – 1947 Partition Archive