How do I create a report that will show me how many credits a student is attempting?
Hi,
A PowerSchool SIS admin can use the potentialcrhrs or ~(*potential_credit_hours) DAT code to pull Credits attempted by a student in a report. I recommend reaching out to your district's Designated Support Contact who should be able to provide you further information on using DAT codes to create reports.
Thank you, but I mean for each trimester - not total. Is there a way to run a report that tells me how many credits a student is attempting in a specific trimester?
Hi! @aobarzanek,
Thank you for the clarification. PowerSchool SIS admin can add the StoreCode ID or the date range in the DAT statement to pull Credits attempted by a student for each trimester in a report.
For example: ~(*potential_credit_hours;T1)
Thank you - Can this report be pulled while the student is currently in the trimester - or does the trimester have to be over?
So when using the ~(*potential_credit_hours) data access tag, keep in mind that it draws from potential credit stored with historical grade records.
So if you just use ~(*potential_credit_hours), it will return the cumulative total of potential credit hours from all historical grade records from all years.
If you use ~(*potential_credit_hours;Q1), it will return the cumulative potential credit hours from all Q1 historical grades from all years.
If you use ~(*potential_credit_hours;Q1;2019), it will return the cumulative potential credit hours from Q1 of the 2019-20 school year only.
This seems like it is still only pulling historical data - how can I see what the student is currently attempting THIS semester - using ~(*potential_credit_hours;Q1;2021) it returns 0 credits.
Yes, that data access tag only pulls from stored grades. What you could do is to store grades using a bogus store code, such as store your Q1 grades using 'A1' (or any made-up store code you want) using the Potential Credit Only option. You could then use ~(*potential_credit_hours;A1;2021) to pull a list of potential credit for your selection of students. You could later delete the A1 grades using DDA once the A1 grades have served their purpose.
Hi Bishal,
Where is this DAT documented officially? I found credit_hours but not potential_credit_hours.
Thanks,
Vance
--
Vance M. Allen
PowerSchool Champion of the Year 2020 Winner
PowerSchool Forum Expert of the Year 2021, 2022, and 2023 Winner
Please do not contact me by private message for support. Please also note that I am not a PowerSchool employee.
Did your issue get resolved? 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!
Hi @Vance
This is not documented anywhere yet. However, previously we have seen instances where using ~(*potential_credit_hours) DAT code helped admins to pull Credits attempted by a student in a report that gives the total credits attempted.
Thanks, @SAFFIYAT. I was referencing this DAT in another thread and hoped there was official documentation to point to. I wasn't aware of any either but thought I would check. Thanks for confirming it is undocumented.
--
Vance M. Allen
PowerSchool Champion of the Year 2020 Winner
PowerSchool Forum Expert of the Year 2021, 2022, and 2023 Winner
Please do not contact me by private message for support. Please also note that I am not a PowerSchool employee.
Did your issue get resolved? 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!
What kind of credits are you talking about?
Thank you for the query!
The credits being referred to are the Potential credits and the Earned Credits. Potential Credit is the amount of credit assigned to a course and a student can potentially earn by completing the course. However, Earned credit would be the amount of credit that a student earns when completing a course. The student may earn the amount of credit assigned to the course (potential credit), or less depending on the student's performance.