[prev in list] [next in list] [prev in thread] [next in thread] 

List:       lon-capa-cvs
Subject:    [LON-CAPA-cvs] cvs: loncom /html/adm/help/tex Spreadsheet_Category_Grades.tex
From:       lira <lira () source ! lon-capa ! org>
Date:       2015-12-28 4:07:36
Message-ID: cvslira1451275656 () cvsserver
[Download RAW message or body]

lira		Mon Dec 28 04:07:36 2015 EDT

  Modified files:              
    /loncom/html/adm/help/tex	Spreadsheet_Category_Grades.tex 
  Log:
  Add example formulas for two categories.
  
  
Index: loncom/html/adm/help/tex/Spreadsheet_Category_Grades.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Category_Grades.tex:1.1 \
                loncom/html/adm/help/tex/Spreadsheet_Category_Grades.tex:1.2
--- loncom/html/adm/help/tex/Spreadsheet_Category_Grades.tex:1.1	Sat Dec 26 04:36:54 \
                2015
+++ loncom/html/adm/help/tex/Spreadsheet_Category_Grades.tex	Mon Dec 28 04:07:35 2015
@@ -13,7 +13,7 @@
 a homework category, whereas columns P and Q can replicate these columns for a quiz \
category, etc.   
 To create a homework category assessment spreadsheet with this strategy, navigate \
                within
-the spreadsheet interface to any assessment. Modify the formula in \texttt{N0} to be \
\texttt{X0} (no quotes), and \texttt{O0} to be \texttt{Z0} (no quotes) and save the \
spreadsheet with a name such as homework\_assesscalc. See Spreadsheet Editing \
(\ref{Spreadsheet_Editing}). Repeat the procedure for each grade category, using \
different pairs of columns for each category and a different assessment spreadsheet \
name for each category. +the spreadsheet interface to any assessment. Modify the \
formula in \texttt{N0} to be \texttt{Z0} (no quotes) for awarded points, and \
\texttt{O0} to be \texttt{X0} (no quotes) for possible points and then save the \
spreadsheet with a name such as homework\_assesscalc. See Spreadsheet Editing \
(\ref{Spreadsheet_Editing}). Repeat the procedure for each grade category, using \
different pairs of columns for each category and a different assessment spreadsheet \
name for each category.  
 \noindent
 \textbf{Assigning the Assessment Level Spreadsheets and Calculating Student Grades}
@@ -27,7 +27,34 @@
 
 Next, edit row 0 to program the summations for the pairs of columns for each grade \
category. Remember that row 0 columns A-Z and a-z will be  available for student \
                viewing, so add appropriate text labels such that the calculations \
                are clear to the
-students. Remember that the cells are much more powerful that traditional \
spreadsheets, and the cells can contain multiple lines of Perl script. For example, \
to calculate homework scores and drop a certain number of points, if columns N and O \
contain the available and awarded points, each column can be totaled using \
\texttt{\&SUM(`N*')} and \texttt{\&SUM(`O*')} as well as logic statements and \
algebraic statements to apply the calculations. +students. Remember that the cells \
are much more powerful that traditional spreadsheets, and the cells can contain \
multiple lines of Perl script. For example, to calculate homework scores and drop a \
certain number of points, if columns N and O contain the awarded and available points \
respectively, each column can be totaled using \texttt{\&SUM(`N*')} and \
\texttt{\&SUM(`O*')} as well as logic statements and algebraic statements to apply \
the calculations. Note below how the script for homework score in column d gives \
students 50 `grace' points, but also adjusts for a maximum of 100\%. The quiz \
calculations in column h avoid an error of division by zero if no quiz scores are \
present. +
+\begin{verbatim}
+<field col=a row=0>
+`(b)Raw Homework Points:
+(c)Raw Homework Possible:
+(d)Scaled Homework Percentage:'
+</field>
+<field col=b row=0>&SUM('N*')</field>
+<field col=c row=0>&SUM('O*')</field>
+<field col=d row=0>
+$possible = c0;
+if($possible > 50) { 
+  $possible=c0-50;
+}
+$possible > 0 ? ($percent=b0/$possible*100) : ($percent=0);
+$percent >= 100 ? 100 : $percent;
+</field>
+<field col=e row=0>
+`(f)Raw Quiz Points:
+(g)Raw Quiz Possible:
+(h)Quiz Percentage:'</field>
+<field col=f row=0>&SUM('P*')</field>
+<field col=g row=0>&SUM('Q*')</field>
+<field col=h row=0>
+g0 > 0 ? (f0/g0*100) : 0;
+</field>
+\end{verbatim}
 
 Columns A-Z should contain the totals for each category and the calculated grade \
because only these columns will be exported to the course level sheet.   
@@ -39,5 +66,5 @@
 \noindent
 \textbf{Course Level Spreadsheet}
 
-After the student level sheet is created, the customized student columns A-Z will \
appear on the course level sheet. For that sheet, row 0 can be modified to perform \
and statistics that you would like to see as the instructor. For example, the row can \
be programmed to calculate the mean and standard deviation for a category. \textbf{Be \
sure to save any customized work as the default unless you need multiple course \
spreadsheets.} +After the student level sheet is created, the customized student \
columns A-Z will appear on the course level sheet. For that sheet, row 0 of the \
course level spreadsheet can be modified to perform and statistics that you would \
like to see as the instructor. For example, the row can be programmed to calculate \
the mean and standard deviation for a category. \textbf{Be sure to save any \
customized work as the default unless you need multiple course spreadsheets.}  


_______________________________________________
LON-CAPA-cvs mailing list
LON-CAPA-cvs@mail.lon-capa.org
http://mail.lon-capa.org/mailman/listinfo/lon-capa-cvs


[prev in list] [next in list] [prev in thread] [next in thread]