Catholic Primary Schools: Literacy Tests – Easier with Google Docs (Google Docs to SAS Template attached)

spreadsheets-iconOne thing I have found working in a Primary School is there is a lot of data collection. Data on students, achievements, goals, reading levels, maths data, and more and more…

A lot of this data then needs to be collated, uploaded to different sources and then sent off to the Catholic Education Office Melbourne (CEO) for their records. I have also found there is a lot of needless double handling – Data is imputed by the teacher (by hand), then all the teachers pass on their data to someone else, this data then needs to be sorted and type up – I’m getting tired just thinking about it.

This is where the collaborative nature of Google Docs is so handy.  By creating one document, all teachers can type in the results of their students at anytime (even easier when they have their iPad handy). Once this document has been completed you simply export and upload it to the relevant source.

Currently we are about do Literacy Observation Tests, these are run in all Catholic Primary Schools in Victoria and the data needs to be exported to the CEO.

Now there is a little work involved, for these tests, they will be uploaded to a reporting package used by the CEO, SAS, so you need to know the correct fields needed for the data, but nice guy that I am, I have figured it out for you.

So, for my CEO school chums, feel free to use the Doc below. Hope it helps!

I will be making more of these for all the testing that goes on in schools and will continue to share them with you all.

Click here to view and add it to your Google Drive