Pastoral Reporting Dashboard - Google Sheets

[Jake Wills]

Hi there,

I made a pastoral reporting dashboard for my school using automated exports from KAMAR so it is kept up to date on a nightly basis... you can see what I've made here:

https://docs.google.com/spreadsheets/d/13o53wd8F955Th8Gzu1imD7wJ4lWw2TlhGAmvQWgOHK0/edit#gid=1787830064

I figured others might be interested as well, so I made a guide showing how you can re-create the dashboard for yourself, but the principles in this can be applied to many other types of data that is stored inside KAMAR. See the guide here:

https://docs.google.com/document/d/1hq2Sp4m6pQ5S2_zo54XWOAeRWcZjiJm8uBy7IBkrfHo/edit?usp=sharing 

A couple of screenshots:

Hopefully this is helpful to some of you.

Ngā manaakitanga (best wishes),

Jake Wills

Kāpiti College

Margaret Road, Raumati Beach 5032