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, 11 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>