Exporting Student Data Files
To generate and export student data files (SDF), use the Student Results Generator. You can select any combination of a test reason, assessments, and students in order to generate and export files. Student data files are useful for analysis.
You can generate student data files from almost any page in Centralized Reporting.
To generate and print student data files:
1. Select the Download Student Results button in the Features & Tools menu. The Student Results Generator window opens. Depending what page you open the Student Results Generator from, the options available to you may be prepopulated or preselected; for example, the Student Portfolio Report prepopulates a single student, and the Student Performance on Test report preselects a single test opportunity. (The filters applied on the page have no effect, however.) You can change the selections.
2.In the panel on the left, select Student Data File. Always do this before you make other selections. Switching between the Individual Student Report and Student Data File options reverts most manual selections to the initial ones.
3.Optional: Select Include only those students who were mine when they tested. This setting allows you to include students who were within your jurisdiction at the time of testing (regardless of their current associations or enrollments). If you select this checkbox, students who were not within your jurisdiction at the time of testing are excluded. Note that when you generate student data files using this setting, district and school jurisdictions and non-encrypted attributes reflect the testing date of each opportunity, not the reporting date.
This option appears only if the reporting school year and time are set to the present in Change Reporting Time Period.
4.Under Report Format, select XLS (Excel, XLSX), CSV (comma-separated values), or TXT (
5.Under Output, select either Data File for Each Test or Single Combined Data File.
6.If the test opportunity options are not preselected, or if you want to change them, there are two ways to make selections:
- Search for students. In the search field at the upper-right corner, enter up to five comma-separated student IDs and select Search. The resulting list of students and all the tests they've taken will replace any previous selections. To deselect and clear results, select Clear Search Results.
- Use the three accordion sections. (If a student is prepopulated by the Student Portfolio Report, first remove the student by selecting Clear Search Results.) Starting from the left, select the section bars to expand them or use the Next and Previous buttons to navigate. Within each section you must make selections:
i. In the Select Test Reason section, choose a test reason.
ii.In the Select Assessments section, choose either Select by Subject or Select by Grade. Select the checkboxes beside the tests or groups of tests you want to include in the report, or select All Subjects or All Grades.
iii.In the Select Students section, choose any number of students from the expandable school and/or class (roster). Students not grouped into classes are found under (Students Not In Any Roster).
- Before choosing students, you may filter by a date range. Select Filters, choose start and end dates in the menu, and then select Apply. Students are filtered by Centralized Reporting processing date, which is not always the same as the date a test was taken. Selecting Clear Filters and then Apply clears the filter.
- Sometimes the list of students is truncated. You can display the entire list by selecting Click to Load More.
- Selecting the checkbox for a student in one class (roster) or school also selects it for that student in all their classes or schools, and the same goes for clearing the checkbox.
7. Select Generate. Once student data file generation is finished, the Secure File Center contains the new SDF available for download.
Note that if a student took a test multiple times, the file will include each test opportunity.