Athletic Roster & GPA's

How can I print a team roster with the student's cumulative or term gpa?

Comments

  • Brian Gray
    Brian Gray Community All-Star
    Eighth Anniversary Kudos 5 K-12 Fall 2025 Product Update Briefing Badge Name Dropper

    @Christine Lamar - I don't see a way to get team rosters and GPAs in the same report. I would generate two separate lists: Team Rosters (from an Advanced List), and GPAs (from a SKY list), then put it all together in a spreadsheet.

    Include the student User ID in both reports. Export the results to CSVs, and put the data into Excel or Google Sheets - each of the CSVs on a separate sheet. Use XLOOKUP to pull the GPA for each player onto the roster page.

  • @Brian Gray - That is what I thought. Thank you!

  • @Christine Lamar We were able to do this through an Advanced list; it requires having the sports, teams, and rosters set up under Extracurricular > Athletics > Athletics Setup first. I've added some screenshots below (had to split the Select Objects into two screenshots); make sure to update the Filters as applicable for your school and setup.

    I export the results then use Excel for sorting, filtering, pivot tables, etc. Hope this helps!

    aab79ec70c90e92c5321b58c64f0b804-huge-se

    2e7f1c6317ef7f6972afed80e9f6dfef-huge-se
    21bbc8188f0a890d6501cfe41f523302-huge-di

    5cdf6a14517283504630f1d119e035f4-huge-fi


  • @Erin Caprielian this is awesome! Thank you