Skip to main content
Skip table of contents

Q - Student Growth File 2023-2024

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), LAP Behavior (program code 38), and Washington Reading Corps Literacy Support (program code 44)

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 receiving 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 the 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. The default selection 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.

6 – LAP Math
7 – LAP Academic Readiness
37 – LAP English Language Arts
38 – LAP Behavior
44 – Washington Reading Corps Literacy Support

[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

  • MA – Mentoring by an adult

  • MP – Mentoring by a peer

  • FE – Family Engagement Services

  • CP – Community Partners

  • EL – Specialized Literacy Instruction for ELs

  • BH – Behavioral Health

  • BM – Behavior Support and Monitoring

  • RJ – Restorative Justice

  • SI – Social Skills Instruction

  • DL - Dual Language

[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.

Note: The code "DL - Dual Language" is also available as part of the valid list of values. 

[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


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.