Calculating GPA and Class Rank

NOTE: You can double click on any screen image to enlarge it.  When you want to go back to the blog, click on the X in the upper right corner of the image. 

Powerschool allows you to calculate GPA's and Class Ranks for students.  There are several steps to the process.  First you have to select the calculation methods for your school.  To do this, select School from the main Powerschool menu, and then select Class Rank.

The next step is to select the Class Rank Method(s) that you want to use at your school.  Class rank methods are created at the district level, and there are several to choose from.  Their names are self explanatory, so you should be able to find the method you are looking for.  If you do not see the method you need, call the Diocese and ask too have it created.  To select the class rank methods, click on Class Rank Methods.

This screen lists all of the methods selected for your school.  If you need a new method, click on New and select the methods you want to use from the list.  Caution : only select the methods you really want, because when you do the next step, Recalculation, you may experience a wait since all methods are recalculated for the entire school. 

Once you have selected your Class Rank Methods, you should recalculate the Class Rank.  Even though the Recalculation Frequency says Daily, I recommend recalculating before running the class rank report.  To recalculate, Click on Recalculation Frequency, and the Recalculate Now.

As I said earlier, the recalculation does take some time.  Once you  have recalculated, you can run your reports.  Go bck to the main Powerschool menu and select Reports.  Scroll down to the Class Ranking report and click on it.

Finally, you need to set up the report you wish to run by selecting the grade level and class rank method.

The resulting report will appear on the screen.  You do not need to go to the report queue to access it.  It lists all students, their calculated average, and their class rank and percentile.

Viewing / Entering Test Scores

NOTE: You can double click on any screen image to enlarge it.  When you want to go back to the blog, click on the X in the upper right corner of the image. 

By the middle of the summer 2012, Terra Nova scores for all students who coded in a valid Student ID Code on their Terra Nova booklets, will be available in Powerschool.  For other students, the scores can be entered manually.

Several other Tests are available for entry, but since we do not receive anything electronically, they cannot be uploaded by the Office of Schools.  However, they can be entered manually and viewed.

To get to the Test Scores screen, select a student and click on Test Scores.

After clicking on the specific test score you want, you will be brought to this screen. If scores do not exist for the student, click on the drop down box next to Enter New Scores, and select the test you want.  The following screen will be blank, and you can enter the scores.

Teacher Personal & Certification Information

NOTE: You can double click on any screen image to enlarge it.  When you want to go back to the blog, click on the X in the upper right corner of the image. 

Every October, the Office of School collects information about the teachers at you schools.  These spreadsheets contain many pieces of data for your teachers.  The data supplied by you will be loaded into the Powerschool system.  Hopefully, next year, the Office of Schools will produce the spreadsheets for you, and forward them to you for salary information only. Two new custom screens have been created in Powerschool to collect and list teacher information.

To get to these screens, you must first select a teacher.  To do this, click on Staff from the main menu, and then select the staff member you want.  Just like selecting students, you can select a staff person by first letter of their last name, or by entering part of their last name in the Search box.

  After selecting the staff member, click on Staff Certification to view certification information for the teacher.

Here you can enter or update information for the teacher.  In the case of new teachers, you will need to go here to enter their certification information.

You can then click on Staff information Form to enter or view or add additional information for your teachers.

Ad Hoc Reporting

NOTE: You can double click on any screen image to enlarge it.  When you want to go back to the blog, click on the X in the upper right corner of the image. 

Many times you will need a report showing fields that do not exist on any pre-written report.  In this case, you  can create your own report.

The first thing you need to do is select the students you want to appear on the report.  You can select them by the first letter of their last name, by their grade, or by entering search criteria in the Search Students box.  You can enter just a partial last name and have the system search for the student you want, or you can enter some kind of search criteria where you search for students that meet your criteria.

In the example below, I am searching for students who have been identified as the youngest in their families.  All students who match the search are listed below the search box.

To create your report, click on the Function drop down box and select List Students.

The List Students function allows you to select up to 10 fields for you report.  If you know the field name on the data base, you can enter it into the field name boxes, but if you don't know the name, you should click on the Fields selection in blue.  Once you do this, the field list box will appear, and you can select the field you want.  Repeat this step for each field you want on your report.

As you can see, the Field list box is very small.  You can expand the size of the box in order to see more fields.  To do this, first put the mouse pointer in the title bar at the top of the Field List box, and click and drag the box to the upper left hand corner.  Next, put the mouse pointer in the bottom right corner of the Field List box, and drag it to make the box bigger.

