The National Archives

Thursday 5 November

   
 
 NDAD: The National Digital Archive of Datasets
Welcome (home page) About NDAD Users Contributors  
Search Browse News Help (new window)  
 
 

Dataset details: CRDA/13/DS/5/2001

All schools 2001

 
 
Quick reference Full details
 
  View in hierarchy
 

Jump to :

  Context   |   Identity statement   |   Administrative context   |   Source of acquisition   |   Nature and content   |   Conditions of access and use   |   Allied materials   |   Structure   |   Validation   |   Related datasets   |  Notes

Context

Schools' Census (Form 7)
Top of pagetop of page

Identity statement

Title All schools 2001
NDAD reference CRDA/13/DS/5/2001
Dates of creation of datasets 2001
Dates of contents of datasets 2001
Date of last input to datasets 2001
Date of last access to datasets 2001
Extent of datasets 1 dataset: 66.1192 MB after processing by NDAD; 7 tables comprising 787268 records.
ISAD(G) level of description File
Top of pagetop of page

Administrative context

Aim and purpose
Statement of responsibility
Top of pagetop of page

Source of acquisition

Source of acquisition This dataset was transferred to NDAD by the Department for Education and Skills (DfES) on a CD-ROM received on 29th June 2007. The transfer also included datasets for the 1996-2000 Schools' Censuses. For the dataset catalogues relating to these years, see Links to related datasets below.
Top of pagetop of page

Nature and content

Scope and content

This dataset comprises data gathered from all schools in England during the Schools' Census conducted by the Department for Education in 2001.The enumeration date was the third Thursday in January, 18th January 2001. Most of the data reflects the position in schools on that date, though some questions required schools to supply data for different periods. For example, primary and secondary schools were asked to give the numbers of teaching staff and the hours worked by non-teaching staff during the week beginning 15th January 2001.

The 2001 dataset contains the following types of data in seven tables:

(1) All Schools 2001

This table contains data on the school, pupils, classes, and teaching staff.

  • Data on the school: its LEA and region and its Form 7 school type.
  • Data on pupils: numbers of pupils on the registers of schools on the enumeration date by sex, by whether pupils were full-time or part-time, and by age at 31st August 2000.
  • Numbers of pupils in designated nursery classes in primary schools.
  • Numbers of boarding pupils, by sex.
  • Numbers of sixth form pupils, by sex and year (first or second).
  • School meals: numbers of pupils who received a free school meal on the enumeration date, and the numbers of day pupils who were eligible for a free school meal. This was further broken down to count pupils up to or above the minimum school leaving age, and whether full-time or part-time.
  • Pupils with statements of special educational needs (SEN), according to their age. The table also includes dually registered pupils with or without statements, by age.
  • Data on teachers: Numbers of qualified teachers, by sex, whether full-time or part-time; totals of full-time and full-time equivalents; and totals of full-time and part-time graduates. More information on Teachers is in the table Teaching staff 2001.

Ethnicity of pupils: this section had been added to the Census in 1996, following changes made after 19th September 1995. The ethnic categories used in the earlier ethnic monitoring survey remained the same as those used in 2000. For definitions of the terms 'White UK Heritage', 'White European' and 'White other', see for example p 3 of the Completion notes for maintained primary schools, reference CRDA/13/DD/1/2001/2 in the Dataset Documentation Catalogue. In 2001, this part of the survey also counted pupils for whom English is a second language, and dually registered pupils.

The minority ethnic monitoring aspect of the survey is also reflected in sections of the data tables for Teaching staff and Non-teaching staff (see below).

Information on new admissions to primary, middle and secondary schools was sought on the questionnaires, but does not appear to be included in this dataset.

Completion time figures were sought on the form, but are not part of this dataset.

(2) Pupils 2001

This table contains totals of full-time and part-time boy and girl pupils; totals of full-time and part-time boy and girl pupils in nursery classes in primary schools; and data on dually and solely registered pupils. The field AGE_C, which contains 24 values which correspond to the age ranges as usually set out on the Form 7 forms, allows greater flexibility in the analysis of the data.

(3) Courses of study 2001

