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

How to collaborate with ChatGPT in the research process and actually learn something

If you have used chatGPT before, it can sometimes feel like talking with someone who has done too much of their 'research on Facebook', filling in gaps with random facts marginally related to the topic just so they can respond and keep the conversation going. However, if applied or 'prompted' correctly, with the user utterly aware of the limitations and ethical considerations, chatGPT can be a helpful research assistant. There is already a wide range of tools available that are built on chatGPT that can support many of the things described below; however, I am still a bit hesitant to rush in with most of them being 'freemium' or asking you to upload your own research and other details or data into their database, I'm happy to stick with the open version of chatGPT as it is what our students have access to. Image created with AI The following guide highlights some prompts, some follow-up questions and most importantly, what you need to do next to follow up a

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!!!

Assessment beyond 2020

Where is external assessment going, and who are we thinking of when we are deciding the future of assessment beyond 2020.   This picture is the actual view I was confronted with, walking into our local community college gym, aged 16.  A place where we had played volleyball, netball and cricket was now being used to measure how much we knew about the things we had spent our school lives practically doing inside this hall, to see if I could pass GCSE PE.  It is now clearly ironic the amount of time that we spent actively exerting ourselves and demonstrating competency in the ‘doing’ of the skill was now going to be measured by writing down everything we knew about it in 2hrs to double check we knew what we were supposed to know.  The previous 24hrs before this vista had seen me cramming the information written on tiny ‘flash cards’ into my short term memory, even up to the walk down the corridor to find my seat I was memorising the diagrams I had drawn about things I don’t reme