topic How can I access historical data in PowerSchool? in Community Forum

How can I access historical data in PowerSchool?

avega2 — Tue, 28 Mar 2023 20:36:25 GMT

I am trying to export GPA's for this year's class in comparison to last year's as well as export program + course data from previous years.

When I use the DDE and select the program table, I get 0 records though I am able to enroll students into specific programs in PowerSchool.

I'm kind of new to this platform and just looking for some pointers after doing some research on my own.

It seems like quick export is for one table only and current year, so I am trying to learn of other options.

Thank you in advance,

Re: How can I access historical data in PowerSchool?

HeatherWeist — Wed, 29 Mar 2023 12:37:54 GMT

@avega2 GPA's are an on-the-spot calculation. Unless you pull the data via a Quick Export and import it into a custom field. It becomes very difficult to compare groups of students over the years.

Re: How can I access historical data in PowerSchool?

avega2 — Wed, 29 Mar 2023 15:12:53 GMT

@HeatherWeist Got it, it seems like I will just have to calculate by pulling from stored grades and making calculations outside of PowerSchool? For previous school years, filtering by term id.

Re: How can I access historical data in PowerSchool?

HeatherWeist — Wed, 29 Mar 2023 16:34:29 GMT

@avega2 You are most welcome. As I mentioned, you could always create custom fields and export the GPAs at the end of the term, year, etc and import them into the custom fields. We do that in order to show a student's GPA for each grade level.

Re: How can I access historical data in PowerSchool?

jasonbengs — Tue, 04 Apr 2023 02:32:31 GMT

To build on what @HeatherWeist said, we use cumulative GPA calculations for all 9-12 grade students, then prior to rolling graduates into the Graduated Students school we export their final GPA and rank into custom fields that are stored permanently during the rollover process. This gives us a final snapshot to use if we need to reprint transcripts or pull other data for those students.