•  Address:
    44001 Garfield Road
    Clinton Township, MI
    48038
  •  Building Maps

PowerSchool Reports



  1. From the Start Page – System Reports
  2. Click on Class Rosters (PDF) near the very bottom of the page
  3. Select the teachers individually by clicking on each name or select multiple teachers using the Ctrl button.
  4. Select individual class periods or all class periods
  5. Select specific enrollment dates or status
  6. Make your selection for Heading font, Size, line height style (see doc for details)
  7. Enter the following into the Heading text box
    • ~(teachername)
    • Class Size ~(No_of_Students)
    • Period ~(expression)
    • Sec# ~(section_number)
    • Room# ~(Room)
    • You can use any variable we chose a lunch code
  8. Enter the following in the Roster columns text box:
    • LastFirst\Name\1
    • Grade_Level\Grade
    • \Mon Lunch
    • \Tues Lunch
    • \Wed Lunch
    • \Thurs Lunch
    • \Fri Lunch
  9. Click Submit at the bottom on the form. Report will be sent to the Report Queue
  10. Once it has completed, click on view
  11. It will open in Adobe to save or print

Class List Lunch Count

From the Start page select Reports from the Functions menu on the left.

Choose Class Roster PDF under the Student Listings heading.

Choose the Teacher(s) that you want to print. To choose more than 1 hold down your control key and select.

Choose the period(s) to include on the report.

Be sure to check –“are currently enrolled in class”- to get only active students in the class.

You can select from several formatting options . List the Heading text for the fields that you will want to include in the format shown below. Continue on with more formatting option along with your Roster column fields. There is an excellent tutorial that explains all the fields in the Mastery in Minutes tutorials.

Once you are finished, click Submit which takes you to your Report Queue and once completed you can view and/or print.

PS Custom Class Roster

  1. From the Functions menu, select System Reports > Setup > Form Letters
  2. Click on New
  3. Give a Detailed Title of the form letter
  4. Modify any information as necessary (default settings shown below) and Submit
  5. Select the title of the form you just created and you will see the link Report Body. Enter name, address, etc. (below is an example of a standard envelope setup – this follows US Postal codes).
  6. If you want to preview the envelope to check for content, etc., select a student.
  7. Select Print a Report and select the report you want to view. Click on Submit. View results from Report Queue window.
  8. If you need to make modifications to the report body, return to the Report Setup and make changes. Re-submit when complete.
  9. When you are ready to use the report, select your group of users from the home page.
  10. Select Print Report from the Functions list
  11. Select the Envelope (Report) you created from the drop down list
  12. Fill in any additional information you may need
  13. Click on Submit
  14. View Results from the Report Queue window.
Creating-Envelopes
  1. From the Functions menu, select System Reports > Setup > Mailing Labels
  2. Click on New
  3. Give your report a detailed Layout Name
  4. Fill in the information (see example shown below – using Avery 5160 labels).
  5. When finished, click on Submit
  6. If you want to preview the label to confirm layout, etc., click on Print from the Mailing Labels window and select your Mailing Label Layout from the drop-down list. *Select One Page Only. Click on Submit. View from the Report Queue window.
  7. When you are ready to use the report, select your group of students from the start page.
  8. Select Print Mailing Labels from the Functions List.
  9. Select the Label you created from the drop down list.
  10. Select other options if needed.
  11. Click on Submit
  12. View results from Report Queue List – Print if all is correct.
Mailing-Labels

Class Size-Gender, Class Size by Teacher, Enhanced Birthday List, etc.

Several of the Engine Reports need to have terms added each year. Below is an example of how to add/edit the terms. The steps are similar for each report.

  • System Reports > Engine tab > Class Size by Teacher
  • Drop down under the term to report to see if your current terms are available.
  • If the correct terms are not there, please follow the steps below:
  • To edit “Class Size-Teacher” report to include current or future terms:
    1. System Reports
    2. Engine tab
    3. Setup
    4. Select “User Vars” in the Class Size-Teacher line
    5. Select TermID

The Default Value for the 12-13 year is 2200 – for the 13-14 year will be 2300

Editing Engine Report Terms

The Enrollment Summary Screen shows the current enrollment by grade level, gender and ethnicity for the students at the selected school or district.

View Enrollment Summary Screen
On the Start Page click Enrollment Summary from the Main Menu.

