M-STEP Spring 2015 Student Data File Format

M-STEP Spring 2015 Student Data File Format
The downloaded file containing Student Test Scores is a Comma Delimited File (CSV).
Please note: fields containing “Reporting Level” information are referring to Claims for ELA/Math and
Disciplines for Science/Social Studies.
C
o
l
u
m
n
Field
Descriptor
Field Type
(length)
A
TestCycleID
text(20)
B
C
D
E
ISDCode
DistrictCode
SchoolCode
FeederSchoolCode
F
G
H
I
J
Grade
LastName
FirstName
MiddleInitial
Gender
K
Ethnicity
L
M
UIC
StudentNumber
N
O
BirthDate
Barcode
P
ED
Q
SE
R
LEP
M-STEP test period and Fiscal
Year
ISD Code Number
School District Code Number
School Code Number
Prior school number that
student attended
Student Grade
Student Last Name
Student First Name
Student Middle Initial
Student’s Gender; M for Male
and F for Female
Student’s ethnic code:
0=Native Hawaiian or Other
Pacific
Islander
1=American Indian or Alaska
Native
3=Black or African American
4=Hispanic or Latino
5=White
6=Two or more Races
9=Asian
Student UIC
Student Number from Local
School District
Student’s Date of Birth
Student’s BAA Bar Code
Number
Economically Disadvantaged:
1 – Yes
0 – No
Special Education:
1 - Yes
0 - No
Limited English Proficiency:
1 – Yes
0 - No
varchar(5)
varchar(5)
varchar(5)
varchar(5)
Format
99999
99999
99999
99999
varchar(2)
varchar(25)
varchar(25)
char(1)
char(1)
int(1)
9
char(10)
varchar(20)
datetime(8)
varchar(10)
varchar(1)
varchar(1)
varchar(1)
mm/dd/yyyy
S
MS
T
Homeless
U
HomeSchooled
V
ContentArea
W
Online
X
Valid
Y
OutOfLevel
Z
Attemptedness
AA
ProhibitedBehavior
AB
Misadministration
AC
NonstandardAccommodation
AD
InvalidReasonCode
AE
StandardAccommodation
AF
ReportingCode
AG
AH
AI
ResearchCode1
ResearchCode2
FormFixed
Migrant Status:
1 – Yes
0 - No
Homeless Student:
1 – Yes
0 - No
Home Schooled:
1 – Yes
0 – No
Note: If a student is home
schooled in any subject then a
student is considered home
schooled.
Content Area:
MA - Math
SC - Science
SS - Social Studies
EL - ELA
Online:
1 – Yes
0 - No
Valid:
1 – Yes
0 - No
Student was tested out of level:
1 – Yes
0 - No
Attempted:
1-Yes
0 - No
Prohibited Behavior:
1 – Yes
0 - No
Assessment Misadministration:
1 – Yes
0 - No
Nonstandard Accommodation
Used
1 – Yes
0 - No
1- Not found in MSDS
5- Multiple Answer Documents
Returned.
6 - Late Return
7 - Misadministration
8 - Did not meet attemptedness
Standard Accommodation
Used:
1 – Yes
0 - No
Class/Group code if provided
by school
Research Use Code 1
Research Use Code 2
Fixed Test Form
varchar(1)
varchar(1)
varchar(1)
varchar(2)
varchar(1)
varchar(1)
varchar(1)
varchar(1)
varchar(1)
varchar(1)
varchar(1)
varchar(1)
varchar(1)
varchar(4)
varchar(2)
varchar(2)
varchar(4)
99
99
AJ
AK
AL
AM
FormPTask
SS
SSSE
PL
AN
AO
AP
SGP
FixedFormPts
PTPts
AQ
AR
AS
AT
TotalPts
ReportingLevel1Code
ReportingLevel1Description
ReportingLevel1SS
AU
ReportingLevel1SSSE
AV
ReportingLevel1PerfIndicator
AW
ReportingLevel1Pts
AX
ReportingLevel1PtsPossible
AY
ReportingLevel1PctCorrect
AZ
BA
BB
ReportingLevel2Code
ReportingLevel2Description
ReportingLevel2SS
BC
ReportingLevel2SSSE
BD
ReportingLevel2PerfIndicator
Performance Task Form
Scale Score
Scale Score Standard Error
Performance Level:
4 – Advanced Proficient
3 – Proficient
2 – Partially Proficient
1 – Not Proficient
Student Growth Percentile
Fixed Form Raw-Score Points
Performance Task Raw-Score
Points
Note: For grade 11, the
Performance Task was
optional and these points are
not included in the Total Points
or Scale Score. NA for Science
and Social Studies
FixedFormPts+PTPts
Reporting Level 1 Code
Reporting Level 1 Description
Reporting Level 1 Scale Score
Note: NA for Science and
Social Studies
Reporting Level 1 Scale Score
Standard Error
Note: NA for Science and
Social Studies
Reporting Level 1 Performance
Indicator:
1 – Near/At or Above
Proficiency
0 – Below Proficiency
Note: NA for Science and
Social Studies
Reporting Level 1 Raw-Score
Points
Reporting Level1 Points
Possible
Reporting Level 1 Percent
Correct
Reporting Level 2 Code
Reporting Level 2 Description
Reporting Level 2 Scale Score
Note: NA for Science and
Social Studies
Reporting Level 2 Scale Score
Standard Error
Note: NA for Science and
Social Studies
Reporting Level 2 Performance
Indicator:
1 – Near/At or Above
Proficiency
0 – Below Proficiency
varchar(4)
int(4)
int(3)
varchar(1)
9999
999
int(2)
int(3)
int(3)
99
999
999
int(3)
varchar(10)
varchar(60)
int(4)
999
int(3)
9999
999
varchar(1)
int(2)
99
int(2)
99
decimal(3,1)
999.9
varchar(10)
varchar(60)
int(4)
9999
int(3)
varchar(1)
999
BE
ReportingLevel2Pts
BF
ReportingLevel2PtsPoss
BG
ReportingLevel2PctCorrect
BH
BI
BJ
ReportingLevel3Code
ReportingLevel3Description
ReportingLevel3SS
BK
ReportingLevel3SSSE
BL
ReportingLevel3PerfIndicator
BM
ReportingLevel3Pts
BN
ReportingLevel3PtsPoss
BO
ReportingLevel3PctCorrect
BP
BQ
BR
ReportingLevel4Code
ReportingLevel4Description
ReportingLevel4SS
BS
ReportingLevel4SSSE
BT
ReportingLevel4PerfIndicator
BU
ReportingLevel4Pts
BV
ReportingLevel4PtsPoss
BW
Reporting Level4PctCorrect
BX
BY
BZ
ReportingLevel5Code
ReportingLevel5Description
ReportingLevel5SS
Note: NA for Science and
Social Studies
Reporting Level 2 Raw-Score
Points
Reporting Level 2 Points
Possible
Reporting Level 2 Percent
Correct
Reporting Level 3 Code
Reporting Level 3 Description
Reporting Level 3 Scale Score
Note: NA for Science and
Social Studies
Reporting Level 3 Scale Score
Standard Error
Note: NA for Science and
Social Studies
Reporting Level 3 Performance
Indicator:
1 – Near/At or Above
Proficiency
0 – Below Proficiency
Note: NA for Science and
Social Studies
Reporting Level 3 Raw-Score
Points
Reporting Level 3 Points
Possible
Reporting Level 3 Percent
Correct
Reporting Level 4 Code
Reporting Level 4 Description
Reporting Level 4 Scale Score
Note: NA for Science and
Social Studies
Reporting Level 4 Scale Score
Standard Error
Note: NA for Science and
Social Studies
Reporting Level 4 Performance
Indicator:
1 – Near/At or Above
Proficiency
0 – Below Proficiency
Note: NA for Science and
Social Studies
Reporting Level 4 Raw-Score
Points
Reporting Level 4 Points
Possible
Reporting Level 4 Percent
Correct
Reporting Level 5 Code
Reporting Level 5 Description
Reporting Level 5 Scale Score
int(2)
99
int(2)
99
decimal(3,1)
999.9
varchar(10)
varchar(60)
int(4)
9999
int(3)
999
varchar(2)
int(2)
99
int(2)
99
decimal(3,1)
999.9
varchar(10)
varchar(60)
int(4)
9999
int(3)
999
varchar(2)
int(2)
99
int(2)
99
decimal(3,1)
999.9
varchar(10)
varchar(60)
int(4)
9999
CA
ReportingLevel5SSSE
CB
ReportingLevel5PerfIndicator
CC
ReportingLevel5Pts
CD
ReportingLevel5PtsPoss
CE
Reporting Level5PctCorrect
CF
CG
CH
ReportingLevel6Code
ReportingLevel6Description
ReportingLevel6SS
CI
ReportingLevel6SSSE
CJ
ReportingLevel6PerfIndicator
CK
ReportingLevel6Pts
CL
ReportingLevel6PtsPoss
CM
ReportingLevel6PctCorrect
CN
CO
CP
ReportingLevel7Code
ReportingLevel7Description
ReportingLevel7SS
CQ
ReportingLevel7SSSE
CR
ReportingLevel7PerfIndicator
Note: NA for Science and
Social Studies
Reporting Level 5 Scale Score
Standard Error
Note: NA for Science and
Social Studies
Reporting Level 5 Performance
Indicator:
1 – Near/At or Above
Proficiency
0 – Below Proficiency
Note: NA for Science and
Social Studies
Reporting Level 5 Raw-Score
Points
Reporting Level 5 Points
Possible
Reporting Level 5 Percent
Correct
Reporting Level 6 Code
Reporting Level 6 Description
Reporting Level 6 Scale Score
Note: NA for Science and
Social Studies
Reporting Level 6 Scale Score
Standard Error
Note: NA for Science and
Social Studies
Reporting Level 6 Performance
Indicator:
1 – Near/At or Above
Proficiency
0 – Below Proficiency
Note: NA for Science and
Social Studies
Reporting Level 6 Raw-Score
Points
Reporting Level 6 Points
Possible
Reporting Level 6 Percent
Correct
Reporting Level 7 Code
Reporting Level 7 Description
Reporting Level 7 Scale Score
Note: NA for Science and
Social Studies
Reporting Level 7 Scale Score
Standard Error
Note: NA for Science and
Social Studies
Reporting Level 7 Performance
Indicator:
1 – Near/At or Above
Proficiency
int(3)
99
varchar(1)
int(2)
int(2)
decimal(3,1)
999.9
varchar(10)
varchar(60)
int(4)
9999
int(3)
99
varchar(1)
int(2)
99
int(2)
99
decimal(3,1)
varchar(10)
varchar(60)
int(4)
int(3)
varchar(1)
999.9
CS
ReportingLevel7Pts
CT
ReportingLevel7PtsPoss
CU
Reporting7PctCorrect
CV
CW
CX
CY
CZ
EssayTypeCode
EssayTypeDescription
EssayRubric1Code
EssayRubric1Name
EssayRubric1Pts
DA
DB
DC
DD
EssayRubric1PtsPoss
EssayRubric2Code
EssayRubric2Name
EssayRubric2Pts
DE
DF
DG
DH
EssayRubric2PtsPoss
EssayRubric3Code
EssayRubric3Name
EssayRubric3Pts
DI
DJ
EssayRubric3PtsPoss
EssayTotalPts
DK
EssayTotalPtsPoss
0 – Below Proficiency
Note: NA for Science and
Social Studies
Reporting Level 7 Raw-Score
Points
Reporting Level 7 Points
Possible
Reporting Level 7 Percent
Correct
Essay Type Code
Essay Type Description
Essay Rubric 1 Code
Essay Rubric 1 Name
Essay Rubric 1 Raw-Score
Points
Condition Codes:
B – Blank
I – Insufficient
L – Nonscorable Language
T – Off Topic
M – Off Purpose
Essay Rubric 1 Points Possible
Essay Rubric 2 Code
Essay Rubric 2 Name
Essay Rubric 2 Raw-Score
Points
Condition Codes:
B – Blank
I – Insufficient
L – Nonscorable Language
T – Off Topic
M – Off Purpose
Essay Rubric 2 Points Possible
Essay Rubric 3 Code
Essay Rubric 3 Name
Essay Rubric 3 Raw-Score
Points
Condition Codes:
B – Blank
I – Insufficient
L – Nonscorable Language
T – Off Topic
M – Off Purpose
Essay Rubric 3 Points Possible
Essay Total Points
Note: Evidence, purpose, and
conventions are the scoring
dimensions for the writing
essay. Scores for evidence and
purpose dimensions will be
averaged, and the average will
be rounded up
Essay Total Points Possible
int(2)
99
int(2)
99
decimal(3,1)
varchar(10)
varchar(60)
varchar(10)
varchar(60)
varchar(1)
int(2)
varchar(10)
varchar(60)
varchar(1)
int(2)
varchar(10)
varchar(60)
varchar(1)
int(2)
int(2)
int(2)
999.9
DL
CreatedDated
Student Data File Creation
Date
Datetime(16)
mm/dd/yy
hh:mm