The table contains information on courses of study followed by older pupils for secondary schools (including Independent schools and City Technology Colleges). This table shows numbers of pupils aged between 16-19 and over on 31st August 2000, analysed by course of study. Types of course are listed in the field COURSE_C.

(4) Teaching staff 2001

Total numbers of male and female teaching staff, by type of teacher, and whether full-time or part-time; and data on the full-time equivalents of part-time staff. The four fields TCHRTYP_1, TCHRTYP_2, TCHRTYP_3 and TCHRTYP_4, containing between them the names of 15 teacher types, allow for flexibility in the analysis of the data. Among the teacher types are teachers of minority ethnic pupils who were employed to 'meet the particular needs' of such pupils, or as 'teachers of English as a second language'.

Information about teachers on long-term paid absence, and relief teachers providing cover for short-term absence, was sought on the questionnaires but does not appear to be included in this dataset. The same applies to information concerning advertised teacher vacancies in schools on the census date.

(5) Non-teaching staff 2001

This table gives total numbers of support staff, and also provides information on their categories and working hours, and whether full-time or part-time. The categories of non-teaching staff include Education Support Staff (E.S.S.) (eg nursery assistants, special needs support staff, bilingual assistants); Other Education Support Staff (O.E.S.S.) (matrons and nurses, medical staff, librarians etc); and administrative/clerical staff (eg secretaries, bursars). Education Support Staff includes staff employed to meet the needs of minority ethnic pupils (eg bilingual assistants). These categories are coded in the field ASCODE2_C. For each category of non-teaching staff, the table records the full-time equivalents based on the number of hours worked by staff in the census week.

(6) Classes as taught 2001

Schools were asked to provide information on classes as taught during a selected period on the day of enumeration. The data in this table is analysed by class type, class number, numbers of pupils, numbers of teachers, class size breakdown, and numbers of teachers and non-teaching staff in class. Data on Key Stage and Activity of the class is also available. The 2001 dataset uses six new fields (clasnum1-clasnum6). They do not relate to any of the data items collected by the Census, and were variables generated by the Department as a means of identifying each separate class within each school. 1 NDAD have no information as to the meaning of the data in these fields, and they are unlikely to be needed by users of the dataset. The Department has confirmed they were not used for analysis.

(7) Permanent Exclusions 2001

This table recorded the numbers of permanent exclusions for the academic year 1999-2000. Schools entered detail on the gender, age (as at 31st August 1999), ethnicity and statement of special educational needs of the excluded pupils. If an excluded pupil had been reinstated following an appeal, they were not counted in the survey.

The 2001 forms sought additional information about exclusions appeals from voluntary aided and special agreement schools: the total number of appeals lodged by parents, number of appeals heard by an independent appeals committee, and number of successful appeals. Similar totals were also sought for admission appeals. None of the results have been recorded in this dataset, however.

The dataset contains a number of derived fields, ie fields whose values were calculated by the Department using information supplied by the school. For example, primary and secondary schools were required to record on their forms the total "directed" hours per week of part-time teaching staff and the hours worked per week by full-time and part-time non-teaching staff; from this the full-time equivalents of staff were calculated by the Department.

For further information on the Schools' Census, see the Series Catalogue.

Digital processing and conversion

The data received on 29th June 2007 was in Qstat format. It was exported into csv format using the export function in Qstat (version 2.11 for Windows). The files then had their line endings changed from the DOS to the Unix standards.

A QStat data dictionary was also transferred for each of the tables within this dataset, providing descriptions of the fields. These existed in non-encoded, plain text format.

Top of pagetop of page

Conditions of access and use

Access conditions The 2001 dataset, and the accompanying 2001 documentation, are public records and are open without restriction.
Top of pagetop of page

Allied materials

Related units of description

NDAD holds 17 examples of documentation used in the 2001 Schools' Census. These include blank copies of forms for various school types, formerly called Form 7 forms but now recoded as ASC (Annual Schools’ Census) forms. NDAD also holds copies of Completion Notes for most of the forms. See the Dataset Documentation Catalogue, references CRDA/13/DD/1/2001/1-17.

Associated material
Publications produced by the originating department

