Institute for Statistics, UNESCO (UIS)

Summary

The United Nations Statistics Division, UIS Education Database is the most comprehensive education databse in the world, containing data from more than 200 countries and territories. The UIS has the mandate to monitor progress towards Education for All and education-related Millennium Development Goals. The statistics, which are updated twice a year, are used by diverse partners, including governments, donor agencies and other UN organizations. In particular, the UIS is the primary education data source for the Education for All Global Monitoring Report, the World Development Indicators and the Human Development Report Data is collected through the UIS annual education survey, which covers all education levels and a range of issues such as enrolment rate, gender parity, teachers, and financing.

The IFs system uses data from the UIS Education Database on a wide variety of topics relating to education. The following sections provide instructions for pulling data from the UIS Education Database for IFs pre-processor series in the Education submodule.

Tables In IFs

Preprocessors

Table	Definition	Name in Source	UsedInPreprocessorFileName	Source in Code
EDPriPTR	Primary pupil-teacher ratio	Enrolment in primary education, both sexes (number)/Teachers in primary education, both sexes (number)	EDUCATION	20062/20162
EdPriAIRFemale%	Education, Primary, Apparent (gross) intake rate in grade 1, female (% of relevant age group)	Gross intake ratio to the last grade of primary education, female (%)	EDUCATION	AIR.1.GLAST.F
EdPriAIRMale%	Education, Primary, Apparent (gross) intake rate in grade 1, male (% of relevant age group)	Gross intake ratio to the last grade of primary education, male (%)	EDUCATION	AIR.1.GLAST.M
EdPriAIRTotal%	Education, Primary, Apparent (gross) intake rate in grade 1, total (% of relevant age group)	Gross intake ratio to the last grade of primary education, both sexes (%)	EDUCATION	AIR.1.GLAST
EdPriCompletionFemale%	Education, Primary, completion rate (school graduation age), gross, Female	Completion rate, primary education, female (%)	EDUCATION	CR.1.F
EdPriCompletionMale%	Education, Primary, completion rate (school graduation age), gross, Male	Completion rate, primary education, male (%)	EDUCATION	CR.1.M
EdPriCompletionTotal%	Education, Primary, completion rate (graduation ratio), gross, both sexes	Completion rate, primary education, both sexes (%)	EDUCATION	CR.1
EdPriDuration	Education, Primary, completion rate (graduation ratio), gross, total	Theoretical duration of primary education (years)	EDUCATION	299932
EdPriEnrollGrossFemalePcnt	Education, Primary, Enrollment Rate Gross, female	Gross enrolment ratio, primary, female (%)	EDUCATION	GER.1.F
EdPriEnrollGrossMalePcnt	Education, Primary, Enrollment Rate Gross, male	Gross enrolment ratio, primary, male (%)	EDUCATION	GER.1.M
EdPriEnrollGrossTotalPcnt	Education, Primary, Enrollment Rate Gross (% Total)	Gross enrolment ratio, primary, both sexes (%)	EDUCATION	GER.1
EdPriEnrollNetFemalePcnt	Education, Primary, Net Enrollment Rate, Female	Total net enrolment rate, primary, female (%)	EDUCATION	NERT.1.F.CP
EdPriEnrollNetMalePcnt	Education, Primary, Net Enrollment Rate, Male	Total net enrolment rate, primary, male (%)	EDUCATION	NERT.1.M.CP
EdPriEnrollNetTotalPcnt	Education, Primary, Net Enrollment Rate, Total	Total net enrolment rate, primary, both sexes (%)	EDUCATION	NERT.1.CP
EdPriEntranceAge	Education Primary Entrance Age	Official entrance age to primary education (years)	EDUCATION	299905
EdPriSurvivalFemale%	Education, Primary, percentage of entrants persisting to last grade, female	Survival rate to the last grade of primary education, female (%)	EDUCATION	SR.1.GLAST.F.CP
EdPriSurvivalMale%	Education, Primary, percentage of entrants persisting to last grade, male	Survival rate to the last grade of primary education, male (%)	EDUCATION	SR.1.GLAST.M.CP
EdPriSurvivalTotal%	Education, Primary, percentage of entrants persisting to last grade, total	Survival rate to the last grade of primary education, both sexes (%)	EDUCATION	SR.1.GLAST.CP
EdSecEnrollGross%Female	Education, Secondary, gross enrollment rate, female	Gross enrolment ratio, secondary, female (%)	EDUCATION	GER.2T3.F
EdSecEnrollGross%Male	Education, Secondary, gross enrollment rate, male	Gross enrolment ratio, secondary, male (%)	EDUCATION	GER.2T3.M
EdSecEnrollGross%Total	Education, Secondary, gross enrollment rate, total	Gross enrolment ratio, secondary, both sexes (%)	EDUCATION	GER.2T3
EdSecLowerDuration	Education Duration of Lower Secondary	Theoretical duration of lower secondary education (years)	EDUCATION	999976
EdSecLowerEnrollGross%Female	Education, Secondary, Lower, Gross Enrollment Rate All Programs, Female	Gross enrolment ratio, lower secondary, female (%)	EDUCATION	GER.2.F
EdSecLowerEnrollGross%Male	Education, Secondary, Lower, Gross Enrollment Rate All Programs, Male	Gross enrolment ratio, lower secondary, male (%)	EDUCATION	GER.2.M
EdSecLowerEnrollGross%Total	Education, Secondary, Lower, Gross Enrollment Rate, Total	Gross enrolment ratio, lower secondary, both sexes (%)	EDUCATION	GER.2
EdSecLowerVoc%AllTotal	Education, Secondary, Lower, Vocational as % of All Program Enrollments, Total	Share of all students in lower secondary education enrolled in vocational programmes (%)	EDUCATION	GTVP.2.V
EdSecUpperDuration	Education, Secondary, Upper, Duration of Upper Secondary	Theoretical duration of upper secondary education (years)	EDUCATION	999978
EdSecUpperEnrollGross%Female	Education, Secondary, Upper, Gross Enrollment Rate All Programs, Female	Gross enrolment ratio, upper secondary, female (%)	EDUCATION	GER.3.F
EdSecUpperEnrollGross%Male	Education, Secondary, Upper, Gross Enrollment Rate All Programs, Male	Gross enrolment ratio, upper secondary, male (%)	EDUCATION	GER.3.M
EdSecUpperEnrollGross%Total	Education, Secondary, Upper, Gross Enrollment Rate All Programs, Total	Gross enrolment ratio, upper secondary, both sexes (%)	EDUCATION	GER.3
EdSecUpperVoc%AllTotal	Education, Secondary, Upper, Vocational as % of All Program Enrollments, Total	Share of all students in upper secondary education enrolled in vocational programmes (%)	EDUCATION	GTVP.3.V
EdTerEnrollGross%Female	Education, Tertiary, Gross Enrollment Rate, Female	Gross enrolment ratio for tertiary education, female (%)	EDUCATION	GER.5T8.F
EdTerEnrollGross%Male	Education, Tertiary, Gross Enrollment Rate, Male	Gross enrolment ratio for tertiary education, male (%)	EDUCATION	GER.5T8.M
EdTerEnrollGross%Total	Education, Tertiary, Gross Enrollment Rate, Total	Gross enrolment ratio for tertiary education, both sexes (%)	EDUCATION	GER.5T8
EdTerGradRate1stDegreeFemale%	Education, Tertiary, Gross Graduation Ratio, ISCED 6 and 7, first degree, female	Gross graduation ratio from first degree programmes (ISCED 6 and 7) in tertiary education, female (%)	EDUCATION	GGR.6T7.F
EdTerGradRate1stDegreeMale%	Education, Tertiary, Gross Graduation Ratio, ISCED 6 and 7, first degree, male	Gross graduation ratio from first degree programmes (ISCED 6 and 7) in tertiary education, male (%)	EDUCATION	GGR.6T7.M
EdTerGradRate1stDegreeTotal%	Education, Tertiary, Gross Graduation Ratio, ISCED 6 and 7, first degree, total	Gross graduation ratio from first degree programmes (ISCED 6 and 7) in tertiary education, both sexes (%)	EDUCATION	GGR.6T7
EdTerGrads%SciEngg	Education, Tertiary, Science and Enginnering Graduates as % of Total Graduates	Percentage of graduates from tertiary education graduating from Natural Sciences, Mathematics and Statistics programmes, both sexes (%)	EDUCATION	FOSGP.5T8.F500
GovtEdPub%GDP	Educational expenditures (public) as percent of GDP	Government expenditure on pre-primary education as a percentage of GDP (%) + Government expenditure on primary education as a percentage of GDP (%) + Government expenditure on lower secondary education as a percentage of GDP (%) + Government expenditure on upper secondary education as a percentage of GDP (%) + Government expenditure on post-secondary non-tertiary education as a percentage of GDP (%) + Government expenditure on tertiary education as a percentage of GDP (%)	ECONOMY	XGDP.02.FSGOV + XGDP.1.FSGOV + XGDP.2.FSGOV + XGDP.3.FSGOV + XGDP.4.FSGOV + XGDP.5T8.FSGOV
R&DGovt%GDP	Gross R&D expenditure by government	GERD as a percentage of GDP	ECONOMY	EXPGDP.TOT
EdExpPri%GDPPC	Expenditure per student in primary education (% of GDP/capita)	Initial government funding per primary student as a percentage of GDP per capita	EDUCATION	XUNIT.GDPCAP.1.FSGOV.FFNTR
EdExpSec%GDPPC	Expenditure per student in secondary education (% of GDP/capita)	Initial government funding per secondary student as a percentage of GDP per capita	EDUCATION	XUNIT.GDPCAP.2T3.FSGOV.FFNTR
EdExpSecLowr%GDPPC	Expenditure per student in lower secondary education (% of GDP/capita)	Initial government funding per lower secondary student as a percentage of GDP per capita	EDUCATION	XUNIT.GDPCAP.2.FSGOV.FFNTR
EdExpSecUppr%GDPPC	Expenditure per student in upper secondary education (% of GDP/capita)	Initial government funding per upper secondary student as a percentage of GDP per capita	EDUCATION	XUNIT.GDPCAP.3.FSGOV.FFNTR
EdExpTer%GDPPC	Expenditure per student in tertiary education (% of GDP/capita)	Initial government funding per tertiary student as a percentage of GDP per capita	EDUCATION	XUNIT.GDPCAP.5T8.FSGOV.FFNTR
EdSecLowerVoc%AllFemale	Percentage of female students in lower secondary education enrolled in vocational programmes, female (%)	Percentage of females in lower secondary education enrolled in vocational programs (%)	EDUCATION	GTVP.2.V.F
EdSecLowerVoc%AllMale	Percentage of male students in lower secondary education enrolled in vocational programmes, male (%)	Percentage of males in lower secondary education enrolled in vocational programs (%)	EDUCATION	GTVP.2.V.M
EdSecUpperGradRateAllFem	Gross Upper Secondary Graduation Ratio, All Programmes. Female	Completion rate, upper secondary education, female (%)	EDUCATION	CR.3.F
EdSecUpperGradRateAllMal	Gross Upper Secondary Graduation Ratio, All Programmes. Male	Completion rate, upper secondary education, male (%)	EDUCATION	CR.3.M
EdSecUpperGradRateAllTot	Gross Upper Secondary Graduation Ratio, All Programmes. Total	Completion rate, upper secondary education, both sexes (%)	EDUCATION	CR.3
EdSecUpperVoc%AllFemale	Percentage of female students in upper secondary education enrolled in vocational programmes, female (%)	Percentage of females in upper secondary enrolled in vocational programs (%)	EDUCATION	GTVP.3.V.F
EdSecUpperVoc%AllMale	Percentage of male students in upper secondary education enrolled in vocational programmes, male (%)	Percentage of males in upper secondary education enrolled in vocational programs (%)	EDUCATION	GTVP.3.V.M

