Mon, 29 Jul 2002 14:51:43 -0000

This is a MIME encoded message

--bowersj21027954303
Content-Type: text/plain

bowersj2		Mon Jul 29 10:51:43 2002 EDT

  Added files:                 
    /doc/help	spreadsheet.manual.texxml 

  Modified files:              
    /doc/help	author.manual.texxml 
    /loncom/html/adm/help/tex	Spreadsheet_Completely_Recalc.tex 
                             	Spreadsheet_Export_Row.tex 
                             	Spreadsheet_Functions.tex 
                             	Spreadsheet_Import_Values.tex 
                             	Spreadsheet_Levels.tex 
                             	Spreadsheet_Max_Depth_Exceeded.tex 
                             	Spreadsheet_Op_On_All_Problem_Parts.tex 
                             	Spreadsheet_Problem_Weight.tex 
                             	Spreadsheet_Ranges.tex 
                             	Spreadsheet_Specifying_Cells.tex 
                             	Spreadsheet_Student_Visible.tex 
                             	Spreadsheet_Symbolic_Names.tex 
                             	Spreadsheet_Template_Row.tex 
                             	Spreadsheet_Ternary_Operator.tex 
                             	Spreadsheet_Tries.tex 
  Log:
  Added index tags, fixed irrelevant bug in author.manual.texxml, created
  spreadsheet.manual.texxml .
  
  
  
  
--bowersj21027954303
Content-Type: text/plain
Content-Disposition: attachment; filename="bowersj2-20020729105143.txt"

Index: doc/help/author.manual.texxml
diff -u doc/help/author.manual.texxml:1.2 doc/help/author.manual.texxml:1.3

--- doc/help/author.manual.texxml:1.2	Wed Jul 17 14:23:45 2002
+++ doc/help/author.manual.texxml	Mon Jul 29 10:51:43 2002
@@ -1,5 +1,4 @@
 <texxml>
-Author_Manual_Title_Page
 	<file name="Author_Manual_Title_Page.tex"/>
 	
 	<section name="Introduction to LON-CAPA">
Index: loncom/html/adm/help/tex/Spreadsheet_Completely_Recalc.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Completely_Recalc.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Completely_Recalc.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Completely_Recalc.tex:1.2	Fri Jul 26 15:53:59 2002
+++ loncom/html/adm/help/tex/Spreadsheet_Completely_Recalc.tex	Mon Jul 29 10:51:43 2002
@@ -4,11 +4,12 @@
 caches these sheets and only selectively invalidates those cache
 copies if potentially relevant data changes. \textbf{Completely
 Recalc} forces LON-CAPA to invalidate all cache copies.
+\index{Completely Recalc}
 
 For instance, this is necessary to get the most up-to-date
 calculations if the sheet itself contains direct access to the system
 clock (making it ``out-of-date'' the moment it is calculated), or if
 an assessment is edited in a way that would retroactively change
-grading. The automatic spreadsheet invalidation catches student
+grading. The automatic spreadsheet devalidation catches student
 submissions, \textbf{PAR}a\textbf{M}eter changes, and spreadsheet
 changes, but not re-publication of a problem resource.  
Index: loncom/html/adm/help/tex/Spreadsheet_Export_Row.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Export_Row.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Export_Row.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Export_Row.tex:1.2	Fri Jul 26 15:53:59 2002
+++ loncom/html/adm/help/tex/Spreadsheet_Export_Row.tex	Mon Jul 29 10:51:43 2002
@@ -4,7 +4,7 @@
 exported from the lower-level spreadsheet.
 
 The export row of assessment-level spreadsheets is what is exported to
-the student-level sheet.
+the student-level sheet.\index{export row}
 
 The export row of student-level spreadsheets is what is exported to
 the course level sheet.
Index: loncom/html/adm/help/tex/Spreadsheet_Functions.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Functions.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Functions.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Functions.tex:1.2	Fri Jul 26 15:53:59 2002
+++ loncom/html/adm/help/tex/Spreadsheet_Functions.tex	Mon Jul 29 10:51:43 2002
@@ -4,31 +4,42 @@
 \begin{itemize}
 
 \item \texttt{\&NUM(range)} - number of non-empty cells in range
+\index{NUM}
 
 \item \texttt{\&BIN(low, high, range)} - number of non-empty cells in
   range with values between low and high
+\index{BIN}
 
 \item \texttt{\&SUM(range)} - sum of the non-empty cells in range
+\index{SUM}
 
 \item \texttt{\&MEAN(range)} - mean value of non-empty cells in range
