Hi,


The only hitch is that all I can find is a generic timestamp in the assessment spreadsheet list of parameters, which presumably is the last time the student attempted a part on the problem. Am I missing something?


I thought I would (belatedly) send a copy of my reply to a follow-up e-mail which was sent to me about this question (off-list) so that anyone searching the lists in the future will have a chance of finding a response to the original July 2, 2015 post to the users' list.

No, you are not missing anything.

In the current implementation there is a single timestamp available from a given resource because of the choice of inner hash key for the timestamp item returned in the hash of a hash retrieved from:

Apache::loncoursedata::get_student_data_from_performance_cache()

For each of the items: solved, tries, awarded, award, and awarddetail the innerhash key is: resource.'.$part.'.$name (where $part is the partID, and $name is the item name (solved, etc.), but for the timestamp, (i.e., the time of the transaction) the inner hash key is just timestamp (i.e., no part identifier). When these items are converted to parameter names for the assessment level spreadsheet, the key: resource.'.$part.'.$name is converted to: stores_$part_$name.

Hence, you'll see: stores_$part_tries etc. as a row item in the assessment level spreadsheet for a particular student for each part ($part) in a multi-part problem, but you'll only see a single timestamp.

This is likely a reflection of the fact that the timestamps preserved in the MySQL table: md5_<course identifier>_performance are identical for all part_ids for a particular resource and student, for a multi-part problem.

The timestamps for last submission for a particular part could be retrieved by using a SQL query including a join on other tables (md5_<course identifier>_partdata and md5_<course identifier>_timestampdata), but it would likely impact the speed of initial retrieval of student performance data (and population of temporary MySQL tables).

Anyway, I have filed bug 6790 (http://bugs.loncapa.org/show_bug.cgi?id=6790 ) to request access to timestamps for last submission for specific parts.

Note: you cannot access the timestamp for a particular problem part via an &EXT() call in a spreadsheet cell either.

Stuart Raeburn
LON-CAPA Academic Consortium


Quoting "Lucas, Mark" <luc...@ohio.edu>:


I'm looking into a scheme whereby students get full credit if answering a question within a week of it opening and half credit for answering anytime before the due date (end of
course potentially).

I'm in the spreadsheet and am to the point of creating the logic that might
read something like (stores_PART_timestamp > parameter_PART_opendate+(3600*24*7) ? 0.5: 1);

The only hitch is that all I can find is a generic timestamp in the assessment spreadsheet list of parameters, which presumably is the last time the student attempted a part on the problem. Am I missing something?

Thanks!
Mark


--
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

Reply via email to