Non-preprocessors

Table	Definition	Name in Source	Source in Code	Formula
EdBasicEnrollGross%Female	Education, Basic, Enrollment Rate, Gross, Female	Gross enrolment ratio, primary and lower secondary, female (%)	GER.1T2.F
EdBasicEnrollGross%Male	Education, Basic, Enrollment Rate, Gross, Male	Gross enrolment ratio, primary and lower secondary, male (%)	GER.1T2.M
EdBasicEnrollGross%Total	Education, Basic, Enrollment Rate, Gross, Total	Gross enrolment ratio, primary and lower secondary, both sexes (%)	GER.1T2
EdEnrollPrivate%Lower2ndaryGeneral	Education enrollments private as % of lower secondary general	Percentage of enrolment in lower secondary education in private institutions (%)	PRP.2
EdEnrollPrivate%Primary	Education enrollment private as % of primary	Percentage of enrolment in primary education in private institutions (%)	PRP.1
EdEnrollPrivate%Upper2ndaryGeneral	Education enrollments private as % of upper secondary general	Percentage of enrolment in upper secondary education in private institutions (%)	PRP.3
EdEnrollPrivateAll2ndaryCombined	Education enrollment private all secondary combined	Percentage of enrolment in secondary education in private institutions (%)	PRP.2T3
EdEnrollPrivateUpper2ndaryGeneral	Education enrollment private upper secondary general	Percentage of enrolment in upper secondary education in private institutions (%)	PRP.3
EdExpISCED1-4Cap%	Education expenditures, ISCED 1-4, capital portion	Capital expenditure as a percentage of total expenditure in primary public institutions (%) + Capital expenditure as a percentage of total expenditure in lower secondary public institutions (%) + Capital expenditure as a percentage of total expenditure in upper-secondary public institutions (%) + Capital expenditure as a percentage of total expenditure in post-secondary non-tertiary public institutions (%)	XSPENDP.1.FDPUB.FNCAP + XSPENDP.2.FDPUB.FNCAP + XSPENDP.3.FDPUB.FNCAP + XSPENDP.4.FDPUB.FNCAP
EdExpISCED1-4NonSalCur%	Education expenditures, ISCED 1-4, non-salary current portion	Current expenditure other than staff compensation as a percentage of total expenditure in primary public institutions (%) + Current expenditure other than staff compensation as a percentage of total expenditure in lower secondary public institutions (%) + Current expenditure other than staff compensation as a percentage of total expenditure in upper secondary public institutions (%) + Current expenditure other than staff compensation as a percentage of total expenditure in post-secondary non-tertiary public institutions (%)	XSPENDP.1.FDPUB.FNNONS + XSPENDP.2.FDPUB.FNNONS + XSPENDP.3.FDPUB.FNNONS + XSPENDP.4.FDPUB.FNNONS
EdExpISCED1-4Sal%	Education expenditures, ISCED 1-4, salary portion	All staff compensation as a percentage of total expenditure in primary public institutions (%) + All staff compensation as a percentage of total expenditure in lower secondary public institutions (%) + All staff compensation as a percentage of total expenditure in upper secondary public institutions (%) + All staff compensation as a percentage of total expenditure in post-secondary non-tertiary public institutions (%)	XSPENDP.1.FDPUB.FNS + XSPENDP.2.FDPUB.FNS + XSPENDP.3.FDPUB.FNS + XSPENDP.4.FDPUB.FNS
EdExpISCED1-4TotalCur%	Education expenditures, ISCED 1-4, total current portion	Current expenditure as a percentage of total expenditure in primary public institutions (%) + Current expenditure as a percentage of total expenditure in lower secondary public institutions (%) + Current expenditure as a percentage of total expenditure in upper-secondary public institutions (%) + Current expenditure as a percentage of total expenditure in post-secondary non-tertiary public institutions (%)	XSPENDP.1.FDPUB.FNCUR + XSPENDP.2.FDPUB.FNCUR + XSPENDP.3.FDPUB.FNCUR + XSPENDP.4.FDPUB.FNCUR
EdExpPrePri%EducTot	Educational expenditure in pre-primary as % of total educational expenditure	Government expenditure on pre-primary education, constant US$ (millions)/Government expenditure on education, constant US$ (millions)	X.USCONST.02.FSGOV/X.USCONST.FSGOV
EdExpPri%EducTot	Education expenditure in primary as % of total educational expenditure	Government expenditure on primary education, constant US$ (millions)/Government expenditure on education, constant US$ (millions)	X.USCONST.1.FSGOV/X.USCONST.FSGOV
EdExpSec%EducTot	Education Expenditure Secondary as % of Total Educational Expenditure	Government expenditure on secondary education, constant US$ (millions)/Government expenditure on education, constant US$ (millions)	X.USCONST.2T3.FSGOV/X.USCONST.FSGOV
EdExpSecLowr%EducTot	Educational expenditure in lower secondary as % of total educational expenditure	Government expenditure on lower secondary education, constant US$ (millions)/Government expenditure on education, constant US$ (millions)	X.USCONST.2.FSGOV/X.USCONST.FSGOV
EdExpSecUppr%EducTot	Educational expenditure in upper secondary as % of total educational expenditure	Government expenditure on upper secondary education, constant US$ (millions)/Government expenditure on education, constant US$ (millions)	X.USCONST.3.FSGOV/X.USCONST.FSGOV
EdExpTer%EducTot	Education Expenditure Tertiary as % of Total Educational Expenditure	Government expenditure on tertiary education, constant US$ (millions)/Government expenditure on education, constant US$ (millions)	X.USCONST.5T8.FSGOV/X.USCONST.FSGOV
EdExpTerCap%	Education expenditures, tertiary, capital portion	Capital expenditure as a percentage of total expenditure in tertiary public institutions (%)	XSPENDP.5T8.FDPUB.FNCAP
EdExpTertNonSalCur%	Education expenditures, tertiary, non-salary current portion	Current expenditure other than staff compensation as a percentage of total expenditure in tertiary public institutions (%)	XSPENDP.5T8.FDPUB.FNNONS
EdExpTertSal%	Education expenditures, tertiary, salary portion	All staff compensation as a percentage of total expenditure in tertiary public institutions (%)	XSPENDP.5T8.FDPUB.FNS
EdExpTertTotalCur%	Education expenditures, tertiary, total current portion	Current expenditure as a percentage of total expenditure in tertiary public institutions (%)	XSPENDP.5T8.FDPUB.FNCUR
EdExpectedYearsofSchooling	Expected years of schooling for a child of school entering age	School life expectancy, primary to tertiary, both sexes (years)	SLE.1T8
EdExpectedYearsofSchoolingFemale	Expected years of schooling for a child of school entering age, female	School life expectancy, primary to tertiary, female (years)	SLE.1T8.F
EdExpectedYearsofSchoolingMale	Expected years of education for a child of school going age, male	School life expectancy, primary to tertiary, male (years)	SLE.1T8.M
EdPostSecDuration	Education, Post-Secondary Non-Tertiary, Cycle Length	Theoretical duration of post-secondary non-tertiary education (years)	999988
EdPrePriDuration	Education, Pre-Primary, Cycle Length	Theoretical duration of pre-primary education (years)	299929
EdPrePriParityGenderTeachers	Ratio of female to male teachers in pre-primary education who are trained	Pupil-trained teacher ratio in pre-primary education (headcount basis)	PTRHC.02.TRAINED
EdPri2and3ParityGenderMath	Ratio of girls' to boys' mathematics achievement in grades 2 & 3	Proportion of students in Grade 2 or 3 achieving at least a minimum proficiency level in mathematics, adjusted gender parity index (GPIA)	MATH.G2.GPIA + MATH.G3.GPIA
EdPri2and3ParityGenderRead	Ratio of girls' to boys' reading achievement in grades 2 & 3	Proportion of students in Grade 2 or 3 achieving at least a minimum proficiency level in reading, adjusted gender parity index (GPIA)	READ.G2.GPIA + READ.G3.GPIA
EdPri2and3ParityRurUrbMath	Ratio of rural to urban students' mathematics achievement in grades 2 & 3	Proportion of students in Grade 2 or 3 achieving at least a minimum proficiency level in mathematics, adjusted location parity index (LPIA)	MATH.G2.LPIA + MATH.G3.LPIA
EdPri2and3ParityRurUrbRead	Ratio of rural to urban students' reading achievement in grades 2 & 3	Proportion of students in Grade 2 or 3 achieving at least a minimum proficiency level in reading, adjusted location parity index (LPIA)	READ.G2.LPIA + READ.G3.LPIA
EdPri2and3ParitySocioeconMath	Ratio of students from low to high socio-economic groups' mathematics achievement in grades 2 & 3	Proportion of students in Grade 2 or 3 achieving at least a minimum proficiency level in mathematics, adjusted wealth parity index (WPIA)	MATH.G2.WPIA + MATH.G3.WPIA
EdPri2and3ParitySocioeconRead	Ratio of students from low to high socio-economic groups' achievement in reading in grades 2 & 3	Proportion of students in Grade 2 or 3 achieving at least a minimum proficiency level in reading, adjusted wealth parity index (WPIA)	READ.G2.WPIA + READ.G3.WPIA
EdPriAIRParity	Education, Primary, Apparent(gross) Intake Rate, Gender Parity Index	Gross intake ratio to the last grade of primary education, adjusted gender parity index (GPIA)	AIR.1.GLAST.GPIA
EdPriCompletionFemale	Education, primary, completion rate from household survey data, female	Completion rate, primary education, female (%)	CR.1.F
EdPriCompletionFemale%BL	Education, Primary, completion rate (graduation ratio), gross, Female	Completion rate, primary education, female (%)	CR.1.F
EdPriCompletionMale	Education, primary, completion rate from household survey data, male	Completion rate, primary education, male (%)	CR.1.M
EdPriCompletionMale%BL	Education, Primary, completion rate (graduation ratio), gross, Male	Completion rate, primary education, male (%)	CR.1.M
EdPriCompletionParity	Education, Primary, Completion Rate, Gender Parity, New	Completion rate, primary education, adjusted gender parity index (GPIA)	CR.1.GPIA
EdPriCompletionTotal	Education, primary, completion rate from household survey data, total	Completion rate, primary education, both sexes (%)	CR.1
EdPriCompletionTotal%BL	Education, Primary, completion rate (graduation ratio), gross, total	Completion rate, primary education, both sexes (%)	CR.1
EdPriEnrollHeadCountTtl	Education, Primary, Total Enrollment (male plus female)	Enrolment in primary education, both sexes (number)	20062	*0.000001
EdPriEnrollHeadcountFem	Female enrollment at primary level, in both public and private institutions	Enrolment in primary education, female (number)	20063	*0.000001
EdPriEnrollHeadcountMal	Male enrollment, primary level, in both public and private institutions	Enrolment in primary education, male (number)	40035	*0.000001
EdPriEnrollNetParity	Education, Primary, Net Enrollment Rate, Gender Parity Index	Total net enrolment rate, primary, adjusted gender parity index (GPIA)	NERT.1.GPIA
EdPriOutofSchoolFemale%	Education primary, percentage of primary age children who are out of school, Female	Out-of-school rate for children of primary school age, female (%)	ROFST.1.F.CP
EdPriOutofSchoolMale%	Education primary, percentage of primary age children who are out of school, Male	Out-of-school rate for children of primary school age, male (%)	ROFST.1.M.CP
EdPriOutofSchoolTotal%	Education primary, percentage of primary age children who are out of school, total	Out-of-school rate for children of primary school age, both sexes (%)	ROFST.1.CP
EdPriParityGenderMath	Ratio of girls' to boys' mathematics achievement by the end of primary	Proportion of students at the end of primary achieving at least a minimum proficiency level in mathematics, adjusted gender parity index (GPIA)	MATH.PRIMARY.GPIA
EdPriParityGenderRead	Ratio of girls' to boys' reading achievement by the end of primary	Proportion of students at the end of primary achieving at least a minimum proficiency level in reading, adjusted gender parity index (GPIA)	READ.PRIMARY.GPIA
EdPriParityGenderTeachers	Ratio of female to male teachers in primary education who are trained	Pupil-trained teacher ratio in primary education (headcount basis)	PTRHC.1.TRAINED
EdPriParityRurUrbMath	Ratio of rural to urban students' mathematics achievement by the end of primary	Proportion of students at the end of primary achieving at least a minimum proficiency level in mathematics, adjusted location parity index (LPIA)	MATH.PRIMARY.LPIA
EdPriParityRurUrbRead	Ratio of rural to urban students' reading achievement by the end of primary	Proportion of students at the end of primary education achieving at least a minimum proficiency level in reading, adjusted location parity index (LPIA)	READ.PRIMARY.LPIA
EdPriParitySocioeconMath	Ratio of students from low to high socio-economic groups' achievement in mathematics by the end of primary	Proportion of students at the end of primary achieving at least a minimum proficiency level in mathematics, adjusted wealth parity index (WPIA)	MATH.PRIMARY.WPIA
EdPriParitySocioeconRead	Ratio of students from low to high socio-economic groups' achievement in reading by the end of primary	Proportion of students at the end of primary education achieving at least a minimum proficiency level in reading, adjusted wealth parity index (WPIA)	READ.PRIMARY.WPIA
EdPriRepeater1stYearFemale%	Percentage of repeaters in primary. Grade 1.Female	Repetition rate in Grade 1 of primary education, female (%)	REPR.1.G1.F.CP
EdPriRepeater1stYearMale%	Percentage of repeaters in primary. Grade 1.Male	Repetition rate in Grade 1 of primary education, male (%)	REPR.1.G1.M.CP
EdPriRepeater1stYearTotal%	Percentage of repeaters in primary. Grade 1. Total	Repetition rate in Grade 1 of primary education, both sexes (%)	REPR.1.G1.CP
EdPriRepeaterFemale%	Education Primary Percentage of Repeaters, all grades, female	Repetition rate in primary education (all grades), female (%)	REPR.1.F.CP
EdPriRepeaterMale%	Education Primary Percentage of Repeaters, all grades, male	Repetition rate in primary education (all grades), male (%)	REPR.1.M.CP
EdPriRepeaterTotal%	Education Primary Percentage of Repeaters, all grades, total	Repetition rate in primary education (all grades), both sexes (%)	REPR.1.CP
EdPriSurvivalParity	Education, Primary, Survival to Last Grade, Gender Parity, New	Survival rate to the last grade of primary education,adjusted gender parity index (GPIA)	SR.1.GLAST.GPIA
EdSecDuration	Duration of education, secondary	Theoretical duration of secondary education (years)	THDUR.2T3
EdSecEnrNoFem	Education, secondary Enrollment Number, Female	Enrolment in secondary education, female (number)	20083	*0.000001
EdSecEnrNoMal	Education, secondary Enrollment Number, Male	Enrolment in secondary education, male (number)	40044	*0.000001
EdSecEnrNoTot	Education, Total Secondary, Total Enrollment (male plus female)	Enrolment in secondary education, both sexes (number)	20082	*0.000001
EdSecEnrollGross%Parity	secondary gross enrollment rate, all programs, Gender Parity Index, new data	Gross enrolment ratio, secondary, adjusted gender parity index (GPIA)	GER.2T3.GPIA
EdSecLowerAdultGrads25Female%	Adult population (25 and over) with lower secondary (or more) education, female%	Educational attainment rate, completed lower secondary education or higher, population 25+ years, female (%)	EA.2T8.AG25T99.F
EdSecLowerAdultGrads25Male%	Adult population (25 and over) with lower secondary (or more) education, male%	Educational attainment rate, completed lower secondary education or higher, population 25+ years, male (%)	EA.2T8.AG25T99.M
EdSecLowerAdultGrads25Total%	Adult population (25 and over) with lower secondary (or more) education, total%	Educational attainment rate, completed lower secondary education or higher, population 25+ years, both sexes (%)	EA.2T8.AG25T99
EdSecLowerEnrollGrossParity	Gender parity index for gross enrolment ratio. Lower secondary. All programmes	Gross enrolment ratio, lower secondary, adjusted gender parity index (GPIA)	GER.2.GPIA
EdSecLowerEnrollHeadcountFemale	Education, lower secondary, headcount enrollment number, female	Enrolment in lower secondary education, female (number)	20065	*0.000001
EdSecLowerEnrollHeadcountMale	Education, lower secondary, headcount enrollment number , male	Enrolment in lower secondary education, male (number)	40038	*0.000001
EdSecLowerEnrollHeadcountTotal	Education, Lower Secondary, Total Enrollment (male plus female)	Enrolment in lower secondary education, both sexes (number)	20064	*0.000001
EdSecLowerNetEnrollFemale%	Net Lower Secondary Enrollment Rate, Female	Total net enrolment rate, lower secondary, female (%)	NERT.2.F.CP
EdSecLowerNetEnrollMale%	Net Lower Secondary Enrollment Rate, Male	Total net enrolment rate, lower secondary, male (%)	NERT.2.M.CP
EdSecLowerNetEnrollTot%	Net Lower Secondary Enrollment Rate, Total	Total net enrolment rate, lower secondary, both sexes (%)	NERT.2.CP
EdSecLowrCompletionFemale	Education, lower secondary, completion rate from household survey data, female	Completion rate, lower secondary education, female (%)	CR.2.F
EdSecLowrCompletionMale	Education, lower secondary, completion rate from household survey data, male	Completion rate, lower secondary education, male (%)	CR.2.M
EdSecLowrCompletionTotal	Education, lower secondary, completion rate from household survey data, total	Completion rate, lower secondary education, both sexes (%)	CR.2
EdSecLowrPTR	Education, lower secondary, pupil teacher ratio	Enrolment in lower secondary education, both sexes (number)/Teachers in lower secondary education, both sexes (number)	20064/20164
EdSecLwrParityGenderMath	Ratio of girls' to boys' mathematics achievement by the end of lower secondary	Proportion of students at the end of lower secondary achieving at least a minimum proficiency level in mathematics, adjusted gender parity index (GPIA)	MATH.LOWERSEC.GPIA
EdSecLwrParityGenderRead	Ratio of girls' to boys' reading achievement by the end of lower secondary	Proportion of students at the end of lower secondary achieving at least a minimum proficiency level in reading, adjusted gender parity index (GPIA)	READ.LOWERSEC.GPIA
EdSecLwrParityGenderTeachers	Ratio of female to male teachers in lower secondary who are trained	Pupil-trained teacher ratio in lower secondary education (headcount basis)	PTRHC.2.TRAINED
EdSecLwrParityRurUrbMath	Ratio of rural to urban students' mathematics achievement by the end of lower secondary	Proportion of students at the end of lower secondary achieving at least a minimum proficiency level in mathematics, adjusted location parity index (LPIA)	MATH.LOWERSEC.LPIA
EdSecLwrParityRurUrbRead	Ratio of rural to urban students' reading achievement by the end of lower secondary	Proportion of students at the end of lower secondary education achieving at least a minimum proficiency level in reading, adjusted location parity index (LPIA)	READ.LOWERSEC.LPIA
EdSecLwrParitySocioeconMath	Ratio of students from low to high socio-economic groups' achievement in mathematics by the end of lower secondary	Proportion of students at the end of lower secondary achieving at least a minimum proficiency level in mathematics, adjusted wealth parity index (WPIA)	MATH.LOWERSEC.WPIA
EdSecLwrParitySocioeconRead	Ratio of students from low to high socio-economic groups' achievement in reading by the end of lower secondary	Proportion of students at the end of lower secondary education achieving at least a minimum proficiency level in reading, adjusted wealth parity index (WPIA)	READ.LOWERSEC.WPIA
EdSecUpperEnrollGrossParity	Gender parity index for gross enrolment ratio. Upper secondary. All programmes	Gross enrolment ratio, upper secondary, adjusted gender parity index (GPIA)	GER.3.GPIA
EdSecUpperEnrollGrossParityNew	Gender parity index for gross enrolment ratio. Upper secondary. All programmes	Gross enrolment ratio, upper secondary, adjusted gender parity index (GPIA)	GER.3.GPIA
EdSecUpperEnrollHeadCountMale	Education, upper secondary, headcount enrollment number , male	Enrolment in upper secondary education, male (number)	40041	*0.000001
EdSecUpperEnrollHeadcountFemale	Education, upper secondary, headcount enrollment number, female	Enrolment in upper secondary education, female (number)	20071	*0.000001
EdSecUpperEnrollHeadcountTotal	Education, Upper Secondary, Total Enrollment (male plus female)	Enrolment in upper secondary education, both sexes (number)	20070	*0.000001
EdSecUpperNetEnrollFemale%	Net Upper Secondary Enrollment, Female	Total net enrolment rate, upper secondary, female (%)	NERT.3.F.CP
EdSecUpperNetEnrollMale%	Net Upper Secondary Enrollment Rate, Male	Total net enrolment rate, upper secondary, male (%)	NERT.3.M.CP
EdSecUpperNetEnrollTot%	Net Upper Secondary Enrollment Rate, Total	Total net enrolment rate, upper secondary, both sexes (%)	NERT.3.CP
EdSecUpperParityGenderTeachers	Ratio of female to male teachers in upper secondary education who are trained	Pupil-trained teacher ratio in upper secondary education (headcount basis)	PTRHC.3.TRAINED
EdSecUpprCompletionFemale	Education, upper secondary, completion rate from household survey data, female	Completion rate, upper secondary education, female (%)	CR.3.F
EdSecUpprCompletionMale	Education, upper secondary, completion rate from household survey data, male	Completion rate, upper secondary education, male (%)	CR.3.M
EdSecUpprCompletionTotal	Education, upper secondary, completion rate from household survey data, total	Completion rate, upper secondary education, both sexes (%)	CR.3
EdSecVoc%Tot	Education Secondary, technical or vocational enrollment as percentage of all programs, total	Share of all students in secondary education enrolled in vocational programmes (%)	GTVP.2T3.V
EdTerEnrISCED6HdctFem	Education, 6 Tertiary, Enrollment headcount, Female	Enrolment in tertiary education, ISCED 6 programmes, female (number)	42635	*0.000001
EdTerEnrISCED6HdctMale	Education, 6 Tertiary, Enrollment headcount, Male	Enrolment in tertiary education, ISCED 6 programmes, male (number)	42615	*0.000001
EdTerEnrISCED6HdctTot	Education, 6 Tertiary, Enrollment headcount, Total	Enrolment in tertiary education, ISCED 6 programmes, both sexes (number)	42654	*0.000001
EdTerEnrollHeadcountFem	Education, Tertiary, Enrollment Headcount, Female	Enrolment in tertiary education, all programmes, female (number)	25057	*0.000001
EdTerEnrollHeadcountMale	Education, Tertiary, Enrollment Headcount, Male	Enrolment in tertiary education, all programmes, male (number)	42620	*0.000001
EdTerEnrollHeadcountTotal	Education, Tertiary, Enrollment Headcount, Total	Enrolment in tertiary education, all programmes, both sexes (number)	25053	*0.000001
EdTerFemaleMaleRatio	Ratio of females to males in tertiary education	Gross enrolment ratio for tertiary education, adjusted gender parity index (GPIA)	GER.5T8.GPIA
EdTerGrads%Ag	Education, Tertiary, Agriculture Graduates as % of total graduates	Percentage of graduates from tertiary education graduating from Agriculture, Forestry, Fisheries and Veterinary programmes, both sexes (%)	FOSGP.5T8.F800
EdTerGrads%Engg	Education, Tertiary, Engineering, Manufacturing and Construction as % of total graduates	Percentage of graduates from tertiary education graduating from Engineering, Manufacturing and Construction programmes, both sexes (%)	FOSGP.5T8.F700
EdTerGrads%Health	Education, Tertiary, Health and Welfare Graduates as % of total graduates	Percentage of graduates from tertiary education graduating from Health and Welfare programmes, both sexes (%)	FOSGP.5T8.F900
EdTerGrads%Sci	Education, Tertiary, Science Graduates as % of total graduates	Percentage of graduates from Science, Technology, Engineering and Mathematics programmes in tertiary education, both sexes (%) + Percentage of graduates from tertiary education graduating from Information and Communication Technologies programmes, both sexes (%)	FOSGP.5T8.F500 + FOSGP.5T8.F600
PupilTeacherRatioUISPrimary	Pupil teacher ratio in primary education	Enrolment in primary education, both sexes (number)/Teachers in primary education, both sexes (number)	20062/20162
PupilTeacherRatioUISSecondary	Pupil teacher ratio in secondary education	Enrolment in secondary education, both sexes (number)/Teachers in secondary education, both sexes (number)	20082/20182
PupilTrainedTeacherRatioUISPrimary	Pupil to trained teacher ratio in primary education	Pupil-trained teacher ratio in primary education (headcount basis)	PTRHC.1.TRAINED
PupilTrainedTeacherRatioUISSecondary	Pupil toTrained teacher ratio in secondary education	Pupil-trained teacher ratio in secondary education (headcount basis)	PTRHC.2T3.TRAINED
EdSecLowrRpt%Gr1BothSexes	Repetition rate in Grade 1 of lower secondary general education, both sexes (%)	Repetition rate in Grade 1 of lower secondary general education, both sexes (%)	REPR.2.G1.CP
EdSecLowrRpt%Gr1Female	Repetition rate in Grade 1 of lower secondary general education, female (%)	Repetition rate in Grade 1 of lower secondary general education, female (%)	REPR.2.G1.F.CP
EdSecLowrRpt%Gr1Male	Repetition rate in Grade 1 of lower secondary general education, male (%)	Repetition rate in Grade 1 of lower secondary general education, male (%)	REPR.2.G1.M.CP
EdSecLowrRpt%Gr2BothSexes	Repetition rate in Grade 2 of lower secondary general education, both sexes (%)	Repetition rate in Grade 2 of lower secondary general education, both sexes (%)	REPR.2.G2.CP
EdSecLowrRpt%Gr2Female	Repetition rate in Grade 2 of lower secondary general education, female (%)	Repetition rate in Grade 2 of lower secondary general education, female (%)	REPR.2.G2.F.CP
EdSecLowrRpt%Gr2Male	Repetition rate in Grade 2 of lower secondary general education, male (%)	Repetition rate in Grade 2 of lower secondary general education, male (%)	REPR.2.G2.M.CP
EdSecLowrRpt%Gr3BothSexes	Repetition rate in Grade 3 of lower secondary general education, both sexes (%)	Repetition rate in Grade 3 of lower secondary general education, both sexes (%)	REPR.2.G3.CP
EdSecLowrRpt%Gr3Female	Repetition rate in Grade 3 of lower secondary general education, female (%)	Repetition rate in Grade 3 of lower secondary general education, female (%)	REPR.2.G3.F.CP
EdSecLowrRpt%Gr3Male	Repetition rate in Grade 3 of lower secondary general education, male (%)	Repetition rate in Grade 3 of lower secondary general education, male (%)	REPR.2.G3.M.CP
EdSecLowrRpt%Gr4BothSexes	Repetition rate in Grade 4 of lower secondary general education, both sexes (%)	Repetition rate in Grade 4 of lower secondary general education, both sexes (%)	REPR.2.G4.CP
EdSecLowrRpt%Gr4Female	Repetition rate in Grade 4 of lower secondary general education, female (%)	Repetition rate in Grade 4 of lower secondary general education, female (%)	REPR.2.G4.F.CP
EdSecLowrRpt%Gr4Male	Repetition rate in Grade 4 of lower secondary general education, male (%)	Repetition rate in Grade 4 of lower secondary general education, male (%)	REPR.2.G4.M.CP
EdSecLowrRpt%Gr5BothSexes	Repetition rate in Grade 5 of lower secondary general education, both sexes (%)	Repetition rate in Grade 5 of lower secondary general education, both sexes (%)	REPR.2.G5.CP
EdSecLowrRpt%Gr5Female	Repetition rate in Grade 5 of lower secondary general education, female (%)	Repetition rate in Grade 5 of lower secondary general education, female (%)	REPR.2.G5.F.CP
EdSecLowrRpt%Gr5Male	Repetition rate in Grade 5 of lower secondary general education, male (%)	Repetition rate in Grade 5 of lower secondary general education, male (%)	REPR.2.G5.M.CP
EdSecLowrRpt%GrAllBothSexes	Repetition rate in lower secondary general education (all grades), both sexes (%)	Repetition rate in lower secondary general education (all grades), both sexes (%)	REPR.2.CP
EdSecLowrRpt%GrAllFemale	Repetition rate in lower secondary general education (all grades), female (%)	Repetition rate in lower secondary general education (all grades), female (%)	REPR.2.F.CP
EdSecLowrRpt%GrAllMale	Repetition rate in lower secondary general education (all grades), male (%)	Repetition rate in lower secondary general education (all grades), male (%)	REPR.2.M.CP
add calebs tables here

