DataBrighten

    Share of all students in lower secondary education enrolled in vocational programmes (%)

    1,145 × 6rows × columns: 110 countries, 1998 to 2020

    Real data: World Bank, Gender Statistics, indicator UIS.GTVP.2.V, retrieved 19 November 2026. Values are as published; we only reshaped the file.

    textnumberdateyes/no
    Rows1,145country-year values
    Countries110with at least one value
    Years1998 – 202023 years with data
    LicenceCC BY 4.0credit the World Bank

    What it measures

    Total number of students enrolled in vocational programmes at the lower secondary education level, expressed as a percentage of the total number of students enrolled in all programmes (vocational and general) at the lower secondary level. Vocational education is designed for learners to acquire the knowledge, skills and competencies specific to a particular occupation or trade or class of occupations or trades. Vocational education may have work-based components (e.g. apprenticeships). Successful completion of such programmes leads to labour-market relevant vocational qualifications acknowledged as occupationally-oriented by the relevant national authorities and/or the labour market.

    The numbers in 2018

    In 2018, 50 countries have a value. The highest is Suriname (35.34); at the bottom, 6 countries tie at 0 (e.g. British Virgin Islands, Burundi, China). The median country value is 2.4. The World Bank's World aggregate for 2019 is 1.38.

    Top 10 countries, 2018

    %

    Source: World Bank, UIS.GTVP.2.V, retrieved 19 November 2026. Computed from share-of-all-students-in-lower-secondary-education-enrolled-in-vocational-programmes-perce.csv.

    Highest, 2018

    #CountryValue
    1Suriname35.34
    2Mexico23.1
    3Uruguay20.51
    4Belgium19.49
    5Costa Rica17.24
    6Ireland16.81
    7United Kingdom15.4
    8Mauritius13.77
    9Australia12.72
    10Maldives11.77

    Lowest, 2018

    Ties are listed A to Z.

    #CountryValue
    1Mauritania0
    2Liechtenstein0
    3Comoros0
    4China0
    5Burundi0
    6British Virgin Islands0
    7Brazil0.0427
    8St. Lucia0.0731
    9Chad0.0954
    10Hungary0.149
    How many countries report, by decade
    DecadeMost countries in one year
    1990s47
    2000s62
    2010s59
    2020s1

    World aggregate by year

    As published by the World Bank (in the regions file, not the country file).

    YearWorld
    20191.38
    20181.38
    20171.4
    20161.4
    20151.38
    20141.43
    20131.43
    20121.35
    20111.27
    20101.26
    20091.25
    20081.26

    By region, 2018

    World Bank regionValue
    Latin America & Caribbean 5.99
    Middle East, North Africa, Afghanistan & Pakistan2.47
    Europe & Central Asia1.99
    Sub-Saharan Africa 1.81
    East Asia & Pacific0.201
    South Asia0.00251
    North America0

    First rows

    share-of-all-students-in-lower-secondary-education-enrolled-in-vocational-programmes-perce.csv

    countrytextiso3textregiontextincome_grouptextyearnumbervaluenumber
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20010
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20040
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20050
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20060
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20070
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20080
    AlgeriaDZAMiddle East, North Africa, Afghanistan & PakistanUpper middle income19997.22591
    AlgeriaDZAMiddle East, North Africa, Afghanistan & PakistanUpper middle income20007.97906

    Data dictionary

    ColumnTypeMeaning
    countrytextCountry or economy, World Bank name
    iso3textISO 3166-1 alpha-3 code
    regiontextWorld Bank region
    income_grouptextWorld Bank income group
    yearnumberCalendar year of the value
    valuenumberShare of all students in lower secondary education enrolled in vocational programmes (%), exactly as the World Bank API returns it (not rounded)

    Only country-years with a value are in the long file; blank cells in the wide file mean no value was published.

    Practice questions

    answers computed from the file

    Which country has the highest value in 2018?

    Suriname, with 35.34.

    Excel (on the long CSV: E = year, F = value)

    =FILTER(A2:A100000,(E2:E100000=2018)*(F2:F100000=MAXIFS(F2:F100000,E2:E100000,2018)))

    SQL (table wb = the CSV)

    SELECT country, value FROM wb WHERE year = 2018
      AND value = (SELECT MAX(value) FROM wb WHERE year = 2018);

    pandas (df = pd.read_csv("share-of-all-students-in-lower-secondary-education-enrolled-in-vocational-programmes-perce.csv"))

    y = df[df.year == 2018]
    y[y.value == y.value.max()][["country", "value"]]

    File: share-of-all-students-in-lower-secondary-education-enrolled-in-vocational-programmes-perce.csv

    How many countries report a value for 2018?

    50 of the 217 economies in the file's country list.

    Excel (on the long CSV: E = year, F = value)

    =COUNTIF(E2:E100000,2018)

    SQL (table wb = the CSV)

    SELECT COUNT(*) FROM wb WHERE year = 2018;

    pandas (df = pd.read_csv("share-of-all-students-in-lower-secondary-education-enrolled-in-vocational-programmes-perce.csv"))

    (df.year == 2018).sum()

    File: share-of-all-students-in-lower-secondary-education-enrolled-in-vocational-programmes-perce.csv

    What is the median across countries in 2018?

    2.4 (median of the 50 country values; not a World Bank aggregate).

    Excel (on the long CSV: E = year, F = value)

    =MEDIAN(FILTER(F2:F100000,E2:E100000=2018))

    SQL (table wb = the CSV)

    -- SQLite has no MEDIAN(); this picks the middle value(s)
    SELECT AVG(value) FROM (SELECT value FROM wb WHERE year = 2018 ORDER BY value
      LIMIT 2 - (SELECT COUNT(*) FROM wb WHERE year = 2018) % 2
      OFFSET (SELECT (COUNT(*) - 1) / 2 FROM wb WHERE year = 2018));

    pandas (df = pd.read_csv("share-of-all-students-in-lower-secondary-education-enrolled-in-vocational-programmes-perce.csv"))

    df[df.year == 2018]["value"].median()

    File: share-of-all-students-in-lower-secondary-education-enrolled-in-vocational-programmes-perce.csv

    Which country rose the most between 2008 and 2018?

    Uruguay: from 6.17 to 20.51, a rise of 14.34 (out of 34 countries with both years).

    Excel (on the long CSV: E = year, F = value)

    Use the wide file (share-of-all-students-in-lower-secondary-education-enrolled-in-vocational-programmes-perce-wide.csv): add a column = [2018] - [2008], then sort it largest to smallest.

    SQL (table wb = the CSV)

    SELECT a.country, b.value - a.value AS rise FROM wb a JOIN wb b ON a.iso3 = b.iso3
    WHERE a.year = 2008 AND b.year = 2018 ORDER BY rise DESC LIMIT 1;

    pandas (df = pd.read_csv("share-of-all-students-in-lower-secondary-education-enrolled-in-vocational-programmes-perce.csv"))

    w = df.pivot(index="country", columns="year", values="value")
    (w[2018] - w[2008]).dropna().nlargest(1)

    File: share-of-all-students-in-lower-secondary-education-enrolled-in-vocational-programmes-perce.csv

    Which year has the most countries reporting?

    2009, with 62 countries. (Later years are still filling in as countries report.)

    Excel (on the long CSV: E = year, F = value)

    Make a pivot table: year in Rows, Count of value in Values, then sort by the count.

    SQL (table wb = the CSV)

    SELECT year, COUNT(*) AS n FROM wb GROUP BY year ORDER BY n DESC, year DESC LIMIT 1;

    pandas (df = pd.read_csv("share-of-all-students-in-lower-secondary-education-enrolled-in-vocational-programmes-perce.csv"))

    df.groupby("year").size().sort_values(ascending=False).head(1)

    File: share-of-all-students-in-lower-secondary-education-enrolled-in-vocational-programmes-perce.csv