By default the PowerTeacher gradebook calculates the final grades based on total points. At my district, the final grade is calculated by averaging the Quartile grades together. The attached document is what I distribute to my teachers for them to follow to set up the gradebook to calculate the final grade according to our policy.
Comments
Anybody write SQL to export web gradebook final grade setup?
Before I try this, has anybody written SQL against the PSM_ tables to extract the final grade setup?
PowerSchool does not allow admin to push the final grade composition to teachers. Infinite Campus does.
However, the districts that I support require teachers to use a set formula (Final grade = 20% Q1 + 20% Q2 + etc...).
I've done this with Campus, but would find it useful to extract the final grade setups, move them into Excel, do a Pivot to create columns of appropriate store codes and be able to verify who has not set things up correctly.
Figured this out...useful to others?
done
re: Figured this out...useful to others?
I'm sorry I didn't release this earlier, but the bundle I just published (temporarily in beta) includes such a report. I've put it on several district's systems and they've all loved it so far.
Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org
Serious question.
Is there an advantage calculating final grades using the gradebook rather than using the average final grades function in PowerSchool?
Thanks,
-Guy
The Average Final Grades
The Average Final Grades function does not round, so you will get grades such as 89.75% which should round up to 90% in my district. Also if the grade in the gradebook doesn't match what prints on the report cards you may get phone calls from parents if the final grade is published on the parent portal asking why the grades on the parent portal are wrong.
Tim Scoff, tim@scoff.net