Page Comparison

...

#	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	gender	string	Gender for which data is being entered	Accepted Values - Male, Female, Other	5	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.

...

#	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
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.

...

#	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
34grade	school_category	integerstring	Grade of the class	Restricted to values from 1 to 12	4	gender	string	Gender of the student 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	student_enrolment	integer	Student enrolled for schoolstring	Gender of the student	Accepted Values - Male, Female, Other
7	CwSNcwsn_enrollmentsenrolled	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.

...

#	Column Name	Data Type	Description	Validation

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

State Officer

Total Teachers

Big Number

Academic Year, Month

District-wise Total Teachers

Table

Academic Year, Month

Category-wise Total Teachers (


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

)

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,

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:

School Principal

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 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 District Officer	Total Teachers	Big Number	District, Block, Academic Year, Month
	ClusterBlock-wise Total Teachers	Table	District, Block, Academic Year, Month
	Category-wise Total Teachers (Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Block, Academic Academic Year, Month
	Average Pupil-Teacher Ratio	Big Number	District, Block, Academic Year, Month
	ClusterBlock-wise Average Pupil-Teacher Ratio	Table	District, Block, Academic Year, Month
	BlockDistrict-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 Block Officer	Total Teachers	Big Number	District, Block, Cluster, Academic Year, Month
	SchoolCluster-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
	SchoolCluster-wise Average Pupil-Teacher Ratio	Table	District, Block, Cluster, Academic Year, Month
	ClusterBlock-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
Cluster Officer	Total Teachers	Big Number	District, Block, Cluster, Academic Year, Month
	School-wise Total Teachers	Table	District, Block, Cluster, Academic Year, Month
	GradeCategory-wise Total Teachers Table(Primary, Upper Primary, Secondary, Senior Secondary)	Bar Chart	District, Block, Cluster, School, Academic Year, Month
	Average Pupil-Teacher Ratio	Big Number	District, Block, Cluster, School, Academic Year, Month
	GradeSchool-wise Average Pupil-Teacher Ratio	Table	District, Block, Cluster, School, Academic Year, Month
	SchoolCluster-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

Input Schema

...

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

...


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.

...

#	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.

...

#	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.

...

*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: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
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
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
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
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
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
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
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
1

academic

school_

year

3

district_id

integer

Unique ID for the District for which the data is being entered

-

4

id

integer

Year for which the data is being entered

-

2

month

string

Month for which the data is being entered

-

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

integer

string

Unique

Block ID

for the Block for which the data is being entered

-

5

cluster

as defined by the state registry	Restricted to 5 characters
4	district_id

integer

string

Unique

District ID

for the Cluster for which the data is being entered

-

6

total_mentors

integer

Total number of mentors available

-

7

mentors_met_their_target

integer

Total number of mentors who met their target in the given month

<= total_mentors

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
1

date

grade

string

integer

Date

Grade for which the data is being entered

YYYY-MM-DD

2

visited_school_id

integer

Unique ID for the school that was visited

Max 13 characters

3

average_duration

integer

Average duration of the visit (in mins)

-

...

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
1

date

cluster_id

string

Date for which the data is being entered

YYYY-MM-DD

Cluster ID as defined by the state registry	Restricted to 9 characters
2

school

cluster_

id

name

integer

Unique ID for the school for which the data is being entered

Max 13 characters

3

total_teachers

integer

Total number of teachers in the school

string	Cluster Name as defined by the state registry	-
3	latitude	number	provide the geo-coordinates of the cluster	-
4

unique_teachers_visited

integer

Total number of teachers visited in the school

<= total_teachers

5

average_visit_duration_in_min

integer

Average duration of the visit (in mins)

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.

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

...

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 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 Officer

...

% Clusters with review meeting conducted last month

...

Big Number

...

District, Block, Academic Year, Month

...

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

...

1

...

date

...

string

...

Date of the meeting conducted at the district

...

YYYY-MM-DD

...

2

...

district_id

...

integer

...

Unique ID of the district

...

-

...

3

...

meeting_conducted

...

string

...

Whether the meeting is conducted or not

...

Yes, No

...

#

...

Column Name

...

Data Type

...

Description

...

Validation

...

1

...

date

...

string

...

Date of the meeting conducted at the block

...

YYYY-MM-DD

...

2

...

block_id

...

integer

...

Unique ID of the block

...

-

...

3

...

meeting_conducted

...

string

...

Whether meeting is conducted or not

...

will accept data.

Dimensions Block

#	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
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
1

date

state_id

string

Date of the meeting conducted at the cluster

YYYY-MM-DD

2

cluster_id

integer

Unique ID of the block

-

3

meeting_conducted

string

Whether meeting is conducted or not

Yes, No

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.

Versions Compared

Old Version 13

New Version Current

Key

Teacher Statistics Program

Teacher Statistics Program

Input Schema

Input Schema

Input Schema

Input Schema

Review Meetings Program

Input Schema

Dimensions Master

Dimensions School

Dimensions Cluster

Review Meetings Program

Input Schema

Dimensions Block

Dimensions District

Dimensions State