Data methodology
How the information the Council publishes is produced.
Source, validation, frequency, disaggregations, limitations and the variable dictionary. A figure without its method is an opinion with decimal places.
01
Sources
The portal's series are built on three kinds of source: the administrative register of enrolment and schools, the teaching staff register, and the population projections that serve as the denominator of the coverage rates. Every indicator states which of the three it comes from.
In this demonstration all three are simulated. In a real deployment each belongs to a different institutional system, with its own owner and its own closing calendar.
The mapping is the exception: the boundaries of the eighteen departments are real and come from geoBoundaries (gbOpen, ADM1), published under a CC BY 4.0 licence. They are used as they are, projected and simplified for screen; everything painted on top of them is illustrative.
02
Validation
Before publication, every series passes three checks: internal consistency (the disaggregations sum to the total), consistency over time (no year-on-year change is left without a documented explanation) and cross-checking between registers (enrolment against the school directory, and schools against teaching staff).
When a check fails, the series is not published: what is published is the note explaining why it is not there.
03
Frequency
Collection is annual and follows the calendar the Council approves: a single cut-off date for every reporting organisation, a cross-validation window and a single publication date. The half-yearly bulletins open no new series: they comment on the existing ones.
04
Disaggregations
Every national figure is published disaggregated by education level, sex, area, administration and department, and — where the source allows — by session and route. A national average that cannot be broken down territorially tells you nothing about a country as uneven as this one.
05
Limitations
The coverage rates depend on the population projection used as the denominator: changing the projection moves the indicator without enrolment having moved. The retention rates depend on the register of transfers between schools. The infrastructure indicators are built on what the school reports, with sample verification afterwards.
These limitations are published next to each indicator, not in a footnote.
06
Variable dictionary
Every dataset is published with its dictionary: variable name, type, unit, permitted values and how missing data is handled. The dictionary is part of the download, not of a separate page.
07Variable dictionary
Every variable, its type and its handling.
The dictionary is part of every download, not of a separate page: a file without one forces you to guess.
| Variable | Type | Unit | Permitted values | Note |
|---|---|---|---|---|
anio | Integer | Year | 2019–2026 | The school year the record refers to. |
departamento | Text | Code | 18 two-letter codes | The portal's territorial code. |
nivel | Text | Category | pre · bas · sec | Education level. |
sexo | Text | Category | f · m | Sex as recorded at enrolment. |
area | Text | Category | urban · rural | The school's area. |
administracion | Text | Category | state · private · semi-official | The school's status. |
valor | Integer or decimal | Depends on the indicator | ≥ 0 | Empty when the figure is unavailable; never zero by default. |
08Integration layer
Where a real system plugs in.
This demonstration works its figures out in the browser. The architecture is ready for each of them to come from its institutional source instead.
01
Enrolment and school register
The statistics module exposes a single query function. Replacing it with a call to the institutional enrolment service leaves the dashboards, the map, the filters, the tables and the downloads untouched.
02
Population projections
The coverage rates need a demographic denominator. The integration for that is a projection service by single year of age and territory.
03
Teaching staff register
The student–teacher ratio and the accreditation figures are fed by the staff system, not by the school register.
04
Content management
News, documents, regulations, datasets, indicators, events and consultations are modelled as collections, ready to be administered from a CMS without touching any code.
The figures in this prototype are simulations created solely to demonstrate what the platform can do.