教师教学常用电子表格程序使用手册尹克林著(西南大学园艺园林学院)西南大学教务处2006年12月目录目录................................................................................................................................................ii1.教学日历操作步骤目录...........................................................................................................iv2.成绩记载操作步骤目录...........................................................................................................iv3.命题单操作步骤目录................................................................................................................v4.插图目录....................................................................................................................................v5.前言.......................................................................................................................................16.基本操作....................................................................................................................................3系统设置..................................................................................................................................3系统“安全性”设置.......................................................................................................3系统“加载宏”设置.......................................................................................................3认识Excel电子表界面............................................................................................................4约定俗成..................................................................................................................................7编程核心技术..........................................................................................................................87.教学日历....................................................................................................................................98.成绩记载..................................................................................................................................12简明操作步骤.................................................................................................................12操作步骤详解.................................................................................................................139.成绩记载简版..........................................................................................................................2910.试卷分析常用指标与计算公式..............................................................................................29试卷评估参数........................................................................................................................29试题代表性.....................................................................................................................29试题深度........................................................................................................................30试题结构........................................................................................................................3010.2考试质量评估.................................................................................................................3010.3试卷评估指标...........