How to Pull Reports in PowerSchool for Data Collection

If the system your school uses is PowerSchool and you are looking for instructions on how to pull these reports to collect your data, then this is the post for you! In order to run these reports you need to have administration access, which counselors should have in order to create the schedules.


To Pull a Behavior Report:

  1. On your PowerSchool home page, go All Reports

  2. Click System tab

  3. Discipline Section

  4. Select Discipline Log.

  5. Enter the date range, student selection, then Submit.

  6. Selections can be made by grade level, gender or any other selection group established.

  7. Once the report is created, select the Excel option at the top of the spreadsheet (CSV).

  8. Save the report in an easily accessible place, where it can easily be retrieved.

  9. Open it, then save it as an excel binary workbook.

  10. One you have it in the appropriate excel spreadsheet format, you may sort the information.

To Pull an Achievement Report:

  1. On the PowerSchool homepage, select the grade level that you would like data for

  2. Click All Reports

  3. Select Custom Reports tab

  4. Then Click Grades and Grading Section

  5. Select Current Grades by Percent Report

  6. Enter the term (N1: 1st Nine Weeks, Y1: Full Year, S1 or S2 for semester.

  7. Put in appropriate numbers and submit.

  8. Once report is created, copy and paste the student information into a blank Excel sheet.

To Pull an Attendance Report:

  1. On the PowerSchool homepage, click All Reports

  2. Select Custom Reports

  3. Click Student Attendance Range Report

  4. Enter dates for Attendance Range

  5. All students > 0 -100.

  6. Save as excel binary and save it. This will allow you to sort the data.

To Pull a Demographic Report:

  1. On the PowerSchool homepage, select All Reports.

  2. Click Custom Your School's Name Reports

  3. Select All School Reports

  4. Click, Misc. then select testing demographics reports.

  5. Select a student group, either grade level or the student population that you have already established as your current selection then click submit.

  6. Scroll over to the right and export the information into an excel spreadsheet.

  7. Once report is generated, select the Excel option at the top of the spreadsheet generated (CSV). Save the report in an easily accessible place, where it can easily be retrieved.

  8. Open it, then save it as an excel binary workbook. Once you have it in the appropriate Excel spreadsheet format, you may sort the information.

Hopefully updates do not change this flow anytime soon!

© 2023 by Watch & Learn. Proudly created with Wix.com

Let's Connect!

  • Instagram
  • Facebook
  • Pinterest