I'm a teacher and would love a way to organize how my students are doing for different topics.
Using a google sheet like below, I organize how different students are doing with different skills by simply assigning them a value (grade) for each skill.
What I'd love to do is then take a column of data for a specific skill, and break it up into three groups depending on their value. Something like:
Here, each student is placed in a group depending on if their grade was high, medium, or low. The problem is, though, that I can't just drag the formulas across the page: in my "Subtracting Fractions" group, the data is being pulled from column E in the Class 100 Mastery tab, which means that's the wrong data. This seems to be happening because in the process of taking one column and splitting it into three messes with how google sheets wants to increment the columns in my
Any tips for how I can fix this or get around it? It'd be nice to not have to manually edit the formula each time I want to get the data for a specific skill.