Annotation of loncom/html/adm/help/tex/Spreadsheet_HowTo_Assessments.tex, revision 1.5
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.5 ! lira 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
1.1 matthew 8: parts, while not knowing how many parts there are as the spreadsheet
9: is written.
10:
1.2 webbsuza 11: The spreadsheet has a preprocessor which can expand a symbolic
1.5 ! lira 12: expression over all symbolic names that match. The general syntax is
1.1 matthew 13: \index{EXPANDSUM} \texttt{[\&EXPANDSUM(VARNAME;expression)]}.
14:
1.5 ! lira 15: \noindent
! 16: For example, for the above assessment with four parts,\\
1.1 matthew 17:
1.5 ! lira 18: \noindent
1.3 riegler 19: \texttt{\&EXPANDSUM(}\texttt{\textbf{PART}}\texttt{;parameter\_}\texttt{\textbf{PART}}\texttt{\_weight{*}stores\_}\texttt{\textbf{PART}}\texttt{\_awarded)}\\
1.5 ! lira 20:
! 21: \noindent
! 22: would become\\
! 23:
! 24: \noindent
1.1 matthew 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 +}~\\
1.5 ! lira 29: % bold does not show
! 30: % where \textbf{bolded text} is used to highlight what the \texttt{\&EXPANDSUM} function is doing.
! 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:
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>