File:
[LON-CAPA] /
loncom /
html /
adm /
help /
tex /
Spreadsheet_Files.tex
Revision
1.8:
download - view:
text,
annotated -
select for diffs
Thu Dec 29 02:12:15 2016 UTC (7 years, 7 months ago) by
lira
Branches:
MAIN
CVS tags:
version_2_12_X,
version_2_11_X,
version_2_11_5_msu,
version_2_11_5,
version_2_11_4_uiuc,
version_2_11_4_msu,
version_2_11_4,
version_2_11_3_uiuc,
version_2_11_3_msu,
version_2_11_3,
version_2_11_2_uiuc,
version_2_11_2_msu,
version_2_11_2_educog,
version_2_11_2,
HEAD
improving spreadsheet documentation
1: \label{Spreadsheet_Files}
2:
3: If you have permission to edit a spreadsheet you will also have permission to
4: save and load spreadsheet definition files.\\
5:
6: \noindent
7: \textbf{Default Spreadsheets}
8:
9: There are three default spreadsheets, one for each level. These are called
10: \texttt{default\_classcalc}, \texttt{default\_studentcalc}, and
11: \texttt{default\_assesscalc}. These are the starting spreadsheets for every class.\\
12:
13: \noindent
14: \textbf{Modified Spreadsheets}
15:
16: When you modify a spreadsheet you begin working with an temporary copy.
17: You may save the spreadsheet using the \fbox{Save as}
18: button on the spreadsheet. Fill in a name and click on the \fbox{Save as} button.
19: You may also use the \fbox{Save as \& Make This Sheet the Default} button
20: to set the current spreadsheet definition as the default for this level.\\
21:
22: \label{Spreadsheet_Loading}
23: \noindent
24: \textbf{Loading a Spreadsheet Definition from a Published File}
25:
26: Using the \underline{Select Spreadsheet File} link opens the LON-CAPA resource browser.
27: Only files with the extension \texttt{.spreadsheet} can be selected. The
28: spreadsheet definition file must be valid XML. See \textbf{Authoring Spreadsheet Files} (\ref{Spreadsheet_Authoring}) for information on
29: creating spreadsheet files.\\
30:
31: \noindent
32: \textbf{Setting the Assessment Level Spreadsheets used to Calculate Grades}
33:
34: In the student level spreadsheet every assessment in the course has a
35: spreadsheet definition file associated with it.
36: The spreadsheet definition used for each assessment row
37: is selected using a drop-down option selector in the \textbf{Assessments} column.
38: Initially this spreadsheet is ``Default'', meaning the current default
39: assessment spreadsheet will be used to compute the students grade. Also, a
40: dropdown option selector is provided to set the assessment spreadsheet for
41: each folder/sequence.
42:
43: Changing the spreadsheet used for an assessment modifies the student level
44: spreadsheet, so you must use the \fbox{Save as} button to save the current
45: student spreadsheet.\\
46:
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>