National Data Sets

How are records matched to students in Illuminate?

AIMSweb Fall/Winter/Spring

• 1st: UniqueIdentifier (13) to State Student ID
• 2nd: UniqueIdentifier (13) to Local Student ID

AIMSweb Fall/Winter/Spring Including NPR

• 1st: UniqueIdentifier (14) to State Student ID
• 2nd: UniqueIdentifier (14) to Local Student ID

AIMSweb Fall/Winter/Spring Including NPR/ROI/SGP

• 1st: UniqueIdentifier (14) to State Student ID
• 2nd: UniqueIdentifier (14) to Local Student ID

AIMSWeb Progress Monitoring 2013-2014

• 1st: UniqueIdentifier (12) to State Student ID
• 2nd: UniqueIdentifier (12) to Local Student ID

Data Layout Missing For:

• AIMSweb 2.0 Fall/Winter/Spring 2014-2015

How are unique records identified?

AIMSweb Fall/Winter/Spring

• none (all imported records create duplicates)

AIMSweb Fall/Winter/Spring Including NPR

• none (all imported records create duplicates)

AIMSweb Fall/Winter/Spring Including NPR/ROI/SGP

• UniqueIdentifier (14)
• GOM (16) 
• SchoolYear (17)

AIMSWeb Progress Monitoring 2013-2014

• UniqueIdentifier (12)
• Measure (15)
• DateGiven (17) 

Data Layout Missing For:

• AIMSweb 2.0 Fall/Winter/Spring 2014-2015

How are records matched to students in Illuminate?

All current AP dataset (2012-2013, 2013-2014, 2014-2015) imports look to match:

• 1st: Student Identifier (242) to Local Student ID  
• 2nd: A unique combination of Student Last Name (2) to Last Name, Student First Name (3) to First Name, and Date of Birth (14) to Birth Date 

How are unique records identified?

2014-2015, 2013-2014, and 2012-2013: 

• "Assessment" Table: 
  • Admin Year (59)
  • Exam Code (60)
  • Exam Grade (61)
  • Irregularity Code 1 (62)
  • Irregularity Code 2 (63)
  • Class Section Code (64)
  • Student Identifier (242)
  • Student Last Name (2)
  • Student First Name (3)
  • Student Middle Initial (4)
  • Date of Birth (14)
• "Other" (non-assessment data) Table: 
  • Student Identifier (242)
  • Student Last Name (2)
  • Student First Name (3)
  • Student Middle Initial (4)
  • AP Number (1)

How are records matched to students in Illuminate?

2015-2016 and 2014-2015 (Form 7 Delimited):

• 1st: Secondary Student ID (position 415-434) to State Student ID
• 2nd: Student ID (position 404-414)  to Local Student ID 

2012-2013 through 2008-2009:

• 1st: Secondary Student ID (position 4057-4220) to State Student ID
• 2nd: Student ID (position 251-258) to Local Student ID 

2007-2008 through 2005-2006:

• 1st: Secondary Student ID (position 4201-4200) to State Student ID
• 2nd: Student ID (position 251-258) to Local Student ID

How are unique records identified?

2015-2016 and 2014-2015 (Form 7 Delimited):

• Date Tested (position 296-303)
• Student ID (position 404-414) 

2012-2013 through 2005-2006: 

• Date Tested (position 251-258) 
• Student ID (position 308-318)

Note: We do not have an import tool for 2013-2014 Cogat.

Built for the Common Core, i-Ready combines a valid and reliable growth measure and individualized instruction.  i-Ready includes instructional lessons and diagnostic tests for K-12 to drive Response to Intervention.  The Diagnostic assessment measures student competency in all areas of Reading and Mathematics and delivers personalized instructional materials for teachers and students. Curriculum Associates is the company who has developed this product and it's content. The product works on using data to inform and drive instruction in the classroom and makes predictions on the performance on Common Core state mandated assessment.  Due to this fact many users like to see the results of diagnostic side by side which their common core assessment data to make comparisons and inferences.

References

• i-Ready Product Info
• i-Ready Tour

Subjects

• Reading (Grades K-12)
• Mathematics (Grades K-12)

Administrations:

Diagnostic

i-Ready diagnostics tests can be taken any time and contain a diagnostic completion date for each occurrence.  There are multiple records for each student depending on how many diagnostics were taken.  These diagnostics are also adaptive which adjust the challenge of the questions as they are answered.  The diagnostic will state if the child is below, at, or above grade level.  To pull a unique record for a student you will need the student id and diagnostic completion date.  Records can also be grouped by academic year to display progress over the course of the year.

Instruction

