Differences

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

--- emis_user_manual_data_warehouse [2021/07/20 06:30] – [Inspections] ghachey
+++ emis_user_manual_data_warehouse [2023/12/13 20:52] (current) – [Teachers] ghachey
@@ Line 119: / Line 119: @@
 <note tip>The table warehouse.EdLevelERDistrict is essentially the same but with the added ability to disaggregate by districts.</note>
+Details about the columns names in this table are included below:
+  * **SurveyYEar**: school year of survey to collect data
+  * **ClassLevel**: the class level or grade
+  * **YearOfEd**: the official year of education of the class level
+  * **OfficialAge**: the official age of the class level
+  * **enrolM**: males enrolled
+  * **enrolF**: females enrolled
+  * **enrol**: total enrolled
+  * **repM**: male repeaters
+  * **repF**: female repeaters
+  * **rep**: total repeaters
+  * **psaM**: male pre-school attenders
+  * **psaF**: female pre-school attenders
+  * **psa**: total pre-school attenders
+  * **intakeM**: males intakes (new enrollments without repeaters)
+  * **intakeF**: females intakes (new enrollments without repeaters)
+  * **intake**: total intakes (new enrollments without repeaters)
+  * **nEnrolM**: males enrolled of official age
+  * **nEnrolF**: females enrolled of official age
+  * **nEnrol**: total enrolled of official age
+  * **nIntakeM**: males intakes of official age
+  * **nIntakeF**: females intakes of official age
+  * **nIntake**: total intakes of official age
+  * **nRepM**: male repeaters of official age
+  * **nRepF**: female repeaters of official age
+  * **nRep**: total repeaters of official age
+  * **popM**: male population as per most recent population projection in use
+  * **popF**: female population as per most recent population projection in use
+  * **pop**: total population as per most recent population projection in use
 The workbook below shows some sample analysis. This workbook does a bit more than simple pivot tables and charts on the data but also computes new data using formulas.
@@ Line 141: / Line 172: @@
 <note important>Flows are more advanced indicators with slightly more advanced mathematics behind them then other ratios seen so far.</note>
-Each of these views produce the same data but with different disaggregations (i.e. down to school level, district level and nation wide and by gender). Each record will have the following data which must be used in various formulas to produce the final indicators. There is a bold emphasis on the most important ones to produce most flow indicators with enough precision. These flows use the reconstructed cohort methods and must have consistent collection of enrolments and repeaters for two consecutive years.
+Each of these views produce the same data but with different disaggregations (i.e. down to school level, district level and nation wide and by gender). Each record will have the following data which must be used in various formulas to produce the final indicators. There is a bold emphasis on the most important ones to produce most flow indicators with enough precision. These flows use the reconstructed cohort methods and must have consistent collection of enrolments and repeaters for two consecutive years. Details about the columns names in this view are included below:
   * **Enrol**: the enrolments (e.g. Grade 5 enrolments for 2018-19)
@@ Line 177: / Line 208: @@
 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