PowerSchool Indiana State Reporting: Testing Online and Barcode Report

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-ME 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

If you are stuck on any of the steps outlined above, please don’t hesitate to reach out and contact us!

Updated on November 26, 2018

Was this article helpful?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.