Washington State Assessments

CAA/CIA - Certification of Academic/Individual Achievement

COE - Collection of Evidence 

SBA - Smarter Balanced 

WaKIDS - Washington Kindergarten Inventory of Developing Skills

WCAP - Washington Comprehensive Assessment Program

WELPA - Washington English Language Proficiency Assessment

CAA/CIA (Certificate of Academic/Individual Achievement)

How are records matched to students in Illuminate?

SSID (8) to State Student ID only

How are unique records identified?

SSID (Column 8) only.

COE (Collection of Evidence)

How are records matched to students in Illuminate?

2014-2015: SSID (13) to State Student ID only

How are unique records identified?

2014-2015: 

  • AdministrationMonthYear (1)
  • SSID (13)

EDS WAMS (Education Data System - Washington Academic Middle School)

How are records matched to students in Illuminate?

EDS WAMS Assessment Data 2013-2014: 

  • 1st: SSID (7) to State Student ID
  • 2nd: DistrictID (8) to Local Student ID

How are unique records identified?

2013-2014

"CEDARS" Table

  • SSID (7)
  • DistrictID (8)

"DAPE", "MSP", "MSP - B" and "WAASPORT" Tables (Math, Reading, Sci, and Writing)

  • mathResolvedAttempted (29), ReadingResolvedAttempted (14), scienceResolvedAttempted (36), or writingResolvedAttempted (21) – depending on Subject 
  • SSID (7)
  • DistrictID (8)

"HSPE" and "HSPE - B" Tables (Reading and Writing)

  • ReadingResolvedAttempted (14) or writingResolvedAttempted (21) – depending on Subject
  • SSID (7)
  • DistrictID (8)

"EOC Math 1" Table

  • EOCMathyr1Attempted (43)
  • SSID (7)
  • DistrictID (8)

"EOC Math 2" Table

  • EOCMathyr2Attempted (49)
  • SSID (7)
  • DistrictID (8)

"EOC Biology" Table

  • EOCBiologyAttempted (55)
  • SSID (7)
  • DistrictID (8)

WaKIDS (Washington Kindergarten Inventory of Developing Skills)

How are records matched to students in Illuminate?

2014-2015: 

  • 1st: StateStudentID (14) to State Student ID
  • 2nd: DistrictStudentID (13) to Local Student ID 

How are unique records identified?

2014-2015: DistrictStudentID (13) only

WCAP (Washington Comprehensive Assessment Program)

How are records matched to students in Illuminate?

2014-2015 and 2013-2014

  • 1st: SSID (97-106) to State Student ID
  • 2nd: StudentDistrictID (107-116) to Local Student ID

2012-2013 through 2008-2009 

  • 1st: SSID (89-98) to State Student ID
  • 2nd: StudentDistrictID (99-108) to Local Student ID

How are unique records identified?

2014-2015: 

  • ScoredFileID (1-7)
  • administration (17-30)

