I put in a simple formula to add up different sections on a test or an assignment so that it shows up as one grade in their GradeBook but I want to be able to look back and see my addition to determine each grade that was added together. It seems like those formulas randomly disappear and I am left with just the final number. Does anyone know if there is something I can do or that can be done so that those formulas stay so I can look back at them?
But it is not columns that are in my google classroom, these are other manual entries that I have put in. It is as if when I import it does a copy and paste values. Is that part of the routine?
Yes, I have manually entered marks and marks that I import from Google Classroom.
I am entering formulas in the mark column. For example if a student got 12 marks on the first section and 10 marks on the second section I type in "=12+10" when I enter their mark. I realize I could do a second sheet, or record somewhere else, I was just hoping that it would be able to save that and save me the extra recording step.
In what column have you entered this formula? What GradeBook type are you using? If you create a new sheet you can enter formulas there as the new sheet will not affect GradeBook calculations.