Excel软件辅助概率论与数理统计教学  

Using Excel Software to Help Probability Theory and Mathematical Statistics Teaching

作　　者：孙晓玲[1] 王宁[1] 

机构地区：[1]合肥师范学院数学与统计学院,安徽合肥230601

出　　处：《合肥师范学院学报》2015年第3期73-76,共4页Journal of Hefei Normal University

基　　金：安徽省高校省级自然科学研究项目(KJ2013B219);合肥师范学院教学团队项目(2013jxtd07)

摘　　要：仅依靠黑板或PPT演示的传统概率论与数理统计教学通常缺乏分析结果的可视化直观表现,课程中应用性较强的内容不能让学生实际动手设计和分析,制约和影响了教学效果。利用包含了大量数学函数的Excel 2010软件辅助教学,将数据表嵌入到PPT文件进行教学演示或嵌入到网页中让学生自主实验,能够很好得提高课堂的教学效果和教学效率。通过巧用Excel 2010软件处理二项分布问题的教学实例分析和实验可展现软件对概率论与数理统计教学的较好辅助作用。The traditional probability theory and mathematical statistics which relies only on the blackboard or PPT demo teaching often lack the visual analysis of the results of the visual performance, and fails to encourage students to do hands-on design and analysis, thus restricts and affects the teaching results. The use of the Excel software teaching contains a large number of mathematical functions, Excel data sheet is embedded into the PPT file for the teaching demonstration or embedded into Webpage enabling students to do independent experiments, which improves the classroom teaching effect and teaching efficiency. Teaching examples of analysis and experimental binomial distribution problems skillfully with Excel software can show a better auxiliary function of Excel software to the teaching of probability theory and mathematical statistics.

关 键 词：EXCEL软件 概率论与数理统计 辅助教学 二项分布 

分 类 号：G642[文化科学—高等教育学]