You must log in to this site in order to participate in the forum.
Note: This is an excellent document developed by Ergin that includes examples of some of the most asked formula questions. It is also still in development. Please feel free to add your examples to this document by posting a comment. Thanks, J
We have prepared a document summarizing how to use the formula tokens in the formula editor of the gradebook with a few examples. This is currently a draft and you are welcome to contribute. Let us know if you have any questions/comments or any other examples you would like us to include.
There are two ways of copying your gradebook settings from a previous course into a new course:
Copy Gradebook Settings tool allows you to copy your gradebook settings, gradebook macros, categories and assignments. However, it won't copy the links between your gradebook assignments and your content items in the lessons tab, like drop boxes. You have to create those links again by selecting the corresponding associated content item in the assignment settings in the gradebook. Also regarding category settings, a glitch still exists, as described here.
By default, ANGEL calculates category average by dividing the sum of collected points for all assignments in the category by the sum of total possible points. So it counts higher point assignments more.
For example, suppose that in a homework category we have two assignments:
Hw1: 80 pts worth
Hw2: 100 pts worth
A student gets 80 for Hw1, 50 for Hw2. Then the category average for this student is calculated by ANGEL as: (80+50)/(80+100) yielding 72.22% by default.
However, if you'd like to weight all assignments equally, then the category average would slightly be different. In the same example, the student has 80 out of 80 which is 100% for Hw1; 50 out of 100 which is 50% for Hw2. Then the average of these is 75% which would be the category average if both were weighted equally.
In order to weight all assignments in a category equally, you need to enter a formula for that category. To do so:
- in the gradebook, click on "Categories"
- select the checkbox next to the category and click on "Edit Selected"
Currently it is possible to enter a non-numeric grade into the Course Gradebook without having a macro set for it. This will cause the averages and overall grades to not include this assignment. Ex: an editor enters a grade of A. if there was not a macro for A it does not store a numeric value. This causes the grade to not be included in the averages (Student, Assignment, Category, etc..).
A macro is a shortcut for turning letter grades into a score. For example, in this macro setup, when a letter grade of "b" is entered the student gets an 85% for their score. However, it should be noted that macros are case sensitive. In the same macro setup, for instance, when the letter grade of "B" is entered instead, the score will not be saved since "B" is not defined in the setup.
Also, it is not possible to define both cases of a letter together. If you define "B" as "80%" as a new filter in the same example, it will simply update the current lowercase entry.