Skip to main content

Credits Earned Report

Custom Queries allow you to generate a report that displays student credits earned based on report card data. Schools run these reports to make sure students are on track to graduate or to determine eligibility. The credits earned field on a custom query does require GPA to be enabled, and you will need to recalculate GPA before running this report. For more information on configuring other types of custom queries, please refer to the following article.

Custom Queries are a part of the Enhanced Data Access (EDA) subscription. If, while following the steps below, you are redirected to the Main page with an error message, your subscription does not include EDA. Please contact your sales representative for a quote or email us at support@common-goal.com.

To create the Credits Earned report:

  1. Go to Main > Reports > Saved Reports
  2. Select Create a Custom Query
  3. On the Type tab, configure the following:
    • Select Extract Rows of Data
    • Check Remove Duplicate Rows
  4. On the Entities & Fields tab, configure the following
    • In Data to Query, search and select Students. This will add the following Additional Data to Join In:
      • Yearly Enrollments
      • Grade Level Types
      • Enrollment Entries
    • In Additional Data to Join In, choose one of the following data elements:
      • GPA Overall shows the cumulative credits earned
      • GPA Per Year shows yearly credits earned
      • GPA Per Grading Period shows credits earned for each grading period. This includes both regular and summary grading periods. To filter on a single grading period, please refer to the below section below
    • In Fields to Query, add these needed fields:
      • (Students Fields to Query) First Name 
      • (Students Fields to Query) Last Name 
      • (Students Fields to Query) Student Number
      • (Grade Level Types Fields to Query) Grade Level Type Code 
      • (GPA Fields to Query) Credits Earned
  5. On the Filters tab, add any needed. To see common filters, please refer to the section below
  6. (Optional) On the Column Order tab, rearrange the fields for the final report
  7. (Optional) On the Sorting tab, set and prioritize which fields are used for sorting
  8. On the Preview tab, review sample rows for the final report
    • (Optional) Make any adjustments to previous tabs based off the preview
  9. Select Save & Run
  10. Enter the report title into the Description
    • We recommend titling the end of the report “- Recalculate GPA before running”  as a reminder to recalculate GPA
  11.  Click Save
  12. Select an Output Format
  13. Click Run Export

Common Filters

Single Grade Level Filtering

If you want to filter on a specific grade level, select the Entities & Fields tab and make sure to have the following data element added as Additional Data to Join in (it should be included by default):\

  • Grade Level Types

To filter on a specific grading period, you will need to add a new filter with the following components: select Grade Level Types, Grade Level Type Code, =. From there, select the desired grading period.

Single Grading Period Filtering

If using GPA Per Grading Period, you can filter by grading period information. To do so, select the Entities & Fields tab and add the following data elements into the blank Additional Data to Join in:

  • Grading Periods
  • Grading Period Types

To filter on a specific grading period, you will need to add a new filter with the following components: select Grading Period Types, Grading Period Type, =. From there, type in the name of the grading period you wish to filter on.