ML CSV Reports

Manage Learn (ML) is a vertical within the Sunbird project that focuses on implementing project, observation, and survey capabilities.

1. Project : The improvement project empowers leaders to outline and monitor a series of tasks, guiding users toward achieving specific improvement objectives.

2. observation : Observations consist of questionnaires tailored for specific entities like school blocks or clusters.

3. Surveys: Surveys on the Managed Learn are designed to gather valuable opinions and feedback from users without being associated with any specific entity.

Different types of ML reports

Project Reports

1. Task Detail Report : This CSV report contains information related detailed a project progress along with task, sub-task data and evidences attached to tasks once completed. This report queries sl-project Druid datasource. This report is generated considering several scenarios.

• Sample Task Detail Report CSV

UUID	User Type	User sub type	Declared State	District	Block	School Name	School ID	Declared Board	Org Name	Program Name	Program ID	Project ID	Project Title	Project Objective	Category	Project start date of the user	Project completion date of the user	Project Duration	Project Status	Tasks	Sub-Tasks	Task Evidence	Task Remarks	Project Evidence	Project Remarks
58b1a1a1-face-492b-a75a-0503863722bc	administrator	HM	Andhra Pradesh	ANANTAPUR	AMADAGUR	MPUPS KANDUKURIVARIPALLI	28224500205	State (Tamil Nadu)	Staging Custodian Organization	Testing program 4.7	PGM-FD255-testing_program-4.7	6310918982642d0007cb71cb	' Project with Tasks and Subtasks - FD255'	' Project with Tasks and Subtasks - FD255'	'Education Leader, School Process'	2022-09-01T11:03:37.895+05:30	2022-09-01T11:06:53.582+05:30	2 weeks	submitted	'Task 1'	'subtask 1 of Task 1'	https://sunbirdstagingpublic.blob.core.windows.net/samiksha/survey/6310918982642d0007cb71cb/58b1a1a1-face-492b-a75a-0503863722bc/293821ac-af9d-4853-89c2-1875a1f1fb9e/1662030251735.jpg	Null	https://sunbirdstagingpublic.blob.core.windows.net/samiksha/survey/6310918982642d0007cb71cb/58b1a1a1-face-492b-a75a-0503863722bc/293821ac-af9d-4853-89c2-1875a1f1fb9e/1662030337167.jpg	'awesome content with resources '

2. Status Report : This CSV report contains information related to the status of the project progress user wise. This report queries sl-project Druid datasource.

• Sample Status Report CSV

UUID	User Type	User sub type	state_name	District	Block	School Name	School ID	Declared Board	Org Name	Program Name	Program ID	Project ID	Project Title	Project Objective	Project start date of the user	Project completion date of the user	Project Duration	Last Synced date	Project Status	Certificate Status
0b241dc8-c66e-4909-b4dd-ca1dbde28bd7	administrator	HM	Andhra Pradesh	CHITTOOR	B.KOTHAKOTA	MPPS GUTTAMEEDA H/W	28230500607	State (Andhra Pradesh)	Staging Custodian Organization	Testing program 4.7	PGM-FD255-testing_program-4.7	624168e6ed274f000880e853	' Project with Tasks and Subtasks - FD255'	' Project with Tasks and Subtasks - FD255'	2022-03-28T07:51:02.230+05:30	Null	2 weeks	Null	started	Null

3. Filtered Task Detail Report : This CSV report contains information related detailed to project progress along with task, sub-task data and evidences attached to tasks once completed. Users can filter the volume of data by using the inbuild filters provided in the Program Dashboard. This report queries sl-project Druid datasource. This report is generated considering few scenarios.

• Sample Filtered Task Detail Report CSV

UUID	User Type	User sub type	Declared State	District	Block	Org Name	Program Name	Project Title	Project Objective	Project Status	Project Completion Date of the user	Tasks	Task Evidence	Task Remarks	Project Evidence	Project Remarks
3486fdb5-0e13-4638-94af-9a0e5fd7d865	administrator	DEO	Andhra Pradesh	ANANTAPUR	AGALI	Staging Custodian Organization	Testing program 4.7	' Project with Tasks and Subtasks - FD255'	' Project with Tasks and Subtasks - FD255'	submitted	2022-03-23T06:50:35.793+05:30	'Task 1'	www.google.com	Null	www.google.com	"good work"

