Skip to main content

Easy departmental data collection with google drive

In Physical education, like any other subject we are constantly collecting data on all students - our data then has to get crunched to go into our Kamar reporting system.  A few years ago things were getting a bit messy and data was going missing on old bits of paper and numbers were getting plucked out of the air more often than rugby balls were going missing from our store cupboard!

Google spreadsheets seemed the obvious choice as some of the department were already half using excel to collate data.  I created a shared document (see here for a guide) and headed the table columns for each term/credit period.  Our reporting system required a 1-9 scale for each skill assessed so a formular was applied to turn a beep test score into a numerical value, or a sprint time into a value between 1-9.  This could then be applied to all students for all teachers in the year group.  We could also create totals and averages for each class, teacher and year group.  At the end of each term the list was printed out and pinned up in the gym for the students to admire their efforts!

So how was this different from using an excel document on a shared school network drive?  The main advantages were that the whole department could all edit at the same time - on a shared drive only one copy of a MS office document can be open at once.  Often the data entry was done immediately after school or during breaks, and it was important that we could all be on at the same time.  The ability to chat or comment online was also good for staff and as a HOD - I could quickly scan and comment on any data that looked a bit inaccurate, and leave a comment or mention it to a staff member so they could amend it.  Some classes and students were also invited to 'view' the document - the really keen boys liked seeing the scores updated and there was a great sense of competition and it definitely increased motivation for the students.

2012 Update - We have been using the system now for 2 years and is working well, students and staff are familiar with the system - it is also good to be able to go back in the records and see how a student performed in previous years.



Popular posts from this blog

Learning analytics in secondary schools

What can be learnt from the challenges faced in the use of learning analytics in tertiary institutions, when considering its application in secondary education? photo by Frank Dabek I posed this question after reading several sources regarding the use of learning analytics in education.  As a secondary school teacher I was interested in finding out if there was anything to be learnt about the application of analytics in tertiary setting , before it is embedded into secondary schooling.  The NMC 2013 Horizon Report claims that within 2-3 years it will have developed beyond the 20% penetration point.  After summarising sources I found common themes in the challenges faced when utilising learning analytics. Driving forces behind analytics Error correction and data override Collection of valuable data Ethics, morals and privacy I will evaluate the considerations of each challenge when applied in the secondary context to raise the achievement of learners and inform successfu

Motivation and homework follow up...

Last week I wrote about setting a homework challenge to learn muscles of the body as an online game - the students then had to post screen grabs on google+ to show they had done it and to be in contention for the hallowed prize of 'King of the Muscles' and a cafe voucher. I wasn't quite sure how it was going to go, but by Thursday the buzz in all my senior classes was about ' poke-a-muscle '.  The boys were so excited about it they'd post a score, and then find out that someone had beaten them, and then rush out of the class at interval to get to a computer and beat the top score.  I even had an email on Saturday (two days after the due date) from two boys who had been practicing and spent the afternoon working together to try and beat the original high scores they had submitted with the homework!!!

Gamification of human anatomy

Poke-a-muscle and whack-a-bone are two really fun web apps that refresh understanding of human anatomy.  I'm using them today in my lesson and getting the boys to screen grab their best score and post it to our Google+ community to encourage some healthy competition between the students.  I finished the lesson off with a collaborative problem solving activity that I found on the TES website which asks the students to match up statements about functions of the skeleton !