Indiana State Report (DOE-TL 2019)
Note: the DOE Testing Online and Barcode Report data layout can be obtained here. This file contains detailed information on the requirements and contents of the report as well as submission deadlines.
Layout Requirements
The DOE-TL (Testing Online and Barcode Report) focuses on student-level information for online testing and barcode labels for the English 10 and Algebra I ECA, ILEARN Biology ECA, ILEARN U.S. Government ECA and WIDA assessments, which includes the following fields:
- School Number
- Student Test Number (STN)
- Enrolled Grade
- Section 504 Plan or Choice Scholarship Education Plan (CSEP)
- Accommodations
- English Learner
- Test Code
In PowerSchool, the associated student fields for this report are as follows:
- School Number
- SchoolID
- Student Test Number (STN)
- State_StudentNumber
- Enrolled Grade
- Grade_Level
- Section 504
- S_IN_STU_X.Section_504_Plan_TF
- Accommodations
- S_IN_STU_X.Read_Aloud
- S_IN_STU_X.Calculator
- S_IN_STU_X.Extended_Time
- S_IN_STU_X.Large_Font
- S_IN_STU_X.Large_Print
- S_IN_STU_X.Paper_Format
- S_IN_STU_X.Braille_UEB_Contracted
- S_IN_STU_X.Braille_EBAE_Contracted
- English Language Proficiency Level
- S_IN_STU_X.ENG_Lang_Prof_Level
- Test Code
- [Courses]alt_course_number
- Note that this field value is associated with the Courses (2) table and not the Students (1) table in PoweSchool
- [Courses]alt_course_number
The field list below can be used for a Quick Export from your PowerSchool site:
SchoolID State_StudentNumber Grade_Level S_IN_STU_X.Section_504_Plan_TF S_IN_STU_X.Read_Aloud S_IN_STU_X.Calculator S_IN_STU_X.Extended_Time S_IN_STU_X.Large_Font S_IN_STU_X.Large_Print S_IN_STU_X.Paper_Format S_IN_STU_X.Braille_UEB_Contracted S_IN_STU_X.Braille_EBAE_Contracted S_IN_STU_X.ENG_Lang_Prof_Level
Report Parameters
The DOE-TL extract link can be found at the following PowerSchool page:
- System Reports > State > Testing Online and Barcode (DOE-TL) Report
On this report page, you will have the following options to select from:
- Schools to include
- Current Selection Students
- The Selected ___ Students Only
- You can make a student selection on the Start Page before running the report. For more information on how to do so see the Beginner and Intermediate articles on student selection
- All Students
- Include Only Students in Grade Levels
- Report Start and End Date
- Include Header & Students Name in Output File
- Test Type
- Filter ECA Subjects Below
- Scheduling
If you are stuck on any of the steps outlined above, please don’t hesitate to reach out and contact us!