General Information & Demographics
School and District locations and information were gathered from the USBE website, and student and teacher counts were calculated using course records; a student or teacher is included in this count if they took/taught at least one class in the selected school or district. The student count can be slightly different from enrollment counts because a student may be enrolled in one school but may also take a class in another school. Class size was calculated by taking the average of the student count for each class in the school/district. Classes are defined as a unique combination of Term, Cycle, Class Period, and Course Section, which are part of course records. AP, Concurrent Enrollment (CE), Dual Language Immersion (DLI), and IB class lists were gathered using core code information found on the USBE website and course records.
Student demographics were calculated using student enrollment records gathered from the USBE. Records containing information from 10 or fewer students were removed to protect student privacy.
Test Scores
Test score data for each student from the RISE/Aspire, AP, Financial Literacy, and ACT tests came from the USBE. Average testing scores for each school/district were calculated, masking any information that contained data from 10 or fewer students.
Total & Per Student Spending
School districts and charters submit their expenses to Transparent Utah. Project KIDS uses the data that these entities submit along with more detailed payroll information that districts submit to the Utah Office of the State Auditor for Project KDIS. Data is cleaned and standardized.
Rather than dividing total school/district spending evenly among all students, Project KIDS weighted students based on the amount of time each student spent in a given school by using students' course enrollment information. This allowed us to determine the proportion of a school year that each student was present in a given school. For example, if a student is only in a school for the first half of the year, they will be given half of the resources that a student enrolled in the whole year will receive
Project KIDS also broke down school expense and payroll information into twelve major categories based on financial account codes.
By taking the student weights and subcategory designations together, Project KIDS was able to build a detailed account of student resources, and then aggregate that up to the school and district levels. Expenses on this dashboard may differ from other organization's accounts because of this methodology.