Tag Archives: Data

The story of how same marks can lead to two different grades!

Author : Hariharan

It was a sunny day and I felt my car’s AC air gushing at my face. It was in no time, the AC beat the heat but it was temporary. The heat came from a phone call then. The person X of Hive Public School at the other end tells me, “Hari all the overall grade calculation for class 6 is wrong”. I wanted to reassure whether she was telling what I heard, so I told, “Could you please repeat it ma’am?”. “Hari all the overall grade calculation for class 6 is wrong. What we have given in the sheet as aggregation what Report Bee has done doesn’t match at all”. I took deep breath which I don’t do often and claimed, “Your’s is a CBSE school right?”, the answer was ‘Yes’. “We do calculation based on the CCE* guidelines”. And the conversation went on till I agreed to change the grades for deviating students. Now, you would have got it, most of the time we end up abiding customer needs.

Usually the assumption for any CBSE school would comply to CCE guidelines. This was an incident on that assumption which proved costly. The next few passages, I will be explaining the math involved in our calculation and why the deviation happened in the first place. So if you are not really a math person and it bores you, feel free to jump to the last paragraph.

Our mode of calculation (CCE prescribed) :

captureTo your left is the grade calculation image. They say grade is calculated based on the marks scaled up/down to 100, basically percentage. Each grade also has a grade point pinned to it as well. Each subject’s grade for a term is calculated by aggregating the marks procured in the numerator, the total in the denominator and multiplying it by 100. That would give the percentage value for it to be displayed as grade in the report card. In this way individual subjects will have marks and the respective grades. To calculate the overall grade, the individual subject’s grade is the percentage expressed out of total marks in term all subjects inclusive. Below is the image explaining our calculation for the specific student Bee.


Hive Public School’s mode of calculation (The heart wrecking phone call) :

There is no legitimate image for this to be referred. The only place where the calculation can be found out is as fields shared by the school. Each subject’s mark is grade with percentage as base. Till this point they resemble our mode of calculation. After this, they do a calculation which you might not see in any CBSE school doing. For the grade procured, the corresponding grade point is referred and this is done for all the subjects. The grade points are summed up and divided by the number of subjects included part of their academics. This gives an average grade point out of 10. The overall grade referred is based on the grade point’s range. Below is the image explaining Hive Public School’s calculation for specific student Bee.


The teachers of the school had gone for a workshop three years back and had brought this take away of overall grade calculation. Had the overall grade calculation methodology been mentioned in the CCE guidelines, this problem wouldn’t have come. So, here we came with a hack. The school identified students with deviating grades and gave it to us. We changed the grades manually through CSS, the tool which is normally used to feast your eyes with vividness. Because of this, there was 956 lines of code at the back end. Also, we ended up editing the grades of 20% of students in a class on an average.

*CCE – Continuous and comprehensive evaluation is a process of assessment, mandated by the Right to Education Act, of India. Student’s marks will be replaced by grades which will be evaluated through a series of curricular and extra-curricular evaluations along with academics. The aim is to decrease the workload on the student by means of continuous evaluation by taking number of small tests throughout the year in place of single test at the end of the academic program. Only Grades are awarded to students based on work experience skills, dexterity, innovation, steadiness, teamwork, public speaking, behavior, etc. to evaluate and present an overall measure of the student’s ability.

Boys perform well in Co-ed than single-sex schools

We belong to an era of data science, cognitive psychology and artistic visualization. At Report Bee, we performed an extensive analysis on single sex schools vis-a-vis co-ed schools and found that in Tamil Nadu, boys are performing better in co-ed schools than boys-only schools.

We took the last 4 years data (2012- 2015), and the findings showed us a trend.

In 2015, among the 6258 schools that appeared for the 12th board exams, the pass percentage of boys only schools is 59.8 whereas the pass percentage of girls only schools is 66.2. But in case of the co-ed schools, the pass percentage of boys and girls increases to 63.6 and 66.8 respectively.

In class 12, we found that boys in Co-ed schools on an average scoring 5.3% more than their counterparts in boys-only schools. Through a detailed analysis on each of the revenue districts, we observed a maximum average difference of 13.5% (~162 marks) in a Perambalur.

KANYAKUMARI, DINDIGUL, OOTY, NAMAKKAL, TRICHY, NAGAPATTINAM seem to have boys in boys-only school performing better than Co-ed schools, reason here is these districts are literacy districts and they perform well in any given condition.

When tested on girls in co-ed school and girls only school, there was an increase of 0.6%.It showed that girls are performing better than boys irrespective of being a single sex school or a Co-ed school.

Similarly In class 10, we found that boys in almost all the revenue districts in Tamil Nadu are performing better in Co-ed schools. Except Virudhunagar, all the other districts show a higher performance in average marks scored by the boys studying in co-ed school.

The performance of the students can vary from various reasons like peer pressure, discipline, employability, infrastructure, adolescence and so on.

Tamilnadu 12th Board – Spatial Analysis

12th Std boys12th std girls

Green colored districts are those in which the boys in Co-ed school have obtained a better average% than the boys-only schools. Red colored are the districts where the boys in boys-only schools have scored a higher average% than the Co-ed schools

Tamilnadu 10th Board – Spatial Analysis

10th std boys10th std girls

Power of Data Digitisation

Author: Venky

Venky_data DigitVenky_data Digit2


I recently went for an eye check-up to a well-known hospital. At the same place, eight years ago, there was another eye hospital where I had gone for a check-up and got a prescription for my glasses. By this time, a new management had taken over the place. When the receptionist asked whether this was my first visit to the hospital, considering the new management, I said, “Yes”.

A few minutes after I filled in my details, the receptionist came to me and said, “it is not your first visit to this hospital. You had been here eight years ago.” She also showed my profile and the prescription provided to me back then. I was a little surprised because I never thought that such old data could still exist with the new management after all those years. The power of data digitization dawned on me that very moment and a scenario crossed my mind.

I imagined a student who had applied for admission in a new school but was yet to submit the hard copies of marks sheets from her previous school. Next day, when she went to submit her marks, the school said that they had already viewed her profile and her performance in the previous school and that they were happy to admit her in their school. I could feel the surprise of this student and her parents, just like I was when the old hospital with new management pulled out my records from 8 long years ago. Looks like we are not far from experiencing this power of data digitisation for real!