Skip to content

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.

![](/assets/Screenshot 2023-08-17 at 1.27.59 PM.png)

  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
UUIDUser TypeUser sub typeDeclared StateDistrictBlockSchool NameSchool IDDeclared BoardOrg NameProgram NameProgram IDProject IDProject TitleProject ObjectiveCategoryProject start date of the userProject completion date of the userProject DurationProject StatusTasksSub-TasksTask EvidenceTask RemarksProject EvidenceProject Remarks
58b1a1a1-face-492b-a75a-0503863722bcadministratorHMAndhra PradeshANANTAPURAMADAGURMPUPS KANDUKURIVARIPALLI28224500205State (Tamil Nadu)Staging Custodian OrganizationTesting program 4.7PGM-FD255-testing_program-4.76310918982642d0007cb71cb’ Project with Tasks and Subtasks - FD255'' Project with Tasks and Subtasks - FD255''Education Leader, School Process’2022-09-01T11:03:37.895+05:302022-09-01T11:06:53.582+05:302 weekssubmitted’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.jpgNullhttps://sunbirdstagingpublic.blob.core.windows.net/samiksha/survey/6310918982642d0007cb71cb/58b1a1a1-face-492b-a75a-0503863722bc/293821ac-af9d-4853-89c2-1875a1f1fb9e/1662030337167.jpg’awesome content with resources ’
  1. 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
UUIDUser TypeUser sub typestate_nameDistrictBlockSchool NameSchool IDDeclared BoardOrg NameProgram NameProgram IDProject IDProject TitleProject ObjectiveProject start date of the userProject completion date of the userProject DurationLast Synced dateProject StatusCertificate Status
0b241dc8-c66e-4909-b4dd-ca1dbde28bd7administratorHMAndhra PradeshCHITTOORB.KOTHAKOTAMPPS GUTTAMEEDA H/W28230500607State (Andhra Pradesh)Staging Custodian OrganizationTesting program 4.7PGM-FD255-testing_program-4.7624168e6ed274f000880e853’ Project with Tasks and Subtasks - FD255'' Project with Tasks and Subtasks - FD255’2022-03-28T07:51:02.230+05:30Null2 weeksNullstartedNull
  1. 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
UUIDUser TypeUser sub typeDeclared StateDistrictBlockOrg NameProgram NameProject TitleProject ObjectiveProject StatusProject Completion Date of the userTasksTask EvidenceTask RemarksProject EvidenceProject Remarks
3486fdb5-0e13-4638-94af-9a0e5fd7d865administratorDEOAndhra PradeshANANTAPURAGALIStaging Custodian OrganizationTesting program 4.7’ Project with Tasks and Subtasks - FD255'' Project with Tasks and Subtasks - FD255’submitted2022-03-23T06:50:35.793+05:30’Task 1’www.google.comNullwww.google.com”good work”

  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
UUIDUser TypeUser Sub TypeDeclared StateDistrictBlockSchool IDSchool NameDeclared BoardOrganisation NameProgram NameProgram IDSurvey NameSurvey IDsurvey_submission_idQuestion_external_idQuestionQuestion_response_labelEvidencesRemarks
12dd9732-841c-47bc-8714-423e7e723961administratorHM,DEO,SPDAndhra PradeshAnanthapuramAMADAGUR28224500612MPPS(URDU) AMADAGURCBSEStaging Custodian OrganizationProgram - HT and officialsProgram_HT_officials_123Survey HT54468f4e-14d8-11ee-af5f-bb2c8e1fa21b-168786299371564b67ec9c60fd1000869717cSUR_TEST_001_1687862979157-1687862993720Enter your First question’manual testing ‘Null’test12333@#₹_&-+()/?!;::”*€¥$¢^°°=\\∆§×π√•|`~~. test. test ,,,, … test ,😣😀😕😕😕😕😕😭😭 test. test…,,,,, test’
  1. 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
UUIDUser typeuser_sub_typeDeclared StateDistrictDistrictSchool IDSchool NameDeclared BoardOrg NameProgram NameProgram IDSurvey NameSurvey IDsurvey_submission_idStatus of submissionSubmission date
03f2e690-c031-4e68-aec7-521afae36bf0administratorHM,DEOAndhra PradeshDr. B.R. Ambedhkar KonaseemaAinavilli28144900701MPPS (NO.2) SANAPALLILANKACBSEStaging Custodian OrganizationProgram - HT and officialsProgram_HT_officials_123Survey HT54468f4e-14d8-11ee-af5f-bb2c8e1fa21b-1687862993715649c1d9d5c81330008b7ea64startedNull

  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
