Archived Blackboard Learn discussions

Re: Reporting on assignments within courses?

John Manguno — Thu, 04 Aug 2011 13:27:50 GMT

Thank you Michael. I will check it out.

Re: Reporting on assignments within courses?

Michael Zimmerman — Thu, 04 Aug 2011 04:55:46 GMT

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

Reporting on assignments within courses?

John Manguno — Wed, 03 Aug 2011 15:35:26 GMT

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?