loncom/html/adm/help/tex/Spreadsheet_HowTo_Assessments.tex - view

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 (17 years, 11 months 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.