Null propagation in Enrolments JasperReport

[Brian Lewis]

In School enrolments by Ed Level and Gender Report, null values should be displayed as blank, and should not propagate into total columns

@nlangidrik

[Ghislain Hachey]

This report is now obsolete by the new School Report Card. But I believe the same issue is there as well so I am leaving this to re-assign

[Ghislain Hachey]

Fix this in the new School Report Card and then completely delete the old original school report card.

[Shraddha Tambe]

This issue is not there in the new School Report Card Version (we are using Crosstab component there, which will show 0 if not records are found for any Education Level/Gender combination)

[Brian Lewis]

@shraddha_tambe :

Some minor points.... terminology: we refer to the specific classes G1, G2 as Class Levels. They are held in the table lkpLevels, and each class level has a Year of Education; which is how many years you are at school to get to that level. By convention, Year of Education = 1 for the first year of primary education; so early childhood preceding that can have Year of Education 0 or even -1.

Education Level refers to the broader bands of education: primary education, junior secondary, senior secondary, ECE etc.

An education level is chronological - it is defined by a Start and End value for Year of Education. e.g. Primary Education covers years 1 to 8.

Education Levels are held in the tables lkpEducationLevels, lkpEducationLevels,Alt , lkpEducationLevelsAlt2. In other words, you can, for reporting purposes, divide up the full course of education in 3 different ways. For example, It is common to report on Primary Education and Junior Secondary together as Basic Education.

Given an official start age for primary educaction - ie the official age for Year of Education 1, then each education level maps to an age range - and hence to a well-defined set of population numbers. So, we can define Enrolment Ratios for Education Levels.

We can define enrolment ratios for class levels as well, but this is less common. We do use the official age for each class level to cound pupils at official Age, and Over Age and Under Age pupils.

When you are presenting class levels in an array or table, they should always be order by Year of Education ascending. You'll see in your screen shot above that GK (ie kindergarten, year of education = 0) is at the bottom, it should be at the top.

Also, personally I think it is better to suppress the display of 0 values in tables like this; see the image in issue #589. Suppressing the 0s makes the flow of values immediately visually evident - is there a wide spread of ages in a class? Are there outliers to investigate?

[Shraddha Tambe]

I have taken care of the ordering of the Class Levels in this and other sub-reports which have Class Levels.

Should I rename this chart to School Enrollments by “Class Level” and Gender ? Or are you suggesting, we change this report to show data by “education levels” ?

[Ghislain Hachey]

@shraddha_tambe Yes, you can rename “Education Level” to “Class Level”.

[Shraddha Tambe]

Sorry, the new School report card already names this report - “2.1 Student Enrollment by Grade and Gender”

Changes related to this ticket are done, can be deployed alongwith Issue#572