光电效应法测普朗克常数仿真实验数据处理中的替代方法及教学实践

摘要

在采用光电效应法测普朗克常数仿真实验的操作环节的基础上,在其数据处理环节提出使用Excel数据处理功能进行处理的替代方法。在绘制反向伏安特性曲线方面Excel法能达到仿真实验输出结果的同样水准,在增添测量数据、精确读取拐点数值等方面,Excel更灵活、更准确；在计算普朗克常数、电子逸出功、红限时,使用Excel工具能让学生对物理概念了解得更充分,更透彻。%Based on adopting the experiment operation aspect of the computer simulation experiments of meas-uring Planck’ s constant by photoemission,this article discusses some substitute method of data processing. Through choosing some items the result of Excellmethod can correspond to the output of the computer simula-tion. By processing the data,the students can understand the related physical concepts more clearly. When the students read some wrong clamp voltage and obtain the wrong Planck’ s constant the substitute method is espe-cially helpful.