Low Grades Reports for Admins

Submitted by MattFreund on Mon, 04/05/2010 - 3:52pm

Various custom pages that allow you to search for grades - current grades or percents, or stored grades:

* gradesreport.html - the grades drop-down has D, F, D's & F's, and I's and the page title says Low Current Grades
* currentgradesreport.html - the grades drop-down has A-F, D's & F's, and I's and the page title says Current Grades, otherwise works the same as the gradesreport.html
* linkedgradesreport.html - similar to the currentgradesreport.html file except there's a group function link at the bottom of the page. In order for it to work the names on the results are hyperlinks to the student's set of pages.
* percentsreport.html - instead of a drop-down for grades, one can enter a minimum and maximum number to search for current grades on
* percentsreportcursel.html - same as the percentsreport.html page except the student names are links and there is a group function link at the bottom of the page
* storedgradesreport.html - unlike the ones above, this one searches on stored grades instead of current grades

4/6/2010 - uploaded copies of the reports that were previously on sisresources.com including three extra reports that were not in the original download.

5/6/2010 - added the descriptions of the 6 pages to help answer questions on what pages are in the download and what they do and added screen shots

0
Your rating: None

Comments

Modding the report a bit . . .

by Chris_Moggia - 04/05/2010 - 5:29pm

Matt et al,

I'm trying to mod this report three ways for an administrator at one of my schools.

First, I changed line 138 to add the option of selecting all D's, F's, AND I's at the same time like this: ~[if.~[gpv:gd]=DsFsIs]and pgf.Grade IN ('D+','D','D-','F','I')[/if]

Second, the administrator is more interested in the date the grade was originally posted that the last grade update. How should I modify the last part of line 124 to substitute StoredGrades[31]DateStored instead of cc.LastGradeUpdate?

Third, how do I get the report to pull ALL stored grades from grade level 9-12, instead of just pulling one year at a time?

This way the report would pull ALL of the incompletes, D's and F's for the entire student body of ACTIVELY enrolled students.

-Chris

RE: Modding the report a bit . . .

by MattFreund - 04/07/2010 - 9:49am

If you're wanting the one that shows current grades to show stored information as well then you'll have to go in and modify the sql and join the stored grades table in somehow to the mix so you can pull fields from it. On the third part you would also need to modify the sql to not look at the current year but rather in the where look where the grade level in the stored grades table is greater than 8.

Matt

How Do I Run This Report for a Selected Group of Students?

by Patti_Chappell - 02/21/2010 - 8:22pm

Hello,

We are a school that has students from 12 different school districts. The admins at each of those districts need a D/F report each nine weeks for only their students.

If I do a search for a selected group of students and run this report, I get all students, not just the selected group.

How do I run this for just the selected group?

Thanks!

Patti Chappell

RE: How Do I Run This Report for a Selected Group of Students?

by MattFreund - 02/22/2010 - 11:33am

Verify the students are the current selection by going to the start page. Once you're sure they're the current selection then pull up the custom page and from the drop-down choose to run for the current selection of students.

Matt

GPA

by DMurphy - 01/29/2010 - 6:55pm

Could this be modified to also pull by GPA<2.0?

No Results Yet

by bucks - 12/01/2009 - 2:06pm

We recently upgraded to 6.0.1 and upon finding that the old Low Grades report didn't work with the new version, I went replaced the old html file in the report folder with the new one (I thought it was new), but I'm still getting no results. Can you point me in the right direction?

Thanks!
Sarah

re: no results yet

by MattFreund - 12/01/2009 - 3:30pm

The page should work ok on 6 but I've seen where people have run into problems because of the following in the html:

form name="gradesform" action="/admin/reports/gradesreport.html" method="POST"

I had to leave off the less than and greater than, but what that does is look for the page in that exact location, but often times people place the page in another folder instead or the link to the page is wrong. But if you change the above to

form name="gradesform" action="gradesreport.html" method="POST"

then it should work regardless of folder or link. So that would be something to try, but if that doesn't work, try the newer versions of the pages at http://www.sisresources.com/index.php?/Grades/grades-reports.html instead.

Matt

It works!

by bucks - 12/11/2009 - 1:16pm

Thanks! I had indeed found the new one and put it in properly, but it took the nightly process to make the new report show up. It works perfectly. Thanks so much!

Sarah

