Return to Spreadsheet_HowTo_Assessments.tex CVS log

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

Updating chapter 15 of cc manual.

\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 would have parts 0, 11, 12, and 13. For a
general spreadsheet, it is not 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 fit. The general syntax is
\index{EXPANDSUM} \texttt{[\&EXPANDSUM(VARNAME;expression)]}. 

For example, for the above assessment with three parts,

\texttt{\&EXPANDSUM(}\texttt{\textbf{PART}}\texttt{;parameter\_}\texttt{\textbf{PART}}\texttt{\_weight{*}stores\_}\texttt{\textbf{PART}}\texttt{\_awarded)}\\
would become
\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 what the
\texttt{\&EXPANDSUM} function is doing.

\noindent
\textbf{What 'tries' means}

In multi-part questions, the exported value for "tries"\index{tries} is now 
the average number of tries to get the parts right. 
The full data for each part is still stored by the system.