---

Survey Reports

1. Question Report : This CSV report contains information of the questions attended by the users, their responses, remarks and evidence if submitted. This report queries sl-survey Druid datasource.

• Sample Question Report CSV

UUID	User Type	User Sub Type	Declared State	District	Block	School ID	School Name	Declared Board	Organisation Name	Program Name	Program ID	Survey Name	Survey ID	survey_submission_id	Question_external_id	Question	Question_response_label	Evidences	Remarks
12dd9732-841c-47bc-8714-423e7e723961	administrator	HM,DEO,SPD	Andhra Pradesh	Ananthapuram	AMADAGUR	28224500612	MPPS(URDU) AMADAGUR	CBSE	Staging Custodian Organization	Program - HT and officials	Program_HT_officials_123	Survey HT	54468f4e-14d8-11ee-af5f-bb2c8e1fa21b-1687862993715	64b67ec9c60fd1000869717c	SUR_TEST_001_1687862979157-1687862993720	Enter your First question	'manual testing '	Null	'test12333@#₹_&-+()/?!;::''*€¥$¢^°°={}\\∆§×π√•|`~~. test. test ,,,, ...... test ,😣😀😕😕😕😕😕😭😭 test. test.....,,,,, test'

2. Status Report : This CSV report contains the status information of Surveys attended by the users. This report queries ml-survey-status Druid datasource.

• Sample Status Report CSV

UUID	User type	user_sub_type	Declared State	District	District	School ID	School Name	Declared Board	Org Name	Program Name	Program ID	Survey Name	Survey ID	survey_submission_id	Status of submission	Submission date
03f2e690-c031-4e68-aec7-521afae36bf0	administrator	HM,DEO	Andhra Pradesh	Dr. B.R. Ambedhkar Konaseema	Ainavilli	28144900701	MPPS (NO.2) SANAPALLILANKA	CBSE	Staging Custodian Organization	Program - HT and officials	Program_HT_officials_123	Survey HT	54468f4e-14d8-11ee-af5f-bb2c8e1fa21b-1687862993715	649c1d9d5c81330008b7ea64	started	Null

---

Observation with Rubric Reports

1. Question Report : This CSV report contains information of the questions attended by the users, their responses, remarks and evidence if submitted. This report queries sl-observation Druid datasource.

• Sample Question Report CSV

UUID	User Type	User Sub Type	Declared State	District	Block	School ID	School Name	Declared Board	Org Name	Program Name	Program ID	Observation Name	Observation ID	Entity Observed	observation_submission_id	Domain Name	Criteria Name	Question_external_id	Question	Question_response_label	Question score	Evidences	Remarks
0498cee8-b015-4e51-a3a5-1bdc91c26914	Null	HM,DEO,SPD	Andhra Pradesh	NELLORE	KOVUR	Null	ZPHS(G) KOVUR	CBSE	ZPHS(G) KOVUR	Testing 4.4	PGM_FD_98_TEST_4.4	Observation with Rubrics – FD 98	ce643538-332f-11ec-988d-cf2eb532a059-OBSERVATION-TEMPLATE_CHILD	Andhra Pradesh	6295df3cae13230007dda6cb	HP Domain	Coaching & mentoring	Q17_1634904093354-1634906556742	You have to conduct regular review meetings with school principals of your district. How would you ensure that the review meeting is conducted well?	Make your own observations and ask general questions	25	Null	Null

2. Status Report : This CSV report contains the status information of observation attended by the users. This report queries sl-observation-status Druid datasource.

• Sample Status Report CSV

