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