cQube v5.0 Beta - Schema Documentation

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

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

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

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

Add label