Keyboard

Data Validation Queries

The queries shown below can be used in the Custom Exports portion of the cockpit application to verify and validate parts information available in the district database.  

Assessment Results Validation

 
This query will allow for validation of assessment results from multiple sources.
 
   

Assessment Objective Results Validation

 
This query will allow for validation of assessment objective results from multiple sources.
 

 

 

Calendar Date Event Validation

 
This query shows the school year calendar for all schools in the system, allowing the user to make sure the correct descriptions are provided for each school day.  This is important for the MiExcel file creation.
 
   

Class List Verification

 
This query will list class list information for every school, broken down by teacher, section, term and student. It is useful in determining if all class roster information is correctly transferring to the data hub database.
 
   

DAILY ATTENDANCE VERIFICATION

 
This query will list daily attendance events for every student, by school, with details on grade level, absence type and calendar day type.
 
   

DATA FRESHNESS SCRIPT

 
Use this SQL Script to see which tables are populated, when they were first populated, and when they were last updated
 
   

Discipline action taken verification

 

This query will list actions taken for students on discipline incidents.

 
   

NWEA Class Roster Export

 

This query can be used to export data in the NWEA CRF CSV file format.

 
   

SECTION ATTENDANCE VERIFICATION

 
This query provides a breakdown of all of the student absences by section.
 
   

Student Characteristic Verification

 
This query provides student characteristic information including things such as Homeless, Immigrant and Unaccompanied Youth information.
 
   

Student Enrollment Verification

 
This query provides detailed student enrollment and exit-withdraw information.(StudentSchoolAssociation)
 
   

Student Indicator Verification

 
This query provides student indicator information including things such as At-Risk information
 
   

Student Language Usage Analysis

 
This query provides a breakdown of all of the languages indicated for students in the district, the usage type (home, spoken, dominant, etc.) and the total number of students with a given configuration.
 
   

Student Program Verification

 
This query provides student program information including things such as Early Childhood, LEP and Special Education.
 
   

Student Schedule Verification

 
This query lists the schedules for students in all schools, sorted by school, student, term and class period.
 
   

Students Without Parents

 
This query indicates students who are enrolled in a school, but who do not have parent/contact records listed.
 
   

Students Without Schedules

 
This query indicates students who are enrolled in a school, but who do not have a schedule.
 
   

Students with Parents

 
This query indicates students enrolled in a school and their parent.