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


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 !