Data sets available in the Starter Pack

 

The Data Viz Starter Pack comes with a suite of reports so you can get started on the right foot. These reports are built off the base data sets provided to you by the Starter Pack. We’ve documented them in a Google Sheet so that you can get a sense of how we are organizing things as well as the data columns provided in each data set. We also keep sample data sets to help you visualize what these will look in your organization. Below is a little descriptor as to what each data set holds.

Sites

This is the most basic data set we have. The sites data set will give you site id and site name for every school in your district. A small helper set that comes in handy when blending multiple data sets. 

Faculty & Staff

Faculty & Staff will pull together a full staff list for your organization. We give contact information such as email in here, demographic details such as gender and race, and list the staff member’s departments. These details need to be stored in your student information system (SIS) for us to be able to pull them together for you. We can help show you where that is done.

Student Demographics & Enrollment

This data set gives you every student for the current school year, demographic, and enrollment information. Students with any type of enrollment record for the current academic year appear in this data set. This is intentional so you can track things like student retention and student exit reasons. Other student data sets will have student id, but will not have fields such as student name. This is the data set you want to blend with others to pull those fields in. 

Student Attendance

This data set has detailed student attendance records. This will give you a student by student breakdown that includes total absences as well as what makes up that total (how many absences were excused, unexcused, etc).

Course Enrollments

Course Enrollments gives you current class rosters and course information for those classes. This data set is blended with the Student Demographics and Enrollment data set to produce our Class Rosters report. This data set could also be used to monitor class sizes, Honors / AP course enrollment, etc.

Student Behavior Incidents

This is the student discipline data set that tracks suspensions and expulsions for your schools. This can be blended with the Student Demographics and Enrollment data set to track this data by campus, gender, race, etc. The Department of Ed has built out some interesting visualizations that look at suspensions rates by race. We will be expanding the report library to include reports that look at this type of data.

Student Grades: Current

This is a current snapshot of grades across your school. This data set is blended with our Student Demographics and Enrollment to produce our Grade Distribution report. This data set does not track previous enrollments. If a student is in period 1 ELA and she is moved to period 2, this data set will not show a previous enrollment in period 1 ELA.

Student Grades: High School Transcript

This is a data set we can enable for High Schools who could benefit from it. This data set is not used in any reports in our report library at this time, but believe schools will find it handy when building student profiles, graduation checks, and other reports that need to look at a student’s historical grades.

Average Daily Attendance

This is our only data set that includes rolled up data and is actually four separate data sets. All other data sets were created to serve as utility data sets that can be used in many different types of reports. This data set was only created to power our Average Daily Attendance report. 

NWEA Assessment Results

We expect this data set to evolve over time. Currently this data set is a straight export from NWEA via their API and pushes to a Google Sheet. In the next six months we will be bringing schools together to discuss what this data set should look like and expand it to include previous academic years and only the fields that are helpful.

Wow! Those are a lot of data sets. We expect schools that are new to the Starter Pack to go a long way using these base data sets. As mentioned in our infrastructure post, every school receives a forked copy of the main Data Viz Starter Pack scripting library. This means that an advanced user could modify the library to provide additional data sets to their organization. We will then have a process for them to recommend that data set be included in the core data sets and we will support it moving forward. Fun times ahead!

 
Marcos Alcozer