Abstract: Genetic drift is a fluctuation phenomenon of gene frequency due to the random error caused by sampling in small population. Whether in nature or in the domestic conditions, the genetic drift phenomena are common. Therefore, it has received much attention in the teaching of genetics. The concept of genetic drift is important in explaining some evolutionary phenomena, as well as breeding work, the establishment of gene pool and so on. In order to better display the genetic drift rule, Excel 2003 is used to simulate the process of drift, and it is expected to understand the drift direction and the degree more vivid and profound.

Key words: genetic drift, Excel, simulation