Skip to main content
Skip table of contents

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:

  1. On the start page, enter the field name to search in the Search Students field.
  2. Enter the appropriate comparator. About Searching provides additional information on comparators.
  3. Click Search.
  4. 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
*secondarystudents=

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
*allstudents=

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.

RA list of students with reduced-cost lunch.
PA list of students with full pay lunch.
EA list of exempt students.
FDCA 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:

  1. On the start page, search for and select a group of students.
  2. Click the [Select Function] arrow and select the appropriate Function under Search.
  3. Complete your search.
  4. 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.

  1. Choose whether you would like to scan the Current Student Selection or the total enrolled student population.
  2. 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.
  3. 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.
  4. 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

  1. Select the attendance mode from Scan this attendance mode.
  2. Select the attendance code to scan for from for this attendance code.
  3. Select a comparator.
  4. Enter the number of instances of the attendance code in the Periods field.
  5. Select:
  • Cumulative per Section Enrollment Record to scan for the number of cumulative attendance codes for each class.
  • Total Count to scan for the number of attendance codes regardless of the section enrollment record.

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.

  1. Choose the desired attendance mode and whether you would like to scan the Current Student Selection or the total enrolled student population.
  2. Enter the first and last days of the date range to scan using the format mm/dd/yyyy or mm-dd-yyyy.

  3. 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.

  4. Click Submit.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.