Differences

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

--- emis_user_manual_data_warehouse [2024/12/23 08:03] – [Flows] 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)
-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). This also equals = ((EnrolNYNextLevel - RepNYNextLevel) / Enrol) / ( 1 - RepNY / Enrol) which in turn equals to EnrolNYNextLevel - RepNYNextLevel / Enrol - RepNY
+  * **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)$$
 <note important>
-Note that the formula used in some UN publications is more like this Survival by Grade Level (year on year) = (EnrolNYNextLevel - RepNYNextLevel) / Enrol while we use 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 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>