canoepus
commented
1 year ago - Maybe include some diagrams in the minilecture on the worksheet, like the ones in the SQL mentor training.
- Visual presentation of GROUP BY is helpful and students appreciate the diagrams.
- We forgot a table in the Fish problem again :(
- Q1 is good.
- An SM had mad beef with Q3. Problem setup is overall not intuitive in a way that makes the problem not very helpful for student learning. Tables given in the problem are not helpful because there's only one exam for which we have a shirt color; it would be more helpful if there was more overlap (at least 2 or 3 shirt-exam questions). Kinda dumb to evaluate academic performance based on sum of midterm scores (I agree, maybe just instead calculate people's SDs). Don't include this in the worksheet next time/make a new question with similar difficulty.