Skip to main content

Power to Business Professors: Automatic grading of problem-solving tasks in a spreadsheet


Professors that are experts in Excel can create tasks such as problem solving and tests. Students are able to receive feedback while working on the assignment that is already built in the system. VBA is used. This tool is to help with learning for students rather than simply memorization.

Key Points

  • A spreadsheet template enables a professor to develop individualized problem-solving tasks.
  • Tasks are marked automatically and provide students with tailored feedback.
  • Feedback focus both on the problem-solving outcome and the problem-solving process.
  • When homework, assignments, and exams are marked automatically, the assessment load on professors is substantially reduced.

Link to full article