Wednesday, February 25, 2015

Family Rep and Linking Family Members

Too often we send home multiple copies of the same notice, newsletter, etc with siblings. Also, there are times when we may want to contact home and know each household is only receiving one phone call (e.g. unexpected early closures, etc)

We can pull lists or create reports from PowerSchool if you enter Family Reps and link Family Members.

Family Rep

The check box is found on the Modify Info page for each student.



To enter them for your school, you can check each of the students separately...but I would recommend selecting all your students and using the Student Field Value Function to change the field family_rep to a value of 1. Then you can go back and remove just the older siblings' check mark by hand.


Linking Family Members

To link siblings, go to one of the students' Family page.



Click on the Search for Additional Family Members link.




Ensure the Include Student's Last Name in Search checkbox is checked and hit submit. If the sibling has a different last name, enter it in the field before hitting submit.


You will get a list of possible siblings based on the last name. Click the related checkbox for each sibling and hit submit. Note: At this time, please do not use the copy function!

Reports that I have created for you:

1. Number of family reps in each homeroom.
2. Emergency contact list with the family info only listed once for the family rep.

Please take a look at the available reports on http://psreportdepot.blogspot.ca and send me an email if you would like any others.

Friday, February 13, 2015

Attendance Reports

From time to time you may be asked to provide teachers, parents, the Board, etc with the attendance year-to-date or another specific range. I have created several reports that will give you this information if various forms. (Go to my other blog http://psreportdepot.blogspot.ca/ for sql code.)

They all work by first selecting the group of students for which you want the attendance information (e.g. homeroom, grade level, etc.). Here are the steps:

1. Select the student(s).
2. From the Start Page click System Reports.
3. Select the SQL Reports4 Tab.
4. Select Attendance
5. Choose the Report and enter the required Parameters.

Here are the report Samples:


Monthly Absent Totals (NLY) or (LY)

Note: NLY - used when the school year does not contain a leap year.
         LY - used when the school year contains a leap year


NLY - https://sisavrsb.ednet.ns.ca/admin/sqlReports4/params.html?frn=0069323&lrn=005779
LY - https://sisavrsb.ednet.ns.ca/admin/sqlReports4/params.html?frn=0069324&lrn=005779

Present and Absent Totals



https://sisavrsb.ednet.ns.ca/admin/sqlReports4/params.html?frn=0069224&lrn=005779

Full Attendance Report (With Comments)



https://sisavrsb.ednet.ns.ca/admin/sqlReports4/params.html?frn=0066273&lrn=005779

Attendance Comment Report




 https://sisavrsb.ednet.ns.ca/admin/sqlReports4/params.html?frn=0065474&lrn=005779

Tuesday, February 10, 2015

Searching For Students

Using the search bar in PowerSchool to search for students will greatly simplify your life! Below is the provincial guide.

Inschool Search Guide

If you feel good using search bar, here are some common searches for the AVRSB. Remember compound searches (when you want more than one thing to be true in the selected group) are separated by a semi-colon.

Common Search Examples:


Home_Room contains Jack
  • Will find all students with Jack in their homeroom name. Great if you don't remember how you set-up your homeroom names, especially with split classes. For example 1/2 Jackson or Jackson1/2 or Jackson
NS_SSW=1
  • Finds the students in the Student Support Worker Program
NS_NSA=1
  • Finds the students in the Native Student Advisor Program
Grade_Level>5;Grade_Level<9
  • Finds students in grade 6, 7 and 8. Wonderful for separating your middle school students from other students in your school.
Grade_Level=2;Gender=f
  • Finds the female students in grade 2.
Grade_Level=10;NS_Program=S015
  • Finds the students in grade 10 that are in the Early French Immersion Program. Great search for separating student to print report cards.
CurrentIPP=Y
  • Finds the students with a current IPP.
CurrentAdap=Y
  • Finds the students with current adaptations.

***If you have a specific search and you would like me to give you the code, leave me a comment below.***