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, 8 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
\label{Spreadsheet_Files}
If you have permission to edit a spreadsheet you will also have permission to
save and load spreadsheet definition files.\\
\noindent
\textbf{Default Spreadsheets}
There are three default spreadsheets, one for each level. These are called
\texttt{default\_classcalc}, \texttt{default\_studentcalc}, and
\texttt{default\_assesscalc}. These are the starting spreadsheets for every class.\\
\noindent
\textbf{Modified Spreadsheets}
When you modify a spreadsheet you begin working with an temporary copy.
You may save the spreadsheet using the \fbox{Save as}
button on the spreadsheet. Fill in a name and click on the \fbox{Save as} button.
You may also use the \fbox{Save as \& Make This Sheet the Default} button
to set the current spreadsheet definition as the default for this level.\\
\label{Spreadsheet_Loading}
\noindent
\textbf{Loading a Spreadsheet Definition from a Published File}
Using the \underline{Select Spreadsheet File} link opens the LON-CAPA resource browser.
Only files with the extension \texttt{.spreadsheet} can be selected. The
spreadsheet definition file must be valid XML. See \textbf{Authoring Spreadsheet Files} (\ref{Spreadsheet_Authoring}) for information on
creating spreadsheet files.\\
\noindent
\textbf{Setting the Assessment Level Spreadsheets used to Calculate Grades}
In the student level spreadsheet every assessment in the course has a
spreadsheet definition file associated with it.
The spreadsheet definition used for each assessment row
is selected using a drop-down option selector in the \textbf{Assessments} column.
Initially this spreadsheet is ``Default'', meaning the current default
assessment spreadsheet will be used to compute the students grade. Also, a
dropdown option selector is provided to set the assessment spreadsheet for
each folder/sequence.
Changing the spreadsheet used for an assessment modifies the student level
spreadsheet, so you must use the \fbox{Save as} button to save the current
student spreadsheet.\\
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>