Q - Student Growth File 2020-2021

Introduction

The Student Growth File captures information regarding academic growth for students participating in the Learning Assistance Program (LAP). Districts are required to report to OSPI the amount of academic growth gained by students participating in the LAP English Language Arts (program code 37), LAP Math (program code 6), LAP Academic Readiness (program code 7), and LAP Behavior (program code 38).

Districts are also required to report student entrance and exit assessment data as well as the services used to support LAP students. There should be one record per student per LAP enrollment for the current school year. For example, if a student enters, exits, and re-enters a program, there will be two records reflecting two separate enrollments in the program. If a student is participating in or received services for more than one program, there should be a record for each program.

Selection Criteria

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

Student Program Selection

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

The student's school enrollment must be within the current school year:

1. The student's school Entry Date must be on or before the last day of the current term.
2. The student's school Entry Date must be on or before the current date.
3. The student's school Exit Date must be on or after the first day of the current term.
4. The student must not be excluded from state reporting.
5. The student must not be excluded from CEDARS reporting.
6. The student's school must not be excluded from state reporting.

The program enrollment must be within the current school year:

1. The Program Start Date must be on or before the last day of the current school year.
2. The Program Start Date must be on or before the current date.
3. The Program End Date must be on or after the last day of the current school year.

The Qualification Code for the program enrollment must be populated.

Report Input

For help with report navigation and generation, 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. The All Schools option is only available when running the report from the District Office.
Current Selection Students	Indicate which students to include in the report by selecting one of the following options: The Selected [Number] Students Only – Run the report for students in the current selection. All Students – Run the report for all students in the current school or district that meet the selection criteria. If you are running the report for a single student, or a group of students, select the students before running the report.
School Year	Choose the year for which to run the report.
Scheduling	Select Schedule to run the report on a specific date and time. Default is Run Now.

Report Output

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

Item	Data Element	Description	[Table]FieldName	Reqd	Field Type	Length
Q01	School Year	The four-digit year in which the school year ends.	[Terms]LastDay	Yes	Char	4
Q02	Serving County District Code	The County District code for the district submitting the data.	[Prefs]Value [Prefs]Name=districtnumber	Yes	Char	5
Q03	District Student ID	The locally assigned student identifier.	[Students]Student_Number	Yes	VarChar	50
Q04	State Student ID (SSID)	The identifier assigned to each WA public school student by OSPI. Rule: This field is not required if the student has not yet been assigned an SSID.	[Students]State_StudentNumber	Con	Char	10
Q05	Location ID	The Location ID for the school. The school number is reported.	[Schools]School_Number	Yes	VarChar	4
Q06	Program Code	The State assigned LAP program code.	[S_WA_STU_SpecialPrograms_C]programCode	Yes	Numeric
Q07	Program Start Date	The date the student begins receiving services in the format MM/DD/YYYY.	[S_WA_STU_SpecialPrograms_C]startDate	Yes	Date	8
Q08	Identification Assessment	The assessment identified is the measure that most heavily influences the identification of student eligibility for LAP services. Refer to the CEDARS Data Manual and Appendices for a list of valid values.	[S_WA_STU_LAPINFO_C]IdentificationAssessment	Yes	Numeric	2
Q09	Amount of Academic Growth	The amount of academic growth gained by students participating in the LAP.	[S_WA_STU_LAPINFO_C]AcademicGrowth	Con	Numeric	2
Q10	Progress Monitoring Assessment	The assessment used to monitor student progress.	[S_WA_STU_LAPINFO_C] ProgressMonitoringAssessment	Con	Numeric	2
Q11	Beginning Score	The raw score or scale score from the progress monitoring assessment. Report the scale score rather than the raw score unless a scale score is not available.	[S_WA_STU_LAPINFO_C]BeginningScore	Con	Numeric
Q12	Date of Beginning Score	The date that the initial progress monitoring assessment was given in the format MM/DD/YYYY.	[S_WA_STU_LAPINFO_C]DateBeginning	Con	Date	8
Q13	End Score	The raw score or scale score from the progress monitoring assessment. Report the scale score rather than the raw score unless a scale score is not available.	[S_WA_STU_LAPINFO_C]EndScore	Con	Numeric
Q14	Date of End Score	The date that the final progress monitoring assessment was given in the format MM/DD/YYYY.	[S_WA_STU_LAPINFO_C]DateEnd	Con	Date	8
Q15	Extended Learning Time Intervention	Extended day learning occurs outside the required basic education allotted time period and can include before-school hours, after-school hours, on Saturdays, and during the summer. For students who receive multiple extended learning time interventions, please select the primary intervention. Valid Values: BA – Before/After school instruction HC – Homework Club BP – Book Programs CI – Computer-Based or Online Instruction SP – Saturday Programs NE – No Extended Learning Programs offered O – Other	[S_WA_STU_LAPINFO_C]ExtendedLearningTime	Con	VarChar	2
Q16	Tutoring Intervention	Tutoring includes any interaction with a trained adult or peer using an intervention program or practice that addresses students’ unique academic needs during the regular school day.	[S_WA_STU_LAPINFO_C]Tutoring	Con	VarChar	4
Q17	Student Met Learning Goal	Based on assessment(s) and/or progress monitoring, it was determined that the student no longer needed supplemental education services to meet standards in the general education classroom. The student is eligible to exit LAP (but does not necessarily need to be exited from CEDARS).	[S_WA_STU_LAPINFO_C]MetLearningGoal	Con	VarChar	1