Concept Mastery Data

Disclaimer: I am not a Google Sheets expert! But I'm pretty good and able to eventually achieve what I'm thinking so that I'm working smarter, not harder. It takes some time, but Sheets is so valuable and such a time saver.

One thing I need to improve on with Standards Based Grading is the recording and reporting of progress. I had a long, painful process this Spring (you can read about it in this reflection post, #5). As I was looking more into options this summer, I ran across Mari Venturino's post on Tracking Data. She has a Google Sheet she keeps and she did a lot of conditional formatting and "=countif". She uses a binary approach to the mastery tasks with either a 0 or 1. I like how she determines the letter grades, and that was something I was already considering (still working out though). Her Sheet was a good starting point for me. I made a copy and started to adjust to the needs of my class and my students. Since it will include student names (alphabetical!) it won't be something I can share with students and parents. 

I've been trying to meet with students on a more regular basis to go over grades and what they need to be working on, so this wouldn't even work for that purpose. My idea was creating something where I would just need to input 1 set of information (student ID#) and then it would import the students data (scores and current grade). Enter "=vlookup"!!! I copied over some data and went to testing. It works BEAUTIFULLY! I'm so excited about this aspect - this will be a game changer to student conferences and discussions. Data Template. The letter grade assigned is based on the level they are performing at on the concepts overall. Here is the current break down that is programmed into the Sheet (subject to change, but thinking it's pretty accurate for this school year):

A… at least 85% of skills are Got it or better; no score is developing, not yet, or missing

B… at least 70% of skills are Got it or better; less than 10% of skills are developing or not yet, and zero skills are missing

C… less than 30% of skills are developing or not yet and zero skills are missing

F… more than 30% of skills are developing, not yet or missing

For the upcoming school year, I also have plans for students to record their own assessment scores. I liked the document that Everybody is a Genius posted about. I plan to make a few tweaks to it since I don't have a 3+ score. Here is my Record Sheet Template (and a second version that is portrait - I made it so it can easily go in a composition book and only 2 sides would need to be trimmed). The other thing I'm going to implement is having students do a self-assessment on the concepts (I do skills/concepts instead of the actual standard since that isn't kid friendly). I love that Sheets has the Checkbox feature now, so you can see how easy it'll be for students. Here is my First Semester Skills list and my Second Semester Skills List for Integrated Math 2. I like including the Mathematical Practices here since they are such a huge aspect of math. You will also notice I'm trying to not have too many skills, so some ideas are together (like sine and cosine are together not separate).

I also still need to figure out how I will inform parents of student progress. I only have a few more weeks though to try to figure out something!