In Schoolrunner, there are many places where you can quickly and easily export out the data captured in our system. This article highlights all of these places, and how they might be used as imports into your Student Information System in regards to state reporting. In order for your school to make use of the Schoolrunner data exports, your SIS will need to allow for the importing of .csv files. You may be able to use the available API endpoints to create a scheduled data pull and generate your own files.
The Export Page
The Export page is found by hovering over "Setup" on the main menu. Export categories are arranged into three categories: People, Culture, and Academics. For the purposes of importing into your SIS, this article will focus on academics and culture.
Export Course Grades and Assessments
Select "Export Report Card Grades" to include only the course grades that appeared on a student report card into a .csv file. These grades will be for active enrollments. To export any course grade stored in our database for each student at your school, select "Export All Grades". "Export Assessments" will export out an overall average and other assessment level details for each assessment entered into Schoolrunner.
Export Behaviors and Interventions
To create a quick, school-wide export of all behavior records, or all Interventions entered for all students at your school, select the following options under "Culture" on the Export page:
Export Data Elsewhere in Schoolrunner
For many schools, certain Incident information, such as suspensions, is required state reporting. In order to get all incident information in an easily editable .csv file, go to the Incidents page, found in the main menu under the "Culture" heading.
Select "Download" or "Download by Scholar" to download a .csv file. You can specify time ranges, consequence types, and more with the filters on the left-hand side of the page.
If your school is on a direct PowerSchool sync or a Clever-facilitated PowerSchool sync, you will also see an option that specifies "Download for PowerSchool Import".
This will give you an export that can be uploaded directly into PowerSchool for reporting purposes.
Exporting Communication Logs
You can create a .csv download of all recorded communications in Schoolrunner. To find this export option navigate to the Communication page, found under the "Culure" menu.
Once there, you can set your date range, among other filtering options. Then, hover over the download icon to generate your file.
Exporting Student Lists on the Groups Page
If you have a saved group, and you’d like to export a list of those students into a spreadsheet, you can do so by navigating to the Groups page and selecting your group from "Existing Filters".
Use the "Download" link in the upper right-hand corner of the page to create your export.
Exporting Student and Staff Dashboards
You can also export any homeroom or saved student group from the Student Dashboard, and staff member info from the Staff Dashboard. Look for the "Download" link in the upper right-hand corner of any dashboard.
Exporting Analysis Report Pivot Tables and Raw Data
When viewing a report on the Analysis page, you can export data from the "Pivot Table" or "Raw Data" tabs by clicking the "Download" link.
More information on how to export attendance information can be found here. We also highly recommend that at the end of each year, you download and save all student report cards for future reference.
Exporting Assessment Results
When viewing an individual assessment, there are a few options to export student assessment responses and results. All options are accessible from the "Actions" menu.
Here's a breakdown of what each link produces:
- Download Definition – exports a .csv file that contains the structure of the assessment (number of questions, correct answers, point values, standards, etc.), but no students or student results. This file can be uploaded into a blank assessment to automatically structure the new assessment according to the definition
- Download Results – exports a .csv file that lists students and their overall results on the assessment
- Download Full Results – exports a .csv file that lists student responses for each question on the assessment
- Download Result Slips – generates a printable webpage that list overall results and question responses for each student, paginated by student
- Download Mastery Summary – exports a .csv file that lists each standard on the assessment and their average mastery scores (averaged from all student results for that standard)