A set of files that will chart the assignments across the class and chart a single students chart. This report uses the new version of Fusion Charts available in 5.2.1
Understanding Charts
Assignment Chart
• The colored lines in the assignment chart indicate where the percentage the point preceding it it
• Blue 80% and greater
• Yellow between 80% and 60%
• Red below 60%
• A break in the line indicates that a score has not been entered for that student
Student Chart
• The blue line is the score the student received
• The orange line is the class average for that assignment
• A break in the blue line indicates that a score has not been entered for this student
• A break in the orange line indicates that either the assignment is out of zero total points or scores for this assignment have not been entered
• IE. Extra credit, future assignments, etc
Tips and Tricks
• Hovering over a point will show detailed information about that point
• Clicking a point on the assignment chart will load that student's assignment history
• Clicking a point on the class average line in the student chart will load the assignment chart for that assignment
• Right clicking on the chart will display an option to print the chart
Version History:
V 1.01 (03/20/2009)
- Initial Release
V 1.1 (04/14/2009)
- Added admin charts
V 1.1.1 (05/07/2009)
- Replaces Double quotes with a space
V 1.1.2 (05/12/2009)
- Now shows 1 Standard Deviation from the mean
- Label has been changed to indicate 1 Standard Deviation
Comments
Teacher Charts/Student Charts
Is there a way to have the assignment chart for the students put on the student/parent side? As a parent of a teenager this would tell me if my son is working hard enough or is the teacher doing enough in the classroom. Our administrators and teachers could not live without these charts. Thank you for all of your hard work!!!!
PowerSchool 6
I have not had any problems with this running on my test server after I upgraded to PowerSchool 6.
No Charts Showing in PT
I am trying to implement this, but in PowerTeacher, I get the list of assignments (no links like on the admin side) and students (no links like on admin side.). I do not get charts.
Also, on the admin side, I get individual student charts, but no chart for how the class did overall.
Can you help with that?
Thanks!
Patti
Great Work!!
Hi All,
Once again have to say Thank You to all your hard work. It is really a very helpful tool for administrator & teachers. When I click on teacher list of assignment some of it will show “no data to display” what does that mean? When I click on the student there is scored entered for that assignment. I would like to understand more on this chart function.
Many Thanks.
Regards,
HC
RE:Great Work!!
The “no data to display” means that a properly formed XML was sent back but there was not any data to display. Do the other assignments work? Are there any non- alphanumeric characters for the assignment? (',",!, etc)
Assignment Chart Vs Student Chart
Hi Tinba,
Thanks for your quick feedback. Some of the assignment really contain special characters such as (:,>,?) but for some of those with normal wording also didn't display the chart. There are assignments that displays the chart nicely. Besides that I would like to understand more about this chart. When click on student info all the assignment chart displayed, the class average fall in 0 means what? If there are assignments that are exempted, will it count into the class average also?
Thanks & Regards,
HC
Thank you!
Great customization - thanks for your hard work and for sharing!!!
Cindy Albright
SIS Manager
Warren Township High School
No assignments/No students
This looks like it might be really cool.
Unfortunately could not get it to work on our test server. I get the the twirly blue circle on the Admin side and on the Teacher side. But when I click on the icon I get a small tabbed box with No assignments and no students. It tried Matt's Uppercase change but it didn't help. And I tried moving in the latest Fusion Charts (our latest is as of 2/28/09) and our latest yui from our live server(our live server has more recent and cleaner changes than our test server) We have 5.2.1.4. Suggestions?
No assignments/No students
I would make sure the link to the page is passing the correct section id in the sectionid variable.
latest on nonfunctioning admin charts
As bizarre as it may seem. We have discovered that the Invalid XML DATA error message only shows when we attempt to chart students enrolled in our English 7, 8 10 or 12 classes. Other courses including English 9 and English 11 chart just fine. This is true from both admin and teacher charting screens. I see no reason why these courses nor their course numbers should be generating the Invalid XML data message...but they do. Any thoughts?
latest on nonfunctioning admin charts
Is there anything special with these courses. Longer periods? Double bookings? Anything outside the normal for PowerSchool.
latest on nonfunctioning admin charts
I can see nothing unique about these courses. Oddly, Ms. Armstrong's 1st period English 7 course will not chart correctly for student charts (INVALID XML DATA error). In second period all these same kids go to Social Studies. This class charts correctly.
re:latest on nonfunctioning admin charts
Can you see the charts from the teacher side? Are they only failing on the admin side for these courses? The coding that creates the charts are nearly identical for both so my guess would be that these same courses won't work on the teacher side either.
Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org
re:latest on nonfunctioning admin charts
You are correct, the charts do not show for the previously mentioned courses in neither the teacher nor the admin side.
re:latest on nonfunctioning admin charts
Something else that could be the problem is the case of the course numbers between the courses table and the sections table if you're using alphanumeric course numbers. I've run into that problem with the low grades report leaving off classes with first year users because both courses and sections were imported into PS but the case for course_number was different for some sections compared to the course and so they didn't match up in sql statements unless you used upper or lower in the sql. For example, in the tlist_sql on the sectionstats.html page, you may have to change
from sections s inner join courses c on c.course_number=s.course_number
to
from sections s inner join courses c on upper(c.course_number)=upper(s.course_number)
Matt
e:latest on nonfunctioning admin charts
All of our course numbers are 4 digits long. Regardless, I applied your script suggestion and the results are still the same. A handful of courses will not chart students data (the assignment data charts just fine). In these courses when I click on a student name the message retrieving Data is soon replaced by the INVALID XML DATA error.
e:latest on nonfunctioning admin charts
What does the XML look like?
re:latest on nonfunctioning admin charts
To Tejas' point, the charts are launched using the section ID and the studentID (not student number). Both values should be unique though if a student left a section then came back he/she would have duplicate CC records and some other records for the same section. It sounds like you have at least 1 student in each of those sections that don't work that has multiple records in the system for the same section.
I just did a test on my system looking for sections that have duplicate studentID records in the SECTIONSCORESID table. When I look up that section's charts I am getting information, however all the students that have duplicate records do not show up in the list to click on. So for a section with 23 students where 13 of those students have duplicate records only the 10 without duplicate records actually show up in the charts and lists.
Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org
re:latest on nonfunctioning admin charts
When I check the SECTIONSCORESID table for the sections in question I receive no duplicate student id. All the students enrolled in the course appear when I look up the course charts all the students names appear. But clicking on a name results in the INVALID XML DATA error.
And this is only for a handful of courses.
re:latest on nonfunctioning admin charts
OK, well I just checked mine again and those names I was referring to don't show up in the list but they do show up on the chart so that wasn't it anyways.
So the assignment charts that show you what each class member earned works but the individual student chart doesn't. Is that correct?
Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org
re:latest on nonfunctioning admin charts
Yes, that is it exactly. But only on that handful of courses mentioned earlier. All other courses and teachers can see charts for assignments and students.
assignment name
Hello,
I had the same issue and I found that the problem for me was that a couple of teachers have used double quotes in the Assignment name. That was causing the xml to be invalid. I'm still on the test server so I just went in to DDA and removed the bad characters and the charts work great now. So, you might want to take a look at the xml file (view source).
Good Luck,
Paula
And Thank you to PowerDataSolutions for all the great work!
Teacher Charts for Admins
Has anyone been able to get the charts to work properly for the admin?
I have created the link, admins are able to see the assignment tab and chart but the are not able to select a student and get that data charted. We get instead an error "Invalid XML Data".
We are using the future enrollment customization screen.
Thanks
re: Teacher Charts for Admins
Where did you put the link? Try adding it as the last thing in the list before the [/tlist_sql].
Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org
teacher charts for admins
Thanks so much for your time on this. I am truly stumped on this one.
I moved the link to the position requested and the error still persists.
Awesome! Thanks! Kathy
Awesome! Thanks!
Kathy Davies
System Information Manager
Lamar County Schools, Ga.
Administrators would love this
Teachers have had the charts available to them since Monday, start of Q4. They find it very helpful. Now the administration also wants to see this data portrayed in charts. Any way to make this available to admins either as a report or via the class roster screen at teacher schedule/teacher name/class roster?
re: Administrators would love this
Version 1.1 now includes admin charts. You have to make your own links since there are so many customizations out there that deal with those pages.
Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org
Administrators view of charts
Thanks so much for this enhancement to Teacher charts. I have created the Admin link and it functions as it should in getting the Admin user to the chart screens. However, when the admin user clicks on the resulting Student Tab and then on a student name or student number we receive an "Invalid XML data" error within the box where graphic data should go. Teachers, from their link, are able to see the graphic data.
BTW, the assignment tab, when selected, correctly charts assignments.
Thoughts?
re: Administrators view of charts
If you notice in the documentation it should mention that the link was for people who have installed the future enrollment customization. If you have not installed that then you will need to use
sectionstats.html?sectionID=~(ID)
That last part was not included with the documentation.
Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org
re:administrators view of charts
Hi Jason, in fact we are using the future enrollments customization and so did use sectionstats.html?sectionid=~(secid;l). Data does pull and graph correctly to view how all students did for a given assignment. However, to view how one student has done for all assignments throughout the year we rec. a light green bordered box with the words "Invalid XML data".
Charts terrific assessment tool
These charts are a great way for teachers to quickly assess student performance. Great work. Well deserved award.
And, amusingly, teachers have requested that I edit the mozilla_blu button on the home page to a picture file (made it a png) since it was exciting them too much.
daveb
Fantastic tool
These charts are wonderful.
I too had teachers who didn't like the blue circle going round and round so I made it a stationary icon also. Just too much excitement for them i guess.
:)
Wonderful job!
Leigh
Awesome!
This is really excellent work.
Any thoughts of making these charts available on the admin side? I showed it to our principal and he would love to be able to use them as a problem-solving tool.
Thanks for sharing this with the PowerSchool community!
Brilliant
This is what we love.
John D
Cubs Fan!
Fusion Charts and Teacher Charts
If we are running Seating Charts 2.0 for Oracle without any problems, is that the same version of Fusion Charts as is used in 5.2.1?
Thanks
Dan Morgan
La Salle High School
Union Gap, WA
Premier 5.2.0.6
Grades 9-12 with 200 Students
PowerPC Duo G5 2.0 Ghz
Fusion Charts and Teacher Charts
These should be the same charts.
Which term(s)
Does this show assignments from the current term or all year long?
Thanks in advance for an help,
-Guy
All Assignments
It shows all the assignments from the class. It does not look at the term at all.
terms...
I'm sure this took a ton of hard work, we all thank you. If you ever make it show assignments for current term only I would be very interested, as many others would be too I would think. Outstanding work!
Doug
5.2.x users
I had to use the following to get this to work:
added to teacher/home.html
/teachers/assignmentcharts/sectionstats.html?sectionid=~(id)" >
awesome add on!
Thanks
Where....
Where in the code did you add the above code?
teacher/home.html
I placed it right after the code for the printer icon. I used the old powergrade icon for the picture. I posted only part of the code in my above comment because it would not display (only as an html link). So make sure you read the PDF for the full line of code.
Charts
Hi: I do not see a .pdf file. I only get lists of assignments or students, no charts. Obviously I'm doing something wrong, any help would be greatly appreciated.
Catharine Teri-Savage
Farmington, CT
RE:Charts
Just click on any assignment or student. It brings up a chart to the right of the list.
Thank you
I can't believe I did not see that!!!!
Great!
This is really cool stuff - it allows longitudinal data analysis without having to launch PTG. Great job, Tejas!
I found an icon, and modified my teachers/home.html to include Charts. Anyone interested?
5.2.0.x users should be advised - this uses the latest FusionCharts, so you'll need to either upgrade, or do what I did:
Set up 5.2.1.x on a test server, then copy the test server's web_root/flash and we_root/scripts/yui folders over to the production server's custom web_root. Not 100% sure about YUI, but it seems like a good idea.
This is the report that won Tejas a PSU Scholarship (AGAIN!) at ALS, BTW. Check it out - very pretty!
How do I get the latest
How do I get the latest Fusion charts?
Set up 5.2.1.x on a test
Set up 5.2.1.x on a test server, then copy the test server's web_root/flash and web_root/scripts/yui folders over to the production server's custom web_root. Not 100% sure about YUI, but it seems like a good idea.