I use Excel quite heavily – looking at cohort data, children’s attainment and calculating value added scores. All pretty usual teacher stuff. Sometime I look across multiple schools and sometimes nationally, but all pretty standard Excel functionality.
Recently I was looking at a school’s tracking spreadsheet for progress in internal testing. It looked like this:
Basic functionality of taking the scores for the 10 individual tests and calculating an average using the Excel function =Average(data range).
The school wanted to use this data to suggest what set the students should be…
Continue reading at: