Power School - Tips and Tricks for Staff

Useful Search Bar Commands for PS >>>>>>>
Student Search in Power School

Comparator |
Means This |
Does This |
Example |
= |
Equals |
Searches for an exact match of the search argument. |
first_name=Jamaal |
< |
Is less than |
Searches for all matches less than the search argument. |
grade_level<11 |
> |
Is greater than |
Searches for all matches greater than the search argument. |
grade_level>3 |
<= |
Is less than or equal to |
Searches for all matches less than or equal to the search argument. |
grade_level<=10 |
>= |
Is greater than or equal to |
Searches for all matches greater than or equal to the search argument. |
grade_level>=5 |
# |
Does not equal |
Searches for all matches that are anything other than the search argument. |
football# |
in |
One of the values is present in the field |
Searches for all the matches that contain one of the search arguments. Additional search arguments are separated with commas in the search command. |
last_name in yang,holt
(searches for students whose last name is Yang or Holt) |
contains |
The value is contained in the field. |
Searches for matches where the search argument is anywhere in the field. |
street contains maple |
!contain |
The value is not contained in the field. |
Searches for matches where the search argument is not anywhere in the field. |
street !contain maple |
@ |
Wildcard |
Replaces unknown information in the search argument. |
first_name=jacq@
(searches for any student whose first name begins with jacq – such as Jacquine and Jacqueline.) |
Compound searches: You can search the database using multiple search commands simultaneously. When you enter more than one search command in the Search Students field, separate the search commands with a semicolon (;). A semicolon between search commands means ‘and’.
After a list of students is returned, a plus sign (+) prior to the next search command means ‘or’.
Useful Searches in Power School :)
Trying to Find: |
Here's the Search (code to enter in Search Bar on the Start Page in PS) |
What the search is asking PS |
- Students with no Schedule - Students with "X" number of classes |
*number_of_classes=0 *number_of_classes < 6 |
Give me all the students who are enrolled in no classes – or < 6 classes |
October Birthdays Birthdays today |
*birthday>9/30/12;*birthday<11/1/12 *birthday = today |
Give me all the students whose birthday is after Sept 30, but before Nov 1 |
All students in 3rd and 4th grade |
grade_level<5;grade_level>2 |
Give me all students in a grade less than fifth AND a grade greater than 2nd |
All K and 1st graders |
Click on K to select all K, then use +grade_level=1 |
Give me all K students and add to that search all 1st graders |
Last Names with a Jr |
last_name=@jr |
Give me all students whose last name has a jr at the end @ is a wildcard search |
All Students who entered in Nov |
/entrydate>10/31/19;entrydate<12/1/19 |
Give me all students, active and inactive whose entry date is after 10/31 and before 12/01 (the forward slash / will also list inactive students |
Active Students who entered in Nov |
Entry date>10/31/19;entrydate<12/01/19 |
Give me all active students whose entry date is after 10/31 and before12/01 |
Students who left in Nov (gain /loss) |
/exitdate>10/31/19;exitdate<12/01/19;exitdate#6/6/19 |
Give me all students whose exit date is after Oct 31, but not 6/6/19 |
All Students who live on a particular street |
Street contains Main |
Give me all the students who's address is on Main (sub in the street you are looking for) |
All Students whose Mother's Name OR Father's name is.... |
Mother contains Michelle OR Mother contains Smith Father contains John Father contains Crawford |
Give me all students whose mother/father name contains Michelle OR Smith. You can us this search with the first or last name of a parent, but not both first and last name |
All students whose Emergency Contact contains ..... |
emerg_contact_1 contains Jones |
Give me all student whose emergency contact 1 contains the last name Jones. (This works with a first name as well, but again, not first and last) |
All Pre-Registered Students |
/enroll_status=-1 |
Give me all students pre-registered |
Who was active on Oct 21 2019? |
*as_of=10/21/2019 |
Finds all students who were active on that date. A student is active if he or she enrolled in your school on or before the date you enter, or exited on or after the date you enter. |
Students not enrolled in a period |
*not_enrolled_in_period = 1 |
Finds students who are not currently enrolled in a Period 1 course. |
Students in a course Students in a course and section |
*enrolled_in = 010009
*enrolled_in = 010009.1 |
Finds student who are enrolled in Course 010009 (AVID 10) in the current term or only those in Section 1
AVID courses :) Course 010008 (AVID 9) Course 010009 (AVID 10) Course 010011 (AVID 11) Course 010015 (AVID 12)
|
Students not in a course |
*not_enrolled_in = 010009 |
Finds students who are not currently enrolled in Course 010009 (AVID 10). |
Students who have completed a course |
*has_completed_course = 010009 |
Finds students who have at least one entry of Course 010009 on their Historical Grades page. |
Students who have not completed a course |
*has_not_completed_course = 010009 |
Finds students who do not have any entries for Course 010009 on their Historical Grades page |
Students with X amount of credits |
*cumulative_credit_hours < 14 |
Finds students with fewer than 14 overall credit hours on their Historical Grades page. |
Finding F&R |
lunchstatus # P |
Mosaic updates nightly - this will pull a list of F&R students |
Finding CALPADS Ethnicity |
ethnicity=(see code below)
ethnicity=500 for Hispanic
ethnicity=600 for Black or African American
ethnicity=700 for White
ethnicity=400 for Filipino
ethnicity=M for Multiple
ethnicity=100 or American Indian or Alaska Native
ethnicity=200 for Asian
ethnicity=300 for Native Hawaiian/Other Pac Islander
ethnicity=999 TBD (to find out)
|
pulls from demographic screen - schedule reporting - matched to CALPADS 8.1 student snapshot report.
|
How to Find CAASPP Summative and ELPAC Score Reports in PS >>>>>>>



- From the PowerTeacher Portal landing -> select section : student info icon ->
- Select Student on left hand side ->
- Select "Score Reports" from the drop down menu on the top right.->
- Select ALL in the school year drop down (the default is current year and that limits what you can see) - >
- Click Get Reports (this will show all reports available)


How to find Student Programs >>>>>
To look up Student Programs
Go to Special Functions
- CALPADS Student Program Enrollments (displays 144-SPED, 101-504, 127-GATE)
- CALPADS English Language Acquisition (Students enrolled in ELD - current EL, IFEP, RFEP)
Tips and Tricks from the National Power School User Group 2021