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 four parts may have parts 0, 11, 12, and 13. For a
7: general spreadsheet, it is often desirable to sum up all of these
8: parts, while not knowing how many parts there are as the spreadsheet
9: is written.
10:
11: The spreadsheet has a preprocessor which can expand a symbolic
12: expression over all symbolic names that match. The general syntax is
13: \index{EXPANDSUM} \texttt{[\&EXPANDSUM(VARNAME;expression)]}.
14:
15: \noindent
16: For example, for the above assessment with four parts,\\
17:
18: \noindent
19: \texttt{\&EXPANDSUM(}\texttt{\textbf{PART}}\texttt{;parameter\_}\texttt{\textbf{PART}}\texttt{\_weight{*}stores\_}\texttt{\textbf{PART}}\texttt{\_awarded)}\\
20:
21: \noindent
22: would become\\
23:
24: \noindent
25: \texttt{parameter\_0\_weight{*}stores\_0\_awarded +}~\\
26: \texttt{parameter\_11\_weight{*}stores\_11\_awarded +}~\\
27: \texttt{parameter\_12\_weight{*}stores\_12\_awarded +}~\\
28: \texttt{parameter\_13\_weight{*}stores\_13\_awarded +}~\\
29: % bold does not show
30: % where \textbf{bolded text} is used to highlight 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:
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>