Family History by the Numbers: Generations & Ancestor Counts, Pedigree Numbering, Cousin Relationships, Date Estimates and Research Trackers
Bring order and numbers into your family tree: count ancestors per generation and see pedigree collapse, number ancestors with a standard pedigree scheme, work out cousin degrees and «removed» steps, estimate missing birth years from records, check timelines for impossible dates and track your research, all with a fictional family and every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you bring numbers into a family tree with a spreadsheet, using one fictional family from start to finish. You count ancestors per generation with POWER and see how pedigree collapse reduces the unique people when lines cross. You number ancestors with the father 2n, mother 2n + 1 scheme, find any number's generation with LOG and look up parents with XLOOKUP. You work out cousin degrees and removed steps and fill a relationship chart, turn stated ages into birth-year ranges and their overlap, flag impossible dates with IFS, measure moves on a map grid and finish with a research tracker and chart.
Lessons
- Generations & Ancestor Counts: Doubling, Running Totals and Birth-Year Estimates Pro
- Pedigree Collapse: Theoretical vs Unique Ancestors When Family Lines Cross Pro
- Pedigree Numbering: Father 2n, Mother 2n + 1, Generations with LOG and Look-ups Pro
- Cousin Relationships: Degree, «Removed» Steps and a Relationship Chart Pro
- Estimating a Birth Year: Ranges from Stated Ages and Their Overlap Pro
- Timeline Checks: Parent Ages, Events After Death and Impossible-Date Flags Pro
- Places & Moves: Places per Generation, Distances on a Map Grid and a Migration Timeline Pro
- Capstone: Research Tracker – Completeness per Person and Generation, Open Questions and a Chart Pro