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?

@Brad Dixon Oh if they are manual entries not in Google Classroom then they should not be overwritten upon next import. As long as the assignment names are not the same as any in Google Classroom.

@Gdev apps The values themselves are not getting overwritten, it is the formula that I used to enter the value. I want to be able to go back and see the addition I used to calculate the final value but the formulas seem to be overwritten by just the value at some point on a regular basis... I don't really know if it is happening during imports from the classroom.

@Brad Dixon I understand now, yes formulas will be overwritten upon import because the data is put into an array of numbers, not formulas. So in this case, it is not possible to put formulas in as they will be converted to numbers upon Classroom import.