add grade level

by jessicabolton - 10/14/2009 - 2:46pm

would adding a drop down to search on grade level as well be an easy add-on?

re: add grade level

by jtreadwell - 10/14/2009 - 5:14pm

There is a report in the reports bundle that is based on this customization that will let you search by grade.

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

Add another choice

by jessicabolton - 10/07/2009 - 8:42am

First I added Us to the Ds and Fs search. I am now trying to add another option to search on Us and Fs only. It seems to ignore the first if statement and jump right to the second. As it is below, the Ds,Us,Fs search returns no results but the Us and Fs works fine. I flipped them and same thing - whichever is first does not work but the 2nd one does. Any suggestions? Thanks

WHERE
~[if.~[gpv:se]=]s.enroll_status = 0 and s.schoolid = ~(curschoolid)
[else]s.enroll_status = 0 and s.schoolid = ~(curschoolid) and ps_customfields.getstudentscf(s.id,'~[gpv:se]')=1
[/if]
and pgf.FinalGradeName = '~[gpv:tm]'
and sec.Termid >= ~(curyearid)00
~[if.~[gpv:gd]=DsUsAndFs]and pgf.Grade IN ('D+','D','D-','F','U')
[else]
~[if.~[gpv:gd]=UsAndFs]and pgf.Grade IN ('U','F')
[else]
and pgf.Grade LIKE '~[gpv:gd]%'
[/if]
[/if]

RE: Add another choice

by MattFreund - 10/07/2009 - 10:09am

Don't use the [else]. Do like the original had and just put the /if at the end of each line. So something like

~[if.~[gpv:gd]=DsUsAndFs]and pgf.Grade IN ('D+','D','D-','F','U')[/if]
~[if.~[gpv:gd]=UsAndFs]and pgf.Grade IN ('U','F')[/if]
and pgf.Grade LIKE '~[gpv:gd]%'

Matt

thank you for the reply - I

by jessicabolton - 10/07/2009 - 11:34am

thank you for the reply - I changed it to this and now only the single letter searches work. Us and Fs and Ds,Us,Fs no longer work at all. Am I still forgetting something?

WHERE
~[if.~[gpv:se]=]s.enroll_status = 0 and s.schoolid = ~(curschoolid)
[else]s.enroll_status = 0 and s.schoolid = ~(curschoolid) and ps_customfields.getstudentscf(s.id,'~[gpv:se]')=1
[/if]
and pgf.FinalGradeName = '~[gpv:tm]'
and sec.Termid >= ~(curyearid)00
~[if.~[gpv:gd]=DsUsAndFs]and pgf.Grade IN ('D+','D','D-','F','U')[/if]
~[if.~[gpv:gd]=UsAndFs]and pgf.Grade IN ('U','F')[/if]
and pgf.Grade LIKE '~[gpv:gd]%'

GROUP BY pgf.studentid
HAVING count(*) >= ~[gpv:mn]) lowgrades

INNER JOIN Students s ON lowgrades.id = s.id
INNER JOIN PGFinalGrades pgf ON s.ID = pgf.StudentID
INNER JOIN Sections sec ON pgf.SectionID = sec.ID
INNER JOIN Courses c ON upper(sec.Course_Number) = upper(c.Course_Number)
INNER JOIN Teachers t ON sec.Teacher = t.ID
INNER JOIN CC cc ON pgf.SectionID = cc.SectionID AND pgf.StudentID = cc.StudentID

WHERE pgf.FinalGradeName = '~[gpv:tm]'
and sec.Termid >= ~(curyearid)00
~[if.~[gpv:gd]=DsUsAndFs]and pgf.Grade IN ('D+','D','D-','F','U')[/if]
~[if.~[gpv:gd]=UsAndFs]and pgf.Grade IN ('U','F')[/if]
and pgf.Grade LIKE '~[gpv:gd]%'

RE: thank you for the reply - I

by MattFreund - 10/07/2009 - 11:49am

It's probably the last line and it needs some sort of logic as well. Try the following:

~[if.~[gpv:gd]=][else]and pgf.Grade LIKE '~[gpv:gd]%'[/if]

Otherwise you'll have to do like the original and make if statements for each part in your drop-down.

Matt

Adding a field to percentsreport.html

by wilmapayne - 09/16/2009 - 4:00pm

