Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

#

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

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

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

2

school_id

string

School ID as defined by the state registry

Restricted to 10 characters

3

grade

integer

Grade of the class

Restricted to values from 1 to 12

4

gender

string

Gender of the student 

5

student_category

string

Category of the school as defined by the school

6

student_enrolment

integer

Student enrolled for school

7

CwSN_enrollments

integer

Child with special needed 

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

school_id

string

School ID as defined by the state registry

Restricted to 10 characters

3

grade

integer

Grade of the class

Restricted to values from 1 to 12

4

gender

string

Gender of the student 

Accepted Values - Male, Female, Other

5

student_category

string

Category of the school as defined by the school

Accepted values- SC,ST,OBC,others,general

6

student_enrolled

integer

Student enrolled for school

NA

7

cwsn_enrolled

integer

Child with special needed 

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.

...

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

#

Column Name

Data Type

Description

ValidationType

Description

Validation

1

academic_year

string

year for which the student has enrolled is being recorded

Yyyy format to be used

2

school_id

string

School ID as defined by the state registry

Restricted to 10 characters

3

grade

integer

Grade of the class

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

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

academic_year

integer

Year for which the data is being entered

-

2

monthdate

string

Month for which Date when the data is being enteredwas recorded

-

3

district_id

integer

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

-

4

block_id

integerYyyy-mm-dd format to be used

2

school_id

string

Unique ID for the Block School for which the data is being entered

-

5

cluster_id

integer

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

-

6

Restricted to 10 characters

3

total_mentors

integer

Total number of mentors available

-NA

74

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 for which when the data is being enteredYYYY-MM-DDwas recorded

Yyyy-mm-dd format to be used

2

visited_school_id

integerstring

Unique ID for the school that was visited

Max 13 10 characters

3

school_category

string

Category which the school ID belongs to

Accepted Values - Primary, Upper Primary, Secondary, Senior Secondary

4

average_duration

integernumber

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 for which when the data is being enteredYYYY-MM-DDwas recorded

Yyyy-mm-dd format to be used

2

school_id

integerstring

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

Max 13 characters

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

integernumber

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.

...

#

Column Name

Data Type

Description

Validation

1

date

string

Date of the meeting conducted at the district

YYYY-MM-DD

2

district_id

integerstring

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

integerstring

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

integerstring

Unique ID of the block

-Restricted to 9 characters

3

meeting_conducted

string

Whether meeting is conducted or not

Yes, No

...