Baselight
Sign In

2nd Survey Of Schools: ICT In Education

Directorate-General for Communications Networks, Content and Technology

@ecdgconnect.n_2nd_survey_of_schools_ict_in_education

Loading...
Loading...

About this Dataset

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 entry level scenario outlines the minimum and essential components of a HECC. - The advanced scenario further advances the entry level scenario, e.g. by entailing more advanced digital equipment, as well as a greater number of teachers’ professional development activities and access to paid-for contents. - The cutting-edge level is a further advanced scenario in relation to network requirements, it also includes a greater variety of digital equipment and increased opportunities for face-to-face professional development for teachers, and leadership training. 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: - Access to and use of digital technologies - Digital activities and digital confidence of teachers and students - ICT related teacher professional development - Digital home environment of students - Schools’ digital policies, strategies and opinions 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: 2024-06-11T16:16:06Z

Tables

Table 1

@ecdgconnect.n_2nd_survey_of_schools_ict_in_education.table_1
  • 814.37 KB
  • 9927 rows
  • 166 columns
Loading... 

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
);

Table 2

@ecdgconnect.n_2nd_survey_of_schools_ict_in_education.table_2
  • 969.1 KB
  • 19038 rows
  • 112 columns
Loading... 

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
);

Table 3

@ecdgconnect.n_2nd_survey_of_schools_ict_in_education.table_3
  • 1.08 MB
  • 8749 rows
  • 198 columns
Loading... 

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
);

Table 6

@ecdgconnect.n_2nd_survey_of_schools_ict_in_education.table_6
  • 3.69 MB
  • 48835 rows
  • 216 columns
Loading... 

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
);

Share link

Anyone who has the link will be able to view this.