Return to Spreadsheet_Layout.tex CVS log

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

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

1.1       matthew     1: \label{Spreadsheet_Layout}
                      2: 
                      3: This section describes the layout of each level of spreadsheet.  See the
1.2     ! riegler     4: section on the Spreadsheet Hierarchy (\ref{Spreadsheet_Hierarchy}) 
1.1       matthew     5: for a description of the types of spreadsheets and their data-flow 
                      6: relationships.
                      7: 
                      8: 
1.2     ! riegler     9: \noindent
1.1       matthew    10: \textbf{General Characteristics} 
                     11: 
                     12: Each spreadsheet has 52 columns and a variable number of rows.  
                     13: The columns of the spreadsheets are labeled 'A-z'.
                     14: The rows of the spreadsheets contain data appropriate to the spreadsheet as 
1.2     ! riegler    15: described below.  The section Spreadsheet Row Numbers
1.1       matthew    16: (\ref{Spreadsheet_Row_Numbers}) describes how row numbers are assigned.
                     17: 
1.2     ! riegler    18: \noindent
1.1       matthew    19: \textbf{Assessment Spreadsheet Layout}
                     20: 
                     21: There are two special rows on the top of the assessment spreadsheet.
1.2     ! riegler    22: The first is the template row (\ref{Spreadsheet_Template_Row}).
        !            23: The second row is the export row (\ref{Spreadsheet_Export_Row}).
1.1       matthew    24: 
                     25: The main body of the assessment spreadsheet contains the parameters associated
                     26: with the assessment.  The parameter values appear in the ``A'' column of the
                     27: spreadsheet and cannot be edited.  The remainder of the spreadsheet columns,
                     28: labeled ``B-z'', can be edited and used for computations.
                     29: 
1.2     ! riegler    30: See Referencing Spreadsheet Parameters 
1.1       matthew    31: (\ref{Spreadsheet_Referencing_Parameters}) for information
                     32: on how to reference a parameter value in the spreadsheet.
                     33: 
1.2     ! riegler    34: \noindent
1.1       matthew    35: \textbf{Student Spreadsheet Layout}
                     36: 
                     37: The student spreadsheet has both a 
                     38: \textbf{template row} (\ref{Spreadsheet_Template_Row}) and an 
                     39: \textbf{export row} (\ref{Spreadsheet_Export_Row}).
                     40: 
                     41: The main body of the student spreadsheet contains the export rows of the
                     42: assessments in the course.  Each assessment appears beneath the title of
                     43: the folder or sequence which it belongs to.  The first 26 columns of the
                     44: main body of the spreadsheet, ``A-Z'', are the export data from the assessments
                     45: and cannot be edited.  The remaining columns, ``a-z'', can be edited.
                     46: 
1.2     ! riegler    47: \noindent
1.1       matthew    48: \textbf{Course Spreadsheet Layout}
                     49: 
                     50: The course spreadsheet contains the data exported from each student level
                     51: spreadsheet. 
                     52: 
                     53: The two topmost rows are the \textbf{template row} 
                     54: (\ref{Spreadsheet_Template_Row}) and a summary row.  
                     55: The remainder of the spreadsheet it taken up with student data.
                     56: Each student spreadsheet exports one row to the course spreadsheet.  The
                     57: first 26 columns, ``A-Z'', contain the student data and cannot be edited.  
                     58: The remaining 26 columns ``a-z'', can be edited.
1.2     ! riegler    59: