Part of my goal in this Geometry unit was to collect more data on the students and ease the teacher load at the same time by automating the grading.
I naturally thought of Google Forms.
We are two weeks into this unit, and (among other issues) I have a progress tracker that should show the teacher where students are and show the students where to pick up from.
I had this sheet with dropdowns that I could select to see where students were at. The problem was that:
- It doesn't show the score,
- It wasn't automatic.
With a little ChatGPT work, I got a formula using the FLATTEN formula.
=IF(COUNTIF(FLATTEN('Lesson 4 Lesson Snap'!A:AC), A3), "Done", "")
This now gives me something that can automatically mark when students complete a lesson. I still have to go in to see what issues students have and where they need help.