hogan usecase - UMKCNSF/UMKC--HACKATHON GitHub Wiki

Problem Statement:

Hogan Preparatory Academy (a K-12 charter school district) uses multiple data platforms that collect and manage different types of data. The big three types of data collected are attendance, behavior, and achievement. Administrators need to be able to use data to make decisions about interventions for particular students (by indicator at a single point in time or over time) as well as understand patterns that occur to inform school-wide or group interventions (across indicators), and on a regular basis. We are currently working to develop a database which houses all our data and create reports from the data that can easily be manipulated by a user (i.e., a data dashboard). However, the data will need to be routinely updated manually and reporting software seems cumbersome. Help us automate the data process and make reporting user-friendly!

Develop an application that:

  1. Accepts documents from a user. The documents most often used are Excel and .csv files. Bonus points for an application that can also accept and use text documents the in ways described below.

  2. Allows the document submitter to identify which variables in the document should be available for the reporting feature (see #5).

  3. Links documents by the student using at least 1 of 3 IDs – state student number (SSN), local student ID (ID), and/or PowerSchool ID (PSID). Every document will have at least 1 of the 3 IDs included.

  4. Codes data longitudinally by date for reporting capability.

  5. Includes the ability to generate reports or a data dashboard that users can easily manipulate using the variable names identified for this feature. The reporting/dashboard feature should include the ability to change the level of observation (i.e., observe data for an individual student, classroom, school, or district).

Examples of reports typically needed by administrators:

Attendance

Attendance trends over time by district and building.

Early Warning Indicator

Attendance, behavior, and achievement trends over time by the student to flag students with low attendance, high behavior incidents, and low achievement.

Student Growth

Change in achievement indicator between testing periods by building, grade level, teacher, or st