Have a personal or library account? Click to login
Data from the Swiss TREE Panel Study (Transitions from Education to Employment) Cover

Data from the Swiss TREE Panel Study (Transitions from Education to Employment)

Open Access
|Nov 2023

Figures & Tables

jopd-11-97-g1.png
Figure 1

TREE multi-cohort design.

Table 1

TREE1 sample and response.

Calendar year20002001200220032004200520062007201020142019/20
Panel wavebaseline12345678910
Ø age of sample1617181920212223263035
Sample and responseN valid gross sample6343594456095345506048524659457144023882
N response5528520648774679450641333979342331422979
% response/baseline87%82%77%74%71%65%63%54%50%47%
Table 2

Selected sample descriptives for TREE1, baseline and panel wave 9 (2000 and 2014).

TREE1 BASELINE SURVEY, 2000N% OR MEAN
(UNWEIGHTED)(UNWEIGHTED)
Total6343100%
GenderFemale344054%
Male290346%
Age6319Ø 15.5
Year of birth198375712%
1984339954%
1985205232%
Other years1112%
Academic track attended at lower secondary levelExtended requirements435868%
Basic requirements162626%
No formal tracking3576%
PISA reading literacy score6337Ø 510.0
Highest parental socio-economic index (HISEI)5845Ø 50
Highest parental educationCompulsory
Secondary
Tertiary
1464
2189
2399
24%
36%
40%
Migration backgroundSwiss native*377660%
2nd generation migrant**156025%
1st generation migrant***90014%
Language regionGerman297047%
French254040%
Italian83313%
Rural vs. urban areaRural207233%
Urban427167%
TREE1 PANEL WAVE 9, 2014 (≈30 YEARS OLD)N% OR MEAN
(UNWEIGHTED)(UNWEIGHTED)
Total3142100%
Educational attainmentCompulsory873%
Secondary116137%
Tertiary188160%
Gainful occupationFull-time work (≥90%)207466%
Part-time work (<90%)71223%
Other situation35611%
Marital statusSingle220270%
Married89328%
Other status461%
ParenthoodYes76724%
No237476%

[i] Note that percentages may not add up to 100% due to missing values (not displayed for reasons of table readability).

Note that we display only a (selected number of salient) variables measured/collected on the occasion of the two panels waves in question.

* Participants and their parents born in Switzerland.

** Participants born in Switzerland, with at least one parent born abroad.

*** Participants born abroad.

Source: own calculations.

Table 3

TREE2 sample and responses.

Calendar year2016201720182019202020212022
Panel wavebaseline123456
Ø age of sample16171819202122
Sample and response
    N valid goss sample9741*9251*8918*785569496128
    N response797169036154535345014461
    % response/baseline82%75%69%68%65%73%

[i] * Due to retrospective exclusions from the sample, the published datasets comprise only 8,429 cases.

Table 4

Selected sample descriptives for TREE2, 2016 and 2019 (baseline and panel wave 3).

TREE2 BASELINE SURVEY, 2016N% OR MEAN
(UNWEIGHTED)(UNWEIGHTED)
Total8429100%
GenderFemale459254%
Male383746%
Age8429Ø 15.8
Year of birth1999103812%
2000480957%
2001249230%
Other years901%
Academic track attended at lower secondary levelHigh requirements241929%
Extended requirements342341%
Basic requirements254030%
AES math score8340Ø.13
Highest parental socio-economic index (HISEI)8267Ø 51
Highest parental educationCompulsory115014%
Secondary391446%
Tertiary317439%
Migration backgroundSwiss native*609373%
2nd generation migrant**154118%
1st generation migrant***7639%
Language regionGerman588570%
French208125%
Italian4635%
Rural vs. urban areaRural453354%
Intermediate200124%
Urban186322%
TREE2 3RD PANEL WAVE SAMPLE, 2019 (≈19 YEARS OLD)N% OR MEAN
(UNWEIGHTED)(UNWEIGHTED)
Total6154100%
Educational statusNot in education or training3205%
Internship or transitional solutions921%
2 years VET731%
3–4 years VET293848%
Vocational baccalaureate61210%
General baccalaureate172128%
Other general education programme3986%

[i] Note that percentages may not add up to 100% due to missing values (not displayed for reasons of table readability).

Note that we display only a (selected number of salient) variables measured/collected on the occasion of the two panels waves in question.

* Participants and their parents born in Switzerland.

** Participants born in Switzerland with at least one parent born abroad.

