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.3

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