Participation points are a big part of the way I teach. The problem is keeping track. In the past, I've printed slips of paper with my roster and gave kids tally marks. Being absent minded, I often lost those papers. I tried carrying my iPad around and marking a Google Form to tally points. That was time consuming. I have even done a strategy called feedback tokens where I printed out hundreds of business card size tokens and gave them to students for participation, etc. and had them "cash" in at the end of class. That worked, but was a management nightmare.
Now that students are back face to face, I've been looking for a way to digitally track participation points. I did a few Google searches and found quite a few apps for chores, etc., paid services, but nothing free, that would meet my needs. I tried using a spreadsheet on my iPad, but trying mark kids in each cell was cumbersome. As I kept searching, I stumbled across a post by Alice Keeler. Duh! Of course Alice would have a spreadsheet hack for this. Why didn't I go there first. She loves to say, "The answer is always a spreadsheet". In this instance, she is absolutely correct!
Alice posted a sample of what I am trying to do with a spreadsheet using checkboxes. Click here to view Alice's post. It hit me! Create a spreadsheet like Alice did, using checkboxes, access it on my iPad and I can mark points for students quickly and easily using my Apple Pencil. As I went about developing my participation points spreadsheet, I thought this would also be good for tasks such as keeping track of student restroom use as well. Since you can duplicate sheets, my restroom log was two clicks away.