How to export all student answers?

Added by Craig Howald almost 8 years ago

I tried to create an answer sheet with ten arbitrary choices for each question. I would like all student answers to be exported into a spreadsheet for analysis later. However, the export only gives this information:

Exam    A:    Name    note    total    max
            20.0    max    
            0.0    mean    
1:1        ?    0.0    0    1
1:2        ?    0.0    0    1
1:3        ?    0.0    0    1

and nothing specific to each question.

Where I would like the answers for each question for each student (one numeric value for each question or a boolean for each possible response).

How do I get this output?

Thanks very much,
Craig

PS: Here is the LATEX file I am using:

\documentclass[letterpaper]{article}
\usepackage{multicol}
\usepackage[insidebox,noshuffle,postcorrect,outsidebox]{automultiplechoice}
\definecolor{amcboxcolor}{rgb}{0,0,0}
\AMCboxColor{amcboxcolor}
\def\AMCbeginQuestion#1#2{\par\noindent{\bf Q#1} \hspace*{1em}} %how questions are displayed
\def\AMCchoiceLabel#1{} 

\begin{document}
\onecopy{1}{
\noindent
%table for student ID.  Can this been drawn better?
\begin{tabular}{|l|l|l|}  
\hline
N &
student number \\
\hline
\vspace{-0.25cm}
\\
%{\def\AMCchoiceLabelFormat#1{#1} 
\AMCcode{class}{1}&
{\def\AMCchoiceLabelFormat##1{} \AMCcode{StudentNum}{7}}

\\
\hline
\end{tabular}
% Name box.  Would be better wider with dotted line at bottom.
\hfill\namefield{\fbox{     
\begin{minipage}{.5\linewidth}
\vspace*{10mm}
Name:
\vspace*{.5cm}\dotfill
\vspace*{1mm}

Date:
\vspace*{.5cm}\dotfill
\vspace*{1mm}

Class:
\vspace*{.5cm}\dotfill
\vspace*{1mm}
\end{minipage}
}}\hfill

Answer by placing an X in the appropriate box.

\begin{multicols}{2}\columnseprule=.4pt

% Header labelling boxes. It would be nice if letters were placed at a specific location, instead of putting 0.1 cm of empty space between letters.  If this is changed, it needs to be changed at several other points as well. It would be nice to associate headre with the block of questions between it and next header, so that column break happens after Q26 instead of Q27.
\hspace{0.5cm}
A  \hspace {0.10cm} 
B  \hspace {0.1cm} 
C  \hspace {0.1cm} 
D  \hspace {0.1cm} 
E  \hspace {0.1cm} 
F  \hspace {0.1cm} 
G  \hspace {0.1cm} 
H  \hspace {0.1cm} 
I  \hspace {0.1cm} 
J  \hspace {0.1cm} 

% first question.  it would be nice if choice boxes could be placed at a specific location, instead of just after question number.  mostly this causes a problem when question # goes from one digit to two.
\begin{question}{01}
\hspace{0.0cm}
\begin{choicescustom}
\wrongchoice{A}\scoring{1}%
\wrongchoice{B}\scoring{2}%
\wrongchoice{C}\scoring{3}%
\wrongchoice{D}\scoring{4}%
\wrongchoice{E}\scoring{5}%
\wrongchoice{F}\scoring{6}%
\wrongchoice{G}\scoring{7}%
\wrongchoice{H}\scoring{8}%
\wrongchoice{I}\scoring{9}%
\wrongchoice{J}\scoring{0}%
\end{choicescustom}
\end{question}

\begin{question}{02}
\hspace{0.0cm}
\begin{choicescustom}
\wrongchoice{}\scoring{1}%
\wrongchoice{}\scoring{2}%
\wrongchoice{}\scoring{3}%
\wrongchoice{}\scoring{4}%
\wrongchoice{}\scoring{5}%
\wrongchoice{}\scoring{6}%
\wrongchoice{}\scoring{7}%
\wrongchoice{}\scoring{8}%
\wrongchoice{}\scoring{9}%
\wrongchoice{}\scoring{0}%
\end{choicescustom}
\end{question}

\end{multicols}
}

\end{document}

Replies (3)

RE: How to export all student answers? - Added by Alexis Bienvenüe almost 8 years ago

You can use CSV export with Ticked boxes option.

RE: How to export all student answers? - Added by Craig Howald almost 8 years ago

I was doing thins. It didn't work.

However, I have made it work. Apparently, I need to run "update marking scale" even though I am doing no marking. If I then click cancel and run marking without "update marking scale clicked" it will record properly. Why is this?

Thanks,
Craig

RE: How to export all student answers? - Added by Alexis Bienvenüe almost 8 years ago

I was doing this. It didn't work.

What was the problem?

(1-3/3)