Monday, April 10, 2017

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

Friday, October 14, 2016

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

Thursday, October 13, 2016

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