File:
[LON-CAPA] /
loncom /
html /
adm /
help /
tex /
Spreadsheet_HowTo_Assessments.tex
Revision
1.2:
download - view:
text,
annotated -
select for diffs
Tue Aug 8 17:47:27 2006 UTC (18 years, 1 month ago) by
webbsuza
Branches:
MAIN
CVS tags:
version_2_9_X,
version_2_9_99_0,
version_2_9_1,
version_2_9_0,
version_2_8_X,
version_2_8_99_1,
version_2_8_99_0,
version_2_8_2,
version_2_8_1,
version_2_8_0,
version_2_7_X,
version_2_7_99_1,
version_2_7_99_0,
version_2_7_1,
version_2_7_0,
version_2_6_X,
version_2_6_99_1,
version_2_6_99_0,
version_2_6_3,
version_2_6_2,
version_2_6_1,
version_2_6_0,
version_2_5_X,
version_2_5_99_1,
version_2_5_99_0,
version_2_5_2,
version_2_5_1,
version_2_5_0,
version_2_4_X,
version_2_4_99_0,
version_2_4_2,
version_2_4_1,
version_2_4_0,
version_2_3_X,
version_2_3_99_0,
version_2_3_2,
version_2_3_1,
version_2_3_0,
version_2_2_X,
version_2_2_99_1,
version_2_2_99_0,
version_2_2_2,
version_2_2_1,
version_2_2_0,
version_2_1_99_3,
bz6209-base,
bz6209,
bz5969,
bz2851,
PRINT_INCOMPLETE_base,
PRINT_INCOMPLETE,
HEAD,
GCI_3,
GCI_2,
GCI_1,
BZ5971-printing-apage,
BZ5434-fox
reworded, changing from passivve to active voice, added commas, fixed a few typos.CVS: ----------------------------------------------------------------------
\label{Spreadsheet_HowTo_Assessments}
\textbf{How to deal with multi-part problems}
Often, there are several parts in a specific problem. For example, a
problem with three parts would have parts 0, 11, 12, and 13. For a
general spreadsheet, it is not often desirable to sum up all of these
parts, while not knowing how many parts there are as the spreadsheet
is written.
The spreadsheet has a preprocessor which can expand a symbolic
expression over all symbolic names that fit. The general syntax is
\index{EXPANDSUM} \texttt{[\&EXPANDSUM(VARNAME;expression)]}.
For example, for the above assessment with three parts,
\texttt{\&EXPANDSUM(}\texttt{\textbf{PART}}\texttt{;parameter\_}\texttt{\textbf{PART}}\texttt{\_weight{*}stores\_}\texttt{\textbf{PART}}\texttt{\_awarded)}
would become
\texttt{parameter\_0\_weight{*}stores\_0\_awarded +}~\\
\texttt{parameter\_11\_weight{*}stores\_11\_awarded +}~\\
\texttt{parameter\_12\_weight{*}stores\_12\_awarded +}~\\
\texttt{parameter\_13\_weight{*}stores\_13\_awarded +}~\\
where \textbf{bolded text} is used to highlight what the
\texttt{\&EXPANDSUM} function is doing.
\textbf{What 'tries' means}
In multi-part questions, the exported value for "tries"\index{tries} is now
the average number of tries to get the parts right.
The full data for each part is still stored by the system.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>