Return to Spreadsheet_HowTo_Assessments.tex CVS log

Up to [LON-CAPA] / loncom / html / adm / help / tex

Annotation of loncom/html/adm/help/tex/Spreadsheet_HowTo_Assessments.tex, revision 1.1

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
        !             6: problem with three parts would have parts 0, 11, 12, and 13. For a
        !             7: general spreadsheet, it is not 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 an expand a symbolic
        !            12: expression over all symbolic names that fit. The general syntax is
        !            13: \index{EXPANDSUM} \texttt{[\&EXPANDSUM(VARNAME;expression)]}. 
        !            14: 
        !            15: For example, for the above assessment with three parts,
        !            16: 
        !            17: \texttt{\&EXPANDSUM(}\texttt{\textbf{PART}}\texttt{;parameter\_}\texttt{\textbf{PART}}\texttt{\_weight{*}stores\_}\texttt{\textbf{PART}}\texttt{\_awarded)}
        !            18: 
        !            19: would become
        !            20: 
        !            21: \texttt{parameter\_0\_weight{*}stores\_0\_awarded +}~\\
        !            22: \texttt{parameter\_11\_weight{*}stores\_11\_awarded +}~\\
        !            23: \texttt{parameter\_12\_weight{*}stores\_12\_awarded +}~\\
        !            24: \texttt{parameter\_13\_weight{*}stores\_13\_awarded +}~\\
        !            25: 
        !            26: where \textbf{bolded text} is used to highlight what the
        !            27: \texttt{\&EXPANDSUM} function is doing.
        !            28: 
        !            29: \textbf{What 'tries' means}
        !            30: 
        !            31: In multi-part questions, the exported value for "tries"\index{tries} is now 
        !            32: the average number of tries to get the parts right. 
        !            33: The full data for each part is still stored by the system.