Abstract The grade evaluation system for the analytical chemistry experiment course is built with Excel formula, IF function and cross-worksheets sum function. The influence index and index weight of the grade evaluation system are studied, and this system is used to rate the students' grades with positive results.
ZHANG Xin, WANG Wen-Bao, LU Rui-Li, CUI Yun-Mei, WANG Li. Construction and Application of Excel-Based Grade Evaluation System for Analytical Chemistry Experiment Course[J]. , 2018, 39(12): 14-18.