class: center, middle, inverse, title-slide # Project: University Entrance Exam Analysis ### Dol_R ### 8/24/2020 --- ## Introduction and Key Takeaways In Turkey, every year millions of students take the university entrance exam. After the announcement of results, participants list their university and department choices and they are placed according to their ranks. <br>This analysis focuses on universities and departments popularity over the years. Hopefully, it would help future participants in their decision making process. **Key Takeaways:** * Medicine maintained its popularity over the years and added mean of 577 more quotas every year. * Koç University has a significantly higher popularity with its scholarship options. * Computer Engineering has gained popularity over the years. * Civil Engineering has lost its popularity over the years. --- ## Summary of the Data and Explanations Using **University Exam** data from [*Hacettepe University's Website*](http://web.ee.hacettepe.edu.tr/osym), we obtained university results of years 2016-2020. Each year is on a separate Excel spreadsheet. Since every year some departments are opened and some are shut down, datasets will have different number of rows. There are 9 variables and more than 10000 rows for each dataset. **university**: Name of the university <br>**city**: University's location <br>**department**: Name of the department <br>**type**: Type of the exam points. <br>**quota**: Maximum number of participants to be accepted, upper bound for accepted_number <br>**accepted_number**: Accepted number of participants to the selected university's selected department <br>**lowest_score**: Lowest score of the accepted participant's scores <br>**highest_score**: Highest score of the accepted participant's scores <br>**lowest_ranking**: Lowest ranking of the accepted participant's scores, last accepted person's ranking --- **Objectives:** * Analyze University Exam Entrance data * Cleaning and manipulation of datasets * Exploration of the popularity trends of the universities and departments * Comparison by visualization * Finding top universities and departments ### Data Preprocessing In order to ease the reading process, functions `mani97` and `mani86` are created. These functions remove the columns related to the percentage of change regarding the previous year. They also rename the columns and remove the last empty rows. The raw data for some years have an additional column at the end, therefore two functions were needed. ### Loading the Libraries and Datasets After loading the required libraries, we download the .xlsx file from our project repository. After reading it, we remove the file. --- We have 5 datasets for the last 5 years. Each dataset has 9 columns and they all have different number of rows. For example there are 10617 rows in dataset for the year 2020 and 11402 rows in dataset for the year 2019. Some departments or even universities may have been opened or closed. ``` ## # A tibble: 1 x 5 ## exam20 exam19 exam18 exam17 exam16 ## <int> <int> <int> <int> <int> ## 1 10617 11402 11958 11484 10657 ``` As an example, let's observe dataset for the year 2018. First four variables are categorical and the rest is numerical. We could also see that there are 11958 rows for this year. ``` ## Rows: 11,958 ## Columns: 9 ## $ university <chr> "İSTANBUL MEDİPOL ÜNİVERSİTESİ", "KOÇ ÜNİVERSİTESİ", … ## $ city <chr> "İSTANBUL", "İSTANBUL", "İSTANBUL", "İSTANBUL", "İSTA… ## $ department <chr> "Tıp Fakültesi (İngilizce) (Burslu)", "Tıp Fakültesi … ## $ type <chr> "SAY", "SAY", "SAY", "SAY", "SAY", "SAY", "SAY", "SAY… ## $ quota <dbl> 10, 15, 8, 11, 52, 82, 11, 30, 82, 50, 9, 175, 50, 12… ## $ accepted_number <dbl> 10, 15, 8, 11, 52, 82, 11, 30, 82, 50, 9, 175, 50, 12… ## $ lowest_score <dbl> 549.1749, 548.1738, 543.2350, 542.8008, 538.5325, 536… ## $ highest_score <dbl> 562.9543, 556.2859, 546.1979, 548.5940, 559.5140, 562… ## $ lowest_ranking <dbl> 56, 84, 207, 221, 400, 496, 510, 511, 622, 637, 739, … ``` --- ## Exploratory Data Analysis When the exam procedure changes, the types of grading systems also change. Therefore, there is no point of comparing `type` variable for different years. But it can be an identifier in each year. ### Top Universities and Departments Some universities' departments may be selected by the participants with lowest scores in different types of grading systems. After grouping by `university` and `department`, lowest score column is put in decreasing order. Lowest score is the last entering person's score to a specific university and department. By putting it into decreasing order, we get the highest scores of last entering people. Let's see how the top 10 departments changed over the years. --- To do this, we count unique values and use `full_join` on all of the datasets. Finally, we replace `NULL` values with zero, which means this university or department was not in top 10 for that specific year. This plot shows how many times a university occurred in our top 10 calculation in each year. For example, Bilkent University occurred one time each year and Koç University has the highest number of occurrences. <!-- --> --- This plot shows how many times a department occurred in our top 10 calculation in each year.For departments we remove "(Burslu)" and "(İngilizce)" information in order to count them correctly. <!-- --> --- ### Top Cities Cities play a key role while selecting university, in the first table below, we calculated how many listings of cities appeared in the first thousand ranking. Similarly, the second table shows the distribution of universities listed in the first thousand. #### University and City Distribution of the First Thousand Students in the University Exam <table> <caption>Table.1. City Distribution of the First Thousand Students</caption> <thead> <tr> <th style="text-align:left;"> </th> <th style="text-align:right;"> DİL </th> <th style="text-align:right;"> EA </th> <th style="text-align:right;"> SAY </th> <th style="text-align:right;"> SÖZ </th> </tr> </thead> <tbody> <tr> <td style="text-align:left;"> ANKARA </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 4 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 1 </td> </tr> <tr> <td style="text-align:left;"> İSTANBUL </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 15 </td> <td style="text-align:right;"> 8 </td> <td style="text-align:right;"> 5 </td> </tr> </tbody> </table> --- <table class="table" style="font-size: 10px; margin-left: auto; margin-right: auto;"> <caption style="font-size: initial !important;">Table.2. University Distribution of the First Thousand Students </caption> <thead> <tr> <th style="text-align:left;"> </th> <th style="text-align:right;"> DİL </th> <th style="text-align:right;"> EA </th> <th style="text-align:right;"> SAY </th> <th style="text-align:right;"> SÖZ </th> </tr> </thead> <tbody> <tr> <td style="text-align:left;"> ACIBADEM MEHMET ALİ AYDINLAR ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> BOĞAZİÇİ ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 3 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 1 </td> </tr> <tr> <td style="text-align:left;"> GALATASARAY ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> İHSAN DOĞRAMACI BİLKENT ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 3 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> İSTANBUL 29 MAYIS ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> </tr> <tr> <td style="text-align:left;"> İSTANBUL MEDİPOL ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> İSTANBUL ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> İSTANBUL ÜNİVERSİTESİ-CERRAHPAŞA </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> KOÇ ÜNİVERSİTESİ </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 6 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 2 </td> </tr> <tr> <td style="text-align:left;"> ÖZYEĞİN ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> </tr> <tr> <td style="text-align:left;"> SABANCI ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> TOBB EKONOMİ VE TEKNOLOJİ ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> </tr> <tr> <td style="text-align:left;"> YEDİTEPE ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> </tr> </tbody> </table> --- #### University and City Distribution of the First Five Thousand Students in the University Exam <table> <caption>Table.3. City Distribution of the First Five Thousand Students</caption> <thead> <tr> <th style="text-align:left;"> </th> <th style="text-align:right;"> DİL </th> <th style="text-align:right;"> EA </th> <th style="text-align:right;"> SAY </th> <th style="text-align:right;"> SÖZ </th> </tr> </thead> <tbody> <tr> <td style="text-align:left;"> ANKARA </td> <td style="text-align:right;"> 9 </td> <td style="text-align:right;"> 19 </td> <td style="text-align:right;"> 21 </td> <td style="text-align:right;"> 10 </td> </tr> <tr> <td style="text-align:left;"> ESKİŞEHİR </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> İSTANBUL </td> <td style="text-align:right;"> 14 </td> <td style="text-align:right;"> 42 </td> <td style="text-align:right;"> 35 </td> <td style="text-align:right;"> 47 </td> </tr> <tr> <td style="text-align:left;"> İZMİR </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 2 </td> </tr> </tbody> </table> --- <table class="table" style="font-size: 10px; margin-left: auto; margin-right: auto;"> <caption style="font-size: initial !important;">Table.4. University Distribution of the First Five Thousand Students</caption> <thead> <tr> <th style="text-align:left;"> </th> <th style="text-align:right;"> DİL </th> <th style="text-align:right;"> EA </th> <th style="text-align:right;"> SAY </th> <th style="text-align:right;"> SÖZ </th> </tr> </thead> <tbody> <tr> <td style="text-align:left;"> ACIBADEM MEHMET ALİ AYDINLAR ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> ANKARA ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> BAHÇEŞEHİR ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 7 </td> </tr> <tr> <td style="text-align:left;"> BAŞKENT ÜNİVERSİTESİ </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 1 </td> </tr> <tr> <td style="text-align:left;"> BEYKENT ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> </tr> <tr> <td style="text-align:left;"> BEZM-İ ÂLEM VAKIF ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> BOĞAZİÇİ ÜNİVERSİTESİ </td> <td style="text-align:right;"> 4 </td> <td style="text-align:right;"> 7 </td> <td style="text-align:right;"> 4 </td> <td style="text-align:right;"> 3 </td> </tr> <tr> <td style="text-align:left;"> EGE ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> ESKİŞEHİR TEKNİK ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> GALATASARAY ÜNİVERSİTESİ </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 5 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> </tr> <tr> <td style="text-align:left;"> GAZİ ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> HACETTEPE ÜNİVERSİTESİ </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 2 </td> </tr> <tr> <td style="text-align:left;"> İBN HALDUN ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 3 </td> </tr> <tr> <td style="text-align:left;"> İHSAN DOĞRAMACI BİLKENT ÜNİVERSİTESİ </td> <td style="text-align:right;"> 3 </td> <td style="text-align:right;"> 8 </td> <td style="text-align:right;"> 7 </td> <td style="text-align:right;"> 1 </td> </tr> <tr> <td style="text-align:left;"> İSTANBUL 29 MAYIS ÜNİVERSİTESİ </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 4 </td> </tr> <tr> <td style="text-align:left;"> İSTANBUL BİLGİ ÜNİVERSİTESİ </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 6 </td> </tr> <tr> <td style="text-align:left;"> İSTANBUL MEDİPOL ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> İSTANBUL OKAN ÜNİVERSİTESİ </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> İSTANBUL SABAHATTİN ZAİM ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 2 </td> </tr> <tr> <td style="text-align:left;"> İSTANBUL TEKNİK ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 3 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> İSTANBUL ÜNİVERSİTESİ </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> İSTANBUL ÜNİVERSİTESİ-CERRAHPAŞA </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> İSTİNYE ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> İZMİR EKONOMİ ÜNİVERSİTESİ </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 2 </td> </tr> <tr> <td style="text-align:left;"> KADİR HAS ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 3 </td> </tr> <tr> <td style="text-align:left;"> KOÇ ÜNİVERSİTESİ </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 10 </td> <td style="text-align:right;"> 11 </td> <td style="text-align:right;"> 3 </td> </tr> <tr> <td style="text-align:left;"> MALTEPE ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> </tr> <tr> <td style="text-align:left;"> MARMARA ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 1 </td> </tr> <tr> <td style="text-align:left;"> ORTA DOĞU TEKNİK ÜNİVERSİTESİ </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 3 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 2 </td> </tr> <tr> <td style="text-align:left;"> ÖZYEĞİN ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 9 </td> <td style="text-align:right;"> 3 </td> <td style="text-align:right;"> 2 </td> </tr> <tr> <td style="text-align:left;"> SABANCI ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> TED ÜNİVERSİTESİ </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 1 </td> </tr> <tr> <td style="text-align:left;"> TOBB EKONOMİ VE TEKNOLOJİ ÜNİVERSİTESİ </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 6 </td> <td style="text-align:right;"> 4 </td> <td style="text-align:right;"> 3 </td> </tr> <tr> <td style="text-align:left;"> YAŞAR ÜNİVERSİTESİ </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> <td style="text-align:right;"> 0 </td> </tr> <tr> <td style="text-align:left;"> YEDİTEPE ÜNİVERSİTESİ </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 2 </td> <td style="text-align:right;"> 1 </td> <td style="text-align:right;"> 10 </td> </tr> </tbody> </table> --- We can monitor the density of cities for first five thousand ranking. Obviously, Istanbul has dominated the first five thousand while Izmir starts to attract students from three thousand. Ankara is somewhere in between and mostly left-skewed. <!-- --> --- ### Quota Informations In 2020, the occupancy rate in quotas is 92.63 %. Which is greater than 2019 value (90.64 % ). The cities, universities and departments with the highest quotas in recent years can be seen from the tables below. <table class="table" style="font-size: 10px; margin-left: auto; margin-right: auto;"> <caption style="font-size: initial !important;">Table.5. Department Quotas in Recent Years</caption> <thead> <tr> <th style="text-align:right;"> year </th> <th style="text-align:left;"> department </th> <th style="text-align:right;"> department_quota </th> </tr> </thead> <tbody> <tr> <td style="text-align:right;"> 2020 </td> <td style="text-align:left;"> Hemşirelik </td> <td style="text-align:right;"> 12469 </td> </tr> <tr> <td style="text-align:right;"> 2019 </td> <td style="text-align:left;"> Hemşirelik </td> <td style="text-align:right;"> 11994 </td> </tr> <tr> <td style="text-align:right;"> 2017 </td> <td style="text-align:left;"> İşletme (Açıköğretim) </td> <td style="text-align:right;"> 11788 </td> </tr> <tr> <td style="text-align:right;"> 2018 </td> <td style="text-align:left;"> Hemşirelik </td> <td style="text-align:right;"> 11629 </td> </tr> <tr> <td style="text-align:right;"> 2017 </td> <td style="text-align:left;"> Hemşirelik </td> <td style="text-align:right;"> 11306 </td> </tr> <tr> <td style="text-align:right;"> 2016 </td> <td style="text-align:left;"> Hemşirelik </td> <td style="text-align:right;"> 10921 </td> </tr> <tr> <td style="text-align:right;"> 2020 </td> <td style="text-align:left;"> Tıp Fakültesi </td> <td style="text-align:right;"> 10702 </td> </tr> <tr> <td style="text-align:right;"> 2019 </td> <td style="text-align:left;"> Tıp Fakültesi </td> <td style="text-align:right;"> 10203 </td> </tr> <tr> <td style="text-align:right;"> 2018 </td> <td style="text-align:left;"> Tıp Fakültesi </td> <td style="text-align:right;"> 9648 </td> </tr> <tr> <td style="text-align:right;"> 2017 </td> <td style="text-align:left;"> İşletme </td> <td style="text-align:right;"> 9628 </td> </tr> <tr> <td style="text-align:right;"> 2016 </td> <td style="text-align:left;"> İşletme </td> <td style="text-align:right;"> 9481 </td> </tr> <tr> <td style="text-align:right;"> 2016 </td> <td style="text-align:left;"> İşletme (Açıköğretim) </td> <td style="text-align:right;"> 9226 </td> </tr> <tr> <td style="text-align:right;"> 2017 </td> <td style="text-align:left;"> Tıp Fakültesi </td> <td style="text-align:right;"> 9029 </td> </tr> <tr> <td style="text-align:right;"> 2017 </td> <td style="text-align:left;"> İktisat </td> <td style="text-align:right;"> 8840 </td> </tr> <tr> <td style="text-align:right;"> 2019 </td> <td style="text-align:left;"> İlahiyat </td> <td style="text-align:right;"> 8698 </td> </tr> <tr> <td style="text-align:right;"> 2018 </td> <td style="text-align:left;"> İşletme </td> <td style="text-align:right;"> 8593 </td> </tr> <tr> <td style="text-align:right;"> 2016 </td> <td style="text-align:left;"> İktisat </td> <td style="text-align:right;"> 8591 </td> </tr> <tr> <td style="text-align:right;"> 2020 </td> <td style="text-align:left;"> İlahiyat </td> <td style="text-align:right;"> 8573 </td> </tr> <tr> <td style="text-align:right;"> 2018 </td> <td style="text-align:left;"> İlahiyat </td> <td style="text-align:right;"> 8558 </td> </tr> <tr> <td style="text-align:right;"> 2017 </td> <td style="text-align:left;"> İlahiyat </td> <td style="text-align:right;"> 8501 </td> </tr> </tbody> </table> --- <table class="table" style="font-size: 10px; margin-left: auto; margin-right: auto;"> <caption style="font-size: initial !important;">Table.6. City Quotas in Recent Years</caption> <thead> <tr> <th style="text-align:right;"> year </th> <th style="text-align:left;"> city </th> <th style="text-align:right;"> city_quota </th> </tr> </thead> <tbody> <tr> <td style="text-align:right;"> 2018 </td> <td style="text-align:left;"> İSTANBUL </td> <td style="text-align:right;"> 112514 </td> </tr> <tr> <td style="text-align:right;"> 2020 </td> <td style="text-align:left;"> İSTANBUL </td> <td style="text-align:right;"> 106565 </td> </tr> <tr> <td style="text-align:right;"> 2019 </td> <td style="text-align:left;"> İSTANBUL </td> <td style="text-align:right;"> 102296 </td> </tr> <tr> <td style="text-align:right;"> 2017 </td> <td style="text-align:left;"> İSTANBUL </td> <td style="text-align:right;"> 101551 </td> </tr> <tr> <td style="text-align:right;"> 2016 </td> <td style="text-align:left;"> İSTANBUL </td> <td style="text-align:right;"> 94271 </td> </tr> <tr> <td style="text-align:right;"> 2017 </td> <td style="text-align:left;"> ESKİŞEHİR </td> <td style="text-align:right;"> 65815 </td> </tr> <tr> <td style="text-align:right;"> 2016 </td> <td style="text-align:left;"> ESKİŞEHİR </td> <td style="text-align:right;"> 52348 </td> </tr> <tr> <td style="text-align:right;"> 2020 </td> <td style="text-align:left;"> ANKARA </td> <td style="text-align:right;"> 45092 </td> </tr> <tr> <td style="text-align:right;"> 2019 </td> <td style="text-align:left;"> ANKARA </td> <td style="text-align:right;"> 40273 </td> </tr> <tr> <td style="text-align:right;"> 2018 </td> <td style="text-align:left;"> ANKARA </td> <td style="text-align:right;"> 40069 </td> </tr> <tr> <td style="text-align:right;"> 2018 </td> <td style="text-align:left;"> ESKİŞEHİR </td> <td style="text-align:right;"> 38118 </td> </tr> <tr> <td style="text-align:right;"> 2017 </td> <td style="text-align:left;"> ANKARA </td> <td style="text-align:right;"> 37907 </td> </tr> <tr> <td style="text-align:right;"> 2016 </td> <td style="text-align:left;"> ANKARA </td> <td style="text-align:right;"> 35065 </td> </tr> <tr> <td style="text-align:right;"> 2019 </td> <td style="text-align:left;"> ESKİŞEHİR </td> <td style="text-align:right;"> 29768 </td> </tr> <tr> <td style="text-align:right;"> 2020 </td> <td style="text-align:left;"> ESKİŞEHİR </td> <td style="text-align:right;"> 26229 </td> </tr> <tr> <td style="text-align:right;"> 2020 </td> <td style="text-align:left;"> İZMİR </td> <td style="text-align:right;"> 23462 </td> </tr> <tr> <td style="text-align:right;"> 2019 </td> <td style="text-align:left;"> İZMİR </td> <td style="text-align:right;"> 22564 </td> </tr> <tr> <td style="text-align:right;"> 2018 </td> <td style="text-align:left;"> İZMİR </td> <td style="text-align:right;"> 22163 </td> </tr> <tr> <td style="text-align:right;"> 2020 </td> <td style="text-align:left;"> ERZURUM </td> <td style="text-align:right;"> 21999 </td> </tr> <tr> <td style="text-align:right;"> 2017 </td> <td style="text-align:left;"> İZMİR </td> <td style="text-align:right;"> 19236 </td> </tr> </tbody> </table> --- <table class="table" style="font-size: 10px; margin-left: auto; margin-right: auto;"> <caption style="font-size: initial !important;">Table.7. University Quotas in Recent Years</caption> <thead> <tr> <th style="text-align:right;"> year </th> <th style="text-align:left;"> university </th> <th style="text-align:right;"> university_quota </th> </tr> </thead> <tbody> <tr> <td style="text-align:right;"> 2017 </td> <td style="text-align:left;"> ANADOLU ÜNİVERSİTESİ </td> <td style="text-align:right;"> 61485 </td> </tr> <tr> <td style="text-align:right;"> 2016 </td> <td style="text-align:left;"> ANADOLU ÜNİVERSİTESİ </td> <td style="text-align:right;"> 48110 </td> </tr> <tr> <td style="text-align:right;"> 2018 </td> <td style="text-align:left;"> ANADOLU ÜNİVERSİTESİ </td> <td style="text-align:right;"> 32351 </td> </tr> <tr> <td style="text-align:right;"> 2019 </td> <td style="text-align:left;"> ANADOLU ÜNİVERSİTESİ </td> <td style="text-align:right;"> 24057 </td> </tr> <tr> <td style="text-align:right;"> 2018 </td> <td style="text-align:left;"> İSTANBUL ÜNİVERSİTESİ </td> <td style="text-align:right;"> 22687 </td> </tr> <tr> <td style="text-align:right;"> 2020 </td> <td style="text-align:left;"> ATATÜRK ÜNİVERSİTESİ </td> <td style="text-align:right;"> 21203 </td> </tr> <tr> <td style="text-align:right;"> 2020 </td> <td style="text-align:left;"> ANADOLU ÜNİVERSİTESİ </td> <td style="text-align:right;"> 20939 </td> </tr> <tr> <td style="text-align:right;"> 2017 </td> <td style="text-align:left;"> İSTANBUL ÜNİVERSİTESİ </td> <td style="text-align:right;"> 18309 </td> </tr> <tr> <td style="text-align:right;"> 2016 </td> <td style="text-align:left;"> İSTANBUL ÜNİVERSİTESİ </td> <td style="text-align:right;"> 18169 </td> </tr> <tr> <td style="text-align:right;"> 2018 </td> <td style="text-align:left;"> ATATÜRK ÜNİVERSİTESİ </td> <td style="text-align:right;"> 15735 </td> </tr> <tr> <td style="text-align:right;"> 2020 </td> <td style="text-align:left;"> İSTANBUL ÜNİVERSİTESİ </td> <td style="text-align:right;"> 15283 </td> </tr> <tr> <td style="text-align:right;"> 2019 </td> <td style="text-align:left;"> İSTANBUL ÜNİVERSİTESİ </td> <td style="text-align:right;"> 15115 </td> </tr> <tr> <td style="text-align:right;"> 2016 </td> <td style="text-align:left;"> ATATÜRK ÜNİVERSİTESİ </td> <td style="text-align:right;"> 14239 </td> </tr> <tr> <td style="text-align:right;"> 2019 </td> <td style="text-align:left;"> ATATÜRK ÜNİVERSİTESİ </td> <td style="text-align:right;"> 13663 </td> </tr> <tr> <td style="text-align:right;"> 2017 </td> <td style="text-align:left;"> ATATÜRK ÜNİVERSİTESİ </td> <td style="text-align:right;"> 13524 </td> </tr> <tr> <td style="text-align:right;"> 2017 </td> <td style="text-align:left;"> SELÇUK ÜNİVERSİTESİ </td> <td style="text-align:right;"> 9738 </td> </tr> <tr> <td style="text-align:right;"> 2016 </td> <td style="text-align:left;"> SELÇUK ÜNİVERSİTESİ </td> <td style="text-align:right;"> 8364 </td> </tr> <tr> <td style="text-align:right;"> 2020 </td> <td style="text-align:left;"> ANKARA ÜNİVERSİTESİ </td> <td style="text-align:right;"> 8196 </td> </tr> <tr> <td style="text-align:right;"> 2018 </td> <td style="text-align:left;"> SELÇUK ÜNİVERSİTESİ </td> <td style="text-align:right;"> 8162 </td> </tr> <tr> <td style="text-align:right;"> 2017 </td> <td style="text-align:left;"> GAZİ ÜNİVERSİTESİ </td> <td style="text-align:right;"> 8055 </td> </tr> </tbody> </table> --- #### Quota Differences In some cases we would wonder the departments whose quote more increased or decreased. However, there are some highly volatile departments ending with "(Açıköğretim) , (İÖ) or (..indirimli). they may be misleading, so we should eliminate the departments ending with these words in order to get more established departments. Also another criteria can be necessity of being founded at least 4 years ago. So that we can see trends of department quotes. Here is the top 20 departments whose quote increased most and whose decreased most in the last 4 years. Note: Ranked by taking mean quote differences of last 4 years. <table class="table" style="font-size: 10px; margin-left: auto; margin-right: auto;"> <caption style="font-size: initial !important;">Table.8. Deparments which Their Quotas Increased Most in Recent Years</caption> <thead> <tr> <th style="text-align:left;"> department </th> <th style="text-align:right;"> mean_difference </th> </tr> </thead> <tbody> <tr> <td style="text-align:left;"> Tıp Fakültesi </td> <td style="text-align:right;"> 577.50 </td> </tr> <tr> <td style="text-align:left;"> Psikoloji </td> <td style="text-align:right;"> 464.25 </td> </tr> <tr> <td style="text-align:left;"> Diş Hekimliği Fakültesi </td> <td style="text-align:right;"> 461.75 </td> </tr> <tr> <td style="text-align:left;"> Sağlık Yönetimi </td> <td style="text-align:right;"> 460.75 </td> </tr> <tr> <td style="text-align:left;"> Finans ve Bankacılık </td> <td style="text-align:right;"> 454.50 </td> </tr> <tr> <td style="text-align:left;"> Gastronomi ve Mutfak Sanatları </td> <td style="text-align:right;"> 424.50 </td> </tr> <tr> <td style="text-align:left;"> İslami İlimler </td> <td style="text-align:right;"> 391.25 </td> </tr> <tr> <td style="text-align:left;"> Bilgisayar Mühendisliği </td> <td style="text-align:right;"> 388.00 </td> </tr> <tr> <td style="text-align:left;"> Hemşirelik </td> <td style="text-align:right;"> 387.00 </td> </tr> <tr> <td style="text-align:left;"> Mimarlık </td> <td style="text-align:right;"> 370.25 </td> </tr> <tr> <td style="text-align:left;"> Beslenme ve Diyetetik </td> <td style="text-align:right;"> 343.50 </td> </tr> <tr> <td style="text-align:left;"> Fizyoterapi ve Rehabilitasyon </td> <td style="text-align:right;"> 342.00 </td> </tr> <tr> <td style="text-align:left;"> Radyo, Televizyon ve Sinema </td> <td style="text-align:right;"> 316.75 </td> </tr> <tr> <td style="text-align:left;"> İngiliz Dili ve Edebiyatı (İngilizce) </td> <td style="text-align:right;"> 294.00 </td> </tr> <tr> <td style="text-align:left;"> Rehberlik ve Psikolojik Danışmanlık </td> <td style="text-align:right;"> 293.00 </td> </tr> <tr> <td style="text-align:left;"> Sosyal Hizmet </td> <td style="text-align:right;"> 282.50 </td> </tr> <tr> <td style="text-align:left;"> Siyaset Bilimi ve Kamu Yönetimi </td> <td style="text-align:right;"> 265.75 </td> </tr> <tr> <td style="text-align:left;"> Matematik </td> <td style="text-align:right;"> 257.25 </td> </tr> <tr> <td style="text-align:left;"> Türk Dili ve Edebiyatı </td> <td style="text-align:right;"> 235.50 </td> </tr> <tr> <td style="text-align:left;"> Hukuk Fakültesi </td> <td style="text-align:right;"> 223.50 </td> </tr> </tbody> </table> --- <table class="table" style="font-size: 10px; margin-left: auto; margin-right: auto;"> <caption style="font-size: initial !important;">Table.9. Deparments which Their Quotas Decreased Most in Recent Years</caption> <thead> <tr> <th style="text-align:left;"> department </th> <th style="text-align:right;"> mean_difference </th> </tr> </thead> <tbody> <tr> <td style="text-align:left;"> İşletme </td> <td style="text-align:right;"> -789.50 </td> </tr> <tr> <td style="text-align:left;"> İktisat </td> <td style="text-align:right;"> -736.50 </td> </tr> <tr> <td style="text-align:left;"> Bilgisayar ve Öğretim Teknolojileri Öğretmenliği </td> <td style="text-align:right;"> -577.00 </td> </tr> <tr> <td style="text-align:left;"> Fen Bilgisi Öğretmenliği </td> <td style="text-align:right;"> -457.00 </td> </tr> <tr> <td style="text-align:left;"> Gıda Mühendisliği </td> <td style="text-align:right;"> -450.00 </td> </tr> <tr> <td style="text-align:left;"> Çevre Mühendisliği </td> <td style="text-align:right;"> -416.75 </td> </tr> <tr> <td style="text-align:left;"> Sınıf Öğretmenliği </td> <td style="text-align:right;"> -237.25 </td> </tr> <tr> <td style="text-align:left;"> Arkeoloji </td> <td style="text-align:right;"> -219.00 </td> </tr> <tr> <td style="text-align:left;"> Kamu Yönetimi </td> <td style="text-align:right;"> -216.00 </td> </tr> <tr> <td style="text-align:left;"> Enerji Sistemleri Mühendisliği </td> <td style="text-align:right;"> -191.50 </td> </tr> <tr> <td style="text-align:left;"> Uluslararası Ticaret </td> <td style="text-align:right;"> -185.25 </td> </tr> <tr> <td style="text-align:left;"> Metalurji ve Malzeme Mühendisliği </td> <td style="text-align:right;"> -171.50 </td> </tr> <tr> <td style="text-align:left;"> Konaklama İşletmeciliği </td> <td style="text-align:right;"> -158.67 </td> </tr> <tr> <td style="text-align:left;"> Makine Mühendisliği </td> <td style="text-align:right;"> -105.00 </td> </tr> <tr> <td style="text-align:left;"> Ekonometri </td> <td style="text-align:right;"> -100.00 </td> </tr> <tr> <td style="text-align:left;"> Turizm İşletmeciliği ve Otelcilik </td> <td style="text-align:right;"> -97.67 </td> </tr> <tr> <td style="text-align:left;"> Jeoloji Mühendisliği </td> <td style="text-align:right;"> -94.75 </td> </tr> <tr> <td style="text-align:left;"> Sosyal Bilgiler Öğretmenliği </td> <td style="text-align:right;"> -92.50 </td> </tr> <tr> <td style="text-align:left;"> İmalat Mühendisliği </td> <td style="text-align:right;"> -90.50 </td> </tr> <tr> <td style="text-align:left;"> Kimya Mühendisliği </td> <td style="text-align:right;"> -88.00 </td> </tr> </tbody> </table> --- ### Popularity of Different Engineering Departments In this part of the project, the two most popular state universities' data are taken into account. 6 different engineering departments that exist in both Boğaziçi University and Middle East Technical University are chosen to make a comparison their popularity over the years. Data shows that computer engineering gains popularity and civil engineering lose its popularity in the recent years. Other engineering branches such as industrial engineering and electrical&electronics engineering have relatively stable popularity. <!-- --> --- #### Popularity of Computer Engineering and Civil Engineering Popularity of computer engineering and civil engineering in the top 3 state universities can be shown in plots below. There is an increasing trend of choosing computer engineering but negative trend of choosing civil engineering in the recent years. <!-- --> --- <!-- --> --- #### Equivalence of rankings to score in years 2018, 2019 and 2020 Among university exam applicants one of the biggest curiosity is the equivalence of exam score to rankings. Calculating possible exam scores is possible with the equations published by ÖSYM or via websites but ranking equivalence change every year by the toughness of the exam. Also another problem of the equivalence is ÖSYM does not publish the year by year equivalence of scores to rankings. The only indicator we have is the lowest ranking and lowest score equivalence table. So we aim to find the correlation between the scores and the ranking with the data we have and forecast possible minimum score to enter different ranking intervals. We only use 2018, 2019, 2020 data since before the ranking system was different. <!-- --> --- From this graph we can observe that in top 100000 students, effect of the score on the ranking decreases. Also we can guess the effect of people's choises on rankings. In 2018 students with most ranking of 400,000 enter SAY departments but in 2020 it rises up to 700,000. The SAY quotas were 192792 in 2018 and 191155 in 2020. There is a decrease in quotas but it can be seen that people with higher rankings prefer SAY departments in 2020. Also in from 2018 to 2020 people prefer SÖZ departments more and the lowest rankings decrease. The SÖZ quotas were 105445 in 2018 and 113362 in 2020. The quota increase by 8% but the rankings got lower. DIL departments show really small fluctuations. There is slight change in those three years. --- Even though there are significant fluctuations in the higher ranking area, the top 100,000 ranking shows stable behavior. In the university exam students mostly aim three ranking depends on their work and potential. These rankings are 100,000, 50,000 and 10,000. We wanted to create a small guideline for future students to see their possible interval with their potential scores. We take the average of scores in three years with selecting an interval around the selected rankings. This interval is 9k to 11k in 10,000 ranking, 47.5k and 52.5k in 50,000 ranking and 95k and 105k in 100,000 ranking. <table class="table" style="font-size: 15px; margin-left: auto; margin-right: auto;"> <thead> <tr> <th style="text-align:left;"> Ranking </th> <th style="text-align:left;"> DİL </th> <th style="text-align:left;"> EA </th> <th style="text-align:left;"> SAY </th> <th style="text-align:left;"> SÖZ </th> </tr> </thead> <tbody> <tr> <td style="text-align:left;"> 10,000 </td> <td style="text-align:left;"> 418.772 </td> <td style="text-align:left;"> 427.827 </td> <td style="text-align:left;"> 494.556 </td> <td style="text-align:left;"> 404.704 </td> </tr> <tr> <td style="text-align:left;"> 50,000 </td> <td style="text-align:left;"> 278.34 </td> <td style="text-align:left;"> 375.578 </td> <td style="text-align:left;"> 424.469 </td> <td style="text-align:left;"> 359.692 </td> </tr> <tr> <td style="text-align:left;"> 100,000 </td> <td style="text-align:left;"> - </td> <td style="text-align:left;"> 347.141 </td> <td style="text-align:left;"> 365.983 </td> <td style="text-align:left;"> 335.743 </td> </tr> </tbody> </table> --- ## Conclusion In Turkey, every year millions of students take the university entrance exam and enter university. Every year rankings of departments and universities change due to popularity and this affect the results significantly. We made analyses on the university entrance exam data and observe the outcomes. The data ww used was not in a clean form therefore we started with cleaning and manipulating the data. We found the top universities and departments along with the most preferred cities. We knew the importance of the quota information so we observe the changes in the department quotas. Using both the ranking and quota information leads us to understand the cities and departments with the highest demand among entrants. We observe correlation between the quota and the ranking changes in several departments. We observe the change in popularity of engineering departments and wanted go into detail in the popularity of engineering departments. We found out significant changes in the rankings of engineering departments such as Civil and Computer Engineering. Furthermore we defined the correlation of scores with rankings and create a ranking-score table to be used as a guide by prospective students. --- ## Shiny App We also have a Shiny App called [University Exams in Turkey](https://ilaydacelenk.shinyapps.io/uni_exam_project/). ## References - [*Hacettepe University's Website*](http://web.ee.hacettepe.edu.tr/osym/). - [*Xaringan Tutorial*](https://slides.yihui.org/xaringan/#1) - [*Stack Overflow*](https://stackoverflow.com/)