Skip to main content

Protecting privacy when sharing student data with the community


*revision 2014* The MOE have contacted me and have since said that it is not ok to publish the NSN number online, even if it is not associated with a name and only shared with parents.  To get around this you could use the school student ID number?

After a few conversations at school about the ethics behind sharing student results with parents and other class members +Hamish Arthur came up with an idea that we could hide the student name and use the National Student Number, then unhide the name when we wanted to add data - after about 5 seconds of fiddling with a table in google docs it was clear that this was the way to do it - students and parents can find the boy with the NSN, and the teacher can toggle the hide column - so we wouldn't waste time and easily mismark work when using 9 digit long references instead of names!  This is how you do it..

1) Make sure all the students know their NSN number - they should know this if they are level 2, but some level 1 students might need to be told what it is.  Easy to find on Kamar or your school admin system - they need to know it anyway and should be encouraged to use it.



2) Export from Kamar a spreadsheet containing the NSN numbers (see this how to guide - and modify at step 3 to insert NSN number from NZQA info)



3) Open your student data table and insert a row to the left of the names, copy and paste the NSN numbers (first checking your student data table has the same name order as the new NSN data)



4) Hide the column with the student names by moving the mouse to the top of column 'b' (or the column where the names were stored) and clicking on the small triangle pointing down - you should have the option to hide the column!



5) This is the table that the parents and students will see when they check the homework, when you want to edit the table you can unhide the name by clicking in the area that looks like the picture below and expanding it.



Make sure you have shared the table as 'view only' or anyone will be able to unhide the column!!

# I tried to use 3 different classes data so that I didn't violate privacy issues in this post about violating privacy!! #

Comments

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