Grades distribution graph

Another interesting (and very useful) customization I’ve been recently asked to do is a visual representation of the stored grades distribution by school/year/grading period (store code).

You start by choosing the school from a drop down box of schools in your district.

After choosing the school

you will be presented with another drop down box listing the relevant school years.

Again, after choosing the year

you’ll see yet another drop down appear, a drop down containing all the grading periods/bins (for the previously chosen school and year) that have stored grades in them.

Once you’ve chosen the store code/grading bin you’ll have the option (the drop down on the second row) to order your grades a certain way.

What the options mean:

1. If you leave the field blank than the grades on the graph will be ordered “alphabetically” (A,A+,A- a.s.o. for letter grades and 1,2,3 a.s.o. for number grades).
2. “From 1 to 7” – grades from 1 to 7 are listed first, from left to right, everything else comes afterwards ordered alphabetically.
3. “From A to F” – proper ordering of letter grades (A+,A,A- a.s.o.), everything else comes afterwards ordered alphabetically.
4. “By total number” – it counts the number of occurrences of each grade and orders them “ascending” (from 1 occurrence to 1000, let’s say).
5. “By custom string” – allows you to choose, from the list of possible grades, the order in which you’d like them to be displayed (use drag & drop to move the grades around and change their left-to-right display order).
   

Whatever your choice was at the previous step, you can now press the submit button to see the results.

Below are some examples of how the graphs could look like, depending, of course, on your own grades in the database (and the order you choose).

Letter grades, ordered “From A to F”:

Letter grades, ordered “By total number”:

Letter grades, ordered “By custom sorting”:

Number grades, ordered “From 1 to 7”:

Number grades, ordered “By custom sorting”:

You could also report on, based on the same logic, the number of failed or incomplete grades (vs. total grades), or even create an extra option to the order drop down called “failed grades first” (to show first the failed grades and then the rest), for example.

There is virtually no limit to what can be done (counted, displayed and analyzed) on the pattern above as long as the data is there, in your database, and it is consistent (that’s extremely important when you’re doing statistics/graphs).

You can download this customization (as a PowerSchool plugin) here or here. Once installed, you will find its main page called grade_distribution.html under /admin/dashboard. You can then create a link to this page and add it to the left-hand menu or pretty much anywhere you want.

You can email me any comments or questions you might have.

Health Office visits statistics using graphs

Here is a customization I’ve done recently for the Health Office department of an international school.

Its purpose is to have a visual representation of the data collected every time a student enters the Health Office (office visits). In our case it will display statistics over “visit types” (as “categories”) and over “visit time” (as the difference between “time_out” and “time_in”).

The initial screen displays the title of the page, two date entry fields and a submit button.

You can bound your statistics to a certain time window by filling in both the “from” and “to” fields (or either one or the other, depending on your needs) or leave them both blank in order to get a statistics over the entire history of your office visits records (a “total over time”).

Once you chose your time window you can go on and press the submit button to display the results.

The result page showing the statistics will be split into two graphs (example given for time window: Jan 1st – Jul 1st, 2016):

1. Number of Health Office visits
   Includes the total number of office visits and total number of (unique) students during the Health Office over the specified time window.
2. Average Health Office visit times
   Includes the time spent by students and average visit time duration during the specified time window.

The statistics could be further refined/split in the future by, for example, school name (Middle School, High School a.s.o.) or by school year (thus eliminating the need of having tho choose the from/to dates yourself). Of course statistics similar to the above can be done for Immunizations and Screenings, should you be needing them.

There is virtually no limit to what can be done (counted, displayed and analyzed) on the pattern above as long as the data is there, in your database, and it is consistent (that’s extremely important when you’re doing statistics/graphs).

You can download this customization (as a PowerSchool plugin) here or here. Once installed, you will find its main page called HO_visits_graphs.html under /admin/dashboard. You can then create a link to this page and add it to the left-hand menu or pretty much anywhere you want.

You can email me any comments or questions you might have.