Return to Spreadsheet_Levels.tex CVS log

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

improving spreadsheet documentation

    1: \label{Spreadsheet_Levels}
    2: 
    3: Each Student and Assessment level spreadsheets permit sophisticated calculations. The summary values that are to be passed to the parent spreadhseet are summarized in the \textbf{export row} of the sheet. The figure shows the spreadsheet hierarchy and indicates the flow of information. 
    4: 
    5: \begin{figure}
    6: \begin{center}\includegraphics[  width=0.80\paperwidth]{spreadsheet_hierarchy}
    7: \end{center}
    8: \end{figure}
    9: 
   10: \begin{enumerate}
   11: 
   12: \item \textbf{The Course Spreadsheet}
   13: 
   14: The course spreadsheet contains all of the summary data for all the students in
   15: the course.
   16: 
   17: \item \textbf{The Student Spreadsheet}
   18: 
   19: The student level spreadsheet summarizes the assessment spreadsheet data for the students.  
   20: There is only one default student level spreadsheet definition, 
   21: but the data varies for each student.
   22: The student spreadsheet is programmed to permit the instructor to assign different
   23: assessment spreadsheets for different grade categories or other uses.
   24: The data present in the student spreadsheet is imported from the 
   25: \textbf{export row} (\ref{Spreadsheet_Export_Row})
   26: of each assessment spreadsheet for all of the assessments currently in 
   27: the course.  
   28: The student spreadsheets pass summary data to the course-level spreadsheet
   29: via the student spreadsheet \textbf{export row} (\ref{Spreadsheet_Export_Row}).
   30: 
   31: \item \textbf{The Assessment Spreadsheets}
   32: 
   33: An assessment-level spreadsheet provides access to all of the parameters
   34: associated with a student's performance on a particular homework assignment, quiz, 
   35: or exam.
   36: Each student has an assessment spreadsheet for every assessment in the course.
   37: The assessment spreadsheets provide data to their parent, the student level
   38: spreadsheet, via the assessment spreadsheet \textbf{export row} (\ref{Spreadsheet_Export_Row}). 
   39: Multiple assessment spreadsheets can be used in a course facilitating organizing assessments into
   40: categories or for other purposes.
   41: 
   42: 
   43: \end{enumerate}
   44: 
   45: 
   46: