Differences

This shows you the differences between two versions of the page.

--- emis_user_manual_data_warehouse [2023/12/13 20:52] – [Teachers] ghachey
+++ emis_user_manual_data_warehouse [2024/12/23 11:16] (current) – [Flows] ghachey
@@ Line 175: / Line 175: @@
   * **Enrol**: the enrolments (e.g. Grade 5 enrolments for 2018-19)
-  * **Rep**: the repeaters (e.g. Grade 5 repeaters for 2018-19)
+  * **Rep**: the repeaters (e.g. Grade 5 repeaters for 2018-19. In other words, Grade 5 cohort of previous school year staying in Grade 5)
-  * **RepNY**: the repeaters for the next school year (e.g. Grade 5 repeaters for 2019-20)
+  * **RepNY**: the repeaters for the next school year (e.g. Grade 5 repeaters for 2019-20.)
-  * TroutNY: the transfers out for the next school year (e.g. Grade 5 transfers out for 2019-20)
+  * **TroutNY**: the transfers out for the next school year (e.g. Grade 5 transfers out for 2019-20)
   * **EnrolNYNextLevel**: the enrolments for the next school year into the next class level/grade (e.g. Grade 6 enrolments for 2019-20)
   * **RepNYNextLevel**: the repeaters for the next school year into the next class level/grade (e.g. Grade 6 repeaters for 2019-20)
-  * TrinNYNextLevel: the transfers in for the next school year (e.g. Grade 6 transfers in for 2019-20)
+  * **TrinNYNextLevel**: the transfers in for the next school year (e.g. Grade 6 transfers in for 2019-20)
-The formulas are either identical or mathematical equivalent to the ones in the UNESCO UIS Education Indicators
+The formulas are either identical or mathematical equivalent (or near equivalent) to the ones in the UNESCO UIS Education Indicators
 Technical guidelines.
-  * Promotion Rate = (EnrolNYNextLevel - RepNYNextLevel) / Enrol
+  * **Promotion Rate** $$= \frac{(EnrolNYNextLevel - RepNYNextLevel)}{Enrol}$$
-  * Repetition Rate = RepNY / Enrol
+  * **Repetition Rate** $$= \frac{RepNY} {Enrol}$$
-  * Survival Rate (year on year; not to a particular year) = Promotion Rate / ( 1 - Repetition Rate)
+  * **Survival Rate** (year on year; not to a particular year) $$= \frac{Promotion Rate}{( 1 - Repetition Rate)}$$ which also $$= \frac{\frac{(EnrolNYNextLevel - RepNYNextLevel)}{Enrol}}{( 1 - \frac{RepNY}{Enrol})}$$ which also $$= \frac{EnrolNYNextLevel - RepNYNextLevel}{Enrol - RepNY}$$
-  * Dropout Rate = 1 - (Promotion Rate + Repetition Rate)
+  * **Dropout Rate** = $$1 - (Promotion Rate + Repetition Rate)$$
-  * Transition Rate (year on year) = (EnrolNYNextLevel - RepNYNextLevel) / Enrol
+<note important>
+Note that the formula used in some UN publications is more like this Survival by Grade Level (year on year) $$= \frac{(EnrolNYNextLevel - RepNYNextLevel)}{Enrol}$$ while we use $$\frac{(EnrolNYNextLevel - RepNYNextLevel)}{Enrol - RepNY}$$
+The difference being that we take into consideration the repeaters from the original cohort of the first year which will not be illegible for promotion. It provides a slightly more precise survival rate when data is accurately collected.
+</note>
 A sample workbook showing how these many flow indicators can be calculated including some analysis is included below.