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:
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>