emis_user_manual_data_warehouse
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
emis_user_manual_data_warehouse [2020/09/07 03:42] – [Teachers] ghachey | emis_user_manual_data_warehouse [2023/12/13 20:37] – [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 tip>The table warehouse.EdLevelERDistrict is essentially the same but with the added ability to disaggregate by districts.</ | ||
+ | |||
+ | Details about the columns names in this table are included below: | ||
+ | |||
+ | * **SurveyYEar**: | ||
+ | * **ClassLevel**: | ||
+ | * **YearOfEd**: | ||
+ | * **OfficialAge**: | ||
+ | * **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**: | ||
+ | * **intakeF**: | ||
+ | * **intake**: total intakes (new enrollments without repeaters) | ||
+ | * **nEnrolM**: | ||
+ | * **nEnrolF**: | ||
+ | * **nEnrol**: total enrolled of official age | ||
+ | * **nIntakeM**: | ||
+ | * **nIntakeF**: | ||
+ | * **nIntake**: | ||
+ | * **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. | 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> | <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. | + | 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) | * **Enrol**: the enrolments (e.g. Grade 5 enrolments for 2018-19) | ||
Line 160: | Line 191: | ||
* Transition Rate (year on year) = (EnrolNYNextLevel - RepNYNextLevel) / Enrol | * Transition Rate (year on year) = (EnrolNYNextLevel - RepNYNextLevel) / Enrol | ||
- | A sample workbook how this many of the flow indicators | + | A sample workbook |
{{ : | {{ : | ||
Line 172: | Line 203: | ||
==== Teachers ==== | ==== Teachers ==== | ||
- | === Table warehouse.TeacherQual === | ||
- | |||
- | Intermediate table to assist in calculation of Certified / Qualified. This table shows, for each teacher, the qualifications reported, and the first year of that report. It is assembled from both the School Surveys, and any named qualifications reported in the web UI. | ||
- | |||
- | <note warning> | ||
=== Table warehouse.TeacherLocation === | === Table warehouse.TeacherLocation === | ||
Line 195: | Line 221: | ||
=== Tables/ | === Tables/ | ||
- | 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 | * warehouse.TeacherJobTable | ||
Line 374: | Line 400: | ||
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. | ||
+ | |||
+ | ==== Teachers ==== | ||
+ | |||
+ | === Table warehouse.TeacherQual === | ||
+ | |||
+ | Intermediate table to assist in calculation of Certified / Qualified. This table shows, for each teacher, the qualifications reported, and the first year of that report. It is assembled from both the School Surveys, and any named qualifications reported in the web UI. | ||
+ | |||
+ | <note warning> | ||
- | ==== Flows ==== | ||
Line 440: | Line 473: | ||
<note important> | <note important> | ||
- | Consolidates the overall result of inspections. Filter on InspectionType to restrict to accreditations | + | Consolidates the overall result of inspections |
<note important> | <note important> |
emis_user_manual_data_warehouse.txt · Last modified: 2023/12/13 20:52 by ghachey