Advanced Student Searches - PowerSchool SIS
You can search for students using various fields. For example, you can search by activities, ethnicity, secondary enrollment, or lunch status. To search for students, do the following:
Activities
Search for students by activities to find students who either participate or do not participate in a given activity. All student records have all activity fields associated with them. If there is a value in the field, the student participates. If the field is blank, the student does not participate.
On the start page, enter an activity field name such as soccer in the Search Students field. The # or = operator is required. For example, by entering soccer# followed by nothing, you search for all records whose the soccer field does not equal blank. You can also search for soccer=1 to pull up all the students in soccer.
Also, you can Search for Activities and you will see all the activities available to search for.
Ethnicity
Search for students by ethnicity.
On the start page, enter ethnicity followed by the code for the ethnic group you want to search in the Search Students field. The = operator is required.
Secondary Enrollments
Search for students who are enrolled at one school and taking classes at a different school. The following search codes are available for the Search Student field. The = operator is required.
Lunch Status
Search for students using the lunch status field. Use the following codes to search for students based on how much they pay for lunch. The = operator is required.
Search Using Group Actions
You can search for students using specific group actions. For example, you can search by GPA, grades/attendance, or perfect attendance. To search for students, do the following:
On the start page, search for and select a group of students.
Click the arrow and select the appropriate Action under Search.
Complete your search.
Do one of the following:
To work with an individual student, click the Current Student Selection and choose the name of the student with whose record you want to work.
To work with the group of students, choose an option from the Select a function for this group of students menu.
GPA
Search for a group of students receiving a particular grade point average using the GPA function. This function is especially useful to locate honor roll students or those receiving failing grades.
Choose whether you would like to scan the Current Student Selection or the total enrolled student population. Complete any combination of the remaining fields and Submit.
Field | Description |
---|---|
Who are enrolled in this | Enter the course.section number to search by course. Enter the period to search by period. Or choose a teacher to search by a specific teacher. |
Whose cumulative GPA is | Choose the cumulative GPA cut-off criteria, and enter the percentage point of the cutoff. Choose a GPA calculation method. |
Whose term GPA is | Enter a store code in the field, such as Q2 or S1. Choose the term GPA cut-off criteria, and enter the percentage point of the cutoff. Choose a GPA calculation method. |
Whose current GPA is | Choose the current GPA cutoff criteria, and enter the percentage point of the cutoff. Choose a GPA calculation method. |
Who were enrolled as of this date | Enter the enrollment cutoff date. |
Who match this search | Enter other criteria to search for students, such as activity membership. |
Search by Grades/Attendance
Select the school for which you would like to find students. Search for a group of students with a specific grade or attendance record using Search by Grades/Attendance.
Choose whether you would like to scan the Current Student Selection or the total enrolled student population.
Enter the minimum number of classes necessary to meet the search criteria. For example, to list students failing at least two classes, enter 2. To list students failing any class, enter 1.
Indicate how you want the results handled by choosing Combined (grades or attendance) or Filtered (grades and attendance) if searching for both grades and attendance.
Complete any combination of the remaining fields and Submit.
The following descriptions are only for fields that require special considerations.
Field | Description |
---|---|
Scan for this final grade | Enter the comparator and the specific letter grades for which you want to scan. Separate multiple grades with commas. |
Scan for this final grade percentage | Enter the comparator and the specific percentage for which you want to scan. |
Scan for this citizenship grade | Enter the comparator and the specific citizenship grades for which you want to scan. Separate multiple grades with commas without spaces. |
Scan for attendance |
|
When scanning attendance | Select Scan all attendance records to scan attendance codes during the current term. Or select Only scan records in this date range to scan attendance codes for a specific time frame within the selected term. If you select Only scan records in this date range, enter the first and last dates of the date range or click the Calendar icon to select the dates. |
Scan for grades in | Choose Historical Grade and enter a value in the Store Code/Final Grade field. For example, if you choose historical grades, enter the store code/final grade, such as Q1 or Q2. This scans the grades for the store code entered for the year of the currently selected term. If you are working in Q3 and enter a store code of Q1, the system scans the Q1 grades for the current year. It does not scan grades from previous years. To do so, change the currently selected term. |
Scan for all classes enrolled | Select As of This Date to scan for all classes enrolled as of a specified date. Or select Anytime During the Current Term to scan for all classes enrolled anytime during the current term. If As of This Date is selected, enter a date or click the Calendar to select a date. |
Results | Select Make this the current selection of students to continue working with the resulting group of students. Or select Display matching students & sections to display each matching student and the term, section, course name, and teacher for which the criteria are met. |
Search for Perfect Attendance
Select the school for which you would like to find students and search for students who have perfect attendance records during a specified period using Search for Perfect Attendance.
Choose the desired attendance mode and whether you would like to scan the Current Student Selection or the total enrolled student population.
Enter the first and last days of the date range to scan using the format mm/dd/yyyy or mm-dd-yyyy.
Enter the attendance codes that do not render students absent. For example, if your school excuses absences when a student performs volunteer work, enter V if that is the code for a volunteer absence at your school.
Click Submit.