[LON-CAPA-cvs] cvs: doc /help course.manual.texxml loncom/html/adm/help/tex Authoring_Spreadsheet.tex Spreadsheet_About.tex Spreadsheet_Cell_Editing.tex Spreadsheet_Export_Row.tex Spreadsheet_Files.tex Spreadsheet_Functions.tex Spreadsheet_HowTo.tex Spreadsheet_HowTo_Assessments.tex Spreadsheet_Layout.tex Spreadsheet_Levels.tex Spreadsheet_Parms.tex Spreadsheet_Referencing_Cells.tex Spreadsheet_Referencing_Parameters.tex Spreadsheet_Row_Numbers.tex Spreadsheet_Template_Row.tex

riegler riegler@source.lon-capa.org
Mon, 23 Aug 2010 16:16:22 -0000


This is a MIME encoded message

--riegler1282580182
Content-Type: text/plain

riegler		Mon Aug 23 16:16:22 2010 EDT

  Modified files:              
    /loncom/html/adm/help/tex	Spreadsheet_Referencing_Parameters.tex 
                             	Spreadsheet_Referencing_Cells.tex 
                             	Spreadsheet_Cell_Editing.tex 
                             	Spreadsheet_Files.tex 
                             	Spreadsheet_Row_Numbers.tex 
                             	Authoring_Spreadsheet.tex 
                             	Spreadsheet_Layout.tex 
                             	Spreadsheet_Template_Row.tex 
                             	Spreadsheet_Export_Row.tex 
                             	Spreadsheet_Levels.tex 
                             	Spreadsheet_About.tex 
                             	Spreadsheet_HowTo_Assessments.tex 
                             	Spreadsheet_HowTo.tex 
                             	Spreadsheet_Functions.tex 
                             	Spreadsheet_Parms.tex 
    /doc/help	course.manual.texxml 
  Log:
  
  Updating chapter 15 of cc manual.
  
  
--riegler1282580182
Content-Type: text/plain
Content-Disposition: attachment; filename="riegler-20100823161622.txt"

Index: loncom/html/adm/help/tex/Spreadsheet_Referencing_Parameters.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Referencing_Parameters.tex:1.5 loncom/html/adm/help/tex/Spreadsheet_Referencing_Parameters.tex:1.6
--- loncom/html/adm/help/tex/Spreadsheet_Referencing_Parameters.tex:1.5	Sat Aug 21 08:51:08 2010
+++ loncom/html/adm/help/tex/Spreadsheet_Referencing_Parameters.tex	Mon Aug 23 16:16:18 2010
@@ -3,13 +3,15 @@
 In the assessment-level spreadsheet, the parameters are available for
 calculation in three ways.
 
-1. Reference the cell containing the parameter: \texttt{A7}
+\begin{enumerate}
+\item Reference the cell containing the parameter: \texttt{'A7'}
 
-2. Reference the parameter by name: \texttt{[parameter\_0\_weight]}
+\item Reference the parameter by name: \texttt{'[parameter\_0\_weight]'}
 
 In each of these two cases, the value of the parameter will replace the
 reference before the Perl code in the cell is executed.
 
-3. Use the \texttt{\&PARM()} function, this will get run as part of the perl
+\item Use the \texttt{&PARM()} function, this will get run as part of the perl
    code evaluation.
+\end{enumerate}
 
Index: loncom/html/adm/help/tex/Spreadsheet_Referencing_Cells.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Referencing_Cells.tex:1.4 loncom/html/adm/help/tex/Spreadsheet_Referencing_Cells.tex:1.5
--- loncom/html/adm/help/tex/Spreadsheet_Referencing_Cells.tex:1.4	Tue Aug  8 17:47:27 2006
+++ loncom/html/adm/help/tex/Spreadsheet_Referencing_Cells.tex	Mon Aug 23 16:16:18 2010
@@ -2,9 +2,11 @@
 
 \textbf{Cells}
 
-Cells may be specified by simply writing their name.  \texttt{A17} will be
-replaced with the value in row A column 17 before the Perl is evaluated.
+Cells may be specified by simply writing their name enclosed in either single quotes or double quotes. 
+For instance, \texttt{'A17'} and \texttt{"A17"} will be
+replaced with the value in row $A$ column 17 before the Perl command is evaluated.
 
+\noindent
 \textbf{Ranges}
 
 Ranges \index{ranges, spreadsheet} specify rectangles of various shapes
@@ -13,21 +15,21 @@
 
 \begin{itemize}
 
