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

Attendance Comments Report (SQL)

For the current student selection, this report lists the student number, first name, last name, attendance date, course number, period, attendance code and attendance comment for only those students who have an attendance comment. Found at Start Page --> System Reports --> sqlReports 4 --> Attendance --> Attendance Comments Report (here)


Code:
Here

Monday, October 10, 2016

Absence Percentage by Date (Cur School) (SQL)

The Absence Percentage by Date (Cur School) reports absence percent for a school on a given date. The following calculation is used to determine the absence percentage: (Absences) / Enrollment x 100. Found at Start Page --> System Reports --> sqlReports 4 --> Attendance --> Absence Percentage by Date (Cur School) (here)




Code:
Here

Absence Percent by Date Range & Grade (Cur School) (SQL)

The Absence Percent by Date Range & Grade (Cur School), reports absence percent by school and grade. For each grade level, the following calculation is used to determine the absence percentage: (Absences) / Enrollment x 100. Found at Start Page --> System Reports --> sqlReports 4 --> Attendance --> Absence Percent by Date Range & Grade (Cur School) (here)




Code:
Here

Attendance Count Report (Core)

The Attendance Count Report gives period by period attendance for the selected days, student(s), period(s) and code(s). It is found at Start Page --> System Reports --> Attendance Count (here)