To View a List of Students by Gender

  1. Click on any blue link to see a list of males in the specific grade or ethnic category. Click on any pink link to see a list of females in the specific grade or ethnic category. To View Graph of Students by Grade or Ethnicity
  2. Click on any of the row or column headings to see a graph with the specific data displayed. For example, clicking Total in Grade.

EnrollmentSummaryScreen

PowerSchool Extra Mailings Label Directions

In the form for each of your student contacts is a place to indicate whether that person is to receive letter mailings.

To print mailing labels for these contacts:

  1. Select students of interest
  2. Choose Reports from the menu
  3. Select the Engine tab
  4. Click Contact Mailing Labels (5160)

This report will pull contacts flagged with “receives mailings” and create a PDF file that can be printed onto Avery 5160 mailing labels. The report can be run for a selected group of students or fall all students at the school.

Extra-mailings

Search for your group of students, for example – *birthday=today or not_enrolled_in_period=1

Once you have your list of students drop down “Search a function for this group of students” and choose the List Student option.

The Student List page is displayed. Here you will enter the fields that you want to appear on your report (list). Enter the title for your report.

Now enter the fields that you want displayed; key in a title for the column heading. If you need to find the code for the field, click on the Fields link and choose a field from the list.

As you can see, you are allowed up to 10 columns.

Padding In Each Cell will add space around the data. Note that it is measured in points. If you don‟t know what number to use, start with 4.

#Rows In Between Breaks can be filled in and you can also select Gridlines to display

Choose your sort if you have an order preference.

When you are finished with this screen, click Submit and your list will display. If the list display needs to be modified, you can click back to Student List in the breadcrumbs and it should return you to the setup screen to modify your report.

To print this list hold down your left mouse button and select from Football Roster down and over to include all the data, right click on the data and choose Copy. Open Word and chose Paste; printed it from there. If you choose to print directly from the PowerSchool page, you will get the entire page with the Functions list on the side.

*Since PowerSchool only displays the first 500 names,you will need to use Select Students by Hand option in the drop down Functions to see the entire list. If you need to print the entire list, choose the List Students option, follow through the Report page setup and Submit.

Find & Print a List of Students

Creating Envelopes

  1. From the Functions menu, select System Reports > Setup > Form Letters
  2. Click on New
  3. Give a Detailed Title of the form letter
  4. Modify any information as necessary (see doc for default settings) and Submit
  5. Select the title of the form you just created and you will see the link Report Body. Enter name, address, etc. (see doc for an example of a standard envelope setup – this follows US Postal codes)
  6. If you want to preview the envelope to check for content, etc., select a student.
  7. Select Print a Report and select the report you want to view. Click on Submit. View results from Report Queue window.
  8. If you need to make modifications to the report body, return to the Report Setup and make changes. Re-submit when complete.
  9. When you are ready to use the report, select your group of users from the home page.
  10. Select Print Report from the Functions list
  11. Select the Envelope (Report) you created from the drop down list
  12. Fill in any additional information you may need
  13. Click on Submit
  14. View Results from the Report Queue window.

Creating-Envelopes

Creating Mailing Labels

  1. From the Functions menu, select System Reports > Setup > Mailing Labels
  2. Click on New
  3. Give your report a detailed Layout Name
  4. Fill in the information (see example shown below – using Avery 5160 labels).
  5. When finished, click on Submit
  6. If you want to preview the label to confirm layout, etc., click on Print from the Mailing Labels window and select your Mailing Label Layout from the drop-down list. *Select One Page Only. Click on Submit. View from the Report Queue window.
  7. When you are ready to use the report, select your group of students from the start page.
  8. Select Print Mailing Labels from the Functions List.
  9. Select the Label you created from the drop down list.
  10. Select other options if needed.
  11. Click on Submit.
  12. View results from Report Queue List – Print if all is correct.

Reference the attached document for Laser Printer instructions.

Mailing Labels

Extra Mailings Labels

For each contact on the MISD custom Student Contacts page there is a place to indicate whether that person is to receive letter mailings.

You will see in the contact screen those contacts who have this option indicated with *Receives mailings*

To print mailing labels for these contacts:

  1. Select students of interest
  2. Choose Reports from the menu
  3. Select the Engine tab
  4. Click Contact Mailing Labels (5160)

This report will pull contacts flagged with ‘receives mailings’ and create a PDF file that can be printed onto Avery 5160 mailing labels. The report can be run for a selected group of students or for all students at the school.

Extra-mailings

