Custom Reports Bundle Grading 4.0.1

About
This plugin will add the grading reports to the custom reports bundle base. Note: the base plugin will need to be installed before you will see these reports automatically appear.

What's new
The reports have been updated to look and feel more like PowerSchool native pages.

How do I install a plugin?
Directions can be found here

Change History
V 4.0.1 - Released 2014-04-05

  • Fix for list class details report. Previously only showed students whose last name started with A if using the Stored Grades filter (gradebook filter did not have this problem)

V 4.0.0 - Released 2014-04-01

  • Initial public release of updated reports in plugin form
Sponsor: 
Computer Logic Group

Customization:

Contributor: 
Jason Treadwell
Brent Johnson
Brian Andle
Others I'm sure I'm forgetting

PS Verions

6.x: 
N
7.x: 
Y
Plugin: 
Y
CPM Import Friendly: 
Y
Report Type: 
Web Based Report
Images: 
Custom Reports Bundle Grading tab (part 1)
Custom Reports Bundle Grading tab (part 2)

Comments

Where is the link to download this plugin?

Nathan,

Please read the large bold note at the end that states that it's not there until I'm done updating.

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

The link to the download has been added and the warning message has been removed. You should now be able to download the plugin.

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

my bad, sorry

It looks like this report is still erroneously filtering for students with a last name starting with A:

AND s.Last_Name LIKE 'A%'

Is there a reason why this report would be designed to only look at the first letter of the alphabet?

Yes, the report was doing that because I had a filter when I ran the query on my test box that I forgot to remove when I put it in the page. It's fixed in 4.0.1.

You say "still", was this there before? This report was built by me for a specific customer who donated it back to the community and theirs doesn't have it so I'm curious if older versions had it as my original one (the one on the customer site) didn't. I tested all these queries before updating the pages so I figured I just pasted it back with the extra filter but it sounds from your comment that this was placed there previously too.

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

I could have done it myself, but I prefer to use official versions of 3rd party customizations.

And yes, this exists in version 3.4.4 as well.

Just in case you are wondering. I have this package installed from a while back.
We never used that report and I definitely haven't customized it. I just checked and have the same filter in mine:
AND s.Last_Name LIKE 'A%'

Just wanted to let you know since you seemed curious. I will just remove that.
But it seems like a good idea to have for testing so that the query runs faster.

Missy

Greetings

When I installed the grades and grading reports I can only see 4 of them. I'm missing 24 which one of them is the one that I would like to use.

I turned off customization and turned it back on and the reports did not populate. Also run the Rebuild Custom Page Link in the special operations and nothing.

I changed from Static to Dynamic in the PDS setup and refresh the reports and guess what? Nothing changed.

Then report that I want is detailGradeInfo.html. What am I doing wrong? What can I do to fix this list of missing reports?

Thanks

Greetings

When I installed the grades and grading reports I can only see 4 of them. I'm missing 24 which one of them is the one that I would like to use.

I turned off customization and turned it back on and the reports did not populate. Also run the Rebuild Custom Page Link in the special operations and nothing.

I changed from Static to Dynamic in the PDS setup and refresh the reports and guess what? Nothing changed.

Then report that I want is detailGradeInfo.html. What am I doing wrong? What can I do to fix this list of missing reports?

Thanks

I have installed the latest Custom Report Bundle and we are missing a report.
If you run Custom Reports in Static mode, you can see the Graduation Statistics report under Grading. However, when you switch to Dynamic mode, this report is gone. How can I get that link to show up in Dynamic mode?
Thanks, Elainna

Echoing the many thanks for your time & work in providing these reports! I use the Final Grade setup to quickly check that teachers have correct school-defined term weights. . . New version was recently installed and I've noticed that a few isolated sections/teachers are NOT showing on this report. For example, a faculty member has five S1 sections--only one shows up when I filter for S1 classes. Should I be looking for an error of some sort in the section setup details? Haven't found it yet. . .