*** Participants born abroad.

Source: own calculations.

Table 5

Survey topics of TREE1 and TREE2.

SURVEY TOPICSCOMPARABILITY WITH TREE1
MAINDETAILED
Socio-demographicsSocio-demographic characteristics and housing situation
      Age and GenderC
      Civil StatusC
      Housing situationC
Composition of (own) familyC
Migration background and nationality
      Migration backgroundC
      Nationality, residence status
Education, training and employmentEducational pathways and transitions (lower sec. level)
      Educational biography (compulsory school)C
      Educational decisions (transitions lower => upper sec. education):perceived cost, benefit and chances of success
      Educational objectives and aspirationsC
      Plans for education and trainingC
      Characteristics of maths lessons (end of lower secondary education)
Educational situation and post-compulsory pathways
      Attended educational programmesC
      Attended schoolsC
      Attended training firmsC
      Skills requirements for educational activities/media use
      Absenteeism/intention to change educationC
      Resources and strains (education)C
      Credentials and marksC
      Reasons discontinuing education and training
Employment situation (incl. internships) and pathways
      Employment/internshipsC
      Conditions of employmentC
      Job position within company’s hierarchyC
      SalaryC
      Resources and strains (employment)C
      Job tasks, requirements and job-skills-mismatchC
      Absenteeism/intention to change jobC
      Reasons for termination of employment
      Desired job situation
Self-assessment of education and employment pathways
      Assessment of current education and training
      Assessment of completed education & training
      Perceived fit and commitment: main activityC
Other activities, job and training searchSearch for education or employment
      Search for education (end of lower secondary education)
      Search for VET training place (upper sec.)C
      Job search (upper sec.)C
      Search for general education programme (upper sec.)
Other activities
      Unemployment (unregistered and registered)(C)
      Vacation/holidays(C)
      Military service(C)
      Childcare (as main activity)(C)
      Illness/accident(C)
      Maternity/paternity leave(C)
      Gap/missing information(C)
Reasons for non-participation in education and employment
      Reasons for non-participation in education and employment
      Reasons for non-participation in education
      Reasons for part-time & non-employment
Family, significant others, social origin and networksFamily background
      Family climateC
      Socio-economic originC
      Childcare situation (own children)
Social, cultural, and economic resources
      Social capital (own)
      Cultural capital (family of origin)C
      Cultural capital (own)C
      Economic capital (family of origin)C
      Financial situation (general)C
Social participationSocial and cultural participation
      Politics(C)
      Leisure
      Group affiliation and sense of belonging (identity)C
Well-beingand healthSatisfaction and well-being
      SatisfactionC
      School-related well-being
      Critical life eventsC
HealthC
SelfNon-cognitive factors
      Motivational conceptsC
      Self-perceptionC
      Emotions related to maths classes
      Volitional strategiesC
      Personality characteristics
      Global preferences (risk, time and social preferences)
      Values and attitudesC
      Attitudes related to maths classes
Cognitive skills (assessments)
      basic mathematical skills(C+)
      reading speed
      cognitive skills

[i] Legend for columns on comparison with TREE1:

C = Data (partly) comparable across cohorts. (C) Comparable data for both cohorts in upcoming data releases. (C+) Elaborated, but not fully comparable assessment of math competences available for both cohorts (TREE1: randomized split-half sample).

Table 6

