~[wc:commonscripts] ~[wc:admin_header_css] ~[wc:admin_navigation_css]

IAR/ISA Form Conflicts~[if#sch.is.a.school] - ~(schoolabbr)[/if#sch]

Under the Spring 2027 (26-27) Illinois Administration Platform rules, a student can be assigned only one accommodated test form per subject.
When the accommodations on a student's IAR/ISA page would assign more than one form, the page and the upload choose one using a hierarchy (shown by the help icon next to the form name).
However, this may not be what was intended, and the platform rejects some combinations outright.
Below are students with one or more of these "form conflicts", and the related accommodations. Also listed: Spanish with Large Print on paper is not a conflict. It is the Paper Large Print Spanish Edition.
Clicking on a student number will take you to that student for review/correction.
~[tlist_sql; WITH subj AS ( SELECT s.dcid AS student_dcid, s.student_number, s.last_name, s.first_name, schools.abbreviation, s.grade_level, 'Math' AS subject, /* normalized accommodation fields */ CASE WHEN x.PARCC_Math_Test_Format = 'P' THEN 'P' ELSE 'O' END AS test_format, CASE WHEN x.PARCC_Math_Screen_Read_App IN ('05','06') THEN 'Yes' END AS screen_reader, CASE WHEN x.PARCC_Math_Braille_Response = '01' THEN 'Yes' END AS braille_online, CASE WHEN x.PARCC_Math_Human_Reader IN ('04','05') THEN 'Yes' END AS human_reader, CASE WHEN x.PARCC_Math_Braill_W_Graphic = '01' THEN 'Yes' END AS braille_paper, CASE WHEN x.PARCC_Math_Large_Print = '01' THEN 'Yes' END AS large_print, CASE WHEN x.PARCC_Math_Translate_Spa = '01' THEN 'Yes' END AS spanish, CASE WHEN p.PARCC_Math_sign_language = '01' THEN 'Yes' END AS sign_language, CASE WHEN p.IAR_Math_extensions = '01' THEN 'Yes (Bundle)' END AS speech_to_text, '' AS word_prediction, '' AS ela_text_to_speech FROM students s JOIN schools ON s.schoolid = schools.school_number AND (schools.State_ExcludeFromReporting = 0 OR schools.State_ExcludeFromReporting IS NULL) LEFT JOIN S_IL_STU_X x ON s.dcid = x.studentsdcid LEFT JOIN u_parcc p ON s.dcid = p.studentsdcid WHERE s.enroll_status = 0 AND s.grade_level BETWEEN 3 AND 8 AND s.State_StudentNumber IS NOT NULL AND (x.Alt_Assessment_Indicator <> '01' OR x.Alt_Assessment_Indicator IS NULL) AND (x.state_excludeenrollment = 0 OR x.state_excludeenrollment IS NULL) ~[if#sch.is.a.school] AND s.schoolid = ~(curschoolid) [/if#sch] UNION ALL SELECT s.dcid AS student_dcid, s.student_number, s.last_name, s.first_name, schools.abbreviation, s.grade_level, 'ELA' AS subject, CASE WHEN x.PARCC_ELA_Test_Format = 'P' THEN 'P' ELSE 'O' END AS test_format, CASE WHEN x.PARCC_ELA_Screen_Reader_App IN ('05','06') THEN 'Yes' END AS screen_reader, CASE WHEN x.PARCC_ELA_Braille_Response = '01' THEN 'Yes' END AS braille_online, CASE WHEN x.PARCC_ELA_Human_Reader IN ('04','05') THEN 'Yes' END AS human_reader, CASE WHEN x.PARCC_ELA_Braille_W_Graphic = '01' THEN 'Yes' END AS braille_paper, CASE WHEN x.PARCC_ELA_Large_Print = '01' THEN 'Yes' END AS large_print, '' AS spanish, CASE WHEN p.PARCC_ELA_sign_language = '01' THEN 'Yes' END AS sign_language, CASE WHEN x.ELA_Extensions = '01' THEN 'Yes' END AS speech_to_text, CASE WHEN p.IAR_ELA_word_prediction = '01' THEN 'Yes' END AS word_prediction, CASE WHEN x.PARCC_ELA_Text_To_Speech = '11' THEN 'Yes' END AS ela_text_to_speech FROM students s JOIN schools ON s.schoolid = schools.school_number AND (schools.State_ExcludeFromReporting = 0 OR schools.State_ExcludeFromReporting IS NULL) LEFT JOIN S_IL_STU_X x ON s.dcid = x.studentsdcid LEFT JOIN u_parcc p ON s.dcid = p.studentsdcid WHERE s.enroll_status = 0 AND s.grade_level BETWEEN 3 AND 8 AND s.State_StudentNumber IS NOT NULL AND (x.Alt_Assessment_Indicator <> '01' OR x.Alt_Assessment_Indicator IS NULL) AND (x.state_excludeenrollment = 0 OR x.state_excludeenrollment IS NULL) ~[if#sch.is.a.school] AND s.schoolid = ~(curschoolid) [/if#sch] UNION ALL SELECT s.dcid AS student_dcid, s.student_number, s.last_name, s.first_name, schools.abbreviation, s.grade_level, 'Science' AS subject, CASE WHEN x.IAR_Sci_Paper_Trans = '02' THEN 'P' ELSE 'O' END AS test_format, CASE WHEN x.IAR_Sci_Assistive_Tech IN ('05','06') THEN 'Yes' END AS screen_reader, CASE WHEN x.IAR_Sci_Braille_Response = '01' THEN 'Yes' END AS braille_online, CASE WHEN x.IAR_Sci_Human_Reader IN ('04','05') THEN 'Yes' END AS human_reader, CASE WHEN x.IAR_Sci_Tactile_Graphics = '01' THEN 'Yes' END AS braille_paper, CASE WHEN x.IAR_Sci_Large_Print = '01' THEN 'Yes' END AS large_print, CASE WHEN p.IAR_SCI_spanish = '01' THEN 'Yes' END AS spanish, CASE WHEN p.IAR_SCI_sign_language = '01' THEN 'Yes' END AS sign_language, CASE WHEN p.IAR_SCI_extensions = '01' THEN 'Yes' END AS speech_to_text, CASE WHEN p.IAR_SCI_word_prediction = '01' THEN 'Yes' END AS word_prediction, '' AS ela_text_to_speech FROM students s JOIN schools ON s.schoolid = schools.school_number AND (schools.State_ExcludeFromReporting = 0 OR schools.State_ExcludeFromReporting IS NULL) LEFT JOIN S_IL_STU_X x ON s.dcid = x.studentsdcid LEFT JOIN u_parcc p ON s.dcid = p.studentsdcid WHERE s.enroll_status = 0 AND (s.grade_level = 5 OR s.grade_level = 8) AND s.State_StudentNumber IS NOT NULL AND (x.Alt_Assessment_Indicator <> '01' OR x.Alt_Assessment_Indicator IS NULL) AND (x.state_excludeenrollment = 0 OR x.state_excludeenrollment IS NULL) ~[if#sch.is.a.school] AND s.schoolid = ~(curschoolid) [/if#sch] ), form_eval AS ( SELECT student_dcid, student_number, last_name, first_name, abbreviation, grade_level, subject, /* online forms */ CASE WHEN test_format = 'O' AND spanish = 'Yes' THEN 1 END AS Online_Spanish, CASE WHEN test_format = 'O' AND sign_language = 'Yes' THEN 1 END AS Online_ASL, CASE WHEN test_format = 'O' AND (screen_reader = 'Yes' OR braille_online = 'Yes') THEN 1 END AS Online_BVI, CASE WHEN test_format = 'O' AND ( (subject = 'Math' AND (human_reader = 'Yes' OR speech_to_text IS NOT NULL)) OR (subject = 'ELA' AND (human_reader = 'Yes' OR ela_text_to_speech = 'Yes')) OR (subject = 'Science' AND human_reader = 'Yes') ) THEN 1 END AS Online_Bundle, /* Science Speech to Text and Word Prediction are not available on the Online Spanish form */ CASE WHEN test_format = 'O' AND subject = 'Science' AND spanish = 'Yes' AND (speech_to_text = 'Yes' OR word_prediction = 'Yes') THEN 1 END AS Tool_On_Spanish, /* paper forms. Spanish with Large Print is the Large Print Spanish Edition, not a conflict */ CASE WHEN test_format = 'P' AND braille_paper = 'Yes' THEN 1 END AS Paper_Braille, CASE WHEN test_format = 'P' AND large_print = 'Yes' THEN 1 END AS Paper_Large, CASE WHEN test_format = 'P' AND spanish = 'Yes' AND large_print IS NULL THEN 1 END AS Paper_Spanish, /* raw accommodations for reporting */ test_format, screen_reader, braille_online, human_reader, braille_paper, large_print, spanish, sign_language, speech_to_text, word_prediction, ela_text_to_speech FROM subj ) , form_hits AS ( SELECT student_dcid, student_number, last_name, first_name, subject, form_name FROM form_eval UNPIVOT ( hit FOR form_name IN ( Online_Spanish AS 'Online Spanish', Online_ASL AS 'Online ASL/Human Signer', Online_BVI AS 'Online Blind and Visually Impaired', Online_Bundle AS 'Online Bundle', Tool_On_Spanish AS 'Speech to Text/Word Prediction on Spanish form', Paper_Braille AS 'Paper Braille', Paper_Large AS 'Paper Large Print', Paper_Spanish AS 'Paper Spanish' ) ) WHERE hit = 1 ) SELECT f.student_dcid AS student_dcid, f.student_number AS student_number, f.last_name AS last_name, f.first_name AS first_name, e.abbreviation AS abbreviation, e.grade_level AS grade_level, e.subject AS subject, LISTAGG(f.form_name, ', ') WITHIN GROUP (ORDER BY f.form_name) AS conflicting_forms, /* Accommodations snapshot */ MAX(e.test_format) AS test_format, MAX(e.screen_reader) AS screen_reader, MAX(e.braille_online) AS braille_online, MAX(e.human_reader) AS human_reader, MAX(e.braille_paper) AS braille_paper, MAX(e.large_print) AS large_print, MAX(e.spanish) AS spanish, MAX(e.sign_language) AS sign_language, MAX(e.speech_to_text) AS speech_to_text, MAX(e.word_prediction) AS word_prediction, MAX(e.ela_text_to_speech) AS ela_text_to_speech FROM form_hits f JOIN form_eval e ON f.student_dcid = e.student_dcid AND f.subject = e.subject GROUP BY f.student_dcid, f.student_number, f.last_name, f.first_name, e.abbreviation, e.grade_level, e.subject HAVING COUNT(*) > 1 ORDER BY e.abbreviation, f.last_name, f.first_name, e.subject ;nonemessage=] [/tlist_sql]
Student Number Last Name First Name School Grade Subject Conflicting Forms Test Format AT for Limited Vision Braille Writer/Refreshable Braille Device Proctor Read Aloud Braille with Tactile Graphics Large Print Language Spanish Sign Language/ASL Speech to Text Word Prediction ELA Text to Speech
No form conflicts found
~(student_number) ~(last_name) ~(first_name) ~(abbreviation) ~(grade_level) ~(subject) ~(conflicting_forms) ~(test_format) ~(screen_reader) ~(braille_online) ~(human_reader) ~(braille_paper) ~(large_print) ~(spanish) ~(sign_language) ~(speech_to_text) ~(word_prediction) ~(ela_text_to_speech)

Speech to Text / Word Prediction Not Exported: Student Not Eligible

These students have Speech to Text or Word Prediction marked Yes but are not eligible, so the accommodations upload leaves those columns blank.
ELA requires an IEP or 504 plan. Science requires an IEP, 504, LEP or Dual Language (the Illinois Administration Platform's own validation, Rule 1, may still reject EL-only Science students).
Correct the student's IEP/504/LEP status, or set the accommodation to No. Each student number opens that student's IAR/ISA page in a new window.
~[tlist_sql; SELECT s.dcid AS student_dcid, s.student_number AS student_number, s.last_name AS last_name, s.first_name AS first_name, schools.abbreviation AS abbreviation, s.grade_level AS grade_level, 'ELA' AS subject, CASE WHEN x.ELA_Extensions = '01' AND p.IAR_ELA_word_prediction = '01' THEN 'Speech to Text, Word Prediction' WHEN x.ELA_Extensions = '01' THEN 'Speech to Text' ELSE 'Word Prediction' END AS not_exported, 'IEP/504' AS required_plan, CASE WHEN x.lep = 1 OR x.Dual_Language IN ('01','02') THEN 'Yes' ELSE 'No' END AS lep_status FROM students s JOIN schools ON s.schoolid = schools.school_number AND (schools.State_ExcludeFromReporting = 0 OR schools.State_ExcludeFromReporting IS NULL) LEFT JOIN S_IL_STU_X x ON s.dcid = x.studentsdcid LEFT JOIN S_IL_STU_Plan504_X p504 ON s.dcid = p504.studentsdcid LEFT JOIN u_parcc p ON s.dcid = p.studentsdcid WHERE s.enroll_status = 0 AND s.grade_level BETWEEN 3 AND 8 AND s.State_StudentNumber IS NOT NULL AND (x.Alt_Assessment_Indicator <> '01' OR x.Alt_Assessment_Indicator IS NULL) AND (x.state_excludeenrollment = 0 OR x.state_excludeenrollment IS NULL) AND (x.ELA_Extensions = '01' OR p.IAR_ELA_word_prediction = '01') AND (x.iep IS NULL OR x.iep <> 1) AND (p504.Participant IS NULL OR p504.Participant <> 1) ~[if#sch.is.a.school] AND s.schoolid = ~(curschoolid) [/if#sch] UNION ALL SELECT s.dcid AS student_dcid, s.student_number AS student_number, s.last_name AS last_name, s.first_name AS first_name, schools.abbreviation AS abbreviation, s.grade_level AS grade_level, 'Science' AS subject, CASE WHEN p.IAR_SCI_extensions = '01' AND p.IAR_SCI_word_prediction = '01' THEN 'Speech to Text, Word Prediction' WHEN p.IAR_SCI_extensions = '01' THEN 'Speech to Text' ELSE 'Word Prediction' END AS not_exported, 'IEP/504 or LEP' AS required_plan, 'No' AS lep_status FROM students s JOIN schools ON s.schoolid = schools.school_number AND (schools.State_ExcludeFromReporting = 0 OR schools.State_ExcludeFromReporting IS NULL) LEFT JOIN S_IL_STU_X x ON s.dcid = x.studentsdcid LEFT JOIN S_IL_STU_Plan504_X p504 ON s.dcid = p504.studentsdcid LEFT JOIN u_parcc p ON s.dcid = p.studentsdcid WHERE s.enroll_status = 0 AND (s.grade_level = 5 OR s.grade_level = 8) AND s.State_StudentNumber IS NOT NULL AND (x.Alt_Assessment_Indicator <> '01' OR x.Alt_Assessment_Indicator IS NULL) AND (x.state_excludeenrollment = 0 OR x.state_excludeenrollment IS NULL) AND (p.IAR_SCI_extensions = '01' OR p.IAR_SCI_word_prediction = '01') AND (x.iep IS NULL OR x.iep <> 1) AND (p504.Participant IS NULL OR p504.Participant <> 1) AND (x.lep IS NULL OR x.lep <> 1) AND (x.Dual_Language IS NULL OR x.Dual_Language NOT IN ('01','02')) ~[if#sch.is.a.school] AND s.schoolid = ~(curschoolid) [/if#sch] ORDER BY 5, 3, 4, 7 ;nonemessage=] [/tlist_sql]
Student Number Last Name First Name School Grade Subject Not Exported Requires LEP/Dual Language
No ineligible Speech to Text or Word Prediction found
~(student_number) ~(last_name) ~(first_name) ~(abbreviation) ~(grade_level) ~(subject) ~(not_exported) ~(required_plan) ~(lep_status)

Word Prediction Needs Review

Through 25-26, Speech to Text and Word Prediction were one combined field. Starting in 26-27 they are separate tool add-ons, and the old combined field now means Speech to Text only.
These students have Speech to Text = Yes but have never had Word Prediction answered, so Word Prediction is not included in the upload.
Open the student's IAR/ISA page: Word Prediction will be pre-selected Yes from the old combined field. Confirm or change it, then save.
~[tlist_sql; SELECT s.dcid AS student_dcid, s.student_number AS student_number, s.last_name AS last_name, s.first_name AS first_name, schools.abbreviation AS abbreviation, s.grade_level AS grade_level, 'ELA' AS subject FROM students s JOIN schools ON s.schoolid = schools.school_number AND (schools.State_ExcludeFromReporting = 0 OR schools.State_ExcludeFromReporting IS NULL) LEFT JOIN S_IL_STU_X x ON s.dcid = x.studentsdcid LEFT JOIN u_parcc p ON s.dcid = p.studentsdcid WHERE s.enroll_status = 0 AND s.grade_level BETWEEN 3 AND 8 AND s.State_StudentNumber IS NOT NULL AND (x.Alt_Assessment_Indicator <> '01' OR x.Alt_Assessment_Indicator IS NULL) AND (x.state_excludeenrollment = 0 OR x.state_excludeenrollment IS NULL) AND x.ELA_Extensions = '01' AND p.IAR_ELA_word_prediction IS NULL ~[if#sch.is.a.school] AND s.schoolid = ~(curschoolid) [/if#sch] UNION ALL SELECT s.dcid AS student_dcid, s.student_number AS student_number, s.last_name AS last_name, s.first_name AS first_name, schools.abbreviation AS abbreviation, s.grade_level AS grade_level, 'Science' AS subject FROM students s JOIN schools ON s.schoolid = schools.school_number AND (schools.State_ExcludeFromReporting = 0 OR schools.State_ExcludeFromReporting IS NULL) LEFT JOIN S_IL_STU_X x ON s.dcid = x.studentsdcid LEFT JOIN u_parcc p ON s.dcid = p.studentsdcid WHERE s.enroll_status = 0 AND (s.grade_level = 5 OR s.grade_level = 8) AND s.State_StudentNumber IS NOT NULL AND (x.Alt_Assessment_Indicator <> '01' OR x.Alt_Assessment_Indicator IS NULL) AND (x.state_excludeenrollment = 0 OR x.state_excludeenrollment IS NULL) AND p.IAR_SCI_extensions = '01' AND p.IAR_SCI_word_prediction IS NULL ~[if#sch.is.a.school] AND s.schoolid = ~(curschoolid) [/if#sch] ORDER BY 5, 3, 4, 7 ;nonemessage=] [/tlist_sql]
Student Number Last Name First Name School Grade Subject
No students need Word Prediction review
~(student_number) ~(last_name) ~(first_name) ~(abbreviation) ~(grade_level) ~(subject)
~[wc:admin_footer_css]