[BACK]Return to Spreadsheet_Layout.tex CVS log [TXT] [DIR] Up to [LON-CAPA] / loncom / html / adm / help / tex
File:  [LON-CAPA] / loncom / html / adm / help / tex / Spreadsheet_Layout.tex
Revision 1.1: download - view: text, annotated - select for diffs
Fri Aug 29 21:08:40 2003 UTC (20 years, 10 months ago) by matthew
Branches: MAIN
CVS tags: version_2_9_X, version_2_9_99_0, version_2_9_1, version_2_9_0, version_2_8_X, version_2_8_99_1, version_2_8_99_0, version_2_8_2, version_2_8_1, version_2_8_0, version_2_7_X, version_2_7_99_1, version_2_7_99_0, version_2_7_1, version_2_7_0, version_2_6_X, version_2_6_99_1, version_2_6_99_0, version_2_6_3, version_2_6_2, version_2_6_1, version_2_6_0, version_2_5_X, version_2_5_99_1, version_2_5_99_0, version_2_5_2, version_2_5_1, version_2_5_0, version_2_4_X, version_2_4_99_0, version_2_4_2, version_2_4_1, version_2_4_0, version_2_3_X, version_2_3_99_0, version_2_3_2, version_2_3_1, version_2_3_0, version_2_2_X, version_2_2_99_1, version_2_2_99_0, version_2_2_2, version_2_2_1, version_2_2_0, version_2_1_X, version_2_1_99_3, version_2_1_99_2, version_2_1_99_1, version_2_1_99_0, version_2_1_3, version_2_1_2, version_2_1_1, version_2_1_0, version_2_0_X, version_2_0_99_1, version_2_0_2, version_2_0_1, version_2_0_0, version_1_99_3, version_1_99_2, version_1_99_1_tmcc, version_1_99_1, version_1_99_0_tmcc, version_1_99_0, version_1_3_X, version_1_3_3, version_1_3_2, version_1_3_1, version_1_3_0, version_1_2_X, version_1_2_99_1, version_1_2_99_0, version_1_2_1, version_1_2_0, version_1_1_X, version_1_1_99_5, version_1_1_99_4, version_1_1_99_3, version_1_1_99_2, version_1_1_99_1, version_1_1_99_0, version_1_1_3, version_1_1_2, version_1_1_1, version_1_1_0, version_1_0_99_3, version_1_0_99_2, version_1_0_99_1, version_1_0_99, version_1_0_3, version_1_0_2, version_1_0_1, bz6209-base, bz6209, bz5969, bz2851, PRINT_INCOMPLETE_base, PRINT_INCOMPLETE, HEAD, GCI_3, GCI_2, GCI_1, BZ5971-printing-apage, BZ5434-fox
New spreadsheet help files.

    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.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>