TPT
Total:
$0.00
"Husky-volution" - Spreadsheet Microevolution Simulation
"Husky-volution" - Spreadsheet Microevolution Simulation
"Husky-volution" - Spreadsheet Microevolution Simulation
"Husky-volution" - Spreadsheet Microevolution Simulation
"Husky-volution" - Spreadsheet Microevolution Simulation
"Husky-volution" - Spreadsheet Microevolution Simulation
"Husky-volution" - Spreadsheet Microevolution Simulation
"Husky-volution" - Spreadsheet Microevolution Simulation
Share

Description

This Google Sheet simulation allows users to track the evolution of a population of digital Huskies that are subject to different environmental selective pressures and initial conditions over ten generations.

The major driving force of the evolution of the Husky population is natural selection, but sexual selection and genetic drift (i.e., "random" events) also play a part in determining the composition of the final gene pool.

With each run of the simulation, users can choose from various selective pressure scenarios, adjust the population size, and vary the initial gene pool to observe the effect that these variables have on the outcome.

Ultimately, the data-rich spreadsheet helps learners to visualize and analyze the generation-to-generation changes in allele frequencies that characterize the evolutionary mechanisms falling under the category of "microevolution."

Plus, it's just dang fun to play with!

Note: This Google Sheet requires users to run additional functions (Macros) embedded within the spreadsheet. Users must "Allow access" to these functions to run the simulation.

Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT's content guidelines.

"Husky-volution" - Spreadsheet Microevolution Simulation

Jeremy Mohn
23 Followers
$10.00

Highlights

Digital downloads
Grades icon
Grades
9th - 12th
Standards icon
Standards

Save even more with bundles

This is a bundle of the "Husky Love" Genetics Simulation Project and the "Husky-volution" Spreadsheet Microevolution Simulation.
Price $30.00Original Price $35.00Save $5.00
2

Description

This Google Sheet simulation allows users to track the evolution of a population of digital Huskies that are subject to different environmental selective pressures and initial conditions over ten generations.

The major driving force of the evolution of the Husky population is natural selection, but sexual selection and genetic drift (i.e., "random" events) also play a part in determining the composition of the final gene pool.

With each run of the simulation, users can choose from various selective pressure scenarios, adjust the population size, and vary the initial gene pool to observe the effect that these variables have on the outcome.

Ultimately, the data-rich spreadsheet helps learners to visualize and analyze the generation-to-generation changes in allele frequencies that characterize the evolutionary mechanisms falling under the category of "microevolution."

Plus, it's just dang fun to play with!

Note: This Google Sheet requires users to run additional functions (Macros) embedded within the spreadsheet. Users must "Allow access" to these functions to run the simulation.

Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT's content guidelines.

Reviews

This product has not yet been rated.
Rated 0 out of 5

Questions & Answers

Loading

Standards

to see state-specific standards (only available in the US).
NGSSHS-LS4-2
Construct an explanation based on evidence that the process of evolution primarily results from four factors: (1) the potential for a species to increase in number, (2) the heritable genetic variation of individuals in a species due to mutation and sexual reproduction, (3) competition for limited resources, and (4) the proliferation of those organisms that are better able to survive and reproduce in the environment. Emphasis is on using evidence to explain the influence each of the four factors has on number of organisms, behaviors, morphology, or physiology in terms of ability to compete for limited resources and subsequent survival of individuals and adaptation of species. Examples of evidence could include mathematical models such as simple distribution graphs and proportional reasoning. Assessment does not include other mechanisms of evolution, such as genetic drift, gene flow through migration, and co-evolution.
NGSSHS-LS4-3
Apply concepts of statistics and probability to support explanations that organisms with an advantageous heritable trait tend to increase in proportion to organisms lacking this trait. Emphasis is on analyzing shifts in numerical distribution of traits and using these shifts as evidence to support explanations. Assessment is limited to basic statistical and graphical analysis. Assessment does not include allele frequency calculations.
Loading