emis_user_manual_data_warehouse
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
emis_user_manual_data_warehouse [2020/09/04 02:19] – [Special Education] ghachey | emis_user_manual_data_warehouse [2020/09/07 03:45] – [Teachers] ghachey | ||
---|---|---|---|
Line 133: | Line 133: | ||
==== Flows ==== | ==== Flows ==== | ||
+ | |||
+ | |||
+ | === Views warehouse.CohortNation, | ||
+ | |||
+ | The primary views to produce flow ratios indicators. | ||
+ | |||
+ | <note important> | ||
+ | |||
+ | 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. | ||
+ | |||
+ | * **Enrol**: the enrolments (e.g. Grade 5 enrolments for 2018-19) | ||
+ | * **Rep**: the repeaters (e.g. Grade 5 repeaters for 2018-19) | ||
+ | * **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) | ||
+ | * **EnrolNYNextLevel**: | ||
+ | * **RepNYNextLevel**: | ||
+ | * TrinNYNextLevel: | ||
+ | |||
+ | The formulas are either identical or mathematical equivalent to the ones in the UNESCO UIS Education Indicators | ||
+ | Technical guidelines. | ||
+ | |||
+ | * Promotion Rate = (EnrolNYNextLevel - RepNYNextLevel) / Enrol | ||
+ | * Repetition Rate = RepNY / Enrol | ||
+ | * Survival Rate (year on year; not to a particular year) = Promotion Rate / ( 1 - Repetition Rate) | ||
+ | * Dropout Rate = 1 - (Promotion Rate + Repetition Rate) | ||
+ | * Transition Rate (year on year) = (EnrolNYNextLevel - RepNYNextLevel) / Enrol | ||
+ | |||
+ | A sample workbook showing how these many flow indicators can be calculated including some analysis is included below. | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | |||
+ | |||
+ | |||
==== Teachers ==== | ==== Teachers ==== | ||
+ | |||
+ | |||
+ | === Table warehouse.TeacherLocation === | ||
+ | |||
+ | The table warehouse.TeacherLocation sits on the transition between: | ||
+ | |||
+ | * teacher reporting derived from the School Surveys; and | ||
+ | * teacher reporting derived from Appointments, | ||
+ | |||
+ | The tables Establishment and Teacher Appointments define the structure of the teaching establishment: | ||
+ | |||
+ | 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/ | ||
+ | |||
+ | 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, | ||
+ | |||
+ | 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. | ||
+ | |||
+ | === Tables/ | ||
+ | |||
+ | Tables containing data about the number of staff. They come in various disaggregations: | ||
+ | |||
+ | * warehouse.TeacherJobTable | ||
+ | * warehouse.TeacherJobSchool | ||
+ | * warehouse.TeacherJobDistrict | ||
+ | * warehouse.TeacherJobAuthority | ||
+ | * warehouse.TeacherJobAuthorityGovt | ||
+ | * warehouse.TeacherJobRegion | ||
+ | * warehouse.TeacherJobIsland | ||
+ | * warehouse.TeacherJobNation | ||
+ | * warehouse.TeacherJobSchoolType | ||
+ | |||
+ | |||
+ | === Tables/ | ||
+ | |||
+ | Tables containing data about the number of staff teaching at specific grades. They come with various disaggregations support. | ||
+ | |||
+ | * warehouse.TeacherActivityTable | ||
+ | * warehouse.TeacherActivitySchool | ||
+ | * warehouse.TeacherActivityDistrict | ||
+ | * warehouse.TeacherActivityAuthority | ||
+ | * warehouse.TeacherActivityAuthorityGovt | ||
+ | * warehouse.TeacherActivityRegion | ||
+ | * warehouse.TeacherActivityIsland | ||
+ | * warehouse.TeacherActivityNation | ||
+ | * warehouse.TeacherActivitySchoolType | ||
+ | |||
+ | They are generally used to produce Pupil-Teacher Ratios (PTR) with higher accuracy. The PTR = Enrol / Teachers. The warehouse tables provide the following columns: | ||
+ | |||
+ | * Enrol: enrolments for the grade (and whatever other disggregation) | ||
+ | * Staff: total teachers teaching at that grade (regardless of how much time in a day they teach there) | ||
+ | * StaffW: teachers full time equivalent teaching at that grade | ||
+ | * GradePTR: the PTR calculated without regards for full time equivalent | ||
+ | * GradePTRW: more precise PTR calculated with StaffW (i.e. full time equivalent) | ||
+ | |||
+ | A sample workbook on teacher data analysis is included below. | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
Line 183: | Line 284: | ||
{{ : | {{ : | ||
+ | |||
+ | {{ : | ||
==== School Accreditation ==== | ==== School Accreditation ==== | ||
Line 267: | Line 370: | ||
Same of warehouse.enrol except this table aggregates this data up to District, Authority, SchoolTypeCode and is used as the basis for higher level aggregations of any of these enrolment data items. | Same of warehouse.enrol except this table aggregates this data up to District, Authority, SchoolTypeCode and is used as the basis for higher level aggregations of any of these enrolment data items. | ||
- | |||
- | ==== Flows ==== | ||
emis_user_manual_data_warehouse.txt · Last modified: 2023/12/13 20:52 by ghachey