As you select the fields for your report, they show up in the List Student screen boxes.  You can add a title for your report as well as column titles for the fields you selected.  You can also enter sort criteria for your selected fields.  If no sort criteria is entered, the report will be produced in last name alphabetical order.  In the case below, this report is sorted by grade and then last name.

Here is what the report looks like.

 You can go to file / print to print the report, or you can use the mouse to highlight the entire report, then right click the mouse and hit copy.  Next, open up a blank excel spreadsheet, and right click in the first cell and select paste.  All of the data will appear in column on your spreadsheet.

Powerschool Logs

NOTE: You can double click on any screen image to enlarge it.  When you want to go back to the blog, click on the X in the upper right corner of the image. 


The Powerschool Log is a function that is not used by many schools.  Some schools have started to use the Nurse's log to track student visits to the Nurse's office, and our High School use the Discipline Log, but it is something that all principals can use to store notes electronically.  In this post, I will concentrate on the Medical and Discipline logs, but in addition to these, there are log categories for Attendance, Counselor Notes, Grade Changes, and Parental Contact.  To create a log entry for a student, first, select the student, and then click on Log Entries, under the Main Header Administration.

When you get to the Log Entries screen, you will see all of the old log entries for the student.  If you wish to review one of these entries, click on the date and you will be taken to the Log screen.  If you want to enter a new entry, click on New, and you will be given a blank Log Entry screen.

 

Here is the New Log Entry screen with information entered for a Nurse visit by a student.  All of the data in the red circles was entered for this particular incident.  Many of the entry fields have drop down boxes to help.  The incident entered below is shown on the previous screen, circled in red.  Not all information needs to be entered, but at the very least, you should enter date, author, log type, title and log text.  Sub type is useful, but can usually be determined by reading the log text.

Reviewing Log Entries

You can select and view log entries by entering selection criteria.  After selecting the entries, you can, at this time,  print reports for Medical and Discipline log entries only.  Here is how you view the entries or create these reports.

The first thing you need to do is to select the log entries you want to see.  You do this by clicking on Special Functions then selecting Search Log Entries.

This takes you to the Log Entries Search screen where you enter your search criteria.  The only thing you have to enter here is the Log Type, but by entering other criteria, you can narrow down your search.

 After submitting this, the Log Entry Functions screen will give you a choice on how to view your log entries.  Note that the number of entries is shown on the screen.

If you choose List Log Entries, this screen appears showing the entries.

If you chose either Medical or Discipline log entries, you can request a printed report.  The Print Log Entries Screen has a drop down box to allow you to select the report you want.  Be sure to select Medical Log Report or BGA Student Discipline Report depending on which entries you selected. 

Here is a sample of the Medical Log Report.

Report Engine Reports

NOTE: You can double click on any screen image to enlarge it.  When you want to go back to the blog, click on the X in the upper right corner of the image. 

One area to find some useful reports is the Report Engine section.  These are easy to set up reports to give you some quick information.  To get to these reports, select Reports from the main menu, then click on the Engine tab (see red arrow).

The first report I'm going to show is the Enhanced Birthday List.  All report engine reports give you a setup screen to select report criteria.  In the screen below, I am asking for any student whose birthday is in January 2012 (See red circles).

Here is the resulting report.

The other report I will demonstrate is the List Transfer report.  This is a report that I have run for many principals.  First you'll see the setup screen, and then the report itself.

YOU MUST CHOOSE CURRENT SCHOOL ONLY.  Then you should enter a date range.

As noted in red, the student can be selected to get additional information.

Parental Access Statistics

NOTE: You can double click on any screen image to enlarge it.  When you want to go back to the blog, click on the X in the upper right corner of the image. 

 If you are interested in seeing if parents are using Powerschool, you can do two things.  The first report lists parental access statistics for your school.  To run this report, click on Reports, then scroll down to Parental Access Statistics.
 

The resulting report show the total numbers for the school year.  You can take note of two particular numbers to get a good picture of parental access.  The first is Number of Students whose records were accessed.  The second is Number of parents signed up to receive progress reports via email.

If you want to look at parental access for a specific student, then you need to select the student from the main menu, and then click on Net Access (See red circle).  The resulting screen will show all of the times that a parent has accessed the system.