TEDS Data Dictionary

12 Year Study Data Files

Contents of this page:

Introduction

This page relates specifically to data collected in the 12 Year study. More general issues relating to the storage and organisation of TEDS data files are discussed on another page.

Raw Data files

These are currently stored in the \System\Rawdata\12yr\ folder, and the list below refers to files and sub-directories within this folder.

The Access database has been periodically updated to keep it in the most recent Access format, to avoid software compatibility issues. Nevertheless, the essential data from the tables are also stored in exported "copies" in the form of the csv files in the Export folder.

  • 12yr.accdb.
    This is the Access database file (2007 format) containing aggregated and cleaned 12 Year raw data from the booklets/questionnaires and from administrative sources. (Note that it does not contain the web test data; the files of web test data are generally very large, and contain far too many columns to be accommodated in Access tables.)
    This Access database is now treated as the master copy of the data (except for the web tests), and is the source of such data for the analysis dataset. The important tables in the database are:
    • Teacher - data from the teacher questionnaires
    • Parent1, Parent2 - data from the parent booklet
    • TwinQuestionnaire - data from the child booklet
    • SRSparentCAST - data from the parent SRS CAST questionnaire
    • yr12Progress - admin data relating to the 12 Year study, such as return dates. This table also includes data from the twin TOWRE telephone tests, and the parent NC levels questionnaire. This table was originally in the TEDS admin database.
  • \Export\ subdirectory, containing exported 12 Year raw data files. These files are directly used to construct the analysis dataset.
    Some of the files are exported from the Access database described above; they are csv files. The exported csv files originate from tables in the Access database above. The files are called:
    • Parent1.csv, Parent2.csv (parent booklet data)
    • SRSparentCAST.csv (parent SRS CAST questionnaire data)
    • TwinQuestionnaire.csv (twin booklet data)
    • Teacher.csv (teacher questionnaire data)
    • AdminData.csv (admin data from table yr12Progress, including TOWRE data, parent NC data, and return dates)
  • \web data files\ subdirectory, containing aggregated web test data files. There is one file for each of the twin web activities, plus a file of family web status data. Each such file contains data aggregated from the different waves of data collection, with identifying fields (like names) removed. These files were aggregated, with some cleaning, from the raw analysis files that were originally downloaded from the web server. The web data files are as follows.
    • 12yr_families_status.csv - Web study family status data, including status flags for each twin in each test.
    • 12yr_piat.csv - PIAT test data
    • 12yr_yes_no.csv - Yes/No test data
    • 12yr_goal.csv - GOAL test data
    • 12yr_maths.csv - Mathematics test data
    • 12yr_raven.csv - Ravens test data
    • 12yr_vocab.csv - Vocabulary test data
    • 12yr_pic_comp.csv - Picture Completion test data
    • 12yr_gen_kn.csv - General Knowledge test data
    • 12yr_fig_lang.csv - Expressions test data
    • 12yr_toal.csv - TOAL test data
    • 12yr_inferences.csv - Inferences test data
    • 12yr_eyes.csv - Eyes test data
    • 12yr_jigsaws.csv - Jigsaws test data
    • 12yr_hidden_shapes.csv - Hidden Shapes test data
    • 12yr_mrq_ar.csv - Maths and Reading Questionnaire plus Author Recognition data

Dataset files

These files are currently stored in the \System\Datasets\12yr\files\ folder. The following list refers to items within this folder.

  • Ldb9456.sav - the full SPSS version of the 12 Year dataset
  • \working files\ - this subdirectory contains various intermediate files, saved during the process of converting the raw data into the dataset. These files include working datasets l1merge, l2recode, l3derive, l4label, l5label, l6double (all .sav files), saved at the end of the 6 scripts. The latter file is identical (except for the name) to the final dataset Ldb9456_full.sav.

Syntax files (scripts)

These files are currently stored in the \System\Scripts\12yr\ folder.
Note that these are SPSS syntax files. The names of the scripts are L1_merge, L2_recode, L3_derive, L4_label_part1, L5_label_part2, L6_double (all .sps files). The processing carried out by these scripts is described on another page.