This project was part of a Data Science module, taught by Jozsef Konczer at Milestone Institute. For anyone interested in some materials here is a GITHUB.

Project idea and tips for how to use it:

◼
  • There are a lot of things to consider when we decide which universities to apply to.
    Using existing online data sets, I have collected some information which can be changed into your preferred ones, hoping that with them everyone can gain some deeper insights into the culture and style of universities in certain countries.
  • ◼
  • Since everyone looks at different properties when considering universities, I have placed the information in different sections, so you can choose what interests you.
  • Goals and contents:

    To quickly find out some interesting facts about universities:
    1
    .
    The university data set
    2
    .
    Computations:
    2
    .
    1
    .
    The university list in the chosen Area (for example the UK)
    2
    .
    2
    .
    More details about the universities in a certain country (for example the Netherlands)
    2
    .
    3
    .
    Universities in a certain continent (for example Europe)
    2
    .
    3
    .
    1
    .
    EU university properties list
    2
    .
    3
    .
    2
    .
    The number of universities there are in some chosen countries
    2
    .
    4
    .
    A timeline of accreditation in some countries
    2
    .
    5
    .
    Comparing some universities
    2
    .
    6
    .
    Most used motto words (top 100 universities with the most students)
    2
    .
    6
    .
    1
    .
    Overall
    2
    .
    6
    .
    2
    .
    Differences between the culture of several countries
    3
    .
    Summary

    The university data set:

    ◼
  • First, we need to know which universities are in the data set.
  • According to the data published by AUBSP (updated in April 2023), there are more than 29,257 universities in the world, but for this project, the 28,709 universities collected here are also satisfactory.
    In[]:=
    EntityList[EntityClass["University",All]]//Shallow
    Out[]//Shallow=
    
    360 Degrees Beauty Academy
    ,
    4-States Academy of Cosmetology
    ,
    4-States Okmulgee Academy of Cosmetology
    ,
    A & W Healthcare Educators
    ,
    A1 Business and Technical College
    ,
    Aanhui Vocational College of Press and Publishing
    ,
    ABC Adult School
    ,
    ABC Adult School - Cabrillo Lane
    ,
    ABCO Technology
    ,
    ABE International College of Business and Accountancy - Cebu City
    ,28709

    Computations:

    The examples are given in parentheses, you can freely change it.

    TheuniversitylistinthechosenArea(UK)

    As an example, here are the universities in the UK:
    In[]:=
    //Shallow
    Out[]//Shallow=
    
    All Souls College
    ,
    Anglia Ruskin University
    ,
    Aston University
    ,
    Balliol College
    ,
    Bath Spa University
    ,
    Bishop Grosseteste University
    ,
    Blackfriars
    ,
    Blackpool and The Fylde College
    ,
    Bournemouth University
    ,
    Brasenose College
    ,249

    More details about the universities in a certain country (the Netherlands)

    The education system in each country may not be so different, so it may be useful to sort them by country.​​​The basic information you can get based on the country can contain the following: - location of the university and the population of the city/town - the official website - population of the university - whether it is research or art focused - enrolments for undergraduates, graduates and the university as a whole - accrediting agency
    For example, here is a table of universities in the Netherlands:
    
    In[]:=
    universities in the Netherlands
    Input interpretation
    universities
    in Netherlands
    Result
    HU University of Applied Sciences Utrecht
    |
    University of Amsterdam
    |
    Leiden University
    |
    Utrecht University
    |
    Hogeschool van Arnhem en Nijmegen
    |
    University of Groningen
    |
    Vrije Universiteit Amsterdam
    |
    Tilburg University
    |
    Wageningen Universiteit en Researchcentrum
    |
    University of Twente
    |
    NHTV Internationale Hogeschool Breda
    |
    Christelijke Hogeschool Ede
    |
    Amsterdam University of the Arts
    |
    Marnix Academie
    |
    HAS University of Applied Sciences
    |
    Driestar Educatief
    |
    Christelijke Agrarische Hogeschool
    |
    Nyenrode Business Universiteit
    |
    International Institute of Social Studies
    |
    Hotelschool Den Haag, Internationale Hogeschool voor Hotel Management
    |
    Saxion Hogescholen
    |
    Design Academy Eindhoven(total:22)
    Basic information
    More
    location
    website
    type
    HU University of Applied Sciences Utrecht
    Utrecht,Netherlands (population: 321989people)
    www.hu.nl
    University of Amsterdam
    Amsterdam,Noord-Holland,Netherlands (population: 851573people)
    www.uva.nl
    Leiden University
    Leiden,Zuid-Holland,Netherlands (population: 118702people)
    www.leiden.edu
    Utrecht University
    Utrecht,Netherlands (population: 321989people)
    www.uu.nl
    Hogeschool van Arnhem en Nijmegen
    Arnhem,Gelderland,Netherlands (population: 141601people)
    www.han.nl
    University of Groningen
    Groningen,Netherlands (population: 200952people)
    www.rug.nl
    Vrije Universiteit Amsterdam
    Amsterdam,Noord-Holland,Netherlands (population: 851573people)
    www.vu.nl
    Tilburg University
    Tilburg,Noord-Brabant,Netherlands (population: 206134people)
    www.tilburguniversity.nl
    Wageningen Universiteit en Researchcentrum
    Wageningen,Gelderland,Netherlands (population: 35137people)
    www.wur.nl
    University of Twente
    Enschede,Overijssel,Netherlands (population: 152989people)
    www.utwente.nl
    NHTV Internationale Hogeschool Breda
    Breda,Noord-Brabant,Netherlands (population: 166035people)
    www.nhtv.nl
    Christelijke Hogeschool Ede
    Ede,Gelderland,Netherlands (population: 105495people)
    www.che.nl
    Amsterdam University of the Arts
    Amsterdam,Noord-Holland,Netherlands (population: 851573people)
    www.ahk.nl
    arts school
    Marnix Academie
    Utrecht,Netherlands (population: 321989people)
    www.hsmarnix.nl
    HAS University of Applied Sciences
    s-Hertogenbosch,Noord-Brabant,Netherlands (population: 143782people)
    www.hasdenbosch.nl
    Driestar Educatief
    Gouda,Zuid-Holland,Netherlands (population: 70942people)
    www.driestar-educatief.nl
    Christelijke Agrarische Hogeschool
    Dronten,Flevoland,Netherlands (population: 40616people)
    www.cah.nl
    Nyenrode Business Universiteit
    Breukelen,Utrecht,Netherlands (population: 14635people)
    www.nyenrode.nl
    International Institute of Social Studies
    The Hague,Zuid-Holland,Netherlands (population: 505568people)
    www.iss.nl
    Hotelschool Den Haag, Internationale Hogeschool voor Hotel Management
    Zuid-Holland,Netherlands
    www.hotelschool.nl
    Saxion Hogescholen
    Deventer,Overijssel,Netherlands (population: 89142people)
    www.saxion.edu
    Design Academy Eindhoven
    Eindhoven,Noord-Brabant,Netherlands (population: 218456people)
    www.designacademy.nl
    year founded
    HU University of Applied Sciences Utrecht
    1993 (30​yr ago)
    University of Amsterdam
    1632 (391​yr ago)
    Leiden University
    1575 (448​yr ago)
    Utrecht University
    1636 (387​yr ago)
    Hogeschool van Arnhem en Nijmegen
    1990 (33​yr ago)
    University of Groningen
    1614 (409​yr ago)
    Vrije Universiteit Amsterdam
    1880 (143​yr ago)
    Tilburg University
    1927 (96​yr ago)
    Wageningen Universiteit en Researchcentrum
    1876 (147​yr ago)
    University of Twente
    1961 (62​yr ago)
    NHTV Internationale Hogeschool Breda
    1967 (56​yr ago)
    Christelijke Hogeschool Ede
    1994 (29​yr ago)
    Amsterdam University of the Arts
    1987 (36​yr ago)
    Marnix Academie
    1984 (39​yr ago)
    HAS University of Applied Sciences
    1962 (61​yr ago)
    Driestar Educatief
    1945 (78​yr ago)
    Christelijke Agrarische Hogeschool
    1957 (66​yr ago)
    Nyenrode Business Universiteit
    1946 (77​yr ago)
    International Institute of Social Studies
    1952 (71​yr ago)
    Hotelschool Den Haag, Internationale Hogeschool voor Hotel Management
    1929 (94​yr ago)
    Saxion Hogescholen
    1989 (34​yr ago)
    Design Academy Eindhoven
    1947 (76​yr ago)
    gender of student body
    (all cases)
    men and women (coed)
    + Units
    Enrollment
    all students
    median
    4900people
    highest
    38000people (2009,2013,2016,2017,2018,and2019 estimates) (HU University of Applied Sciences Utrecht)
    lowest
    180people (2009,2013,2016,2017,2018,and2019 estimates) (Saxion Hogescholen and Design Academy Eindhoven)
    distribution
    Tuition
    local undergraduate students tuition
    median
    $1800 per year
    highest
    $2800 per year (HU University of Applied Sciences Utrecht)
    lowest
    $1800 per year (10universities)
    local graduate students tuition
    median
    $2800 per year
    highest
    $12000 per year (HU University of Applied Sciences Utrecht and International Institute of Social Studies)
    lowest
    $1800 per year (5universities)
    distribution
    international undergraduate students tuition
    median
    $6000 per year
    highest
    $9000 per year (3universities)
    lowest
    $1800 per year (NHTV Internationale Hogeschool Breda)
    distribution
    international graduate students tuition
    median
    $12000 per year
    highest
    $19000 per year (Leiden University)
    lowest
    $2800 per year (Hotelschool Den Haag, Internationale Hogeschool voor Hotel Management)
    distribution
    (according to 2009–10 school year estimates)
    Accrediting agency
    More
    accrediting agency
    HU University of Applied Sciences Utrecht
    Ministry of Education (1993)
    University of Amsterdam
    Ministerie van Onderwijs, Cultuur en Wetenschap
    Leiden University
    Ministerie van Onderwijs, Cultuur en Wetenschap
    Utrecht University
    Ministerie van Onderwijs, Cultuur en Wetenschap
    Hogeschool van Arnhem en Nijmegen
    Ministerie van Onderwijs, Cultuur en Wetenschap
    University of Groningen
    Ministerie van Onderwijs, Cultuur en Wetenschap (1614)
    Vrije Universiteit Amsterdam
    Ministerie van Onderwijs, Cultuur en Wetenschap
    Tilburg University
    Ministerie van Onderwijs, Cultuur en Wetenschap (1927)
    Wageningen Universiteit en Researchcentrum
    Ministerie van Onderwijs, Cultuur en Wetenschap
    University of Twente
    Ministerie van Onderwijs, Cultuur en Wetenschap
    NHTV Internationale Hogeschool Breda
    Ministerie van Onderwijs, Cultuur en Wetenschap
    HAS University of Applied Sciences
    NVAO (Dutch Flemish Accreditation Organisation)
    Driestar Educatief
    Ministry of Education (1950)
    Christelijke Agrarische Hogeschool
    NVAO (Dutch Flemish Accreditation Organisation)
    Nyenrode Business Universiteit
    Ministerie van Onderwijs, Cultuur en Wetenschap
    International Institute of Social Studies
    NVAO (Dutch Flemish Accreditation Organisation) (1952)
    Hotelschool Den Haag, Internationale Hogeschool voor Hotel Management
    NVAO (Dutch Flemish Accreditation Organization)
    Saxion Hogescholen
    Ministerie van Onderwijs, Cultuur en Wetenschap
    Design Academy Eindhoven
    NVAO (Dutch Flemish Accreditation Organisation) (2007)

    Universities in a certain continent (Europe)

    First, we may want to know which universities are included and what properties can we find information about:

    EU university properties list

    The number of universities there are in some chosen countries

    The idea here is that everyone can search for the countries they are interested in, for example let’s look at these:
    Here is a chart showing the numbers:

    Comparing some universities

    
    In[]:=
    Stanford University, University of Cambridge, University of Oxford, Harvard University

    Most used motto words (top 100 universities with the most students)

    It can be essential to know what cultural differences exist between countries, one of the interesting ways doing it is to look at their mottos, here are some word clouds showing how often a particular word appears in university mottos in the chosen country.

    Spain

    It is quite an interesting one, for Spain there is no word standing out:

    China

    For China, it is innovation, but other words are all playing similar importance here:

    Germany

    For Germany it is also knowledge, followed by light and wisdom:

    US

    In the US the future is the most used one, but tradition, knowledge and truth are also quite common here:

    UK

    Finally for the UK, it is research:

    Summary:

    We can learn a lot of facts about things we sometimes ignore. For example, by analysing the mottos of certain universities and countries, we can learn what they care about most:
    ◼
  • World : knowledge;
  • ◼
  • Hungary : knowledge;
  • ◼
  • Spain : no "specific keywords";
  • ◼
  • China : innovation;
  • ◼
  • Germany : knowledge;
  • ◼
  • USA : future;
  • ◼
  • UK : research;
  • Conclusion

    However, this is not a complete study as we do not have a complete list of universities and the amount of information we have varies from country to country, so this is only a brief summary for reference purposes.

    References

    https://www.aubsp.com/universities-in-world/

    CITE THIS NOTEBOOK

    Constructing universities dataset and showing some queries examples​
    by Yi Wei Chen​
    Wolfram Community, STAFF PICKS, August 11, 2023
    ​https://community.wolfram.com/groups/-/m/t/2988279