Overview of TREE1 data and their documentation. Release 2019 (https://doi.org/10.23662/FORS-DS-816-7).

DATADOCUMENTATION
PISA 2000
PISA-TREE_2000_Version_20xx.sav
  • – PISA_2000_manual_original-variables.pdf

  • – PISA_2000_Codebook_complementary_20xx.pdf

  • – PISA_2000_Technical_Report_original-variables.pdf

  • – PISA 2000 school & student questionnaires in German, French, Italian and English

  • – Warning re PISA 2000 variables on parental education (PISA_2000_Bergman_etal_2010_Problems_educ_attainment_parents.pdf)

TREE1, WAVE-SPECIFIC DATA 2001–2014
Notation:
TREE_data_wave-x-20yy_version_20zz.sav
Notation:
TREE_codebook_wave-x-20yy_version_20zz.pdf
Datasets of first panel wave, 2001:
TREE_data_wave-1–2014_version_2016_german.sav
TREE_data_wave-1–2014_version_2016_french.sav
Codebook for data of first panel wave, 2001:
TREE_codebook_wave-9–2014_version_2016.pdf
Datasets and codebooks of all further panel waves are organised and named the same way as for panel wave 1.
TREE1, FURTHER DATA
TREE_data_certificates_2001–2014_version_20xx.savTREE_codebook_certificates_2001–2014_version_20xx.pdf
TREE_data_weights_wave1–9_version_20xx.sav
  • – TREE_codebook_weights_wave1–9_version_20xx.pdf

  • – Sacchi_2011_TREE_longitudinal_weights_german.pdf

TREE_job_episodes_2003–2014_version_20xx.savTREE_codebook_job_episodes_2003–2014_version_20xx.pdf
Table 7

Overview of TREE2 data and their documentation. Release 2023 (https://doi.org/10.48573/kz0d-8p12).

SECTION/FILES OF THE DATA PACKAGEFILE NAME
0 TO START WITH – GENERAL INFORMATION
Working with the TREE2 data release: How to get started. Update 2023TREE2_How-to-get-started_v2.pdf
TREE2 study design. Update 2023TREE2_Study_Design_Update_2023.pdf
Notes on weighting and variance estimation. Update 2023TREE2_Readme_Weights_v2.pdf
Longitudinal Weights for theTREE2 panel survey. Construction and applicationTREE2_Documentation_Weights.pdf
The TREE multi-cohort panel study. Theoretical frameworkTREE_Theoretical_Framework_2022.pdf
1 DATASETS
Data from panel wave 0 (baseline) (Stata format)TREE2_Data_Wave_0_v2.dta
Data from panel wave 0 (baseline) (SPSS format)TREE2_Data_Wave_0_v2.sav
Data from panel wave 1 (Stata format)TREE2_Data_Wave_1_v2.dta
Data from panel wave 1 (SPSS format)TREE2_Data_Wave_1_v2.sav
Data from panel wave 2 (Stata format)TREE2_Data_Wave_2_v2.dta
Data from panel wave 2 (SPSS format)TREE2_Data_Wave_2_v2.sav
Data from panel wave 3 (Stata format)TREE2_Data_Wave_3_v2.dta
Data from panel wave 3 (SPSS format)TREE2_Data_Wave_3_v2.sav
Activity spells data (episodes) from panel waves 0 to 3 (Stata format)TREE2_Data_Episodes_v2.dta
Activity spells data (episodes) from panel waves 0 to 3 (SPSS format)TREE2_Data_Episodes_v2.sav
Weights for waves 0–3 [Stata format]TREE2_Data_Survey_Weights_v2.dta
Weights for waves 0–3 [SPSS format]TREE2_Data_Survey_Weights_v2.sav
      1–1 MATHS TEST (WAVE 0)
Additional test data from baseline survey (Stata format)TREE2_Data_Wave_0_Maths_Test_v2.dta
Additional test data from baseline survey (SPSS format)TREE2_Data_Wave_0_Maths_Test_v2.sav
Read-me document for additional test dataTREE2_Readme_Wave_0_Maths_Test_v2.pdf
      1–2 – SCHOOL, CLASS AND SURVEY CONTEXT (WAVE 0)
Additional school and sampling data from baseline survey (Stata format)TREE2_Data_Wave_0_Schooling_Context_v2.dta
Additional school and sampling data from baseline survey (SPSS format)TREE2_Data_Wave_0_Schooling_Context_v2.sav
Read-me document for additional school and sampling data from baseline surveyTREE2_Readme_Wave_0_Schooling_Context_v2.pdf
      1–3 COGNITIVE ABILITY TEST CAT (WAVE 0)
Cognitive ability test data (Stata format)TREE2_Data_Wave_0_CAT_v2.dta
Cognitive ability test data (SPSS format)TREE2_Data_Wave_0_CAT_v2.sav
Syntax for cognitive ability test data (Stata format)TREE2_Syntax_Wave_0_CAT_Validation_v2.do
Read-me/short documentation on cognitive ability test dataTREE2_Readme_Wave_0_CAT_v2.pdf
      1–4 READING SPEED TEST
Reading speed test data: scores only, graduation year subsample [Stata format]TREE2_Data_Reading_Speed_Test_Graduation_Year_v2.dta
Reading speed test data: scores only graduation year subsample [SPSS format]TREE2_Data_Reading_Speed_Test_Graduation_Year_v2.sav
Reading speed test data: all test variables, all test cases [Stata format]TREE2_Data_Reading_Speed_Test_Items_v2.dta
Reading speed test data: all test variables, all test cases [SPSS format]TREE2_Data_Reading_Speed_Test_Items_v2.sav
Reading speed test data: syntax (Stata format)TREE2_Syntax_Reading_Speed_Test_Validation_v2.do
      1–5 PRE-GRADUATION MEASUREMENTS
Data on measures collected specifically prior to upper secondary graduation (Stata format)TREE2_Data_Pregraduation_v2.dta
Data on measures collected specifically prior to upper secondary graduation (SPSS format)TREE2_Data_Pregraduation_v2.sav
Read-me/short documentation on pre-graduation measurementsTREE2_Readme_Pregraduation_v2.pdf
2 CODEBOOKS, VARIABLE LISTS & CODE LISTS
Codebook for data of panel wave 0 (baseline survey, 2016)TREE2_Codebook_Wave_0_v2.pdf
Codebook for data of panel wave 1 (2017)TREE2_Codebook_Wave_1_v2.pdf
Codebook for data of panel wave 2 (2018)TREE2_Codebook_Wave_2_v2.pdf
Codebook for data of panel wave 3 (2019)TREE2_Codebook_Wave_3_v2.pdf
Codebook for episodic dataTREE2_Codebook_Episodes_v2.pdf
Codebook for weighting dataTREE2_Codebook_Weights_v2.pdf
Technical lists of variables, panel waves 0–3 (2016–2019)TREE2_Variable_Lists_Technical_v2.pdf
Conceptual list of variables, panel waves 0–3 (2016–2019)TREE2_Variable_List_Conceptual_v2.xlsx
Code list of occupationsTREE2_Codelist_Occupations_v2.xlsx
Code list of education programmesTREE2_Codelist_Education_v2.xlsx
3 DOCUMENTATION ON SCALES
Documentation of scales implemented from panel wave 1 onwardTREE2_Scale-Reporting_Wave_1_onwards_v2.pdf
4 QUESTIONNAIRES
Questionnaire administered in panel wave 0 (baseline survey, AES), GermanTREE2_Questionnaire_Wave_0_AES_GER
Questionnaire administered in panel wave 0 (baseline survey, AES), FrenchTREE2_Questionnaire_Wave_0_AES_FRE
Questionnaire administered in panel wave 0 (baseline survey, AES), ItalianTREE2_Questionnaire_Wave_0_AES_ITA
Questionnaire administered in panel wave 0 (baseline survey, AES extension), GermanTREE2_Questionnaire_Wave_0_AES_Extension_GER
Questionnaire administered in panel wave 0 (baseline survey, AES extension), FrenchTREE2_Questionnaire_Wave_0_AES_Extension_FRE
Questionnaire administered in panel wave 0 (baseline survey, AES extension), ItalianTREE2_Questionnaire_Wave_0_AES_Extension_ITA
Complementary questionnaire administered in panel wave 1, GermanTREE2_Questionnaire_Complementary_Wave_1_GER
Complementary questionnaire administered in panel wave 1, FrenchTREE2_Questionnaire_Complementary_Wave_1_FRE
Complementary questionnaire administered in panel wave 1, ItalianTREE2_Questionnaire_Complementary_Wave_1_ITA
Complementary questionnaire administered in panel wave 2, GermanTREE2_Questionnaire_Complementary_Wave_2_GER
Complementary questionnaire administered in panel wave 2, FrenchTREE2_Questionnaire_Complementary_Wave_2_FRE
Complementary questionnaire administered in panel wave 2, ItalianTREE2_Questionnaire_Complementary_Wave_2_ITA
Complementary questionnaire administered in panel wave 3, GermanTREE2_Questionnaire_Complementary_Wave_3_GER
Complementary questionnaire administered in panel wave 3, FrenchTREE2_Questionnaire_Complementary_Wave_3_FRE
Complementary questionnaire administered in panel wave 3, ItalianTREE2_Questionnaire_Complementary_Wave_3_ITA
DOI: https://doi.org/10.5334/jopd.97 | Journal eISSN: 2050-9863
Language: English
Submitted on: Jun 6, 2023
|
Accepted on: Sep 20, 2023
|
Published on: Nov 9, 2023
Published by: Ubiquity Press
In partnership with: Paradigm Publishing Services
Publication frequency: 1 issue per year

© 2023 Sandra Hupka-Brunner, Thomas Meyer, Andrés Gomensoro, published by Ubiquity Press
This work is licensed under the Creative Commons Attribution 4.0 License.