Family Contact Info, Civic and Early Closure

For the family rep, this report lists his/her siblings, school they attend, homeroom, civic address, the parents' contact information and the early closure information for the family rep and sibling.

Sorted by last name in each homeroom - Here
Sorted by last name - Here

For each family, you need one family rep - set on the modify info page. As well, students that are siblings should be linked on the Family page in PowerSchool (Steps: Here).

Startpage --> System Reports --> SQL Reports --> Linking Family Reports --> Family Contact Info and Civic Address

Code:

Sorted by last name in each homeroom - Here
Sorted by last name - Here

Family Contact Info and Civic Address

For the family rep, this report lists his/her siblings, school they attend, homeroom, civic address and the parents' contact information.

Sorted by last name in each homeroom - Here
Sorted by last name - Here

For each family, you need one family rep - set on the modify info page. As well, students that are siblings should be linked on the Family page in PowerSchool (Steps: Here).

Startpage --> System Reports --> SQL Reports --> Linking Family Reports --> Family Contact Info and Civic Address

Code:

Sorted by last name in each homeroom - Here
Sorted by last name - Here

Number of Family Reps by Homeroom

This report counts the number of family reps in each homeroom. This is ideal for knowing how many paper copies of newsletters, announcements, etc need to be printed or phone calls to be made on unexpected school closures to reach all families. (Here) For each family, you need one family rep - set on the modify info page. As well, students that are siblings should be linked on the Family page in PowerSchool (Steps: Here).


Startpage --> System Reports --> SQL Reports --> Linking Family Reports --> Number of Family Reps by Homeroom

Code:

Here

Family Member Report (SQL)

This report lists the family reps in your building and his/her linked siblings (Here). For each family, you need one family rep - set on the modify info page. As well, students that are siblings should be linked on the Family page in PowerSchool (Steps: Here).

Startpage --> System Reports --> SQL Reports --> Linking Family Reports --> Family Member Report

Code:

Here

Present and Absent Totals (SQL)

For the current selection of students and date range, these reports give the number of school days each student was present or absent. The Present and Absent Totals (Pre-Sept 2016) (Here) should be used for date ranges prior to September 2016 and the Present and Absent Totals (Post-Sept 2016) (Here) should be used for date ranges after September 1, 2016. Found at: Start Page --> System Reports --> sqlReports 4 --> Attendance --> Present and Absent Totals

Code: Pre-Sept 2016 Here Post-Sept 2016 Here

Monthly Absent Totals (Current Selection) (SQL)

For the current selection of students, these reports give monthly and yearly totals for the number of school days each student was present or absent. There are two reports Monthly Absent Totals-LY (Current Selection) (here) when it is a leap year with 29 days in February and Monthly Absent Totals-NYL (Current Selection) (here) when there is not a leap year. Both reports are found at: Start Page --> System Reports --> sqlReports 4 --> Attendance

Code:
Non-Leap Year
Here
Leap Year
Here

Full Attendance Report (With Comments) (SQL)

For the current student selection, this report lists the student number, first name, last name, homeroom, home phone, attendance date, course number, period, attendance code and attendance comment. Found at: Start Page --> System Reports --> sqlReports 4 --> Attendance --> Full Attendance Report (With Comments) (here)

Code:
Here