TA - ASSESSMENT Data Tables – School Data Solutions

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.

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

For example, information may help districts monitor the effectiveness of behavioral systems and note trends in specific incidents or referrals.

QUICK LINKS

ACCESSING DATA TABLES	STUDENT GROUP YEARLY GROWTH BY ASSESSMENT TEST FAMILY
ASSESSMENT TEST ITEMS	STUDENT GROWTH BY ASSESSMENT TEST LIST
STUDENT ASSESSMENTS BY STUDENT GROUP	STUDENT GROWTH BY ASSESSMENT TEST FAMILY
STUDENT GROUP GROWTH BY ASSESSMENT TEST LIST	TIDE ROSTER DATA - STANDARD

ACCESSING DATA TABLES (back to 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.

ASSESSMENT TEST ITEMS (back to Quick Links)

Allows the user to download the item-level data for a single assessment for a group. The item-level data (questions/answers/scoring rubric) for the chosen assessment must be available in Homeroom (that is uploaded) for the extract to be successful.

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

STUDENT ASSESSMENTS BY STUDENT GROUP (back to Quick Links)

Download assessment scores for a single assessment and student group for a specific school year and/or assessment test administration.

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

STUDENT GROUP GROWTH BY ASSESSMENT TEST LIST (back to Quick Links)

This table allows users to calculate the average scale score growth for a group of students across a series of assessments. This extract allows teachers, principals, and other school staff to compare the average progress of different student groups over time. Using this information, teachers, specialists, and administrators can gauge the effectiveness of interventions, check for gap closure progress of subgroups, and compare progress among student groups.

For the chosen student group and assessments, the Student Group Growth by Assessment List extract will deliver an extract that shows the average scale score of each group on each of the assessments. In addition, the chart calculated the scale score difference and percent change between each assessment.

*For the data delivered to be useful, users must choose comparable assessments for which scale score growth is meaningful.

Select a Student Group, Assessment Test, and Include out of District (optional, True/False), then click Save and Generate to Save & Name or Download XLSX.

STUDENT GROUP YEARLY GROWTH BY ASSESSMENT TEST FAMILY (back to Quick Links)

This data table allows a user to calculate the average scale score growth for a group of students across a series of assessments within a test family (MAP, DIBELS, AIMSweb, etc.).

It allows teachers, principals, and other school staff to compare the average progress of different student groups over a series of comparable assessments throughout the year. This information enables teachers, specialists, and administrators to gauge the effectiveness of instruction and interventions, check for gap-closure progress of subgroups, and compare progress among student groups.

For the chosen student group, assessment test family, and subject, this extract will deliver an Excel that shows the average scale score of each group on each assessment in the test family. In addition, the chart calculates the following:

The scale score difference between each assessment administration
Percent change between each assessment administration
The score difference between the first and last assessment administration
The percent change from the first to last assessment administration

NOTE: Unlike the Student Group Growth by Assessment Test List, the Assessment Test Family extract pulls the relevant Test Family and Subject data for all students in the group specific to their current grade.

For example, if a student group has IEP students in grades 3, 4, and 5, the user could select the MAP Test Family and the Reading subject area, and the average scores for each grade level group would be included.

This extract will only deliver assessment results for administrations of the assessment test within the selected school year. To choose assessments from previous school years, use the Student Group Growth by Assessment List data extract.

Select a Student Group, Assessment Test Family, Assessment Test Subject Area, School Year (optional), and Include Out of District (optional, True/False), then click Save and Generate to Save & Name or Download XLSX.

STUDENT GROWTH BY ASSESSMENT TEST LIST (back to Quick Links)

This data table creates an excel of individual student scale score progress over a series of assessments. In addition, this extract allows teachers, specialists, and others to monitor the student's progress on a series of assessments. Finally, this extract creates an easy way to identify students who are growing, stagnating, and falling behind over a year to target students for intervention.

For the chosen student group and assessments, the extract provides a list of students in the group and their scores on each assessment. In addition to scale scores, the extract includes the scale score growth and percent change between each assessment and from the first to the last.

*For the data delivered to be useful, it's important that users choose comparable assessments for which scale score growth is meaningful.

Select a Student Group, Assessment Test Family, Assessment Test Subject Area, School Year (optional), and Include out of District (optional, True/False, then click Save and Generate to Save & Name or Download XLSX.

STUDENT GROWTH BY ASSESSMENT TEST FAMILY (back to Quick Links)

The Student Growth by Assessment Test Family extract shows the progress of individual students in a selected group on a series of assessments within a test family (MAP, DIBELS, AIMSweb, etc.).

This extract allows teachers, specialists, and others to monitor the student's progress on a series of comparable assessments. This extract easily identifies students who are growing, stagnating, and falling behind on an assessment series to target students for intervention.

For the chosen student group and assessments, the extract provides a list of students in the group and their scores on each assessment over the year. In addition to scale scores, the extract includes the scale score growth and percent change between each assessment and from the first to the last.

NOTE: Unlike the Student Growth by Assessment Test List, the Assessment Test Family extract pulls the relevant Test Family and Subject data for all students in the group specific to their current grade. For example, suppose a student group has IEP students in grades 3, 4, and 5. In that case, the user could select the MAP Test Family and the Reading subject area, and the scores for each student would be included specific to the MAP Reading assessments they've taken this year.

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, Assessment Tests, Include out of District (optional, True/False), and Choose Selections, then click Save and Generate to Save & Name or Download XLSX.