How can I download item analysis report to excel?
Or is there any SQL query to get the Item analysis results for a specified course?
The advantage of using an SQL query is to download the Item Analysis report for multiple courses by running one query.
Hi Dany,
First, run the report in a course and use these tables:
Thank you Rafael for your reply.
I will work on it and I would appreciate if anyone already created such a tool.
Hi Rafael again,
I could link those tables and got the same data as the Item Analysis, but which additional tables should I relate to get the course name so that I can run the query for each course independently?
Thank you for your help,
Dany Azzi
Hi Dany,
To relate the courses:
tmp_ia_summary -> qti_asi_data -> course_assessment-> course_main
Regards
Help
Privacy
Behind the Blackboard
Blackboard.com
Hi Dany,
To relate the courses:
tmp_ia_summary -> qti_asi_data -> course_assessment-> course_main
Regards