-\item \textbf{``*''} - all rows, all columns 
-\item \textbf{``B*''} - all rows in column B 
-\item \textbf{``*5''} - all columns in row 5 
-\item \textbf{``C5''..``F25''} - all cells in the rectangle between C5 and F25
+\item \texttt{'*'} - all rows, all columns 
+\item \texttt{'B*'} - all rows in column B 
+\item \texttt{'*5'} - all columns in row 5 
+\item \texttt{'C5'..'F25'} - all cells in the rectangle between C5 and F25
 
 \end{itemize}
 
-Many functions accept ranges. For example, \&SUM(``d*'') will add 
-up all cells in column d.
+Many functions accept ranges, see \ref{Spreadsheet_Functions}. For example, \texttt{\&SUM('d*')} will add up all cells in column $d$.
 
+\noindent
 \textbf{Special References}
 
 There is an additional means of referencing cells most used in the 
 \textbf{template row} (\ref{Spreadsheet_Template_Row}).  
-By using a ``\#'' in the place of a row number
+By using a '\#' in the place of a row number
 the spreadsheet will replace the \# with the current row number.  For example
-\texttt{B\#} will be replaced with the contents of cell B7 in the row 7 and
-the contents of B8 in row 8.
+\texttt{'B\#'} will be replaced with the contents of cell $B7$ in the row 7 and
+the contents of $B8$ in row 8.
Index: loncom/html/adm/help/tex/Spreadsheet_Cell_Editing.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Cell_Editing.tex:1.1 loncom/html/adm/help/tex/Spreadsheet_Cell_Editing.tex:1.2
--- loncom/html/adm/help/tex/Spreadsheet_Cell_Editing.tex:1.1	Fri Aug 29 21:08:40 2003
+++ loncom/html/adm/help/tex/Spreadsheet_Cell_Editing.tex	Mon Aug 23 16:16:18 2010
@@ -1,16 +1,17 @@
 \label{Spreadsheet_Cell_Editing}
 
-To edit a cell in the spreadsheet, move you mouse pointer over it until you 
+To edit a cell in the spreadsheet, move your mouse pointer over it until you 
 are able to follow a link.  Click on the link to open up an editing window.  
 The current contents of the cell will be shown and can be modified.  
-Pressing the ``Accept'' button will cause the spreadsheet to be updated with 
+Pressing the \fbox{Accept} button will cause the spreadsheet to be updated with 
 the new formula.  
 You will then be working with an unsaved modified copy of a spreadsheet.  
-See \textbf{Spreadsheet Files} \ref{Spreadsheet_Files} for information on 
+See Spreadsheet Files \ref{Spreadsheet_Files} for information on 
 loading and saving spreadsheets.
-Pressing the ``Discard Changes'' button will discard any changes you have
+Pressing the \fbox{Discard Changes} button will discard any changes you have
 made to the contents of the cell.
 
+\noindent
 \textbf{What goes in a cell}
 
 The cells of the spreadsheet contain a mixture of Perl commands and LON-CAPA
Index: loncom/html/adm/help/tex/Spreadsheet_Files.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Files.tex:1.4 loncom/html/adm/help/tex/Spreadsheet_Files.tex:1.5
--- loncom/html/adm/help/tex/Spreadsheet_Files.tex:1.4	Tue Aug  8 17:47:26 2006
+++ loncom/html/adm/help/tex/Spreadsheet_Files.tex	Mon Aug 23 16:16:18 2010
@@ -3,37 +3,41 @@
 If you have permission to edit a spreadsheet you will also have permission to
 save and load spreadsheet definition files.  
 
+\noindent
 \textbf{Default Spreadsheets}
 
 There are three default spreadsheets, one for each level.  These are called
 \texttt{default\_classcalc}, \texttt{default\_studentcalc}, and 
 \texttt{default\_assesscalc}.
-These are the starting spreadsheets for every class. 
 
+These are the starting spreadsheets for every class. 
+\noindent
 \textbf{Modified Spreadsheets}
 
 When you modify a spreadsheet you begin working with an temporary copy.  
-You may save the spreadsheet using the ``Save as'' 
-button on the spreadsheet.  Fill in a name and click on the ``Save as'' button.
-You may also use the ``Save as \& Make This Sheet the Default'' button
+You may save the spreadsheet using the \fbox{Save as} 
+button on the spreadsheet.  Fill in a name and click on the \fbox{Save as} button.
+You may also use the \fbox{Save as \& Make This Sheet the Default} button
 to set the current spreadsheet definition as the default for this level.
 
+\noindent
 \textbf{Loading a Spreadsheet Definition from a Published File}
 
-Using the ``Select Spreadsheet File'' link opens the LON-CAPA resource browser.
+Using the \underline{Select Spreadsheet File} link opens the LON-CAPA resource browser.
 Only files with the extension \texttt{spreadsheet} can be selected.  The
 spreadsheet definition file must be valid XML. (You must be author to create and publish a spreadsheet file \ref{Authoring_Spreadsheet}.)
 
+\noindent
 \textbf{Setting the Assessment Level Spreadsheets used to Calculate Grades}
 
 In the student level spreadsheet every assessment in the course has a 
 spreadsheet definition file associated with it.  
 The spreadsheet definition used for each assessment
-is selected using a drop-down dialog in the "assessments" row.
+is selected using a drop-down dialog in the \textbf{Assessments} row.
 Initially this spreadsheet is ``Default'', meaning the current default 
 assessment spreadsheet will be used to compute the students grade.
 
 Changing the spreadsheet used for an assessment modifies the student level 
-spreadsheet, so you must use the ``Save as'' button to save the current
+spreadsheet, so you must use the \textbf{Save as} button to save the current
 student spreadsheet.
 
Index: loncom/html/adm/help/tex/Spreadsheet_Row_Numbers.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Row_Numbers.tex:1.1 loncom/html/adm/help/tex/Spreadsheet_Row_Numbers.tex:1.2
--- loncom/html/adm/help/tex/Spreadsheet_Row_Numbers.tex:1.1	Fri Aug 29 21:08:40 2003
+++ loncom/html/adm/help/tex/Spreadsheet_Row_Numbers.tex	Mon Aug 23 16:16:18 2010
@@ -5,6 +5,7 @@
 The following sections describe the consequences
 of this and answer ``why are the rows of the spreadsheet out of order?''.
 
+\noindent
 \textbf{Assessment Spreadsheet}
 
 Every parameter associated with an assessment has a unique row in the
@@ -15,6 +16,7 @@
 of the assessments in the course, there are likely to be a large number of
 parameters available.
 
+\noindent
 \textbf{Student Spreadsheet}
 
 The student level spreadsheet displays information about each assessment
@@ -24,6 +26,7 @@
 Regardless of the row number, the assessment will appear in the proper place
 in the course structure.
 
+\noindent
 \textbf{Course Spreadsheet}
 
 The rows of the course spreadsheet are assigned to students as they are
Index: loncom/html/adm/help/tex/Authoring_Spreadsheet.tex
diff -u loncom/html/adm/help/tex/Authoring_Spreadsheet.tex:1.1 loncom/html/adm/help/tex/Authoring_Spreadsheet.tex:1.2
--- loncom/html/adm/help/tex/Authoring_Spreadsheet.tex:1.1	Tue Feb 14 19:02:29 2006
+++ loncom/html/adm/help/tex/Authoring_Spreadsheet.tex	Mon Aug 23 16:16:18 2010
@@ -1,7 +1,8 @@
 \label{Authoring_Spreadsheet}
 
-You can create a spreadsheet XML file to import into your course.  The file must be named with the extension .spreadsheet.  Example: 
-\begin{verbatim} <field col=A row=0>'Available Points:'</field>
+As an author you can create a spreadsheet XML file to import into your course.  The file must be named with the extension .spreadsheet.  Example: 
+\begin{verbatim} 
+<field col=A row=0>'Available Points:'</field>
 <field col=B row=0>&SUM('X*')</field>
 <field col=C row=0>'Awarded Points:'</field>
 <field col=D row=0>&SUM('Z*')</field> 
Index: loncom/html/adm/help/tex/Spreadsheet_Layout.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Layout.tex:1.1 loncom/html/adm/help/tex/Spreadsheet_Layout.tex:1.2
--- loncom/html/adm/help/tex/Spreadsheet_Layout.tex:1.1	Fri Aug 29 21:08:40 2003
+++ loncom/html/adm/help/tex/Spreadsheet_Layout.tex	Mon Aug 23 16:16:18 2010
@@ -1,34 +1,37 @@
 \label{Spreadsheet_Layout}
 
 This section describes the layout of each level of spreadsheet.  See the
-section on the \textbf{Spreadsheet Hierarchy} (\ref{Spreadsheet_Hierarchy}) 
+section on the Spreadsheet Hierarchy (\ref{Spreadsheet_Hierarchy}) 
 for a description of the types of spreadsheets and their data-flow 
 relationships.
 
 
+\noindent
 \textbf{General Characteristics} 
 
 Each spreadsheet has 52 columns and a variable number of rows.  
 The columns of the spreadsheets are labeled 'A-z'.
 The rows of the spreadsheets contain data appropriate to the spreadsheet as 
-described below.  The section \textbf{Spreadsheet Row Numbers} 
+described below.  The section Spreadsheet Row Numbers
 (\ref{Spreadsheet_Row_Numbers}) describes how row numbers are assigned.
 
+\noindent
 \textbf{Assessment Spreadsheet Layout}
 
 There are two special rows on the top of the assessment spreadsheet.
-The first is the \textbf{template row} (\ref{Spreadsheet_Template_Row}).
-The second row is the \textbf{export row} (\ref{Spreadsheet_Export_Row}).
+The first is the template row (\ref{Spreadsheet_Template_Row}).
+The second row is the export row (\ref{Spreadsheet_Export_Row}).
 
 The main body of the assessment spreadsheet contains the parameters associated
 with the assessment.  The parameter values appear in the ``A'' column of the
 spreadsheet and cannot be edited.  The remainder of the spreadsheet columns,
 labeled ``B-z'', can be edited and used for computations.
 
-See \textbf{Referencing Spreadsheet Parameters} 
+See Referencing Spreadsheet Parameters 
 (\ref{Spreadsheet_Referencing_Parameters}) for information
 on how to reference a parameter value in the spreadsheet.
 
+\noindent
 \textbf{Student Spreadsheet Layout}
 
 The student spreadsheet has both a 
@@ -41,6 +44,7 @@
 main body of the spreadsheet, ``A-Z'', are the export data from the assessments
 and cannot be edited.  The remaining columns, ``a-z'', can be edited.
 
+\noindent
 \textbf{Course Spreadsheet Layout}
 
 The course spreadsheet contains the data exported from each student level
@@ -52,3 +56,4 @@
 Each student spreadsheet exports one row to the course spreadsheet.  The
 first 26 columns, ``A-Z'', contain the student data and cannot be edited.  
 The remaining 26 columns ``a-z'', can be edited.
+
Index: loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex:1.7 loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex:1.8
--- loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex:1.7	Tue Aug  8 17:47:27 2006
+++ loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex	Mon Aug 23 16:16:18 2010
@@ -7,5 +7,5 @@
 If a cell in the spreadsheet already has a value, that value will be preserved.
 
 Using the ``\#'' notation to specify rows is recommended.  See 
-\textbf{Referencing Spreadsheet Cells} (\ref{Spreadsheet_Referencing_Cells}) 
+Referencing Spreadsheet Cells (\ref{Spreadsheet_Referencing_Cells}) 
 for more information.
Index: loncom/html/adm/help/tex/Spreadsheet_Export_Row.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Export_Row.tex:1.5 loncom/html/adm/help/tex/Spreadsheet_Export_Row.tex:1.6
--- loncom/html/adm/help/tex/Spreadsheet_Export_Row.tex:1.5	Fri Aug 29 21:08:40 2003
+++ loncom/html/adm/help/tex/Spreadsheet_Export_Row.tex	Mon Aug 23 16:16:18 2010
@@ -1,7 +1,7 @@
 \label{Spreadsheet_Export_Row}
 
 The export row determines what information is passed to the next higher
-spreadsheet in the \textbf{spreadsheet hierarchy} 
+spreadsheet in the spreadsheet hierarchy 
 (\ref{Spreadsheet_Hierarchy}).  
 The first 26 columns of the row, labeled ``A-Z'', are
 exported.  The remaining 26 columns, labeled ``a-z'', 
Index: loncom/html/adm/help/tex/Spreadsheet_Levels.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Levels.tex:1.4 loncom/html/adm/help/tex/Spreadsheet_Levels.tex:1.5
--- loncom/html/adm/help/tex/Spreadsheet_Levels.tex:1.4	Mon Jun  2 19:54:21 2003
+++ loncom/html/adm/help/tex/Spreadsheet_Levels.tex	Mon Aug 23 16:16:18 2010
@@ -1,15 +1,18 @@
 \label{Spreadsheet_Levels}
-The course spreadsheet has three 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
-import the export rows of all assessment level sheets.
+sheet that students get to see when they press 
+\includegraphics[width=0.03\paperwidth]{feedback} 
+\textbf{View current problem status and grading information}
+on Main Menu).
+These in turn import the export rows of all assessment level sheets.
 
 The figure shows the spreadsheet hierarchy. 
 
 \begin{figure}
 \begin{center}\includegraphics[  width=0.80\paperwidth]{spreadsheet_hierarchy}
 \end{center}