Matt - we love your report, but I've been asked to add a column reporting the contents of a custom student field: ADVISOR. I tried following the instructions above, but get no output when I run the report. I'm hoping you can tell me what I've done wrong.

Thanks!

Wilma Payne
Cesar Chavez School Network

RE: Adding a field to percentsreport.html

by MattFreund - 09/16/2009 - 6:01pm

Sounds like advisor is a custom field. With custom fields you can't reference them like the regular fields. Are you on PS 6? If so, the way you would reference the field is by putting ps_customfields.getstudentscf(s.id,'advisor') in the select area. You have to put s.id because there's more than one table involved and s.id signifies students table in this sql. You then have to put the same down in the output, but it's easier to alias it in the select and reference the alias. So if you put ps_customfields.getstudentscf(s.id,'advisor') advisor in the select area, then you can just put ~(advisor) in the output.

If you're on PS 5 still then getting the custom field can be a little trickier. I don't know the code right off without trying it on a test server first, but it would involve you having to do some searching in DDE to find a fieldnumber for the custom field and putting it in a nested select statement. If you're on 5, let me know, and I can try to figure out the code.

Matt

Low Grades for Admin - missing store code under term

by Morgan_Sem - 05/13/2009 - 8:16am

Are the codes under the TERM drop down store codes or from our school's years and terms set-up? We have three terms during the year but store grades six times - mid way through term and end of term. For the spring term our grades are collected in S2 but I store in S1 at midterm and S2 at end of term. S1 is not available in the term drop down so I can not run this report for D's. F's and I's at midterm. Does anyone have a solution?

RE: Low Grades for Admin - missing store code under term

by MattFreund - 05/13/2009 - 1:33pm

The drop-down is based on some sql to pull data from your School Setup, Final Grades Setup area for the school:

FROM termbins
WHERE yearid = ~(curyearid)
AND schoolid = ~(curschoolid)

So it should look at the term you're in at top and associate the year with it (year 18 for any 08-09 term you're in) and then pull the data from the termbins table for that year and school. So if you don't have a S1 set up anywhere in Final Grade Setup for that school, then it won't show it in the drop-down.

Matt

re: Low Grades for Admin - missing store code under term

by danberms - 05/13/2009 - 9:11am

I didn't look at the all of the pages, but for the storedgradesreport.html page, the store codes are coming from the years and term.
If you want the list to contain any terms that you store, you can try modifying the tlist for the termchoice to the following.

~[tlist_sql;
SELECT distinct storecode, CASE WHEN storecode = '~[gpv:term]' THEN 'selected' ELSE '' END selectedterm
FROM storedgrades
WHERE termid >= ~(curyearid)00 AND termid <=~(curyearid)99
AND schoolid = ~(curschoolid)
ORDER BY storecode]

The differences is just changing the table and the first line of the where clause to get the current year terms. So the list will only contain terms that there have been grades stored under for that year.

Dan

re: Low Grades for Admin - missing store code under term

by jtreadwell - 05/13/2009 - 9:08am

