PowerSchool Indiana State Reporting: Testing Online and Barcode Report

Contents

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

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
- Select all schools (from District Office) or a manual selection under “Select Multiple Schools”
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
- - Note: Leave all unchecked to include all grade levels
Report Start and End Date
Include Header & Students Name in Output File
- - Note: make sure that the submission method allows headers and/or student name
Test Type
- - Options: ECA, ILEARN WIDA
Filter ECA Subjects Below
- - If ECA is selected as the Test Type then a selection of English 10 and/or Algebra I must be made
Scheduling
- Select when you would like to run the report