I have written improved help instructions for the spreadsheet grading to implement conditional grading, and also to make spreadsheet templates for grade categories and easily apply the templates to individual loncapa problems. For example, once a template has been created for on assessment for partial credit, the template can readily applied to other problems. I also use templates for grade categories to copy awarded points to particular columns so that they are quickly tabulated for each category.
The edits have not yet been incorporated into the help files (perhaps because I have not committed the changes to the repository - I can't remember the status of the draft!), but if you are interested, send me an e-mail off-list, and I can share the draft. My method does change the 'Points Awarded' in the spreadsheet view, but I have not tested in the Assessment Chart mentioned by Doug Mills. P.S. I support the ability to save/load spreadsheet files which makes the above process easier to share between courses. Carl Lira Associate Professor 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 l...@egr.msu.edu http://www.egr.msu.edu/~lira http://chethermo.net <http://chethermo.net/> -----Original Message----- From: lon-capa-users-boun...@mail.lon-capa.org [mailto:lon-capa-users-boun...@mail.lon-capa.org] On Behalf Of Stuart Raeburn Sent: Tuesday, September 20, 2016 12:24 PM To: lon-capa-users@mail.lon-capa.org Subject: Re: [LON-CAPA-users] Reduced Points for multiple attempts Dave, I would recommend using the LON-CAPA spreadsheet to implement this grading scheme for display of grades within LON-CAPA. As regards export to Blackboard Learn, it would be straightforward to modify the existing grade export script used in your domain (for which I implemented some speed-ups at the end of last year) to support points calculations that incorporate number of tries used, given that the number of tries used by each student on each problem part are already available in the md5_<courseid>_performance table for each course. Contact me off-list if you'd like to pursue that option. One of the outcomes of my previous work on grade export for purdue is that the next LON-CAPA release includes a new domain configuration (and associated changes in LON-CAPA internals): "Default lifetime (since last update) can be set for 'temporary' MySQL tables containing student performance data (course's homeserver only) by course type, (can be overridden in a specific course via DC's 'View or modify a course')." Stuart Raeburn LON-CAPA Academic Consortium Quoting "Huckleberry, David W" <dhuck...@purdue.edu>: > I have a faculty member that wants to give more points for first > attempt, and reduce after that. We contacted Gerd and he gave us > information on doing it in the Spreadsheet, but the issue is our > grade sync to Blackboard Learn would ignore any of those > calculations and only take the Awarded Points. > > Is anyone doing anything where that can be handled within the problem itself? > > See the faculty question below: > > "After emailing Bob Herrick, and having Bob get Gerd's feedback, it > sounds like deducting points based on attempts would need to be done > after an exam has been submitted. I'm guessing there would need to > be a spreadsheet with each students attempts and score for each > problem that would need to be run through a formula to adjust their > score (1 attempt and correct = 1 point, 2 attempts and correct = 0.5 > points, more than 2 attempts or incorrect = 0 points). I would > prefer to have a way to assign conditional points automatically, but > I don't know if this is something that would need to be coded into > each problem or something that we would need to code into LON-CAPA > somewhere else, or if there would be a way to do this with > BlackBoard when the scores get transferred." > > > > > > David W Huckleberry > Educational Technologist > Information Technology at Purdue (ITaP) | Innovations in Teaching > and Learning > 523 Young Hall / 155 S. Grant St > West Lafayette, IN 47907 > V: 765-496-1256 > E: dhuck...@purdue.edu<mailto:dhuck...@purdue.edu> _______________________________________________ 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