Recently I hosted an online PD webinar over at SimpleK12.com. My webinar was about how I've been collecting assessment data from my students, and by using Excel I can do some cool analysis tricks to get some meaningful feedback not only for myself, but also for my students. I've used the data to set up a reflection essay writing assignment, which blends my music pedagogy with some Common Core ELA anchor standards, and some Math standards too. There is also a bit in the webinar where I talk about using Excel to dig a little deeper into a spreadsheet downloaded from a recent Kahoot formative assessment activity I did with my students. There are all sorts of formative assessment tools available these days, and they give you a spreadsheet after the assessment is done and over with. So what do you do with that data? Can you do something? In my webinar I talk about how I've recoded the data so it makes more sense to me and my students. You can watch the webinar here.
โThe slide deck from my webinar is below
โThe slide deck from my webinar is below