Annotation of loncom/html/adm/help/tex/Spreadsheet_Levels.tex, revision 1.6
1.2 bowersj2 1: \label{Spreadsheet_Levels}
1.5 riegler 2:
1.6 ! lira 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.
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}).
! 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:
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>