-\end{figure}
\ No newline at end of file
+\end{figure}
Index: loncom/html/adm/help/tex/Spreadsheet_About.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_About.tex:1.3 loncom/html/adm/help/tex/Spreadsheet_About.tex:1.4
--- loncom/html/adm/help/tex/Spreadsheet_About.tex:1.3	Tue May  3 17:51:19 2005
+++ loncom/html/adm/help/tex/Spreadsheet_About.tex	Mon Aug 23 16:16:18 2010
@@ -12,3 +12,8 @@
 For help creating and editing spreadsheets, see 
 \textbf{Spreadsheet Files} (\ref{Spreadsheet_Files}) and 
 \textbf{Spreadsheet Editing} (\ref{Spreadsheet_Editing}).
+
+To access the spreadsheet functionality select
+\includegraphics[width=0.03\paperwidth]{sprs} 
+\textbf{View calculated grades (Spreadsheet)}
+on the Main Menu.
Index: loncom/html/adm/help/tex/Spreadsheet_HowTo_Assessments.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_HowTo_Assessments.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_HowTo_Assessments.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_HowTo_Assessments.tex:1.2	Tue Aug  8 17:47:27 2006
+++ loncom/html/adm/help/tex/Spreadsheet_HowTo_Assessments.tex	Mon Aug 23 16:16:18 2010
@@ -14,18 +14,16 @@
 
 For example, for the above assessment with three parts,
 
