基于Excel应用的多指标评分系统设计与实现

Multiple Index Scoring System Based on Excel Application Design and Implementation

比赛评分、教材评比等多用单一指标衡量,评价结果并不尽合理,若从多个指标评价,将更准确。对于多指标评分,可以使用Excel的数据有效性、函数及保护功能实现,并设定各分数段数量及比率使评分工作更客观、公正。

Scoring, textbook evaluation usually use single index, the evaluation results are not reasonable, If use more than one evaluation index would be more accurate. For multiple index evaluation, you can use the data validation, function, and protection of Excel to realize. In addition, set the fractional number and ratio to make the scoring work more objective and fair.