PowerSchool: Special Reports
There are a number of Special Reports now available on our PowerSchool Server. These reports are not available via the normal PowerSchool report pages/menus.
Before running any of these reports, please login to PowerSchool first, then click on the links below. Please do not bookmark the individual report URL's below, as they may change in the future.
Last Grade Update
Low Current Grades
MCVSD Grade Distribution Report
Student Birthday List
Course Analysis by Gender
Course Information List
Sections Information List
Student Alerts List
Discipline Log Entries per Student
Log Entries per Student
Student Attendance List Report
Stored Percent Grades
PowerTeacher Gradebook Vs. Stored Grades
Final Grade Setups
------------------
Last Grade Update
This report displays the last time a teacher updated grades or added an assignment in their PowerTeacher Gradebook.
Launch the Last Grade Update Report
Notes: Use the Term(s) option at the bottom of the report screen to narrow your search to the current full-year, marking period, and/or semester before clicking Submit.
Keep in mind that any current class that does not have any grade data entered will be omitted from displaying/printing on our MCVSD report cards and transcripts.
------------------
Low Current Grades
This report will print out a list of students with low/high current grades for the term you specify. The report will run for all the students in the school. The information is pulled from the data table that keeps track of current grades, so please keep in mind the information will only be as up-to-date as the teacher's use of the PowerTeacher Gradebook.
Launch the Low Current Grades Report
Notes: Enter a single Reporting Term to use in the lookup, such as
Q1
Run the report again to lookup other Reporting Terms such asQ2 M1 Q3 Q4 F1 Y1
Set the pull down menu to Percentages
Set the Highest%to55and Lowest%to0to find students with grades at or below 55%
Run the report again, and set the Highest%to200and Lowest%to100.001to find students with grades above 100%When the report is generated, a Grade of
--and Percent of0indicates that the student does not have any grades recorded.
------------------
MCVSD Grade Distribution Report
This special report provides better results than the "built-in" PowerSchool report, since it will display percentage grades in our MCVSD ranges. Before running this report, grades must be stored for the requested reporting term (we typically store grades at the end of a marking period). It reports from the historical (stored) grade table. Sort options are by Course Name, Course Number, or Teacher Name.
The completed report can easily be copied & pasted into Excel for further analysis, if desired.
Notes: Enter a single Reporting Term to use in the lookup, such as
Q1
Run the report again to lookup other Reporting Terms such asQ2 M1 Q3 Q4 F1 Y1
------------------
Student Birthday List
This report will generate a list of students with birth dates in the selected month(s).
------------------
Course Analysis by Gender
A course analysis report of section enrollment by gender for the current term.
Notes: This report may take a LONG time to generate and display in your browser, please be patient. In addition, if your report does not output any data, change to a different "Term" at the top of the PowerSchool page (select semester or full year instead of marking period), then re-run the report.
The completed report can easily be copied & pasted into Excel for further analysis, if desired.
------------------
Course Information List
This report will list some key elements of the active courses in your school, including Course Number, Course Name, Course Credits and more.
------------------
Sections Information List
This report will list some key elements of the active sections in your school.
------------------
Student Alerts List
This report will list those students with alerts based on your alert choice. Possible alerts to list are Discipline Alerts, Medical Alerts, and Guardian Alerts.
Launch the Student Alerts List Report
Notes: Student Discipline, Medical or Guardian alerts are found in the following locations:
Select a Student, then select an alert from the Information or Administration menus on the left side of the Student Screen.
Log Entries--->Edit Discipline Alert (e.g.,Detention each Monday at 2:40pm until further notice.)
Emergency/Medical--->Medical Alert (e.g.,Allergic to Soylent Green.)
Parents/Guardian--->Guardian Alert (e.g.,Grandmother Lena allowed to sign student out.)
------------------
Discipline Log Entries per Student
This report shows all discipline log entries for a student or students based on a date range of when the entries were recorded in PowerSchool.
------------------
Log Entries per Student
This report shows all log entries for a student or students based on a date range of when the entries were recorded in PowerSchool.
------------------
Student Attendance List Report
This report will produce an attendance listing (including attendance comments) for the specified dates. It can be run for the current selection of students or all the students. The default date range is the start and end of the current term setting at the top of the page. If your school does not enter daily attendance comments, then another report, such as the Individual Student Absence Summary (available via "Print a Report" link) is recommended instead of this report.
Important Note: When entering the date ranges for this report, you must use a 4 digit year for the "Start" and "Last" date or you'll generate a blank report. For example, use 9/1/2010 instead of 9/1/10. Our server will auto-enter a 2 digit year by default, so you must change this to 4 digits before clicking the Submit button.
------------------
Stored Percent Grades
This report will print out a list of students with stored grades in a specific percent range for the term you specify. The report will run for all the students in the school. The information is pulled from the historical grades data table that keeps track of stored grades, so the information will only be as up-to-date as the most recent stored grades operation. Do not confuse this with the Low Current Grades report, since they pull from different data tables (historical/stored versus live PowerTeacher Gradebook grades).
Launch the Stored Percent Grades Report
Notes: Enter a single Reporting Term (Store Code) to use in the lookup, such as
Q1
Run the report again to lookup other Reporting Terms such asQ2 M1 Q3 Q4 F1 Y1
Enter a Cutoff Grade Percent - High
Enter a Cutoff Grade Percent - Low
Select a School Year to DisplayThis report may take a LONG time to generate and display in your browser if a large number of students in your school match the search parameters, please be patient.
The completed report can easily be copied & pasted into Excel for further analysis, if desired.
------------------
PowerTeacher Gradebook Vs. Stored Grades
This report will show discrepancies between stored/historical grades and current grades in PowerTeacher Gradebook for all active courses. The change in percent score is displayed in your browser. If the PowerTeacher Gradebook value is lower than the stored grade value then the box is red, if it is higher then it's green. If the percents match but the letter grades do not, then the last box will not be shaded (typically due to a "completed" Incomplete).
This is a useful report to run just before the Tech Group performs a "re-store" operation, since the report summarizes the differences between live data & stored data.
Launch the PowerTeacher Gradebook Vs. Stored Grades Report
Notes:
Y1grades in PowerTeacher Gradebook are a moving target during the school year. Until the course is complete,Y1data will change each time a new assignment grade is entered by the teacher. This report will show changes to all reporting terms, includingY1.Updated Report: Now provides the ability to sort resulting data by any of these five columns: Teacher, Course, Crs Num, Student or Term. To sort, simply click on one of these hyperlinked column titles once your data is displayed.
------------------
Final Grade Setups
This report allows you to view how teachers setup their PowerTeacher Gradebook Final Grades. A benefit of this report is the ability to see multiple courses, multiple teachers Final Grade Setups via the PowerSchool admin interface. You can run this report to verify that teachers are using Category Based Weighting for each Reporting Term, Total Points for the typical
M1andF1Reporting Terms, and most importantly, Term Based Weighting for allY1overall Reporting Term. This report eliminates the need to log in with the teacher to their PowerTeacher Gradebook and manually verify all course's Final Grade Setups.There are still a few visual kinks to work out, a known bug causes some teachers to have duplicate categories and weights show up in the report. This does NOT affect any of their actual PowerTeacher Gradebook setups, it is simply a cosmetic issue with this special report. As an example, for some teachers, categories and weights are being duplicated in the right column (listing Name and Weighting and # of Low Assignments to Discard).
Launch the Final Grade Setups Report
Notes: Start with a valid Course Term for your school, such as full-year (
2009-2010 09-10) a single Semester (09-10 Semester 1), or single Marking Period (09-10 Marking Period 1).
Select a Store Code from the pulldown menu such asQ1 Q2 M1 Q3 Q4 F1 Y1, or select All Bins to show all.
Select the default of All Departments.
Pick a single Course or All Courses, and pick a single Teacher or All Courses.
Leave the Setup Type selector at Any Setup.
Click Submit.As above, some teacher's courses may show up with duplicate categories and weights, these can be ignored (bug fix will be applied to the server as soon as it is available).
An example report setup would be to pick a valid Course Term, select the Y1 Store Code and search All Courses and All Courses. This will generate a report that you can scroll down to scan for a Weighting Type TermBasedWeighting for all Y1 Store Codes. If you see any Y1's with CategoryBasedWeighting or Setup Type of TotalPoints, those teachers need to be contacted ASAP so they can change to the proper Term Based Weighting for all
Y1Reporting Terms, and also verify they have the correct Category Based Weighting for each Reporting Term.Updated Report: Now provides ability to sort the resulting data by any of the displayed columns, such as Teacher, Setup Type, Store Code, Weighting Type and more. To sort, simply click on one of these hyperlinked column titles once your data is displayed.
------------------
If there are any questions, please contact the Tech Group.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Need help from the Tech Group? Use the Online
MCVSD "Information Technology Help Request" form
http://www.mcvsd.org/techhelp/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~