Data Pulling Instructions

1. Go to https://databrowser.uis.unesco.org/resources/bulk
2. Download Education SDG, Education Other Policy Relevant Indicators, and R&D SDG
   1. Under SDG 4 Education - Global and Thematic Indicators find file: SDG
   2. Under Other Policy Relevant Indicators (OPRI) find file: OPRI
   3. Under SDG 9.5 - Research and Development (R&D) find file: SCN-SDG
   4. Upzip the downloaded files.
      1. Use {File name}_COUNTRY.csv to prepare country concordance table.
      2. Use {File name}_NATIONAL.csv to extract series.
      3. Use {File name}_LABEL.csv to check the definition of the "INDICATOR_ID" listed below.
         
   5. You can use the code in this GitHub to help pull the data: https://github.com/n1shamin/UIS-UNESCO

Coding

Notes:

2. Series need to be calculated: PupilTeacherRatioUISPrimary, PupilTeacherRatioUISSecondary, EDPriPTR, EdSecLowrPTR, EdExpPrePri%EducTot, EdExpPri%EducTot, EdExpSecLowr%EducTot, EdExpSec%EducTot, EdExpSecUppr%EducTot, EdExpTer%EducTot, EdTerGrads%Sci, GovtEdPub%GDP, EdExpISCED1-4Cap%, EdExpISCED1-4TotalCur%, EdExpISCED1-4NonSalCur%, EdExpISCED1-4Sal%