-\texttt{\&EXPANDSUM(}\texttt{\textbf{PART}}\texttt{;parameter\_}\texttt{\textbf{PART}}\texttt{\_weight{*}stores\_}\texttt{\textbf{PART}}\texttt{\_awarded)}
-
+\texttt{\&EXPANDSUM(}\texttt{\textbf{PART}}\texttt{;parameter\_}\texttt{\textbf{PART}}\texttt{\_weight{*}stores\_}\texttt{\textbf{PART}}\texttt{\_awarded)}\\
 would become
-
 \texttt{parameter\_0\_weight{*}stores\_0\_awarded +}~\\
 \texttt{parameter\_11\_weight{*}stores\_11\_awarded +}~\\
 \texttt{parameter\_12\_weight{*}stores\_12\_awarded +}~\\
 \texttt{parameter\_13\_weight{*}stores\_13\_awarded +}~\\
-
 where \textbf{bolded text} is used to highlight what the
 \texttt{\&EXPANDSUM} function is doing.
 
+\noindent
 \textbf{What 'tries' means}
 
 In multi-part questions, the exported value for "tries"\index{tries} is now 
Index: loncom/html/adm/help/tex/Spreadsheet_HowTo.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_HowTo.tex:1.3 loncom/html/adm/help/tex/Spreadsheet_HowTo.tex:1.4
--- loncom/html/adm/help/tex/Spreadsheet_HowTo.tex:1.3	Tue Aug  8 17:47:27 2006
+++ loncom/html/adm/help/tex/Spreadsheet_HowTo.tex	Mon Aug 23 16:16:18 2010
@@ -4,14 +4,16 @@
 
 To take the sum of column ``M'', for example, use \texttt{\&SUM(``M*'')}\index{SUM}
 
