Power School - Tips and Tricks for Staff

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

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)