2022年数据的排序和筛选教学设计 .pdf

对数据进行排序和筛选教学设计一、教材分析对数据进行排序和筛选 是初中信息技术八年级下册第5 单元数据分析和管理 第 1 课时内容。本节课是在前几节课学习了数据输入、工作表的编辑以及对数据运算等基本知识的基础上，进一步学习对数据进行排序和筛选。本课共由三个部分组成，分别是简单排序、复杂排序、自动筛选，是对前面所学知识的一个综合运用，也是以后学习用图表表示数据的重要基础。通过本节课的学习能让学生学会排序和筛选的操作方法，在生活中能用这些方法解决实际问题，达到学以致用。二、学情分析学生通过前面各单元内容的学习，对数据的输入、编辑、运算有了一定的操作能力，排序和筛选对学生来说在实际生活中应用十分广泛，如比赛成绩的排名、优秀选手的筛选等，如果能够掌握EXCEL 排序与筛选的操作方法，将大大地提高学生解决问题的能力。但基于他们年龄的特征，他们对理论性强的知识点不易理解，认知较直观，而对具体操作易于接受。另外因诸多因素的不同，造成他们对信息技术的认知能力、实际操作能力、知识水平各不相同，形成了不同的层次。因此我在教学中利用任务驱动、自主探究，从而让学生掌握排序与筛选的操作。三、教学目标1、知识与技能学会排序和筛选的操作方法、过程与方法通过对数据排序和筛选，让学生理解排序、筛选的意义；理解排序和筛选在数据管理中的作用。、情感态度和价值观培养学生利用数据的排序和筛选解决生活实际问题的能力四、教学重点、难点重点：关键字的排序、筛选符合条件的数据。难点：关键字的概念及使用多关键字进行复杂排序五、教法、学法教法本节课在“任务驱动”教学法下，结合自主学习、小组合作学习来让学生完成一个个具体学习任务而开展的课堂教学，以尝试先学后教、总结归纳、网络教室直观演示等形式贯穿整个教学过程。学法为引导学生自主探究学习，培养学生良好的学习方法与学习习惯，通过上述教法，坚持以学生自主学习为主，通过学生自己发现问题、分组研讨问题、亲自尝试、合作解决，最后由学生自己归纳总结，来完成本课的学习任务。让学生以练为主，以亲自尝试实践、积极动脑动手来学习新知。六、教学过程教学环节教师活动学生活动设计意图创设情境激趣导入通过多媒体电子教室演示系统向学生展示20XX 年广洲亚运会幕式与比赛精彩片段后出示2010 广洲亚运会奖牌表。提问：请同学们快速的在工作表中找出获得金牌最多的前十个国家？选出奖牌总数在100 枚以上的所有国家？说说你们是用什么方法做的？有没有更快捷的方法呢？今天这节课同学们可以通过手中的课本找到解决这种问题的快捷方法，那就数据的排序和筛选。（板书：对数据进行排序和筛选）学生观看学生观察、回答（一个一个的找）通过创设激趣的情境，激发学生学习兴趣。文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8自学质疑合作交流任务一：自学质疑1、学生阅读课本第75 页至77 页的内容，并讨论回答：排序有几种方 式，排序 有几种方式？分清升序和降序的按钮；知道什么是关键字？了解排序和自动筛选的方法教师做简单的总结2、请同学们自主操作书中75页与 78 页的“做一做”，初步掌握排序和筛选的方法教师巡回指导。师生共同解决操作过程遇到的问题。教师对学生中存在的问题进行相应的补充。学 生 自 主 学习教材中的内容，并回答问题。学生自主尝试操作，说出操作过程中遇到的问题。学生再次操作，然后请个别学生演示如何进行排序与筛选，并讲解其操作方法和步骤。尝试先学后教的教学方法，使学生养成良好的学习习惯，学会自主学习、独立思考。培 养 学 生 自主操作能力，并能从操作中提出问题。通过教师补充的问题加以引申，突出本节课的难点。任务二：合作交流1、亚运会的奖牌怎样进行排序？2、筛选出奖牌总数在100 枚到 450枚之间的所有国家？操作提示：亚运会排名方法和规则先按金牌数量。（如果金牌数相同，就看银牌。如果金、银牌都相同，则看铜牌.注意：排名里，多少枚银牌都比不上一枚金牌。同样，多少枚铜牌都比不上一枚银牌）教师巡回指导教师对存在的问题进行相应的补充。小组讨论，完成任务。请个别学生演示、并讲解其操作方法和步骤。通过组织学生小组讨论、掌握多关键字排序方法突破本节课的教学难点学以致用以用促学学生基本上已经知道了如何对亚运会的奖牌数进行分析，为了让学生学有所用，学生分四小组，每一小组从中选择一个工作有进行分析（世界网球排名榜、2010-2011 赛 季 斯 诺 克 年 终 排小组讨论，然后选代表 汇报 分析 结果通过小组合作、汇报交流、学生评价，让学生感受成功的喜悦，文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8名、）教师从学生的语言、数据处理的准确性、观点的科学性等方面，对各小组分析结果进行点评，对学生的闪光点进行肯定，对存在的问题进行补充。逐渐看到自己的优势和不足，并在今后的实践中得 以 保 持 和 改正。回顾反思升华提高你在本节课中学会了什么教师在学生总结的基础上小结本节课。个别 学生 谈谈 本节课的收获。让学生用自己的语言来总结出今天探索的知识点，养成善于总结的好习惯，有利于帮助学生理清知识脉络，同时培养表达能力。文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8文档编码:CM2G10Z8J2K8 HV6T4H9V4D5 ZM7T3M5L2A8