3. All the series in "Enrollment Headcount" need to *0.000001 to convert to "Millions".

4. Item Understanding in INDICATOR_ID:

Item	Meaning
02	pre-primary
1	primary
2	lower secondary
3	upper secondary
2T3	secondary
4	post-secondary non-tertiary
5T8	tertiary
6T7	ISCED 6 and 7
1T8	primary to tertiary
F	female
M	male
GPIA	adjusted gender parity index
LPIA	adjusted location parity index
WPIA	adjusted wealth parity index
G1	Grade 1
G2T3	Grade 2 or 3
GLAST	last grade
F500	Natural Sciences, Mathematics and Statistics
F600	Information and Communication Technologies
F700	Engineering, Manufacturing and Construction
F800	Agriculture, Forestry, Fisheries and Veterinary
F900	Health and Welfare

Variable	Type	File	INDICATOR_ID	UsedInPreprocessor	UsedInPreprocessorFileName
EdPriCompletionTotal%	Completion rate	SDG	CR.1	1	EDUCATION
EdPriCompletionFemale%	Completion rate	SDG	CR.1.F	1	EDUCATION
EdPriCompletionMale%	Completion rate	SDG	CR.1.M	1	EDUCATION
EdPriCompletionTotal	Completion rate	SDG	CR.1	0
EdPriCompletionTotal%BL	Completion rate	SDG	CR.1	0
EdPriCompletionFemale	Completion rate	SDG	CR.1.F	0
EdPriCompletionFemale%BL	Completion rate	SDG	CR.1.F	0
EdPriCompletionParity	Completion rate	SDG	CR.1.GPIA	0
EdPriCompletionMale	Completion rate	SDG	CR.1.M	0
EdPriCompletionMale%BL	Completion rate	SDG	CR.1.M	0
EdSecLowrCompletionTotal	Completion rate	SDG	CR.2	0
EdSecLowrCompletionFemale	Completion rate	SDG	CR.2.F	0
EdSecLowrCompletionMale	Completion rate	SDG	CR.2.M	0
EdSecUpprCompletionTotal	Completion rate	SDG	CR.3	0
EdSecUpprCompletionFemale	Completion rate	SDG	CR.3.F	0
EdSecUpprCompletionMale	Completion rate	SDG	CR.3.M	0
EdPriDuration	Duration	OPRI	299932	1	EDUCATION
EdSecLowerDuration	Duration	OPRI	999976	1	EDUCATION
EdSecUpperDuration	Duration	OPRI	999978	1	EDUCATION
EdPrePriDuration	Duration	OPRI	299929	0
EdPostSecDuration	Duration	OPRI	999988	0
EdSecDuration	Duration	OPRI	THDUR.2T3	0
EdExpISCED1-4Cap%	Education Expenditure	OPRI	XSPENDP.1.FDPUB.FNCAP + XSPENDP.2.FDPUB.FNCAP + XSPENDP.3.FDPUB.FNCAP + XSPENDP.4.FDPUB.FNCAP	0
EdExpISCED1-4TotalCur%	Education Expenditure	OPRI	XSPENDP.1.FDPUB.FNCUR + XSPENDP.2.FDPUB.FNCUR + XSPENDP.3.FDPUB.FNCUR + XSPENDP.4.FDPUB.FNCUR	0
EdExpISCED1-4NonSalCur%	Education Expenditure	OPRI	XSPENDP.1.FDPUB.FNNONS + XSPENDP.2.FDPUB.FNNONS + XSPENDP.3.FDPUB.FNNONS + XSPENDP.4.FDPUB.FNNONS	0
EdExpISCED1-4Sal%	Education Expenditure	OPRI	XSPENDP.1.FDPUB.FNS + XSPENDP.2.FDPUB.FNS + XSPENDP.3.FDPUB.FNS + XSPENDP.4.FDPUB.FNS	0
EdExpTerCap%	Education Expenditure	OPRI	XSPENDP.5T8.FDPUB.FNCAP	0
EdExpTertTotalCur%	Education Expenditure	OPRI	XSPENDP.5T8.FDPUB.FNCUR	0
EdExpTertNonSalCur%	Education Expenditure	OPRI	XSPENDP.5T8.FDPUB.FNNONS	0
EdExpTertSal%	Education Expenditure	OPRI	XSPENDP.5T8.FDPUB.FNS	0
EdSecLowerAdultGrads25Total%	Educational attainment rate	SDG	EA.2T8.AG25T99	0
EdSecLowerAdultGrads25Female%	Educational attainment rate	SDG	EA.2T8.AG25T99.F	0
EdSecLowerAdultGrads25Male%	Educational attainment rate	SDG	EA.2T8.AG25T99.M	0
EdPriEnrollHeadCountTtl	Enrollment Headcount	OPRI	20062	0
EdPriEnrollHeadcountFem	Enrollment Headcount	OPRI	20063	0
EdSecLowerEnrollHeadcountTotal	Enrollment Headcount	OPRI	20064	0
EdSecLowerEnrollHeadcountFemale	Enrollment Headcount	OPRI	20065	0
EdSecUpperEnrollHeadcountTotal	Enrollment Headcount	OPRI	20070	0
EdSecUpperEnrollHeadcountFemale	Enrollment Headcount	OPRI	20071	0
EdSecEnrNoTot	Enrollment Headcount	OPRI	20082	0
EdSecEnrNoFem	Enrollment Headcount	OPRI	20083	0
EdTerEnrollHeadcountTotal	Enrollment Headcount	OPRI	25053	0
EdTerEnrollHeadcountFem	Enrollment Headcount	OPRI	25057	0
EdPriEnrollHeadcountMal	Enrollment Headcount	OPRI	40035	0
EdSecLowerEnrollHeadcountMale	Enrollment Headcount	OPRI	40038	0
EdSecUpperEnrollHeadCountMale	Enrollment Headcount	OPRI	40041	0
EdSecEnrNoMal	Enrollment Headcount	OPRI	40044	0
EdTerEnrISCED6HdctMale	Enrollment Headcount	OPRI	42615	0
EdTerEnrollHeadcountMale	Enrollment Headcount	OPRI	42620	0
EdTerEnrISCED6HdctFem	Enrollment Headcount	OPRI	42635	0
EdTerEnrISCED6HdctTot	Enrollment Headcount	OPRI	42654	0
GovtEdPub%GDP	Government Expenditure	OPRI	XGDP.02.FSGOV + XGDP.1.FSGOV + XGDP.2.FSGOV + XGDP.3.FSGOV + XGDP.4.FSGOV + XGDP.5T8.FSGOV	1	ECONOMY
EdExpPrePri%EducTot	Government Expenditure	OPRI	X.USCONST.02.FSGOV/X.USCONST.FSGOV	0
EdExpPri%EducTot	Government Expenditure	OPRI	X.USCONST.1.FSGOV/X.USCONST.FSGOV	0
EdExpSecLowr%EducTot	Government Expenditure	OPRI	X.USCONST.2.FSGOV/X.USCONST.FSGOV	0
EdExpSec%EducTot	Government Expenditure	OPRI	X.USCONST.2T3.FSGOV/X.USCONST.FSGOV	0
EdExpSecUppr%EducTot	Government Expenditure	OPRI	X.USCONST.3.FSGOV/X.USCONST.FSGOV	0
EdExpTer%EducTot	Government Expenditure	OPRI	X.USCONST.5T8.FSGOV/X.USCONST.FSGOV	0
EdPriEnrollGrossTotalPcnt	Gross enrolment ratio	OPRI	GER.1	1	EDUCATION
EdPriEnrollGrossFemalePcnt	Gross enrolment ratio	OPRI	GER.1.F	1	EDUCATION
EdPriEnrollGrossMalePcnt	Gross enrolment ratio	OPRI	GER.1.M	1	EDUCATION
EdSecLowerEnrollGross%Total	Gross enrolment ratio	OPRI	GER.2	1	EDUCATION
EdSecLowerEnrollGross%Female	Gross enrolment ratio	OPRI	GER.2.F	1	EDUCATION
EdSecLowerEnrollGross%Male	Gross enrolment ratio	OPRI	GER.2.M	1	EDUCATION
EdSecEnrollGross%Total	Gross enrolment ratio	OPRI	GER.2T3	1	EDUCATION
EdSecEnrollGross%Female	Gross enrolment ratio	OPRI	GER.2T3.F	1	EDUCATION
EdSecEnrollGross%Male	Gross enrolment ratio	OPRI	GER.2T3.M	1	EDUCATION
EdSecUpperEnrollGross%Total	Gross enrolment ratio	OPRI	GER.3	1	EDUCATION
EdSecUpperEnrollGross%Female	Gross enrolment ratio	OPRI	GER.3.F	1	EDUCATION
EdSecUpperEnrollGross%Male	Gross enrolment ratio	OPRI	GER.3.M	1	EDUCATION
EdTerEnrollGross%Total	Gross enrolment ratio	SDG	GER.5T8	1	EDUCATION
EdTerEnrollGross%Female	Gross enrolment ratio	SDG	GER.5T8.F	1	EDUCATION
EdTerEnrollGross%Male	Gross enrolment ratio	SDG	GER.5T8.M	1	EDUCATION
EdBasicEnrollGross%Total	Gross enrolment ratio	OPRI	GER.1T2	0
EdBasicEnrollGross%Female	Gross enrolment ratio	OPRI	GER.1T2.F	0
EdBasicEnrollGross%Male	Gross enrolment ratio	OPRI	GER.1T2.M	0
EdSecLowerEnrollGrossParity	Gross enrolment ratio	OPRI	GER.2.GPIA	0
EdSecEnrollGross%Parity	Gross enrolment ratio	OPRI	GER.2T3.GPIA	0
EdSecUpperEnrollGrossParity	Gross enrolment ratio	OPRI	GER.3.GPIA	0
EdSecUpperEnrollGrossParityNew	Gross enrolment ratio	OPRI	GER.3.GPIA	0
EdTerFemaleMaleRatio	Gross enrolment ratio	SDG	GER.5T8.GPIA	0
EdTerGradRate1stDegreeTotal%	Gross graduation ratio	OPRI	GGR.6T7	1	EDUCATION
EdTerGradRate1stDegreeFemale%	Gross graduation ratio	OPRI	GGR.6T7.F	1	EDUCATION
EdTerGradRate1stDegreeMale%	Gross graduation ratio	OPRI	GGR.6T7.M	1	EDUCATION
EdPriAIRTotal%	Gross intake ratio	SDG	AIR.1.GLAST	1	EDUCATION
EdPriAIRFemale%	Gross intake ratio	SDG	AIR.1.GLAST.F	1	EDUCATION
EdPriAIRMale%	Gross intake ratio	SDG	AIR.1.GLAST.M	1	EDUCATION
EdPriAIRParity	Gross intake ratio	SDG	AIR.1.GLAST.GPIA	0
EdPri2and3ParityGenderMath	MATH	SDG	MATH.G2T3.GPIA	0
EdPri2and3ParityRurUrbMath	MATH	SDG	MATH.G2T3.LPIA	0
EdPri2and3ParitySocioeconMath	MATH	SDG	MATH.G2T3.WPIA	0
EdSecLwrParityGenderMath	MATH	SDG	MATH.LOWERSEC.GPIA	0
EdSecLwrParityRurUrbMath	MATH	SDG	MATH.LOWERSEC.LPIA	0
EdSecLwrParitySocioeconMath	MATH	SDG	MATH.LOWERSEC.WPIA	0
EdPriParityGenderMath	MATH	SDG	MATH.PRIMARY.GPIA	0
EdPriParityRurUrbMath	MATH	SDG	MATH.PRIMARY.LPIA	0
EdPriParitySocioeconMath	MATH	SDG	MATH.PRIMARY.WPIA	0
EdPriEntranceAge	Official entrance age	OPRI	299905	1	EDUCATION
EdPriOutofSchoolTotal%	Out-of-school rate	SDG	ROFST.1.CP	0
EdPriOutofSchoolFemale%	Out-of-school rate	SDG	ROFST.1.F.CP	0
EdPriOutofSchoolMale%	Out-of-school rate	SDG	ROFST.1.M.CP	0
EdEnrollPrivate%Primary	Percentage of enrolment in private	OPRI	PRP.1	0
EdEnrollPrivate%Lower2ndaryGeneral	Percentage of enrolment in private	OPRI	PRP.2	0
EdEnrollPrivateAll2ndaryCombined	Percentage of enrolment in private	OPRI	PRP.2T3	0
EdEnrollPrivate%Upper2ndaryGeneral	Percentage of enrolment in private	OPRI	PRP.3	0
EdEnrollPrivateUpper2ndaryGeneral	Percentage of enrolment in private	OPRI	PRP.3	0
EdTerGrads%SciEngg	Percentage of graduates from tertiary	OPRI	FOSGP.5T8.F500	1	EDUCATION
EdTerGrads%Sci	Percentage of graduates from tertiary	OPRI	FOSGP.5T8.F500 + FOSGP.5T8.600	0
EdTerGrads%Engg	Percentage of graduates from tertiary	OPRI	FOSGP.5T8.F700	0
EdTerGrads%Ag	Percentage of graduates from tertiary	OPRI	FOSGP.5T8.F800	0
EdTerGrads%Health	Percentage of graduates from tertiary	OPRI	FOSGP.5T8.F900	0
EDPriPTR	PTR	OPRI	20062/20162	1	EDUCATION
PupilTeacherRatioUISPrimary	PTR	OPRI	20062/20162	0
EdSecLowrPTR	PTR	OPRI	20064/20164	0
PupilTeacherRatioUISSecondary	PTR	OPRI	20082/20182	0
EdPrePriParityGenderTeachers	Pupil-trained teacher ratio	SDG	PTRHC.02.TRAINED	0
EdPriParityGenderTeachers	Pupil-trained teacher ratio	SDG	PTRHC.1.TRAINED	0
PupilTrainedTeacherRatioUISPrimary	Pupil-trained teacher ratio	SDG	PTRHC.1.TRAINED	0
EdSecLwrParityGenderTeachers	Pupil-trained teacher ratio	SDG	PTRHC.2.TRAINED	0
PupilTrainedTeacherRatioUISSecondary	Pupil-trained teacher ratio	SDG	PTRHC.2T3.TRAINED	0
EdSecUpperParityGenderTeachers	Pupil-trained teacher ratio	SDG	PTRHC.3.TRAINED	0
R&DGovt%GDP	R&D%GDP	SCN-SDG	EXPGDP.TOT	1	ECONOMY
EdPri2and3ParityGenderRead	READ	SDG	READ.G2T3.GPIA	0
EdPri2and3ParityRurUrbRead	READ	SDG	READ.G2T3.LPIA	0
EdPri2and3ParitySocioeconRead	READ	SDG	READ.G2T3.WPIA	0
EdSecLwrParityGenderRead	READ	SDG	READ.LOWERSEC.GPIA	0
EdSecLwrParityRurUrbRead	READ	SDG	READ.LOWERSEC.LPIA	0
EdSecLwrParitySocioeconRead	READ	SDG	READ.LOWERSEC.WPIA	0
EdPriParityGenderRead	READ	SDG	READ.PRIMARY.GPIA	0
EdPriParityRurUrbRead	READ	SDG	READ.PRIMARY.LPIA	0
EdPriParitySocioeconRead	READ	SDG	READ.PRIMARY.WPIA	0
EdPriRepeaterTotal%	Repetition rate	OPRI	REPR.1.CP	0
EdPriRepeaterFemale%	Repetition rate	OPRI	REPR.1.F.CP	0
EdPriRepeater1stYearTotal%	Repetition rate	OPRI	REPR.1.G1.CP	0
EdPriRepeater1stYearFemale%	Repetition rate	OPRI	REPR.1.G1.F.CP	0
EdPriRepeater1stYearMale%	Repetition rate	OPRI	REPR.1.G1.M.CP	0
EdPriRepeaterMale%	Repetition rate	OPRI	REPR.1.M.CP	0
EdExpectedYearsofSchooling	School life expectancy	OPRI	SLE.1T8	0
EdExpectedYearsofSchoolingFemale	School life expectancy	OPRI	SLE.1T8.F	0
EdExpectedYearsofSchoolingMale	School life expectancy	OPRI	SLE.1T8.M	0
EdSecLowerVoc%AllTotal	Share of all students in vocational programmes	OPRI	GTVP.2.V	1	EDUCATION
EdSecUpperVoc%AllTotal	Share of all students in vocational programmes	OPRI	GTVP.3.V	1	EDUCATION
EdSecVoc%Tot	Share of all students in vocational programmes	OPRI	GTVP.2T3.V	0
EdPriSurvivalTotal%	Survival rate	OPRI	SR.1.GLAST.CP	1	EDUCATION
EdPriSurvivalFemale%	Survival rate	OPRI	SR.1.GLAST.F.CP	1	EDUCATION
EdPriSurvivalMale%	Survival rate	OPRI	SR.1.GLAST.M.CP	1	EDUCATION
EdPriSurvivalParity	Survival rate	OPRI	SR.1.GLAST.GPIA	0
EdPriEnrollNetTotalPcnt	Total net enrolment rate	OPRI	NERT.1.CP	1	EDUCATION
EdPriEnrollNetFemalePcnt	Total net enrolment rate	OPRI	NERT.1.F.CP	1	EDUCATION
EdPriEnrollNetMalePcnt	Total net enrolment rate	OPRI	NERT.1.M.CP	1	EDUCATION
EdPriEnrollNetParity	Total net enrolment rate	OPRI	NERT.1.GPIA	0
EdSecLowerNetEnrollTot%	Total net enrolment rate	OPRI	NERT.2.CP	0
EdSecLowerNetEnrollFemale%	Total net enrolment rate	OPRI	NERT.2.F.CP	0
EdSecLowerNetEnrollMale%	Total net enrolment rate	OPRI	NERT.2.M.CP	0
EdSecUpperNetEnrollTot%	Total net enrolment rate	OPRI	NERT.3.CP	0
EdSecUpperNetEnrollFemale%	Total net enrolment rate	OPRI	NERT.3.F.CP	0
EdSecUpperNetEnrollMale%	Total net enrolment rate	OPRI	NERT.3.M.CP	0

