Changes

Page history
Update Using the grading file authored by Robert Alexander Crowell's avatar Robert Alexander Crowell
Hide whitespace changes
Inline Side-by-side
Using-the-grading-file.md
View page @ 63c224ff
# Inputing points # Inputing points
There are two ways how to enter the points a student achieved during the correction electronically. There are two ways how to enter the points a student achieved during the correction electronically.
### Using a spreadsheet during the correction ### 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. 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 ### 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 boxes. The AMC code (example) for this is as follows. 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 boxes. The AMC code (example) for this is as follows.
<details> <details>
<summary>AMC Example code for machine readable points during grading</summary> <summary>AMC Example code for machine readable points during grading</summary>
``` ```
%\hrule %\hrule
\centerline{\rule{\linewidth}{0.5pt}} \centerline{\rule{\linewidth}{0.5pt}}
\vspace{4pt} \vspace{4pt}
\noindent \emph{\large \textbf{Folgendes bitte nicht ausfüllen!}} \noindent \emph{\large \textbf{Folgendes bitte nicht ausfüllen!}}
\vspace{4pt} \vspace{4pt}
\begin{question}{1}{\textbf{Aufgabe 1} [\emph{4 Punkte}]} \begin{question}{1}{\textbf{Aufgabe 1} [\emph{4 Punkte}]}
\begin{multicols}{8} \begin{multicols}{8}
\begin{choices}[o] \begin{choices}[o]
\wrongchoice[0]{0}\scoring{0} \wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1} \wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2} \wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3} \wrongchoice[3]{3}\scoring{3}
\correctchoice[4]{4}\scoring{4} \correctchoice[4]{4}\scoring{4}
\end{choices} \end{choices}
\end{multicols} \end{multicols}
\end{question} \end{question}
\begin{question}{2}{\textbf{Aufgabe 2} [\emph{4 Punkte}]} \begin{question}{2}{\textbf{Aufgabe 2} [\emph{4 Punkte}]}
\begin{multicols}{8} \begin{multicols}{8}
\begin{choices}[o] \begin{choices}[o]
\wrongchoice[0]{0}\scoring{0} \wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1} \wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2} \wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3} \wrongchoice[3]{3}\scoring{3}
\correctchoice[4]{4}\scoring{4} \correctchoice[4]{4}\scoring{4}
\end{choices} \end{choices}
\end{multicols} \end{multicols}
\end{question} \end{question}
\begin{question}{3}{\textbf{Aufgabe 3} [\emph{4 Punkte}]} \begin{question}{3}{\textbf{Aufgabe 3} [\emph{4 Punkte}]}
\begin{multicols}{8} \begin{multicols}{8}
\begin{choices}[o] \begin{choices}[o]
\wrongchoice[0]{0}\scoring{0} \wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1} \wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2} \wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3} \wrongchoice[3]{3}\scoring{3}
\correctchoice[4]{4}\scoring{4} \correctchoice[4]{4}\scoring{4}
\end{choices} \end{choices}
\end{multicols} \end{multicols}
\end{question} \end{question}
\begin{question}{4}{\textbf{Aufgabe 4} [\emph{4 Punkte}]} \begin{question}{4}{\textbf{Aufgabe 4} [\emph{4 Punkte}]}
\begin{multicols}{8} \begin{multicols}{8}
\begin{choices}[o] \begin{choices}[o]
\wrongchoice[0]{0}\scoring{0} \wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1} \wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2} \wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3} \wrongchoice[3]{3}\scoring{3}
\correctchoice[4]{4}\scoring{4} \correctchoice[4]{4}\scoring{4}
\end{choices} \end{choices}
\end{multicols} \end{multicols}
\end{question} \end{question}
\begin{question}{5}{\textbf{Aufgabe 5} [\emph{6 Punkte}]} \begin{question}{5}{\textbf{Aufgabe 5} [\emph{6 Punkte}]}
\begin{multicols}{8} \begin{multicols}{8}
\begin{choices}[o] \begin{choices}[o]
\wrongchoice[0]{0}\scoring{0} \wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1} \wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2} \wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3} \wrongchoice[3]{3}\scoring{3}
\wrongchoice[4]{4}\scoring{4} \wrongchoice[4]{4}\scoring{4}
\wrongchoice[5]{5}\scoring{5} \wrongchoice[5]{5}\scoring{5}
\correctchoice[6]{6}\scoring{6} \correctchoice[6]{6}\scoring{6}
\end{choices} \end{choices}
\end{multicols} \end{multicols}
\end{question} \end{question}
\begin{question}{6}{\textbf{Aufgabe 6} [\emph{6 Punkte}]} \begin{question}{6}{\textbf{Aufgabe 6} [\emph{6 Punkte}]}
\begin{multicols}{8} \begin{multicols}{8}
\begin{choices}[o] \begin{choices}[o]
\wrongchoice[0]{0}\scoring{0} \wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1} \wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2} \wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3} \wrongchoice[3]{3}\scoring{3}
\wrongchoice[4]{4}\scoring{4} \wrongchoice[4]{4}\scoring{4}
\wrongchoice[5]{5}\scoring{5} \wrongchoice[5]{5}\scoring{5}
\correctchoice[6]{6}\scoring{6} \correctchoice[6]{6}\scoring{6}
\end{choices} \end{choices}
\end{multicols} \end{multicols}
\end{question} \end{question}
\begin{question}{11}{\textbf{Aufgabe 11} [\emph{4 Punkte}]} \begin{question}{11}{\textbf{Aufgabe 11} [\emph{4 Punkte}]}
\begin{multicols}{8} \begin{multicols}{8}
\begin{choices}[o] \begin{choices}[o]
\wrongchoice[0]{0}\scoring{0} \wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1} \wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2} \wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3} \wrongchoice[3]{3}\scoring{3}
\correctchoice[4]{4}\scoring{4} \correctchoice[4]{4}\scoring{4}
\end{choices} \end{choices}
\end{multicols} \end{multicols}
\end{question} \end{question}
\begin{question}{12}{\textbf{Aufgabe 12} [\emph{6 Punkte}]} \begin{question}{12}{\textbf{Aufgabe 12} [\emph{6 Punkte}]}
\begin{multicols}{8} \begin{multicols}{8}
\begin{choices}[o] \begin{choices}[o]
\wrongchoice[0]{0}\scoring{0} \wrongchoice[0]{0}\scoring{0}
\wrongchoice[1]{1}\scoring{1} \wrongchoice[1]{1}\scoring{1}
\wrongchoice[2]{2}\scoring{2} \wrongchoice[2]{2}\scoring{2}
\wrongchoice[3]{3}\scoring{3} \wrongchoice[3]{3}\scoring{3}
\wrongchoice[4]{4}\scoring{4} \wrongchoice[4]{4}\scoring{4}
\wrongchoice[5]{5}\scoring{5} \wrongchoice[5]{5}\scoring{5}
\correctchoice[6]{6}\scoring{6} \correctchoice[6]{6}\scoring{6}
\end{choices} \end{choices}
\end{multicols} \end{multicols}
\end{question} \end{question}
``` ```
</details> </details>
Here is an example using this code: [grading_mc.tex](uploads/50d4ed6e22a0edc2cd9daf40410a1bb4/grading_mc.tex). Here is an example using this code: [grading_mc.tex](uploads/50d4ed6e22a0edc2cd9daf40410a1bb4/grading_mc.tex).
You can either use the `\input{grading_mc.tex}` command to include this at the end of the MC answer sheet (doing it this way will ensure that [versioning](https://gitlab.math.ethz.ch/teaching/exam-template/-/wikis/Randomization-using-TeX) works as expected), **or** compile as a **separate** AMC project and print separately (not via the print tool). You can either use the `\input{grading_mc.tex}` command to include this at the end of the MC answer sheet (doing it this way will ensure that [versioning](https://gitlab.math.ethz.ch/teaching/exam-template/-/wikis/Randomization-using-TeX) works as expected), **or** compile as a **separate** AMC project and print separately (not via the print tool).
# Grading file # Grading file
The `GradingWorkbookCreator.xlsm` is an excel based tool that is able to **import student data from, end export it to eDoz**. The `GradingWorkbookCreator.xlsm` is an excel based tool that is able to **import student data from, end export it to eDoz**. This tool needs development, in its current stage it is rather intricate. As a general rule you should always maintain a backup copy of the file in case your working copy corrupts!
The file is located in the central git repo ([download](https://gitlab.math.ethz.ch/teaching/exam-template/-/blob/main/GradingWorkbookCreator.xlsm)). The file is located in the central git repo ([download](https://gitlab.math.ethz.ch/teaching/exam-template/-/blob/main/GradingWorkbookCreator.xlsm)).
Once you open the file, you are presented with the instructions on how to use it. ## Opening the file via citrix
![grading_book](uploads/9a3f6bdeb90618316808b63c85ba730a/grading_book.png) To work with the file it is best if you proceed as follows.
**Please note:** 1. On an ISG supplied Linux client (either physical or via ThinLinc), start the Citrix Workspace. (If you start the software for the first time you must accept the license agreement and supply your user information: your_username@d, your eMail password).
1. The **file runs stably using Microsoft Excel**. OpenSource alternatives may generate an error.
2. Your **computer's regional settings must be set to US English**. WIth this setting "," instead of "." is used to separate the decimals. ![citrix](uploads/08204ad5436948903c973843034e7813/citrix.jpg)
3. Special characters such as "ä", "ü" or "ö" may appear in wrong formatting. This **should not cause any concern**. The data will be accepted by eDoz and recognized correctly.
2. In citrix, open Microsoft Excel.
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.
![citrix_home](uploads/2d54b968bb8e8b1ec9d7d808aa50fbf7/citrix_home.jpg)
![gradebook](uploads/89a6897e5e8157633d93b84c2900c3f7/gradebook.png)
3. In Excel, hit open, then brose. Via "shares" you can access your home directory (you cannot access the files directly e.g. via "Desktop", you must access files stored on the desktop via the shares and your home directory!)
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).
![excel_2](uploads/727be3b5e6562f9c480b139fa62952da/excel_2.jpg)
![Screenshot_from_2022-12-05_18-20-00](uploads/65efe308afe9700ba5254637abb3c308/Screenshot_from_2022-12-05_18-20-00.png)
## Working with the file
**Once you have fixed the grades, you can export the data from the file, and import it to eDoz.**
Once you open the file, you are presented with the instructions on how to use it.
![grading_book](uploads/9a3f6bdeb90618316808b63c85ba730a/grading_book.png)
**Please note:**
1. The **file runs stably using Microsoft Excel**. OpenSource alternatives may generate an error.
2. Your **computer's regional settings must be set to US English**. WIth this setting "," instead of "." is used to separate the decimals.
3. Special characters such as "ä", "ü" or "ö" may appear in wrong formatting. This **should not cause any concern**. The data will be accepted by eDoz and recognized correctly.
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.
![gradebook](uploads/89a6897e5e8157633d93b84c2900c3f7/gradebook.png)
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)
**Once you have fixed the grades, you can export the data from the file, and import it to eDoz.**
For a more sophisticated statistical analysis of how well students fared on the exam (in particular on the MC part), check out [this tool](https://gitlab.math.ethz.ch/teaching/exam-template/-/wikis/Statistical-analysis-of-multiple-choice-results). For a more sophisticated statistical analysis of how well students fared on the exam (in particular on the MC part), check out [this tool](https://gitlab.math.ethz.ch/teaching/exam-template/-/wikis/Statistical-analysis-of-multiple-choice-results).
\ No newline at end of file