lira lira at source.lon-capa.org
Wed Dec 28 21:12:16 EST 2016

lira		Thu Dec 29 02:12:16 2016 EDT

Removed files:

Modified files:
/doc/help	course.manual.texxml
Log:

-------------- next part --------------
Index: doc/help/course.manual.texxml
diff -u doc/help/course.manual.texxml:1.47 doc/help/course.manual.texxml:1.48
--- doc/help/course.manual.texxml:1.47	Sun Jan  3 05:09:13 2016
+++ doc/help/course.manual.texxml	Thu Dec 29 02:12:12 2016
@@ -418,16 +418,14 @@
<subsection name="Student View">
</subsection>
+		<subsubsection name="The Three Spreadsheet Levels">
</subsubsection>
<subsubsection name="Layout">
</subsubsection>
-		<subsubsection name="The Three Spreadsheet Levels">
-			</subsubsection>
<subsubsection name="Export Row">
</subsubsection>
@@ -438,7 +436,7 @@
</subsubsection>
</subsubsection>
</subsection>
@@ -1,19 +1,22 @@

-your course.  It has the flexability to implement most grading schemes and
-it provides access to all the parameters associated with the homework and
+including partial credit for multiple trials, grading categories, use of maxiumum
+or minimum scores, etc. and the spreadsheet tools

+This section of the course manual is divided into three main subsections. The
+\textbf{Student View} section (\ref{Spreadsheet_Student_View}) describes what the students see.

-For help creating and editing spreadsheets, see
+describes information about the structure and function of the spreadsheet. A basic
+understanding of the hierarchy is necessary before creating and editing spreadsheets.

-To access the spreadsheet functionality select
+how to create and edit spreadsheets.
+
\includegraphics[width=0.03\paperwidth]{sprs}
@@ -1,7 +1,7 @@

-strategy involves configuring assessment level spreadsheets for each category, the student level spreadsheet, and the course spreadsheet.\\
+strategy involves configuring assessment level spreadsheets for each category, configuring the student level spreadsheet to assign the activities to categories add calculate the overall grade, and configuring the course spreadsheet to calculate overall category averages, etc.\\

\noindent
@@ -25,7 +25,7 @@

Only files with the extension \texttt{.spreadsheet} can be selected.  The

\noindent
@@ -82,7 +82,7 @@

\noindent
In addition, most non-IO Perl functions work in cells. Perl offers a compact \texttt{if} structure using the logic
-\texttt{TEST\char_EXPR?IF\char_TRUE\char_EXPR\char:IF\char_FALSE\char_EXPR;}. The \texttt{if} statements can be nested. For example, to scale the points awarded on the assessment spreadsheet (by default in \texttt{Z0}) with the number of tries (by default in \texttt{C0}), the adjusted score can be programmed in an empty cell in assessment spreadsheet row 0, where\\
+\texttt{TEST\char_EXPR?IF\char_TRUE\char_EXPR\char:IF\char_FALSE\char_EXPR;}. The \texttt{if} statements can be nested. Suppose that students are to receive full credit for a correct answer on the first attempt, 3/4 credit for a correct answer on two attempts, and half credit for a correct answer on more than two attempts. To scale the points awarded on the assessment spreadsheet (by default in \texttt{Z0}) with the number of tries (by default in \texttt{C0}), the adjusted score can be programmed in an empty export cell in the Assessment Spreadsheet row 0, as illustrated by the following example:\\

\noindent
\texttt{C0$>$2 ? (0.5*Z0) \char: (C0$>$1 ? (0.75*Z0) \char: Z0);}\\
@@ -1,37 +1,9 @@

+The Student Spreadsheet configures how the overall course grade is to be calculated. Each graded item can
+be configured using an Assessment Spreadsheet to specify how the problem parameters are to be evaluated.

-\begin{enumerate}

-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
-Multiple assessment spreadsheets can be used in cases where the instructor configures
-
-
-The student level spreadsheet summarizes the assessment spreadsheet data for the students.
-There is only one default student level spreadsheet definition,
-but the data varies for each student.
-The student spreadsheet is programmed to permit the instructor to assign different
-The data present in the student spreadsheet is imported from the
-of each assessment spreadsheet for all of the assessments currently in
-the course.
-
-
-The course spreadsheet contains all of the summary data for the students in
-the course.
-
-\end{enumerate}
@@ -1,18 +1,46 @@

-The course spreadsheet has three levels.
-The top-level is the "course level" sheet, which is not accessible to
-students. It lists the export rows of all "student level" sheets (the
-sheet that students get to see when they press
-\includegraphics[width=0.03\paperwidth]{feedback}
-\textbf{View current problem status and grading information}
-These in turn import the export rows of all assessment level sheets.
-
-The figure shows the spreadsheet hierarchy.
+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.

\begin{figure}
\end{center}
\end{figure}
+
+\begin{enumerate}
+
+
+The course spreadsheet contains all of the summary data for all the students in
+the course.
+
+
+The student level spreadsheet summarizes the assessment spreadsheet data for the students.
+There is only one default student level spreadsheet definition,
+but the data varies for each student.
+The student spreadsheet is programmed to permit the instructor to assign different
+The data present in the student spreadsheet is imported from the
+of each assessment spreadsheet for all of the assessments currently in
+the course.
+
+
+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
+Multiple assessment spreadsheets can be used in a course facilitating organizing assessments into
+categories or for other purposes.
+
+
+\end{enumerate}
+
+
+
@@ -1,13 +1,18 @@

-The student view of the spreadsheet is restricted to the student level
-spreadsheet in courses where the environment has been set to allow the student
+The student view of the spreadsheet is restricted to the student's personal data, calculated
+by the Student Spreadsheet. Students are only able to view their personal data in courses
+where the environment has been set to allow the student
-Students are not able to view the assessment level spreadsheets
+\includegraphics[width=0.03\paperwidth]{feedback}
+\textbf{View current problem status and grading information}.

If the course contains assessments which indicate the student should not
be able to view the results, as is the default for an exam, the row will appear
blacked out and the data will not be present.  Once the answer date has passed
for the resource, the row will be shown.
+
+Students cannot modify the spreadsheet in any way.
+Students are not able to view the Assessment Spreadsheets

<field col=B row=0>&SUM(X*')</field>
<field col=D row=0>&SUM(Z*')</field>