District Staff Records File Preparation (Spring 2010 and 2011)

RECORD STRUCTURE FOR TALENT TRANSFER INITIATIVE STUDY

File Layout

An ASCII text file is the preferred method for submitting the data required. Below is a detailed record structure for you to follow when submitting the required information in that format. We understand that it may be easier to provide data in some other format such as an ACCESS database or an Excel spreadsheet. If you do not use ASCII, please note the Database Column Names in column three on the attached table, which are provided to standardize the field headings. It would be most helpful if you would change any header names you are using to match those in the Database Column Name before submitting the data. This will help the Mathematica team to convert the information you provide into a usable format. The record structure includes the following headings:

• Field No./Type refers to the variable number and the data type requested. The different data types include numeric (Num) and alpha-numeric (A/N).

• Field Name is the general heading for each variable requested.

• Database Column Name is the specific name of the variable to be used for coding purposes.

• Valid Field Content provides the format for acceptable responses and coding for alpha-numeric responses.

Types of Data

The record structure below includes four major areas for which we would like data on these participants:

• Student Characteristics, and Services includes basic background characteristics of each student, such as gender, date of birth, race/ethnicity, and the student’s 2007-2008, 2006-2007, and 2005-2006 LEP or ELL status and eligibility for free or reduced-price lunch or special education services.

• Test Sores includes information about the student’s 2007-2008, 2006-2007, and 2005-2006 standardized test scores.

• Enrollment Data includes the student’s school enrollment status for 2007-2008, 2006-2007, and 2005-2006 school years.

Student Characteristics:

Field No./ Type	Field Name	Database Column Name	Valid Field Content
1 Num	Student ID	Student	Specified by District
2 Num	District ID	District	Specified by District
6 Num	Student’s Sex	Sex	1 = Male 2 = Female -5= Not available
7 Num	Student’s Date of Birth	DOB	Format is MMDDCCYY MM = 01 – 12 DD = 01 – 31 CC = 19 YY = 00 – 99 00000000 = Unknown
8 Num	Student’s Ethnicity	Ethnicity	1 = Hispanic or Latino(a) 0 = Not Hispanic or Latino(a) -5 = Not available
9 Num	Student’s Race	Race	1 = White 2 = Black or African American 3 = Asian 4 = Native Hawaiian or other Pacific Islander 5 = American Indian/Alaska Native -5 = Not available

2007-2008 Student Services
10 Num	2007 School ID	2007_SchoolID	Specified by District
11 Num	2007 Teacher ID	2007_TeacherID	Specified by District
13 Num	2007 Course Identifier	2007_Course	1 = Self-contained 2 = Math 3 = Reading/Language Arts 4 = Other
12 Num	2007 Student’s Grade	2007_Grade	1-12 -5 = Not available
14 Num	2007 Eligibility for free or reduced-price lunch program	2007_FreeLnch	1 = Yes 2 = No -5= Not available
15 Num	2007 Limited English proficient (LEP) or English language learner (ELL) status	2007_Lep	1 = Yes 2 = No -5= Not available
16 Num	2007 Special education services (IEP or Services Agreement under Section 504)	2007_SpEd	1 = Student receives services under an IEP 2 = Student receives services under a Services Agreement 3 = Neither of the above -5= Not available
17 Num	2007 Disability type and/or severity	2007_Disability	1 = Specific learning disability 2 = Mental retardation 3 = Emotional disturbance 4 = Speech or language impairment 5 = Multiple disabilities 6 = Other health impairment 7 = Hearing impairment 8 = Orthopedic impairment 9 = Visual impairment 10 = Autism 11 = Deaf/Blind 12 = Traumatic brain injury -5 = Not available

2006-2007 Student Services
18 Num	2006 School ID	2006_SchoolID	Specified by District
19 Num	2006 Teacher ID	2006_TeacherID	Specified by District
21 Num	2006 Course Identifier	2006_Course	1 = Self-contained 2 = Math 3 = Reading/Language Arts 4 = Other
20 Num	2006 Student’s Grade	2006_Grade	1-12 -5 = Not available
22 Num	2006 Eligibility for free or reduced-price lunch program	2006_FreeLnch	1 = Yes 2 = No -5= Not available
23 Num	2006 Limited English proficient (LEP) or English language learner (ELL) status	2006_Lep	1 = Yes 2 = No -5= Not available
24 Num	2006 Special education services (IEP or Services Agreement under Section 504)	2006_SpEd	1 = Student receives services under an IEP 2 = Student receives services under a Services Agreement 3 = Neither of the above -5= Not available
25 Num	2006 Disability type and/or severity	2006_Disability	1 = Specific learning disability 2 = Mental retardation 3 = Emotional disturbance 4 = Speech or language impairment 5 = Multiple disabilities 6 = Other health impairment 7 = Hearing impairment 8 = Orthopedic impairment 9 = Visual impairment 10 = Autism 11 = Deaf/Blind 12 = Traumatic brain injury -5 = Not available

