SQL queries that we've found useful, saved for future reference.
These are designed to be run against the MySchoolSask Reporting Database.
- Attendance reason report
- EAL students with levels
- Enrolment number checks
- Enrolments as of a given date
- Enrolments for grades 1 to 3
- Enrolments within a date range - detailed
- Enrolments within a date range - simplified
- Export course rubrics
- Export course transcript and rubric definitions
- Export outcomes for Edsby
- Find PK to 6 classes with a schedule set
- Find SQL view by keyword
- Find the most recent InDate for students with given pupil numbers
- Fountas and Pinnel reading assessments
- Jordan's Principle attendance report
- Next year scripts
- On-reserve report
- Reserve of residency code
- Student enrolment and return numbers
- Student export for course requests
These are specific to Living Sky School Division's Navision instance, and will probably not work for any other Navision.
To help handle or make sense of the results of the queries in this repository
- Split a CSV into multiple files by a given column - Example: You have a file with all schools' data in it, and you want separate files for each school.