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}.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>