Comments
Description
Transcript
2016 PARCC CO Student Test File Layout
2016 PARCC CO Student Test File Layout Column Assumptions: 1. .csv format with header row for summative/txt and csv for Student Test Update File Layout 2.Updates for the summative data can only be done via the Student Test Update. CDE will add all report suppression codes. 3. Voided tests with Unsubmitted or Void Unit flags will be excluded and not considered for any of the record creations. 4. Trim all leading and trailing spaces 5. Cross validations from the SR PNP are also valid for STU imports. Field Start Position End Position Max Length Element Name StateAbbreviation Definitions Expected Values STU Import Update‐able State's 2 character abbreviation CO = Colorado A 1 1 2 N 2 TestingDistrictCode B 2 3 17 Responsible and Testing District must be marked as participating in the administration. *Expected character length = 4 15 TestingSchoolCode C 3 18 32 The Testing District responsible for administering the A‐Z test for a student whose results would be reported to 0‐9 the Responsible District. The Testing School responsible for administering the A‐Z test for a student whose results would be reported to 0‐9 the Responsible School/Institution Responsible and Testing School must be marked as participating in the administration. *Expected character length = 4 15 ResponsibleDistrictCode The district responsible for specific educational services and/or instruction of the student. Also known as the Reporting District D 4 33 47 15 N Responsible and Testing District must be marked as participating in the administration. *Expected character length = 4 Version 1: May 5, 2016 N A‐Z 0‐9 *Blank ‐ If blank use testing district code Note: Within PearsonAccessnext UI, Responsible District Code and Responsible School Code are concatenated into one field Responsible School Code and is required. Y Column Field Start Position End Position Max Length Element Name ResponsibleSchoolCode Definitions The school responsible for specific educational services and/or instruction of the student. Responsible and Testing School must be marked as participating in the administration. *Expected character length = 4 E 5 48 62 15 StateStudentIdentifier F 6 63 72 10 LocalStudentIdentifier G 7 73 102 30 PARCCStudentIdentifier H 8 103 138 9 139 173 10 174 208 A unique number or alphanumeric code assigned to a A‐Z 0‐9 student by a state or any other entity No embedded spaces *Expected character length = 10 A unique number or alphanumeric code assigned to a A‐Z student by a school system or any other entity 0‐9 No embedded spaces Blank STU Import Update‐able Y N Y Unique PARCC Student Identifier that will move System Generated intra state if a student moves district to district or school to school. N Recommended for States to load this ID Identifier into their systems once assigned to assist in future SDU loads and Reporting Database loads The full legal last name borne in common by members of a family. 35 FirstName J A‐Z 0‐9 *Blank ‐ If blank use testing school code Note: Within PearsonAccessnext UI Responsible District Code and Responsible School Code are concatenated into one field Responsible School Code and is required. 36 LastOrSurname I Expected Values The full legal first name given to a person at birth, baptism, or through legal change. 35 Version 1: May 5, 2016 A‐Z 0‐9 . ‐ ' (Standard Apostrophe) Embedded Spaces Y A‐Z 0‐9 . ‐ ' (Standard Apostrophe) Embedded Spaces Y Column Field Start Position End Position Max Length Element Name Definitions MiddleName K 11 209 243 35 L 12 244 253 10 M 13 254 254 1 N 14 255 274 20 15 275 276 2 P 16 277 277 1 The year, month and day on which a person was born. YYYY‐MM‐DD Sex The concept describing the biological traits that distinguish the males and females of a species. M = Male F = Female Date Most Recently Enrolled in US YYYY‐MM‐DD *expected length = 10 YYYY‐MM‐DD StateField1 (Date Most Recently Enrolled in US YYYY‐MM‐DD) AmericanIndianOrAlaskaNative 17 278 278 1 Asian R 18 279 279 1 BlackOrAfricanAmerican S 19 280 280 1 STU Import Update‐able Y Y Y Y The grade level of a student when assessed. 03 = Third grade 04 = Fourth grade 05 = Fifth grade 06 = Sixth grade 07 = Seventh grade 08 = Eighth grade 09 = Ninth grade HispanicOrLatinoEthnicity Q A‐Z 0‐9 . ‐ ' (Standard Apostrophe) Embedded Spaces Blank Birthdate Student Registra on Admin level demographics GradeLevelWhenAssessed O A full legal middle name given to a person at birth, baptism, or through legal change. Expected Values An indication that the person traces his or her origin Y = Yes or descent to Mexico, Puerto Rico, Cuba, Central and N = No South America, and other Spanish cultures, regardless Blank of race. A person having origins in any of the original peoples Y = Yes of North and South America (including Central N = No America), and who maintains cultural identification Blank through tribal affiliation or community attachment. A person having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian Subcontinent. This area includes, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam. A person having origins in any of the black racial groups of Africa. Version 1: May 5, 2016 Y = Yes N = No Blank Y = Yes N = No Blank Y Y Y Y Y Column Field Start Position End Position Max Length Element Name Definitions NativeHawaiianOrOtherPacificIslander T 20 281 281 A person having origins in any of the original peoples Y = Yes of Hawaii, Guam, Samoa, or other Pacific Islands. N = No Blank 1 White U 21 282 282 1 V 22 283 283 1 A person having origins in any of the original peoples Y = Yes of Europe, Middle East, or North Africa. N = No Blank Discussions that a another race would be added to the federal race list. Any data entered into filler field will be ignored on import A person having origins in any of more than one of the racial groups. Y = Yes N = No Blank EnglishLearner (EL) English Learner (EL) Y = Yes N = No Blank TitleIIILimitedEnglishProficientParticipationStatus (Optional for Colorado) An indication that a limited English proficient (LEP) student is served by an English language instruction educational program supported with Title III of ESEA funds An indication that the student is participating in and served by a Gifted/Talented program. Filler TwoOrMoreRaces W X 23 24 284 285 284 285 1 1 Expected Values STU Import Update‐able Y Y N Y Y Y 25 286 286 1 GiftedandTalented Z 26 287 287 1 MigrantStatus AA 27 288 288 1 EconomicDisadvantageStatus AB 28 289 289 1 Y = Yes N = No Blank Y = Yes N = No Blank Persons who are, or whose parents or spouses are, Y = Yes migratory agricultural workers, including migratory N = No dairy workers, or migratory fishers, and who, in the Blank preceding 36 months, in order to obtain, or accompany such parents or spouses, in order to obtain, temporary or seasonal employment in agricultural or fishing work (A) have moved from one LEA to another; (B) in a state that comprises a single LEA, have moved from one administrative area to another within such LEA; or (C) reside in an LEA of more than 15,000 square miles, and migrate a distance of 20 miles or more to a temporary residence to engage in a fishing activity. An indication that the student met the State criteria Y = Yes for classification as having an economic disadvantage. N = No Blank Version 1: May 5, 2016 Y Y Y Y Column Field Start Position End Position Max Length Element Name StudentWithDisabilities AC 29 290 292 3 PrimaryDisabilityType AD 30 293 295 3 StateField2 (Homeless) AE 31 296 315 32 316 335 Expected Values IEP If a student has a disability and an IEP, they are automatically covered by Section 504. If a student has 504 an IEP and needs academic interventions, this should N = No be included in their IEP. The IEP is required to address Blank ALL of a student’s needs that are related to the disability. ‐ See more at: http://www.wrightslaw.com/blog/?p=122#sthash.J6J gIx6v.dpuf The major or overriding disability condition that best AUT = Autism describes a person's impairment. DB = Deaf‐blindness DD = Developmental delay EMN = Emotional disturbance HI = Hearing impairment ID = Intellectual Disability MD = Multiple disabilities NC ‐ Not Collected OI = Orthopedic impairment OHI = Other health impairment SLD = Specific learning disability SLI = Speech or language impairment TBI = Traumatic brain injury VI = Visual impairment Blank Flag if the student meets the criteria of a homeless individual according to the 2001 McKinney‐Vento reauthorization Act. 20 StateField3 (Language Background) AF Definitions Student's language background. 20 Version 1: May 5, 2016 0 = No 3 = Yes and is in the physical custody of a parent or guardian 4 = Yes and is not in the physical custody of a parent or guardian (unaccompanied youth) Three digit language Code 000 = N/A Blank Valid values listed in the Language Background Code List available at: http://www.cde.state.co.us/DataPip eline/org_language_codes.asp STU Import Update‐able Y Y Y Y Column Field Start Position End Position Max Length Element Name StateField4 (Language Proficiency) AG 33 336 355 20 StateField5 (Bilingual) AH 34 356 375 35 376 395 AJ 36 396 415 This one digit field indicates whether the student is currently enrolled in a bilingual program, is in the monitoring period, or is exited. This one‐digit field indicates whether the student is currently enrolled in an English as a Second Language program, is in the monitoring period, or is exited. 20 StateField7 (Title 1) Expected Values Blank A student's English language proficiency is described by his or her ability to speak, to listen, 0 = Not Applicable to read, and to write in English. English Learners 1 = NEP ‐ Non English Proficient 2 = LEP ‐ Limited English Proficient (ELs) must have an English Proficiency rating 3 = FEP ‐ Fluent English Proficient entered (1, 2, or 3), and non‐EL students must 4 = PHLOTE ‐ English Proficient be coded as 0 or 4. Former ELs should be coded 5 = FELL ‐ Former ELL as 5. 20 StateField6 (ESL Status) AI Definitions Student receives Title 1 funding 20 0 = No 1 = Yes 2 = Re‐designated Monitored Y1 3 = Re‐designated Monitored Y2 4 = Exited Y3 5 = Not in Bilingual Program, Parent Choice Blank 0 = No 1 = Yes 2 = Re‐designated Monitored Y1 3 = Re‐designated Monitored Y2 4 = Exited Y3 5 = Not in ESL Program, Parent Choice Blank STU Import Update‐able Y Y Y 0 = No 1 = Yes Blank Y Version 1: May 5, 2016 Column Field Start Position End Position Max Length Element Name Definitions StateField8 (Immigrant) (Optional for Colorado) AK 37 416 435 Expected Values STU Import Update‐able As defined by USDE under Section 3301(6) 0 = No 1 = Yes Title III. Blank Y 20 StateField9 (Colorado Continuously) Continuous in Colorado students have been 0 = No 1 = Yes enrolled in Colorado since 10/01/2013. Blank AL 38 436 455 20 Y StateField10 (Continuous in District and School) AM 39 456 475 Continuous in district students have been enrolled in the school since 10/01/2015. 0 = No 1 = Yes Blank Y 20 Continuous in district students have been enrolled in the district since 10/01/2015. StateField11 (Expelled) AN 40 476 495 0 = No 1 = Expelled Blank 20 StateField12 (Colorado Spanish Language Arts Assessment – CSLA) AO AP 41 496 Test Registra onTest Level 42 516 515 20 565 50 Student is taking the CSLA for ELA ‐ limited to grades CSLA = Student is taking the 3 and 4. Colorado Spanish language arts assessment in place of the PARCC English language arts assessment Blank Y Y N Blank Version 1: May 5, 2016 Column Field Start Position End Position Max Length Element Name ClassName AQ 43 566 610 45 TestAdministrator (Not required in Colorado) AR 44 611 640 30 StaffMemberIdentifier (Not required in Colorado) AS 45 641 670 30 Definitions Expected Values In the UI the students within the same class name can A‐Z be assigned into a session. a‐z 0‐9 ‐ Students and tests are registered to a Class. ‘ (Standard Apostrophe) . Class Name would be used for class rosters for test ) results reporting. ( & / \ + embedded spaces Blank Test Administrator is the person overseeing the A‐Z student(s) in a test session. a‐z 0‐9 ‐ ‘ (Standard Apostrophe) . ) ( & / \ + embedded spaces Blank Student’s assigned teacher used for teacher level A‐Z aggregation reporting. a‐z 0‐9 ‐ This field will be used for teacher roster reports ‘ (Standard Apostrophe) within the PARCC data reporting system. . ) ( & / \ + embedded spaces Blank Version 1: May 5, 2016 STU Import Update‐able N Y Y Column Field Start Position End Position Max Length Element Name TestCode AT 46 671 677 7 AU 47 678 678 1 TestFormat Retest AV 48 679 679 1 Definitions Identifier assigned to the test name. Paper = Paper Based Testing (PBT) Online = Computer Based Testing (CBT) Indicates if this registration is for a retest (retake). Retest can occur if a student failed a prior attempt and is eligible to retake. Other retest scenarios also can occur. Expected Values Spring 2016 MAT03 MAT04 MAT05 MAT06 MAT07 MAT08 ALG01 ALG02 GEO01 MAT1I MAT2I MAT3I ELA03 ELA04 ELA05 ELA06 ELA07 ELA08 ELA09 ELA10 ELA11 P = Paper Based Testing O = Computer Based Testing Y = Yes N = No STU Import Update‐able N N Y PARCC Assessment Need PlanTest Level ELAccommodation AW 49 680 680 1 English language learner accommodations needed for Y = Yes a given assessment. Blank This field will be used for cross validation on the PNP file for all EL accommodations and accessibility features Y Administration Considerations FrequentBreaks AX 50 681 681 1 AY 51 682 682 1 SeparateAlternateLocation Student is allowed to take breaks, at their request, during the testing session. Y = Yes Blank Y Student tested in specially assigned location. Y = Yes Blank Y Version 1: May 5, 2016 Column Field Start Position End Position Max Length Element Name SmallTestingGroup AZ 52 683 683 1 SpecializedEquipmentOrFurniture BA 53 684 684 1 BB 54 685 685 1 BC 55 686 686 1 SpecifiedAreaOrSetting TimeOfDay BD Definitions Expected Values Student is tested in a separate location with a small Y = Yes group of students with matching accessibility features Blank or accommodations/testing needs as appropriate. Check individual state policies on the maximum number of students that are allowed in a small testing group. Y = Yes Student is provided specialized equipment or furniture needed for a successful testing environment Blank (e.g., low lighting; adaptive seat; etc.) Student is tested in a specialized area or setting (e.g., front of the classroom; seat near the door, library observation room etc.) Student is tested during a specific time of day based on their individual needs (e.g., ELA/l in the morning; no testing after lunch; etc.) Y = Yes Blank Y = Yes Blank Accessibility Features Identified in Advance (These accessibility features are available to all students and not limited to students with disabilities or English learners.) Y = Yes AnswerMasking Used to assign this accessibility feature for online Blank testing. By default, answer choices for multiple‐choice items 56 687 687 1 are covered when the item is first presented. The student has the ability to remove the masks at a time of their choosing. STU Import Update‐able Y Y Y Y N FillerField BE 57 688 688 1 N ColorContrast BF 58 689 690 Used to assign this accessibility feature for online testing. 01 = black‐cream 02 = black‐lblue 03 = black‐lmagenta The interface launches a pre‐selected alternate color 04 = white‐black 05 = yellow‐blue combination for the text (foreground) and 06 = dgray‐pgreen background colors. 07 = Color Overlay blank N 2 UI display name Black on Cream Black on Light Blue Black on Light Magenta White on Black Yellow on Blue Dark Gray on Pale Green Color Overlay Presenta on Accommoda ons for Students with Disabili es with an IEP or 504 PlanAccommoda ons from a student's personal needs profile supports presenta on accommoda ons Version 1: May 5, 2016 Column Field Start Position End Position Max Length Element Name ASLVideo BG 59 691 691 Definitions Used to assign the form administered for online testing. 1 Expected Values Y = Yes Blank STU Import Update‐able N American Sign Language content is provided to the student by a human signer through a video. AssistiveTechnologyScreenReader Used to assign the form administered for online testing. Y = Yes Blank Assistive Technology ‐ Screen Reader ‐ Screen Reader Assistive Technology Application (Examples: Jaws, NVDA) used to deliver computer‐based test form for ELA/L and Math. Delivers form tagged to support Screen Reader use. Screen Reader Application used to deliver online test form for ELA/L and Math. BH 60 692 692 1 N TestNav 8 and PARCC Assistive Technology: http://www.pearsononlinetesting.com/TestNav/PARC C‐AT/ Screen Reader Assistive Technology is a 3rd party external support intended for students who are blind. The Screen Reader is used for browser navigation and access to content. Examples: Jaws, NVDA. It can also be used in combination with a Refreshable Braille device for access and response. AssistiveTechnologyNonScreenReader Used to assign the form administered for online testing when an assistive technology application is needed for students without visual impairments. Y = Yes Blank Assistive Technology ‐ Non‐Screen Reader ‐ Assistive Technology Application (Examples: Co:Writer, Read&Write Gold ) used to deliver computer‐based test form for ELA/L and Math. BI 61 693 693 1 N Assistive technology that provides magnification or word prediction assistive technology support that requires security pass through to interact with TestNav TestNav 8 and PARCC Assistive Technology: http://www.pearsononlinetesting.com/TestNav/PARC C‐AT/ Version 1: May 5, 2016 Column Field Start Position End Position Max Length Element Name Definitions ClosedCaptioningForELAL BJ 62 694 694 Used to assign the form administered for online testing RefreshableBrailleDisplayForELAL 63 695 695 1 BL 64 696 696 1 Used to assign an online form for Braille in conjunction with Screen Reader. LargePrint BM 65 697 697 66 698 699 Y = Yes Blank N Student requires paper and pencil test format as an approved accommodation. Y = Yes Blank A Large Print test booklet is provided with text increased 150% to an 18 point font. Y = Yes Blank Y 02 = EBAE/English Braille American Edition Blank Y 1 Student responds in Large Print booklet and responses are transcribed. A hard copy braille test booklet is provided with embedded tactile graphics. BrailleWithTactileGraphics BN N Student uses external device which converts the text from the Screen Reader into Braille. AlternateRepresentationPaperTest STU Import Update‐able Y = Yes Blank Closed captioning and subtitling are both processes of displaying text on a television, video screen, or other visual display to provide additional or interpretive information. 1 BK Expected Values 2 Y Student responds and responses are transcribed. StudentReadsAssessmentAloudToThemselves BO BP BQ The student reads the assessment aloud to Y = Yes themselves and may use an external device such as a Blank 67 700 700 1 whisper phone. The student must be tested in a separate setting. HumanSignerForTestDirections A human signer will sign the test directions to a Y = Yes 68 701 701 1 student. The student may need to be tested in a small Blank group or separate setting. Response Accommoda ons for Students with Disabili es with an IEP or 504 PlanAccommoda ons from a student's personal needs profile supports response accommoda ons AnswersRecordedInTestBook The student records answers directly in the test book. Y = Yes Responses must be transcribed verbatim by a test Blank administrator in a student answer book or answer 69 702 702 1 sheet. Responses that have not been transcribed will not be scored. BrailleResponse BR 70 703 704 2 A student who is blind or visually impaired and their 01 = Braille Writer response is captured by a Braille Writer or Note taker. 02 = Braille Notetaker Blank Version 1: May 5, 2016 Y Y Y Y Column Field Start Position End Position Max Length Element Name CalculationDeviceAndMathematicsTools BS 71 705 705 1 ELALConstructedResponse BT BU 72 73 706 708 707 709 74 710 711 2 MonitorTestResponse BW 75 712 712 1 WordPrediction BX 76 713 713 1 Human scribe and human signer require a Unique Accommodations Request (UAR) approved by CDE. 01 = Speech‐to‐Text 02 = Human Scribe 03 = Human Signer 04 = External AT Device blank 01 = Speech‐to‐Text 02 = Human Scribe 03 = Human Signer 04 = External AT Device blank 01 = Speech‐to‐Text A student's response is captured by an external 02 = Human Scribe Speech to Text device, external AT device, Human 03 = Human Signer Scribe or Signer. 04 = External AT Device blank The test administrator or assigned accommodator Y = Yes monitors proper placement of student responses on a Blank test book/answer sheet or within a computer based test. The test examiner or assigned accommodator cannot assist the student with changing a response. ELALSelectedResponseOrTechnologyEnhancedItems A student's response is captured by an external Speech to Text device, external AT device, Human Scribe or Signer for Selected Response or Technology Enhanced items types. MathematicsResponse BV Expected Values Use of this accommodation requires a Unique Y = Yes Accommodations Request (UAR) approved by CDE. Blank The student is allowed to use a calculator as an accommodation, including for items in test sections designated as non‐calculator sections. In addition, an arithmetic table (including addition/ subtraction and/or multiplication/division charts), and/or manipulatives may be used. A student's response is captured by an external Speech to Text device, external AT device, Human Scribe or Signer for Constructed Response item types. 2 2 Definitions The student uses a word prediction external device Y = Yes that provides a bank of frequently ‐or recently ‐used Blank words as a result of the student entering the first few letters of a word. STU Import Update‐able Y Y Y Y Y Y Accommodations for English Learners (EL) BY 77 714 714 1 AdministrationDirectionsClarifiedinStudentsNativeL The test administrator clarifies general administration Y = Yes anguage instructions only. Blank Version 1: May 5, 2016 Y Column Field Start Position End Position Max Length Element Name Definitions Expected Values AdministrationDirectionsReadAloudinStudentsNativ The test administrator reads aloud, and repeats as eLanguage needed, test directions in students’ native language. BZ 78 715 717 3 CA 79 718 719 2 MathematicsResponseEL TranslationOfTheMathematicsAssessment CB 80 720 722 ARA = Arabic CHI = Chinese (Mandarin) HAT =Haitian Creole NAV = Navajo POL = Polish POR = Portuguese RUS = Russian SPA = Spanish URD = Urdu VIE = Vietnamese HT = Human Translator Blank A student's response is captured by an external 01 = Speech‐to‐Text Speech to Text device or Human Scribe. 02 = Human Scribe blank SPA = Spanish Used to assign the form administered for online testing based on another language other than English. Blank STU Import Update‐able For translated paper tests, Test Format must be P and Translation of the Mathematics Assessment must be non‐blank. 3 Y Y N For translated online tests, Test Format must be O and Translation of the Mathematics Assessment must be non‐blank. WordtoWordDictionaryEnglishNativeLanguage CC 81 723 723 1 Student uses a published word‐to‐word hand‐held dictionary. Other Accessibility Features and Accommodations Version 1: May 5, 2016 Y = Yes Blank Y Column Field Start Position End Position Max Length Element Name TextToSpeech Definitions Used to assign the form administered for online testing. Expected Values 01 = Text Only 02 = Text and graphics Blank STU Import Update‐able N Text‐To‐Speech functionality is embedded into the TestNav platform. It provides a computer read aloud of content but does not support browser navigation. It is not intended to support students who are blind. CEDS: Used as part of an Assessment Personal Needs Profile to define the type of material that should be rendered using the read aloud alternative content. CD 82 724 725 Audio guideline will have definitions of the inclusion orders of Text Only and Text Plus Graphics. I did not see an overall description in the Audio guidelines. There were rules for text, symbols and visuals. 2 Text only to text plus graphics can be changed after a test is started by administrator by exiting test, updating value and logging back into test. For ELA, students With Disability populated with “IEP” and must have a Unique Accommodation Request (UAR) approved by CDE HumanReaderOrHumanSigner CE 83 726 727 2 Used to assign the Proctor Testing Tickets by assigning the session as a Read Aloud in PearsonAccessnext The same test form will appear for the Proctor to Read Aloud or Sign the test to the student. For paper tests a second test book will be shipped for the Proctor to Read Aloud or Sign the test to the student. For ELA, sStudents With Disability populated with “IEP”, and must have a Unique Accommodation Request (UAR) approved by CDE Version 1: May 5, 2016 01 = Human Signer 02 = Human Read Aloud Blank Y Column Field Start Position End Position Max Length Element Name Definitions UniqueAccommodation CF 84 728 728 An accommodation required for a student with a disability or an English Learner could potentially violate the construct of the assessment or that are not specified in the accommodations manuals and may be perceived as providing an advantage. Expected Values Y = Yes Blank STU Import Update‐able Y 1 Use of a unique accommodation must be approved by CDE. Unique accommodation requests must be submitted to CDE by December 15th. EmergencyAccommodation CG 85 729 730 2 Timing and Scheduling Accommodations for English Learners and Students with Disabilities ExtendedTime CH 86 731 736 6 01 = Human Scribe An emergency accommodation for a student who incurs a temporary disabling condition that interferes 99 = Other Blank with test performance shortly before or during the PARCC assessment window. Y Extended Time is provided to the student. EL IEP504 Both Blank Y System generated unique identifier assigned to the student test collection UUID (36 characters max) Post Test Attempt Data CI 87 737 772 36 CJ CK CL 88 89 90 773 791 841 790 840 847 18 50 7 CM 91 848 850 3 CN 92 851 851 1 CO 93 852 854 3 CP CQ CR CS CT CU CV CW CX CY CZ DA DB DC DD 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 855 857 859 861 863 865 867 869 871 907 925 927 929 965 983 856 858 860 862 864 866 868 870 906 924 926 928 964 982 984 2 2 2 2 2 2 2 2 36 18 2 2 36 18 2 StudentTestUUID Filler Filler Filler TotalTestItems TestAttemptednessFlag TotalTestItemsAttempted N N N Total number of questions/items on a administered test Flag indicating the test attempt has met the PARCC test attempt criteria with 1 item in each of n‐1 units/paper sections Total number of items attempted on the test 000 ‐ 999 Blank Y N Blank 000 ‐ 999 Blank N N N N N N N N N N N N N N N N N N Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative Version 1: May 5, 2016 Column DE DF DG DH DI DJ DK DL DM DN Field Start Position End Position Max Length 109 110 111 112 113 114 115 116 117 985 987 1023 1041 1043 1045 1081 1099 1101 986 1022 1040 1042 1044 1080 1098 1100 1102 2 36 18 2 2 36 18 2 2 118 1103 1103 Element Name Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative Filler for summative NotTestedCode 1 NotTestedReason DO 119 1104 1105 2 VoidScoreCode DP 120 1106 1106 1 VoidScoreReason DQ 121 1107 1108 2 Definitions Expected Values STU Import Update‐able N N N N N N N N N Definition: Flag for Not Tested Reason Y Blank Not Tested flag cannot be present on a student assigned in an online session. Although any paper test attempts could have the Not Tested code and reason present. PA Next Operational Report_Test Attempts with Not Tested Reason_ Code provides a view to identify any paper test attempts which should have the Not Tested Code and Not Tested Reason removed. 00 = Absent 01‐10 01 = Not Tested Reason 1 Blank 02 = Not Tested Reason 2 03 = Not Tested Reason 3 04 = Not Tested Reason 4 05 = Not Tested Reason 5 06 = Not Tested Reason 6 07 = Not Tested Reason 7 08 = Not Tested Reason 8 09 = Not Tested Reason 9 Definition: Y Flag for voiding the test attempt score. Blank 01 = Void Score Reason 1 02 = Void Score Reason 2 03 = Void Score Reason 3 04 = Void Score Reason 4 05 = Void Score Reason 5 06 = Void Score Reason 6 07 = Void Score Reason 7 08 = Void Score Reason 8 09 = Void Score Reason 9 10 = Void Score Reason 10 Version 1: May 5, 2016 Y Y Y 01‐10 Blank Y Column Field Start Position End Position Max Length Element Name ShipReportDistrictCode DR 122 1109 1123 15 ShipReportSchoolCode Definitions The district where the Individual Student Report is to A‐Z be shipped. If left blank, then Responsible District will 0‐9 be the ship to location. This District Code must match Blank an existing District Organization Code in PearsonAccessnext. *Expected character length = 4 The school where the Individual Student Report is to A‐Z be shipped. If left blank, then Responsible School will 0‐9 be the ship to location. This School Code must match Blank an existing School Organization Code in PearsonAccessnext. *Expected character length = 4 Expected Values STU Import Update‐able Y Y DS 123 1124 1138 15 DT 124 1139 1139 1 Filler N DU 125 1140 1140 1 Filler N DV 126 1141 1141 1 Filler ReportSuppressionCode Only updateable by CDE DW 127 1142 1143 2 N Error and reject record if invalid value. 01‐10 Cross Validation: If Report Suppression Action is non‐ Blank blank, then Report Suppression Code must be non‐ blank, else error. 01 = Report Suppression Code reason 1 02 = Report Suppression Code reason 2 03 = Report Suppression Code reason 3 04 = Report Suppression Code reason 4 05 = Report Suppression Code reason 5 06 = Report Suppression Code reason 6 07 = Report Suppression Code reason 7 08 = Report Suppression Code reason 8 09 = Report Suppression Code reason 9 10 = Report Suppression Code reason 10 Version 1: May 5, 2016 N Column Field Start Position End Position Max Length Element Name Definitions ReportSuppressionAction Only updateable by CDE DX 128 1144 1145 2 Record field that can be updated and re‐imported 00‐06 01 = The student record will not receive an Individual Blank Student Report (ISR), will not be included in the Roster Report and will not be included in Aggregate reports (Growth and Performance views for School, State, District or PARCC). 02 = The student record receives an Individual Student Report (ISR) with a summative score and the student record is included on the Roster Report with a summative score. The student is excluded from all Aggregate reports (Growth and Performance views for School, State, District or PARCC). 03 = The student record will be included on the Roster Report but the summative score will be n/a. The student record will not receive an Individual Student Report (ISR) and the student record is excluded from all Aggregate reports (Growth and Performance views for School, State, District or PARCC). 04 = The student record is included in all Aggregate reports (Growth and Performance views for School, State, District or PARCC). The student record does not receive an Individual Student Report (ISR) and is excluded from the Roster Report. 05 = The student record only receives an Individual Student Report (ISR). The student record is excluded from the Roster Report and all Aggregate reports (Growth and Performance views for School, State, District or PARCC). 06 = The student record only receives an Individual Student Report (ISR). The student record is included in the Roster Report but excluded in school Aggregate reporting (Growth and Performance Expected Values STU Import Update‐able N Summative Report fields DY 129 1146 1164 19 DZ 130 1165 1183 19 EA 131 1184 1202 19 EB 132 1203 1221 19 EC 133 1222 1240 19 ED 134 1241 1259 19 Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Version 1: May 5, 2016 N N N N N N Column Field Start Position End Position Max Length EE 135 1260 1278 19 EF 136 1279 1297 19 EG 137 1298 1316 19 EH 138 1317 1325 9 EI 139 1326 1333 8 EJ 140 1334 1368 35 EK 141 1369 1370 2 EL 142 1371 1390 20 EM 143 1391 1392 2 EN 144 1393 1452 60 EO 145 1453 1512 60 EP 146 1513 1514 2 EQ 147 1515 1574 60 ER 148 1575 1634 60 Element Name Definitions Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Expected Values STU Import Update‐able N N N N N N N N N N N N N N Score data ES 149 1635 1637 3 ET 150 1638 1640 3 EU 151 1641 1643 3 EV 152 1644 1646 3 EW 153 1647 1649 3 Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Version 1: May 5, 2016 N N N N N Column Field Start Position End Position Max Length EX 154 1650 1659 10 EY 155 1660 1662 3 EZ 156 1663 1667 5 FA 157 1668 1668 1 FB 158 1669 1671 3 FC 159 1672 1676 5 FD 160 1677 1681 5 FE 161 1682 1684 3 FF 162 1685 1685 1 FG 163 1686 1686 1 FH 164 1687 1687 1 FI 165 1688 1688 1 FJ 166 1689 1689 1 FK 167 1690 1690 1 FL 168 1691 1695 5 FM 169 1696 1700 5 FN 170 1701 1705 5 FO 171 1706 1710 5 FP 172 1711 1715 5 Element Name Definitions Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Fields used in Summative File Export only. Version 1: May 5, 2016 Expected Values STU Import Update‐able N N N N N N N N N N N N N N N N N N N