+\index{MEAN}
 
 \item \texttt{\&STDDEV(range)} - standard deviation of non-empty cells
   in range 
+\index{STDDEV}
 
 \item \texttt{\&PROD(range)} - product of non-empty cells in range
+\index{PROD}
 
 \item \texttt{\&MAX(range)} - maximum value of non-empty cell in range
+\index{MAX}
 
 \item \texttt{\&MIN(range)} - minimum value of non-empty cells in
   range 
+\index{MIN}
 
 \item \texttt{\&SUMMAX(n ,range)} - sum of the maximum n non-empty
   cells in range
+\index{SUMMAX}
 
 \item \texttt{\&SUMMIN(n, range)} - sum of the minimum n non-empty
   cells in range
+\index{SUMMIN}
 
 \item \texttt{\&EXT(expression)} - access to EXT function in lonnet
+\index{EXT}
 
 \end{itemize}
 
Index: loncom/html/adm/help/tex/Spreadsheet_Import_Values.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Import_Values.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Import_Values.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Import_Values.tex:1.2	Fri Jul 26 15:53:59 2002
+++ loncom/html/adm/help/tex/Spreadsheet_Import_Values.tex	Mon Jul 29 10:51:43 2002
@@ -1,7 +1,8 @@
 \label{Spreadsheet_Import_Values}
 The spreadsheet determines which data it imports from the metadata of
 the resource. Additional imported values can be used in formulas
