[LON-CAPA-users] automatically decrease point value with number of attempts

lira lira at egr.msu.edu
Mon Feb 9 22:58:10 EST 2015

I have not done this at the assessment level, only at the student level, but
I expect it is the same.

At the top of the page,  see the box to the right of 'Save' and above 'Save
and Make This Sheet the Default'. That is where you save the new sheet with
a new name. If you want every resource to use the same rules, you can make
it the default.  I have only configured the default sheet at the student

I am going to speculate here and make a suggestion. Try this:

Go to the assessment level, enter the desired formulas and change the name
to something like 'decreasing_score' and click 'Save'.
Then, go back to the Student level sheet (Look for the link just above the
assessment table.)
Now look at each assessment. There is a dropdown in the 'Asessment' column
that specifies which assessment sheet is to be used for that assessment.

Please share if it works.

-----Original Message-----
From: lon-capa-users-bounces at mail.lon-capa.org
[mailto:lon-capa-users-bounces at mail.lon-capa.org] On Behalf Of Mills,
Douglas G
Sent: Monday, February 09, 2015 12:21 PM
To: Discussion list for LON-CAPA users
Cc: Mills, Douglas G
Subject: Re: [LON-CAPA-users] automatically decrease point value with number
of attempts

Where do I associate an assessment spreadsheet with a given assignment if I
don't want to just use the default assessment spreadsheet for the course
with it? I'm still not seeing how to do that. Thank you!


Douglas Mills
Director of Instructional Technologies
Department of Chemistry
University of Illinois
dmills at illinois.edu
(217) 244-5739

On 2/4/15, 1:47 PM, "Carl Lira" <lira at egr.msu.edu> wrote:

>I've used spreadsheets a couple of semesters because of my complicated 
>point scheme with different weights for written homework, exams, 
>loncapa exercises, etc. I create a student-level template with the 
>formulas to use.
>They are very powerful.
>They work like an excel spreadsheet, so you can program formulas to 
>calculate the points to assign for a given problem. If you want to give 
>different points depending on the number of trials, you can find that 
>information and enter a formula.
>For example, a homework problem from a previous course shows this 
>spreadsheet table (cells are denoted by blanks and this will run over a 
>couple rows of the e-mail message, but in loncapa it is one wide row):
>72		Homework Problem 1. Interpolation
>	 correct 	 Tries: 	 2 	 Timestamp: 	 1389119141
>TueJan713:25:412014 	 Duedate: 	 1389366000
>FriJan1010:00:002014 	 Attempted Parts: 	 1 	 Solved Parts: 	 1
>You can see the number of tries and the solved parts. So to give 
>partial credit, just create a formula to use in one of the extra 
>columns provided. I used columns for the different categories of 
>material, and then you can sum the columns at the top of the sheet. You 
>can enter formulas to include the weights for the different categories. 
>You must enter the formula for each resource that you want to treat 
>this way. I created a screencast to show students how to read the 
>sheet: https://connect.msu.edu/loncapa-grades/
>I encountered a minor bug that occurred when I copied my course from 
>one semester to the next. Some cells were not completely null in the 
>copy, and the '&NUM', '&SUBMIN' functions were compromised, but I know 
>Stuart Raeburn worked on that and I have not tested subsequently. I'm 
>not using it this semester because I decided to use i>clickers and 
>transferring loncapa stuff to the MSU d2l system was less work than 
>importing a lot of i>clicker data into loncapa.
>This is a very powerful tool. To make it more useful, it would be good 
>(minor issue) the header could be static so it was visible when working 
>in rows far from the header; 2) (major issue) the row numbers and 
>resource names were visible when working far to the right if in column 
>z for example;
>3) (minor issue) The table columns all lined up. Currently each folder 
>is a separate table so that there are many tables of different widths 
>so the columns don't line up through the entire course; 4) They 
>integrated with
>i>clickers used here at MSU.
>Carl Lira
>Department of Chemical Engineering and Materials Science
>2527 Engineering Building
>428 S. Shaw Lane
>Michigan State University
>East Lansing, MI 48824-1226
>Phone: (517) 355-9731
>FAX: (517)432-1105
>http://chethermo.net <http://chethermo.net/>
>-----Original Message-----
>From: lon-capa-users-bounces at mail.lon-capa.org
>[mailto:lon-capa-users-bounces at mail.lon-capa.org] On Behalf Of Mills, 
>Douglas G
>Sent: Wednesday, February 04, 2015 1:38 PM
>To: Discussion list for LON-CAPA users
>Cc: Mills, Douglas G
>Subject: Re: [LON-CAPA-users] automatically decrease point value with 
>number of attempts
>Hi All,
>Thank you Peter and Mark.  Excuse the basic question on spreadsheets, 
>but I'm not finding this addressed anywhere. Is there only one 
>Assessment spreadsheet per course?  ....
>LON-CAPA-users mailing list
>LON-CAPA-users at mail.lon-capa.org

LON-CAPA-users mailing list
LON-CAPA-users at mail.lon-capa.org

More information about the LON-CAPA-users mailing list