Currently tested on PowerSchool 5.2 to 5.2.1.3
Important - 2.1 has a significant change that requires you to read the instructions included in the Download.
Version 2.6.0 of YUI can cause issues. It is recommended you use 2.5.2 which is available from here - Download 2.5.2
With PowerTeacher Gradebook, Teachers have the ability to set if a student is Missing, Late, Exempt or if the Teacher has collected a assignment. The problem with this is that only the teacher can see this. With these custom pages Parents, Administrators and Teachers can see if the student’s assignment is Collected, Missing, Late or Exempt.
The parent portal is controllable by use of a settings page. Each attribute can be individually disabled.
To use these pages 100% of your district must be using the PowerTeacher Gradebook. If a teacher is still using PowerGrade you will not see any assignments, even though there are assignments.
As of PowerSchool 5.2.1.3, PowerSchool has included a similar version of these pages. There are a few reasons I still prefer this version over PowerSchool's.
- The icons are controllable, the school can turn on/off which icons to show.
- The Category and Score comments are hover over, so your users don't need to click in click out.
- My users prefer the larger icons.
- You can sort by Date/Category/Assignment.
- I can modify the SQL to the specifics of my district.
Version History:
V 1.0-2.4
• Included in Documentation
V 2.5 (4/1/2009)
• 2 Versions included in separate folders. 5.2 to 5.2.1.1 and PS 5.2.1.3 and up
• Updated scoresold.html pages to reflect PowerSchool’s version of Missing/Late/Exempt
• The Comment and Description sections are back to the stock PowerSchool code to lower file size.
• HUGE speed increase on Scores.html pages. The SQL query to retrieve the assignments on my system has been knocked down to .5 seconds from 5 seconds.
V 2.6 (5/7/2009)
• Fixed – Bad Link to Old Scores Page
• Fixed-Assignments without a score would not show
V 2.7 (5/12/2009)
• Fixed – Issue where un-checking “Publish Scores” in PTG would not hide the scores.
• Fixed – Issue where if a Teacher changed the Publish Status of an assignment it may or may not show according to the change.
• New – Added a Publish Date to the Admin and Teacher pages to show when a assignment is set to show to the Parents and Students. If the Publish x Days before due date is selected the Publish Date will show the actual Publish Date as being x Days before the Due Date.
• Explanation – Admin’s and Teachers can see all assignments even if they are not published to parents. Admin’s and Teacher’s will see Never as the Publish Date
Comments
Marvelous!!
Hi All,
Unbelievable Good!!
Thanks for the PDS hard work!!
HC
Web Gradebook Assignment not working as expected
Just applied the new version, definitively faster.
I've found a couple of issues, I'm on 5.2.0.3
- If the assignment is set to not publish scores, scores are still published.
- No matter what the Publish Assignment setting for the assignment is set to, it will only list the assignment if there is a score. If the score is blank, the assignment will not display. Statuses has no effect(collected, late, etc)
- If you use Historical Grades under the current grade display, the "Old Scores" page shows all assignments and not the ones for the quarter. The start/end date is not being passed to the scores page, so it's not available to be passed to the Old Scores page, here's the link from the scores page: scoresold.html?frn=031310500&begdate=&enddate=&fg=Q2
This is true on all pages, Admin, Teachers, and Guardians.
- One of your previous version had an hover alert for the assignment description. Was there a problem with it? Is it safe to add it back in?Never mind on this one, Helps to read the readme.Web Assignment - Assignment not show
Hi,
I am facing the same issues as what you posted. Is there any patch to solve this?
Thanks.
Regards,
HC
Re: Web Assignment - Assignment not show
Fixed.
Brian Andle
Re: Web Assignment - Assignment not show
The historical grade issue is definitively resolved.
There are still some things with the publishing settings though.
If an assignment is set to publish the assignment and not publish the score, it's not appearing. The old page would show the assignment with the statement of "score not published"
I believe it's only using the publish assignment setting if it's set to never. If an assignment is set to publish on a set date in the future, or by due date(which is in the future), the assignment is published even though it shouldn't be.
Other than that, it's a great customization.
Re: Web Assignment - Assignment not show
Your right, I'll work on getting that fixed. When I rewrote the code to speed the page up I added a piece of code that shouldn't be there.
Brian Andle
Re: Web Assignment - Assignment not show
One more, I thought I tested it, but the old scores still has the problem.
- If you use Historical Grades under the current grade display, the "Old Scores" page shows all assignments and not the ones for the quarter. The start/end date is not being passed to the scores page, so it's not available to be passed to the Old Scores page, here's the link from the scores page: scoresold.html?frn=031310500&begdate=&enddate=&fg=Q2
This is true on all pages, Admin, Teachers, and Guardians.
Now it does appear that if you delete the &begdate=&enddate= from the link, it displays the proper information. Do you think you can set a condition for the Scores page so that if it's an historical term, that the &begdate=&enddate= is not used?
Maybe something in the link like ~[if.~[gpv:begdate].not.blank]&begdate=~[gpv:begdate]&enddate~[gpv:enddate]=[/if]
I doubt I have the right syntax for the not blank for a square bracket
Also, I just noticed on at least the admin page that the Old Scores page does not use the wildcard for the alerts.
Re: Web Assignment - Assignment not show
I just posted 2.7. It should fix your problems.
Re: Web Assignment - Assignment not show
Excellent, It's looking like it's doing what it should.
There is still the Oldscore.html issues I listed above your post, but those are minor when compared to everything else you fixed.
Good job on the fixes.
Dan
Re: Web Assignment - Assignment not show
Thanks, and hopefully I can remove the oldscores page soon. The only reason it's there is so that if there was a issue, the issue could be identified and fixed and provide a way to still view the grades. Looking back the first view versions were pretty bad. It took me quite sometime to figure out exactly how all the Milan tables interact with each other and how PTG modifies the fields. Not to mention the different revisions of PTG 1, 1.1, 1.5.
Thanks,
Brian Andle
Re: Web Assignment - Assignment not show
I can definiatly believe the difficult task this was to create and am definiatly glad that you did.
Since I'm a little obsessive, I was able to figure out the link on the scores page for the scoresold page to work properly. So if that page lives on in the next version, this is what I found to work...
< a href=scoresold.html?frn=~[gpv:frn]~[if.~[gpv:begdate]=""][else]&begdate=~[gpv:begdate]&enddate~[gpv:enddate]=[/if]&fg=~[gpv:fg]>Click here< /a>
Dan
Web Assignment - Great Job
Hi All,
Yes it is working right now, I am wondering is that possible to publish the assignment and without publish the score.
Many Thanks.
Regards,
HC
Comments & Heading
This is a wonderful customization. We have teachers knocking down our door for us to get it up for them. However I have two items I can't get to work. I am using version 2.4
1. when the page is loaded it states, "This grading term has not been started by the teacher yet", I have looked at the code but can't figure out why the tb.StoreCode = '~[gpv:fg}' that activates this message can someone help me out with what I am missing?
2. when we hover over the comment icon or click on it compopup.html does not give me an expected result, it just sits there. I am sure there is something I have just over looked.
Toby Searle
Bonneville School Dist. #93
Idaho Falls, ID
Re: Comments & Heading
1. That comment appears when there is no Teacher Comment. If you would like you can search for "This grading term has not been started by the teacher yet", and change it to something like "The Teacher has not entered any comments at this time"
2. the comment icon uses the Yahoo YUI files. Please make sure that you are using YUI 2.5.2 and have installed it by following the instructions in the documentation.
Brian Andle
YUI versions
Hi Brian,
I'm having the same problem with the comment pop-up not working. How does one tell what version of YUI they have? What version comes stock with PS6.1? Will 2.6 or 3.0 also work?
Thanks!
YUI versions
You still need to download 2.5.2 and copy the build folder to the appropriate location per the instructions. I should update to pull directly from Yahoo, but that can slow things down.
web gradebook 2.4
Just wanted to confirm that this is still compatible with powerteacher gradebook 1.1?
Re: web gradebook 2.4
Yes it will work just fine on PTG 1.1.
Brian Andle
Report Codes
Do you know the codes to be able to pull the "late" and "missing" assignments into an object report? Thanks!
Re: Report Cards
There are no codes for this information built into PowerSchool.
Brian Andle
Grade book reports
This customization is WONDERFUL and I will have some very happy teachers, parents and administrators when I've got it up and ready...
I was wondering though, a teacher asked if the comments like late, exempt, missing, collected etc. could somehow be included in their Individual Student Reports and Scoresheet reports from the web gradebook. Does anyone know how I might accomplish this?
Thanks for all that PDS does for Powerschool. This is a great resource.
Jennie Rutzen
Skokie School District 68
Slow response
I am actually seeing the latency from the Parent side and there is a dramatic increase in processor load when pulling the quarter from stored grades as opposed to PTG. I also lose the teacher's section description for that quarter as well. I am reporting this because I know you need the feedback, but this is not a complaint by any means.
Mark LeBlanc
Technology Director
Tri-County RVTHS
147 Pond Street
Franklin, MA 02038
508-528-5400 x219
leblanc@tri-county.tc
Re: Slow response
2.3 includes a slight speed increase and fixes the Teacher comment.
Brian Andle
Web Gradebook Assignment Upgrade V2.2
Great customization - thanks for all your hard work!!!!
Cindy Albright
SIS Manager
Warren Township High School
Speed Issue for just the parent portal?
I've got Q1 setup in the current grade display to pull from Historical Grades. This customization for the teachers and admin is able to pull up the assignments in approx 5 seconds.
I am getting a major delay for the Parent Portal version of the page. It takes approx 30 seconds for the assignments to appear if the quarter in question is a Historical Grade. For any quarter that is Current gradebook, it takes the typical 5 seconds. I tested changing Q1 from Historical to the Current setting and experienced the normal 5 second delay.
This is with YUI 2.5.2, 2.2 of this customization, 1.1 of the enhanced portal, and server version 5.2.0.3
Dan
slowness
Thanks for the ideas Dan.
I have Q1 pulling from Current Grades, so that I can compare what is stored against what is current (in case teachers make changes and forget to tell us).
So it is slow for me even pulling from current. I'm still just playing with the Admin version so far.
I've found that it makes a big difference depending on how many users are on.
Naomi Doughty
MSAD#9
Anyone else have problems with page loading slow?
Just wondering in anyone else's new WebGradebookAssignment Upgrade loads very slow on their systems?
Maybe there's a setting I need to change?
The Mass Entry Standards page also loads very slow.
Naomi Doughty
MSAD#9
What a lot of Work!!!
WOW!!
How did you find out about all those tables you referenced in Scores.html (PSM_FinalScore,PSM....)?
Is the assignment weighting info in those tables anywhere?
It would be great to be able to show the weight of each assignment (not category weight but the assignment weight).
Naomi Doughty
MSAD#9
Re: What a lot of Work!!!
Thanks, it took me a good weekend to figure it all out, and Jason was kind enough to help with how to calculate the letter grade. I'll have to look into the weighting, it should be possible. I'm waiting to see what PowerTeacher 1.5 brings as I'm pretty sure the page won't completely work, as there are quite a few new and cool features that I saw at our last state meeting.
Brian Andle
I got the Weight!
Just took a lucky guess and tried:
PSMA.weight weight,
and it worked!
Does this page load SLOW for you?
Naomi Doughty
MSAD#9
Re: I got the Weight!
The page is quite complicated, I know it's about the same speed as the original page on our system, but we don't have huge amounts of users. When PTG 1.5 comes out I'll see what I can do as I'm sure some pieces will need to be recoded.
Brian Andle
Future Assignments on Parent Portal Score Page
We have updated our custom pages to the most recent package which has solved several issues such as old assignments suddenly not being seen on the custom score page, thank you for fixing that!
We noticed that on the teacher version of the score page the future assignments are showing up but not on the guardian page, they still only show assignments to the current date. Not sure about the admin page and really don't care because we don't really use that, the teachers and parents need the future assignments more than admins.
Are we missing something or can the guardian page be updated so it also shows future assignments. Right now we found a work around by using the teacher page but the top guardian menu is missing (because it is a teacher page).
Thanks so much for your custom pages, they are awesome!
Derek
Re: Future Assignments on Parent Portal Score Page
Fixed in 2.2.
Brian Andle
Brian, This upgrade looks
Brian,
This upgrade looks perfect for us. Can I upload it to our server if we're running
v. 5.2.0.3.0102 and Pearson is hosting us?
Thanks,
Amy Johnson
Montgomery Catholic Preparatory School
Future Assignment
Just downloaded and installed on my test server. Only question I have is regarding assignments with a due date in the future. It looks to me like assignments that are due any time after today do not show up in the new page, but do still show up in the old page. Just wondering if this was by design or not?
Chad Cole
Director of Technology
Western School District
Parma, MI 49269
Re: Future Assignment
Fixed in 2.2.
Brian Andle
Re: Future Assignment
I'm still seeing a problem with version 2.2
I have three future assignments, 1 for immediate publish, 1 for Specified date, and one for 60 days before due date. With the dates chosen, they should all be published.
The only one that is published is the days before due date one.
I think the problem is with this line
AND (PSM_SECTIONASSIGNMETAATTRIBUTE.PUBLISHDAYSBEFOREDUE is null or (PSMSA.DATEASSIGNMENTDUE - PSM_SECTIONASSIGNMETAATTRIBUTE.PUBLISHDAYSBEFOREDUE) <= SYSDATE)
What seems to work is if it's changed to
AND (PSM_SECTIONASSIGNMETAATTRIBUTE.PUBLISHDAYSBEFOREDUE = 0 or (PSMSA.DATEASSIGNMENTDUE - PSM_SECTIONASSIGNMETAATTRIBUTE.PUBLISHDAYSBEFOREDUE) <= SYSDATE).
So I believe that PUBLISHDAYSBEFOREDUE is 0 or the last number you entered for that assignment.
I do not like my fix above because if a person picks 0 as the days before, it will be displayed.
Additionally, my belief is that PTG remembers the value for the days before that you entered, so if you had 60 before as a choice and it's within the 60 days, it would be displayed. If you change to "Due date" without changing the 60 days, it would still display the item even if the due date is in the future. Lastly, if changed to never with the 60 days it would still be displayed.
I almost think that it needs to be a CASE WHEN based upon the drop down box and then the comparisons to see if the proper date has passed. I'm not sure what field and values to use though or I would figure it out on my own.
Dan
Non-Graded Assignments Not Showing Up
Brian / Jason,
Thanks a million for the wonderful customizations. I get compliments everyday for the improvements to both the quicklookup screens and the parent portal screens.
I do have a question concerning the assignments. It seems that the [x:studentscores] displays all assignments, including those that have not yet been scored. This new version that uses tlist_sql does not show assignments unless they have been graded.
However, when the print option is selected, it will print assignments that have not been scored.
This is causing some confusion with parents, mostly (as well as some administrators).
Is there some modification to the tlist_sql that can be made in order to INCLUDE the assignments that do not yet have a score? If so, please enlighten us. I have no problem making any modifications that would help in this regard. I apologize for the intrusion, but my Oracle based sql skills lacking, but I am always willing to learn.
Thanks,
bJamN
Ben Solomon, ALS 2008
Ben, what version are you
Ben, what version are you using? Back in version 1.x I had a problem where assignments with no score caused the page to fail.
Brian Andle
wrong version, but still no Hover Love (admin only)
Brian, it seems that I was using an older version of the customization (v1.x). I have recently upgraded to v2.1 and all looks well.
However, I seem to be experiencing a lack of "hover" action on the admin quicklookup screens. The parent portal version works perfectly. I have been unable to get the hover to work in the admin portal, though.
Thanks a million,
Ben
Re: wrong version, but still no Hover Love (admin only)
Try clearing the browser cache, also check to see if the admin page works on another computer. I have seen issues where it's the browser on that specific computer that causes the problem. Also check for any plug-in's that disable javascript as this is what controls the hover over.
Brian Andle
Problem with YUI
It seems that my problem stemmed from an outdated YUI install.
thanks,
bJamN
Re: Problem with YUI
Good to hear that you got it working.
Brian Andle
Hover not working in Firefox
Hi,
First off, these customizations ROCK!!! You guys are Awesome!!!
One small problem, I installed this customization and it works great with IE. The problem I'm having is to have the hover work with FireFox, is there something that I can do about this?
Thanks
Ted
Re: Hover not working in Firefox
Try clearing the cache in FireFox. I have found that this is what normally fixes this issue.
Brian Andle
Re: Hover not working in Firefox
Brian,
Nope, that didn't work. I also tried to restart firefox, no luck, any other suggestions?
Re: Hover not working in Firefox
What version of FireFox? Try holding the F5 key and clicking the refresh button. I solely FireFox and haven't experienced this issue.
Brian Andle
Re: Hover not working in Firefox
FF 3.0.3 We have it installed across the board.
Tried to refresh and a forced refresh, neither did the trick.
Re: Hover not working in Firefox
Does it work on any computer? Do you have a plugin that disables javascript?
Brian Andle
Couple Questions
Love the availabilty of the missing, exempt etc. Where is the settings page to customize it. Also at the top of the page I get a bunch of extra buttons, like emergency med, change password, etc. What page do I need to go to to delete this and how do I do it.
NB