Assessment Fact Audit

Contents

Introduction

The Assessment Fact Audit report is used to verify Assessment Fact data before running the extract. The extract is generated in a comma-delimited format.

Selection Criteria

Selection criteria determine which database records are used in the report.

Assessment Fact Audit Report Selection

The Assessment Fact Audit report includes assessment fact records from the [S_NE_STU_AssessmentFact_C] table that meet the criteria entered when running the report:

Records for the state student number entered at report runtime.
Records with the Test Date entered at report runtime.
Records with the Test Description chosen at report runtime.
Records with the Item Description entered at report runtime.
Records with the Assessment Status chosen at report runtime.
Records with the Testing Modification chosen at report runtime.
Records with the Testing Accommodation chosen at report runtime.
Records with the Assessment Accountable District status chosen at report runtime.
Records with the Assessment Accountable School status chosen at report runtime.

Report Input

For help with navigation and report generation, see Understanding the Report Output Table.

Field	Description
Data to be Filled	Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.
Process Current School Only	Choose one of the following from the pop-up menu: Yes No (default) – Indicates District Wide
Use Current Selection	Indicate which students to include in the report by selecting one of the following options: The Selected Number of Students Only All Students (default) Note: If running the report for a single student, or group of students, select the students prior to running report.
State Student Number	Enter a state assigned number to run the report for a particular student.
Test Date (MM/DD/YY)	Enter a date to run the report for tests that occurred on a particular date.
Test Description	Choose a test description from the pop-up menu to run the report for a particular type of test.
Item Description	Enter an item description to run the report for tests with a particular item description.
Assessment Status	Choose an assessment status from the pop-up menu to run the report for tests with a particular assessment status.
Testing Modification	Choose a testing modification from the pop-up menu to run the report for tests with a particular testing modification.
Testing Accommodation	Choose a testing accommodation from the pop-up menu to run the report for tests with a particular testing accommodation.
Assessment Accountable District	Choose Yes or No from the pop-up menu to run the report for students who should be considered in district-level Adequate Yearly Progress (AYP) calculations.
Assessment Accountable School	Choose Yes or No from the pop-up menu to run the report for students who should be considered in school-level Adequate Yearly Progress (AYP) calculations.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Element #	Data Element	Description	[Table]FieldName
1	State Student Number	State issued identification number	[Students]State_StudentNumber [S_NE_STU_AssessmentFact_C]foreignKey = [Students]ID
2	Student Name	The name of the student.	[Students]LastFirst [S_NE_STU_AssessmentFact_C]foreignKey = [Students]ID
3	School Number	The school number.	[S_NE_STU_AssessmentFact_C]SchoolID
4	Test Description	The name of the test, such as STARS.	[S_NE_STU_AssessmentFact_C]TestDescription
5	Assessment School Year	This value is automatically extracted as June 30^th. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms. To change terms, click Terms at the top of the page and choose a term from the list.	[S_NE_STU_AssessmentFact_C]SchoolYear
6	Item Description	The subject of the test, such as reading or mathematics.	[S_NE_STU_AssessmentFact_C]ItemDescription
7	Test Date	The date the test was taken.	[S_NE_STU_AssessmentFact_C]TestDate
8	Assessment Status	Indicates whether the student did not take the test due to a parent or medical waiver.	[S_NE_STU_AssessmentFact_C]AssessmentStatus
9	Testing Modification	Indicates if student received modifications on a majority of the standards.	[S_NE_STU_AssessmentFact_C]TestingModification
10	Testing Accommodation	Indicates if student received accommodations on a majority of the assessments.	[S_NE_STU_AssessmentFact_C]TestingAccomodation
11	Assessment Accountable District	Indicates if student should be considered in district-level Adequate Yearly Progress (AYP) calculations.	[S_NE_STU_AssessmentFact_C]AssessAccountDistrict
12	Assessment Accountable School	Indicates if students should be considered in school-level Adequate Yearly Progress (AYP) calculations.	[S_NE_STU_AssessmentFact_C]AssessAccountSchool