Differences

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

--- emis_user_manual_data_warehouse [2022/02/17 15:38] – [Enrolments] 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.
@@ Line 208: / Line 212: @@
 The table warehouse.TeacherLocation sits on the transition between:
-  * teacher reporting derived from the School Surveys; and
+  * teacher reporting derived from the School Surveys (i.e. PDF annual surveys, Excel Workbook); and
-  * teacher reporting derived from Appointments, and teacher training records from the web UI.
+  * teacher reporting derived from Appointments, and teacher training records from the web UI (i.e. manual entry of records in UI).
-The tables Establishment and Teacher Appointments define the structure of the teaching establishment: i.e. the collection of teaching positions, and the teachers that are appointed to those positions.  This is where we expect the teachers to be.
-The TeacherSurvey table holds the records of where teachers are reported to be by the School Survey. This is where teachers are. Ideally, TeacherSurvey functions as a verification of TeacherAppointments. We can check that teachers are where they are supposed to be and report exceptions. In simpler setups only the surveys are used and not the Establishment/Appointment teacher planning tool.
+<note important>The tables Establishment and Teacher Appointments define the structure of the teaching establishment: i.e. the collection of teaching positions, and the teachers that are appointed to those positions.  This is where we expect the teachers to be. The Establishment and Appointment framework is not currently in use by most users but data is simply gathered using the survey method.</note>
-Regardless of the setup, this table brings these two sets of data together (In fact considerably more detailed views in the Establishment planning component can also perform this reconciliation.) In some systems, we may have the requirement to report on teacher number directly from Appointments, rather than from TeacherSurvey.
+<note important>The TeacherSurvey table holds the records of where teachers are reported to be by the School Survey. This is where teachers are. Ideally, TeacherSurvey functions as a verification of TeacherAppointments. We could check that teachers are where they are supposed to be and report exceptions. In simpler setups (all of them currently) only the surveys are used and not the Establishment/Appointment teacher planning tool.</note>
-In there there is a record for each teacher for each year they were active. It contains the gender, DoB, age group of teacher, the school, role, source (i.e. an appointment or reported through survey), whether the teacher is qualified and certified, the education sector, which grade taught, and some other details.
+Regardless of the setup, this table brings these two sets of data together. There is a record for each teacher for each year they were active. It contains the gender, DoB, age group of teacher, the school, role, source (i.e. an appointment or reported through survey), whether the teacher is qualified and certified as determined by any possible means, the education sector, the max ISCED level taught, which grades taught, and some other details.
 === Tables/Views warehouse.TeacherJob* ===
-Tables containing data about the number of staff. They come in various disaggregations:
+Tables containing data about the number of staff and their job title, staff type (i.e. teaching and non-teaching) and teacher type (i.e. regular, special ed.). They come in various disaggregations:
   * warehouse.TeacherJobTable