Return to Spreadsheet_Levels.tex CVS log

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

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

1.2       bowersj2    1: \label{Spreadsheet_Levels}
1.5       riegler     2: 
1.7     ! raeburn     3: Each Student and Assessment level spreadsheets permit sophisticated calculations. The summary values that are to be passed to the parent spreadsheet are summarized in the \textbf{export row} of the sheet. The figure shows the spreadsheet hierarchy and indicates the flow of information. 
1.1       bowersj2    4: 
                      5: \begin{figure}
1.4       bowersj2    6: \begin{center}\includegraphics[  width=0.80\paperwidth]{spreadsheet_hierarchy}
                      7: \end{center}
1.5       riegler     8: \end{figure}
1.6       lira        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}). 
1.7     ! raeburn    39: Multiple assessment spreadsheets can be used in a course, facilitating organizing assessments into
1.6       lira       40: categories or for other purposes.
                     41: 
                     42: 
                     43: \end{enumerate}
                     44: 
                     45: 
                     46: