I have a dataset of pupils and the schools they attend. For each pupil I have a source XY coordinate and a target XY coordinate. I have a table of schools where the school name matches the name in the pupil table. I also have a full featured road network

Checklist QGIS with the Time Manager plugin installed. a PostgreSQL database with PostGIS and pgRouting extensions installed. access to said database through psql or pgAdmin3/4 A quick and dirty workflow to create some animations using a road network and some driving distance calculations. I won't go through the process