Skip to content

Classroom and Student Table DB cleanup tasks #246

Description

@patudom
  • Create a script that daily runs a script to find new students in db who have used the "default 5 galaxies" measurements and put them into the IgnoreStudents table.
  • Add Class "status" to Classes table - "seed" "real good data" "real bad data" "test good data" "test bad data"
  • Figure out which classes in the Classes table are garbage test classes and should be added to the IgnoreClasses table.
    • Anything that is "real bad data" or "test bad data" should get ignored.
  • For "real good data" and "test good data" classes, query sizes. If classes have N < 15, then treat them as "small" and add 12 random students to those classes. Added note: Should the "class size" we query here be the total number of students in the class, or the total number of students with complete measurements? Probably the latter?
  • Going forward, figure out how to handle unpadded large classes where only a small number of students have completed all 5 galaxy vel & dist measurements. (Otherwise, they would effectively be a small class datawise even though they are a large class in total student numbers).

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions