u/Gloomy_Sound_3281

I am a teacher grading students and I am trying to create 4 columns. One is for 15 percent of the grade, second for 15 percent, third for 70 percent, and fourth for the whole 100. For all four columns it needs to be a ratio. So for the first column it would essentially be, student A: 12/15, student B: 14/15, and so on. How would I create this categorization quickly and easily?

Thanks!