Open PISA is a project of The Center for Internet Research and The Trump Foundation. It aims to explore the PISA data. The PISA test collects large amounts of data, however because of the natural complexity of the database it is not accessible to most educators. Using data science technology, this site simplifies the statistical analysis and thus is a unique site that enable educators to view the database and use the information gathered in the PISA tests.

Open PISA includes:

  1. Dashboard - It will appear at all times on the upper part of the screen and includes the different fields of analysis:

    1. The subjects being tested.

    2. Gender.

    3. Index of economic, social and cultural status (ESCS). The status is being determined by the OECD’s scale that takes into account information gathered from students, School Principals and the Test conductor in each state.

    4. The different countries

    5. The questionnaires: The year, Subject, Field and Question.

  2. Proficiency - This section introduces the orientation levels in the different subjects. The levels is determined by the calculated average of the students scores and according to the diversity. Each level represents a different dataset and skills. You can read more about the levels underneath the graphs. Standing the marker on the line will show the average score.

  3. Expertise - This part will show the top students, that received higher than a 5 in the skill level, and the low students that got less than a 2, in each country

  4. Questionnaire - The PISA test includes many questionnaires for students, for school Principals and for parents. The results are shown in the graphs according to the questions. The full list of Subjects questions includes a complete Index of both Students and School criteria.  This criteria was determined by the OECD. Each criteria was quantified to several questions. These were used for analysis.

  5. Analyze - The Pisa test is used for research on how to promote and advance Education world wide. The test asks how does these criteria influences the students skills. We will use a few statistical tools such as:

    1. Correlation - Each point in the graph represents a student, whereas you can see the connection between the answer the student gave to a chosen question, to his score.

    2. Linear regression

    3. Least squares (R²)

  6. Dictionary - Full list of variables including the Question identifier and description.

Methodology notes

  1. Tests from 2000-2003 are not presented in the site, due to lack of statistical validity.

  2. We do not rank the different countries. Each country has it’s own dataset and therefore any comparing attempt will be problematic at best. The same goes to the OECD average.

  3. We introduce the idea of skills instead of scores as score in this case are meaninless.

  4. For countries that didn’t participate in the PISA tests every period, you will see a dot, and not a line.

  5. Not all questions were introduced in each country. That is clearly marked by specifying that there is no data.

  6. In some questions we show the diversity of answers, not including the percentage of those who didn’t answer. We did this to make the data more clear. It’s also important to remember that many questions come with there own set of biases.

Please contact us for any other kind of data you wish to explore.



Hosting by AllCloud

Contact us: [email protected]

Image result for github icon

Other resources:

  2. PISA 2015 Database
  3. OECD Skills Surveys
  4. Compare Your Country
  5. PISA Day
  6. International Assessment Data Manager