+\noindent
 \textbf{Spreadsheet Lists}
+
 When you have a list of numbers in a cell, how it is displayed depends
 on how you separate the numbers and how Perl interprets the results.
 
-\textbf{35 45 12} will not generate any result because this is an
+\texttt{35 45 12} will not generate any result because this is an
 invalid Perl statement.
 
-\textbf{35,45,12} will have a result of 12 because Perl has a comma
+\texttt{35,45,12} will have a result of 12 because Perl has a comma
 operator similar to the comma operator\index{comma operator} in C.
 
 The comma operator is binary and returns the value on its right. Thus
Index: loncom/html/adm/help/tex/Spreadsheet_Functions.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Functions.tex:1.8 loncom/html/adm/help/tex/Spreadsheet_Functions.tex:1.9
--- loncom/html/adm/help/tex/Spreadsheet_Functions.tex:1.8	Tue Jan 23 01:48:37 2007
+++ loncom/html/adm/help/tex/Spreadsheet_Functions.tex	Mon Aug 23 16:16:18 2010
@@ -1,6 +1,6 @@
 \label{Spreadsheet_Functions}
 The following special functions are available in the spreadsheet.
-Please see \textbf{Referencing Cells} (\ref{Spreadsheet_Referencing_Cells})
+Please see Referencing Cells (\ref{Spreadsheet_Referencing_Cells})
 for information on specifying cells and ranges.
 
 \begin{itemize}