Elizabeth Middleton
Registrar
Notre Dame de Sion School

I tried to modify the percent grades report to show student numbers, and now the table is not loading after I uncheck the Pause button. It just stays saying "Searching for Results" no matter how long I wait. Here is what I did:

In the results table header section, I added <th>ID</th> between <th>&nbsp;</th> and <th>Student</th>

In the ~[tlist_sql section, in the first SELECT statement, I added s.Student_Number between s.grade_level and pgf.Grade

After the ~[tlist_sql section, in the table definition, I added <td>~(s.Student_Number;t)</td> between <td>~(count;-)</td> and <td><a href="/admin/students/home.html?frn=001~(sDCID;l)"

Did I miss something? Or is it possible that something about the file got screwed up because I edited it in Notepad?

Any help would be greatly appreciated.

Is there any documentation that explain these reports better that the on page description? What is the difference between List Class Detail and Percent Grades Report? What is the difference between the Grade Verification Report-Web and the Gradebook Verification Report - except that one allows you to select the term. Int eh Search by Grade & Attendance Report - What criteria needs to be entered to get results? How do you know which reports are pulling from Stored Grades and which ones are pulling from the gradebook?

Trying to run them all to see what type of results are returned, but some do not appear to "me" to be self explanatory.

Any help would be greatly appreciated.

Is there a way to utilize Meeting Attendance in this report instead of Daily Attendance?
Either way, running this report returns no results for our administration. Anything I can change would be a big help.
Thanks,
BAK

I have the latest plugin versions of CRB base and grading installed on v8.0.1. I ran the final grades setup report, filtering by 2014-15, Q1, selected department and results returned fine. I reran the report for a different selected department with same 2014-15 and Q1 filters. While waiting for results to return we started seeing Java errors. For example clicking on a student name in PowerSchool resulted in a long error message starting "Error executing freemarker template: backed by StudentAccessAccountsAdminAction: Expression accessLevel is undefined on line 4, column 20 in admin/students/accessaccounts.ftl.. ---------- ==> assignment: readOnly=(accessLevel < 2) [on line 4, column 1 in admin/students/accessaccounts.ftl] ---------- Expression accessLevel is undefined on line 4, column 20 in admin/students/accessaccounts.ftl. The problematic instruction: ---------- ==> assignment: readOnly=(accessLevel < 2) [on line 4, column 1 in admin/students/accessaccounts.ftl] ---------- Java backtrace for programmers: ---------- "

The system log showed the error below. Bug? or is something else going on?

DALX ATTENTION! Critical Error generated from MWCP_ParseResponse Description=java.sql.SQLException: Exception executing
SELECT DISTINCT
CASE WHEN crs.Sched_Department is null THEN 'No Dept' ELSE crs.Sched_Department END sched_departmentid,
crs.Sched_Department
FROM Courses crs
INNER JOIN Sections sec
ON crs.Course_Number = sec.Course_Number AND
sec.ExcludeFromStoredGrades = 0
INNER JOIN Terms t
ON sec.TermID = t.ID AND
sec.SchoolID = t.SchoolID
WHERE sec.SchoolID = 123123
ORDER BY crs.Sched_Department with 0 parameters: ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [17114], [0x0759FED48], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17114], [0x0759FED48], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17114], [0x0759FED48], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17114], [0x0759FED48], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17114], [0x0759FED48], [], [], [], [], [], [], [], [], [], []

We have discovered a few teachers are missing from the Gradebook Preferences report. They have ID's and are marked as teachers.

Any thoughts as to why they aren't appearing in the report? I've tested in both District and School Level. We looked at the code through SQL and have narrowed them down to the sync_teachermap. The teacherdcid does not appear in the sync_teachermap. In addition, one of the accounts associates the teacher with another teachers name which happens to have two accounts in two different middle schools.

Subscribe to Comments for "Custom Reports Bundle Grading 4.0.1"