cQube v5.0 Beta - Schema Documentation

Student Attendance Program

This program entails indicators to monitor compliance and performance of student attendance. Following are the reports within this program.

Student Attendance Compliance: This report shows the compliance of student attendance being marked in the schools. A school is counted as attendance-compliant when attendance of more than 50% of the students in the school is marked on a particular date. This report will have the Date Range filter. Other Filters like District, Block, Cluster, School will be picked up from RBAC. Following indicators will be available for specific roles as part of this report:

Role	Indicator	Chart Type	Applicable Filters

Role	Indicator	Chart Type	Applicable Filters
State Officer	Average Attendance Compliance %	Big Number	Date Range
State Officer	District-wise Attendance Compliance %	Table	Date Range
District Officer	Average Attendance Compliance %	Big Number	District, Date Range
	Block-wise Attendance Compliance %	Table	District, Date Range
	District-wise Rank in Attendance Compliance %	Table	Date Range
Block Officer	Average Attendance Compliance %	Big Number	District, Block, Date Range
	Cluster-wise Attendance Compliance %	Table	District, Block, Date Range
	Block-wise Rank in Attendance Compliance %	Table	District, Date Range
Cluster Officer	Average Attendance Compliance %	Big Number	District, Block, Cluster, Date Range
	School-wise Attendance Compliance %	Table	District, Block, Cluster, Date Range
	Cluster-wise Rank in Attendance Compliance %	Table	District, Block, Date Range
School Principal	Average Attendance Compliance %	Big Number	District, Block, Cluster, School, Date Range
	Grade-wise Attendance Compliance % (1 to 12)	Table	District, Block, Cluster, School, Date Range
	School-wise Rank in Attendance Compliance %	Table	District, Block, Cluster, Date Range

Student Attendance Summary: This report shows the summary of students being present in the schools (out of the ones being marked). This report will have the Date Range filter. Other Filters like District, Block, Cluster, School will be picked up from RBAC. Following indicators will be available for specific roles as part of this report:

Role	Indicator	Chart Type	Applicable Filters