@@ -32,16 +32,16 @@
   range 
 \index{MIN}
 
-\item \texttt{\&SUMMAX(n ,range)} - sum of the maximum n non-empty
+\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
+\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.
-Use \&EXT(``system.time'') to retrieve the current time.
+Use \texttt{\&EXT('system.time')} to retrieve the current time.
 \index{EXT}
 
 \item \texttt{\&PARM(parameter)} - get the value of a specific parameter 
@@ -54,25 +54,25 @@
 
 \item \texttt{\&MAXPARM(expression)} -  get the value of a parameter that 
 matches the expression that is the largest in value (If one specified 
-'opendata' it would return the largest opendate set on the problem.)
+'opendate' it would return the largest opendate set on the problem.)
 \index{MAXPARM}
 
 \item \texttt{\&SUMSEQ(column,sequence1,sequence2,sequence3,...)} -
 sum the given column across the folders or sequences listed.
 
 When specifying a sequence use the full title.  Instead of a sequence title
-the word ``all'' can be used to sum over all sequences.  Regular expressions
-can be entered as well, if prefixed by ``regexp:''.  See below for examples.
+the word \texttt{all} can be used to sum over all sequences.  Regular expressions
+can be entered as well, if prefixed by \texttt{regexp:}.  See below for examples.
 
 \begin{itemize}
 
-\item \texttt{\&SUMSEQ(``Z'',''Chapter 1'');}
+\item \texttt{\&SUMSEQ('Z','Chapter 1');}
 
-\item \texttt{\&SUMSEQ(``Z'',''Chapter 1'',''Chapter 2'',''Chapter 3'');}
+\item \texttt{\&SUMSEQ('Z','Chapter 1','Chapter 2','Chapter 3');}
 
-\item \texttt{\&SUMSEQ(``Z'',''all'');} - sum over all sequences.
+\item \texttt{\&SUMSEQ('Z','all');} - sum over all sequences.
 
-\item \texttt{\&SUMSEQ(``Z'',''regexp:Large Biomolecules'');} -
+\item \texttt{\&SUMSEQ('Z','regexp:Large Biomolecules');} -
  sum over all sequences which match the regular expression 
 /Large Biomolecules/.
 
Index: loncom/html/adm/help/tex/Spreadsheet_Parms.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Parms.tex:1.2 loncom/html/adm/help/tex/Spreadsheet_Parms.tex:1.3
--- loncom/html/adm/help/tex/Spreadsheet_Parms.tex:1.2	Mon Aug 23 11:37:23 2010
+++ loncom/html/adm/help/tex/Spreadsheet_Parms.tex	Mon Aug 23 16:16:18 2010
@@ -1,9 +1,8 @@
 \label{Spreadsheet_Parms}
-If you set a course parameter \ref{Course_Setting_Parameters},
-you can access this parameter in the spreadsheet
-\index{spreadsheet, course parameter in}. To access the
-parameter 'testparm' use 
 
+If you set a course parameter (see \ref{Course_Setting_Parameters}),
+you can access this parameter in the 
+spreadsheet\index{spreadsheet, course parameter in}. To access the
+parameter 'testparm' use
 \texttt{\&EXT('course.testparm')}\index{EXT}
-
 in a cell of your spreadsheet. 
Index: doc/help/course.manual.texxml
diff -u doc/help/course.manual.texxml:1.31 doc/help/course.manual.texxml:1.32
--- doc/help/course.manual.texxml:1.31	Mon Aug 23 11:37:29 2010
+++ doc/help/course.manual.texxml	Mon Aug 23 16:16:22 2010
@@ -352,6 +352,12 @@
 		<subsubsection name="Template Row">
        	               	<file name="Spreadsheet_Template_Row.tex" />
 			</subsubsection>	
+		<subsubsection name="Row Numbers">
+       	               	<file name="Spreadsheet_Row_Numbers.tex" />
+			</subsubsection>	
+		<subsubsection name="Spreadsheet Files">
+       	               	<file name="Authoring_Spreadsheet.tex" />
+			</subsubsection>	
 		</subsection>
 	<subsection name="Modifying the Spreadsheet">
                	<file name="Spreadsheet_Files.tex" />

--riegler1282580182--