Report Showing Under, Over and Official Age Enrollments Online Dashboard [2020:M]

[Ghislain Hachey]

Refer to the jasper version at #332 for details

[Brian Lewis]

First thing to be clear on here is the definition of Under, Over at Official Age.

There are two ways of looking at this:

by level of education;

by class level.

For a Level of Education e.g. primary, there is an age range e.g. 6-13 (Grade 1 to 8)

All primary enrolled children between ages 6-13 are at Official Age. This is how NER is calculated for Primary education. This is the usual way of looking at over-age and under-age.

Conversely, for each class level, there is an official age e.g. Grade 4 = Age 9. You can then measure how many children are at the official age for the class they are in, and from this calculate, for each year of education, Class Level NER. It's also meaningful to consider Class Level GER - ie the enrolment in a single Class Level over the population of official age for that class level - a single year of age.

Note that there is no direct relation between class level NERs and Education Level NER. To see this, note that a 12-y-o child in Grade 1 is At Official Age for Primary ( and contributes to NER) but over age for their class level. So in particular, you CANNOT add class level NERs to get Education Level NER.

Examining Class Level NERs, across a range of class levels, provide information about flow.

This Excel presentation shows a lot of information about age analysis of enrolments; and could be good to incorporate.

Age participation Rate is the percentage of children of a given age that are in school - at any level. So, the percentages in tha table add across - not down - noting that for younger children, some of the age participation is in ECE and so not shown.

[Ghislain Hachey]

@jeremy_kells please if you could integrate this when doing this. This analysis will go in

• Individual School dashboard
• Schools dashboard

I also created a new issue for the JasperReports version of this in #460 for @rupam_bhardwaj

[Ghislain Hachey]

@Brian Lewis this is not priority for this school year. Do not work on it.