\label{Spreadsheet_Hierarchy}

There are three different types of spreadsheets inside LON-CAPA: Assessment Spreadsheets, Student Spreadsheet, and Course Spreadsheet.

\begin{enumerate}

\item \textbf{The Assessment Spreadsheets}

An assessment-level spreadsheet provides access to all of the parameters
associated with a student's performance on a particular homework assignment, quiz, 
or exam.
Each student has an assessment spreadsheet for every assessment in the course.
The assessment spreadsheets provide data to their parent, the student level
spreadsheet, via the \textbf{export row} (\ref{Spreadsheet_Export_Row}).

\item \textbf{The Student Spreadsheet}

The student level spreadsheet presents data to the students on their 
performance in the course.  
There is only one possible student level spreadsheet definition, 
but the data varies for each student.
The data present in the student spreadsheet is imported from the 
\textbf{export row} (\ref{Spreadsheet_Export_Row})
of each assessment spreadsheet for all of the assessments currently in 
the course.  
The student spreadsheets pass summary data to the course-level spreadsheet
via the \textbf{export row} (\ref{Spreadsheet_Export_Row}).

\item \textbf{The Course Spreadsheet}

The course spreadsheet contains all of the summary data for the students in
the course.   There is only one course spreadsheet.

\end{enumerate}