2nd Survey Of Schools: ICT In Education
Directorate-General for Communications Networks, Content and Technology
@ecdgconnect.n_2nd_survey_of_schools_ict_in_education
Directorate-General for Communications Networks, Content and Technology
@ecdgconnect.n_2nd_survey_of_schools_ict_in_education
The Survey of Schools: ICT in Education, published in March 2019, builds upon the European Commission’s first Survey of Schools: ICT in Education.The survey was conducted in a partnership between Deloitte and IPSOS, on behalf of the European Commission.
The 2nd Survey of Schools: ICT in Education has two objectives:
Objective 1: Benchmark progress in ICT in schools - to provide detailed and up-to-date information related to access, use and attitudes towards the use of technology in education by surveying head teachers, teachers, students and parents covering the EU28, Norway, Iceland and Turkey;
Objective 2: Model for a ‘highly equipped and connected classroom’ - to define a conceptual model for a ‘highly equipped and connected classroom’ (HECC), presenting three scenarios to describe different levels of a HECC and to estimate the overall costs to equip and connect an average EU classroom with advanced components of the HECC model.
The survey was carried out in 31 countries (EU28, Norway, Iceland and Turkey), by conducting interviews with head teachers, teachers, students and parents (ISCED level 1: primary schools: ISCED level 2: lower secondary schools; ISCED level 3: upper secondary schools). A range of different topics was covered, including:
Specific country profiles are available online
Publisher name: Directorate-General for Communications Networks, Content and Technology
Publisher URL: https://commission.europa.eu/about/departments-and-executive-agencies/communications-networks-content-and-technology
Last updated: 2025-12-10T19:28:39Z
CREATE TABLE table_1 (
"country" VARCHAR,
"countryid" VARCHAR,
"cnt" VARCHAR,
"eu" VARCHAR,
"level" VARCHAR,
"schoolid" VARCHAR,
"classid" VARCHAR,
"teid" VARCHAR,
"wave" BIGINT,
"n_teachers_part" BIGINT,
"n_students_part" BIGINT,
"n_parents_part" BIGINT,
"te02q011" VARCHAR,
"te02q012" VARCHAR,
"te02q013" VARCHAR,
"te02q014" VARCHAR,
"te02q015" VARCHAR,
"te02q016" VARCHAR,
"te04q01" VARCHAR,
"te04q02" VARCHAR,
"te04q03" VARCHAR,
"te05q01" VARCHAR,
"te05q03" VARCHAR,
"te05q02" VARCHAR,
"te05q04" VARCHAR,
"te05q05" VARCHAR,
"te06q01" VARCHAR,
"te07q01" VARCHAR,
"te30q01" VARCHAR,
"te09q01" VARCHAR,
"te09q02" VARCHAR,
"te09q03" VARCHAR,
"te09q04" VARCHAR,
"te09q06" VARCHAR,
"te09q05" VARCHAR,
"te09q07" VARCHAR,
"te09q08" VARCHAR,
"te09q09" VARCHAR,
"te10q01" VARCHAR,
"te10q02" VARCHAR,
"te11q01" VARCHAR,
"te11q02" VARCHAR,
"te13q01" VARCHAR,
"te14q01" VARCHAR,
"te14q02" VARCHAR,
"te14q03" VARCHAR,
"te14q04" VARCHAR,
"te14q05" VARCHAR,
"te14q06" VARCHAR,
"te14q07" VARCHAR,
"te14q08" VARCHAR,
"te14q09" VARCHAR,
"te14q12" VARCHAR,
"te14q10" VARCHAR,
"te14q11" VARCHAR,
"te15q01" VARCHAR,
"te16q01" VARCHAR,
"te16q06" VARCHAR,
"te16q02" VARCHAR,
"te16q03" VARCHAR,
"te16q04" VARCHAR,
"te16q05" VARCHAR,
"te18q01" VARCHAR,
"te18q02" VARCHAR,
"te18q08" VARCHAR,
"te18q10" VARCHAR,
"te18q12" VARCHAR,
"te18q13" VARCHAR,
"te18q14" VARCHAR,
"te18q06" VARCHAR,
"te18q03" VARCHAR,
"te18q04" VARCHAR,
"te18q05" VARCHAR,
"te19q01" VARCHAR,
"te19q02" VARCHAR,
"te19q05" VARCHAR,
"te19q03" VARCHAR,
"te19q04" VARCHAR,
"te18q07" VARCHAR,
"te31q01" VARCHAR,
"te18q09" VARCHAR,
"te32q01" VARCHAR,
"te32q02" VARCHAR,
"te21q01" VARCHAR,
"te21q02" VARCHAR,
"te21q04" VARCHAR,
"te21q05" VARCHAR,
"te21q12" VARCHAR,
"te21q06" VARCHAR,
"te21q14" VARCHAR,
"te21q11" VARCHAR,
"te21q07" VARCHAR,
"te21q08" VARCHAR,
"te21q09" VARCHAR,
"te20q01" VARCHAR,
"te20q02" VARCHAR,
"te20q22" VARCHAR,
"te20q03" VARCHAR,
"te20q04" VARCHAR,
"te20q05" VARCHAR
);CREATE TABLE table_2 (
"country" VARCHAR,
"countryid" VARCHAR,
"cnt" VARCHAR,
"eu" VARCHAR,
"level" VARCHAR,
"id" VARCHAR,
"classid" VARCHAR,
"prid" VARCHAR,
"wave" BIGINT,
"n_teachers_part" BIGINT,
"n_students_part" BIGINT,
"n_parents_part" BIGINT,
"pa01q01" VARCHAR,
"pa02q01" BIGINT,
"pa03q011" VARCHAR,
"pa03q012" VARCHAR,
"pa03q013" VARCHAR,
"pa03q014" VARCHAR,
"pa03q015" VARCHAR,
"pa03q016" VARCHAR,
"pa03q017" VARCHAR,
"pa04q01" VARCHAR,
"pa04q02" VARCHAR,
"pa04q03" VARCHAR,
"pa04q04" VARCHAR,
"pa04q05" VARCHAR,
"pa04q06" VARCHAR,
"pa04q07" VARCHAR,
"pa04q08" VARCHAR,
"pa05q01" VARCHAR,
"pa05q02" VARCHAR,
"pa05q03" VARCHAR,
"pa05q04" VARCHAR,
"pa05q20" VARCHAR,
"pa05q05" VARCHAR,
"pa05q08" VARCHAR,
"pa05q06" VARCHAR,
"pa05q10" VARCHAR,
"pa05q12" VARCHAR,
"pa05q13" VARCHAR,
"pa05q14" VARCHAR,
"pa05q15" VARCHAR,
"pa05q17" VARCHAR,
"pa05q18" VARCHAR,
"pa05q19" VARCHAR,
"pa24q02" VARCHAR,
"pa07q01" VARCHAR,
"pa08q01" VARCHAR,
"pa08q02" VARCHAR,
"pa08q03" VARCHAR,
"pa08q04" VARCHAR,
"pa08q05" VARCHAR,
"pa08q06" VARCHAR,
"pa09q01" VARCHAR,
"pa09q02" VARCHAR,
"pa09q03" VARCHAR,
"pa06q01" VARCHAR,
"pa06q02" VARCHAR,
"pa06q03" VARCHAR,
"pa10q01" VARCHAR,
"pa10q02" VARCHAR,
"pa10q03" VARCHAR,
"pa10q04" VARCHAR,
"pa10q05" VARCHAR,
"pa10q06" VARCHAR,
"pa11q01" VARCHAR,
"pa11q02" VARCHAR,
"pa11q03" VARCHAR,
"pa12q01" VARCHAR,
"pa12q02" VARCHAR,
"pa12q03" VARCHAR,
"pa12q04" VARCHAR,
"pa12q05" VARCHAR,
"pa13q01" VARCHAR,
"pa13q02" VARCHAR,
"pa13q03" VARCHAR,
"pa13q06" VARCHAR,
"pa13q04" VARCHAR,
"pa13q05" VARCHAR,
"pa15q01" VARCHAR,
"pa15q02" VARCHAR,
"pa15q03" VARCHAR,
"pa15q04" VARCHAR,
"pa15q05" VARCHAR,
"pa15q06" VARCHAR,
"pa16q01" VARCHAR,
"pa16q02" VARCHAR,
"pa16q03" VARCHAR,
"pa16q04" VARCHAR,
"pa16q05" VARCHAR,
"pa16q06" VARCHAR,
"pa17q01" VARCHAR,
"pa17q02" VARCHAR,
"pa17q03" VARCHAR,
"pa17q04" VARCHAR,
"pa17q05" VARCHAR,
"pa17q06" VARCHAR,
"pa19q01" VARCHAR,
"pa19q02" VARCHAR,
"pa19q03" VARCHAR
);CREATE TABLE table_3 (
"country" VARCHAR,
"countryid" VARCHAR,
"cnt" VARCHAR,
"eu" VARCHAR,
"level1" VARCHAR,
"level2" VARCHAR,
"level3a" VARCHAR,
"level3b" VARCHAR,
"schoolid" VARCHAR,
"princid" VARCHAR,
"wave" BIGINT,
"n_principal_part" BIGINT,
"n_teachers_part" BIGINT,
"n_students_part" BIGINT,
"n_parents_part" BIGINT,
"sc01q01a" VARCHAR,
"sc01q01b" VARCHAR,
"sc01q02a" VARCHAR,
"sc01q02b" VARCHAR,
"sc01q03a" VARCHAR,
"sc01q03b" VARCHAR,
"sc01q04a" VARCHAR,
"sc01q04b" VARCHAR,
"sc04q01" BIGINT,
"sc06q01" VARCHAR,
"sc12q011" VARCHAR,
"sc12q012" VARCHAR,
"sc12q013" VARCHAR,
"sc12q014" VARCHAR,
"sc12q015" VARCHAR,
"sc12q016" VARCHAR,
"sc12q017" VARCHAR,
"sc11q01" VARCHAR,
"sc07q01a" VARCHAR,
"sc07q01b" VARCHAR,
"sc07q01c" VARCHAR,
"sc07q01d" VARCHAR,
"sc07q01e" VARCHAR,
"sc07q03a" VARCHAR,
"sc07q03b" VARCHAR,
"sc07q03c" VARCHAR,
"sc07q03d" VARCHAR,
"sc07q03e" VARCHAR,
"sc07q13a" VARCHAR,
"sc07q13b" VARCHAR,
"sc07q13c" VARCHAR,
"sc07q13d" VARCHAR,
"sc07q13e" VARCHAR,
"sc07q14a" VARCHAR,
"sc07q14b" VARCHAR,
"sc07q14c" VARCHAR,
"sc07q14d" VARCHAR,
"sc07q14e" VARCHAR,
"sc07q11a" VARCHAR,
"sc07q11b" VARCHAR,
"sc07q11c" VARCHAR,
"sc07q11d" VARCHAR,
"sc07q11e" VARCHAR,
"sc07q05a" VARCHAR,
"sc07q05b" VARCHAR,
"sc07q05c" VARCHAR,
"sc07q05d" VARCHAR,
"sc07q05e" VARCHAR,
"sc07q07a" VARCHAR,
"sc07q07b" VARCHAR,
"sc07q07c" VARCHAR,
"sc07q07d" VARCHAR,
"sc07q07e" VARCHAR,
"sc07q08a" VARCHAR,
"sc07q08b" VARCHAR,
"sc07q08c" VARCHAR,
"sc07q08d" VARCHAR,
"sc07q08e" VARCHAR,
"sc08q01" VARCHAR,
"sc09q01" BIGINT,
"sc09q02" BIGINT,
"sc09q03" BIGINT,
"sc09q04" BIGINT,
"sc13q01" VARCHAR,
"sc13q02" VARCHAR,
"sc13q03" VARCHAR,
"sc13q04" VARCHAR,
"sc14q01" VARCHAR,
"sc14q02" VARCHAR,
"sc14q03" VARCHAR,
"sc14q15" VARCHAR,
"sc14q06" VARCHAR,
"sc14q13" VARCHAR,
"sc14q04" VARCHAR,
"sc14q05" VARCHAR,
"sc14q12" VARCHAR,
"sc14q14" VARCHAR,
"sc14q07" VARCHAR,
"sc14q08" VARCHAR,
"sc14q09" VARCHAR,
"sc15q01" VARCHAR,
"sc15q02" VARCHAR,
"sc15q03" VARCHAR,
"sc15q04" VARCHAR,
"sc15q05" VARCHAR
);CREATE TABLE table_6 (
"level" VARCHAR,
"country" VARCHAR,
"countryid" VARCHAR,
"cnt" VARCHAR,
"eu" VARCHAR,
"schoolid" VARCHAR,
"classid" VARCHAR,
"stid" VARCHAR,
"wave" BIGINT,
"n_teachers_part" BIGINT,
"n_students_part" BIGINT,
"n_parents_part" BIGINT,
"st25q01" VARCHAR,
"st22q01" VARCHAR,
"st01q01" VARCHAR,
"st01q03" VARCHAR,
"st01q04" VARCHAR,
"st02q01" VARCHAR,
"st03q01" VARCHAR,
"st03q02" VARCHAR,
"st03q05" VARCHAR,
"st03q06" VARCHAR,
"st03q07" VARCHAR,
"st03q08" VARCHAR,
"st03q09" VARCHAR,
"st03q14" VARCHAR,
"st03q13" VARCHAR,
"st03q11" VARCHAR,
"st03q16" VARCHAR,
"st27q01" VARCHAR,
"st27q02" VARCHAR,
"st27q03" VARCHAR,
"st27q04" VARCHAR,
"st31q01a" VARCHAR,
"st32q01a01" VARCHAR,
"st32q01a02" VARCHAR,
"st32q01a03" VARCHAR,
"st32q01a04" VARCHAR,
"st32q01a05" VARCHAR,
"st32q01a06" VARCHAR,
"st32q01a07" VARCHAR,
"st32q01a08" VARCHAR,
"st32q01a09" VARCHAR,
"st32q01a10" VARCHAR,
"st32q01a11" VARCHAR,
"st32q01a12" VARCHAR,
"st32q01a13" VARCHAR,
"st32q01a14" VARCHAR,
"st32q01a15" VARCHAR,
"st32q01a16" VARCHAR,
"st32q01a17" VARCHAR,
"st32q01a18" VARCHAR,
"st32q01a19" VARCHAR,
"st32q01a20" VARCHAR,
"st32q01a21" VARCHAR,
"st32q01a22" VARCHAR,
"st32q01a23" VARCHAR,
"st32q01a24" VARCHAR,
"st32q01a25" VARCHAR,
"st32q01a26" VARCHAR,
"st32q01a27" VARCHAR,
"st32q01a28" VARCHAR,
"st32q01a29" VARCHAR,
"st32q01a30" VARCHAR,
"st32q01a31" VARCHAR,
"st05q03" VARCHAR,
"st05q05" VARCHAR,
"st05q06" VARCHAR,
"st05q12" VARCHAR,
"st06q12" VARCHAR,
"st05q01" VARCHAR,
"st05q16" VARCHAR,
"st05q02" VARCHAR,
"st05q18" VARCHAR,
"st05q13" VARCHAR,
"st05q22" VARCHAR,
"st05q24" VARCHAR,
"st05q25" VARCHAR,
"st05q07" VARCHAR,
"st29q01" VARCHAR,
"st29q02" VARCHAR,
"st29q06" VARCHAR,
"st29q10" VARCHAR,
"st29q03" VARCHAR,
"st29q04" VARCHAR,
"st29q05" VARCHAR,
"st29q07" VARCHAR,
"st29q08" VARCHAR,
"st29q09" VARCHAR,
"st30q01" VARCHAR,
"st30q02" VARCHAR,
"st30q03" VARCHAR,
"st30q04" VARCHAR,
"st30q05" VARCHAR,
"st30q06" VARCHAR,
"st06q02" VARCHAR,
"st06q09" VARCHAR,
"st06q04" VARCHAR,
"st06q05" VARCHAR,
"st06q18" VARCHAR
);Anyone who has the link will be able to view this.