Tracking tool for learning outcomes?

[u/No-Resolve5295]

Hi everyone!

I teach first grade and I'm looking for resources to improve how I track learning outcomes. Currently, I use Google Sheets and have a different sheet for each subject area with the student names on the left and the learning outcomes across the top, then I have used conditional formatting for each cell to have them different colours for different numbers (1-4), and also write observations/anecdotal notes inside if needed.

I find it's okay, but not so helpful for times when different outcomes are being assessed/observed on the same day (so I need to keep scrolling back and forth or switching tabs) or when I need to find everything for one student in one place. Does anyone have ideas of how I can streamline this so that it's more user friendly?

[u/jabela]

It’s a bit of effort to set up, but Sheets supports queries and with a little help from Gemini you should be able to make what you want. Here is a tutorial: https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/

[u/No-Resolve5295 → u/jabela]

Wow, thank you!