Low Grades Report Teachers

Submitted by tscoff on Mon, 09/28/2009 - 3:18pm

This is an easy to run PHP based low grades report for teachers. It is difficult to set up, but it allows my teachers to print out mid term progress notices in 5 minutes or less for all of their students. It also opens up a security hole in PowerSchool. I have this report configured so that it can only be run from within my district to minimize the security hole.

This report shows the teachers every student in every one of their classes who is earning less than 70% on one screen. It also includes the ability to print out progress notices for all of a teacher's students whose grade is at or below 69%, 75%, 79%, 85%, or all students. The progress notice includes every assignment for the grading period with any comments that the teacher entered.

Updated on 9-28-2009 to work with the PowerTeacher Gradebook version 1.6

0
Your rating: None

Comments

Blank results

by dwertz - 11/05/2008 - 9:05pm

Hello,

When I run this report (after getting everything configured) I recieve no results. I made sure that I was connecting to the database my changing the odbc user info so I now that it isn't it. I scoured all the files to make sure that I have the terms we use. I get the initial search page, and the page that tells teachers to print but there are no results under the teacher instructions. What am I missing?

Dave

Does the initial search page

by tscoff - 11/07/2008 - 3:55pm

Does the initial search page show results? It needs to be on the PowerSchool server and the rest needs to be on the ODBC server. Also, are you using the PS user in the ODBC settings? That's the only user with access to the necessary tables to pull the data in that report. The PSNavigator account does not work.

I believe that the report is 5.2 only and does not work under Sybase.

Tim Scoff, tim@scoff.net

The initial search page

by dwertz - 11/10/2008 - 3:35pm

The initial search page shows nothing except for the description text. I have the php files on the web server and the html files on the PowerSchool server (which is 5.2 with Oracle). And yes, I am using the PS user and not PSNavigator.

Re: Low Grades Report

by gmara - 10/09/2008 - 4:35pm

I get this when it hits the lowgrades.php after clicking Submit. Any ideas? Thanks!

Gil

++++++++++++++++++++++++++++

= rt.StartDate INNER JOIN PSM_Assignment a ON a.ID = PSM_SectionAssignment.AssignmentID INNER JOIN PSM_AssignmentCategory ON a.AssignmentCategoryID = PSM_AssignmentCategory.ID INNER JOIN Sections ON Sections.Section_Number = PSM_Section.SectionIdentifier AND Sections.Course_Number = c.CourseCode INNER JOIN SYNC_TeacherMap ON SYNC_TeacherMap.TeacherID = t.ID INNER JOIN Teachers ON SYNC_TeacherMap.TeachersDCID = Teachers.DCID INNER JOIN PSM_School ON PSM_SchoolCourse.SchoolID = PSM_School.ID WHERE Teachers.ID = $Teacher AND fs.Score < $Percent AND rt.Name = '$Quartile' AND enroll.SectionEnrollmentStatus = 0 AND PSM_Section.TermID >= ( $Year * 100 ) ORDER BY c.Title, s.LastName, s.FirstName, PSM_SectionAssignment.DateAssignmentDue" ); $num_cols = odbc_num_fields($result); $student = ''; ?>

* Print this page out and hand it out to your students for the mid term progress report.
* Each student will print on a separate page.
* The first page prints with nothing but these instructions.
* You can print this out at any time, it pulls the grades directly from your gradebook and it's updated dynamically as you update your grades.
* This report does not necessarily print the same grade that is on the students' report card! Changes made at the office override the data in this report.
* This report lists every student who has a grade lower than % for the grading period.

Individual Progress Report

Current Grade: %

Assignment
Due Date Assignment Category Points Earned /
Points Possible Comment
/

The first place that I'd

by tscoff - 10/10/2008 - 2:47pm

The first place that I'd look is to see if PHP is enabled on the server. PowerSchool does not support PHP, that needs to be installed on an external web server.

What you're seeing is the raw PHP code instead of the results of that PHP code.

Tim Scoff, tim@scoff.net

Erorr when connecting to page

by novicane32 - 10/01/2008 - 5:40pm

I am getting an error message when I try to connect to the php page on my server.

The message is Warning: odbc_connect()[function.odbc-connect]:SQL error:[iODBC][DriverManger]Specified driver could not be loaded.SQL state IM003 in SQLConnect in "my folder path" on line 6 Couldn't connect to ODBC:IM003

I am using the PSNavigate to connect with. Is that what I am doing wrong?

Any help is always appreciated.

Brad Sanders

Yes, you need to use the PS

by tscoff - 10/10/2008 - 2:53pm

Yes, you need to use the PS account in order to make this work. This report queries tables that can only be seen with that account.

Tim Scoff, tim@scoff.net

re: Low Grades Report

by mark.heinig@rcs... - 09/29/2008 - 2:37pm

This is a great report. Thanks! I am having trouble linking the file to runreports.html. I have the code entered correctly, but it is not appearing. Do I need to resync something?

re: Low Grades Report

by brian_andle - 09/29/2008 - 4:59pm

Make sure that you haven't placed the code of the new link inside a [if] statement. The [if] statement may not be true and causing the link not to show.

Brian Andle

Syndicate content Syndicate content