Search for your group of students. Once you have your list of students drop down “Search a function for this group of students” and choose the List Student option.

The Student List page is displayed. Here you will enter the fields that you want to appear on your list.

Enter the title which will be your report title. Now enter the fields that you want displayed as key in a title for the column. If you need to find the code for the field, click on the Fields link and choose a field from the list.

In the column on the right, key in the title for the column that you want to see on your report. As you can see, you are allowed up to 10 columns.

Padding In Each Cell will add space around the data and note, it is measured in points. If you don’t know where to start with this number, try 4. #Rows In Between Breaks can be filled in and you can also select Gridlines to display. Below that is your sort options fields which you can list in ascending or descending order.

When you are finished with this screen, click Submit and your list will display. If the list display needs to be modified, you can click back to Student List in the breadcrumbs and it should return you to the setup screen to modify.

List-Students

Mass Print Meeting Attendance Screen

Select your group of students

Select the first student in your group

In their Meeting Attendance screen key in the correct dates and Submit. This
should populate every student in your group’s Meeting Attendance screen.

Go back to your list of selected students and in Functions select to Mass Print a
Student Screen.

In the drop down select Meeting Attendance and Submit

In the pane on the left is the list of students. Click down in that box. Right click
and choose Print

When your Print window opens select the Options tab and check “Print all linked
documents” and select Print.

The first page will be the list of students followed by a screen print for each student.

Mass Print Meeting Attendance Screen[1]

Mass Printing a Screen for a Group of Students

Use Microsoft Internet Explorer, not Firefox, for this procedure.

It’s usually best if you are in the year term.

  1. On the Start page of PowerSchool, select the students you wish to print. Suggestion: Do not try to print all the students in the school at one time if the school has over 1000 students. Do one grade level at a time instead.
  2. Below the list of selected students in functions, select the “Mass Print a Student Screen” function.
  3. The next screen asks: Which student screen would you like to mass print? Scroll down and select the screen you wish to print.

The Mass Printing Instructions are not quite right. Use these:

  • Right click down once on the white background inside the frame around the students’ names then select File > Print. (If you accidentally click more than once you will get the list of names but no screen prints.)
  • Click on the Options tab in the gray printer box. On that Options tab, click in the box titled “Print all linked documents”.
  • Click on the Print button.
  • The first printed sheet contains a list of all the students you selected followed by the screen print for each student.

Consider the time it will take to print a large number of screens. This report does not allow you to select a time to print, so before submitting, think about how long that particular computer and printer will be tied up.

Mass-print-student-screen

Reports/Setup/Report Cards/Progress Report

Select the Heading link and you will see the screen below:

The information in the box above is copied below so you can see the entire text:

<center>^([39]schooladdress)<br>^([39]schoolcity), ^([39]schoolstate)^([39]schoolzip)<br>^([39]schoolphone)<br><br><b>FIRST PROGRESS REPORT</b></center>

^[letter.date]

To the Parent(s) of:

^(first_name) ^(last_name)

^(Mailing_street)

^(Mailing_city), ^(mailing_state) ^(Mailing_zip)

From your main Report Card screen, select Schedule Listing and make your choices. Here is an example of the setup:

From the main Report Card screen select Footer to bring up the following screen:

Below is a copy of the entire text for this Progress Report.

<b>

<center>Oct. 30th In-service 1/2 day, Student’s dismissal at 12:06 pm

Nov. 11th and 12th conferences; Nov. 13th No school for students

PLEASE SIGN AND RETURN THE BOTTOM SECTION TO YOUR CHILD’S TEACHER

***********************************************************************************************</center>

^(first_name) ^(last_name)

Parent/Guardian signature:_______________________________________Date:_______________

Remember, when you are finished select Submit from the main Report Card page.

Progress-Report-Template-Example

Search Command Legend
Comparator Description
= Equals
< Is less than
> Is greater than
<= Is less than or equal to
>= Is greater than or equal to
# Does not equal (anything other than the search)
In One of the values is present in the field
contains Value is contained in the field
!contains Value is not contained in the field
@ Wildcard

The following student search command examples can be used from the start page in PowerSchool.

Search Command Examples  

Search for Birthdays

Search Students: *birthday?=5/1/09; *birthday<=5/31/09

Once you have your student list, you can use the function drop down menu and choose List Students which will bring up the Student List Report where you make your selections and submit to view the list. To print the list, select the title and the list, right click on it and select Print.