The list of codes is generated by looking up your store codes that are setup in the termbins table for the current term selected. So if you are in S2 then S1 wouldn't show. If you are in full year then both should show. However there are several reports in this package, which one are you trying? 2 of them go to live grades and 1 goes to stored grades. The live grades reports will not see a S1 within a S2 course because it doesn't really exist (unless you've officially set them up in your final grade setup).

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

Multiple listings at High School

by FMRSD_Tech - 12/09/2008 - 9:55am

Hello,

I am using the low grade custom page and it works great in all schools, but the high school. For some reason, the high school data prints our multiple listings of the same course and grade for each term.

Does anyone know what could be causing this or what I need to adjust in the report?

Thanks for any help,
Lynne Phillips, Tech Director

RE: multiple listings at high school

by MattFreund - 12/10/2008 - 10:15am

Lynne,

The page pulls information from the PGFinalGrades table so you might want to check that via DDE and make sure you don't have duplicate grades in there for the HS. If that's not the problem, try adding distict after the word select in the sql part of the page and see if that helps.

Matt

Low Grades report.

by Sagarave - 11/14/2008 - 10:10am

Our users needed couple more options in the Grades drop down, which I added with out any problems.

The options that I added were

I was able to add the option for U's & NI's in the sql script. But when I add either of the other two options, the entire sql script is displayed on the page as follows.
--
Student Grade Level Home Room Grade Percent Course Exp. Teacher Last Grade Update
~[tlist_sql; SELECT s.LastFirst, s.grade_level,s.home_room, pgf.Grade, pgf.Percent, c.Course_Name, sec.Expression, t.LastFirst, cc.LastGradeUpdate FROM (SELECT pgf.studentid id, count(*) FROM PGFinalGrades pgf INNER JOIN Students s ON pgf.StudentID = s.ID INNER JOIN Sections sec ON pgf.SectionID = sec.ID INNER JOIN CC cc ON pgf.SectionID = cc.SectionID AND pgf.StudentID = cc.StudentID WHERE s.id in (-1) and pgf.FinalGradeName = '' and sec.Termid >= 1800 GROUP BY pgf.studentid HAVING count(*) >= ) lowgrades INNER JOIN Students s ON lowgrades.id = s.id INNER JOIN PGFinalGrades pgf ON s.ID = pgf.StudentID INNER JOIN Sections sec ON pgf.SectionID = sec.ID INNER JOIN Courses c ON sec.Course_Number = c.Course_Number INNER JOIN Teachers t ON sec.Teacher = t.ID INNER JOIN CC cc ON pgf.SectionID = cc.SectionID AND pgf.StudentID = cc.StudentID WHERE pgf.FinalGradeName = '' and sec.Termid >= 1800 ORDER BY ;alternatecolor] !!!LastFirst!!! !!!grade_level!!! !!!home_room!!!
[/tlist_sql]

Report generated at ~[time] on ~[date]
~[wc:admin_footer]

--
What am I doing wrong? Is it a problem with my browser?

Any help, pointers will be appreciated.

Thanks
Venkat.
Elizabeth Public Schools.
NJ.

tlist_sql displayed

by MattFreund - 11/14/2008 - 2:47pm

Venkat,

Can you email me a copy of the page so I can check the html coding to make sure something isn't missing? I think the sql part on the posting got stripped and left off some important parts.

I think I ran into that same problem when I tried to do something similar and I think my problem had to do with page size. I think that could do it or some html code missing which would do it too and if I saw your page we could rule out the coding.

If it is a page size problem though, a couple workarounds are too have two pages - the original and then a second page like it but with just the U and N parts and the admins would have to go to one or the other. The other thing that may work is the choice part being on a separate page altogether and then an insertfile command used to insert that part onto the page. Jason did something like that on the login report.

Matt

tlist_sql displayed

by Sagarave - 11/14/2008 - 4:04pm

Thank you very much for your reply Matt. Can I please have your email id.

Venkat.
Elizabeth Public Schools
NJ

Help! Case Sensitive

by FMRSD_Tech - 10/29/2008 - 11:23am

Help,

We have finally identified the commonality of why certain classes were not being pulled into this low grades report. Our Middle Schools have named their course numbers similar to this: EleArt6
On mistake, a principal enrolled students in a couple different sections and did not use the UpperCase/LowerCase consistency pattern above. (didn't know it would be an issue.)
Under teacher schedules, the course number appears eleart6 and any students in this course and the few others he did not use Caps do now show in this report. Is there a code or case sensitivity issue in the report that would prevent this? The kids are fine in all PS built in reports. PowerSchool would not discuss the issue as they said it was the 3rd party report problem. Please help!

Lynne Phillips, Tech Director

RE: Help! Case Sensitive

by MattFreund - 10/29/2008 - 12:55pm

I've uploaded a new file with pages that should fix the problem. The new download will have lowgradesforadmins as the name instead of low grades. I had to change one line on the page and here's the line in case you want to change it on your page instead or if some others have modified the customization and need to change the line. Look for:

INNER JOIN Courses c ON sec.Course_Number = c.Course_Number

and change it to:

INNER JOIN Courses c ON upper(sec.Course_Number) = upper(c.Course_Number)

Oracle is case sensitive and the line above puts the course name references in upper case in the SQL on the page so it looks the same for the report at least. That'll fix the problem for this report, but if you download any other custom pages and the courses aren't showing you'll need to change them as well to look for the same case.

If anyone is using the reporting engine reports and having the same problem, I'll get updates to them online as well.

Matt

Thank you!!!

by FMRSD_Tech - 10/29/2008 - 2:23pm

Thank you so much Matt!!!

You have solved the issue!

Have a wonderful day!
Lynne Phillips, Tech Director

RE Reports Updated as well

by MattFreund - 10/29/2008 - 3:36pm

You're welcome. I've uploaded some updated versions of the reporting engine reports to the sisresources site with the same fix in case anyone is using them.

Matt

Low Grade Report for Entire School

by schnurer_sdsm - 10/21/2008 - 12:41pm

I'm not able to print this report for all grades (leave blank for all). I can check grades 9 and 10 and get results, but report returns blank when I leave grades blank.

RE: Low Grade Report for Entire School

by MattFreund - 10/21/2008 - 2:20pm

Are you referring to the reporting engine report at sisresources.com, because the pages on this site don't have grade levels associated with them. If that's what you're referring to, do you have a large student body? I have a modified version of that report that I'll get posted online that fixes a bug when the numbers of students is rather large.

Matt

Low Grade Report for Entire School

by schnurer_sdsm - 10/21/2008 - 2:55pm

Matt,

I did download the reporting engine from sisresources.com because I don't know how to from this site. We have 1200 students, so I understand that could be causing my problem. I will check back for the modified version of the report.

Thanks,

Karen

RE: Low Grade Report for Entire School

by MattFreund - 10/23/2008 - 12:06am

I've uploaded newer versions of the report to the sisresources.com site. I dropped the PRE from the name, so when loaded the report will just be Low Current Grades. I also dropped the grade level choice - I had to do that to get the revision to work correctly. I did add a third version of the report to the download. It doesn't have an activity drop-down like the other two, but instead lets you choose to run the report for the current selection or for all students. The report is more flexible that the original two in that you can run it for any group of students by making the group the current selection first through the start page search box or the stored searches area.

All three versions have 5.2 in the version name and they all will load with the same name - Low Current Grades. If you wish to load more than one of them, you will need to change the name and id of each report through the setup area so they're unique. Otherwise you'll receive errors if you have more than one reporting engine report with the same name and id.

Matt

Low Grades Report

by jinwood - 09/30/2008 - 2:44pm

Hi Matt,

I'm not sure what we're doing wrong, I had one of our program developers take a look at your original report and the one I modified. Other than changing your F's to E's everything is the same. When we run the report to pull D'and E's it pulls all grades. When we run it to pull D's or E's only it works great.

Any suggestions?

Thanks again
Judi

low grade report

by MattFreund - 09/30/2008 - 3:21pm

Can you either post your changes so I can see them or email me the changes? Without seeing your changes I won't be much help. I would need to see what you changed in the drop down part and in the sql part.

Thanks,
Matt

low grades report and student number

by dragot - 09/29/2008 - 7:17pm

Hi Matt,

Is there any way to add student number to the percents report? I tried a number of codes but I can't seem to make it work... What we really need is a progress report for each student that has a failing grade...

Tom

how to add the student number

by MattFreund - 09/29/2008 - 11:19pm

Look for the following in the tlist_sql:

SELECT s.LastFirst, s.grade_level, pgf.Grade, pgf.Percent, c.Course_Name, sec.Expression, t.LastFirst, cc.LastGradeUpdate

With tlist_sql, wherever you place the field in the select is the order it'll appear on the output. So if you want the student_number field between the lastfirst and grade_level, then do the following:

SELECT s.LastFirst, s.student_number, s.grade_level, pgf.Grade, pgf.Percent, c.Course_Name, sec.Expression, t.LastFirst, cc.LastGradeUpdate

Then you'll have to add a column heading in the part above the tlist_sql and an output column below the tlist_sql.

One thing you may want to look at instead of this page, is the Low Current Grades report at http://www.sisresources.com/re/reports.html It has a link on it to Group Functions with the group of students on the report the current selection. So if you have a report, like a report card template of the students classes and grades, then you can run it for the current selection.

Matt

Low Grades Report

by jinwood - 09/25/2008 - 8:51am

Matt,

I modified this report to pull D's and E's instead of F's, when I try and run it it pulls all grades from A - E, is this they way it's suppose to pull?

Thanks
Judi

re: low grades report

by MattFreund - 09/25/2008 - 12:32pm

No, sounds like you missed something in the modification. Compare it to the original and make sure you modified everything - drop-down, sql, etc.

Matt

Syndicate content Syndicate content