Automating a part of the assessment of a University using Excel

Abstract

A process of establishing an assessment policy for a university and automating a part of the assessment is discussed. Excel was the tool used to carry out the automation. The form the assessment policy should take was discussed for three years, and was partially implemented in two months. We collected grades of all students of all classes from our university, using our academic affairs system. After the grade data were downloaded from the academic affairs system, we produced radar charts for each student, for each department, and for the university as a whole. Then, by clicking some buttons in the Excel book, the data were partitioned into the grade lists of all departments.