基于VBA对性状分离比模拟实验的优化和拓展

Optimization and expansion of simulated experiments on character segregation ratio based on VBA

“性状分离比的模拟实验”活动的开展有助于学生形成科学思维和科学探究等核心素养。利用EXCEL中VBA语言对实验进行数字化模拟,优化数据分析,能增大课堂容量,提高课堂效率。VBA具有可操作性强的特点,可以拓展对自由组合性状分离比、配子致死等内容的模拟。

The implementation of the“simulated experiment on character segregation ratio”activity helps students develop core literacy,such as scientific thinking and scientific inquiry.By using VBA language in EXCEL to conduct digital simulation of the experiment,data analysis can be optimized,the classroom capacity can be increased,and the classroom efficiency can be improved.VBA has the characteristic of strong operability,which can expand the simulation of free combination character segregation ratio,gamete lethality and other contents.