UUIDUser TypeUser Sub TypeDeclared StateDistrictBlockSchool IDSchool NameDeclared BoardOrg NameProgram NameProgram IDObservation NameObservation IDEntity Observedobservation_submission_idDomain NameCriteria NameQuestion_external_idQuestionQuestion_response_labelQuestion scoreEvidencesRemarks
0498cee8-b015-4e51-a3a5-1bdc91c26914NullHM,DEO,SPDAndhra PradeshNELLOREKOVURNullZPHS(G) KOVURCBSEZPHS(G) KOVURTesting 4.4PGM_FD_98_TEST_4.4Observation with Rubrics – FD 98ce643538-332f-11ec-988d-cf2eb532a059-OBSERVATION-TEMPLATE_CHILDAndhra Pradesh6295df3cae13230007dda6cbHP DomainCoaching & mentoringQ17_1634904093354-1634906556742You 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 questions25NullNull
  1. 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
UUIDUser TypeUser sub typeDeclared DistrictDeclared DistrictDeclared BlockDeclared School IDDeclared School NameDeclared BoardOrg NameProgram NameProgram IDObservation NameObservation IDDistrict observedBlock observedSchool observedID of school observedObservation Submission IDStatus of submissionSubmission dateECM marked NA
0498cee8-b015-4e51-a3a5-1bdc91c26914administratorHM,DEO,SPDAndhra PradeshNELLOREKOVUR28192600523ZPHS(G) KOVURCBSEStaging Custodian OrganizationTesting 4.4PGM_FD_98_TEST_4.4Observation with Rubrics – FD 98ce643538-332f-11ec-988d-cf2eb532a059-OBSERVATION-TEMPLATE_CHILDNullNullNullNull6295df3cae13230007dda6cbcompleted2022-05-31T09:29:03.491+05:30Null
  1. 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
UUIDUser TypeUser Sub TypeDeclared StateDistrictBlockSchool IDSchool NameDeclared BoardOrg NameProgram NameProgram IDObservation NameObservation IDEntity Observedobservation_submission_idDomain NameDomain LevelCriteria NameCriteria Level
0498cee8-b015-4e51-a3a5-1bdc91c26914NullHM,DEO,SPDAndhra PradeshNELLOREKOVURNullZPHS(G) KOVURCBSEZPHS(G) KOVURTesting 4.4PGM_FD_98_TEST_4.4Observation with Rubrics – FD 98ce643538-332f-11ec-988d-cf2eb532a059-OBSERVATION-TEMPLATE_CHILDAndhra Pradesh6295df3cae13230007dda6cbHP DomainL1InfluenceL3

  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
UUIDUser TypeUser Sub TypeDeclared StateDeclared DistrictDeclared BlockDeclared School IDDeclared School NameDeclared BoardOrganisation NameProgram NameProgram IDObservation NameObservation IDDistrict observedBlock observedSchool observedID of school observedobservation_submission_idSubmission dateQuestion_external_idQuestionQuestion_response_labelQuestion scoreEvidencesRemarks
7e392af9-4923-4d14-8c3e-a2e8aab51237teacherTEACHERAndhra PradeshANANTAPURAMADAGUR28224500518MPPS JOWKULACBSEStaging Custodian OrganizationProgram Teacher-1Pgm_Teacher_2-QAobs without rubrics 4be7b6ed0-0c35-11ee-9eca-334a9e787416-OBSERVATION-TEMPLATE_CHILDAnantapurAMADAGURMPPS JOWKULA2822450051864993c9a5c81330008b78a492023-06-26T07:22:27.385ZQ1_1686913540822-1686913551805Enter the date of observation2023-06-26T12:52:00+05:30NullNullNull
  1. 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
UUIDUser TypeUser sub typeDeclared StateDeclared DistrictDeclared BlockDeclared School IDDeclared School NameDeclared BoardOrg NameProgram NameProgram IDObservation NameObservation IDDistrict observedBlock observedSchool observedID of school observedObservation Submission IDStatus of submissionSubmission date
52907735-7316-4d8d-886d-af46a8830549administratorHM,DEOAndhra PradeshAnanthapuramAgali28226200910MPPS HANUMANNAHALLIState (Andhra Pradesh)Staging Custodian OrganizationProgram Teacher-1Pgm_Teacher_2-QAobs without rubrics 4be7b6ed0-0c35-11ee-9eca-334a9e787416-OBSERVATION-TEMPLATE_CHILDSri SatyasaiAgaliMPPS HANUMANNAHALLI28226200910649abbb35c81330008b7c455startedNull