Kindergarten Assessment - Approaches to Learning File

Contents

Introduction

The Kindergarten Assessment – Approaches to Learning File generates a list of enrolled Kindergarten students during the selected date range. It includes in the results details for Approaches to Learning Assessments completed during the date range.

The report may be run at the district or school level.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] and [ReEnrollments] tables based on the following criteria:

Students active, in-full or in-part, between the Start Date and End Date.
The student enrollment record’s grade level is Kindergarten.
The student's school must not be excluded from state reporting.
The student must not be excluded from state reporting.

Assessment Selection

The report selects records from the [S_OR_STU_ KAsmtItemRspns _C] based on the following criteria:

The Assessment Administration Date is between the Report Start Date and Report End Date.
The associated student had an active Kindergarten enrollment corresponding with the Assessment Administration Date.
The Assessment Type is “Approaches to Learning”.

Back to Top

Report Input

To generate the Kindergarten Assessment – Early Mathematics File, do the following:

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools*	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Students to Include*	Indicate which students to include in the report by selecting one of the following options: Use Current Selection – Run the report for students in the current selection. Don’t Use Current Selection – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Report Start Date	The start of the date range to select students and assessments.
Report End Date	The end of the date range to select students and assessments.

Back to Top

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.

Item #	Data Element	Description	[Table]FieldName	Data Type	Field Length
This report is a student-level Consolidated Collections report using the “core fields query” to gather student details and assure consistent data submissions to ODE. SEE THE SSID REPORT OUTPUT FOR A LISTING OF THE CORE ELEMENTS OF THIS STUDENT-LEVEL CONSOLIDATED COLLECTION REPORT.
57	Assessment Attempt Code	Code describing the attempt made to complete the assessment.	[S_OR_STU_KAsmtItemRspns_C]AsmtAtmptCd	Char	1
58	Assessment Administration Code	Code describing circumstances around the assessment, including the reason a student did not participate.	[S_OR_STU_KAsmtItemRspns_C]AsmtAdmnCd	Char	1
59	Assessment Administration Date	Date the assessment was administered to the student.	[S_OR_STU_KAsmtItemRspns_C]AdmnDt	Datetime	8
60	Item 1 Response	Item 1 Response	[S_OR_STU_KAsmtItemRspns_C]Item1Rspns	Char	1
61	Item 2 Response	Item 2 Response	[S_OR_STU_KAsmtItemRspns_C]Item2Rspns	Char	1
62	Item 3 Response	Item 3 Response	[S_OR_STU_KAsmtItemRspns_C]Item3Rspns	Char	1
63	Item 4 Response	Item 4 Response	[S_OR_STU_KAsmtItemRspns_C]Item4Rspns	Char	1
64	Item 5 Response	Item 5 Response	[S_OR_STU_KAsmtItemRspns_C]Item5Rspns	Char	1
65	Item 6 Response	Item 6 Response	[S_OR_STU_KAsmtItemRspns_C]Item6Rspns	Char	1
66	Item 7 Response	Item 7 Response	[S_OR_STU_KAsmtItemRspns_C]Item7Rspns	Char	1
67	Item 8 Response	Item 8 Response	[S_OR_STU_KAsmtItemRspns_C]Item8Rspns	Char	1
68	Item 9 Response	Item 9 Response	[S_OR_STU_KAsmtItemRspns_C]Item9Rspns	Char	1
69	Item 10 Response	Item 10 Response	[S_OR_STU_KAsmtItemRspns_C]Item10Rspns	Char	1
70	Item 11 Response	Item 11 Response	[S_OR_STU_KAsmtItemRspns_C]Item11Rspns	Char	1
71	Item 12 Response	Item 12 Response	[S_OR_STU_KAsmtItemRspns_C]Item12Rspns	Char	1
72	Item 13 Response	Item 13 Response	[S_OR_STU_KAsmtItemRspns_C]Item13RspnsItem11Rspns	Char	1
73	Item 14 Response	Item 14 Response	[S_OR_STU_KAsmtItemRspns_C]Item14Rspns	Char	1
74	Item 15 Response	Item 15 Response	[S_OR_STU_KAsmtItemRspns_C]Item15Rspns	Char	1
75	Assessment Administration Notes	Additional assessment administration information.	[S_OR_STU_KAsmtItemRspns_C]AdmnCmnt	Varchar	500

Back to Top