Return to Spreadsheet_HowTo_Assessments.tex CVS log

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

- Revert some of the changes in rev 1.5.

    1: \label{Spreadsheet_HowTo_Assessments}
    2: 
    3: \textbf{How to deal with multi-part problems}
    4: 
    5: Often, there are several parts in a specific problem. For example, a
    6: problem with three parts may have parts 0, 11, 12, and 13, where
    7: part 0, is the part ID reserved for the problem as a whole.  For a
    8: general spreadsheet, it is often desirable to sum up all of these
    9: parts, while not knowing how many parts there are as the spreadsheet
   10: is written.
   11: 
   12: The spreadsheet has a preprocessor which can expand a symbolic
   13: expression over all symbolic names that match. The general syntax is
   14: \index{EXPANDSUM} \texttt{[\&EXPANDSUM(VARNAME;expression)]}. 
   15: 
   16: \noindent
   17: For example, for the above assessment with three parts,\\
   18: 
   19: \noindent
   20: \texttt{\&EXPANDSUM(}\texttt{\textbf{PART}}\texttt{;parameter\_}\texttt{\textbf{PART}}\texttt{\_weight{*}stores\_}\texttt{\textbf{PART}}\texttt{\_awarded)}\\
   21: 
   22: \noindent
   23: would become\\
   24: 
   25: \noindent
   26: \texttt{parameter\_0\_weight{*}stores\_0\_awarded +}~\\
   27: \texttt{parameter\_11\_weight{*}stores\_11\_awarded +}~\\
   28: \texttt{parameter\_12\_weight{*}stores\_12\_awarded +}~\\
   29: \texttt{parameter\_13\_weight{*}stores\_13\_awarded +}~\\
   30: where \textbf{bolded text} is used to highlight (PDF version of manual excluded) what the \texttt{\&EXPANDSUM} function is doing.\\
   31: 
   32: 
   33: \noindent
   34: \textbf{What `tries' means}
   35: 
   36: In multi-part questions, the exported value for ``tries''\index{tries} is 
   37: the average number of tries to get the parts correct. 
   38: 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}).
   39: