Response Exhaust

The response exhaust report captures the user's responses to each question in the assessment. The response exhaust report contains data only if an assessment or question set is present. For each batch of users, a distinct response exhaust report is created. Each user's attempt at a particular question is exhaustively recorded, resulting in multiple rows for each attempt. m

Overall, the code represents the job that processes user enrolment data and collects batch information. It retrieves assessment data, performs necessary transformations, joins with content data, and organizes the resulting DataFrame as a response exhaust report.

Data provider:

cassandra

1. user redis

2. user_enrolments

3. assessment_aggregator

4. user_activity_agg

postgres

1. job_request table

Content search API

File Structure

Format	Nomenclature	Example
CSV	response-exhaust/{request_id}/<batch_id>_response_<updatedDate>.csv	do_1130264512015646721166_response_26_08_2020.csv

File Contents

Column Label	Column Type	Data Type	Description
Collection Id	Static	String	Unique Collection Identifier
Collection Name	Static	String	Collection Title
Batch Id	Static	String	Batch Id
Batch Name	Static	String	Batch Title
User UUID	Static	String	The system generated unique user ID
User Name	Static	String	Name of the user
QuestionSet Id	Static	String	Id of the question set
QuestionSet Title	Static	String	Title of the question set
Attempt Id	Static	String	Id of the attempt. There can be more than one attempt for the same question set
Attempted On	Static	DateTime	Date on which the last attempt happened for this attempt id
Question Id	Static	String	Question id
Question Type	Static	String	Question type - mcq/mtf/mmcq/ftb
Question Title	Static	String	Title of the question
Question Description	Static	String	Description of the question
Question Duration	Static	Number	Time taken to answer the question
Question Score	Static	Number	Score received for the question
Question Max Score	Static	Number	Max applicable score for the question
Question Options	Static	JSON	Options shown to the user
Question Response	Static	JSON	Responses given by the user

Consent Fields

• Question Response

Sample Data

Collection Id,Collection Name,Batch Id,Batch Name,User UUID,QuestionSet Id,QuestionSet Title,Attempt Id,Attempted On,Question Id,Question Type,Question Title,Question Description,Question Duration,Question Score,Question Max Score,Question Options,Question Response
do_1130934466492252161819,Test Course,1.3093449510953E+017,Batch1,f703de4e-d47a-4adb-856c-de122e6a0b32,do_1126980913198940161169,Test Questionset,85b32814c2680581f9447c0b792dc2a3,2020-01-09 05:47:44,do_2129194942597447681595,mcq,Which planet has the most Moons?\n,,3,0,1,"[{'1': '{""text"":""Venus\n""}'}]","[{'1': '{""text"":""Venus\n""}'}, {'2': '{""text"":""Jupiter\n""}'}, {'3': '{""text"":""Mercury\n""}'}, {'4': '{""text"":""None of the above\n""}'}, {'answer': '{""correct"":[""2""]}'}]"
do_1130934466492252161819,Test Course,1.3093449510953E+017,Batch1,587204af-41db-4313-b3ab-cf022d3055c6,do_1126980913198940161169,Test Questionset,85b328331c2680581f9447c0b792dc2a4,2020-01-09 05:47:44,do_2129194942597447681595,mcq,Which planet has the most Moons?\n,,4,1,1,"[{'2': '{""text"":""Jupiter\n""}'}]","[{'1': '{""text"":""Venus\n""}'}, {'2': '{""text"":""Jupiter\n""}'}, {'3': '{""text"":""Mercury\n""}'}, {'4': '{""text"":""None of the above\n""}'}, {'answer': '{""correct"":[""2""]}'}]"