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.

 

EEM Population Status

This query will show if EEM data is flowing from the CEPI Educational Entity Master system.

 

MSDS Statistics

This query will show which of the MSDS views are populated for state reporting.

 

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.