DNA Handout #3 from June WCGS meeting - Things you can do with your autosomal DNA results

 This handout was curated and created by Cini Gage. She wanted to share some of the many tools that we have been working with over the last couple of years. Please click on the images to view a larger version. This was formatted as a landscape spreadsheet and requires screenshots to get it to fit blog format.

Things you can do with your autosomal DNA results

click to see larger size

DNA Handout #2 from June WCGS meeting - Leeds Color Matching

Leeds Color Matching Sorting Method for atDNA Matches
Presenter: Cyndi Deal

DNA with DANA LEEDS - blog for Color Clustering Matches - https://dnawithdana.com

¡  1) DNA Color Clustering: The Leeds Method for Easily Visualizing Matches

¡  2) DNA Color Clustering: Identifying “In Common” Surnames

¡  3) DNA Color Clustering: Does it Work with 4th Cousins?

¡  4) DNA Color Clustering: Dealing with 3 Types of Overlap

¡  5) Check Your Work! (The “How”)

¡  6) 7 Organization Tips for Your DNA Color Cluster Chart

Dana Leeds’ Presentation at I4GG2018

¡  Creating and Analyzing Genetic Networks with a Spreadsheet - Dana Leeds ($)

http://i4gg.org/conference-videos/

Color and Tag with Ancestry’s new features –

·        Video from Blaine Bettinger - Sub-Clustering Your Shared Matches at AncestryDNA

https://www.youtube.com/watch?v=6ApidzEyA_k

Other Blogs and Work Groups

¡  Roberta Estes blog post,  The Leeds Method

https://dna-explained.com/2018/09/26/the-leeds-method/

¡  Roberta Estes blog post, Painting Leeds matches to DNAPAINTER (using matches with chromosome data)

https://dna-explained.com/2018/10/02/dnapainter-painting-leeds-method-matches

¡  Diahan Southard blog post, Organizing Matches with Leeds

https://www.yourdnaguide.com/leeds-method/

¡  Facebook Workgroup – Genetic Genealogy Tips and Techniques  >> search “Leeds” in box on left sidebar

https://www.facebook.com/groups/geneticgenealogytipsandtechniques

Preprinted worksheet for Leeds Method

¡  https://memoriesintime.co.nz/collections/family-history/products/dna-match-leeds-method-worksheet

DNA Match Manager

¡  https://heirloomsoftware.com/dna-match-manager/

Conditional Formatting “recipe”  -  Included in handout

Gather Matches for excel the Fast way

DNA Match Manager

•        https://heirloomsoftware.com/dna-match-manager/

•        Free, Fast

•        Works with all main test sites and GedMatch

•        Creates csv files that you can save in Excel

DNA Match Manager

Color match options – Easy vs. Power tools

Format Cell color

Right click on cell> choose fill tool (Paint bucket)> Choose color. This is simple and works, but you can’t sort it.

“Recipe” for Conditional Formatting in Excel

Home tab on Excel task Ribbon> Conditional Formatting dropdown> New Rule> 2^nd option: format only cells that contain> fill “cell value” and define a color.
Power Tool option: Allows you to sort columns into associated family lines when they become apparent.

My Latest leeds effort

Using Power Tools:

¡  Match Manager data

¡  Conditional Formatting

¡  Color Code the starting match

¡  Rearranging the Columns as family lines become apparent

This shows how my process has evolved since first Leeds chart example that I shared with you. You can see that I have been moving the columns around as their connections become obvious.

Final Step, transfer this valuable info to your AncestryDNA match Page. Color code and Tag your matches with Ancestry’s new features. See Blaine Bettinger video (link on Resource page).

DNA Handout #1 from June 2019 WCGS Meeting - Evaluating your atDNA Matches

Presented and prepared by Sallie Szymczyk

Evaluating Your atDNA Matches

WCGS

June 25,2019

Use a unique username

Open a new e-mail account

Provide at least a skeleton tree

Start with your closest matches to determine which side of your family they are on

Look at available trees for hints

Look for common surnames and locations

Check to see if your match has posted to a message board

Use the “Shared Matches” tool on Ancestry, the “In Common With” tool on FTDNA or “shared DNA Matches” on My Heritage

Determine Paternal or Maternal match

Make a spread sheet to keep track of your findings

Contact your matches with an “informed” e-mail – Do your home workReturn to the WakeCoGen Website

Upcoming Events - Busy WCGS schedule for Summer!

WCGS Members and Wake researchers!  It’s going to be a great summer of genealogy starting with these upcoming events:

June 29, 2019:  Transcription Workshop at Olivia Raney Library. 10am – noon. More info here.

July 2, 2019:  Family Tree Maker is coming to Raleigh!  WCGS will partner with FTM for an evening of great information on using FTM, upcoming upgrade, and much more. 7pm – 9pm. More info here.

WCGS Summer of DNA – don’t miss out on 3 great programs we’ll offer over the summer geared toward beginner and intermediate skill levels.

June 25, 2019:  Make Your Autosomal DNA Matches Work for You in two parts: Get Familiar with Your Shared Matches and Sort Shared Matches along family lines with Leeds Color Matching process. Olivia Raney Local History Library in Raleigh, NC refreshments at 6:30, program starts at 7pm.

July 23, 2019: Use Science to Refine the Placement of Autosomal Matches Into Your Tree: An introduction to the “What are the Odds” tool at DNAPainter.com.  Olivia Raney Local History Library in Raleigh, NC refreshments at 6:30, program starts at 7pm.

August 27, 2019: Autosomal DNA Q&A Panel group. Submit your questions with contact info, question and sketch of the relationship in question by July 25. The sketch (nothing fancy is needed!) will help us with context. Submit to Newsletter@wakecogen.org.  Cameron Village Regional Library in Raleigh, NC starting at 7pm.

Just starting out with DNA?  You’ll find lots of great resources to help you master the basics in these articles from a previous DNA presentation. We especially recommend the Blaine Bettinger video series at Legacy Webinars. DNA links and reading list on WCGS blog.

Haven't tested yet but want to play along?  There is still plenty of time! This progress tracker will guide you thru the steps and get you started so you can be ready for our Summer of DNA!  Progress Tracker for DNA Study. Work the progress tracker, then the reading list. Both of these study aids live on the WCGS blog so you can reference them any time you like.

Questions? Email CarlaStancil@gmail.com

See you there!

Carla Stancil

President, Wake County Genealogical Society