Student self assessment - Qualitative Data gathering using google sheets

Spark - MIT have given me the opportunity to explore and figure out a way of developing a way with my students to unpack the curriculum in Visual Arts for themselves. In order to do this successfully, (shoutout Tania Coutts for help with this) I need them to be able to not only self assess, which they do anyway, but to be public and brave about it.

Google sheets is essentially 'live'. 'Protected sheets and ranges' means that I can have multiple editors and lock them down to only what I want them to be able to edit. Qualitative data is significant in understanding how students are managing that top end of the curriculum.

This is where we are at with all of our junior classes. Because it is all of them (13 classes in all) it is a bit of a Himalayan trek to get it all done.

This is a screen shot from one class who are incomplete so far.
Each student can only access their own row. It is colour coded and is my marking schedule anyway for the class, with alterations made to the language, as they tell me some of my criteria were too confusing... They can see what each other are entering right then and there and this can be good or bad. How I manage the culture, as the teacher running the task at the time, is important here. It does take clear explanation first as well.

We are working on refining it with each class and there is differing feedback from each class. So it has to be developed with the class, not for the school.