Purpose:
All districts are required to have procedures for the identification of Native American/Alaska Native students who qualify for Title III. Students identified as Native American by having any one of the WA State Races selected and are academically at risk may qualify for Title III supplemental instructional support.
A Student Data Grid can be created to review pertinent data to determine if students are academically at risk. Some of the data points districts have used in this process are included in the directions below. These are just suggestions and can be modified per district.
What you'll need:
Student Group containing Native American Students
*See this article for directions on creating this Student Group
Create Student Data Grid:
From Homeroom, click on the application selector in the top right corner of the screen and click the Student Data Grids icon.
- Click: Create New Data Grids
- Name: 'Native American Students - Are They Struggling'
- Click the arrow next to the Save button and choose 'Save & Continue'
Column Configuration
This brings you to the Columns tab where we configure the various columns of the Data Grid. We’ll be using the following data column configurations:
Student: Name | Formula: Custom Formula |
Enrollments: Current Grade Level | Services: Services |
Demographics: Gender & Federal Race Code | Behaviors: Yearly Attendance & incident Counts |
Column headers for Native American Students - Are They Struggling:
Add Data Column - Student
SSID:
Find the Student Data Columns, look for ‘SSID’
- click [Add]
Last Name:
Find the Student Data Columns, look for ‘Name’
- click [Configure & Add]
- click ‘LastName, FirstName’ and choose LastName from the drop down list
First Name:
Find the Student Data Column, then look for ‘Name’
- click [Configure & Add]
- click ‘LastName, FirstName’ and choose FirstName from the drop down list
You should now have 3 data columns.
- click in the ‘Sort Order’ box for column 2 'Student – LastName – 1:B' and type in the number ‘1’. This will order your data grid by the students last name.
- click the Save button in the top right corner.
- Note: It’s always a good idea to save periodically to ensure the loss of Internet connectivity doesn’t loose the most recent work done.
Birthdate:
Find the Student Data Columns, look for ‘Birthdate’
- click [Add]
Add Data Column - Demographics
Gender:
Find the Demographics Data Columns, look for ‘Gender’
- click [Add]
Race/ethnicity:
Find the Demographics Data Column, then look for ‘Federal Race Code'
- click [Configure & Add]
- click the check box next to 'Federal Race Label'
- click Save
Add Data Column - Enrollments
School:
Find the Enrollments Data Column, then look for ‘Current Predominant School’
- click [Add]
- Note: If the student attends more than one school, this will provide the 'Predominant' school the student attends at the time the Data Grid is run
Grade Level:
Find the Enrollments Data Column, then look for ‘Current Grade Level’
- click [Add]
- click the Save button in the top right corner.
Add Data Column - Services
ELL Status:
Find the Services Data Column, then look for 'Services'
- click [Configure & Add]
- click the Select button to the right of Service:
Scroll through, or 'search' for the service your district uses to specify ELL.
In this instance we have chosen 'Bilingual Education' by clicking the + button to the right of the Bilingual Education service.
- click Add Services
- under Columns to Include click the box next to Status
- under Styles remove the word 'Status' and type 'ELL Status - Current'
- Note: This will be the column header title
- click Save
Services Status:
Follow the same steps used for 'ELL Status' to include the status of any service the student might be receiving. This will help to determine if the student needs services through ELL or if they are receiving services in other areas that may help. Services helpful to include: Special Education, 504, Title 1 or LAP.
Add Data Column - Assessments
Assessments:
Find the Assessments Data Column, then look for 'Assessments'
- click [Configure & Add]
- look for Set Time Span and click Current School Year and change it to Last School Year
- Note: As this Data Grid is most likely needed at the beginning of a school year, this will gather data from last year
- to the right of Assessments click the Select button
- use the filters or 'search' to find an appropriate assessment (e.g. SBA ELA)
- click the + button next to the assessments; click the Add Assessments button
- Note: Choose the assessments appropriate for the grade levels the Data Grid will be run for. In this instance, we chose SBA ELA Gr 3, 4 and 5 as the Data Grid will be run for Elementary students.
- clicking the box next to Most Recent Score will search for the most recent score for your selected Assessment(s).
- under Columns to Include: click the box next to Score
- under Styles remove the word 'Score' and replace it with 'Most Recent SBA ELA Score'
- Note: This configuration will return the most recent score the student received for any of these assessments, last year. If it is important to know which assessment the score is for, click the box next to Assessment Name under Columns to Include
- click Save
Follow these directions for adding as many assessments as needed to help make an accurate determination of the students needs.
Save data columns:
Once you have added all of the data columns, click the arrow next to the Save button and choose 'Save & Continue'
Run Student Data Grid:
To run the Data Grid for the appropriate students, the Native American student group must be created. If that has not been done, please do so now by using the directions found here.
From the Report Tab:
- click the Select Student Group button
- click the + button next to the name of the Native American student group
- type in a File Name (this is optional)
- click the Send Spreadsheet Report
An email has been sent that will allow the user to download the Student Data Grid. For more information on the email / download process read this article.
Comments
0 comments
Please sign in to leave a comment.