loncom/html/adm/help/tex/Spreadsheet_Layout.tex - view

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.

\label{Spreadsheet_Layout} This section describes the layout of each level of spreadsheet. See the section on the \textbf{Spreadsheet Hierarchy} (\ref{Spreadsheet_Hierarchy}) for a description of the types of spreadsheets and their data-flow relationships. \textbf{General Characteristics} Each spreadsheet has 52 columns and a variable number of rows. The columns of the spreadsheets are labeled 'A-z'. The rows of the spreadsheets contain data appropriate to the spreadsheet as described below. The section \textbf{Spreadsheet Row Numbers} (\ref{Spreadsheet_Row_Numbers}) describes how row numbers are assigned. \textbf{Assessment Spreadsheet Layout} There are two special rows on the top of the assessment spreadsheet. The first is the \textbf{template row} (\ref{Spreadsheet_Template_Row}). The second row is the \textbf{export row} (\ref{Spreadsheet_Export_Row}). The main body of the assessment spreadsheet contains the parameters associated with the assessment. The parameter values appear in the ``A'' column of the spreadsheet and cannot be edited. The remainder of the spreadsheet columns, labeled ``B-z'', can be edited and used for computations. See \textbf{Referencing Spreadsheet Parameters} (\ref{Spreadsheet_Referencing_Parameters}) for information on how to reference a parameter value in the spreadsheet. \textbf{Student Spreadsheet Layout} The student spreadsheet has both a \textbf{template row} (\ref{Spreadsheet_Template_Row}) and an \textbf{export row} (\ref{Spreadsheet_Export_Row}). The main body of the student spreadsheet contains the export rows of the assessments in the course. Each assessment appears beneath the title of the folder or sequence which it belongs to. The first 26 columns of the main body of the spreadsheet, ``A-Z'', are the export data from the assessments and cannot be edited. The remaining columns, ``a-z'', can be edited. \textbf{Course Spreadsheet Layout} The course spreadsheet contains the data exported from each student level spreadsheet. The two topmost rows are the \textbf{template row} (\ref{Spreadsheet_Template_Row}) and a summary row. The remainder of the spreadsheet it taken up with student data. Each student spreadsheet exports one row to the course spreadsheet. The first 26 columns, ``A-Z'', contain the student data and cannot be edited. The remaining 26 columns ``a-z'', can be edited.