GdevApps_LOGO.png
youtube-subscribe-chanell-png-31.png
CONTACT US
FREE TRIAL
  • Home

  • Apps

  • Privacy

  • Refunds

  • FAQs

  • Support

  • More

    0
    1. Support Forum
    2. Support Questions
    3. Formulas for adding up marks disappear
    Search
    Brad Dixon
    Jan 23, 2019

    Formulas for adding up marks disappear

    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

    9 comments
    0
    Help Desk
    Jan 24, 2019

    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.

    0
    Brad Dixon
    Jan 24, 2019

    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

    0
    Help Desk
    Jan 24, 2019

    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?

    0
    Brad Dixon
    Jan 24, 2019

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

    0
    Help Desk
    Jan 24, 2019

    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.



    0
    Brad Dixon
    Jan 24, 2019

    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?

    0
    Help Desk
    Jan 25, 2019

    @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.

    0
    Brad Dixon
    Jan 25, 2019

    @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.

    0
    Help Desk
    Jan 25, 2019

    @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.

    Home
    Apps
    Privacy
    Refunds
    Contact