📄 Grades Data Tables V2

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

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

The resulting Excel can be used to track students' progress over time, assist in class placement determinations, and for additional student monitoring.

• Each term of a year (quarter, trimester, semester, etc.) for all classes within a selected content (reading, math, foreign languages). 
• Grades for a particular student group by year and subject. 
• GPA for a particular group, by percent and count.

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.

CLASS GRADES 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 Years, Subject Area (optional), and Choose Selections, then click Save and Generate to Save & Name or Download XLSX.

CLASS SUMMARY BY STUDENT GROUP 

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

CLASSROOM GRADEBOOK COURSES

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

GPA DISTRIBUTION 

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, Choose Selections, then click Save and Generate to Save & Name or Download XLSX.

GRADEBOOK GRADE

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 Year (optional), Subject Area (optional), and Choose Selections, then click Save and Generate to Save & Name or Download XLSX.

PLANNED CREDIT

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

STUDENT COURSES PASSED FAILED

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

• Grades Data Tables V2.pdf700 KB