District Testing Record (DT) (Ohio Extracts)

Tool Search: OH Extracts

The Ohio District Testing (DT) Extract collects head count information on district-wide assessments beyond those required by the state. One record per test per grade level is reported if the reported test is administered to an entire grade level within the district. This only applies to non-state tests and should not be reported for grade levels considered optional in receiving the test.

One record will report per test if the Test Type = District Test, the Parent Test = (no parent), the Test Grade Level is not null, the Test Code is not null and at least one student has a test date within the selected calendar.

Screenshot of the district testing record extract editor.
Image 1: Ohio District Testing Extract

Report Logic

  • Reports one record per test per grade level if the test is given to an entire grade level in the district. This extract applies to only non-state tests. If the only rests that the district administers to grades K-12 or all students in particular grade levels are the Ohio's Achievement and Graduation Tests, KRA-L or the Ohio Test of English Language Acquisition, a single record should be manually created by the district with "NT" in the grade level field and a Local Assessment Number of the district's choice.
  • If a test is required for students in one grade level but required for students in another, only reports a record for the required grade level.
  • Tests administered over multiple calendars are aggregated into one record per test.

Report Editor

The following table describes the options available in the extract editor.

Editor Field

Description

Extract Type

The type of extract being generated. In this case, select District Testing (DT).

Reporting Period

Indicates when the report is being submitted.

Date Range

The dates which determine which student enrollments will appear on the report, based on the Start and End Dates of enrollments within the selected calendar(s). These fields are auto-populated with a recommended date range based on the Reporting Period selected.

Format

The format in which the report will generate. Options are State Format (Fixed width), HTML, CSV and XML. Use HTML, CSV or XML formats for data review and verification and State Format for submission to the State.

Ad hoc Filter

Although it appears, this functionality is not available for this report.

Calendar(s)

Students enrolled in the selected calendar(s) will appear in the report.

Generating the Extract

  1. Select District Testing (DT) as the Extract Type.
  2. Select the Reporting Period.
  3. Enter a Date Range in mmddyyyy format or by clicking the calendar icon and selecting a date.
  4. Select the Format in which the report should generate.
  5. Do not select an Ad hoc Filter. Although this field appears available, Ad hoc functionality has not been implemented for the District Testing Record.
  6. Indicate which Calendar(s) should be included in the report.
  7. Click Generate Extract to generate the report in the indicated format or Submit to Batch to schedule when the report will generate. If generating multiple extracts at a time (after Campus.1921), requests can only be submitted to the Batch Queue.

Users have the option of submitting a District Testing Record report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Extract Layout

 

Element Name

Description & Format

Campus Location

Filler1

 

 

Filler2

 

 

Sort Type

Reports as DT for this extract.


Alphanumeric, 2 characters

OH State Reporting > OH Extracts > Extract Type > District Testing Record (DT)

Filler3

 

 

Fiscal Year

The end year of the reporting school year.


Date field, 4 digits, YYYY

System Administration > Calendar > School Year > End Year


Calendar.endYear

Reporting Period

The Reporting Period selected in the extract editor.


Alphanumeric, 1 character

OH State Reporting > OH Extracts > District Testing Record (DT) > Reporting Period


Not dynamically stored

District IRN

The state-assigned information retrieval number (IRN) of the district.


Numeric, 6 characters

System Administration > Resources > District Information > State District Number


District.number

Grade Level Assessed

The grade level of assessed students.


Alphanumeric, 2 characters

Assessment > Test Setup > Tests > Test Detail > Test Grade Level


Test.testGrade

Local Assessment Number

The locally-determined assessment number. Reports the Test Grade Level and a sequence identifier (0, 1, 2, etc.). For example, the first test for Test Grade Level 01 would report as 010. If the Test Grade Level is IN, PS or KG, use 00 as the grade level.


Numeric, 3 digits

Assessment > Test Setup > Tests > Test Detail > Code


