Mon, 22 Jul 2002 21:08:18 -0000

This is a MIME encoded message

--bowersj21027372098
Content-Type: text/plain

bowersj2		Mon Jul 22 17:08:18 2002 EDT

  Added files:                 
    /loncom/html/adm/help/tex	Spreadsheet_Alternative_View.tex 
                             	Spreadsheet_Changes_To_Grading.tex 
                             	Spreadsheet_Completely_Recalc.tex 
                             	Spreadsheet_Empty_Rows.tex 
                             	Spreadsheet_Export_Row.tex 
                             	Spreadsheet_Functions.tex 
                             	Spreadsheet_Import_Values.tex 
                             	Spreadsheet_Levels.tex 
                             	Spreadsheet_Max_Depth_Exceeded.tex 
                             	Spreadsheet_OOO_Rows.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 

  Modified files:              
    /loncom/html/adm/help/tex	Course_Problem_Weight.tex 
  Log:
  .tex file checkins for credit at meeting and review if anybody wants to.
  
  
  
--bowersj21027372098
Content-Type: text/plain
Content-Disposition: attachment; filename="bowersj2-20020722170818.txt"

Index: loncom/html/adm/help/tex/Course_Problem_Weight.tex
diff -u loncom/html/adm/help/tex/Course_Problem_Weight.tex:1.1 loncom/html/adm/help/tex/Course_Problem_Weight.tex:1.2

--- loncom/html/adm/help/tex/Course_Problem_Weight.tex:1.1	Mon Jul 22 12:49:42 2002
+++ loncom/html/adm/help/tex/Course_Problem_Weight.tex	Mon Jul 22 17:08:18 2002
@@ -1,19 +1,8 @@
--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.
-
-The default spreadsheet uses the ``weight'' parameter as the number of
-points a student will receive for completing a problem
-correctly. Custom spreadsheets can use many parameters to compute the
-points a student will receive, such as \emph(status} (completed, not
-solved, excused, etc.), \emph{partial credit}, \emph{number of tries},
-etc., or \textbf{weight} as just another parameter.
-
-Thus, for a given course, the true effect of the \textbf{weight}
-parameter can only be understood in the context of the spreadsheet the
-course is using to determine the number of points a student will
-receive for a given problem. (Using \textbf{weight} as part of the
-spreadsheet calculation can provide an easy way to manipulate how the
-problem distributes points without needing to edit the spreadsheet
-directly.) 
\ No newline at end of file
+The ``problem weight'' parameter is used to calculate the points of a
+problem.  The default spreadsheet uses the wieght as the points.  You
+may want to think of a problem's weight in comparison to other
+problems.  For example, all problems with a weight of 1 means that
+both easy and difficult problems are given the same weight.  If you
+choose to customize the spreadsheet, then the problem weight and
+points may not equal each other for your course.  The default weight
+of all problems and problem parts is 1.
\ No newline at end of file

Index: loncom/html/adm/help/tex/Spreadsheet_Alternative_View.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Alternative_View.tex
If you want an alternative spreadsheet view of the same data, save the
sheet without making it default. Then use "load" if you want to use
the sheet again.
Index: loncom/html/adm/help/tex/Spreadsheet_Changes_To_Grading.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Changes_To_Grading.tex
If you change the grading scheme in the spreadsheet, the student's
view of the problem will be unaffected (still show ``correct'' or
``incorrect''), as the problem view never shows how many points a
problem is worth. Their view of their own spreadsheet (which they
obtain through the \textbf{GRDS} button) will show the updated points
calculation. 
Index: loncom/html/adm/help/tex/Spreadsheet_Completely_Recalc.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Completely_Recalc.tex
The total number of sheets in course can be tremendous, since it is
the number of students times the number of assessments. LON-CAPA
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.

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
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_Empty_Rows.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Empty_Rows.tex
To avoid showing ``empty rows'' in the spreadsheet, you can check the
\textbf{Hide} box on the spreadsheet itself, or you can change the
default functionality in the \textbf{Course Environment}, available
through pushing the \textbf{PARM} button.

Index: loncom/html/adm/help/tex/Spreadsheet_Export_Row.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Export_Row.tex
In order to get data from the lower level spreadsheets to the higher
level spreadsheets (see \ref{Spreadsheet_Levels}), the data must be
exported from the lower-level spreadsheet.

The export row of assessment-level spreadsheets is what is exported to
the student-level sheet.

The export row of student-level spreadsheets is what is exported to
the course level sheet.

Only the columns labelled with uppercase letters will be exported. The
lowercase letters are available for additional calculations used only
on the current level of the spreadsheet.
Index: loncom/html/adm/help/tex/Spreadsheet_Functions.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Functions.tex
The following functions are available in the spreadsheet:

\begin{itemize}

\item \texttt{\&NUM(range)} - number of non-empty cells in range

\item \texttt{\&BIN(low, high, range)} - number of non-empty cells in
  range with values between low and high

\item \texttt{\&SUM(range)} - sum of the non-empty cells in range

\item \texttt{\&MEAN(range)} - mean value of non-empty cells in range

\item \texttt{\&STDDEV(range)} - standard deviation of non-empty cells
  in range 

\item \texttt{\&PROD(range)} - product of non-empty cells in range

\item \texttt{\&MAX(range)} - maximum value of non-empty cell in range

\item \texttt{\&MIN(range)} - minimum value of non-empty cells in
  range 

\item \texttt{\&SUMMAX(n ,range)} - sum of the maximum n non-empty
  cells in range

