ML CSV Reports
Manage Learn (ML) is a vertical within the Sunbird project that focuses on implementing project, observation, and survey capabilities.
Project : The improvement project empowers leaders to outline and monitor a series of tasks, guiding users toward achieving specific improvement objectives.
observation : Observations consist of questionnaires tailored for specific entities like school blocks or clusters.
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
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' | Null | 'awesome content with resources ' |
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 |
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
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' |
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
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 |
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 |
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
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 |
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 |
Last updated
