Spreadsheet Model for Student Evaluation and Grading

This technical note describes the application of a spreadsheet-based model for student evaluation and grading. The note shows how a spreadsheet-based model can be used in automating the process of evaluating and grading in situations where advanced technologies like optical recognition are not available. The first part of the note describes how a spreadsheet can be used to evaluate course components, which involve multiplechoice type of questions (MCQs). The second part of the note describes how a spreadsheet can help instructors in determining the final grades for a course and its components, given the institutional grading guidelines. The model was successfully used for several courses at a premier management institute in central India. It was observed that the model helped in saving significant amount of time in student evaluation and grading and thus helped in speeding up the process of feedback from the instructor to the students.