2013-2014: 

  • CEDARS Table: 
    • SSID (97-106)
    • StudentDistrictID (107-116)
    • CEDARS_DateEnrolledInDistrict (1158-1167)
    • DateEnrolledInSchool 1178-1187
  • DAPE, MSP and MSP-B Tables: 
    • "Attempt" (either ReadingAttempt 651-652, WritingAttempt 668-669, MathAttempt 685-686, or ScienceAttempt 702-703, depending on subject)
    • "StudentBarcode" (either ReadingStudentBarcode 205-219, MathStudentBarcode 512-526, or ScienceStudentBarcode 612-626, depending on subject--the "Writing" table doesn't use the barcode column)
    • SSID (97-106)
    • StudentDistrictID (107-116)
  • HSPE and HSPE-B Tables (Note: no Math or Science data is stored in 2014 HSPE and HSPE tables)
    • "Attempt" (either ReadingAttempt 651-652 or WritingAttempt (668-669) depending on subject)
    • "StudentBarcode" ReadingStudentBarcode (205-219), the "Writing" table doesn't use the barcode column)
    • SSID (97-106)
    • StudentDistrictID (107-116)
  • WAASPORT Tables: 
    • "Attempt" (either WAASPortfolioReadingAttempt (1314-1315), WAASPortfolioWritingAttempt (1323-1324), WAASPortfolioMathAttempt (1332-1333),  or WAASPortfolioScienceAttempt (1341-1342), depending on subject)
    • WAASPortfolio_ID (1270-1277)
    • SSID (97-106)
    • StudentDistrictID (107-116)
  • EOC Tables:
    • "Attempt" (either EOCMath1Attempt (1423-1424), EOCMath2Attempt (1587-1588), or EOCBioAttempt (1743-1744), depending on subject)
    • "Student Barcode" (either EOCMath1StudentBarcode (1384-1398), EOCMath2StudentBarcode (1548-1562), or EOCBioStudentBarcode (1704-1718), depending on subject)
    • SSID (97-106)
    • StudentDistrictID (107-116)

2012-2013: 

  • CEDARS Table: 
    • SSID (89-98)
    • StudentDistrictID (99-108)
    • CEDARS_DateEnrolledInDistrict (1204-1213)
    • CEDARS_DateEnrolledInSchool (1224-1233)
  • DAPE, MSP, and MSP-B Tables:
    • "Attempt" (either ReadingAttempt (697-698), WritingAttempt (714-715), MathAttempt (731-732), ScienceAttempt (748-749), depending on subject)
    • "School Code" (either MathSchoolCode (522-525), ReadingSchoolCode (185-188), ScienceSchoolCode (634-637), or WritingSchoolCode (295-298))
    • "Student Barcode" (either ReadingStudentBarcode 209-223, MathStudentBarcode 546-560, or ScienceStudentBarcode 658-672 depending on subject--the "Writing" table doesn't use the barcode column)
    • SSID (89-98)
    • StudentDistrictID (99-108)
  • HSPE and HSPE-B Tables: (Note: no Math or Science data is stored in 2013 HSPE and HSPE tables)
    • "Attempt" (either ReadingAttempt (697-698) or WritingAttempt (714-715) depending on subject)
    • "School Code" (either ReadingSchoolCode (185-188) or WritingSchoolCode (295-298))
    • "Student Barcode" ReadingStudentBarcode (209-223) (Note: the "Writing" table doesn't use the barcode column)
    • SSID (89-98)
    • StudentDistrictID (99-108)
  • WAASPORTS Tables:
    • "Attempt" (either WAASPortfolioReadingAttempt (1314-1315), WAASPortfolioWritingAttempt (1323-1324), WAASPortfolioMathAttempt (1332-1333), WAASPortfolioScienceAttempt (1341-1342), depending on subject)
    • WAASPortfolio_ID (1306-1313)
    • SSID (89-98)
    • StudentDistrictID (99-108)
  • EOC Tables:
    • "Attempt" (either EOCMath1Attempt (1471-1472), EOCMath2Attempt (1647-1648), or EOCBioAttempt (1815-1816), depending on subject)
    • "Student Barcode" (either EOCMath1StudentBarcode (1432-1446), EOCMath2StudentBarcode (1608-1622), or EOCBioStudentBarcode (1776-1790), depending on subject)
    • SSID (89-98)
    • StudentDistrictID (99-108)

2011-2012:

  • CEDARS Table: 
    • SSID (89-98)
    • StudentDistrictID (99-108)
    • CEDARS_DateEnrolledInDistrict (1180-1189)
    • CEDARS_DateEnrolledInSchool (1200-1209)
  • DAPE, MSP, and MSP-B 
    • "Attempt" (either ReadingAttempt (673-674), WritingAttempt (690-691) , MathAttempt (707-708), or ScienceAttempt (724-725), depending on subject)
    • "School Code" (either MathSchoolCode (505-508), ReadingSchoolCode (183-186), ScienceSchoolCode (612-615), or WritingSchoolCode (289-292))
    • "Student Barcode" (either ReadingStudentBarcode (207-221), MathStudentBarcode (529-543), or ScienceStudentBarcode (636-650), depending on subject--the "Writing" table doesn't use the barcode column)
    • SSID (89-98
    • StudentDistrictID (99-108)
  • HSPE and HSPE-B Tables (Note: no Math data is stored in 2012 HSPE and HSPE tables)
    • "Attempt" (either ReadingAttempt (673-674), WritingAttempt (690-691), ScienceAttempt (724-725), depending on subject)
    • "School Code" (either ReadingSchoolCode (183-186), ScienceSchoolCode (612-615), or WritingSchoolCode (289-292))
    • "Student Barcode" (either ReadingStudentBarcode (207-221) or ScienceStudentBarcode (636-650), depending on subject--the "Writing" table doesn't use the barcode column)
    • SSID (89-98)
    • StudentDistrictID (99-108)
  • WAASPORTS Tables:
    • "Attempt" (either WAASPortfolioReadingAttempt (1284-1285), WAASPortfolioWritingAttempt (1293-1294), WAASPortfolioMathAttempt (1302-1303), WAASPortfolioScienceAttempt (1311-1312), depending on subject)
    • WAASPortfolio_ID (1276-1283)
    • SSID (89-98)
    • StudentDistrictID (99-108)
  • EOC Tables
    • "Attempt" (either EOCMath1Attempt (1435-1436), EOCMath2Attempt (1605-1606), or EOCBioAttempt (1768-1769), depending on subject)
    • "Student Barcode" (either EOCMath1StudentBarcode (1432-1446), EOCMath2StudentBarcode (1608-1622), or EOCBioStudentBarcode (1776-1790), depending on subject)
    • SSID (89-98)
    • StudentDistrictID (99-108)

2010-2011:

  • CEDARS Table: 
    • SSID (89-98)
    • StudentDistrictID (99-108)
    • CEDARS_DateEnrolledInDistrict (1149-1158)
    • CEDARS_DateEnrolledInSchool (1169-1178)
  • DAPE, MSP, and MSP-B Tables:
    • "Attempt" (either ReadingAttempt (642-643), WritingAttempt (659-660), MathAttempt (676-677), or ScienceAttempt (693-694), depending on subject)
    • "School Code" (either MathSchoolCode (486-489), ReadingSchoolCode (180-183), ScienceSchoolCode (586-589), or WritingSchoolCode (279-282)
    • "Student Barcode" (either ReadingStudentBarcode (199-213), MathStudentBarcode (505-519), or ScienceStudentBarcode (605-619), depending on subject--the "Writing" table doesn't use the barcode column)
    • SSID (89-98
    • StudentDistrictID (99-108)
  • HSPE and HSPE-B Tables (Note: no Math data is stored in 2011 HSPE and HSPE tables)
    • "Attempt" (either ReadingAttempt (642-643), WritingAttempt (659-660), or ScienceAttempt (693-694), depending on subject)
    • "School Code" (either MathSchoolCode (486-489), ReadingSchoolCode (180-183), ScienceSchoolCode (586-589), or WritingSchoolCode (279-282)
    • "Student Barcode" (either ReadingStudentBarcode (199-213), or ScienceStudentBarcode (605-619), depending on subject--the "Writing" table doesn't use the barcode column)
    • SSID (89-98
    • StudentDistrictID (99-108)
  • WAASPORTS tables:
    • "Attempt" (WAASPortfolioReadingAttempt (1253-1254), WAASPortfolioWritingAttempt (1262-1263), WAASPortfolioMathAttempt (1271-1272), WAASPortfolioScienceAttempt (1280-1281), depending on subject)
    • WAASPortfolio_ID (1245-1252)
    • SSID (89-98)
    • StudentDistrictID (99-108)
  • EOC Tables:
    • "Attempt" (either EOCMath1Attempt (1435-1436) or EOCMath2Attempt (1604-1605), depending on subject)
    • "Student Barcode" (either EOCMath1StudentBarcode (1398-1412) or EOCMath2StudentBarcode (1567-1581), depending on subject)
    • SSID (89-98)
    • StudentDistrictID (99-108)

2009-2010:

  • CEDARS Table: 
    • SSID (89-98)
    • StudentDistrictID (99-108)
    • CEDARS_DateEnrolledInDistrict (1130-1139)
    • CEDARS_DateEnrolledInSchool (1150-1159)
  • DAPE, MSP, MSP-B, HSPE, and HSPE-B Tables:
    • "Attempt" (either ReadingAttempt (655-656), WritingAttempt (672-673), MathAttempt (689-690), or ScienceAttemept (706-707), depending on subject)
    • "School Code" (either MathSchoolCode (498-501), ReadingSchoolCode (183-186), ScienceSchoolCode (600-603), or WritingSchoolCode (286-289)
    • "Student Barcode" (either ReadingStudentBarcode (202-216), MathStudentBarcode (517-531), or ScienceStudentBarcode (619-633), depending on subject--the "Writing" table doesn't use the barcode column)
    • SSID (89-98
    • StudentDistrictID (99-108)
  • WAASPORTS tables:
    • "Attempt" (WAASPortfolioReadingAttempt (1231-1232), WAASPortfolioWritingAttempt (1240-1241), WAASPortfolioMathAttempt (1249-1250), WAASPortfolioScienceAttempt (1258-1259), depending on subject)
    • WAASPortfolio_ID (1223-1230)
    • SSID (89-98)
    • StudentDistrictID (99-108)

2008-2009:

  • CEDARS Table: 
    • SSID (89-98)
    • StudentDistrictID (99-108)
    • CSRS_DateEnrolledInDistrict (1078-1087)
    • CSRS_DateEnrolledInSchool (1098-1107)
  • DAWL Table:
    • "Attempt" (either ReadingAttempted (652-653), WritingAttempted (669-670), MathAttempted (686-687), or ScienceAttempted (703-704), depending on subject)
    • "School Code" (either ReadingSchoolCode (183-186), MathSchoolCode (496-499), or ScienceSchoolCode (597-600), WritingSchoolCode (284-287) depending on subject)
    • SSID (89-98)
    • StudentDistrictID (99-108)
  • WASL and WASL-B Tables
    • "Attempt" (either ReadingAttempted (652-653), WritingAttempted (669-670), MathAttempted (686-687), or ScienceAttempted (703-704), depending on subject)
    • "School Code" (either ReadingSchoolCode (183-186), MathSchoolCode (496-499), or ScienceSchoolCode (597-600), WritingSchoolCode (284-287) depending on subject)
    • "Student Barcode" (either MathStudentBarcode (515-529), ReadingStudentBarcode (202-216), ScienceStudentBarcode (616-630)--depending on subject, note that the "Writing" table doesn't use the barcode column)
    • SSID (89-98)
    • StudentDistrictID (99-108)
  • WAASPORT tables:
    • "Attempt" (PORT_ReadingAttempt (1178-1179), PORT_WritingAttempt (1187-1188), PORT_MathAttempt (1196-1197), PORT_ScienceAttempt (1205-1206), depending on subject)
    • PORT_ID (1170-1177)
    • SSID (89-98)
    • StudentDistrictID (99-108)

WELPA (Washington English Language Proficiency Assessment)

How are records matched to students in Illuminate?

All WELPA Imports (2011-2012, 2012-2013, 2013-2014, and 2014-2015)

  • 1st: Look to match SSID (12) to State Student ID
  • 2nd: Look to match DistrictStudentID (13) to Local Student ID

How are unique records identified?

All WELPA Imports (2011-2012, 2012-2013, 2013-2014, and 2014-2015): 

  • SSID (12)
  • DistrictStudentID (13)