Educational Services » Power School - Tips and Tricks for Staff

Power School - Tips and Tricks for Staff

Student Search in Power School

Here are some useful searches to copy and paste into the search bar in PS
 
A search command is a statement of search instructions. Search commands must contain three elements: a field name, a comparator, and a search argument.

 

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

 

Search for inactive students: When you perform searches, Power School only searches active student records in your school. Occasionally you may need to search for students who preregistered for next year, transferred or dropped out of school midyear, or graduated early. To access inactive student records, begin your search command with a forward slash (/)

 

 

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

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. 
 

 

 
 
1) Admin can access the CAASPP reports by selecting a student -> select "State/Province - CA" -> Score Reports.
 
 
 
 
 
2) Teachers can access this information from the teacher portal. Unified Classroom -> Quick Links -> PowerTeacher Portal Home -> select the Backpack icon -> select "Score Reports" from the drop down menu on the top right.

----------------------------------------------------------------------------------------------------------------------------------------------
 
3) Parents can access this information as well on the parent portal browser version. There is a link named "Score Reports" on the navigation menu.
----------------------------------------------------------------------------------------------------------------------------------------------

To look up Student Programs 

Go to Special Functions

 

  Click CALPADS Student Enrollments to display students enrolled.
 
  • CALPADS Student Program Enrollments (displays 144-SPED, 101-504, 127-GATE)
  • CALPADS English Language Acquisition (Students enrolled in ELD - current EL, IFEP, RFEP)