Not Grade Formula Example

Alan.P.39
Alan.P.39 Posts: 19 🧭
in Higher Ed / Postsecondary

Does anyone have an example of using the NOT function in a formula grade item? I continue to get errors no matter how many parameters I add/remove.

Tagged:
· Share on Twitter

Best Answer

  • Roqeeb.O.922
    Roqeeb.O.922 Posts: 11
    Answer ✓

    Hi Alan.P.39,

    Thank you for reaching out to the Brightspace Community!

    Examples of using the NOT function can be found below:

    If the average of all three quizzes does not exceed 50%, give the student 20%, otherwise give them 100%.
    IF{NOT {AVG { [Q1.Percent], [Q2.Percent], [Q3.Percent]} <= 50}, 100, 20}

    If the value of Item A is not less than 50 points, give the student 100 points, otherwise give them 0 points.

    IF{NOT{ ([ITEM A.Points Received] <= 50) }, 100, 0}

    The NOT function reverses the value of its argument. Use NOT when you want to make sure a value is not equal to one particular value.

    Hopefully, this helps, and please feel welcome to reach out with more questions!

    Kind regards,

    Roqeeb

    · Share on Twitter

Categories