📄 Identifier Data Tables V2

Data Tables are a fast and easy method to generate multiple data sets using basic data input selections.  Like Data Grids, Data Tables are comprehensive spreadsheets made up of data columns to present the information.

Identifier Data Tables allow you to download a list of students in a group in a CSV/Excel file.  The file may then be downloaded and distributed for additional manipulation, combined with other data, record keeping, or any other purpose.

ACCESSING DATA TABLES

Navigate to Homeroom Dashboards and select an SDS dashboard.  NOTE: See the  Homeroom Dashboards - Basic Dashboard Navigation help article for instructions on accessing various dashboards.

Scroll to the bottom of your dashboard to find the Create Data Extracts Container and select your chosen Data Table.

Alternatively, Data Tables may be accessed by navigating the Data Tables App within the Data Extracts Bundle and clicking Create Data Table from the left-hand navigation menu. 

Next, select Browse Category from Data Extracts, search for your chosen Data Table, and select Build Table.

504 PLANS

Download a spreadsheet to view 504 plans by the student group.

Select a Student Group (optional) and School Year (optional), then click Save and Generate to Save & Name OR click the Actions Gear to Download the Data Table.

ADDITIONAL UNIQUE IDENTIFIER LIST

Download a spreadsheet to view another unique identifier list by student group.

Choose Selections:

• Student - Birth Date, Grad Requirement Base Year, Email Address, Primary Mailing Address, Primary Physical Address, Advisor
• Identifiers - Student ID, SSID, External Application ID, Other ID
• Current Enrollment - Grade Level, Predominant School, Currently Enrolled Status, Current GPA, Earned Credits, Failed Credits
• Demographics - Gender, Federal Ethnicity/Race, Other Races, Student Languages, Native Language, Home Language
• Services - 504, Bilingual Education, Gifted, LAP Language Arts, LAP Math, LAP Reading, Special Education, Title 1 Reading
• Risk - Current Gradebook D’s and F’s, Days Absent Past 14 Days, HS Credits-On Track for Graduation, MS Missing Assignments, Prior Year Absences, Risk Index-Elementary School, Risk Index-Middle School, Risk Index-High School, SBA Summative Mathematics

Select a Student Group, Additional Unique Identifiers (Other ID or External Application ID), and Choose Selections, then click Save and Generate to Save & Name or Download XLSX.

EMAIL ADDRESSES FOR STUDENTS 

Download a spreadsheet of email addresses associated with a student by email address type.

Select a Student Group and Email Address Type (optional), then click Save and Generate to Save & Name, Download XLSX, or Download Validation Workbook.

GUARDIAN CONTACT INFORMATION 

Download a spreadsheet of guardian contact information for a group of students.

Choose Selections:

• Student - Birth Date, Grad Requirement Base Year, Email Address, Primary Mailing Address, Primary Physical Address, Advisor
• Identifiers - Student ID, SSID, External Application ID, Other ID
• Current Enrollment - Grade Level, Predominant School, Currently Enrolled Status, Current GPA, Earned Credits, Failed Credits
• Demographics - Gender, Federal Ethnicity/Race, Other Races, Student Languages, Native Language, Home Language
• Services - 504, Bilingual Education, Gifted, LAP Language Arts, LAP Math, LAP Reading, Special Education, Title 1 Reading
• Risk - Current Gradebook D’s and F’s, Days Absent Past 14 Days, HS Credits-On Track for Graduation, MS Missing Assignments, Prior Year Absences, Risk Index-Elementary School, Risk Index-Middle School, Risk Index-High School, SBA Summative Mathematics

Select a Student Group, Prefer Mailing Address (True/False), and Choose Selections, then click Save and Generate to Save & Name or Download XLSX.

INDIVIDUAL HEALTH PLANS

Download a spreadsheet of individual health plan data for a selected student group.

Select a Student Group and School Year (optional), then click Save and Generate to Save & Name, Download XLSX, or Download Validation Workbook.

STUDENT HICAP PLANS DATA TABLE 

Download a spreadsheet of student HiCap plans data.

Select a Student Group and School Year (optional), then click Save and Generate to Save & Name, or Download XLSX.

STUDENT LEARNING PLAN PROGRESS 

Download a spreadsheet view of student learning plan progress by Student group.

Choose Selections:

• Student - Birth Date, Grad Requirement Base Year, Email Address, Primary Mailing Address, Primary Physical Address, Advisor
• Identifiers - Student ID, SSID, External Application ID, Other ID
• Current Enrollment - Grade Level, Predominant School, Currently Enrolled Status, Current GPA, Earned Credits, Failed Credits
• Demographics - Gender, Federal Ethnicity/Race, Other Races, Student Languages, Native Language, Home Language
• Services - 504, Bilingual Education, Gifted, LAP Language Arts, LAP Math, LAP Reading, Special Education, Title 1 Reading
• Risk - Current Gradebook D’s and F’s, Days Absent Past 14 Days, HS Credits-On Track for Graduation, MS Missing Assignments, Prior Year Absences, Risk Index-Elementary School, Risk Index-Middle School, Risk Index-High School, SBA Summative Mathematics

Select a Student Group, School, Student learning Plan Interventions (optional), School Year, and Choose Selections, then click Save and Generate to Save & Name.

STUDENT RACE/ETHNICITY DATA TABLE

Download a spreadsheet of student Race/Ethnicity Data using the new state race codes.

Select a Student Group (optional), click Save and Generate to Save & Name, or Download XLSX.

STUDENTS BY STUDENT GROUP 

Download a spreadsheet of student data for a student group 

Selections:

• Student - Birth Date, Grad Requirement Base Year, Email Address, Primary Mailing Address, Primary Physical Address, Advisor
• Identifiers - Student ID, SSID, External Application ID, Other ID
• Current Enrollment - Grade Level, Predominant School, Currently Enrolled Status, Current GPA, Earned Credits, Failed Credits
• Demographics - Gender, Federal Ethnicity/Race, Other Races, Student Languages, Native Language, Home Language
• Services - 504, Bilingual Education, Gifted, LAP Language Arts, LAP Math, LAP Reading, Special Education, Title 1 Reading
• Risk - Current Gradebook D’s and F’s, Days Absent Past 14 Days, HS Credits-On Track for Graduation, MS Missing Assignments, Prior Year Absences, Risk Index-Elementary School, Risk Index-Middle School, Risk Index-High School, SBA Summative Mathematics

Select a Student Group and Choose Selections, then click Save and Generate to Save & Name, or Download XLSX.

OTHER TABLES OF INTEREST

• ALE Annual Course Types
• Graduation Pathways by Student
• OSPI Pathways Appeals Waivers
• Career Planner Survey Completion Summary
• Four-Year Plan Completion
• Four-Year Plan Waivers
• Four-Year Plan Courses
• Career Planner Goals
• Service Status Data Table
• Food Restrictions

• Identifier Data Tables V2.pdf800 KB