What is the DBF Excel Grading tool?
The Teaching Center of the Department of Finance (DF) developed a tool for the automated creation and correction of problem sets and exams solved in Microsoft Excel. It is sucessfully used in various courses of the Department of Banking and Finance.
Aim of the DF Excel Grading Tool
The aim of the DBF Excel Grading tool is to facilitate the personalization of problem sets and exams and their fully automated correction. While the personalization makes cheating more difficult, the fully automated correction heavily decreases the workload and mitigates the risk of human errors.
Features
The main features of the tool are the generation of personalized exams and their fully automated correction. All exercises whose solution can be specified using an Excel formula can be graded automatically. Fully open questions (e.g. open text questions) are presented in the output of the tool and can be graded by hand in a seperate step.
| Feature | Comment |
|---|---|
| Digitization | Exams must be created in Microsoft Excel |
| Statistics | Basic statistics for each exercise |
| Fully Automated Grading | Fully automated correction based on sample solution |
Tags: tool