Return to Spreadsheet_Files.tex CVS log

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

Annotation of loncom/html/adm/help/tex/Spreadsheet_Files.tex, revision 1.7

1.1       matthew     1: \label{Spreadsheet_Files}
                      2: 
                      3: If you have permission to edit a spreadsheet you will also have permission to
1.6       lira        4: save and load spreadsheet definition files.\\
1.1       matthew     5: 
1.5       riegler     6: \noindent
1.1       matthew     7: \textbf{Default Spreadsheets}
                      8: 
                      9: There are three default spreadsheets, one for each level.  These are called
1.2       www        10: \texttt{default\_classcalc}, \texttt{default\_studentcalc}, and 
1.6       lira       11: \texttt{default\_assesscalc}. These are the starting spreadsheets for every class.\\
1.5       riegler    12: 
                     13: \noindent
1.1       matthew    14: \textbf{Modified Spreadsheets}
                     15: 
                     16: When you modify a spreadsheet you begin working with an temporary copy.  
1.5       riegler    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
1.6       lira       20: to set the current spreadsheet definition as the default for this level.\\
1.1       matthew    21: 
1.6       lira       22: \label{Spreadsheet_Loading}
1.5       riegler    23: \noindent
1.1       matthew    24: \textbf{Loading a Spreadsheet Definition from a Published File}
                     25: 
1.5       riegler    26: Using the \underline{Select Spreadsheet File} link opens the LON-CAPA resource browser.
1.6       lira       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{Authoring_Spreadsheet}) for information on
                     29: creating spreadsheet files.\\
1.1       matthew    30: 
1.5       riegler    31: \noindent
1.1       matthew    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.  
1.7     ! lira       36: The spreadsheet definition used for each assessment row
        !            37: is selected using a drop-down option selector in the \textbf{Assessments} column.
1.1       matthew    38: Initially this spreadsheet is ``Default'', meaning the current default 
1.7     ! lira       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.
1.1       matthew    42: 
                     43: Changing the spreadsheet used for an assessment modifies the student level 
1.6       lira       44: spreadsheet, so you must use the \fbox{Save as} button to save the current
                     45: student spreadsheet.\\
1.1       matthew    46: