Teacher Tool: A Student Roster Generator for Somerville

What

The app creates an interactive tool for teachers to view:

• rosters of students that can be grouped and sorted in different ways, including by homeroom, by demographic sub-groups (e.g. low-income students), and by risk level
• profiles of students with attendance and behavioral information over time

Why

Teachers, building-level administrators, and district administrators could use this tool to see patterns in their classroom and target specific interventions to support their students.

User story

As an admin, I want to see which students are at risk and whether they are receiving necessary interventions.

As a teacher, I want to see which students are at risk and target interventions to these students.

As a teacher, I want to see how my students are doing both academically and behaviorally over time.

Installation

This is a Ruby on Rails app and uses a PostgreSQL database. See Code for America's "HowTo" on Rails for more information on deploying and maintaining apps using Rails: https://github.com/codeforamerica/howto/blob/master/Rails.md

Setting up demo data

To set up demo data after you clone the project, run

rake db:seed:demo

In addition to creating demo students, homerooms, and assessment results, this will create a demo educator login defined in db/seeds/demo/demo_educator.seeds.rb. The demo login has an email address of demo@example.com and the password demo-password.

Once you've created the demo data, start a local server by running rails c from the root of your project (i.e. in the folder called somerville-teacher-tool). When the local server is up and running, visit http://localhost:3000/ and log in with your demo login information. You should see the roster view for your (demo) data.

Tests

This app uses the Rspec testing library. To run the test suite:

rspec

Pre-commit

This app comes with a suggested pre-commit file that you can add to your git hooks. It will run the tests before any commits, so you can be sure any changes you add are kosher.

Add to your git hooks:

cp pre-commit .git/hooks/pre-commit
chmod +x .git/hooks/pre-commit

If you have a good reason to skip the test suite and commit straightaway:

git commit --no-verify

Demployment

We are deploying this app on Heroku and you can, too. Be sure to set config variables for DEVISE_SECRET_KEY and SECRET_KEY_BASE in order for your app to deploy properly.

Status timeline

• May 2015: We're considering the app an alpha product now. Our focus is on building out the student profile feature and improving the roster view while testing working iterations with our teacher partners at Healey.
• April 2015: Had our first call with Healey teachers and principal to get feedback on a working prototype of the app using real data.
• March 2015: Started writing and testing functions to import data from Somerville's Student Information System and student assessment sources.
• February 2015: We met with the fantastic 5th grade teacher team at Healey throughout the month to learn about the challenges they face, see the current tools they use, and sketch paper prototypes together.
• January 2015: We kicked up this app during Build Week as a warm-up getting-to-know-you exercise. The initial product idea and subsequent feedback came from Stephanie Hirsch. This app drew from a single set of de-identified sample data from Excel to generate risk levels by homeroom, so it couldn't do anything useful in the wild. We said: "If this demo seems promising to stakeholders and early iterations prove useful, it could grow up over the course of the fellowship year."

Future?

This app could grow in several different ways.

• Sub-views: Create sub-views with more limited and focused access to data. These sub-views could be made available to others within the school community, including parents and students.
• After-school: Incorporate data about after-school programs.
• Behavioral: Incorporate data about behavioral incidents including suspensions and expulsions.
• Interventions: Allow teachers to add interventions to the system and track how they impact student progress. (This is a top priority.)
• Unique URLs: Can be generated to be viewed online at a later time by users with access.
• Exportable Excel: Can be exported of any view for teachers to use at data meetings.
• Printable PDFs: Can be exported of any view for teachers to print out.

Who made this?

Alex, Amir, and Mari from Code for America's Somerville Fellowship Team in collaboration with the City of Somerville and Somerville Public Schools.