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

Group email parents with Kamar and Gmail

After # EdChatNZ on Thursday night I was really determined to make digital contact with parents and share with them the great work their sons were doing!  At our school we use Kamar to collect absences, store student data and report back to parents.  It has a handy function where you can click on a student and email the parents directly, but I wanted to email all the parents of classes at once.  After a bit of playing around I managed to find a way to do it, here's what I did!!! 1) In Kamar select 'Printing' then select 'Export'  This will save the file so you can copy the addresses into gmail, rather than printing it out. 2) Now you need to select your class - as I wanted to email one class at a time I need to select a single class, but you have to option to select multiple groups.  Click on 'Option Subject' and then type your teacher code into the box.  Your classes should all appear and then when you select the class it will copy into the bo