摘要
Excel函数是大学计算机基础课程的重点难点,学生理解和掌握该内容较为困难。文章设计了一个教学案例,该案例使用Excel函数计算、统计学生考试结果。通过该案例的计算学习,使学生理解和掌握Excel常用函数的功能和用法,用生活中的实际案例来分析学习,找到理论与实际工作的切入点,增加学生学习的积极性、主动性,革除传统教学存在的弊端,达到更好的教学效果。
Excel function is the key and difficult point of college computer basic course. In this paper, a teaching case is designed. The case is calculated by using Excel function to calculate the test results of students. Through the calculation study of this case, students can understand and master the functions and usage of the common functions of Excel, analyze and study with the actual cases in life, find the entry point of theory and actual work, increase the enthusiasm and initiative of students to study, and eliminate the disadvantages of traditional teaching, so as to achieve better teaching effect.
引文
[1]王青梅.国内外案例教学法研究综述[J].宁波大学学报(教育科学版),2009(3):7-11.
[2]李战国,彭统乾.案例式教学中案例选择原则—以Excel函数为例[J].电脑知识与技术,2019(9):164-166.
[3]王峥嵘.浅谈案例式教学在计算机学科教学中的运用[J].科教文汇,2016(4):71-72.