Changes

Page history
Update Using the grading file authored by Robert Alexander Crowell's avatar Robert Alexander Crowell
Show whitespace changes
Inline Side-by-side
Using-the-grading-file.md
View page @ f661d060
# Inputing points
There are two ways how to enter the points a student achieved during the correction electronically.
### Using a spreadsheet during the correction
You can distribute the `registration.csv` (after deleting the non-anonymous data, i.e. Name, Firstname and Legi) to the first and second graders. During grading a grader can have a laptop with them and directly enter the points while grading.
### Using AMC
As an alternative you may wish to retain a machine readable list on which a grader marks the points given to a student by filling boxed. The AMC code (example) for this is as follows.
<details>
<summary>AMC Example code for machine readable points during grading</summary>
```
%\hrule
\centerline{\rule{\linewidth}{0.5pt}}
\vspace{4pt}
\noindent \emph{\large \textbf{Folgendes bitte nicht ausfüllen!}}
\vspace{4pt}
\begin{question}{1}{\textbf{Aufgabe 1} [\emph{4 Punkte}]}
\begin{multicols}{8}
\begin{choices}[o]
\wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3}
\correctchoice[4]{4}\scoring{4}
\end{choices}
\end{multicols}
\end{question}
\begin{question}{2}{\textbf{Aufgabe 2} [\emph{4 Punkte}]}
\begin{multicols}{8}
\begin{choices}[o]
\wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3}
\correctchoice[4]{4}\scoring{4}
\end{choices}
\end{multicols}
\end{question}
\begin{question}{3}{\textbf{Aufgabe 3} [\emph{4 Punkte}]}
\begin{multicols}{8}
\begin{choices}[o]
\wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3}
\correctchoice[4]{4}\scoring{4}
\end{choices}
\end{multicols}
\end{question}
\begin{question}{4}{\textbf{Aufgabe 4} [\emph{4 Punkte}]}
\begin{multicols}{8}
\begin{choices}[o]
\wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3}
\correctchoice[4]{4}\scoring{4}
\end{choices}
\end{multicols}
\end{question}
\begin{question}{5}{\textbf{Aufgabe 5} [\emph{6 Punkte}]}
\begin{multicols}{8}
\begin{choices}[o]
\wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3}
\wrongchoice[4]{4}\scoring{4}
\wrongchoice[5]{5}\scoring{5}
\correctchoice[6]{6}\scoring{6}
\end{choices}
\end{multicols}
\end{question}
\begin{question}{6}{\textbf{Aufgabe 6} [\emph{6 Punkte}]}
\begin{multicols}{8}
\begin{choices}[o]
\wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3}
\wrongchoice[4]{4}\scoring{4}
\wrongchoice[5]{5}\scoring{5}
\correctchoice[6]{6}\scoring{6}
\end{choices}
\end{multicols}
\end{question}
\begin{question}{11}{\textbf{Aufgabe 11} [\emph{4 Punkte}]}
\begin{multicols}{8}
\begin{choices}[o]
\wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3}
\correctchoice[4]{4}\scoring{4}
\end{choices}
\end{multicols}
\end{question}
\begin{question}{12}{\textbf{Aufgabe 12} [\emph{6 Punkte}]}
\begin{multicols}{8}
\begin{choices}[o]
\wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3}
\wrongchoice[4]{4}\scoring{4}
\wrongchoice[5]{5}\scoring{5}
\correctchoice[6]{6}\scoring{6}
\end{choices}
\end{multicols}
\end{question}
```
</details>
You can either include this at the end of the MC answer sheet, or compile as a **separate** AMC project and print separately (not via the print tool).
# Grading file
The `GradingWorkbookCreator.xlsx` is an excel based tool that is able to import student data from, end export it to eDoz.
Once you open the file, you are presented with the instructions on how to use it.
......@@ -6,6 +141,10 @@ Once you open the file, you are presented with the instructions on how to use it
**Please note: The file runs stably using Microsoft Excel. OpenSource alternatives may generate an error.**
Once you have generated the file, entered points, and input grade thresholds, you will have a graphical overview over how well students did on the exam.
Once you have generated the file, you can enter the points a student gathered. Either copy from the separate files grades created during grading, or the readout from AMC.
You can then input the grade thresholds and get a graphical overview of how well students did on the exam (retake candidates are marked in red).
![Screenshot_from_2022-12-05_18-20-00](uploads/65efe308afe9700ba5254637abb3c308/Screenshot_from_2022-12-05_18-20-00.png)