Search the site for the term 'PISA'

The PISA database contains, in addition to the scores of students, a lot of demographic, socioeconomic and cultural data about them, collected through a series of questionnaires, that allow contextualize the academic results and make studies with a great number of variables. Most of these data are categorical, making the correspondence analysis a particularly appropriate tool to work with them. In this article I will show you how to easily perform this analysis using the ca package of the R program.

[Read More...]

In this post you can download the R code samples to work with plausible values in the PISA database, to calculate averages, mean differences or linear regression of the scores of the students, using replicate weights to compute standard errors.

[Read More...]

In the previous article in this series we viewed how to computing standard errors with replicate weights in PISA database, in this article we will take an overview of one of the most controversial points of these studies, the complex system of scores implemented.

[Read More...]

In this post you can download the R code examples to compute the standard errors of the mean, standard deviation, proportions or mean differences, on the data of the PISA database, using the replicate weights method.

[Read More...]

In the previous article in this series we saw an introduction to PISA data analytics, with examples of functions in R code for sampling, and we talked about the sampling weights, which ponder each student so that it represents a group of individuals with the same characteristics rather than a single student, (remember that PISA aims to assess the effect of educational policies on the whole population of the country, not on individual students). In this article, we will see how to use these weights to calculate estimators from samples and we'll see also how to calculate standard errors of these estimators using replicated weights.

[Read More...]

In this post you will find examples of R code for data sampling in PISA database. In these examples the different weights of students, schools or parents are corrected depending on the number of records selected for the sample. Also there are examples of stratified sampling using the values in a particular column in the data set.

[Read More...]

Every three years, since 2000, the OECD (Organization for Economic Cooperation and Development) performs a series of tests in a number of countries at national level to 15-years-old students, in order to assess the degree of knowledge in three main groups of areas: science, reading and math. This is the PISA program, whose last edition took place in 2015.

[Read More...]

In previous articles I have talked about the POD project, a database that centralizes access to other databases so that they can be consulted through a common interface. In this article we will see the tool that is used for data filtering and query on any of the databases integrated into POD.

[Read More...]

PISA (Program for International Student Assessment) is a program of the OECD (Organization for Economic Cooperation and Development) for the evaluation of education policies. It consists of a series of tests and surveys conducted to 15 years old students, schools and parents at national level in the countries participating in the program (in 2012 there were 65 participating countries, and in 2015 there are more than 70). These tests seek to assess the level of knowledge in three main areas: Reading, science and math.

In this article I make a brief introduction to SQL Server database created from the original data published by the OECD.

[Read More...]

In this page you can download the central PISA database, which contains all the common data for all countries, as questions, response values and territorial divisions.

[Read More...]

In this page you can find the instructions and the links to download and install each PISA national database with the responses of students, schools and parent questionaires of the years from 2000 to 2012.

[Read More...]

From this page you can download an installable copy of the POD Configuration database. You can find also instructions to install and setup it on the server, and to download a free version of SQL Server.

[Read More...]

POD (Portal Open Data) is a project that I started when I was studying to obtain Microsoft Web Developer MCSD, in order to do some practices. Consists of a SQL Server database through which on can access to other databases in a centralized way.

In this article I describe the POD Configuration database

[Read More...]