UUID	User Type	User sub type	Declared District	Declared District	Declared Block	Declared School ID	Declared School Name	Declared Board	Org Name	Program Name	Program ID	Observation Name	Observation ID	District observed	Block observed	School observed	ID of school observed	Observation Submission ID	Status of submission	Submission date	ECM marked NA
0498cee8-b015-4e51-a3a5-1bdc91c26914	administrator	HM,DEO,SPD	Andhra Pradesh	NELLORE	KOVUR	28192600523	ZPHS(G) KOVUR	CBSE	Staging Custodian Organization	Testing 4.4	PGM_FD_98_TEST_4.4	Observation with Rubrics – FD 98	ce643538-332f-11ec-988d-cf2eb532a059-OBSERVATION-TEMPLATE_CHILD	Null	Null	Null	Null	6295df3cae13230007dda6cb	completed	2022-05-31T09:29:03.491+05:30	Null

3. Domain Criteria Report : This report contains questions and answer related information along with calculated the scores of domains. Each domain will contain criterias and each critiria contains numbers with score, so based on that it will calculate the scores. This report queries sl-observation-status sl-observation Druid datasource.

• Sample Domain Criteria Report CSV

UUID	User Type	User Sub Type	Declared State	District	Block	School ID	School Name	Declared Board	Org Name	Program Name	Program ID	Observation Name	Observation ID	Entity Observed	observation_submission_id	Domain Name	Domain Level	Criteria Name	Criteria Level
0498cee8-b015-4e51-a3a5-1bdc91c26914	Null	HM,DEO,SPD	Andhra Pradesh	NELLORE	KOVUR	Null	ZPHS(G) KOVUR	CBSE	ZPHS(G) KOVUR	Testing 4.4	PGM_FD_98_TEST_4.4	Observation with Rubrics – FD 98	ce643538-332f-11ec-988d-cf2eb532a059-OBSERVATION-TEMPLATE_CHILD	Andhra Pradesh	6295df3cae13230007dda6cb	HP Domain	L1	Influence	L3

---

Observation without Rubric Reports

1. Question Report : This CSV report contains information of the questions attended by the users, their responses, remarks and evidence if submitted. This report queries sl-observation Druid datasource.

• Sample Question Report CSV

UUID	User Type	User Sub Type	Declared State	Declared District	Declared Block	Declared School ID	Declared School Name	Declared Board	Organisation Name	Program Name	Program ID	Observation Name	Observation ID	District observed	Block observed	School observed	ID of school observed	observation_submission_id	Submission date	Question_external_id	Question	Question_response_label	Question score	Evidences	Remarks
7e392af9-4923-4d14-8c3e-a2e8aab51237	teacher	TEACHER	Andhra Pradesh	ANANTAPUR	AMADAGUR	28224500518	MPPS JOWKULA	CBSE	Staging Custodian Organization	Program Teacher-1	Pgm_Teacher_2-QA	obs without rubrics 4	be7b6ed0-0c35-11ee-9eca-334a9e787416-OBSERVATION-TEMPLATE_CHILD	Anantapur	AMADAGUR	MPPS JOWKULA	28224500518	64993c9a5c81330008b78a49	2023-06-26T07:22:27.385Z	Q1_1686913540822-1686913551805	Enter the date of observation	2023-06-26T12:52:00+05:30	Null	Null	Null

2. Status Report : This CSV report contains the status information observation attended by the users. This report queries sl-observation-status Druid datasource.

• Sample Status Report CSV

UUID	User Type	User sub type	Declared State	Declared District	Declared Block	Declared School ID	Declared School Name	Declared Board	Org Name	Program Name	Program ID	Observation Name	Observation ID	District observed	Block observed	School observed	ID of school observed	Observation Submission ID	Status of submission	Submission date
52907735-7316-4d8d-886d-af46a8830549	administrator	HM,DEO	Andhra Pradesh	Ananthapuram	Agali	28226200910	MPPS HANUMANNAHALLI	State (Andhra Pradesh)	Staging Custodian Organization	Program Teacher-1	Pgm_Teacher_2-QA	obs without rubrics 4	be7b6ed0-0c35-11ee-9eca-334a9e787416-OBSERVATION-TEMPLATE_CHILD	Sri Satyasai	Agali	MPPS HANUMANNAHALLI	28226200910	649abbb35c81330008b7c455	started	Null