This section contains tests that are used throughout the United States to assess student progress and are developed by many different test vendors. These tests may be used to measure: RTI, College and Career Readiness, Graduation Requirements, English Language, Cogitative Ability, and Predictive Measures on high stakes tests.
ACT
How are records matched to students in Illuminate?
2014-2015 and 2013-2014:
- 1st: State Student ID (7) to State Student ID
- 2nd: Local ID (8) to Local Student ID
How are unique records identified?
2014-2015 and 2013-2014:
- State Student ID (7)
- Local ID (8)
How are records matched to students in Illuminate?
2014-2015 through 2010-2011:
- 1st: User Defined Field 3 (172) to State Student ID
- 2nd: Student ID Number (169) to Local Student ID
2012-2013 and 2013-2014:
- 1st: User Defined Field 3 (170) to State Student ID
- 2nd: Student ID Number (167) to Local Student ID
2010-2011 and 2011-2012:
- 1st: User Defined Field 3 (171) to State Student ID
- 2nd: Student ID Number (168) to Local Student ID
2009-2010:
- 1st: Student ID Number (168) to Local Student ID
2008-2009 and 2007-2008:
- 1st: Student ID Number (171) to Local Student ID
How are unique records identified?
2014-2015:
- Student ID Number (169)
- User Defined Field 3 (172)
- Process Number (1)
2012-2013 and 2013-2014:
- Student ID Number (167)
- User Defined Field 3 (170)
- Process Number (1)
2011-2012 and 2010-2011:
- Student ID Number (168)
- User Defined Field 3 (171)
- Process Number (1)
2009-2010:
- Student ID Number (168)
- Process Number (1)
2008-2009 and 2007-2008:
- Student ID Number (171)
- Process Number (1)
How are records matched to students in Illuminate?
All current ACT imports:
- 1st: Looks to match Student SSID (192-204 or 691-700, depending on length) to State Student ID
- 2nd: Looks to match Local ID Number (381-390) to Local Student ID.
- 3rd: unique combination of Student Last Name (3-27) to First Name, Student First Name (28-43) to Last Name, and Date of Birth (101-106) to Birth Date.
How are unique records identified?
2015-2016 (High School):
- Test Date (233-236)
- Student Last Name (3-27)
- Student First Name (28-43)
- Date of Birth (101-106)
- Local ID Number (381-390)
- Student SSID (192-204 or 691-700, depending on length).
2015-2016 (Colleges):
- Test Date (233-236)
- Student Last Name (3-27)
- Student First Name (28-43)
- Date of Birth (101-106)
- Local ID Number (381-390)
- Student SSID (192-204 or 691-700, depending on length).
2014-2015 (High School): Same as 2015-2016, above.
2014-2015 (Colleges): Same as 2015-2016, above, except that the Local ID Number column is position 381-388, rather than 381-390.
2013-2014, 2012-2013, and 2011-2012:
- Student Last Name (3-27)
- Student First Name (28-43)
- Date of Birth (101-106)
- Test Date (233-236)
- Local ID is (381-388)
- SSID is (691-700) only.
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
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.
Now you can! Visit Automate State Assessment Data to get started today.
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
All NWEA imports match on Student ID (2) to the Local Student ID only.
All NWEA
- Term Name (1)
- Student ID (2)
- Discipline (5)
- Growth Measure Y/N (6)
- Test Name (either 8 or 15)
You have the ability to download the file they used to import (save it as a .csv when you do this, it will automatically download as a .txt file if you do not) and open it in Excel (Data > Get External Data > Import Text File > choose your downloaded .csv).
Count the number of columns in the file that they used. If they number of columns isn't 128 (it might be something like 136), then they may have downloaded a version of this assessment data that we don't support.
Currently, we only support the Assessment Results version of this file, which is 128 columns. We do not support the Combined Assessment Results version (which is 136 columns).
You can see the two different versions as sheets in the Excel layout we have for this dataset here.
Now you can! Visit Automate State Assessment Data to get started today.
PSAT
Summary
The PSAT 8/9 is a test that will helps teachers figure out what students need to work on most so that they're ready for college when they graduate from high school. It tests the same skills and knowledge as the SAT, PSAT/NMSQT, and PSAT 10- in a way that makes sense for the grade level. This assessment replaces the ReadiStep assessment that was administered until the 2014-2015 academic year.
References
https://collegereadiness.collegeboard.org/psat-8-9
How are records matched to students in Illuminate?
2015-2016 - Current: imports look to match
- 1st: SECONDARY_ID (26 CSV, 234-263 Fixed) to State Student ID
- 2nd: SECONDARY_ID (26 CSV, 234-263 Fixed) to Local Student ID
- 3rd: A unique combination of NAME_LAST (6 CSV, 113-147 Fixed) to Last Name, NAME_FIRST (7 CSV, 148-182 Fixed) to First Name, and BIRTH_DATE (23 CSV, 203-212 Fixed) to Birth Date
How are unique records identified?
2015-2016 - Current:
-
All Tables CSV:
- NAME_LAST (6)
- NAME_FIRST (7)
- BIRTH_DATE (23)
- SECONDARY_ID (26)
- LATEST_PSAT_DATE (44)
-
All Tables Fixed-Width:
- NAME_LAST (113-147)
- NAME_FIRST (148-182)
- BIRTH_DATE (203-212)
- SECONDARY_ID (234-263)
- LATEST_PSAT_DATE (663-672)
Summary
The PSAT 10/NMSQT is college readiness exam that measures:
- What students have learned in high school
- What students need to succeed in college
This assessment is broken down into three separate tests:
- Math
- Reading
- Writing and Language
References
https://collegereadiness.collegeboard.org/psat-nmsqt-psat-10/inside-the-test
How are records matched to students in Illuminate?
2015-2016 - Current: Imports look to match
- 1st: SECONDARY_ID (26 CSV, 234-263 Fixed) to State Student ID
- 2nd: SECONDARY_ID (26 CSV, 234-263 Fixed) to Local Student ID
- 3rd: A unique combination of NAME_LAST (6 CSV, 113-147 Fixed) to Last Name, NAME_FIRST (7 CSV, 148-182 Fixed) to First Name, and BIRTH_DATE (23 CSV, 203-212 Fixed) to Birth Date
How are unique records identified?
2015-2016 - Current:
-
All Tables CSV:
- NAME_LAST (6)
- NAME_FIRST (7)
- BIRTH_DATE (23)
- SECONDARY_ID (26)
- LATEST_PSAT_DATE (46)
-
All Tables Fixed-Width:
- NAME_LAST (113-147)
- NAME_FIRST (148-182)
- BIRTH_DATE (203-212)
- SECONDARY_ID (234-263)
- LATEST_PSAT_DATE (665-674)
How are records matched to students in Illuminate?
2014-2015 Fixed Width:
- 1st: Student ID Number (524-538) to Local Student ID
- 2nd: Unique combination of Last name (9-23) to Last Name, First name (24-35) to First Name, and Date of birth (88-93) to Birth Date
2014-2015 CSV:
- ***Layout is missing from Illuminate, will need to upload it.
2013-2014, 2012-2013, 2011-2012:
- 1st: Local ID 1 (209) to Local Student ID
- 2nd: Unique combination of Last Name (E) to Last Name, First Name (7) to First Name, Date of Birth (14) to Birth Date
How are unique records identified?
2014-2015 Fixed Width:
- Test form code (146-147)
- Year in which test was administered (1-2)
- Last name (9-23)
- First name (24-35)
- Date of birth (88-93)
- Student ID Number (524-538)
2014-2015 CSV: ***Layout is missing from Illuminate, we need to upload it.
2013-2014, 2012-2013 and 2011-2012:
- Test Form (column 1)
- Year of Test (17)
- Last Name (6)
- First Name (7)
- Date of Birth (14)
- Local ID 1 (209)
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)
Now you can! Visit Automate State Assessment Data to get started today.
Comments
0 comments
Please sign in to leave a comment.