2005-2006 Student Services
26 Num	2005 School ID	2005_SchoolID	Specified by District
27 Num	2005 Teacher ID	2005_TeacherID	Specified by District
29 Num	2005 Course Identifier	2005_Course	1 = Self-contained 2 = Math 3 = Reading/Language Arts 4 = Other
28 Num	2005 Student’s Grade	2005_Grade	1-12 -5 = Not available
30 Num	2005 Eligibility for free or reduced-price lunch program	2005_FreeLnch	1 = Yes 2 = No -5= Not available
31 Num	2005 Limited English proficient (LEP) or English language learner (ELL) status	2005_Lep	1 = Yes 2 = No -5= Not available
32 Num	2005 Special education services (IEP or Services Agreement under Section 504)	2005_SpEd	1 = Student receives services under an IEP 2 = Student receives services under a Services Agreement 3 = Neither of the above -5= Not available
33 Num	2005 Disability type and/or severity	2005_Disability	1 = Specific learning disability 2 = Mental retardation 3 = Emotional disturbance 4 = Speech or language impairment 5 = Multiple disabilities 6 = Other health impairment 7 = Hearing impairment 8 = Orthopedic impairment 9 = Visual impairment 10 = Autism 11 = Deaf/Blind 12 = Traumatic brain injury -5 = Not available

2007-2008 Enrollment and Test Scores

34 Num	2007 October 1 Enrollment – School ID	2007_October_School ID	0-999 -5 = Not available -9 = Unknown
35 Num	2007 December 15 Enrollment – School ID	2007_December_SchoolID	0-999 -5 = Not available -9 = Unknown
36 Num	2008 Test Date Enrolment or May 15 – School ID	2008_May_SchoolID	0-999 -5 = Not available -9 = Unknown
37 Num	2008 Test Date	2008_Test_Date	Format is MMDDCCYY MM = 01 – 12 DD = 01 – 31 CC = 19 YY = 00 – 99
38 A/N	Test form information, such as “Stanford 9 Form S” or an off grade test indicator	Test_Form	Uppercase A to Z . (period) ’ (apostrophe) - (dash)
39 A/N	Description of Alternative Test(s), if applicable	Alt_Test	Uppercase A to Z . (period) ’ (apostrophe) - (dash)
40 Nu	2008 Test Scores	2008_Test_Scores	000 - 999 000 = None, did not participate in testing -9 = Unknown

2006-2007 Test Scores
41 Num	2006 October 1 Enrollment – School ID	2006_October_SchoolID	0-999 -5 = Not available -9 = Unknown
42 Num	2006 December 15 Enrollment – School ID	2006_December_SchoolID	0-999 -5 = Not available -9 = Unknown
43 Num	2007 Test Date Enrolment or May 15 – School ID	2007_May_SchoolID	0-999 -5 = Not available -9 = Unknown
44 Num	2007 Test Date	2007_Test_Date	Format is MMDDCCYY MM = 01 – 12 DD = 01 – 31 CC = 19 YY = 00 – 99
45 A/N	2007 Test form information, such as “Stanford 9 Form S” or an off grade test indicator	2007_Test_Form	Uppercase A to Z . (period) ’ (apostrophe) - (dash)
46 A/N	Description of Alternative Test(s), if applicable	Alt_Test	Uppercase A to Z . (period) ’ (apostrophe) - (dash)
47 Num	2007 Test Scores	2007_Test_Scores	000 - 999 000 = None, did not participate in testing -9= Unknown

2005-2006 Test Scores
48 Num	2005 October 1 Enrollment – School ID	2005_October_SchoolID	0-999 -5 = Not available -9 = Unknown
49 Num	2005 December 15 Enrollment – School ID	2005_December_SchoolID	0-999 -5 = Not available -9 = Unknown
50 Num	2006 Test Date Enrolment or May 15 – School ID	2006_May_SchoolID	0-999 -5 = Not available -9 = Unknown
51 Num	2006 Test Date	2006_Test_Date	Format is MMDDCCYY MM = 01 – 12 DD = 01 – 31 CC = 19 YY = 00 – 99
52 A/N	2006Test form information, such as “Stanford 9 Form S” or an off grade test indicator	2006_Test_Form	Uppercase A to Z . (period) ’ (apostrophe) - (dash)
53 A/N	Description of Alternative Test(s), if applicable	Alt_Test	Uppercase A to Z . (period) ’ (apostrophe) - (dash)
54 Num	2006 Test Scores	2006_Test_Scores	000 - 999 000 = None, did not participate in testing -9= Unknown

2004-2005 Test Scores
55 Num	2004 October 1 Enrollment – School ID	2004_October_SchoolID	0-999 -5 = Not available -9 = Unknown
56 Num	2004 December 15 Enrollment – School ID	2004_December_SchoolID	0-999 -5 = Not available -9 = Unknown
57 Num	2005 Test Date Enrolment or May 15 – School ID	2005_May_SchoolID	0-999 -5 = Not available -9 = Unknown
58 Num	2005 Test Date	2005_Test_Date	Format is MMDDCCYY MM = 01 – 12 DD = 01 – 31 CC = 19 YY = 00 – 99
59 A/N	2005Test form information, such as “Stanford 9 Form S” or an off grade test indicator	2005_Test_Form	Uppercase A to Z . (period) ’ (apostrophe) - (dash)
60 A/N	Description of Alternative Test(s), if applicable	Alt_Test	Uppercase A to Z . (period) ’ (apostrophe) - (dash)
61 Num	2005 Test Scores	2005_Test_Scores	000 - 999 000 = None, did not participate in testing -9= Unknown