/
Advanced Student Searches - PowerSchool SIS
  • Ready for review
  • 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.

    Searching with Advanced Methods

     

    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.

    Search Codes
    Search Codes

    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:

    1. On the start page, search for and select a group of students.

    2. Click the arrow and select the appropriate Action 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

    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

    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.

    Related content

    Office Staff - Administrator Guides
    Office Staff - Administrator Guides
    Read with this
    Searching PowerSchool Tools - Fields, Comparators, Prefixes
    Searching PowerSchool Tools - Fields, Comparators, Prefixes
    More like this
    Accessing PowerSchool SIS
    Accessing PowerSchool SIS
    Read with this
    Search for Students - PowerSchool SIS
    Search for Students - PowerSchool SIS
    More like this
    PowerSchool Stored Searches - Secondary Admins
    PowerSchool Stored Searches - Secondary Admins
    More like this
    Student Profile View
    Student Profile View
    More like this