TEDS Data Dictionary

9 Year Study Data Files

Contents of this page:

Introduction

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

Raw Data files

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

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.

  • 9yr.accdb. This is the Access database file (2007 format) containing all the aggregated and cleaned 9 Year raw data. This is now treated as the master copy of the data, and is the source of data used in the analysis dataset. The important tables in the database are:
    • Parent1, Parent2, Parent3 - data from the parent booklets (there are too many columns to be accommodated in a single Access table, so the columns are split between three tables)
    • ChildBooklet - data from the twin booklets
    • Teacher - data from the teacher booklets
    • yr9Progress - admin data relating to the 9 Year study, such as return dates. This table was originally in the TEDS admin database.
  • \Export\ subdirectory, containing exported 9 Year raw data files.
    These csv files have been exported from the Access database described above, for the purpose of making the analysis dataset. The files are called:
    • Parent1.csv, Parent2.csv, Parent3.csv (parent booklet data)
    • ChildBooklet.csv (twin booklet data)
    • Teacher.csv (teacher booklet data)
    • 9yrAdmin.csv (admin data from table yr9Progress)
  • \twin story files\ subdirectory.
    This contains a set of pdf files, each of which contains a scanned image of the twin story from the 9 Year twin booklet for a given twin. The files are pseudonymous, each filename being the pseudonymous ID (id_twin) for the given twin.

Dataset files

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

  • idoub945.sav - the SPSS version of the 9 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 i1merge, i2derive, i3label, i4double (all .sav files), saved at the end of scripts 1 to 4. The latter file is identical (except for the name) to the final dataset idoub945.sav.

Syntax files (scripts)

These files are currently stored in the \System\Scripts\9yr\ directory.
Note that these are SPSS syntax files. The names of the scripts are i1_merge, i2_derive, i3_label, i4_double (all .sps files). The processing carried out by these scripts is described on another page.