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