i-Ready instruction records are unique per student id and academic year and contain the number of lessons taken and the result of those lessons.  Instruction is provided that is tailored to each individual needs based on their performance on the diagnostic exams.  Instructional lessons are also provided to teachers that support the content students are receiving.

Test Window

Each (beg / mid / end) testing window is configured by the individual district/school  so the testing window can vary.  This information is not included in the data extracted so we may need a way for our users to enter this information into Illuminate or provide it in a pre-built if specific window reporting is requested.

Placement Levels And Scale Scores and Other Measures

Diagnostic

In the Diagnostic portion of i-Ready "Overall Scale Scores" are provided for each diagnostic (Math/Reading) as well as a "Placement Level".  There are many placement levels and their cutoffs which are listed in this document.  

Instruction

In the instructional component of i-Ready the number of lessons passed and failed are reported as well as the pass rate and total time spent on each domain.

Domains

The domains above are available for both Math and Reading for the i-Ready.

Schema

All diagnostic results for students are stored in the following tables:national_assessments.iready_diagnostic_reading, national_assessments.iready_diagnostic_math

All instructional results for students are stored in the following tables: national_assessments.iready_instruction_reading, national_assessments.iready_instruction_math

Please refer to the Domains section for specific field names for the domains. As mentioned in the beginning of this article to get a unique test (diagnostic) record for a student you will need to select a combination of student_id and a diagnostic completion date (diagnostic_completiondate) for diagnostic records. The instructional data is aggregated by academic year.  If you want to get all diagnostic records for a student just search on student_id. If you want all records for an academic year (academic_year) than filter on that as well.

Website: www.nwea.org

Smarter Balanced Assessment and RIT Score Correlations - As you begin your instructional planning in anticipation of the 2016 Smarter Balanced Assessment Consortia (Smarter Balanced) summative assessments, your Measures of Academic Progress® (MAP®) data can be a huge help! We have resources now—and even more coming soon—that will help you: predict student performance on the next Smarter Balanced summative test set student growth goals between now and then track progress toward those goals with your fall, winter, and spring MAP administrations identify students who are at risk and adjust instructional strategies Northwest Evaluation Association™ (NWEA™) has been working since last year to give schools insight into how Smarter Balanced scores correspond to MAP performance—and how you can use that information to help your students.  Our complete linking study, in which we connect the scale of Smarter Balanced math and English language arts (ELA) tests with MAP math and reading assessments, will be released in December

How are records matched to students in Illuminate?

2014-2015, 2013-2014, and 2012-2013: 

• 1st: Student ID (9) to Local Student ID
• 2nd: Unique combination of Student Last Name (10) to Last Name, Student First Name (11) to First Name, and Student Date of Birth Month (19), Student Date of Birth Day (20) and Student Date of Birth Year (21) to Birth Date

How are unique records identified?

2014-2015, 2013-2014, and 2012-2013:

• Test Date (8)
• Student ID (9)
• Student Last Name (10)
• Student First Name (11)
• Student Date of Birth Month (19)
• Student Date of Birth Day (20)
• Student Date of Birth Year (21)

How are records matched to students in Illuminate?

SAT 2016-2017 & 2015-2016 (CSV and Fixed Width formats):

• 1st: Secondary School Student ID (column 26, position 234-263) to Local Student ID
• 2nd: Secondary School Student ID (column 26, position 234-263) to State Student ID
• 3rd: Unique combination of
  • Last or Surname (column 6, position 113147) to Last Name
  • First Name (column 7, position 148182) to First Name
  • Birth Date (column 23, position 203-212) to Birth Date

SAT 2014-2015 through 2005-2006:

• 1st:Unique combination of
  • Last Name (7-21)to Last Name
  • First Name (22-33) to First Name
  • Birth Date (36-41) to Birth Date
• 2nd: (NOTE: Added a column for SSID and a column for Local ID that  can populate for matching, as an option.)
  • Local ID can be added to the first 10 characters at the end of the file
  • SSID can be added to the next 10 characters after the 10 characters that are reserved for Local ID

How are unique records identified?

SAT 2015-2016 (CSV and Fixed Width formats): 

• "Core" "Other", "Reading", "Writing", and "Math" Tables:
  • Latest SAT: Assessment Date (column 44, position 659–668)
  • Last or Surname (column 6, position113–147)
  • First Name (column 7, position 148–182)
  • Birth Date (column 23, position 203-212)
  • Record Number (column 855, position 2573-2574)
  • Secondary School Student ID (column 26, position 234-263)
