TA - IDENTIFIERS Data Tables

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.

QUICK LINKS

ACCESSING DATA TABLES (QUICK LINKS)

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 (QUICK LINKS)

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 (QUICK LINKS)

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 (QUICK LINKS)

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 (QUICK LINKS)

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 (QUICK LINKS)

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 (QUICK LINKS)

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 (QUICK LINKS)

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 (QUICK LINKS)

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 (QUICK LINKS)

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