Return to Spreadsheet_Layout.tex CVS log

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

Updating chapter 15 of cc manual.

    1: \label{Spreadsheet_Layout}
    2: 
    3: This section describes the layout of each level of spreadsheet.  See the
    4: section on the Spreadsheet Hierarchy (\ref{Spreadsheet_Hierarchy}) 
    5: for a description of the types of spreadsheets and their data-flow 
    6: relationships.
    7: 
    8: 
    9: \noindent
   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 
   15: described below.  The section Spreadsheet Row Numbers
   16: (\ref{Spreadsheet_Row_Numbers}) describes how row numbers are assigned.
   17: 
   18: \noindent
   19: \textbf{Assessment Spreadsheet Layout}
   20: 
   21: There are two special rows on the top of the assessment spreadsheet.
   22: The first is the template row (\ref{Spreadsheet_Template_Row}).
   23: The second row is the export row (\ref{Spreadsheet_Export_Row}).
   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: 
   30: See Referencing Spreadsheet Parameters 
   31: (\ref{Spreadsheet_Referencing_Parameters}) for information
   32: on how to reference a parameter value in the spreadsheet.
   33: 
   34: \noindent
   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: 
   47: \noindent
   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.
   59: