摘要
指出按照传统的方法进行课堂教学质量评估，存在不同的评估群体所得的测评分不具可比性的问题；而按照标准分进行评估，由于要对各种测评分进行标准化处理，使计算量大大增加。提出利用Excel 97或Excel 2000中丰富的统计和数学功能，根据用标准分进行教学评估的要求，制作计算学生测评标准分和计算教学质量评估总评分的模板，以减轻数据处理的工作量。
In view of the uncomparability in the traditional teaching appraisal because of the scores from different group appraisers or large amount of calculating work has to be done by standardizing the original scores, the paper introduces the utilization of the abundant statistic and calculating functions in Excel 97 & Excel 2000 and the evaluation template making based on standard scorces for lessening calculating work.