• "Subjects" Table:
  • Latest SAT Subject Assessment Date (column 452, position 1582–1591)
  • Latest Subject Test 1 Assessment Identifier (column 455, position 1595–1596)
  • Last or Surname (column 6, position113–147)
  • First Name (column 7, position 148–182)
  • Birth Date (column 23, position 203-212)
  • Record Number (column 855, position 2573-2574)
  • Secondary School Student ID (column 26, position 234-263)
• "Course Info" and "Activity and College" Tables:
  • Date of Report (column 857, position 2582–2591)
  • Last or Surname (column 6, position113–147)
  • First Name (column 7, position 148–182)
  • Birth Date (column 23, position 203-212)
  • Record Number (column 855, position 2573-2574)
  • Secondary School Student ID (column 26, position 234-263)

SAT (2011-2012) - (2014-2015): 

• "Core" Table: 
  • Test Date (140-147)
  • Last Name (7-21)
  • First Name (22-33)
  • Date of Birth (36-41)
  • Record Number (1160-1161), 
• "Other" Table:
  • Last Name (7-21)
  • First Name (22-33)
  • Date of Birth (36-41)
  • Date of Report (1163-1168)
  • Record Number (1160-1161)
• "Subjects" Table:
  • (Subject) Test Date (284–291)
  • Subj. Test Code 1 (295-296)
  • Last Name (7-21)
  • First Name (22-33)
  • Date of Birth (1163-1168)
  • Record Number (1160-1161)

SAT 2010-2011 - Prior Years Back to 2005-2006: 

• "Core" Table:
  • Test Date (140–143)
  • Last Name (7-21)
  • First Name (22-33)
  • Date of Birth (36-41)
  • Record Number (1112-1113)
• "Other" Table:
  • Last Name (7-21)
  • First Name (22-33)
  • Date of Birth (36-41)
  • Date of Report (1115–1120)
  • Record Number (1112-1113)
• "Subjects" Table:
  • (Subject) Test Date (260-263)
  • Subj. Test Code 1 (267–268)
  • Last Name (7-21)
  • First Name (22-33)
  • Date of Birth (36-41)
  • Record Number (1112-1113)

How are records matched to students in Illuminate?

• 1st: SIS_ID (3) to Local Student ID
• 2nd: SIS_ID (3) to State Student ID 

How are unique records identified?

• SIS_ID (3)
• LEXILE_MOD_DATE (12) 

How are records matched to students in Illuminate?

2013-2014 and 2012-2013 Fixed

• 1st: Unique combination of 
  • Student Name-Last (3-13) to Last Name
  • Student Name-First (14-22) to First Name
  • Date of Birth (53-60) to Birth Date
• 2nd: Student Number (33-42) to Local Student ID
• 3rd: Student Number (33-42) to State Student ID

2013-2014 and 2012-2013 CSV

• 1st: Unique combination of 
  • Student Name-Last (2) to Last Name
  • Student Name-First (3 to First Name
  • Date of Birth (8-11) to Birth Date
• 2nd: Student Number (6) to Local Student ID
• 3rd: Student Number (6) to State Student ID

How are unique records identified?

2013-2014 and 2012-2013 Fixed

• Student Number (33-42)
• Grade (150-151)
• Level (position 209-210) 
• Form (position 211-212)

2013-2014 and 2012-2013 CSV

• Student Number (6)
• Grade (27)
• Level (37) 
• Form (38)

How are records matched to students in Illuminate?

Early Literacy, Math, and Reading:

• 1st: StudentLocalID (1) to Local Student ID
• 2nd: StudentStateID (2) to State Student ID

Early Literacy, Math, and Reading Assessment Details:

• 1st: StudentID (1) to Local Student ID
• 2nd: StateStudentID (11) to State Student ID

Early Literacy, Math, and Reading SGP:

• 1st: StudentLocalID (12) to Local Student ID
• 2nd: StudentStateID (13) to State Student ID 


Accelerated Math:

• 1st: StudentID (1) to Local Student ID
• 2nd: StateStudentID (38) to State Student ID


Accelerated Reader RP Details:

• 1st: StudentID (1) to Local Student ID
• 2nd: StateStudentID (11) to State Student ID

How are unique records identified?

Early Literacy, Math, and Reading: 

• StudentLocalID (1)
• AssessmentDate (23)

Early Literacy, Math, and Reading Assessment Details: 

• StudentID (1)
• DateTaken (18)

Early Literacy, Math, and Reading SGP: 

• SGPWindowName (1)
• StudentLocalID (12)
• TeacherLocalID (18)

Accelerated Math:

• Description (12)
• BegDate (13)
• Student ID (1)
• Teacher ID (5)

Accelerated Reader RP Details:

• StudentID (1)
• DateTaken (18)