I could never find a decent simulation fo Mendel's experiments so I made one in excel.
There are 1000 pea plants. Traits that will be examined are pod colour, stem height and seed shape. Press F9 and you will randomly generate new data for the 1000 plants. Students conduct multiple trials and analyse results.
There are multiple tabs in the spreadsheet. These include:
- Pod Colour F1 generation
- Pod Colour F2 generation
- Stem Height F1 generation
- Stem Height F2 generation
- Seed Shape F1 generation
- Seed Shape F2 generation
Also included is a separate word document for students to record their results