Return to Spreadsheet_Row_Numbers.tex CVS log

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

Annotation of loncom/html/adm/help/tex/Spreadsheet_Row_Numbers.tex, revision 1.2

1.1       matthew     1: \label{Spreadsheet_Row_Numbers}
                      2: 
                      3: LON-CAPA ensures every row in a spreadsheet is uniquely and persistently
                      4: assigned a row number.  Once a row number is used, it cannot be reused.
                      5: The following sections describe the consequences
                      6: of this and answer ``why are the rows of the spreadsheet out of order?''.
                      7: 
1.2     ! riegler     8: \noindent
1.1       matthew     9: \textbf{Assessment Spreadsheet}
                     10: 
                     11: Every parameter associated with an assessment has a unique row in the
                     12: assessment level spreadsheet.  As new parameters are encountered they
                     13: are assigned the next available row number.  Adding a parameter to an
                     14: assessment thus results in the new parameter appearing at the bottom of
                     15: the spreadsheet.  Since the default spreadsheet definition must cover all
                     16: of the assessments in the course, there are likely to be a large number of
                     17: parameters available.
                     18: 
1.2     ! riegler    19: \noindent
1.1       matthew    20: \textbf{Student Spreadsheet}
                     21: 
                     22: The student level spreadsheet displays information about each assessment
                     23: in the course.  The row numbers are initially assigned based on the order 
                     24: in which assessments appear in the course.  If a new assessment is 
                     25: added at a later time, it will be assigned the next higher row number.
                     26: Regardless of the row number, the assessment will appear in the proper place
                     27: in the course structure.
                     28: 
1.2     ! riegler    29: \noindent
1.1       matthew    30: \textbf{Course Spreadsheet}
                     31: 
                     32: The rows of the course spreadsheet are assigned to students as they are
                     33: encountered in the class list.  Each student is 
                     34: assigned a row number the first time they are present in the course.
                     35: The rows are listed alphabetized by the students full name and the row
                     36: numbers are assigned in this order.  If a student is later added, they
                     37: will appear in the proper place alphabetically in the spreadsheet but
                     38: their row number will not be in sequence.