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

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