Peter and Gerd-

Thanks for the suggestions.  Gerd's is a more elegant, one-line version of mine 
that handles the rounding correctly, where my original version simply chopped 
the following digits.  In computing a grade average, improperly handling the 
rounding in the fourth decimal place isn't a huge concern (to me at 
least---maybe to the student).

Peter's suggestion of "sprintf" also works nicely.  I used 

$x = some formula that computes an average;
sprintf  '%.3f', $x; 

Peter-

The spreadsheet is Lon-Capa's gradebook. Go to Main Menu->Grading and 
Statistics->View calculated grades (Spreadsheet).  

After using LC since 2008, and after much begging from students to post their 
grades, I decided to tackle the spreadsheet.  I was intimidated at first, and 
the documentation is a bit minimalist, but I've got it figured out.  Like 
everything else LC, there is a bit of a steep learning curve at first, but the 
results are well worth it.  The gradebook/spreadsheet works PERFECTLY,  and it 
is very flexible.  I've been able to incorporate all the offline grades and get 
students' grade averages computed correctly.


Rex Abert
Associate Professor of Mathematics
Tallahassee Community College
________________________________________
From: lon-capa-users-boun...@mail.lon-capa.org 
[lon-capa-users-boun...@mail.lon-capa.org] on behalf of Peter Dencker 
[denc...@math.uni-luebeck.de]
Sent: Monday, November 2, 2015 5:36 PM
To: Discussion list for LON-CAPA users
Subject: Re: [LON-CAPA-users] (no subject)

Hello.


There is the perl builtin  'sprintf '

Does

$y = sprintf  '%.3f', $z;

work?


(Could not test it. What is the 'spreadsheet'?)

Peter


On 11/02/2015 11:13 PM, Rex Abert wrote:
> Mark-
>
> I've tried that.  The function &roundto($x,$n) works fine in problem scripts, 
> but returns "undefined" in the spreadsheet.
>
> Rex Abert
> Associate Professor of Mathematics
> Tallahassee Community College
> ________________________________________
> From: lon-capa-users-boun...@mail.lon-capa.org 
> [lon-capa-users-boun...@mail.lon-capa.org] on behalf of Lucas, Mark 
> [luc...@ohio.edu]
> Sent: Monday, November 2, 2015 5:01 PM
> To: Discussion list for LON-CAPA users
> Subject: Re: [LON-CAPA-users] (no subject)
>
> Rex,
>
> There is a function: roundto(x,n)  available in perl safe space within the 
> coding of a
> problem. You might try it to see if it works in the spreadsheet.
>
> $y = &roundto($z,3);
>
> will round z to 3 decimal places.
>
> Later,
> Mark
>
>
> On Nov 2, 2015, at 4:40 PM, Rex Abert <abe...@tcc.fl.edu> wrote:
>
>> I have a question about rounding values to, say, 3 or 4 digits in the 
>> spreadsheet.  I've come up with the following hack that does the job, but i 
>> was wondering if there was a more elegant (built-in?) way to do it.
>>
>>
>> $x = &SUMSEQ("T","regexp:Homework")/&SUMSEQ("S","regexp:Homework")*100;
>> $x *= 1000;
>> $x = int($x);
>> $x /= 1000;
>> $x;
>>
>> In the above code, columns S and T contain points available and points 
>> earned, depending on whether the due date has passed or not.
>>
>> Rex Abert
>> Associate Professor of Mathematics
>> Tallahassee Community College
>> _______________________________________________
>> LON-CAPA-users mailing list
>> LON-CAPA-users@mail.lon-capa.org
>> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
>
> --
> Mark Lucas                                                              
> email: luc...@ohiou.edu
> 252D Clippinger Lab                                             phone: 
> (740)597-2984
> Department of Physics and Astronomy                     fax: (740)593-0433
> Ohio University
> Athens, OH 45701
>
> _______________________________________________
> LON-CAPA-users mailing list
> LON-CAPA-users@mail.lon-capa.org
> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
> _______________________________________________
> LON-CAPA-users mailing list
> LON-CAPA-users@mail.lon-capa.org
> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
>


--
Dr. Peter Dencker
    wissenschaftl. Mitarbeiter

UNIVERSITÄT ZU LÜBECK
    INSTITUT FÜR MATHEMATIK

    Ratzeburger Allee 160
    23562 Lübeck

    Tel +49 451 500 4254
    Fax +49 451 500 3373
    denc...@math.uni-luebeck.de

    www.math.uni-luebeck.de
_______________________________________________
LON-CAPA-users mailing list
LON-CAPA-users@mail.lon-capa.org
http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
_______________________________________________
LON-CAPA-users mailing list
LON-CAPA-users@mail.lon-capa.org
http://mail.lon-capa.org/mailman/listinfo/lon-capa-users

Reply via email to