Return to Spreadsheet_Op_On_All_Problem_Parts.tex CVS log

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

Annotation of loncom/html/adm/help/tex/Spreadsheet_Op_On_All_Problem_Parts.tex, revision 1.5

1.2       bowersj2    1: \label{Spreadsheet_Op_On_All_Problem_Parts}
1.1       bowersj2    2: Often, there are several parts in a specific problem. For example, a
                      3: problem with three parts would have parts 0, 11, 12, and 13. For a
                      4: general spreadsheet, it is not often desirable to sum up all of these
                      5: parts, while not knowing how many parts there are as the spreadsheet
                      6: is written.
                      7: 
                      8: The spreadsheet has a preprocessor which an expand a symbolic
                      9: expression over all symbolic names that fit. The general syntax is
1.3       bowersj2   10: \index{EXPANDSUM} \texttt{[\&EXPANDSUM(VARNAME;expression)]}. 
1.1       bowersj2   11: 
                     12: For example, for the above assessment with three parts,
                     13: 
1.4       bowersj2   14: \texttt{\&EXPANDSUM(}\texttt{\textbf{PART}}\texttt{;parameter\_}\texttt{\textbf{PART}}\texttt{\_weight{*}stores\_}\texttt{\textbf{PART}}\texttt{\_awarded)}
1.1       bowersj2   15: 
                     16: would become
                     17: 
1.4       bowersj2   18: \texttt{parameter\_0\_weight{*}stores\_0\_awarded +}~\\
                     19: \texttt{parameter\_11\_weight{*}stores\_11\_awarded +}~\\
                     20: \texttt{parameter\_12\_weight{*}stores\_12\_awarded +}~\\
                     21: \texttt{parameter\_13\_weight{*}stores\_13\_awarded +}~\\
1.1       bowersj2   22: 
                     23: where \textbf{bolded text} is used to highlight what the
1.5     ! bowersj2   24: \texttt{\&EXPANDSUM} function is doing.
1.4       bowersj2   25: In multi-part questions, "tries"\index{tries} is now the average number of tries to
                     26: get the parts right. The full data for each part is still stored by
                     27: the system. To expand the data and work with all parts, please see
                     28: \ref{Spreadsheet_Op_On_All_Problem_Parts}.