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


Export Incidents

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

 

incidentdownload.jpg


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.

 

Screen Shot 2016-09-27 at 3.44.47 PM.png


Once there, you can set your date range, among other filtering options. Then, hover over the download icon to generate your file.


Screen Shot 2016-09-27 at 3.45.00 PM.png


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

 

Screen Shot 2016-09-27 at 3.52.38 PM.png


Use the "Download" link in the upper right-hand corner of the page to create your export.


exportgorup.jpg


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.


Screen Shot 2016-09-27 at 3.56.16 PM.png


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.

 

pivot table export.jpg


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)