\label{Spreadsheet_HowTo_Assessments}

\textbf{How to deal with multi-part problems}

Often, there are several parts in a specific problem. For example, a
problem with three parts may have parts 0, 11, 12, and 13, where
part 0, is the part ID reserved for the problem as a whole.  For a
general spreadsheet, it is often desirable to sum up all of these
parts, while not knowing how many parts there are as the spreadsheet
is written.

The spreadsheet has a preprocessor which can expand a symbolic
expression over all symbolic names that match. The general syntax is
\index{EXPANDSUM} \texttt{[\&EXPANDSUM(VARNAME;expression)]}. 

\noindent
For example, for the above assessment with three parts,\\

\noindent
\texttt{\&EXPANDSUM(}\texttt{\textbf{PART}}\texttt{;parameter\_}\texttt{\textbf{PART}}\texttt{\_weight{*}stores\_}\texttt{\textbf{PART}}\texttt{\_awarded)}\\

\noindent
would become\\

\noindent
\texttt{parameter\_0\_weight{*}stores\_0\_awarded +}~\\
\texttt{parameter\_11\_weight{*}stores\_11\_awarded +}~\\
\texttt{parameter\_12\_weight{*}stores\_12\_awarded +}~\\
\texttt{parameter\_13\_weight{*}stores\_13\_awarded +}~\\
where \textbf{bolded text} is used to highlight (PDF version of manual excluded) what the \texttt{\&EXPANDSUM} function is doing.\\


\noindent
\textbf{What `tries' means}

In multi-part questions, the exported value for ``tries''\index{tries} is 
the average number of tries to get the parts correct. 
The full data for each part is still stored by the system. To assign partial credit based on number of tries, see the example in \textbf{Special Functions} (\ref{Spreadsheet_Functions}).