User Tools

Site Tools


start

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
start [2024/10/06 17:50] – [How to visualize the data] tdsmdavidstart [2024/11/27 20:41] (current) tdsmdianne
Line 1: Line 1:
 ====== OVERVIEW ====== ====== OVERVIEW ======
-The Teacher Demand and Supply Model (TDSM) supports Jordan's Ministries of Education (MoE) and Higher Education and Scientific Research (MoHESR) to make data-driven decisions and prepare multi-year supply and demand projections for grade K-12 teachers of Jordanian students in the Kingdom's public schools. The model uses data entered into the Open Education Management Information System (OpenEMIS((OpenEMIS (https://www.openemis.org) is an open-source education management information system initiated by UNESCO and used by the Kingdom of Jordan to track its students and teachers.))) to calculate teacher surpluses and shortages in each school from 2016 to five years in the future, allowing policymakers to recognize trends and shifts, and incorporate those into their considerations for policies and incentives impacting teacher recruitment and retention. TDSM will support stakeholders across the education sector in their efforts to plan strategically; it will inform the MoE, *Civil Service Bureau (CSB)*, and university partners about where teachers are going to be needed and for which subjects. The TDSM workflow is depicted in the illustration below.{{:tdsm.png?800|}}+The Teacher Demand and Supply Model (TDSM) supports Jordan's Ministries of Education (MoE) and Higher Education and Scientific Research (MoHESR) to make data-driven decisions and prepare multi-year supply and demand projections for grade K-12 teachers of Jordanian students in the Kingdom's public schools. The model uses data entered into the Open Education Management Information System (OpenEMIS((OpenEMIS (https://www.openemis.org) is an open-source education management information system initiated by UNESCO and used by the Kingdom of Jordan to track its students and teachers.))) to calculate teacher surpluses and shortages in each school from 2016 to five years in the future, allowing policymakers to recognize trends and shifts, and incorporate those into their considerations for policies and incentives impacting teacher recruitment and retention. TDSM will support stakeholders across the education sector in their efforts to plan strategically; it will inform the MoE and university partners about where teachers are going to be needed and for which subjects. The TDSM workflow is depicted in the illustration below.{{:tdsm.png?800|}}
 ====== USER GUIDE ====== ====== USER GUIDE ======
  
Line 138: Line 138:
 Navigate to the [[start#how to visualize the data|TDSM front end]] to view the updated forecasts. Navigate to the [[start#how to visualize the data|TDSM front end]] to view the updated forecasts.
  
-===== How to archive a version ===== *NEED STEP TO UPDATE VERSION # AND VERSION MONTH YEAR+===== How to archive a version ===== 
  
 Inside the project folder is file called "archive.sh", this script will archive the old data for the project create a record for the archive in archive list. Inside the project folder is file called "archive.sh", this script will archive the old data for the project create a record for the archive in archive list.
Line 148: Line 148:
 Whenever TDSM receives a new subject during an OpenEMIS dowload, it automatically associates it with an existing teacher specialization. If TDSM's mapping rules do not apply to the new subject, "Other" is used as the default specialization.  The list of all subject-to-specialization mappings is stored in the [[start#staging tables|subjects.csv]] file.  To change the mapping of a given subject, modify the corresponding value in the specialization column of subjects.csv. The specialization can be one that already exists in the file or a new specialization.  TDSM does not overwrite existing subject x specialization mappings and will apply this new mapping to all data the next time it is updated. Whenever TDSM receives a new subject during an OpenEMIS dowload, it automatically associates it with an existing teacher specialization. If TDSM's mapping rules do not apply to the new subject, "Other" is used as the default specialization.  The list of all subject-to-specialization mappings is stored in the [[start#staging tables|subjects.csv]] file.  To change the mapping of a given subject, modify the corresponding value in the specialization column of subjects.csv. The specialization can be one that already exists in the file or a new specialization.  TDSM does not overwrite existing subject x specialization mappings and will apply this new mapping to all data the next time it is updated.
 ===== How to add a new student track to TDSM ==== ===== How to add a new student track to TDSM ====
-To add a new student track, e.g., Eleventh grade engineering, to TDSM, first check to see that the OpenEMIS grade label is already contained in the [[start#lookup tables|grade_mappings lookup table]].  If not, add the new grade mapping to this file. For example, you would add "Eleventh grade" in the name column and "11" in the grade column.  Next, add the new OpenEMIS track labels, separated by commas, and the corresponding suffix to the the [[start#lookup tables|track_mappins lookup table]].  For example, for engineering, you might add "engineering,هندسة" to the names column and "eng" to the track column.  Finally, you would create a new row in the [[start#lookup tables|weekly_classes_per_specialization lookup table]], with "11_eng" in the grade column and the number of hours required under each specialization column.  For specializations where instruction was not require, leave the column blank.+To add a new student track, e.g., Eleventh grade engineering, to TDSM, first check to see that the OpenEMIS grade label is already contained in the [[start#lookup tables|grade_mappings lookup table]].  If not, add the new grade mapping to this file. For example, you would add "Eleventh grade" in the name column and "11" in the grade column.  Next, add the new OpenEMIS track labels, separated by commas, and the corresponding suffix to the the [[start#lookup tables|track_mappins lookup table]].  For example, for engineering, you might add "engineering,هندسة" to the names column and "eng" to the track column.  Finally, you would create a new row in the [[start#lookup tables|weekly_classes_per_specialization lookup table]], with "11_eng" in the grade column and the number of hours required under each specialization column.  For specializations where instruction is not required, leave the column blank.
 ===== How to update required class hours for a student track ===== ===== How to update required class hours for a student track =====
 The weekly hours of required instruction for each student track are contained [[start#lookup tables|weekly_classes_per_specialization lookup table]]. To adjusted the required hours of instruction for a given student track, modify the values in this file. Leave the cells blank for specializations where no instruction is required. The weekly hours of required instruction for each student track are contained [[start#lookup tables|weekly_classes_per_specialization lookup table]]. To adjusted the required hours of instruction for a given student track, modify the values in this file. Leave the cells blank for specializations where no instruction is required.
 ===== How to add new OpenEMIS locations to TDSM ===== ===== How to add new OpenEMIS locations to TDSM =====
-Each directorate is uniquely identified in OpenEMIS by an area_id.  A list of all OpenEMIS area_ids can be found in the [[start#stagins tables|areas.csv]] table, which is updated each time the TDSM data are refreshed.  Additionally, each school in OpenEMIS is given a more granular administrative_area_id.  Administrative_area_ids are nested within area_ids.  Because OpenEMIS does not have unique identifiers for liwas, each known administrative_area_id+area_id pair has been mapped to a liwa in the [[start#lookup tables|administrative_area_crosswalk.csv]] file. If an administrative_area_id is not mapped in this table, any school with that administrative_area_id will not be included in TDSM. All unmaped schools are listed in the [[start#data files|unmapped_schoools.csv]] file. To add a new administrative_area_id+area_id pair to TDSM, add a new row the administrative_area_crosswalk.csv file, filling in a value for each column. Thenext time the TDSM data are refreshed, the newly mapped administrative_area_ids will then be included.+Each directorate is uniquely identified in OpenEMIS by an area_id.  A list of all OpenEMIS area_ids can be found in the [[start#staging tables|areas.csv]] table, which is updated each time the TDSM data are refreshed.  Additionally, each school in OpenEMIS is given a more granular administrative_area_id.  Administrative_area_ids are nested within area_ids.  Because OpenEMIS does not have unique identifiers for liwas, each known administrative_area_id+area_id pair has been mapped to a liwa in the [[start#lookup tables|administrative_area_crosswalk.csv]] file. If an administrative_area_id is not mapped in this table, any school with that administrative_area_id will not be included in TDSM. All unmaped schools are listed in the [[start#data files|unmapped_schoools.csv]] file. To add a new administrative_area_id+area_id pair to TDSM, add a new row the administrative_area_crosswalk.csv file, filling in a value for each column. The next time the TDSM data are refreshed, the newly mapped administrative_area_ids will then be included.
  
 ===== How to refine the forecasting models ===== ===== How to refine the forecasting models =====
Line 159: Line 159:
  
 =====Version history===== =====Version history=====
-TDSM version 1.0 was deployed February 2022.  Version 2.0 is in final testing and scheduled to deploy on..+TDSM version 1.0 was deployed February 2022.  Version 2.0 is scheduled to deploy in 2024
 |                                          ^  TDSM 1.0  ^  TDSM 2.0  ^ |                                          ^  TDSM 1.0  ^  TDSM 2.0  ^
 ^  Data feed    |  Files manually generated from OpenEMIS and sent to TDSM  |  Automatically pulls from OpenEMIS via its API        | ^  Data feed    |  Files manually generated from OpenEMIS and sent to TDSM  |  Automatically pulls from OpenEMIS via its API        |
Line 227: Line 227:
 The following tables are generated by TDSM each time it loads new data from OpenEMIS Jordan. These tables are persisted so that TDSM can be rerun without having to reload data from OpenEMIS. The following tables are generated by TDSM each time it loads new data from OpenEMIS Jordan. These tables are persisted so that TDSM can be rerun without having to reload data from OpenEMIS.
  
-  * **areas.csv**: List of all areas.+  * **areas.csv**: List of all areas. [[https://drive.google.com/file/d/1E1ekGoBVmVX_zc6QIR1NaTVs6WPLn2u-/view?usp=drive_link|View file]]
   * **institutions.csv**: List of all schools.   * **institutions.csv**: List of all schools.
-  * **subjects.csv**: List of all existing subjects and the teacher specialization they map to, Also includes the OpenEMIS ID of each subject and the OpenEMIS ID of the academic period during which the subject was first taught.+  * **subjects.csv**: List of all existing subjects and the teacher specialization they map to, Also includes the OpenEMIS ID of each subject and the OpenEMIS ID of the academic period during which the subject was first taught. [[https://drive.google.com/file/d/1aqtnm9tTF45D0RGscx_NGeYda7Oaiy9C/view?usp=drive_link|View file]]
   * **teacher_subjects.csv**:  All teachers by subject and year.     * **teacher_subjects.csv**:  All teachers by subject and year.  
   * **teacher_positions.csv**: Yearly teacher positions.     * **teacher_positions.csv**: Yearly teacher positions.  
Line 245: Line 245:
   * **lkp_specialization.txt**: Lookup table for specialization values.   * **lkp_specialization.txt**: Lookup table for specialization values.
   * **lkp_school.txt**: Lookup table for school details.   * **lkp_school.txt**: Lookup table for school details.
-  * **unmapped_schools.csv**: Lists all schools from OpenEMIS that were not successfully mapped to a liwa. These schools are not included in the TDSM data or projections. To include these schools in TDSM, see [[start#How to add new OpenEMIS locations to TDSM+  * **unmapped_schools.csv**: Lists all schools from OpenEMIS that were not successfully mapped to a liwa. [[https://drive.google.com/file/d/1l9HkEeOcJzrlDJ54blFjfNtZUZAxNxuy/view?usp=drive_link|View file]] These schools are not included in the TDSM data or projections. To include these schools in TDSM, see [[start#How to add new OpenEMIS locations to TDSM
 |How to add new OpenEMIS locations to TDSM |How to add new OpenEMIS locations to TDSM
 ]] ]]
  
  
start.1728237059.txt.gz · Last modified: 2024/10/06 17:50 by tdsmdavid