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?

Thanks,

Brad Dixon

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.

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.

Thanks

I think I misunderstood your question. I tested adding a formula as a mark and it worked. Is there anything else you may be doing that could overwrite your formulas? Are you importing from Google Classroom?

Yes, I have manually entered marks and marks that I import from Google Classroom.

Okay then it is the import from Google Classroom that is overwriting the formulas. Unfortunately sync is only one way; from Classroom to GradeBook (we wish we could have 2 way sync but it is not possible) which means data entered in GradeBook gets overwritten upon each import.

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?