Additional Birthday Search Codes: *birthday=today *birthday=4/1

Searching for Birthdays

Use the Section Readiness Report in PTAdmin to determine if all the teacher’s grades are completed and ready to be permanently stored. There is a handy email feature included.

In PowerTeacher Gradebook the teacher must click on the button Q1 in Progress to verify that they have completed their grades and they are ready to be stored. Once they click on the button, a screen will display where they can check the box to indicate they have completed Final Grades and an option to make a comment.

Note: The teachers can unverify by clicking the Grades Completed box, unchecking Final Grades Completed and save, therefore, you will want to run this report and confirm all are completed just before storing grades.

To set up the Section Readiness Report, in PTAdmin you first need to click the Groups menu in the upper right corner to expand, then click the plus sign to the right of Section Groups.

The Section Search box will display. The most common search is a simple section search based on the School Number. Select the School tab and key in the school number. Once you put in your search criteria, click “Add To” to run the search.

You can continue to refine your search if you like and add to, filter by, or remove from, with the criteria that you enter. Once you have the results you are looking for, make sure that you name and save the search. You can always double check your search criteria by clicking on the Criteria tab.

Note: Typically you would want to avoid clicking the Select all within the search results table. This is a way to select by hand from your broader selection. This however changes the query to a hand-picked selection by the record ID in the database rather than the more efficient search parameters you first input to get your search results.

Now you are ready to run the Section Readiness Report. Click on Reports and select the Section Readiness Report.

Select the School or the Section Group you have created, how you want it to Display (Period/Day, Section Number, or Both), whether you want only the ones that are completed, not ready or both, the correct year and reporting term. Select Run Report.

Notice that you can see the teacher verification comments in the results and you can click on the Details link on the far right (see the following example) to see more information about that section’s students and grades. Also note that you can Export All Results.

After clicking on Details the following popup window displays. At the bottom of this screen there is a link to export these results.

After running the report you can click “Email” which will take the distinct list of teachers and populate their email addresses in an email list (they must have an email address on their Edit Information page in order to display in this list). You can modify this list by unchecking the Select box or just verify that it appears correct. Then click Send Email. This will send the email list to the default email client on that machine, most likely yourself. At this point you can either keep the email list on the To line or it can be moved to Cc or Bcc, then type whatever message you want to communicate to the teachers. Possibly you could thank teachers for verifying their grades or encourage them to complete their grades and that they only have 1 more day to verify their grades.

The Custom Report “Gradebook Verification” is also a nice report however it does not have the email feature or the ability to display Details.

MISD-Section-Readiness-Report-Final

List Student’s Age

Select All your students and in the functions dropdown select Quick Export. Key in the following (you can probably copy & paste) and add/remove any fields you need.

lastfirst

grade_level

DOB

~(*evaluate trunc(~(f.div;~(f.sub;~(f.currentdate);~(dob));365.25),0))

Select CRLF in Record Delimiter, check for Column titles on 1st row and Submit. Save the file to your desktop.

Go to your desktop, right click on the file you just saved and open in Excel. This should give you the student’s age in years from today’s date.

Example
Lastfirst Grade Level DOB *evaluateTruncf.div
Anderson, Cody N 9 3/8/1994 16

Student’s Age Report

The MISD Transcripts are an out-of-PowerSchool enhancement developed specifically for Macomb County Schools. There is an Enhancement link on the PowerSchool menu, however you must have a login and password to access the program.

These is also documentation on this Enhancement page to help you setup and run transcripts.

When a student has a schedule change and is enrolled in another course, the grades from the previous course reside in the former teacher’s gradebook. The former teacher views this student as dropped in the gradebook, but cannot view scores unless the former teacher runs the Individual Student Report. The former teacher can either print the report or just view it on the screen. The current teacher cannot see any of this information unless given the report.

In PowerTeacher > Gradebook > Select the class the student was previously in

  1. Expand the “Dropped student” list on the left hand side of the screen.
  2. Highlight the student name.
  3. Click on Reports > Individual Student Report.
  4. Choose Selected Groups and/or Students.
  5. Run the report. You will be asked to View or Save the report.

To view the dropped student’s grades, hilite the name and select Filter Selected from the Student Groups dropdown list.

On the Admin side you can view the scores through PTAdmin and use the instructions above or in All Enrollments select View on the dropped class and a page will display with the assignment grades.

View-Dropped-Students-Grades