Data Layout for the 2006
Student Level Accountability Information File
The file for which this data layout was prepared contains 170 different variables that were required to fully implement the 2006 Achievement, Growth, and AYP models. The models are complex and rely on data extracted from MSIS, student level test data files received from testing vendors (CTB and Harcourt), and other data sources (e.g., Alternate Assessment and ELL/LEP scan forms and the MAAECF application developed by MIS). To understand the accountability models and the way that data values in the Student Level Accountability Information File (SLAIF) are used in the models, please see the documents posted on the 2006 Accountability Information Center web page in the Mississippi Assessment and Accountability Reporting System (MAARS). Select "Guidance" from the MAARS Main Menu.
http://ORSAP.mde.k12.ms.us:8080/MAARS
A student appears in the file if
(1) he/she was included in any of your district's monthly data transmissions to MSIS
(end of Month 1 through end of Month 9) AND
(2) there were no later indicator records for that month in MSIS showing a different
district code (ORS extracts the latest indicator record for each month) AND
(3) the student was enrolled in grades 3 through 12 during 2005/2006 OR
was enrolled in grade 56 or 58 and had a peer grade (based on age as of
September 1, 2005) between 3 and 8 OR
was enrolled in grade 78 and had a peer grade between 3 and 8.
Of 524,023 students in the cumulative 2005/2006 enrollment, 391,358 met the criteria and appear in one or more of the 152 district SLAIF spreadsheets.
With very few exceptions (e.g., a student with MCT test data, but an incorrectly coded grade in MSIS), the above students were those who may have been included for calculating AYP testing participation rates, AYP proficiency indexes, and BAI/HAI values for the Achievement model. You will need to use the values in the student records to determine if and how each student counted within the accountability models run for your district and schools.
For 2006, 17 variables were added (DISPL, REMRLA, REMMTH, MAAECF_LA, MAAECF_MA, XG3 to XG8, and YG3 to YG8) and 2 were deleted (RAA, MAA).
Office of Research and Statistics
Mississippi Department of Education
July 31, 2006
Note: The most current version of this file layout can be accessed from the
2006 Accountability Information Center web page (see web address above).
7
Student Level Accountability Information File -- 2006 /Pos / Field Name / Description /
1 / MSIS_ID / Student's MSIS ID
2 / LAST NAME / From Month 8 (or other month if no Month 8)
3 / FIRST NAME / From Month 8 (or other month if no Month 8)
4 / MI / From Month 8 (or other month if no Month 8) Set to blank if not A-Z.
Begin Demographic Variables
5 / SEX / Sex from Month 8 (or other month if no Month 8)
6 / DOB / Date of birth from month 8 (or other month if no Month 8) 4-digit Year in 2005.
NA / DIST1-DIST9 / These variables were deleted – use 1st 4 digits in DISTSCH1-DISTSCH9.
7 / DISTSCH1 / School code from the end-of-month 1 (September) extract
8 / DISTSCH2 / Same – Month 2
9 / DISTSCH3 / Same – Month 3
10 / DISTSCH4 / Same – Month 4
11 / DISTSCH5 / Same – Month 5
12 / DISTSCH6 / Same – Month 6
13 / DISTSCH7 / Same – Month 7 (secondary location for determining school level FAY)
14 / DISTSCH8 / Same – Month 8 (primary location for determining school level FAY)
15 / DISTSCH9 / Same – Month 9
16 / RES_DIST / Resident district for SPED receiving services outside school attendance zone.
May be where student received services or the district placing the student.
17 / RES_SCH / Resident school for SPED receiving services outside school attendance zone.
Will be '001' for out of district placements.
18 New / DISPL / Displaced student "proxy" flag. Based on a student enrollment date later than August 26 during "Month 1" (August/September) of SY2005/2006.
This flag was used for implementing special flexibility allowed by the U.S. Department of Education for 2006 only. It does not represent an accurate indication of every student's displaced status. Additional information concerning displaced students in the accountability models can be downloaded from the 2006 Accountability Information Center in MAARS.
"Y" indicates that the student was considered displaced.
"N" indicates that the student was not considered displaced.
If a displaced student was in the grades assessed and was enrolled during the testing dates, he/she was included in a special "displaced students" subgroup for calculating 2005/2006 AYP testing participation rates. Such students were not included in any other subgroups (not even the "all students" group) for calculating AYP testing participation rates.
None of the displaced students were considered to be "full academic year" students. Their SAMEDIST and SAMESCHL values were forced to '9999' or '9999999'. Therefore, none of the displaced students' test scores were included in the 2006 Achievement, Growth, or AYP models.
One of the USDE requirements is that displaced students scoring below proficient on statewide assessments receive remediation in 2006/2007. To facilitate the identification of those students, two variables were added at the end of the data record. See positions #169 and 170 (REMRLA, REMMTH).
19 / SAMEDIST / District where student satisfied Full Academic Year (FAY), otherwise '9999'
20 / SAMESCHL / School where student satisfied FAY, otherwise '9999999'
21 / SAMEDISF / Same district in Months 1-3 (used for 4X4 students taking semester courses)
22 / SAMEDISS / Same district in Months 5-8 (used for 4X4 students taking semester courses)
23 / SAMESCHF / Same school in Months 1-3 (used for 4X4 students taking semester courses)
24 / SAMESCHS / Same school in Months 5-8 (used for 4X4 students taking semester courses)
25 / GRD1 / Grade code from end of Month 1 (includes 56, 58, 78, etc.)
26 / GRD2 / Same – Month 2
27 / GRD3 / Same – Month 3
28 / GRD4 / Same – Month 4
29 / GRD5 / Same – Month 5
30 / GRD6 / Same – Month 6
31 / GRD7 / Same – Month 7
32 / GRD8 / Same – Month 8
33 / GRD9 / Same – Month 9
34 / PGRD / Peer Grade: Same as MSIS unless 56/58/78 when based on age on 9/1/05
35 / ED8 / Economically Disadvantaged: Y/N based on lunch flag in MSIS at end of Mo. 8
36 / RACE1 / Race code from end of Month 1
37 / RACE2 / Same – Month 2
38 / RACE3 / Same – Month 3
39 / RACE4 / Same – Month 4
40 / RACE5 / Same – Month 5
41 / RACE6 / Same – Month 6
42 / RACE7 / Same – Month 7
43 / RACE8 / Same – Month 8 (used to classify students into NCLB race/ethnicity subgroup)
44 / RACE9 / Same – Month 9
45 / SPED1 / SPED code from end of Mo. 1 (this is NOT the IEP code that was used in 2003)
46 / SPED2 / Same – Month 2
47 / SPED3 / Same – Month 3
48 / SPED4 / Same – Month 4
49 / SPED5 / Same – Month 5
50 / SPED6 / Same – Month 6
51 / SPED7 / Same – Month 7
52 / SPED8 / Same – Month 8 (used to classify students into SWD/DO/IEP NCLB subgroup).
53 / SPED9 / Same – Month 9
54 / SCD / Significant Cognitive Disability flag from MSIS at the end of the year: Y or blank
55 / LEP / Contains a Y if an ELL/LEP scan form was submitted during 2005/2006
56 / LEPYR / Years of Service grid from ELL/LEP scan form (0 & 1 signify "Year 1 LEP")
57 / LEPMON / ELL/LEP monitored # years (only if value is 1 or 2 and LEPYR is blank)
NA / KEEPLEP / This variable was deleted for 2005 – too few to justify inclusion.
58 / MIGR8 / Migrant code from end of Month 8 (classifies student as MIGR for NCLB)
Begin Test Eligibility and Participation Information
59 / ELIGRLM / 1 if MSIS grade (or peer grade for 56/58/78 students) is between 03 and 08
60 / ELIGE / 1 if student took English II in 2004/2005, was not repeating the course, and was enrolled in the same school during the fall & spring SATP administrations.
61 / ELIGA / 1 if student took Algebra I, was a 10th grader, was not repeating the course, and was in the same school during the fall & spring SATP administrations.
62 / ELIGRNO / 1 signifies that student is to be forced to non-eligible for RLA participation
63 / ELIGRLA / Y means that student counted in the RLA participation rate denominator
64 / ELIGMNO / 1 signifies that student is to be forced to non-eligible for MTH participation
65 / ELIGMTH / Y means that student counted in the MTH participation rate denominator
66 / TESTSCHL / For any student with ELIGRLM=1 (must have MCT -- on-grade or instructional level – or alternate assessment data in reading/language and mathematics), a school code is in this field if the student was enrolled in that school May 2 through 12, 2006. For students with ELIGE=1 or ELIGA=1, a school code is in this field if there is not already a school code based on ELIGRLM. If '9999999', the student doesn't count in any school's test participation rate. For district participation rates, the district code is the first four characters of TESTSCHL.
67 / TSTRLA / Y/N indicates whether reading/language data were found for the student in the ORS final matched test data files. If ELIGRLA=Y, student counts in the numerator for the RLA participation rate.
Note: Beginning in 2006, non-SCD students had to take an "on-grade" assessment or be considered "not tested." In such cases, TSTRLA will be set to "N" and the corresponding test flag in the MCT instructional level or old Alternate Assessment string (see below) will be set to "F" (for Forced).
68 / TSTMTH / Y/N indicates whether mathematics data were found for the student in the ORS final matched test data files. If ELIGMTH=Y, student counts in the numerator for the MTH participation rate. See note for TSTRLA; also applies to TSTMTH.
69 / MCT_R_GL / This is a 6-character string. Each position represents an MCT Reading test level for "on-grade" testing. Position 1 = Level 13 (grade 3), Position 2 = Level 14, etc. 1 means we found data on that test level for the student, 0 means no data.
70 / MCT_L_GL / Same, but MCT "on-grade" Language test at Levels 13-18.
71 / MCT_M_GL / Same, but MCT "on-grade" Mathematics test at Levels 13-18.
72 / MCT_R_IL / This is a 7-character string. Each position represents an MCT "instructional level" Reading test. Position 1 = Level 12 (grade 2), Position 2 = Level 13, etc. 1 means we found data on that test level for the student, 0 means no data.
For a non-SCD student, "F" indicates that the student was forced to "not tested."
73 / MCT_L_IL / Same, but MCT "instructional level" Language test at Levels 12-18.
74 / MCT_M_IL / Same, but MCT "instructional level" Mathematics test at Levels 12-18.
75 / TSTRALT / 1 indicates that the student had an alternate assessment with an RLA score.
Data were scanned from "blue forms" and separate RLA and MTH scores were computed using the RLA and MTH bubbles on the forms. 0 means no RLA.
For a non-SCD student, "F" indicates that the student was forced to "not tested."
76 / TSTMALT / 1 indicates that the student had an alternate assessment with a MTH score.
See explanation above for RLA. 0 means no MTH data.
77 / TSTXALT / 1 indicates that the student had an alternate assessment. If this flag is 1, the SCD was considered tested (for both TSTRLA & TSTMTH).
For a non-SCD student, "F" indicates that the student was forced to "not tested."
78 New / MAAECF_LA / 1 indicates a student coded SCD at the time of testing who has a language arts score (proficiency level) on the Mississippi Alternate Assessment of the Extended Curriculum Frameworks (MAAECF).
79 New / MAAECF_MA / 1 indicates a student coded SCD at the time of testing who has a mathematics score (proficiency level) on the Mississippi Alternate Assessment of the Extended Curriculum Frameworks (MAAECF).
80 / TSTENGL / 1 indicates that the student has English II data from 2005/2006. Students repeating the course are not expected to be tested (see field ELIGE).
81 / TSTAL10 / 1 indicates that the student has Algebra I data from 2005/2006. Students repeating the course are not expected to be tested (see field ELIGA).
Begin Special Conditions (Manual Adjustment) Process
Note: This process also includes KEEPLEP (deleted 2005), ELIGRNO, and ELIGMNO (listed earlier).
82 / IRDG / 1 indicates MCT reading score forced to invalid (Special Conditions Process)
83 / ILNG / 1 indicates MCT language score forced to invalid
84 / IMTH / 1 indicates MCT math score forced to invalid
Begin Test Data for MCT "On-Grade" Testing
85 / RG3 / MCT Grade 3 Reading Proficiency Level (1-4) -- used for BAI/HAI and AYP
86 / LG3 / MCT Grade 3 Language Proficiency Level (1-4) -- used for BAI/HAI and AYP
87 / MG3 / MCT Grade 3 Math Proficiency Level (1-4) -- used for BAI/HAI and AYP
88 / RG4 / MCT Grade 4 Reading Proficiency Level (1-4) -- used for BAI/HAI and AYP
89 / LG4 / MCT Grade 4 Language Proficiency Level (1-4) -- used for BAI/HAI and AYP
90 / MG4 / MCT Grade 4 Math Proficiency Level (1-4) -- used for BAI/HAI and AYP
91 / RG5 / MCT Grade 5 Reading Proficiency Level (1-4) -- used for BAI/HAI and AYP
92 / LG5 / MCT Grade 5 Language Proficiency Level (1-4) -- used for BAI/HAI and AYP
93 / MG5 / MCT Grade 5 Math Proficiency Level (1-4) -- used for BAI/HAI and AYP
94 / RG6 / MCT Grade 6 Reading Proficiency Level (1-4) -- used for BAI/HAI and AYP
95 / LG6 / MCT Grade 6 Language Proficiency Level (1-4) -- used for BAI/HAI and AYP
96 / MG6 / MCT Grade 6 Math Proficiency Level (1-4) -- used for BAI/HAI and AYP