\item \texttt{\&SUMMIN(n, range)} - sum of the minimum n non-empty
  cells in range

\item \texttt{\&EXT(expression)} - access to EXT function in lonnet

\end{itemize}

In addition, non-IO Perl functions work in cells, which is internally
evaluated within a safe space. Field names and Column-Row combinations
can be used as variables.
Index: loncom/html/adm/help/tex/Spreadsheet_Import_Values.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Import_Values.tex
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
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
\ref{Spreadsheet_Completely_Recalc}). 
Index: loncom/html/adm/help/tex/Spreadsheet_Levels.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Levels.tex
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.

The figure shows the spreadsheet hierarchy. 

\begin{figure}
\includegraphics{spreadsheet_hierarchy}
\end{figure}
Index: loncom/html/adm/help/tex/Spreadsheet_Max_Depth_Exceeded.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Max_Depth_Exceeded.tex
The ``Maximum Calculation Depth Exceeded'' 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}

Try replacing \texttt{X0}'s contents with \texttt{[
(Some_complicated_expression) > 2]?1:0}. In other words, replace the
reference to \texttt{G0} with the actual contents of \texttt{G0}. That
might fix your error by removing one level of indirection that
LON-CAPA must process in order to compute the result.  
Index: loncom/html/adm/help/tex/Spreadsheet_OOO_Rows.tex
+++ loncom/html/adm/help/tex/Spreadsheet_OOO_Rows.tex
Once a sheet is saved, there is a one-to-one relationship between a
certain row and a specific student in the course-level sheet, and a
specific assessment in the student level sheet. Thus, specific cell
names like ``A5'' can be used in calculations. Changing class
enrollment or course content, respectively, after saving a sheet will
bring the row numbers ``out of order''.

Index: loncom/html/adm/help/tex/Spreadsheet_Op_On_All_Problem_Parts.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Op_On_All_Problem_Parts.tex
Often, there are several parts in a specific problem. For example, a
problem with three parts would have parts 0, 11, 12, and 13. For a
general spreadsheet, it is not often desirable to sum up all of these
parts, while not knowing how many parts there are as the spreadsheet
is written.

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)]}. 

For example, for the above assessment with three parts,

\texttt{[\&EXPANDSUM(\textbf{PART};parameter_\textbf{PART}_weight*stores_\textbf{PART}_awarded)]}

would become

\texttt{parameter_\textbf{0}_weight*stores_\textbf{0}_awarded +
parameter_\textbf{11}_weight*stores_\textbf{11}_awarded +
parameter_\textbf{12}_weight*stores_\textbf{12}_awarded +
parameter_\textbf{13}_weight*stores_\textbf{13}_awarded}

where \textbf{bolded text} is used to highlight what the
\texttt{\&EXPANDSUM} function is doing.
Index: loncom/html/adm/help/tex/Spreadsheet_Problem_Weight.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Problem_Weight.tex
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.

The default spreadsheet uses the ``weight'' parameter as the number of
points a student will receive for completing a problem
correctly. Custom spreadsheets can use many parameters to compute the
points a student will receive, such as \emph{status} (completed, not
solved, excused, etc.), \emph{partial credit}, \emph{number of tries},
etc., or \textbf{weight} as just another parameter.

Thus, for a given course, the true effect of the \textbf{weight}
parameter can only be understood in the context of the spreadsheet the
course is using to determine the number of points a student will
receive for a given problem. (Using \textbf{weight} as part of the
spreadsheet calculation can provide an easy way to manipulate how the
problem distributes points without needing to edit the spreadsheet
directly.) 
Index: loncom/html/adm/help/tex/Spreadsheet_Ranges.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Ranges.tex
Ranges specify rectangles of various shapes in the spreadsheet, just
as ranges do in traditional spreadsheets. Exmples of legitimate
ranges: 

\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

\end{itemize}

Many functions accept ranges. For example, \&SUM(``d*'') will add 
up all cells in column d.

Index: loncom/html/adm/help/tex/Spreadsheet_Specifying_Cells.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Specifying_Cells.tex
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).

There are also the wildcards '*' and '#' which are used in ranges (see
\ref{Spreadsheet_Ranges}), templates (see
\ref{Spreadsheet_Template_Row}), and symbolic names (see
\ref{Spreadsheet_Symbolic_Names}).
Index: loncom/html/adm/help/tex/Spreadsheet_Student_Visible.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Student_Visible.tex
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}. 

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
student level sheet, use the pulldown menu next to the particular
assessment. 
Index: loncom/html/adm/help/tex/Spreadsheet_Symbolic_Names.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Symbolic_Names.tex
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. 
Index: loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex
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.
Index: loncom/html/adm/help/tex/Spreadsheet_Ternary_Operator.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Ternary_Operator.tex
The ?'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')}

can be translated into:

\texttt{if (B2 > 16 ) \{ \\
  \hspace*{16pt}     \$temp = 'passing grade';\\
  \} else \{ \\
  \hspace*{16pt}     \$temp = 'failing grade'; \\
  \} \\
  \$temp;\\
}

The nicest part of the ( ? : ) operator (aside from its compactness)
is the way it automatically returns the value you want without having
to use any temporary variable.s
Index: loncom/html/adm/help/tex/Spreadsheet_Tries.tex
+++ loncom/html/adm/help/tex/Spreadsheet_Tries.tex
In multi-part questions, "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}.
--bowersj21027372098--