Pulling Data on Enrollment in Vocational Programmes:

The pre-processor series in IFs relating to enrollment in vocational programmes are:

1. EdSecUpperVoc%AllMale
2. EdSecUpperVoc%AllFemale
3. EdSecUpperVoc%AllTotal
4. EdSecLowerVoc%AllMale
5. EdSecLowerVoc%Allfemale
6. EdSecLowerVoc%AllTotal

Data for these series was obtained from the UIS Education Database in the following drop down menu sequence: Education>Participation>Distribution of Enrollment>Distribution of Enrollment by Programme Orientation.

Because these particular series contain confusing wording, the full names in UIS of each fo the six series are provided below.

1. Percentage of male students in lower secondary education enrolled in vocational programmes, male (%)
2. Percentage of female students in lower secondary education enrolled in vocational programmes, female (%)
3. Percentage of students in lower secondary education enrolled in vocational programmes, both sexes (%)
4. Percentage of male students in upper secondary education enrolled in vocational programmes, male (%)
5. Percentage of female students in upper secondary education enrolled in vocational programmes, female (%)
6. Percentage of students in upper secondary education enrolled in vocational programmes, both sexes (%)

Pulling Data on Educational Expenditure:

The pre-processor series in IFs relating to educational expenditure are:

1. EdExpPri%GDPPC
2. EdExpSec%GDPPC
3. EdExpSecLowr%GDPPC
4. EdExpSecUppr%GDPPC
5. EdExpTer%GDPP

