[LON-CAPA-users] Spreadsheet Timestamps

[Stuart Raeburn]

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" <lucasm at 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: lucasm at ohiou.edu
> 252D Clippinger Lab						phone: (740)597-2984
> Department of Physics and Astronomy		fax: (740)593-0433
> Ohio University
> Athens, OH 45701