首页 | 本学科首页   官方微博 | 高级检索  
     

关于VLOOKUP()函数教学方法的探讨
引用本文:周艳仔.关于VLOOKUP()函数教学方法的探讨[J].江汉石油职工大学学报,2011,24(1):75-77.
作者姓名:周艳仔
作者单位:中国石化集团江汉石油管理局职工培训中心,湖北,潜江,433121
摘    要:针对性地教学能收到很好的学习效果.基于大部分不了解VLOOKUP()函数学生的好奇心心理,结合多年教学经验,提出了引入案例分析,辅助VLOOKUP()函数应用的教学方法:(1)角色换位,确定教学方向;(2)案例分析,激发学生兴趣;(3)抛砖引玉,推出VLOOKUP()函数教学;(4)竞赛练习,巩固教学知识.

关 键 词:计算机教学  案例分析法  VLOOKUP()函数  学生成绩表

Discussion of Teaching method of VLOOKUP() Function
ZHOU Yan-zi.Discussion of Teaching method of VLOOKUP() Function[J].Journal of Jianghan Petroleum University of Staff and Workers,2011,24(1):75-77.
Authors:ZHOU Yan-zi
Affiliation:ZHOU Yan-zi(Training Center for the Workers and Staff of Jianghan Petroleum Administration,SINOPEC,Qianjiang Hubei 433121,China)
Abstract:Teaching with a clear aim will achieve a good learning result.On the basis of most of students' curiosity for unknown VLOOKUP() function and years of teaching experience,the author presents a method of introducing case analysis to assist VLOOKUP() function teaching,that is,orientating teaching by role exchange,arousing students' interests through case analysis,introducing VLOOKUP() function with a simple example serving as catalyst and mastering teaching knowledge through contest practice.
Keywords:Computer Teaching  Case Analysis Method  VLOOKUP() Function  Student Record of Achievement  
本文献已被 CNKI 维普 万方数据 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号