-through the same \&EXT (external) function that is also available in
+through the same \&EXT (external)\index{EXT} 
+function that is also available in
 assessments. For example, \&EXT("system.time") imports the system
 time. (Note that in this particular example, the explicit time
 dependence is not recognized by the caching mechanism (see also
Index: loncom/html/adm/help/tex/Spreadsheet_Levels.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Levels.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Levels.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Levels.tex:1.2	Fri Jul 26 15:53:59 2002
+++ loncom/html/adm/help/tex/Spreadsheet_Levels.tex	Mon Jul 29 10:51:43 2002
@@ -1,4 +1,7 @@
 \label{Spreadsheet_Levels}
+The course spreadsheet has three levels.
+
+\index{course level spreadsheet}
 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 "GRDS"). These in turn
Index: loncom/html/adm/help/tex/Spreadsheet_Max_Depth_Exceeded.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Max_Depth_Exceeded.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Max_Depth_Exceeded.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Max_Depth_Exceeded.tex:1.2	Fri Jul 26 15:53:59 2002
+++ loncom/html/adm/help/tex/Spreadsheet_Max_Depth_Exceeded.tex	Mon Jul 29 10:51:43 2002
@@ -1,6 +1,7 @@
 \label{Spreadsheet_Max_Depth_Exceeded}
-The ``Maximum Calculation Depth Exceeded'' erro can occur when you
-reference other cells in calculations. For example, if you have: 
+The ``Maximum Calculation Depth Exceeded''\index{Maximum Calculation
+Depth Exceeded error} erro can occur when you reference other cells in
+calculations. For example, if you have: 
 
 \texttt{G0 = Some_complicated_expression\\
  X0 = G0>2?1:0}
Index: loncom/html/adm/help/tex/Spreadsheet_Op_On_All_Problem_Parts.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Op_On_All_Problem_Parts.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Op_On_All_Problem_Parts.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Op_On_All_Problem_Parts.tex:1.2	Fri Jul 26 15:53:59 2002
+++ loncom/html/adm/help/tex/Spreadsheet_Op_On_All_Problem_Parts.tex	Mon Jul 29 10:51:43 2002
@@ -7,7 +7,7 @@
 
 The spreadsheet has a preprocessor which an expand a symbolic
 expression over all symbolic names that fit. The general syntax is
-\texttt{[\&EXPANDSUM(VARNAME;expression)]}. 
+\index{EXPANDSUM} \texttt{[\&EXPANDSUM(VARNAME;expression)]}. 
 
 For example, for the above assessment with three parts,
 
Index: loncom/html/adm/help/tex/Spreadsheet_Problem_Weight.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Problem_Weight.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Problem_Weight.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Problem_Weight.tex:1.2	Fri Jul 26 15:53:59 2002
+++ loncom/html/adm/help/tex/Spreadsheet_Problem_Weight.tex	Mon Jul 29 10:51:43 2002
@@ -1,8 +1,9 @@
 \label{Spreadsheet_Problem_Weight}
-Problem weight is set on the \textbf{Parm} screen. The
-\textbf{weight} of the problem is a parameter that is attached to the
-problem that \emph{can} be used by the spreadsheet to calculate the
-points a student will receive for a problem.
+Problem weight\index{problem weight}\index{weight, problem} is set on
+the \textbf{Parm} screen. The \textbf{weight} of the problem is a
+parameter that is attached to the problem that \emph{can} be used by
+the spreadsheet to calculate the points a student will receive for a
+problem.
 
 The default spreadsheet uses the ``weight'' parameter as the number of
 points a student will receive for completing a problem
Index: loncom/html/adm/help/tex/Spreadsheet_Ranges.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Ranges.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Ranges.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Ranges.tex:1.2	Fri Jul 26 15:53:59 2002
+++ loncom/html/adm/help/tex/Spreadsheet_Ranges.tex	Mon Jul 29 10:51:43 2002
@@ -1,7 +1,7 @@
 \label{Spreadsheet_Ranges}
-Ranges specify rectangles of various shapes in the spreadsheet, just
-as ranges do in traditional spreadsheets. Exmples of legitimate
-ranges: 
+Ranges\index{ranges, spreadsheet} specify rectangles of various shapes
+in the spreadsheet, just as ranges do in traditional
+spreadsheets. Exmples of legitimate ranges: 
 
 \begin{itemize}
 
Index: loncom/html/adm/help/tex/Spreadsheet_Specifying_Cells.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Specifying_Cells.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Specifying_Cells.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Specifying_Cells.tex:1.2	Fri Jul 26 15:53:59 2002
+++ loncom/html/adm/help/tex/Spreadsheet_Specifying_Cells.tex	Mon Jul 29 10:51:43 2002
@@ -1,7 +1,8 @@
 \label{Spreadsheet_Specifying_Cells}
-Cells are specified by the letter-number combination of their position
-in the table, for example ``A5''. Note that the columns are labelled
-``A-Z'' and then to the right of that ``a-z'' (lowercase).
+Cells\index{cells, specifying} are specified by the letter-number
+combination of their position in the table, for example ``A5''. Note
+that the columns are labelled ``A-Z'' and then to the right of that
+``a-z'' (lowercase).
 
 There are also the wildcards '*' and '#' which are used in ranges (see
 \ref{Spreadsheet_Ranges}), templates (see
Index: loncom/html/adm/help/tex/Spreadsheet_Student_Visible.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Student_Visible.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Student_Visible.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Student_Visible.tex:1.2	Fri Jul 26 15:53:59 2002
+++ loncom/html/adm/help/tex/Spreadsheet_Student_Visible.tex	Mon Jul 29 10:51:43 2002
@@ -1,7 +1,7 @@
 \label{Spreadsheet_Student_Visible}
 To change the spreadsheet sheet that students see, use \textbf{Save
-As...}  on the level sheet that you want to change, and check the box
-\textbf{make default}. 
+As...}  on the level of spreadsheet that you want to change, and check
+the box \textbf{Make Default}. 
 
 If you only want to change the sheet for specific assessments, save
 the assessment level sheet and do not make it default. Instead, on the
Index: loncom/html/adm/help/tex/Spreadsheet_Symbolic_Names.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Symbolic_Names.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Symbolic_Names.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Symbolic_Names.tex:1.2	Fri Jul 26 15:53:59 2002
+++ loncom/html/adm/help/tex/Spreadsheet_Symbolic_Names.tex	Mon Jul 29 10:51:43 2002
@@ -1,5 +1,5 @@
 \label{Spreadsheet_Symbolic_Names}
 In the assessment level spreadsheet, most imported values also have
-symbolic name attached to them, for example parameter_0_weight. You
-can refer to the imported value by adding square brackets around its
-name, for example [parameter_0_weight]*A5. 
\ No newline at end of file
+symbolic name\index{symbolic names} attached to them, for example
+parameter_0_weight. You can refer to the imported value by adding
+square brackets around its name, for example [parameter_0_weight]*A5. 
\ No newline at end of file
Index: loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex:1.2	Fri Jul 26 15:53:59 2002
+++ loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex	Mon Jul 29 10:51:43 2002
@@ -1,4 +1,4 @@
 \label{Spreadsheet_Template_Row}
-The template row is a way to use the same formula in every row of a
-sheet. The actual row number is replaced by a ``#''. For example,
-``A#*b#'' would be ``A5*b5'' in row 5.
\ No newline at end of file
+The template row\index{template row} is a way to use the same formula
+in every row of a sheet. The actual row number is replaced by a
+``#''. For example, ``A#*b#'' would be ``A5*b5'' in row 5.
\ No newline at end of file
Index: loncom/html/adm/help/tex/Spreadsheet_Ternary_Operator.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Ternary_Operator.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Ternary_Operator.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Ternary_Operator.tex:1.2	Fri Jul 26 15:53:59 2002
+++ loncom/html/adm/help/tex/Spreadsheet_Ternary_Operator.tex	Mon Jul 29 10:51:43 2002
@@ -1,5 +1,6 @@
 \label{Spreadsheet_Ternary_Operator}
-The ?'s and :'s seen in the spreadsheet cells are part of compact notation for an if-then-else clause. Something like:
+The ?\index{? :}'s and :'s seen in the spreadsheet cells are part of
+compact notation for an if-then-else clause. Something like:
 
 \texttt{( B2 > 16 ? 'passing grade' : 'failing grade')}
 
Index: loncom/html/adm/help/tex/Spreadsheet_Tries.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Tries.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Tries.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Tries.tex:1.2	Fri Jul 26 15:53:59 2002
+++ loncom/html/adm/help/tex/Spreadsheet_Tries.tex	Mon Jul 29 10:51:43 2002
@@ -1,5 +1,5 @@
 \label{Spreadsheet_Tries}
-In multi-part questions, "tries" is now the average number of tries to
+In multi-part questions, "tries"\index{tries} is now the average number of tries to
 get the parts right. The full data for each part is still stored by
 the system. To expand the data and work with all parts, please see
 \ref{Spreadsheet_Op_On_All_Problem_Parts}.

Index: doc/help/spreadsheet.manual.texxml
+++ doc/help/spreadsheet.manual.texxml
<texxml>
	<file name="Spreadsheet_Manual_Title_Page.tex" />

	<section name="Introduction to the Spreadsheet">
		<file name="Spreadsheet_About.tex"/>
		<subsection name="Spreadsheet Organization">
			<file name="Spreadsheet_Levels.tex" />
			<file name="Spreadsheet_Export_Row.tex" />
			<file name="Spreadsheet_Template_Row.tex" />
			</subsection>
		</section>

	<section name="Using the Spreadsheet">
		<subsection name="How the Spreadsheet Works">
			<tex content="(This section is particularly haphazard and could use a well-written overview."/>
			<file name="Spreadsheet_Import_Values.tex" />
			<file name="Spreadsheet_Symbolic_Names.tex" />
			<file name="Spreadsheet_Problem_Weight.tex" />
			<file name="Spreadsheet_Parms.tex" />
			</subsection>
		<subsection name="Recalculating the Spreadsheet">
			<file name="Spreadsheet_Completely_Recalc.tex" />
			</subsection>
		<subsection name="Specifying Cells">
			<file name="Spreadsheet_Specifying_Cells.tex" />
			<file name="Spreadsheet_Ranges.tex" />
			</subsection>
		<subsection name="Using Cells">
			<subsubsection name="Lists">
				<file name="Spreadsheet_Lists.tex" />
				</subsubsection>
			</subsection>
		<subsection name="Available Functions">
			<file name="Spreadsheet_Functions.tex" />
			<file name="Spreadsheet_Col_Sum.tex" />
			<subsubsection name="? :">
				<file name="Spreadsheet_Ternary_Operator.tex" />
				</subsubsection>
			</subsection>
		<subsection name="Handling Multi-part Problems">
			<file name="Spreadsheet_Op_On_All_Problem_Parts.tex" />
			<file name="Spreadsheet_Tries.tex" />
			</subsection>
		</section>

	<section name="Troubleshooting and Tips">
		<subsection name="Common Error Messages">
			<subsubsection name="Max Depth Exceeded">
				<file name="Spreadsheet_Max_Depth_Exceeded.tex" />
				</subsubsection>
			<subsubsection name="
			</subsection>

		<subsection name="Common Problems">
			<subsubsection name="Empty Rows Showing">
				<file name="Spreadsheet_Empty_Rows.tex" />
				</subsubsection>
			<subsubsection name="Out-of-Order Rows">
				<file name="Spreadsheet_OOO_Rows.tex" />
				</subsubsection>
			<subsubsection name="Changes to Grading Scheme">
				<file name="Spreadsheet_Changes_To_Grading.tex" />
				</subsubsection>
			</subsection>

		<subsection name="Tips">
			<subsubsection name="Alternate View">
				<file name="Spreadsheet_Alternative_View.tex" />
				</subsubsection>
			<subsubsection name="Changing Student Spreadsheets">
				<file name="Spreadsheet_Student_Visible.tex" />
				</subsubsection>
		</section>
	</texxml>

--bowersj21027954303--


