IMPORTANT: The following letters are for FormLetters+ / sqlFormLetters - do not import them into sqlReports.
Some letters will require you to narrow the selection of students or staff before running. For example, to avoid blank pages for students when running the Low Grades one, find students with low grades first by either using a sqlReport report that creates a current selection, or use the Search By Grades built-in function to create a current selection.
The screenshots below are based on fictional data. They are in color, but your letters will probably print in black and white. When testing out the letters, run them for just a small selection of students or staff. Use the print preview feature of your browser to view the output before sending the output to a printer. Letters can look different in different browsers, so be sure to view them in the browser you or other admins will be using when printing the letter.
Click on the category name - Attendance, Grades, etc. - to access the letters (only available if you're logged into the site):
| Attendance | Uploaded |
| Student Attendance - Daily - daily attendance information for students, including attendance comments. (screenshot) | 12/27/2019 |
| Student Attendance - Meeting - meeting attendance information for students, including attendance comments. (screenshot) | 12/27/2019 |
| Student Attendance Totals Chart - Meeting - meeting attendance code totals for a student based on a date range. (screenshot) | 12/27/2019 |
| Grades | |
| Low Current Grades - Percent Search - courses with current grades based on grade percent criteria entered by the user. Grades come from the teacher's gradebook. (screenshot) | 12/27/2019 |
| Low Current Grades Grade Search - courses with low current grades based on letter grade criteria entered by the user. Grades come from the teacher's gradebook. (screenshot) | 12/27/2019 |
| Low Stored Grades - courses with low current grades based on criteria entered by the user. Grades come from historical grades. (screenshot) | 12/27/2019 |
| Health | |
| Health Office Visits - health office visits for a student based on the date range entered by the user. (screenshot) | 12/27/2019 |
| Student Immunization History - immunizations for a student. Shows six doses by default but that can be changed in the SQL. (screenshot) | 12/27/2019 |
| Incident Management | |
| Incident Management Information - incidents for a student based on the date range entered by the user. (screenshot) | 12/27/2019 |
| Log Entries | |
| Discipline Log Entries - log entries for a student based on the date range entered by the user. (screenshot) | 12/27/2019 |
| Student Schedules | |
| Student Schedule - basic information for a student schedule. The SQL could be modified to pull information for specific terms. (screenshot) | 1/28/2020 |
| Student Schedule Matrix - an example of a custom letter. The output is similar to the student schedule matrix group function, but with additional information. (screenshot) | 1/28/2020 |
| Archived Versions - the letters above should work with current versions of the SIS. If you're on an older version of the SIS and the above don't work with it, then visit this area for older copies of the letters to try. | 10/19/2022 |
