本文对《数字化记录员》一课进行了教学设计,设计本着以教师为主导、学生为主体的原则,首先通过让学生观看能自动更改最好成绩的表格引出函数的概念,接着引导学生探究Excel的自动排序功能,最后在教师的引导下,学生通过自主探究和协作学习的方式完成3个任务,从而迁移知识,巩固技能,并且在此过程中体会成功的快乐。 In this paper, we design a course of “Digital Recorder”. The design is based on the principle of teacher-led and student-centered. First, we introduce the concept of function by letting students watch the table that can automatically change the best score, and then guide students to explore Excel automatic sorting function, and finally under the guidance of teachers, students through the independent inquiry and collaborative learning to complete the three tasks in order to migrate knowledge, consolidate skills, and in the process of success experience happiness.