Return to Spreadsheet_Layout.tex CVS log

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

fix formatting.

    1: \label{Spreadsheet_Layout}
    2: 
    3: This section describes the layout of each level of spreadsheet.  See the
    4: section on the \textbf{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 \textbf{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 \textbf{template row} (\ref{Spreadsheet_Template_Row}).
   23: The second row is the \textbf{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: See \textbf{Referencing Spreadsheet Parameters} 
   30: (\ref{Spreadsheet_Referencing_Parameters}) for information
   31: on how to reference a parameter value in the spreadsheet.\\
   32: 
   33: \noindent
   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
   44: and cannot be edited.  The remaining columns, ``a-z'', can be edited.\\
   45: 
   46: \noindent
   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.
   58: