Return to Spreadsheet_HowTo_Assessments.tex CVS log

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

Annotation of loncom/html/adm/help/tex/Spreadsheet_HowTo_Assessments.tex, revision 1.6

1.1       matthew     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
1.6     ! raeburn     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
1.5       lira        8: general spreadsheet, it is often desirable to sum up all of these
1.1       matthew     9: parts, while not knowing how many parts there are as the spreadsheet
                     10: is written.
                     11: 
1.2       webbsuza   12: The spreadsheet has a preprocessor which can expand a symbolic
1.5       lira       13: expression over all symbolic names that match. The general syntax is
1.1       matthew    14: \index{EXPANDSUM} \texttt{[\&EXPANDSUM(VARNAME;expression)]}. 
                     15: 
1.5       lira       16: \noindent
1.6     ! raeburn    17: For example, for the above assessment with three parts,\\
1.1       matthew    18: 
1.5       lira       19: \noindent
1.3       riegler    20: \texttt{\&EXPANDSUM(}\texttt{\textbf{PART}}\texttt{;parameter\_}\texttt{\textbf{PART}}\texttt{\_weight{*}stores\_}\texttt{\textbf{PART}}\texttt{\_awarded)}\\
1.5       lira       21: 
                     22: \noindent
                     23: would become\\
                     24: 
                     25: \noindent
1.1       matthew    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 +}~\\
1.6     ! raeburn    30: where \textbf{bolded text} is used to highlight (PDF version of manual excluded) what the \texttt{\&EXPANDSUM} function is doing.\\
1.5       lira       31: 
1.1       matthew    32: 
1.3       riegler    33: \noindent
1.4       lira       34: \textbf{What `tries' means}
1.1       matthew    35: 
1.5       lira       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: