Return to Spreadsheet_HowTo_Assessments.tex CVS log

Up to [LON-CAPA] / loncom / html / adm / help / tex

wording should say four parts, not three. Also fix formatting.

\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 four parts may have parts 0, 11, 12, and 13. 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 four 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 +}~\\
% bold does not show
% where \textbf{bolded text} is used to highlight 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}).