Return to Spreadsheet_Files.tex CVS log

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

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: