- We want to make sure we know (and the learners know) where they are going and when without having to stop and call out every learner individually or write all 90 learners every day
- We want to make sure that every learner actually does attend workshops (a common question we've had from educators who we've spoken to)
- We didn't want chaos or to spend lots of time sorting it out.
So with some ingenuity (and lots of trial and error!) I've found something that is working (for now). This is a multi step process, but once it was up and working, it's actually quite quick to sort out.
The first step is that in our weekly meetings, my fellow learning coaches and I choose the workshops we are going to offer (based on a variety of factors, which could be its own blog post). After that is decided (usually during our Tuesday meeting) we then make up a Google Form with those choices:
Now comes the fun part. Initially I had just sorted them out by alphabetizing the results. But that took more time than I wanted to spend, so I used the filter formula in Sheets to get from this:
to this:
I made a separate page for our literacy and our math workshops.
For those of you interested, the formula was essentially this:
=filter('Form responses 1'!B:B,('Form responses 1'!D:D="Ideas"))
With Ideas being the name of the workshop. I've further simplified it by using this formula and only changing the headings as necessary.
=filter('Form responses 1'!B:B,('Form responses 1'!C:C=A2))
The A2 just references the top of the list. By separating these into lists it was very easy to cut and paste them into another document for displaying in the habitat:
The next trick was to make sure that our learners were able to look at these and know in advance where and when they needed to be. Having Apple TVs on all of our Habitat TVs proved to be a slight advantage. While I couldn't get our Google Slides to play sans device, I was able to use Flickr to create albums each day so that all the relevant information would cycle through the TVs throughout the day so that the information would always be accessible.
Each week, to save work, we "Copy to" the sheets we sort onto (eg. the Math Workshops) into the new Spreadsheet created for the new form.
But I wrote above that we also wanted to make sure we'd have all of our learners choosing workshops. One (clumsy) solution was for us to go in and check them one-by-one. But I don't like that and it takes a lot of time (and it's not visual).
So I did a bit of googling and found a very useful formula "on the line."
=IF(ISERROR(MATCH(A1,'Form responses 1'!B:B,0)),"Not Registered","Registered")
Essentially what this does is it checks the value in A1 (or A2, A3, A4, etc when you copy it in every line) and sees if it has turned up in Column B in the initial responses. So all I had to do was get a list of all of our 90 learners and put it in Column A and then copy this formula into all of Column B, add a quick conditional formatting (Green if it's Registered, Red if it's Not Registered) and this is what we get:
All but one of our learners have registered this week (and the one who hasn't is in Queenstown).
So that's how we're currently organizing our workshops. It seems like a lot, but once set up, it's very easily copied into a second, third, etc week. Hopefully this has been helpful. I'll make an attempt to share more of my organizational tips on here and if anyone has any ideas of how to improve this system, I'd love to hear from you!