Role	Indicator	Chart Type	Applicable Filters
State Officer	Average Attendance %	Big Number	Date Range
	District-wise Attendance %	Table	Date Range
	Gender-wise Attendance % (Male, Female, Other)	Bar Chart	Date Range
	Grade-wise Attendance % (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	Date Range
District Officer	Average Attendance %	Big Number	District, Date Range
	Block-wise Attendance %	Table	District, Date Range
	District-wise Rank in Attendance %	Table	Date Range
	Gender-wise Attendance % (Male, Female, Other)	Bar Chart	District, Date Range
	Grade-wise Attendance % (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Date Range
Block Officer	Average Attendance %	Big Number	District, Block, Date Range
	Cluster-wise Attendance %	Table	District, Block, Date Range
	Block-wise Rank in Attendance %	Table	District, Date Range
	Gender-wise Attendance % (Male, Female, Other)	Bar Chart	District, Block, Date Range
	Grade-wise Attendance % (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Block, Date Range
Cluster Officer	Average Attendance %	Big Number	District, Block, Cluster, Date Range
	School-wise Attendance %	Table	District, Block, Cluster, Date Range
	Cluster-wise Rank in Attendance %	Table	District, Block, Date Range
	Gender-wise Attendance % (Male, Female, Other)	Bar Chart	District, Block, Cluster, Date Range
	Grade-wise Attendance % (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Block, Cluster, Date Range
School Principal	Average Attendance %	Big Number	District, Block, Cluster, School, Date Range
	Grade-wise Attendance % (1 to 12)	Table	District, Block, Cluster, School, Date Range
	School-wise Rank in Attendance %	Table	District, Block, Cluster, Date Range
	Gender-wise Attendance % (Male, Female, Other)	Bar Chart	District, Block, Cluster, School, Date Range
Class Teacher	Average Attendance %	Big Number	District, Block, Cluster, School, Grade, Date Range
	Grade-wise Rank in Attendance %	Table	District, Block, Cluster, School, Date Range
	Gender-wise Attendance % (Male, Female, Other)	Bar Chart	District, Block, Cluster, School, Grade, Date Range

Input Schema

Following schema will be required to enable the above-mentioned indicators in this program:

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	date	string	Date when the data was recorded	Yyyy-mm-dd format to be used
2	school_id	string	Unique ID of the school	Restricted to 10 characters
3	grade	integer	Grade for which the data is being entered	Restricted to values from 1 to 12
4	school_category	string	Category which the school ID belongs to	Accepted Values - Primary, Upper Primary, Secondary, Senior Secondary
5	gender	string	Gender for which data is being entered	Accepted Values - Male, Female, Other
6	total_students	integer	Total number of students	NA
7	students_attendance_marked	integer	Total number of students whose attendance was marked	NA
8	students_attendance_present	integer	Total number of students who were present in the class	NA

Here is the upload template for this schema. You can use this template to fill the state data and upload it into cQube. Here is the sample template for this schema to see the kind of data and template in which cQube will accept data.

Teacher Attendance Program

This program entails indicators to monitor compliance and performance of teacher attendance. Following are the reports within this program:

Teacher Attendance Compliance: This report shows the compliance of attendance being marked by teachers. This report will have the Date Range filter. Other Filters like District, Block, Cluster, School will be picked up from RBAC. Following indicators will be available for specific roles as part of this report:

Role	Indicator	Chart Type	Applicable Filters

Role	Indicator	Chart Type	Applicable Filters
State Officer	Average Attendance Compliance %	Big Number	Date Range
State Officer	District-wise Attendance Compliance %	Table	Date Range
District Officer	Average Attendance Compliance %	Big Number	District, Date Range
	Block-wise Attendance Compliance %	Table	District, Date Range
	District-wise Rank in Attendance Compliance %	Table	Date Range
Block Officer	Average Attendance Compliance %	Big Number	District, Block, Date Range
	Cluster-wise Attendance Compliance %	Table	District, Block, Date Range
	Block-wise Rank in Attendance Compliance %	Table	District, Date Range
Cluster Officer	Average Attendance Compliance %	Big Number	District, Block, Cluster, Date Range
	School-wise Attendance Compliance %	Table	District, Block, Cluster, Date Range
	Cluster-wise Rank in Attendance Compliance %	Table	District, Block, Date Range
School Principal	Average Attendance Compliance %	Big Number	District, Block, Cluster, School, Date Range
School Principal	School-wise Rank in Attendance Compliance %	Table	District, Block, Cluster, Date Range

Teacher Attendance Summary: This report shows the summary of teachers being present in the school (out of the ones marking their attendance). This report will have the Date Range filter. Other Filters like District, Block, Cluster, School will be picked up from RBAC. Following indicators will be available for specific roles as part of this report:

Role	Indicator	Chart Type	Applicable Filters

Role	Indicator	Chart Type	Applicable Filters
State Officer	Average Attendance %	Big Number	Date Range
State Officer	District-wise Attendance %	Table	Date Range
District Officer	Average Attendance %	Big Number	District, Date Range
	Block-wise Attendance %	Table	District, Date Range
	District-wise Rank in Attendance %	Table	Date Range
Block Officer	Average Attendance %	Big Number	District, Block, Date Range
	Cluster-wise Attendance %	Table	District, Block, Date Range
	Block-wise Rank in Attendance %	Table	District, Date Range
Cluster Officer	Average Attendance %	Big Number	District, Block, Cluster, Date Range
	School-wise Attendance %	Table	District, Block, Cluster, Date Range
	Cluster-wise Rank in Attendance %	Table	District, Block, Date Range
School Principal	Average Attendance %	Big Number	District, Block, Cluster, School, Date Range
School Principal	School-wise Rank in Attendance %	Table	District, Block, Cluster, Date Range

Input Schema

The following schema will be required to enable the above-mentioned indicators in this program:

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	date	string	Date when the data was recorded	Yyyy-mm-dd format to be used
2	school_id	string	Unique ID of the school	Restricted to 10 characters
3	school_category	string	Category which the school ID belongs to	Accepted Values - Primary, Upper Primary, Secondary, Senior Secondary
4	grade	integer	Grade for which the data is being entered	Restricted to values from 1 to 12
5	total_teachers	integer	Total number of teachers	NA
6	teachers_attendance_marked	integer	Total number of teachers whose attendance was marked	NA
7	teachers_attendance_present	integer	Total number of teachers who were present	NA

Here is the upload template for this schema. You can use this template to fill the state data and upload it into cQube. Here is the sample template for this schema to see the kind of data and template in which cQube will accept data.

School Statistics Program

This program entails indicators to monitor different administrative indicators with respect to a school. This program will have the Academic Year and Month filters. Other Filters like District, Block, Cluster, School will be picked up from RBAC. Following indicators will be available for specific roles as part of this program:

Role	Indicator	Chart Type	Applicable Filters

Role	Indicator	Chart Type	Applicable Filters
State Officer	Total Schools	Big Number	Academic Year, Month
	District-wise Total Schools	Table	Academic Year, Month
	Category-wise Total Schools (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	Academic Year, Month
	Student Enrolment-wise Number of Schools (0-50, 50-100, 100-150, 150-200, 200+ students)	Bar Chart	Academic Year, Month
District Officer	Total Schools	Big Number	District, Academic Year, Month
	Block-wise Total Schools	Table	District, Academic Year, Month
	Category-wise Total Schools (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Academic Year, Month
	Student Enrolment-wise Number of Schools (0-50, 50-100, 100-150, 150-200, 200+ students)	Bar Chart	District, Academic Year, Month
Block Officer	Total Schools	Big Number	District, Block, Academic Year, Month
	Cluster-wise Total Schools	Table	District, Block, Academic Year, Month
	Category-wise Total Schools (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Block, Academic Year, Month
	Student Enrolment-wise Number of Schools (0-50, 50-100, 100-150, 150-200, 200+ students)	Bar Chart	District, Block, Academic Year, Month
Cluster Officer	Total Schools	Big Number	District, Block, Cluster, Academic Year, Month
	Category-wise Total Schools (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Block, Cluster, Academic Year, Month
	Student Enrolment-wise Number of Schools (0-50, 50-100, 100-150, 150-200, 200+ students)	Bar Chart	District, Block, Cluster, Academic Year, Month

Input Schema

Following schema will be required to enable the above-mentioned indicators in this program:

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	academic_year	string	year for which the student has enrolled is being recorded	Yyyy format to be used
2	grade	integer	Grade of the class	Restricted to values from 1 to 12
3	school_id	string	School ID as defined by the state registry	Restricted to 10 characters
4	school_category	string	Category which the school ID belongs to	Accepted Values - Primary, Upper Primary, Secondary, Senior Secondary
5	student_category	string	Category of the school as defined by the school	Accepted values- SC,ST,OBC,others,general
6	gender	string	Gender of the student	Accepted Values - Male, Female, Other
7	cwsn_enrolled	integer	Child with special needed	NA
8	student_enrolled	integer	Student enrolled for school	NA

Here is the upload template for this schema. You can use this template to fill the state data and upload it into cQube. Here is the sample template for this schema to see the kind of data and template in which cQube will accept data.

Student Statistics Program

This program entails indicators to monitor different administrative indicators with respect to students in the jurisdiction. This program will have the Academic Year and Month filters. Other Filters like District, Block, Cluster, School will be picked up from RBAC. Following indicators will be available for specific roles as part of this program:

Role	Indicator	Chart Type	Applicable Filters

Role	Indicator	Chart Type	Applicable Filters
State Officer	Total Students Enrolled	Big Number	Academic Year, Month
	Total CwSN Enrolment	Big Number	Academic Year, Month
	District-wise Students Enrolled & CwSN Enrolment	Table	Academic Year, Month
	Gender-wise Student Enrolment (Male, Female, Other)	Bar Chart	Academic Year, Month
	Student Category-wise Enrolment (SC, ST, OBC, General, Other)	Bar Chart	Academic Year, Month
	Category-wise Total Enrolment (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	Academic Year, Month
District Officer	Total Students Enrolled	Big Number	District, Academic Year, Month
	Total CwSN Enrolment	Big Number	District, Academic Year, Month
	Block-wise Students Enrolled & CwSN Enrolment	Table	District, Academic Year, Month
	District-wise rank in Students Enrolled & CwSN Enrolment	Table	Academic Year, Month
	Gender-wise Student Enrolment (Male, Female, Other)	Bar Chart	District, Academic Year, Month
	Student Category-wise Enrolment (SC, ST, OBC, General, Other)	Bar Chart	District, Academic Year, Month
	Category-wise Total Enrolment (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Academic Year, Month
Block Officer	Total Students Enrolled	Big Number	District, Block, Academic Year, Month
	Total CwSN Enrolment	Big Number	District, Block, Academic Year, Month
	Cluster-wise Students Enrolled & CwSN Enrolment	Table	District, Block, Academic Year, Month
	Block-wise rank in Students Enrolled & CwSN Enrolment	Table	District, Academic Year, Month
	Gender-wise Student Enrolment (Male, Female, Other)	Bar Chart	District, Block, Academic Year, Month
	Student Category-wise Enrolment (SC, ST, OBC, General, Other)	Bar Chart	District, Block, Academic Year, Month
	Category-wise Total Enrolment (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Block, Academic Year, Month
Cluster Officer	Total Students Enrolled	Big Number	District, Block, Cluster, Academic Year, Month
	Total CwSN Enrolment	Big Number	District, Block, Cluster, Academic Year, Month
	School-wise Students Enrolled & CwSN Enrolment	Table	District, Block, Cluster, Academic Year, Month
	Cluster-wise rank in Students Enrolled & CwSN Enrolment	Table	District, Block, Academic Year, Month
	Gender-wise Student Enrolment (Male, Female, Other)	Bar Chart	District, Block, Cluster, Academic Year, Month
	Student Category-wise Enrolment (SC, ST, OBC, General, Other)	Bar Chart	District, Block, Cluster, Academic Year, Month
	Category-wise Total Enrolment (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Block, Cluster, Academic Year, Month
School Principal	Total Students Enrolled	Big Number	District, Block, Cluster, School, Academic Year, Month
	Total CwSN Enrolment	Big Number	District, Block, Cluster, School, Academic Year, Month
	Grade-wise Students Enrolled & CwSN Enrolment	Table	District, Block, Cluster, School, Academic Year, Month
	School-wise rank in Students Enrolled & CwSN Enrolment	Table	District, Block, Cluster, Academic Year, Month
	Gender-wise Student Enrolment (Male, Female, Other)	Bar Chart	District, Block, Cluster, School, Academic Year, Month
	Student Category-wise Enrolment (SC, ST, OBC, General, Other)	Bar Chart	District, Block, Cluster, School, Academic Year, Month
Class Teacher	Total Students Enrolled	Big Number	District, Block, Cluster, School, Grade, Academic Year, Month
	Total CwSN Enrolment	Big Number	District, Block, Cluster, School, Grade, Academic Year, Month
	Grade-wise rank in Students Enrolled & CwSN Enrolment	Table	District, Block, Cluster, School, Grade, Academic Year, Month
	Gender-wise Student Enrolment (Male, Female, Other)	Bar Chart	District, Block, Cluster, School, Grade, Academic Year, Month
	Student Category-wise Enrolment (SC, ST, OBC, General, Other)	Bar Chart	District, Block, Cluster, School, Grade, Academic Year, Month

Input Schema

Following schema will be required to enable the above-mentioned indicators in this program:

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	academic_year	string	year for which the student has enrolled is being recorded	Yyyy format to be used
2	grade	integer	Grade of the class	Restricted to values from 1 to 12
3	school_id	string	School ID as defined by the state registry	Restricted to 10 characters
4	school_category	string	Category which the school ID belongs to	Accepted Values - Primary, Upper Primary, Secondary, Senior Secondary
5	student_category	string	Category of the school as defined by the school	Accepted values- SC,ST,OBC,others,general
6	gender	string	Gender of the student	Accepted Values - Male, Female, Other
7	cwsn_enrolled	integer	Child with special needed	NA
8	student_enrolled	integer	Student enrolled for school	NA

Here is the upload template for this schema. You can use this template to fill the state data and upload it into cQube. Here is the sample template for this schema to see the kind of data and template in which cQube will accept data.

Teacher Statistics Program

This program entails indicators to monitor different administrative indicators with respect to teachers in the jurisdiction. This program will have the Academic Year and Month filters. Other Filters like District, Block, Cluster, School will be picked up from RBAC. Following indicators will be available for specific roles as part of this program:

Role	Indicator	Chart Type	Applicable Filters

Role	Indicator	Chart Type	Applicable Filters
State Officer	Total Teachers	Big Number	Academic Year, Month
	District-wise Total Teachers	Table	Academic Year, Month
	Category-wise Total Teachers (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	Academic Year, Month
	Average Pupil-Teacher Ratio	Big Number	Academic Year, Month
	District-wise Average Pupil-Teacher Ratio	Table	Academic Year, Month
	Category-wise Average Pupil-Teacher Ratio (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	Academic Year, Month
District Officer	Total Teachers	Big Number	District, Academic Year, Month
	Block-wise Total Teachers	Table	District, Academic Year, Month
	Category-wise Total Teachers (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Academic Year, Month
	Average Pupil-Teacher Ratio	Big Number	District, Academic Year, Month
	Block-wise Average Pupil-Teacher Ratio	Table	District, Academic Year, Month
	District-wise Rank in Average Pupil-Teacher Ratio	Table	Academic Year, Month
	Category-wise Average Pupil-Teacher Ratio (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Academic Year, Month
Block Officer	Total Teachers	Big Number	District, Block, Academic Year, Month
	Cluster-wise Total Teachers	Table	District, Block, Academic Year, Month
	Category-wise Total Teachers (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Block, Academic Year, Month
	Average Pupil-Teacher Ratio	Big Number	District, Block, Academic Year, Month
	Cluster-wise Average Pupil-Teacher Ratio	Table	District, Block, Academic Year, Month
	Block-wise Rank in Average Pupil-Teacher Ratio	Table	District, Academic Year, Month
	Category-wise Average Pupil-Teacher Ratio (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Block, Academic Year, Month
Cluster Officer	Total Teachers	Big Number	District, Block, Cluster, Academic Year, Month
	School-wise Total Teachers	Table	District, Block, Cluster, Academic Year, Month
	Category-wise Total Teachers (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Block, Cluster, Academic Year, Month
	Average Pupil-Teacher Ratio	Big Number	District, Block, Cluster, Academic Year, Month
	School-wise Average Pupil-Teacher Ratio	Table	District, Block, Cluster, Academic Year, Month
	Cluster-wise Rank in Average Pupil-Teacher Ratio	Table	District, Block, Academic Year, Month
	Category-wise Average Pupil-Teacher Ratio (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Block, Cluster, Academic Year, Month
School Principal	Total Teachers	Big Number	District, Block, Cluster, School, Academic Year, Month
	Grade-wise Total Teachers	Table	District, Block, Cluster, School, Academic Year, Month
	Average Pupil-Teacher Ratio	Big Number	District, Block, Cluster, School, Academic Year, Month
	Grade-wise Average Pupil-Teacher Ratio	Table	District, Block, Cluster, School, Academic Year, Month
	School-wise Rank in Average Pupil-Teacher Ratio	Table	District, Block, Cluster, Academic Year, Month

Input Schema

Following schema will be required to enable the above-mentioned indicators in this program:

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	academic_year	string	year for which the student has enrolled is being recorded	Yyyy format to be used
2	grade	integer	Grade of the class	Restricted to values from 1 to 12
3	school_id	string	School ID as defined by the state registry	Restricted to 10 characters
4	school_category	string	Category which the school ID belongs to	Accepted Values - Primary, Upper Primary, Secondary, Senior Secondary
5	total_teachers	integer	Total teacher of the school	NA
6	students_enrolled	integer	Student enrolled for school	NA

Here is the upload template for this schema. You can use this template to fill the state data and upload it into cQube. Here is the sample template for this schema to see the kind of data and template in which cQube will accept data.

Student Assessment Program

This program entails indicators to monitor the performance of students in various assessments conducted in the classrooms. Following are the reports within this program:

Grades 1 to 3: This report shows the performance in various assessments for students of grades 1 to 3. This report will have the Academic Year, Month, Assessment Type (FA, SA, Boards), Assessment (FA1, FA2, SA1, SA2), Grade (1, 2, 3) and Subject filters. Other Filters like District, Block, Cluster, School will be picked up from RBAC. Following indicators will be available for specific roles as part of this report:

Role	Indicator	Chart Type	Applicable Filters

Role	Indicator	Chart Type	Applicable Filters
State Officer	Average % score in the selected exam (FA / SA)	Big Number	Academic Year, Month, Assessment Type, Assessment
	District-wise Average % score in the selected exam (FA / SA)	Table	Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	Academic Year, Month, Assessment Type, Assessment
	Grade-wise average % score in the selected exam (Grade 1, Grade 2, Grade 3)	Bar Chart	Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	Academic Year, Month, Assessment Type, Assessment, Grade (1, 2, 3)
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	Academic Year, Month, Assessment Type, Assessment, Grade (1, 2, 3), Subject
	Assessment-wise % score (FA / SA)	Bar Chart	Academic Year, Month, Assessment Type
District Officer	Average % score in the selected exam (FA / SA)	Big Number	District, Academic Year, Month, Assessment Type, Assessment
	Block-wise Average % score in the selected exam (FA / SA)	Table	District, Academic Year, Month, Assessment Type, Assessment
	District-wise Rank in Average % score in the selected exam (FA / SA)	Table	Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	District, Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	District, Academic Year, Month, Assessment Type, Assessment
	Grade-wise average % score in the selected exam (Grade 1, Grade 2, Grade 3)	Bar Chart	District, Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	District, Academic Year, Month, Assessment Type, Assessment, Grade (1, 2, 3)
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	District, Academic Year, Month, Assessment Type, Assessment, Grade (1, 2, 3), Subject
	Assessment-wise % score (FA / SA)	Bar Chart	District, Academic Year, Month, Assessment Type
Block Officer	Average % score in the selected exam (FA / SA)	Big Number	District, Block, Academic Year, Month, Assessment Type, Assessment
	Cluster-wise Average % score in the selected exam (FA / SA)	Table	District, Block, Academic Year, Month, Assessment Type, Assessment
	Block-wise Rank in Average % score in the selected exam (FA / SA)	Table	District, Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	District, Block, Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	District, Block, Academic Year, Month, Assessment Type, Assessment
	Grade-wise average % score in the selected exam (Grade 1, Grade 2, Grade 3)	Bar Chart	District, Block, Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	District, Block, Academic Year, Month, Assessment Type, Assessment, Grade (1, 2, 3)
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	District, Block, Academic Year, Month, Assessment Type, Assessment, Grade (1, 2, 3), Subject
	Assessment-wise % score (FA / SA)	Bar Chart	District, Block, Academic Year, Month, Assessment Type
Cluster Officer	Average % score in the selected exam (FA / SA)	Big Number	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	School-wise Average % score in the selected exam (FA / SA)	Table	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	Cluster-wise Rank in Average % score in the selected exam (FA / SA)	Table	District, Block, Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	Grade-wise average % score in the selected exam (Grade 1, Grade 2, Grade 3)	Bar Chart	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment, Grade (1, 2, 3)
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment, Grade (1, 2, 3), Subject
	Assessment-wise % score (FA / SA)	Bar Chart	District, Block, Cluster, Academic Year, Month, Assessment Type
School Principal	Average % score in the selected exam (FA / SA)	Big Number	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment
	Grade-wise Average % score in the selected exam (FA / SA for grades 1 to 3)	Table	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment
	School-wise Rank in Average % score in the selected exam (FA / SA)	Table	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment, Grade (1, 2, 3)
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment, Grade (1, 2, 3), Subject
	Assessment-wise % score (FA / SA)	Bar Chart	District, Block, Cluster, School, Academic Year, Month, Assessment Type
Class Teacher	Average % score in the selected exam (FA / SA)	Big Number	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type, Assessment
	Grade-wise Rank in Average % score in the selected exam (FA / SA for grades 1 to 3)	Table	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type, Assessment
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type, Assessment, Subject
	Assessment-wise % score (FA / SA)	Bar Chart	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type

Grades 4 to 8: This report shows the performance in various assessments for students of grades 4 to 8. This report will have the Academic Year, Month, Assessment Type (FA, SA, Boards), Assessment (FA1, FA2, SA1, SA2), Grade (4 to 8) and Subject filters. Other Filters like District, Block, Cluster, School will be picked up from RBAC. Following indicators will be available for specific roles as part of this report:

Role	Indicator	Chart Type	Applicable Filters

Role	Indicator	Chart Type	Applicable Filters
State Officer	Average % score in the selected exam (FA / SA)	Big Number	Academic Year, Month, Assessment Type, Assessment
	District-wise Average % score in the selected exam (FA / SA)	Table	Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	Academic Year, Month, Assessment Type, Assessment
	Grade-wise average % score in the selected exam (Grades 4 to 8)	Bar Chart	Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	Academic Year, Month, Assessment Type, Assessment, Grade (4 to 8)
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	Academic Year, Month, Assessment Type, Assessment, Grade (4 to 8), Subject
	Assessment-wise % score (FA / SA)	Bar Chart	Academic Year, Month, Assessment Type
District Officer	Average % score in the selected exam (FA / SA)	Big Number	District, Academic Year, Month, Assessment Type, Assessment
	Block-wise Average % score in the selected exam (FA / SA)	Table	District, Academic Year, Month, Assessment Type, Assessment
	District-wise Rank in Average % score in the selected exam (FA / SA)	Table	Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	District, Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	District, Academic Year, Month, Assessment Type, Assessment
	Grade-wise average % score in the selected exam (Grades 4 to 8)	Bar Chart	District, Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	District, Academic Year, Month, Assessment Type, Assessment, Grade (4 to 8)
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	District, Academic Year, Month, Assessment Type, Assessment, Grade (4 to 8), Subject
	Assessment-wise % score (FA / SA)	Bar Chart	District, Academic Year, Month, Assessment Type
Block Officer	Average % score in the selected exam (FA / SA)	Big Number	District, Block, Academic Year, Month, Assessment Type, Assessment
	Cluster-wise Average % score in the selected exam (FA / SA)	Table	District, Block, Academic Year, Month, Assessment Type, Assessment
	Block-wise Rank in Average % score in the selected exam (FA / SA)	Table	District, Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	District, Block, Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	District, Block, Academic Year, Month, Assessment Type, Assessment
	Grade-wise average % score in the selected exam (Grades 4 to 8)	Bar Chart	District, Block, Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	District, Block, Academic Year, Month, Assessment Type, Assessment, Grade (4 to 8)
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	District, Block, Academic Year, Month, Assessment Type, Assessment, Grade (4 to 8), Subject
	Assessment-wise % score (FA / SA)	Bar Chart	District, Block, Academic Year, Month, Assessment Type
Cluster Officer	Average % score in the selected exam (FA / SA)	Big Number	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	School-wise Average % score in the selected exam (FA / SA)	Table	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	Cluster-wise Rank in Average % score in the selected exam (FA / SA)	Table	District, Block, Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	Grade-wise average % score in the selected exam (Grades 4 to 8)	Bar Chart	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment, Grade (4 to 8)
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment, Grade (4 to 8), Subject
	Assessment-wise % score (FA / SA)	Bar Chart	District, Block, Cluster, Academic Year, Month, Assessment Type
School Principal	Average % score in the selected exam (FA / SA)	Big Number	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment
	Grade-wise Average % score in the selected exam (FA / SA for grades 4 to 8)	Table	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment
	School-wise Rank in Average % score in the selected exam (FA / SA)	Table	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment, Grade (4 to 8)
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment, Grade (4 to 8), Subject
	Assessment-wise % score (FA / SA)	Bar Chart	District, Block, Cluster, School, Academic Year, Month, Assessment Type
Class Teacher	Average % score in the selected exam (FA / SA)	Big Number	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type, Assessment
	Grade-wise Rank in Average % score in the selected exam (FA / SA for grades 4 to 8)	Table	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type, Assessment
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type, Assessment, Subject
	Assessment-wise % score (FA / SA)	Bar Chart	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type

Grades 9 to 12: This report shows the performance in various assessments for students of grades 9 to 12. This report will have the Academic Year, Month, Assessment Type (FA, SA, Boards), Assessment (FA1, FA2, SA1, SA2), Grade (9 to 12) and Subject filters. Other Filters like District, Block, Cluster, School will be picked up from RBAC. Following indicators will be available for specific roles as part of this report:

Role	Indicator	Chart Type	Applicable Filters

Role	Indicator	Chart Type	Applicable Filters
State Officer	Average % score in the selected exam (FA / SA / Boards)	Big Number	Academic Year, Month, Assessment Type, Assessment
	District-wise Average % score in the selected exam (FA / SA / Boards)	Table	Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	Academic Year, Month, Assessment Type, Assessment
	Grade-wise average % score in the selected exam (Grades 9 to 12)	Bar Chart	Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	Academic Year, Month, Assessment Type, Assessment, Grade (9 to 12)
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	Academic Year, Month, Assessment Type, Assessment, Grade (9 to 12), Subject
	Assessment-wise % score (FA / SA / Boards)	Bar Chart	Academic Year, Month, Assessment Type
District Officer	Average % score in the selected exam (FA / SA / Boards)	Big Number	District, Academic Year, Month, Assessment Type, Assessment
	Block-wise Average % score in the selected exam (FA / SA / Boards)	Table	District, Academic Year, Month, Assessment Type, Assessment
	District-wise Rank in Average % score in the selected exam (FA / SA / Boards)	Table	Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	District, Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	District, Academic Year, Month, Assessment Type, Assessment
	Grade-wise average % score in the selected exam (Grades 9 to 12)	Bar Chart	District, Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	District, Academic Year, Month, Assessment Type, Assessment, Grade (9 to 12)
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	District, Academic Year, Month, Assessment Type, Assessment, Grade (9 to 12), Subject
	Assessment-wise % score (FA / SA / Boards)	Bar Chart	District, Academic Year, Month, Assessment Type
Block Officer	Average % score in the selected exam (FA / SA / Boards)	Big Number	District, Block, Academic Year, Month, Assessment Type, Assessment
	Cluster-wise Average % score in the selected exam (FA / SA / Boards)	Table	District, Block, Academic Year, Month, Assessment Type, Assessment
	Block-wise Rank in Average % score in the selected exam (FA / SA / Boards)	Table	District, Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	District, Block, Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	District, Block, Academic Year, Month, Assessment Type, Assessment
	Grade-wise average % score in the selected exam (Grades 9 to 12)	Bar Chart	District, Block, Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	District, Block, Academic Year, Month, Assessment Type, Assessment, Grade (9 to 12)
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	District, Block, Academic Year, Month, Assessment Type, Assessment, Grade (9 to 12), Subject
	Assessment-wise % score (FA / SA / Boards)	Bar Chart	District, Block, Academic Year, Month, Assessment Type
Cluster Officer	Average % score in the selected exam (FA / SA / Boards)	Big Number	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	School-wise Average % score in the selected exam (FA / SA / Boards)	Table	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	Cluster-wise Rank in Average % score in the selected exam (FA / SA / Boards)	Table	District, Block, Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	Grade-wise average % score in the selected exam (Grades 9 to 12)	Bar Chart	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment, Grade (9 to 12)
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment, Grade (9 to 12), Subject
	Assessment-wise % score (FA / SA / Boards)	Bar Chart	District, Block, Cluster, Academic Year, Month, Assessment Type
School Principal	Average % score in the selected exam (FA / SA / Boards)	Big Number	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment
	Grade-wise Average % score in the selected exam (FA / SA / Boards for grades 9 to 12)	Table	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment
	School-wise Rank in Average % score in the selected exam (FA / SA / Boards)	Table	District, Block, Cluster, Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment, Grade (9 to 12)
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment, Grade (9 to 12), Subject
	Assessment-wise % score (FA / SA / Boards)	Bar Chart	District, Block, Cluster, School, Academic Year, Month, Assessment Type
Class Teacher	Average % score in the selected exam (FA / SA / Boards)	Big Number	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type, Assessment
	Grade-wise Rank in Average % score in the selected exam (FA / SA / Boards for grades 9 to 12)	Table	District, Block, Cluster, School, Academic Year, Month, Assessment Type, Assessment
	Performance Distribution in the selected exam (% students scored <35%, 35-50%, 50-65%, 65-80%, >=80%)	Bar Chart	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type, Assessment
	Gender-wise average % score in the selected exam (Male, Female, Other)	Bar Chart	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type, Assessment
	Subject-wise average % score (For master subject list in these grades with a grade filter)	Bar Chart	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type, Assessment
	LO-wise average % students answered correctly (For master LO list in these grades & subjects with grade & subject filters)	Table	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type, Assessment, Subject
	Assessment-wise % score (FA / SA / Boards)	Bar Chart	District, Block, Cluster, School, Grade, Academic Year, Month, Assessment Type

Input Schema

Following schema will be required to enable the above-mentioned indicators in this program:

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	student_id (masked)	integer	Masked unique ID for the students for whom the data is being entered	-
2	school_id	integer	Unique ID of the school for which the data is being entered	Max 13 Characters
3	date	string	Date which the data belongs to	YYYY-MM-DD
4	assessment_category	string	Category of Assessment which was conducted	FA, SA, Boards
5	assessment_type	string	Type of Assessment which was conducted	FA1, FA2, FA3, FA4, SA1, SA2, Boards
6	gender	string	Gender of the student for whom data is being entered	Male, Female, Other
7	grade	integer	Grade of the student for whom the data is being entered	1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12
8	subject	string	Subject of the assessment for which the data is being entered	-
9	total_marks	integer	Total maximum marks of the assessment conducted	-
10	total_obtained_marks	integer	Total obtained marks by the student for whom the data is being entered	<= total_marks

For LO-related information:

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	school_id	integer	Unique ID of the school for which the data is being entered	Max 13 Characters
2	date	integer	Date which the data belongs to	YYYY-MM-DD
3	assessment_category	string	Category of Assessment which was conducted	FA, SA, Boards
4	assessment_type	string	Type of Assessment which was conducted	FA1, FA2, FA3, FA4, SA1, SA2, Boards
5	grade	string	Grade of the student for whom the data is being entered	1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12
6	subject	string	Subject of the assessment for which the data is being entered	-
7	lo_id	string	Unique ID of the learning outcome for which the data is being entered	-
8	lo_name	string	Name of the learning outcome for which the data is being entered	-
9	total_students_participated	integer	Total number of students who participated in the assessment of the learning outcome	-
10	total_students_answered_correctly	integer	Total number of students who answered the learning outcome correctly	<= total_students_participated

Here is the upload template for this schema. You can use this template to fill the state data and upload it into cQube. Here is the sample template for this schema to see the kind of data and template in which cQube will accept data.

NIPUN Practice Program

This program entails indicators to monitor student engagement in practicing NIPUN Competencies and their results in becoming NIPUN. Following are the reports within this program:

Student Engagement: This report shows the engagement of students in grades 1 to 3 in practicing NIPUN Competencies. This report will have the Date Range filter. Other Filters like District, Block, Cluster, School, Grade will be picked up from RBAC. Following indicators will be available for specific roles as part of this report:

Role	Indicator	Chart Type	Applicable Filters

Role	Indicator	Chart Type	Applicable Filters
State Officer	Average % students practicing NIPUN Competencies for Hindi & Math at least once every month	Big Number	Date Range
	District-wise Average % students practicing NIPUN Competencies for Hindi & Math at least once every month	Table	Date Range
	Gender-wise % students practicing NIPUN Competencies for Hindi & Math at least once every month (Male, Female, Other)	Bar Chart	Date Range
	Grade-wise % students practicing NIPUN Competencies for Hindi & Math at least once every month (Grade 1, Grade 2, Grade 3)	Bar Chart	Date Range
	Month-wise trend of % students practicing NIPUN Competencies for Hindi & Math (last 6 months)	Bar Chart	-
	% students practicing NIPUN Competencies for Hindi vs Math at least once every month	Bar Chart	Date Range
	Average Duration of a NIPUN Practice session	Big Number	Date Range
District Officer	Average % students practicing NIPUN Competencies for Hindi & Math at least once every month	Big Number	District, Date Range
	Block-wise Average % students practicing NIPUN Competencies for Hindi & Math at least once every month	Table	District, Date Range
	District-wise Rank in Average % students practicing NIPUN Competencies for Hindi & Math at least once every month	Table	Date Range
	Gender-wise % students practicing NIPUN Competencies for Hindi & Math at least once every month (Male, Female, Other)	Bar Chart	District, Date Range
	Grade-wise % students practicing NIPUN Competencies for Hindi & Math at least once every month (Grade 1, Grade 2, Grade 3)	Bar Chart	District, Date Range
	Month-wise trend of % students practicing NIPUN Competencies for Hindi & Math (last 6 months)	Bar Chart	District
	% students practicing NIPUN Competencies for Hindi vs Math at least once every month	Bar Chart	District, Date Range
	Average Duration of a NIPUN Practice session	Big Number	District, Date Range
Block Officer	Average % students practicing NIPUN Competencies for Hindi & Math at least once every month	Big Number	District, Block, Date Range
	Cluster-wise Average % students practicing NIPUN Competencies for Hindi & Math at least once every month	Table	District, Block, Date Range
	Block-wise Rank in Average % students practicing NIPUN Competencies for Hindi & Math at least once every month	Table	District, Date Range
	Gender-wise % students practicing NIPUN Competencies for Hindi & Math at least once every month (Male, Female, Other)	Bar Chart	District, Block, Date Range
	Grade-wise % students practicing NIPUN Competencies for Hindi & Math at least once every month (Grade 1, Grade 2, Grade 3)	Bar Chart	District, Block, Date Range
	Month-wise trend of % students practicing NIPUN Competencies for Hindi & Math (last 6 months)	Bar Chart	District, Block
	% students practicing NIPUN Competencies for Hindi vs Math at least once every month	Bar Chart	District, Block, Date Range
	Average Duration of a NIPUN Practice session	Big Number	District, Block, Date Range
Cluster Officer	Average % students practicing NIPUN Competencies for Hindi & Math at least once every month	Big Number	District, Block, Cluster, Date Range
	School-wise Average % students practicing NIPUN Competencies for Hindi & Math at least once every month	Table	District, Block, Cluster, Date Range
	Cluster-wise Rank in Average % students practicing NIPUN Competencies for Hindi & Math at least once every month	Table	District, Block, Date Range
	Gender-wise % students practicing NIPUN Competencies for Hindi & Math at least once every month (Male, Female, Other)	Bar Chart	District, Block, Cluster, Date Range
	Grade-wise % students practicing NIPUN Competencies for Hindi & Math at least once every month (Grade 1, Grade 2, Grade 3)	Bar Chart	District, Block, Cluster, Date Range
	Month-wise trend of % students practicing NIPUN Competencies for Hindi & Math (last 6 months)	Bar Chart	District, Block, Cluster
	% students practicing NIPUN Competencies for Hindi vs Math at least once every month	Bar Chart	District, Block, Cluster, Date Range
	Average Duration of a NIPUN Practice session	Big Number	District, Block, Cluster, Date Range
School Principal	Average % students practicing NIPUN Competencies for Hindi & Math at least once every month	Big Number	District, Block, Cluster, School, Date Range
	Grade-wise Average % students practicing NIPUN Competencies for Hindi & Math at least once every month (Grade 1, Grade 2, Grade 3)	Table	District, Block, Cluster, School, Date Range
	School-wise Rank in Average % students practicing NIPUN Competencies for Hindi & Math at least once every month	Table	District, Block, Cluster, Date Range
	Gender-wise % students practicing NIPUN Competencies for Hindi & Math at least once every month (Male, Female, Other)	Bar Chart	District, Block, Cluster, School, Date Range
	Month-wise trend of % students practicing NIPUN Competencies for Hindi & Math (last 6 months)	Bar Chart	District, Block, Cluster, School
	% students practicing NIPUN Competencies for Hindi vs Math at least once every month	Bar Chart	District, Block, Cluster, School, Date Range
	Average Duration of a NIPUN Practice session	Big Number	District, Block, Cluster, School, Date Range
Class Teacher	Average % students practicing NIPUN Competencies for Hindi & Math at least once every month	Big Number	District, Block, Cluster, School, Grade, Date Range
	Grade-wise Rank in Average % students practicing NIPUN Competencies for Hindi & Math at least once every month	Table	District, Block, Cluster, School, Date Range
	Gender-wise % students practicing NIPUN Competencies for Hindi & Math at least once every month (Male, Female, Other)	Bar Chart	District, Block, Cluster, School, Grade, Date Range
	Month-wise trend of % students practicing NIPUN Competencies for Hindi & Math (last 6 months)	Bar Chart	District, Block, Cluster, School, Grade
	% students practicing NIPUN Competencies for Hindi vs Math at least once every month	Bar Chart	District, Block, Cluster, School, Grade, Date Range
	Average Duration of a NIPUN Practice session	Big Number	District, Block, Cluster, School, Grade, Date Range

Student Results: This report shows the performance of students in grades 1 to 3 in becoming NIPUN. This report will have the Date Range filter. Other Filters like District, Block, Cluster, School, Grade will be picked up from RBAC. Following indicators will be available for specific roles as part of this report:

Role	Indicator	Chart Type	Applicable Filters

Role	Indicator	Chart Type	Applicable Filters
State Officer	% students declared NIPUN via assessments	Big Number	Date Range
	District-wise % students declared NIPUN via assessments	Table	Date Range
	Month-wise trend of % students declared NIPUN	Bar Chart	-
	Gender-wise % NIPUN Students (Male, Female, Other)	Bar Chart	Date Range
	Grade-wise % NIPUN Students (Grade 1, Grade 2, Grade 3)	Bar Chart	Date Range
	% students declared NIPUN in Hindi vs in Math	Bar Chart	Date Range
District Officer	% students declared NIPUN via assessments	Big Number	District, Date Range
	Block-wise % students declared NIPUN via assessments	Table	District, Date Range
	District-wise Rank in % students declared NIPUN via assessments	Table	Date Range
	Month-wise trend of % students declared NIPUN	Bar Chart	District
	Gender-wise % NIPUN Students (Male, Female, Other)	Bar Chart	District, Date Range
	Grade-wise % NIPUN Students (Grade 1, Grade 2, Grade 3)	Bar Chart	District, Date Range
	% students declared NIPUN in Hindi vs in Math	Bar Chart	District, Date Range
Block Officer	% students declared NIPUN via assessments	Big Number	District, Block, Date Range
	Cluster-wise % students declared NIPUN via assessments	Table	District, Block, Date Range
	Block-wise Rank in % students declared NIPUN via assessments	Table	District, Date Range
	Month-wise trend of % students declared NIPUN	Bar Chart	District, Block
	Gender-wise % NIPUN Students (Male, Female, Other)	Bar Chart	District, Block, Date Range
	Grade-wise % NIPUN Students (Grade 1, Grade 2, Grade 3)	Bar Chart	District, Block, Date Range
	% students declared NIPUN in Hindi vs in Math	Bar Chart	District, Block, Date Range
Cluster Officer	% students declared NIPUN via assessments	Big Number	District, Block, Cluster, Date Range
	School-wise % students declared NIPUN via assessments	Table	District, Block, Cluster, Date Range
	Cluster-wise Rank in % students declared NIPUN via assessments	Table	District, Block, Date Range
	Month-wise trend of % students declared NIPUN	Bar Chart	District, Block, Cluster
	Gender-wise % NIPUN Students (Male, Female, Other)	Bar Chart	District, Block, Cluster, Date Range
	Grade-wise % NIPUN Students (Grade 1, Grade 2, Grade 3)	Bar Chart	District, Block, Cluster, Date Range
	% students declared NIPUN in Hindi vs in Math	Bar Chart	District, Block, Cluster, Date Range
School Principal	% students declared NIPUN via assessments	Big Number	District, Block, Cluster, School, Date Range
	Grade-wise % students declared NIPUN via assessments (Grade 1, Grade 2, Grade 3)	Table	District, Block, Cluster, School, Date Range
	School-wise Rank in % students declared NIPUN via assessments	Table	District, Block, Cluster, Date Range
	Month-wise trend of % students declared NIPUN	Bar Chart	District, Block, Cluster, School
	Gender-wise % NIPUN Students (Male, Female, Other)	Bar Chart	District, Block, Cluster, School, Date Range
	% students declared NIPUN in Hindi vs in Math	Bar Chart	District, Block, Cluster, School, Date Range
Class Teacher	% students declared NIPUN via assessments	Big Number	District, Block, Cluster, School, Grade, Date Range
	Grade-wise Rank in % students declared NIPUN via assessments	Table	District, Block, Cluster, School, Date Range
	Month-wise trend of % students declared NIPUN	Bar Chart	District, Block, Cluster, School, Grade
	Gender-wise % NIPUN Students (Male, Female, Other)	Bar Chart	District, Block, Cluster, School, Grade, Date Range
	% students declared NIPUN in Hindi vs in Math	Bar Chart	District, Block, Cluster, School, Grade, Date Range

Input Schema

Following schema will be required to enable the above-mentioned indicators in this program:

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	date	string	Date which the data belongs to	YYYY-MM-DD
2	school_id	integer	Unique ID of the school for which the data is being entered	Max 13 Characters
3	grade	string	Grade of the students for whom the data is being entered	1, 2, 3
4	subject	string	Subject of the assessment for which the data is being entered	Hindi, Maths
5	gender	string	Gender of the students for whom data is being entered	Male, Female, Other
6	no_of_students_participated	integer	Total number of students who participated in the assessment on the given date	-
7	avg_duration	integer	Average duration of a session of NIPUN Assessments (in minutes)	-
8	no_of_students_nipun	integer	Total number of students who were declared NIPUN out of the ones who participated	<= no_of_students_participated

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	date	string	Date which the data belongs to	YYYY-MM-DD
2	school_id	integer	Unique ID of the school for which the data is being entered	Max 13 Characters
3	grade	string	Grade of the students for whom the data is being entered	1, 2, 3
4	gender	string	Gender of the students for whom data is being entered	Male, Female, Other
5	no_of_students_participated_in_both_Hindi_Maths	string	Total number of students who participated in both Hindi and Math assessments on the given date	-
6	no_of_students_nipun_in_both_Hindi_maths	integer	Total number of students who were declared NIPUN in both Hindi and Math on the given date	-

Here is the upload template for this schema. You can use this template to fill the state data and upload it into cQube. Here is the sample template for this schema to see the kind of data and template in which cQube will accept data.

Teacher Mentoring Program

This program entails indicators to monitor compliance of mentoring visits in different schools by mentors. This program will have the Academic Year & Month filters. Other Filters like District, Block, Cluster, School will be picked up from RBAC. Following indicators will be available for specific roles as part of this program:

Role	Indicator	Chart Type	Applicable Filters

Role	Indicator	Chart Type	Applicable Filters
State Officer	Total Schools	Big Number	Academic Year, Month
	Total Available Mentors	Big Number	Academic Year, Month
	% unique schools/teachers visited by mentors in last month	Big Number	Academic Year, Month
	District-wise % unique schools/teachers visited by mentors in last month	Table	Academic Year, Month
	% mentors who met their target in the last month	Big Number	Academic Year, Month
	District-wise % mentors who met their target in the last month	Table	Academic Year, Month
	Average time spent in the mentoring visit (in mins)	Big Number	Academic Year, Month
	Category-wise number of schools/teachers visited (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	Academic Year, Month
District Officer	Total Schools	Big Number	District, Academic Year, Month
	Total Available Mentors	Big Number	District, Academic Year, Month
	% unique schools/teachers visited by mentors in last month	Big Number	District, Academic Year, Month
	Block-wise % unique schools/teachers visited by mentors in last month	Table	District, Academic Year, Month
	District-wise Rank in % unique schools/teachers visited by mentors in last month	Table	Academic Year, Month
	% mentors who met their target in the last month	Big Number	District, Academic Year, Month
	Block-wise % mentors who met their target in the last month	Table	District, Academic Year, Month
	District-wise Rank in % mentors who met their target in the last month	Table	Academic Year, Month
	Average time spent in the mentoring visit (in mins)	Big Number	District, Academic Year, Month
	Category-wise number of schools/teachers visited (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Academic Year, Month
Block Officer	Total Schools	Big Number	District, Block, Academic Year, Month
	Total Available Mentors	Big Number	District, Block, Academic Year, Month
	% unique schools/teachers visited by mentors in last month	Big Number	District, Block, Academic Year, Month
	Cluster-wise % unique schools/teachers visited by mentors in last month	Table	District, Block, Academic Year, Month
	Block-wise Rank in % unique schools/teachers visited by mentors in last month	Table	District, Academic Year, Month
	% mentors who met their target in the last month	Big Number	District, Block, Academic Year, Month
	Cluster-wise % mentors who met their target in the last month	Table	District, Block, Academic Year, Month
	Block-wise Rank in % mentors who met their target in the last month	Table	District, Academic Year, Month
	Average time spent in the mentoring visit (in mins)	Big Number	District, Block, Academic Year, Month
	Category-wise number of schools/teachers visited (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Block, Academic Year, Month
Cluster Officer	Total Schools	Big Number	District, Block, Cluster, Academic Year, Month
	Total Available Mentors	Big Number	District, Block, Cluster, Academic Year, Month
	% unique schools/teachers visited by mentors in last month	Big Number	District, Block, Cluster, Academic Year, Month
	School-wise % unique teachers visited by mentors in last month*	Table	District, Block, Cluster, Academic Year, Month
	Cluster-wise Rank in % unique schools/teachers visited by mentors in last month	Table	District, Block, Academic Year, Month
	% mentors who met their target in the last month	Big Number	District, Block, Cluster, Academic Year, Month
	Cluster-wise Rank in % mentors who met their target in the last month	Table	District, Block, Academic Year, Month
	Average time spent in the mentoring visit (in mins)	Big Number	District, Block, Cluster, Academic Year, Month
	Category-wise number of schools/teachers visited (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Block, Cluster, Academic Year, Month
School Principal*	% unique teachers visited by mentors in last month*	Big Number	District, Block, Cluster, School, Academic Year, Month
	School-wise Rank in % unique teachers visited by mentors in last month*	Table	District, Block, Cluster, Academic Year, Month
	Average time spent in the mentoring visit (in mins)*	Big Number	District, Block, Cluster, School, Academic Year, Month

*These indicators will be shown if teacher-level mentoring data is collected in the state

Input Schema

Following schema will be required to enable the above-mentioned indicators in this program:

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	date	string	Date when the data was recorded	Yyyy-mm-dd format to be used
2	school_id	string	Unique ID for the School for which the data is being entered	Restricted to 10 characters
3	total_mentors	integer	Total number of mentors available	NA
4	mentors_met_their_target	integer	Total number of mentors who met their target in the given month	<= total_mentors

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	date	string	Date when the data was recorded	Yyyy-mm-dd format to be used
2	visited_school_id	string	Unique ID for the school that was visited	Max 10 characters
3	school_category	string	Category which the school ID belongs to	Accepted Values - Primary, Upper Primary, Secondary, Senior Secondary
4	average_duration	number	Average duration of the visit (in mins)	time in minutes

If teacher-level data is collected for mentoring in the state:

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	date	string	Date when the data was recorded	Yyyy-mm-dd format to be used
2	school_id	string	Unique ID for the school for which the data is being entered	Restricted to 10 characters
4	school_category	string	Category which the school ID belongs to	Accepted Values - Primary, Upper Primary, Secondary, Senior Secondary
3	total_teachers	integer	Total number of teachers in the school	NA
4	unique_teachers_visited	integer	Total number of teachers visited in the school	<= total_teachers
5	average_visit_duration_in_min	number	Average duration of the visit (in mins)	time in minutes

Here is the upload template for this schema. You can use this template to fill the state data and upload it into cQube. Here is the sample template for this schema to see the kind of data and template in which cQube will accept data.

Review Meetings Program

This program entails indicators to monitor compliance of monthly review meetings being conducted at all levels. This program will have the Academic Year & Month filters. Other Filters like District, Block will be picked up from RBAC. Following indicators will be available for specific roles as part of this program:

Role	Indicator	Chart Type	Applicable Filters

Role	Indicator	Chart Type	Applicable Filters
State Officer	% districts with review meeting conducted last month	Big Number	Academic Year, Month
	District-wise status of review meeting conducted last month	Table	Academic Year, Month
	District-wise % blocks conducted meeting last month	Table	Academic Year, Month
District Officer	% blocks with review meeting conducted last month	Big Number	District, Academic Year, Month
	Block-wise status of review meeting conducted last month	Table	District, Academic Year, Month
	Block-wise % clusters conducted meeting last month
Block Officer	% Clusters with review meeting conducted last month	Big Number	District, Block, Academic Year, Month
Block Officer	Cluster-wise status of review meeting conducted last month	Table	District, Block, Academic Year, Month

Input Schema

Following schema will be required to enable the above-mentioned indicators in this program:

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	date	string	Date of the meeting conducted at the district	YYYY-MM-DD
2	district_id	string	Unique ID of the district	Restricted to 3 characters
3	meeting_conducted	string	Whether the meeting is conducted or not	Yes, No

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	date	string	Date of the meeting conducted at the block	YYYY-MM-DD
2	block_id	string	Unique ID of the block	Restricted to 5 characters
3	meeting_conducted	string	Whether meeting is conducted or not	Yes, No

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	date	string	Date of the meeting conducted at the cluster	YYYY-MM-DD
2	cluster_id	string	Unique ID of the block	Restricted to 9 characters
3	meeting_conducted	string	Whether meeting is conducted or not	Yes, No

Here is the upload template for this schema. You can use this template to fill the state data and upload it into cQube. Here is the sample template for this schema to see the kind of data and template in which cQube will accept data.

Dimensions Master

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	school_id	string	School ID as defined by the state registry	Restricted to 10 characters
2	cluster_id	string	Cluster ID as defined by the state registry	Restricted to 9 characters
3	block_id	string	Block ID as defined by the state registry	Restricted to 5 characters
4	district_id	string	District ID as defined by the state registry	Restricted to 3 characters
5	state_id	string	State ID as defined by the state registry	Restricted to 2 characters

Here is the upload template for this schema. You can use this template to fill the state data and upload it into cQube. Here is the sample template for this schema to see the kind of data and template in which cQube will accept data.

Dimensions School

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	grade	integer	Grade for which the data is being entered	Restricted to values from 1 to 12
2	school_id	string	School ID as defined by the state registry	Restricted to 10 characters
3	school_name	string	School Name as defined by the state registry	-
4	school_type	string	school type as defined by the state registry	Accepted Values - rural,urban
5	school_category	string	Category which the school ID belongs to	Accepted Values - Primary, Upper Primary, Secondary, Senior Secondary
6	latitude	number	Provide the geo-coordinates of the school	-
7	longitude	number	provide the geo-coordinates of the school	-

Here is the upload template for this schema. You can use this template to fill the state data and upload it into cQube. Here is the sample template for this schema to see the kind of data and template in which cQube will accept data.

Dimensions Cluster

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	cluster_id	string	Cluster ID as defined by the state registry	Restricted to 9 characters
2	cluster_name	string	Cluster Name as defined by the state registry	-
3	latitude	number	provide the geo-coordinates of the cluster	-
4	longitude	number	provide the geo-coordinates of the cluster	-

Here is the upload template for this schema. You can use this template to fill the state data and upload it into cQube. Here is the sample template for this schema to see the kind of data and template in which cQube will accept data.

Dimensions Block

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	block_id	string	Block ID as defined by the state registry	Restricted to 5 characters
2	block_name	string	Block Name as defined by the state registry	-
3	latitude	number	provide the geo-coordinates of the block	-
4	longitude	number	provide the geo-coordinates of the block	-

Here is the upload template for this schema. You can use this template to fill the state data and upload it into cQube. Here is the sample template for this schema to see the kind of data and template in which cQube will accept data.

Dimensions District

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	district_id	string	District ID as defined by the state registry	Restricted to 3 characters
2	district_name	string	District Name as defined by the state registry	-
3	latitude	number	Provide the geo-coordinates of the district	-
4	longitude	number	Provide the geo-coordinates of the district	-

Here is the upload template for this schema. You can use this template to fill the state data and upload it into cQube. Here is the sample template for this schema to see the kind of data and template in which cQube will accept data.

Dimensions State

#	Column Name	Data Type	Description	Validation

#	Column Name	Data Type	Description	Validation
1	state_id	string	State ID as defined by the state registry	Restricted to 2 characters
2	state_name	string	State Name as defined by the state registry	-
3	latitude	number	Provide the geo-coordinates of the state	-
4	longitude	number	Provide the geo-coordinates of the state	-

Here is the upload template for this schema. You can use this template to fill the state data and upload it into cQube. Here is the sample template for this schema to see the kind of data and template in which cQube will accept data.