I am using SQL with MSRS to create reports which figure out students who have not completed assignments within a given course. This works well, but now there is an interest in displaying individual answer data from tests in custom reports.
I have looked into the database structure, and I can drill down to individual questions being somehow inserted into qti_asi_data or qti_result_data. However, the data fields are some sort of hashed data, and I can't make heads or tail of figuring out the exact structure which would show me student A answered question 2 this way.
Is anyone else attempting this?
John,
Oddly, today someone was asking a very similar question on one of the listservs about deciphering qti_asi_result data. It appears that the data is simply stored in hex format, so you need to use a hex-to-ascii converter ( such as http://www.string-functions.com/hex-string.aspx ) to covert the data into ascii-format XML.
Mike
Thank you Michael. I will check it out.