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,
@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.
PowerSchool Mentor/Champion
PowerSchool Mentor of the Year 2021 Winner
PowerSchool Beta Tester of the Year 2022 Winner
@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.
@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.
PowerSchool Mentor/Champion
PowerSchool Mentor of the Year 2021 Winner
PowerSchool Beta Tester of the Year 2022 Winner
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.
Please remember to give Kudos and/or select Accept As Solution on the helpful posts to thank the author and to help others find the solution. Thanks!