Student Advanced Search
On this page:
Search Using Fields
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:
- On the start page, enter the field name to search in the Search Students field.
- Enter the appropriate comparator. About Searching provides additional information on comparators.
- Click Search.
- Do one of the following:
- To work with an individual student, click the name of the student with whose record you want to work.
- To work with the group of students, click the [Select Function] arrow and choose a function from Group Functions.
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 chess_club in the Search Students field. The # or = operator is required. For example, by entering chess_club# followed by nothing, you search for all records whose chess club field does not equal blank. Though all students have a chess club field tied to their record, only those on the chess club team have a value in the chess club field. Non-chess club students have nothing in the chess club field. Therefore, PowerSchool eliminates them from the results of the search.
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.
Code | Result |
---|---|
*secondarystudents=all | A list of students in all grades taking classes in the current school but not enrolled. |
*secondarystudents=[grade_level] | A list of students in the selected grade level taking classes in the current school but not enrolled. For example, *secondarystudents=5 displays all 5th graders with secondary enrollments in the current school. |
*allstudents=all | A list of all students in all grades taking classes in the current school, including those enrolled. |
*allstudents=[grade_level} | A list of all students in the selected grade level taking classes in the current school, including those enrolled. For example, *allstudents=5 displays all 5th graders, including those with secondary enrollments in the current school. |
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.
Code | Result |
---|---|
F | A list of students with free lunch. |
R | A list of students with reduced-cost lunch. |
P | A list of students with full pay lunch. |
E | A list of exempt students. |
FDC | A list of Free Direct Certification students. |
Search Using Group Functions
You can search for students using specific group functions. 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 [Select Function] arrow and select the appropriate Function 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.
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.