Return to Spreadsheet_Files.tex CVS log

Up to [LON-CAPA] / loncom / html / adm / help / tex

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.\\