Statistics of Education: Schools in England 2001. London, The Stationery Office 2001. Published with the permission of the DfEE.

Publications produced by researchers working on the datasets
Top of pagetop of page

Structure

Logical structure and schema

The dataset consists of seven tables: the main table All schools 2001 (SCSC01VQ) and six related tables, Pupils 2001 (SCPU01VK), Courses of study 2001 (SCCS01VM), Teaching staff 2001 (SCTC01VK), Non-teaching staff 2001 (SCNT01VK), Classes as taught 2001 (SCCL01VK) and Permanent Exclusions 2001 (SCEX01VK). The field names and original field descriptions are taken from a data dictionary which was transferred with the dataset.

The dataset comprises the following table(s):

Table number NDAD reference Name Title
1 CRDA/13/DS/5/2001/1 SCSC01VQ All schools 2001
2 CRDA/13/DS/5/2001/2 SCPU01VK Pupils 2001
3 CRDA/13/DS/5/2001/3 SCCS01VM Courses of study 2001
4 CRDA/13/DS/5/2001/4 SCTC01VK Teaching staff 2001
5 CRDA/13/DS/5/2001/5 SCNT01VK Non-teaching staff 2001
6 CRDA/13/DS/5/2001/6 SCCL01VK Classes as taught 2001
7 CRDA/13/DS/5/2001/7 SCEX01VK Permanent Exclusions 2001
How data was originally captured and validated
Constraints on the reliability of the data It appears that not all the data sought on the survey forms have been entered into the dataset. NDAD has noted some of these missing data where possible, but users should be aware there is not always a direct correspondence between the questions on the forms and the fields in the dataset.
Top of pagetop of page

Validation

Content validation

The datasets were transferred with a data dictionary which included original field descriptions. Unlike some tables in this series, the field descriptions for tables in this dataset showed no signs of truncation. Some fields contained abbreviations: explanatory notes have been added by NDAD, using information from other Schools' Census datasets and documentation.

In the table Teaching staff (SCTC01VK) a number of fields have records which are not valid choices. Field TCHRTYPE_1 has 18,342, TCHRTYPE_2 has 71,523 records, TCHRTYPE_3 has 66,615 records and field TCHRTYPE_4 has 69,835 records. The explanation for this is that the codes and values for teacher types have been split (somewhat arbitrarily) between these four fields. When queried, it becomes clear that all four fields in fact contain the same data, whether expressed in code or in text. This small anomaly accounts for the large number of invalid choices.

In the table Non-teaching staff (SCNT01VK) the field ESTAB contains 120,538 records which are not a valid choice. The original data dictionary has inserted the codes for the field LEA under the field ESTAB, which explains the large number of invalid choices.

In the Classes as taught table (SCCL01VK), there are 138,849 records where the field CLASIZE2 is not a valid choice. This field holds the actual class size which is also held in the field PUPILS. The codes and values in the data dictionary only coded for classes from size 26 to 40, which explains the large number of invalid choices. For an explanation of the fields clasnum1 to clasnum6, see Scope and content.

Transformation validation

Some simple statistical functions (mean, counts) were performed on the original data files using QStat, and the results were compared with the newly created CSV files. No differences were found.

In addition, a small number of basic statistics (for example the total number of schools and pupils) were compared with the figures published in Statistics of Education: Schools in England 2001. London, The Stationery Office 2001.

Top of pagetop of page

Links to related datasets

Related datasets
NDAD reference Title (link leads to Dataset Catalogue)
CRDA/13/DS/5/1995 All schools 1995
CRDA/13/DS/5/1996 All schools 1996
CRDA/13/DS/5/1997 All schools 1997
CRDA/13/DS/5/1998 All schools 1998
CRDA/13/DS/5/1999 All schools 1999
CRDA/13/DS/5/2000 All schools 2000

Top of pagetop of page

Notes

 

1. The department have indicated this was an interim step towards generating a reliable class identifier. In subsequent Schools' Censuses, the schools themselves provide 'class name' data, thus overcoming this problem. Source: Email to NDAD from the Department, 5th October 2007.

Top of pagetop of page

Last updated 2007-10-26 17:49:36

 
 

NDAD v3.0