Practice with the Brightspace Gradebook

Create a Gradebook containing the following items:

Hint: Grade item type is Numeric or Pass/Fail.

After completion your Gradebook should look something like this:

Turn 'Workshop attendance' into a bonus item:

After completion your Gradebook should look something like this:

Show the Workshop item as “Present” or “Absent”.

Hint: you have to create a new Scheme.

After completion your Gradebook should look something like this:

Delete an assignment and create a category with assignments, distribute the weight evenly.

Each assignment counts equally in the category, i.e. (20/3 = 6.67% of the overall course grade)

After completion your Gradebook should look something like this:

Use the Gradebook as set up in the previous exercise.

Calculate the final grade using this formula:

=IF{ ([Workshop Attendance.Points Received] >= 6.0), (((0.2 * ((([Assignment 1.Points Received] + [Assignment 2.Points Received]) + [Assignment 3.Points Received]) / 3)) + (0.3 * [Report.Points Received])) + (0.5 * [Final exam.Points Received])), 0 }

else {grade = 0.0}

Hint: For this example change the Calculation Settings in the Gradebook to Formula. And replace the Pass/Fail 'Workshop Attendance' grade item with one of a different type.

Confirm that a student with these grade scenarios have their grades calculated correctly:

Again, use the same as set up in exercise 4, but now you add a resit grade.

Calculate the final grade using the following formula:

=((0.5 * MAX{ [Final exam.Points Received], [Resit exam.Points Received] }) + (0.2 * ((([Assignment 1.Points Received] + [Assignment 2.Points Received]) + [Assignment 3.Points Received]) / 3))) + (0.3 * [Report.Points Received])

Confirm that students with these grade scenarios have their grades calculated correctly:

With all the knowledge you now have you should be able to make the following Gradebook:

After completion your Gradebook should look something like this:

1. Go to Grades > Setup Wizard and start the wizard.
2. In the wizard’s first step make sure you select “Weighted” and continue the wizard with the default options and finish the wizard.
3. Click on Manage Grades > New > Item, choose the desired properties:
   • Assignment: Numeric – Maximum points: 10 – Weight: 15 – Grade scheme: round off at 0,5
   • Workshop attendance: Pass/Fail – Maximum points: 10 – Weight: 5 – Grade scheme: Pass/Fail
   • Report: Numeric – Maximum points: 10 – Weight: 30 – Grade scheme: round off at 0,1
   • Final exam: Numeric – Maximum points: 10 – Weight: 50 – Grade scheme: round off at 0,1

   click Save and Close.

4. You can add more grade items via New > Item, and choose the corresponding properties for every grade item. Then click Save and Close.

1. Go to Manage Grades, where you can still find the grade items you created in example 1.
2. Go to the grade item Workshop attendance, open the drop-down menu and click on Edit.
3. Change the properties as requested, select Bonus and click Save and Close.
4. Make sure that Can Exceed is checked in the Calculated Final Grade grade item, .

1. Go to the Schemes tab and click on New scheme. Give the scheme a name (‘Absent or Present’) and fill in the ranges:

   Symbol	Start %	Assigned %
   Absent	0	0
   Present	100	100

2. Look up Workshop attendance on the Manage grades tab. Click the downward arrow next to it and choose Edit from the drop-down menu.
3. Change the Grade Scheme to Absent or Present and click Save and Close.

1. Add a new category called “Assignments” via Manage Grades > New > Category.
2. To delete a category, click More Actions. Check the item(s) you want to delete > Delete.
3. Give this category the requested weight, select Distribute weight by points across all items in the category and click Save and Close.
4. Go to New > Item and create a new grade item called “Assignment 1”, give it the properties requested and assign this item to the category “Assignments”. Repeat this step for Assignments 2 and 3.

1. Make sure the Grading System is set to ‘Formula’ in the calculation options (Settings  > Calculating Options) or by redoing the wizard.
2. For Exercise 5 create a new Workshop Attendance grade item of the numeric type to be able to fill in the numerical grades and remove the old one. For Exercise 6 create a new Resit Exam grade item.
3. Once the necessary grade items have been created, go to Manage Grades and click on Final Calculated Grade’. Here you’ll find the option Edit Using the Formula Editor. Click on the link to edit. Entry is done by using the buttons and menus that pop up on the screen. Navigation is done using the arrow-buttons on this page (using your keyboard does not work).
4. When the formula has been entered you can check if you made the formula as intended, by using the Preview button. Once satisfied; click Insert.

1. Delete all the current Grade Items (go to Manage Grades and under More Actions click on Delete. Then select all and click on Delete. A pop-up window appears where you have to click on Delete again).
2. Make sure the Grading System is set to Weighted in the calculation options (Settings > Calculation options) or by redoing the wizard.
3. Create the Categories “Assignments” , “Online quizzes” and “Final Exam” via Manage Grades > New > Category. Give them the proper weights.
4. Create their corresponding Grade Items via New > Item and assign these to the proper category. Do not forget to give them the proper weights and points. For “Online quizzes” to drop the lowest quiz grade you need to select distribute weight evenly across all items > 1 number of lowest non-bonus items to drop for each user.