Data for these series was obtained from the UNESCO Institute for Statistics (http://data.uis.unesco.org/). Specifically, they are found in the following drop down menu sequence: Education>Financial Resources>Government Expenditure per Student>Government Expenditure per Student as Percentage of GDP per capita. 

Once here, the following 5 sheets were used: Government expenditure per (primary/secondary/lower seconday/upper seconday/tertiary) student as percentage of GDP per capita.

Pulling Data on Graduation Rates:

The pre-processor series in IFs relating to graduation rates are:

1. EdTerGradRate1stDegreeFemale% 
2. EdterGradRate1stDegreeMale%
3. EdTerGradRate1stDegreeTotal%
4. EdTerGrad%SciEngg
5. EdPriCompletionFemale%
6. EdPriCompletionMale%
7. EdPriCompletionTotal%

Data for these series was obtained from the UNESCO Institute for Statistics (http://data.uis.unesco.org/). Specifically, they are found in the following drop down menu sequence: Education>Completion and Graduation Ratios>Gross Graduation Ratio.

Once here, the following 4 sheets were used: Gross Graduation Ratio from First Degree Programmes (ISCED 6 & 7) in Tertiary Education, (Female (%)/Male (%)/Both Sexes (%)).

For 5-7 above, the following 3sheets were used:(Gross Graduation Ratio from Primary Education, (Female(%)/Male(%)/Both Sexes (%)).

Pulling Data on Completion Rates:

The pre-processor series in IFs relating to graduation rates are:

1. EdSecLowrCompletionFemale
2. EdSecLowrCompletionMale
3. EdSecLowrCompletionTotal
4. EdSecUpprCompletionFemale
5. EdSecUpprCompletionMale
6. EdSecUpprCompletionTotal

Data for these series was obtained from the UNESCO Institute for Statistics (http://data.uis.unesco.org/). Specifically, they are found in the following dropdown menu sequence: Education>Education>Completion>Completion and graduation ratios. The specific location for each series is as follows.

• EdPriCompletionFemale: Education>Education>Completion>Completion and graduation ratios>Completion rate for primary education (household survey data), select female (%) from dropdown
• EdPriCompletionMale: Education>Education>Completion>Completion and graduation ratios>Completion rate for primary education (household survey data), select male (%) from dropdown
• EdPriCompletionTotal: Education>Education>Completion>Completion and graduation ratios>Completion rate for primary education (household survey data), Both Sexes (%)
• EdSecLowrCompletionFemale: Education>Education>Completion>Completion and graduation ratios>Completion rate for lower secondary education (household survey data), select female (%) from dropdown
• EdSecLowrCompletionMale: Education>Education>Completion>Completion and graduation ratios>Completion rate for lower secondary education (household survey data), select male (%) from dropdown
• EdSecLowrCompletionTotal: Education>Education>Completion>Completion and graduation ratios>Completion rate for lower secondary education (household survey data), select both sexes (%) from dropdown
• EdSecUpprCompletionFemale: Education>Education>Completion>Completion and graduation ratios>Completion rate for upper secondary education (household survey data), select female (%) from dropdown
• EdSecUpprCompletionMale: Education>Education>Completion>Completion and graduation ratios>Completion rate for upper secondary education (household survey data), select male (%) from dropdown
• EdSecUpprCompletionTotal: Education>Education>Completion>Completion and graduation ratios>Completion rate for upper secondary education (household survey data), select both sexes (%) from dropdown

Pulling Data on Intake Rates:

The pre-processor series in IFs relating to apparent (gross) intake rates are:

1. EdPriAIRFemale%
2. EdPriAIRMale%
3. EdPriAIRParity
4. EdPriAIRTotal%

Data for these series was obtained from the UNESCO Institute for Statistics (http://data.uis.unesco.org/). Specifically, they are found in the following drop down menu sequence: Education>Entry>Gross (Apparent) Intake Ratio to Primary and Lower Secondary Education.

Once here, the following three sheets were used: Gross Intake Rate to Grade 1 of Primary Education, (Female%/Male%/Total/GenderParityIndex (GPI)).

The pre-processor series in IFs relating to net (adjusted) intake rates are:

1. EdPriNIRFemale%
2. EdPriNIRMale%
3. EdPriNIRTotal%

Data for these series was obtained from the UNESCO Institute for Statistics (http://data.uis.unesco.org/). Specifically, they are found in the following drop down menu sequence: Education>Entry>Gross (Apparent) Intake Ratio to Primary and Lower Secondary Education.

Once here, the following three sheets were used: Adjusted Net Intake Rate to Grade 1 of Primary Education, (Female/Male/Total).

Net Intake Rate to Grade1 of Primary Education

EDPRINIRENTRNFemale

EDPRINIRENTRNMale

EDPRINIRENTRNTotal

http://data.uis.unesco.org/

• education>entry>net intake rate to primary education> Net intake rate to Grade 1 of primary education, female (%)
• education>entry>net intake rate to primary education> Net Intake Rate to Grade1 of Primary Education male (%)
• education>entry>net intake rate to primary education> Net Intake Rate to Grade1 of Primary Education both sexes (%)

Net Intake Rate to Grade1 of Primary Education (over-age by +1 year)

EDPRINIRENTRNP1Male

EDPRINIRENTRNP1Female

EDPRINIRENTRNP1Total

http://data.uis.unesco.org/

• education>entry>net intake rate to primary education> Net intake rate to Grade 1 of primary education by over-age entrants (+1 year), male (%)
• education>entry>net intake rate to primary education> Net intake rate to Grade 1 of primary education by over-age entrants (+1 year), female (%)
• education>entry>net intake rate to primary education> Net intake rate to Grade 1 of primary education by over-age entrants (+1 year), both sexes (%)
  

Net intake rate to Grade 1 of primary education by under-age entrants (-1 year), male (%)

EDPRINIRENTRNM1Male

EDPRINIRENTRNM1Female

EDPRINIRENTRNM1Total

http://data.uis.unesco.org/

• education>entry>net intake rate to primary education> Net intake rate to Grade 1 of primary education by under-age entrants (-1 year), male (%)
• education>entry>net intake rate to primary education> Net intake rate to Grade 1 of primary education by under-age entrants (-1 year), female (%)
• education>entry>net intake rate to primary education> Net intake rate to Grade 1 of primary education by under-age entrants (-1 year), both sexes (%)
  

Adjusted Net Intake Rate to Grade1 of Primary Education

EDPRINIRADJFemale

EDPRINIRADJMale

EDPRINIRADJTotal

http://data.uis.unesco.org/

• education>entry>net intake rate to primary education> Adjusted net intake rate to Grade 1 of primary education, female (%)
• education>entry>net intake rate to primary education> Adjusted net intake rate to Grade 1 of primary education, male (%)
• education>entry>net intake rate to primary education> Adjusted net intake rate to Grade 1 of primary education, both sexes (%)

Pulling Data on Survival Rates:

The pre-processor series in IFs relating to survival rates are:

1. EdPriSurvivalFemale%
2. EdPriSurvivalMale%
3. EdPriSurvivalTotal%

Data for these series was obtained from the UNESCO Institute for Statistics (http://data.uis.unesco.org/). Specifically, they are found in the following drop down menu sequence: Education>Progression>Survival Rates>Survival Rate to Last Grade of Primary Education.

Once here, the following three sheets were used: Survival Rate to the Last Grade of Primary Education, (Female%/Male%/Total%).

Pulling Data on Duration:

The pre-processor series in IFs relating to survival rates are:

1. EdPriDuration
2. EdSecLowerDuration
3. EdSecUpperDuration

Data for these series was obtained from the UNESCO Institute for Statistics (http://data.uis.unesco.org/). Specifically, they are found in the following drop down menu sequence: Education>System>Duration>Duration by Level of Education.

Once here, the following three sheets were used: Theoretical Duration of (Primary/Lower Seconday/Upper Secondary) Education.

Pulling Data on Transition Rates:

The pre-processor series in IFs relating to transition rates are:

1. EdPriTransition2Sec%Female
2. EdPriTransition2Sec%Male
3. EdPriTransition2SecTotal%

Data for these series was obtained from the UNESCO Institute for Statistics (http://data.uis.unesco.org/). Specifically, they are found in the following drop down menu sequence: Education>Progression>Transition Rates.

Once here, the following three sheets were used: Effective Transition Rate from Primary to Lower Secondary General Education, (Female%/Male%/Total%).

Data Notes

1. As of May 2016, there was no data for 2015 for the LowerVoc series, only 1999-2014. However, there was 2015 data  for the UpperVoc series.
2. Country Concordance: UNESCO countries. 
   1. As of March 2017, UIS utilizes "Cabo Verde" instead of "Cape Verde." The UNESCO Country Concordance utilizes "Cape Verde." You thus must replace "Cabo Verde" with "Cape Verde" in UIS data prior to importing into IFs.