Test.code

Number of Students Taking the Exam

The number of students who were administered the exam.

Field logic determines the number of students taking the exam when the student grade level = Test Grade Level and the test date is within the current calendar year.

If the Score Not Reported field contains any value other than *, the student will not be counted.


Numeric, 4 digits

Student Information > General > Enrollments > Grade AND Student Information > General > Assessments > Tests > Test Score Detail > Score Not Reported AND Assessment > Test Setup > Tests > Test Detail > Test Grade Level


Enrollment.grade
TestScore.nonParticipationReason
Test.testGrade

Assessed Student With Disabilities Headcount

The number of students with disabilities within the assessed grade level administered the assessment.

Field logic determines this number based on students whose grade level = Test Grade Level, the test date falls within the calendar year and who have a Disability Condition that is not null.

If the Score Not Reported field contains any value other than *, the student will not be counted.


Numeric, 4 digits

Student Information > General > Enrollments > Grade AND Student Information > General > Enrollments > Special Education Fields > Disability Condition AND Student Information > General > Assessment > Test Score Detail > Date and Score Not Reported AND Assessment > Test Setup > Tests > Test Detail > Test Grade Level


Enrollment.disability1
TestScore.nonParticipationReason
Test.testGrade

Administered with Accommodations

Indicates if accommodations/modifications were available for students with disabilities.

Field logic includes only students whose grade level equals the Test Grade Level, the test date is within the current calendar year and have a Type of Accommodation set to Y1, Y2, Y3 or Y4.

If the Score Not Reported field contains any value other than *, the student will not be counted.


Alphanumeric, 1 character, Y or N

Assessment > Test Setup > Tests > Test Detail > Received Accommodations AND Student Information > General > Assessment > Test Score Detail > Type of Accommodation


TestScore.receivedAccommodation
TestScore.accommodation

Accommodations Headcount

The number of students with disabilities who took the assessment with accommodations.

Field logic includes only students whose grade level equals the Test Grade Level, the test date is within the current calendar year, have a Disability Condition that is not null and have a Type of Accommodation set to Y1, Y2, Y3 or Y4.


Numeric, 4 digits

Student Information > General > Enrollments > Grade AND Student Information > General > Enrollments > Special Education Fields > Disability Condition AND Student Information > General > Assessment > Test Score Detail > Received Accommodations, Type of Accommodation, Date, Score Not Reported AND Assessment > Test Setup > Tests > Test Detail > Test Grade Level


Enrollment.grade
Enrollment.disability1
TestScore.receivedAccommodation
TestScore.accommodation
TestScore.nonParticipationReason
Test.testGrade

Alternate Assessments Provided

Indicates if alternate assessments were available for students with disabilities who cannot participate regardless of accommodations.

A value of Y will report if the student’s grade level is equal to the Test Grade Level, the test date is within the current calendar year and the Required Test Type is set to ALT.


Alphanumeric, 1 character, Y or N

Assessment > Test Setup > Tests > Test Detail > Assessment Type AND Student Information > General > Assessment > Test Detail > Required Test Type, Date


Test.assessmentType
TestScore.modification

Alternate Assessment Headcount

The number of students with disabilities who took an alternate assessment.

This field reports the total sum of all students whose grade level equals the Test Grade Level, the test date falls within the current calendar year, the Disability Condition is not null and the Required Test Type is set to ALT.


Numeric, 4 digits

Student Information > General > Enrollments > Grade AND Assessment > Test Setup > Tests > Test Detail > Test Grade Level AND Student Information > Special Education > Documents > Enrollment Status > Primary Disability OR Student Information > General > Enrollments > Special Education Fields > Primary Disability Status AND Student Information > General > Assessment > Test Score Detail > Date, Score Not Reported and Required Test Type


Enrollment.grade
Test.testGrade
Enrollment.disability1
TestScore.modification
TestScore.nonParticipationReason

Filler