D2L - Grades & Grading

Information about grades and grading in D2L

Table of Contents

 

Electronic Grading Options

Desire2Learn (D2L) Gradebook

The Desire2Learn course management system provides an electronic gradebook for faculty at UWGB.

Available features include:

  • Tie D2L quizzes, discussions, and dropboxes to grade items for easy entry
  • Ability to drop the lowest grade in a category
  • Cumulative totals, percentage weights, point-based weights
  • Letter grade schemes (automatically make 94% an A, for example)
  • Import/export capabilities including scanned test results and Excel calculated items
  • Controlled, online release to students through the student D2L interface

Excel Gradebook

Excel offers greater calculation options than D2L. Many instructors choose to record grades or create very customized grading schemes in Excel.

For large classes, it is possible to import and post grades to D2L from Excel.

Exporting the D2L Gradebook:

The D2L gradebook can be exported for Excel (xlsx) or as a CSV (comma separated value) text file, which opens in Excel as well as other spreadsheet-type programs. Please note that Excel (xlsx format) gradebook files cannot be imported back into D2L.

To export a gradebook click on Export from within the Enter Grades tab. Select User name, Grade Values you wish to have displayed, Last Name, and First Name. Select the grade items you want to export. Click the Export button associated with your preferred file type. You should see a popup dialog box prompting you to save the text file just created. Save it to an appropriate location.

Importing a CSV file into your D2L course:

To import a CSV file into your D2L gradebook go to the Enter Grades tab found under Grades in the course navbar. Click on the Import button. Browse to the correct CSV file and click Open. The path and file name will appear in the Import File text box. Click on Continue and then once again after the file is uploaded successfully. Ensure the information is correct in the gradebook preview and click Import to finalize the gradebook import.

Large classes and CSV files with several columns might require several steps to import the entire file. In most cases it is desirable to not include extraneous columns in the import file. Any errors in the import process will be reported at the bottom of the page.

Exam Scanning

IT offers a test scoring and analysis service to instructors at UW-Green Bay.

If an instructor designs a multiple answer test (multiple choice and true/false), a scanner sheet can be used for the student’s responses, which can then be read and scored.

The instructor can import scores into the D2L gradebook (see below).

For more information about exam scanning or importing scanned test results, contact the helpdesk.

Importing Scantron results into a D2L Grade book

Scantron test results can be imported into a D2L gradebook. You can either directly upload your Scantron results into D2L, or add the scores to a pre-existing Grade Item.

Direct upload of scores

This is probably the easier method of the two options. After you upload your scores you'll want to rename the Grade Item from "Scanned" to whatever the results are for (e.g. Exam 1, Final, etc.)

  1. Login into D2L and go to the Grades area of your course. If you're not taken to the Enter Grades are of Grades, click on Enter Grades to go there (enter grades displays your class roster and their scores on each grade item).
  2. Click Import
  3. Click Browse
  4. Select the CSV file containing the Scantron data that was emailed to you
  5. Click on the box next to "Create new grade item when an unrecognized item is referenced" to select it.
  6. In D2L, click Continue (and Continue again)
  7. If you'd like your scanned results to be part of a Grade Item category, select that category (e.g. Exams), and set the point total for the Grade Item.
  8. Click Continue (and Continue again)
  9. Click Import
  10. To rename your scanned results to something more meaningful, click on the drop-down arrow next to the new Grade Items name ("Scanned").
  11. Click on Edit, rename the Grade Item, and Save your changes.

Adding scores to pre-existing Grade Item

There are four steps to this process:

  1. Export and download the D2L gradebook taking only the required columns
  2. Open the Scantron results file
  3. Add/replace the column headings in the Scantron file with those from the D2L gradebook file, and
  4. Import the Scantron file (still in a CSV format) into the D2L course.

Opening the Scantron files in Excel:

Save the Scantron attachment to an appropriate file location, if this was not already done. Open the Scantron file in Excel (CSV files usually open automatically in Excel).

Export from D2L
  1. Go to Grades
  2. Click Export Grades
  3. Select Key Field: Username; and Grade Values: Points Grade
  4. Under Choose Grades to Export select only the column you wish to add scores to (Note: this column should be prepared already with the appropriate maximum point value)
  5. Click Export to CSV
  6. Click the file link in the popup and Open (or Save and then open)
Edit in Excel
  1. In the D2L Export Excel file select cell B1 and copy it
  2. Open the modified Scantron Excel file, select cell B1 and paste the column headers from the D2L Export
  3. Click Save As
  4. Next to Save As Type choose CSV (comma delimited)
  5. Save the file in a location from which it will soon be retrieved
Import in D2L
  1. Click Import Grades
  2. Click Browse
  3. Select the CSV file containing the Scantron data that was just saved and click open
  4. In D2L, click Continue (and Continue again)
  5. Click Import
Errors

Any errors in this process appear in the first screen of Import process. These errors usually are the result of missing student UserNames. Those grades must be entered individually.

Grades Setup

Setting Up a Grade book by Using D2L's Wizard

  1. Enter a course without a set gradebook and click on Grades.
  2. Click on Start.
  3. Select a grading system (below)
  4. Once your system is selected, click on Continue.
  5. Choose how the final grade in D2L is calculated. The Adjusted Final Grade option allows you to modify the final grade item without modifying other grade book items.
  6. Choose how D2L will interpret ungraded items.
  7. Drop ungraded items: This option will not calculate ungraded items at all, at any point in the semester. This is nice to select if you're going to allow students to see their current grade in the course throughout the semester. However, if a grade item for a student is not graded at the end of the course and this option is selected, D2L will not calculate the item in the students final score, instead of calculating it as 0. An instructor would either need to change this option later on to "Treat ungraded items as 0," or ensure that all students have a grade of at least 0 in all grade book items.
  8. Treat ungraded items as 0: All ungraded items are scored as 0. This choice could possibly be easier on the instructor, but if students are allowed to see their final grade throughout the semester, it will appear as failing for most of the semester and may lead to a lot of student-teacher grade book communication.

Selecting a Course Grading System

The first thing to do when setting up a D2L gradebook is to decide which course grading system you'll be using. The three options are "Weighted," "Points," and "Formula."

  • In a weighted system everything adds up to 100%.
  • In a points system the instructor adds grade items and specifies a perfect score for each and D2L does the math.
  • In a formula system, the final grade is determined by a custom defined formula. Grade items and categories use the Points system. Example: If a user's score on any item is below 60%, then the user automatically fails the course. Example: If a user's score on any item is below 60%, then the user automatically fails the course displayed as IF{ MIN{ [ITEM1.Percent], [ITEM2.Percent], [ITEM3.Percent] } < 60, 0, 100 }

Selecting a Grade Scheme

Before any student grades can be entered the instructor must select a Grade Scheme. The grade scheme is a breakdown by percent of the letter grades A, AB, B, etc. To select a grade scheme, click on the Schemes tab from within the Grades link in the course Nav bar. Choose the default option to stay with percents, select from one of the listed schemes, or create your own grade scheme.

Importing a Grade Scheme from One D2L Course into Another

If you're created a grade scheme for a previous course, you can import it into other courses.

  1. From within your D2L course, click on Grades.
  2. Click on the Schemes tab (just under the navbar).
  3. Click More Actions and then Copy
  4. The scheme copy page will list all of your previous and current D2L courses, along with any custom schemes. You can browse through the list, or if you know a keyword in your scheme, enter that in the box and press the magnifying glass to search.
  5. Click the radio button next to the scheme name to select it, then click on Copy.

Creating a Grade Scheme in D2L

  1. From within your D2L course, click on Grades.
  2. Click on the Schemes tab (just under the navbar).
  3. Click on "New Scheme."
  4. You must name your scheme. You only need to enter the "Start %" for each grade symbol.
  5. Note: If you plan on exporting your grades from D2L to SiS, the symbols must be standard, i.e. A, AB, B, BC, etc.
  6. To add additional rows for grade symbols, enter the number of additional rows required and click on
  7. Click on Save when finished.

Making a Default Grade Scheme for All Items in a D2L Grade Book

Grade schemes can be applied to your entire grade book, or just one grade item. Frequently, instructors choose to set up their entire grade book with the default "Percentage" scheme, and then apply their own custom scheme to the Final Grade grade item.

  1. From within your D2L course, click on Grades.
  2. Click on the Schemes tab (just under the navbar).
  3. Click on the "check" to make a scheme the default.

Creating Grade Items and Categories in D2L

Grade items are the individual columns in the grade book related to an assignment, assessment, etc. Categories in the grade book are used to organize grade items. When using a weighted grade book, categories are also used to control the weighting of the grade items they contain.

Generally, when creating a grade book that will have grade items as well as categories, it's best to create your categories first.

Creating Grade Categories

  1. From your D2L course, click on "Grades" in the navbar
  2. Click on the Manage Grades tab near the top of the page (just under the navbar in "Grade")
  3. Click on the blue New button, and select "Category."
  4. You need to enter the following items:
    1. Name: the name of your Category
    2. Weight: the weight of the entire category in the grade book. So, if all of your exams total 50% of the final grade, enter 50 here.
    3. Distribution: select your weighting option, manual weighting if there's variation, or equally distributed.
  5. To drop low scores: Choose the third option, "Distribute weight evenly across all items" and select the number of high or low items to ignore from the final grade.
  6. Click Save and New to keep making categories, or Save and Close if you're finished.

Creating Grade Items

  1. Follow steps 1-3 in Creating Grade Categories, above, except you will choose "Item" instead of "Category."
  2. Choose your scoring method for the grade item. Numeric is commonly used.
  3. You will need to enter the following items:
    1. Name: name your grade item. It's best to name it the same or similar to the assignment it's associated with.
    2. Category: though not required, if your grade item is going to be contained within a Category, it's easiest to set it at this point.
    3. Max Points: give your item a point value. If you're associated the grade item with another component of D2L, the Max Points must be the same in both locations (the grade book and the assignment properties).
    4. Weight: If you did not choose "Evenly Distributed" when you created your Category, you will need to assign a weight here.
  4. Click Save and New to keep making categories, or Save and Close if you're finished.

Extra Credit / Bonus Grade Items

There are two ways to provide extra credit to students. First: you may set a grade item to allow more than 100% of the points. Additional points will be calculated into the grade item as extra credit. Second: you can create a bonus grade item within the grades area.

Exceeding 100%

  1. Create the grade item associated with a dropbox, discussion, quiz, or manual entry.
  2. Under the "Grading" section of the "Properties" tab provide a maximum number of points (the score a student must receive to get 100%).
  3. Check the box under "Can Exceed" -- Note that "Bonus" sets the entire item as extra credit while "Can Exceed" still scores the "Maximum Points" normally.

Bonus Grade Item

  1. Create the grade item associated with a dropbox, discussion, quiz, or manual entry.
  2. Under the "Grading" section of the "Properties" tab, check the box under "Bonus" -- Note that "Bonus" sets the entire item as extra credit while "Can Exceed" still scores the "Maximum Points" normally.
  3. Bonus grade items appear with a star next to them in the gradebook .

Notes

  • A category which contains only extra credit must be set to "can exceed" in order to count in the final grade.
  • A bonus grade item can only improve a student's grade, and cannot count against them.
  • When creating a bonus item in your gradebook with a weighted grading system, you must have your gradebook separated into categories.
  • Even if you have a points gradebook, it is still good practice to have a gradebook separated into categories.
  • A bonus grade item can be in it's own category, or count as part of the whole gradebook. If you would like to have the bonus item only apply in a single category, make sure the "allow category grade to exceed category weight" box is unchecked. This will allow a maximum grade of 100% for only this category. If you would like the bonus item to roll over into and count as part of the entire gradebook, make sure that when you are creating the category, this option is checked.

Deleting Grade Items and Categories in D2L

  1. From your D2L course, click on Grades in the navbar
  2. Click on the Manage Grades tab (just under the navbar).
  3. From the Mange Grades screen, click on the "More Actions" button, then "Delete."
  4. Delete grade items and categories

Hiding Grade Items from Students in D2L

You may choose to not display grade items in the grade book to students. Often times, instructors mistakenly hide the grade items in their own view settings, but the grade item is still visible to students. The proper method of hiding a grade item is below.

Hiding a grade item from all students

  1. From within your D2L course, click on Grades.
  2. Click on the Manage Grades tab.
  3. Click on the Grade Category or Grade Item you'd like to hide. If you hide a category, all grade items within that category will also be hidden.
  4. Click on the Restrictions tab.
  5. Select "Hide this grade item" or "Hide this category," depending on which you're currently hiding. You can also choose to hide the grade item or category for specific dates by choosing the corresponding options.
  6. Click Save and Close when finished

Note: Even though the grade item or category is hidden to students, instructors will still see it in the grade book. This is so that you can enter scores if needed, while keeping grade items and categories hidden to students. This is also so that, if you change your mind, you can still find the grade item to "unhide" it.

Hiding grade items from selected students

Sometimes it's beneficial to hide grade items from certain students, but not others. This can occur when you have group discussion topics in your course tied to the grade book. Release conditions allow you to set visibility based upon criteria being met, such as membership in a certain group in the class, score on an assessment, etc.

To access Release Conditions for a grade item or category, do the following:

  1. From within your D2L course, click on Grades.
  2. Click on the Manage Grades tab.
  3. Click on the Grade Category or Grade Item you'd like to hide. If you hide a category, all grade items within that category will also be hidden.
  4. Click on the Restrictions tab.
  5. Click on Create and Attach if you don't have pre-existing Release Conditions. If you do, you can click on Attach Existing to re-use an existing Release Condition.
    1. There are many Release Conditions available to you. For the example given above regarding limiting visibility based upon group enrollment, select "Group Enrollment," listed under the "Classlist" heading, within the Condition Type drop-down box. For the Condition Details, select the group you'd like the grade item to be visible to.
  6. Click on Create, and then Save and Close

Rubrics Resources

The Office of Information Technology at the University of Colorado Boulder has a very nice step-by-step guide for creating rubrics in D2L. This helpful guide is available at https://oit.colorado.edu/tutorial/d2l-creating-rubric 

In addition, here is a quick reference:

  • Rubrics are accessed via Edit Course > Rubrics
  • Analytic Rubrics* break the rubric into criteria while Holistic Rubrics are based on a single overall assessment
  • Rubrics can be scored as Text Only (e.g. poor, good, excellent), Points (each of the criteria share point values for each level), Custom Points* (each of the criteria can have different points for the given levels), or Percentages (holistic only).
  • Criteria, levels, and overall feedback are edited by clicking the drop-downs on the row/column headings.
  • A rubric must be "published" before it can be used. IMPORTANT: Once a rubric is published it cannot be edited.

*Recommended

https://oit.colorado.edu/tutorial/d2l-creating-rubric

Grading Students

Viewing all students in Grades area

D2L limits the total number of cells displayed in the enter grades area to speed up loading times for the page. The enter grades area displays fewer rows (students) when there are too many columns (grade items). Instructors can hide columns or 'grade all' for a given assignment to view all students.

In order to view all students, instructors can hide grade items (for example those they have already graded). To hide columns (grade items):

  1. Go to the enter grades window
  2. Click “More Actions” at the top
  3. Select “Hide/Show Columns”
  4. Un-check the boxes next to any unneeded grade items
  5. Click Save

Once enough grade items have been unchecked (this number will depend on the number of students in the course), the maximum number of students displayable per page will increase.

Grade an assignment for all students

Another way to enter grades for all students for a particular assignment is to click the drop-down on the heading for that column/grade item and choose “Grade All.” This will bring up a list of all students (the maximum per page there is 200) and the instructor can enter grades for each of them for that item.

Tie Dropbox to Grade Item

When a dropbox and grade item correspond in D2L, an instructor can easily grade and provide feedback in the dropbox tool and then "push" or publish that grade to the corresponding grade item. To do so:

  • NOTE: If you've published feedback in the dropbox already, this process will not erase that information. This process WILL over-ride and REPLACE manually entered grades.

Creating the Dropbox and Grade Item Together

  1. In the dropbox tool, click New Folder
  2. In the new folder properties screen, provide a name for the dropbox (this can be different than the name for the grade item) and then click "New Grade Item" under Grade Item.
  3. Use the pop-up window to create your new grade item.
  4. Click Save
  5. The grade item's name will appear in the dropdown under Grade Item, but you will still need to provide and "Out Of" value. This value does not need to match the grade item's max points (see below), but it is helpful to students if it does.
  6. Finish creating the dropbox as normal.
  7. Click Save and Close.

Tying a new Dropbox to an Existing Grade Item

  1. In the dropbox tool, click New Folder
  2. In the new folder properties screen, provide a name for the dropbox (this can be different than the name for the grade item).
  3. Under Grade Item, use the dropdown menu to select the corresponding grade item. NOTE: You can only tie one dropbox (or quiz) to each grade item. Only available items will appear in the dropdown list.
  4. You will still need to provide and "Out Of" value. This value does not need to match the grade item's max points (see below), but it is helpful to students if it does.
  5. Finish creating the dropbox as normal.
  6. Click Save and Close.

Tying after students have submitted and you've published feedback

  1. Check in grades to verify that you have not manually entered grades for any student under the grade item that you would like to tie to. Once you tie a dropbox and publish dropbox feedback/grades, this will overwrite what is already in the gradebook.
  2. Go to the dropbox tool and click the dropdown to access "Edit Folder"
  3. Tie the grade item following the steps for Tying a new Dropbox to an Existing Grade Item above but do not alter the "Out Of" value if you have already scored students in the dropbox.
  4. Published feedback may automatically go to the gradebook. Go to the gradebook to verify that scores were sent. If not, continue to re-publish the feedback.
  5. Return to the dropbox submissions page. Those students with published feedback should have the "Published" icon near their names.
  6. To republish this feedback, select all students you would like to publish OR re-publish by checking the boxes next to their names (left-hand side). Then click "Publish Feedback" above.

 

What happens when the points on the dropbox and the points in the gradebook don't match?

When the points don't match up, D2L is smart enough to convert the score via a percentage. Example: Dr. Bunsen Honeydew creates a gradebook where each journal is worth 20 points so that 5 journals total 100 points of the final grade, but when he grades, he uses a rubric which totals 50 points. Beaker submits a journal to the dropbox and Honeydew grades it giving him 46/50. D2L converts this to 92% and gives Beaker 18.4/20 in the gradebook. Beaker can still view feedback in the dropbox indicating 46/50 but will see 18.4/20 in the gradebook.

Multiple dropboxes & multiple grade items.

Unfortunately, D2L will not allow you to tie multiple dropboxes to a single grade item (such as in cases when students must do one of three assignments, etc.), nor will it tie multiple grade items to one dropbox (such as multiple submissions or "stages" of a project). Instead dropboxes and grade items are one-to-one only. The best way to "trick" D2L into doing what you want with multiple drop-boxes and one grade is to create hidden grade items excluded from calculation and then keep a points grade item updated. To feed multiple grade items, you must create multiple drop-boxes or grade by hand and manually enter grades.

Leaving Feedback and Grading an Assignment in a Dropbox in D2L

  1. Click on Dropbox in the navigation bar.
  2. Click on the name of the dropbox folder that you want to view submissions for.
  3. Click on the Evaluate Submission link next to the name of the student who you want to leave feedback for.
  4. If your dropbox is manually scored, enter the score for the assignment.
  5. If you've attached a rubric to the assignment, click on the rubric name and select the appropriate score.
  6. If your dropbox is not set to receive a grade value, you will not see either of the above options.
  7. Type in any feedback in the Feedback text box.
  8. Attach any files that you want to associate with the feedback. If you have a microphone attached to your computer, you can also click on Record Audio and leave a short voice message.
  9. Finally, you can choose to Publish or Save Draft. Publishing the grade and/or feedback will make it immediately available to that student. You may want to choose to save a draft if you intend to publish all student grades and/or feedback at once, or in case you plan on coming back later to make changes.

Grading and Assessing Discussions

Overview

  1. select the topic you would like to grade and choose "edit topic" from the dropdown menu at the right.
  2. choose the "Assessment Tab" and select an item from the gradebook to tie the discussion to and enter the "out of" score in the appropriate box.
  3. After you click "save and close" you will be back at the main discussion page. Now, when you go to the dropdown menu next to the name of the topic you are grading, you will see "Assess Topic" as an option. Choose "Assess Topic."
  4. Now, you will see a list of students with "Topic Score" after their names. Click "Topic Score" to pull up a list of all posts written by the student for the topic.
  5. You can read all the posts authored by the student; leave feedback; and enter a score.
  6. You may either publish the scores to the gradebook as you go, or you may publish all the grades at once. To do this, place a check in the box that says "publish to grades."
  7. Once you have published the grades, you are done. Here is what your students will see from their perspective.

Grading Group Restricted Discussion Topics

Some context: The way that D2L records grades is one-to-one, so one grade item can only be tied to one activity at a time. This becomes an issue with the old style of group restricted discussion topics (a forum with separate topics for “Group 1 discussion,” “Group 2 discussion,” etc.) because once Group 1 is tied to Discussion 1 grade item it will become unavailable as an option for Group 2.

Once you create a forum that has group restricted topics, and students post to them, you can now assess their work by doing the following:

  1. Edit the topic for Group 1
  2. Click on the Assessment tab, and then from the grade item drop down menu select the grade item
  3. Put the score out of within the entry field
  4. Click "Save and Close"
  5. Now that you've tied the topic to the grade item you can Assess the topic.
  6. Utilizing the filters might help manage the amount of students you must filter through so Viewing by Groups rather than Users is another trick (1 & 2). If you change the filtering you must also click apply so that your page reflects the updates from the selected menu.
  7. Next, click on the student who's post you'd like to assess
  8. This is where you input the topic score, and any feedback that will appear in the Grades tool. You can also publish from this screen. If you do not want to publish the score and feedback immediately do not check the box. When you're finished click "Save and Close"
  9. This box will appear asking you to confirm that you want this feedback to appear in the grades tool; click "Overwrite"
  10. Do this for each student in the group, and then you'll have to do a few more things to assess the next group restricted topic.

Since this grade item is still tied to group restricted topic 1, we'll have to "un-tie" it:

  1. Edit the same group restricted topic (Discussion Group - Group 1)
  2. Click on the Assessment tab, and then from the grade item drop down menu choose the default "--Choose a grade item--" setting; click "Save and Close"
  3. Now, this grade item is free to use for Discussion Group - Group 2. Edit Group 2 topic
  4. Like we did for group restricted topic 1, we now need to tie this topic (Discussion Group - Group 2) to the grade item that it is linked with. Click on the Assessment tab, and then from the grade item drop down menu select the grade item, assign a "Score out of," then click "Save and Close”
  5. Now, you can assess the student posts in the same manner that you did for steps 5-10 above.

Grading a Quiz (Essay Questions, etc.)

To grade an entire exam by hand for each student (one student at a time)

  1. Go to Quizzes
  2. Click the dropdown next to the quiz name and choose Grade
  3. Click on an Attempt
  4. Grade the relevant questions clicking Save as you go
  5. Advance to the next student’s exam by using the arrows at the top of the page or by repeating these steps for various attempts

To grade just one question (e.g. essay) one student at a time

  1. Go to Quizzes
  2. Click the dropdown next to the quiz name and choose Grade
  3. Click on the Questions tab
  4. Select the question you would like to grade from the list provided
  5. Grade the first student (or select another number from the dropdown at the top to view 5, 10, or 20 students at a time instead and grade them all)
  6. Use the arrows at the top to move between pages of students to grade saving as you go

Publishing quiz scores (after students have taken the quiz)

If you have created a quiz and a grade item but have not yet tied them, these are the steps to push the scores to the gradebook.

Tying the grade item:

  1. Ensure that the grade item is created
  2. Go to the quiz by selecting Quizzes and then the dropdown next to the quiz and Edit
  3. Click on the Assessment tab
  4. Check:
    1. Allow attempt to be graded immediately upon completion
    2. Allow automatic export to grades
  5. Select the appropriate grade item from the Grade Item dropdown
  6. Click Save and Close

Re-pushing the grades:

  1. Go to the quiz by selecting Quizzes and then the dropdown next to the quiz and Grade
  2. Click the blue icon next to Published until all boxes under "Published" are unchecked
  3. Click Save
  4. Click the blue icon next to Published again until all boxes under "Published" are checked
  5. Click Save and Close

Final Grades

Calculated and Adjusted Final Grades in D2L

In D2L, the Calculated Final Grade is the sum of all grade items within the grade book. The Adjusted Final Grade does not necessarily include grade items (items are automatically included unless you choose otherwise) and can be modified directly "by hand."

Selecting a Final Grade Method

  1. From within your course, click on Grades in the navbar
  2. Click on Settings in the upper-right corner
  3. Click on the Calculation Options tab
  4. Select to release either the Calculated Grade or Adjusted Grade to students.

Calculating Final Grades in D2L

If your grade book is not set to automatically keep the final grade score updated, you will need to enter the grade book and calculate the final grade for your students. Do the following:

  1. From within your course, click on Grades
  2. From either the Calculated Final Grade or Adjusted Final Grade, click on the drop-down arrow and select Grade All
  3. Click on the drop-down arrow next to the heading Final Grades, at the top of the screen, and choose Recalculate All.
  4. Choose Final Calculated Grade and click Calculate
  5. Click on the Save button at the bottom of the screen. All of your students will now have a Final Calculated Grade.

Automatically keeping Final Scores Up-To-Date

If you prefer, you can have D2L automatically update the final calculated grade automatically each time a change is made to the grade book.

  1. From within your class, click on the Grades link in the navbar.
  2. Click on the Settings link in the upper-right corner
  3. Click on the Calculation Options tab.
  4. Near the bottom of the Calculation Options screen, click on the box next to Automatically keep final grades updated to enable the feature.
  5. Click on the blue Save button

All of your Final Calculated grades will now be up-to-date. Any changes to the grade book will be reflected in the Final Calculated Grade.

Releasing Final Grades to Students in D2L

Depending on how you've set up your grade book, final grades may or may not be visible to students at all times. There are three approaches to final grade visibility that faculty take. They are...

Only making the final grade visible at the end of the semester, once all scores are in

Making the final grade visible throughout the semester, excluding ungraded items (a student that has received a B on all assignments will see their final grade as a B, even though they may not have completed the majority of assignments)

Making the final grade visible throughout the semester, including ungraded items as 0 (a student will see they're receiving an F at the beginning of the semester, and work their way up to a higher grade as assignments are graded)

Making Final Grades Visible at the End of the Semester

This section assumes your final calculated/adjusted grades are up to date. If you'd like to learn more about calculating a final grade, go to Calculating Final Grades in D2L

  1. From within your class, click on Grades in the navbar.
  2. Click on the drop-down arrow next to Final Calculated Grade or Final Adjusted Grade and select Grade All
  3. Click on the drop-down arrow next to Final Grades and select Release All
  4. Depending on your grade book settings, either your Final Calculated or Final Adjusted Grades will be released.

Making Final Grades Visible Throughout the Semester, Excluding Ungraded Items

  1. Click on Grades from within your class
  2. Click on the Settings link in the upper-right corner
  3. Click on the Calculation Options tab
  4. Select the options shown below, dropping ungraded items from final calculation and keeping final grades updated
  5. Follow steps 1-3 of Making Final Grades Visible at the end of the Semester, above.
    1. Note: If you leave the option to Drop ungraded items as selected at the end of the semester, make sure to go back and give each student who did not complete an assignment a zero, otherwise they will not be penalized for not completing work.

Making Final Grades Visible Throughout the Semester, Calculating Ungraded Items as Zeroes.

  1. Click on Grades from within your class
  2. Click on the Settings link in the upper-right corner
  3. Click on the Calculation Options tab
  4. Select the options shown below, dropping ungraded items from final calculation and keeping final grades updated
  5. Follow steps 1-3 of Making Final Grades Visible at the end of the Semester, above.

Exporting Final Grades from D2L into SIS

What is required:

  • An instructor must have a D2L course and use the D2L gradebook. The D2L gradebook must include a Final Grade column using a valid grading scheme. The grading scheme will probably be a new grading scheme defined by the instructor but it can be one of the Organization Schemes available to all instructors. The grading scheme must produce valid letter grades, e.g., A, AB, B., and cannot include A+, A/B, Ok, Pass, etc.

The process of transporting final grades from D2L to SIS:

  1. Logon to D2L and go to the Grades link in the course navbar.
  2. Check over the final grade. The final grade must use a grade scheme that produces only those characters recognized by the SIS, e.g., A, AB, B, etc. It cannot include characters such as A/B, B+, 90%, etc. Most instructors create their own grade schemes so they can define the exact grade cutoffs but the built-in schemes are also available for use. Instructors can create a separate grade scheme to apply only to the final grade. Note that it is acceptable to leave some student final grades empty in D2L as long as those grades are later entered in SIS.
  3. Click on the Export Grades to SIS button in the gradebook. Note: this button will not display if the gradebook was never set up. You will see an "Export completed successfully" message when the grades are sent.Export grades to SIS

It takes about five minutes for the grades to process.

You will receive an email from SIS that will let you know when your grades are ready to import.Email from SIS

  1. Logon to the SIS and navigate to the Grade Roster section for the desired course.grade roster
  2. Click the "Import D2L Grades" button. This process overwrites existing grades in the SIS gradetable so any grades already entered in the gradetable will be replaced with whatever grade is being imported from D2L. This also means that instructors can import grades, return to D2L to make large-scale changes, and re-import the grades. It also means that an instructor can try it with just a few final grades and then come back and finish with all grades.import grades
  3. Check over the grades and make changes as you see fit. Look for any missing grades and any grades that came in with unusual characters. Make corrections as needed.
  4. Approve your grades in the SIS as you normally do.

Notes and FAQ:

Who do I contact for help?

Contact CATL if you have any questions on grade schemes or any other D2L issue. Contact the Registrar’s office for questions concerning grades and SIS.

When can I transfer my D2L grades to SIS?

You can transfer grades from your D2L course to SIS any time during the open grading window at the end of the semester until the grades are due to be posted in SIS.

Can I transfer my grades more than once?

Yes, you can transfer grade files from D2L to SIS as often as you like until the course grades are posted in SIS. Each time you import grades into a SIS grade table they replace previously existing grades. Remember, it might take as long as eight minutes before the new grades are ready in SIS; wait for the email.

What if I have multiple sections in my D2L course?

When you export grades from a D2L course all grades for all sections go. Each section in SIS picks up the appropriate students and grades.

What if my D2L course has more than one instructor?

Any instructor in a D2L course can initiate the grade export process. Also, all instructors in a D2L course get an email when the grades get to SIS (At least I think so. I haven't been able to confirm.) In any case, only the instructor of record can logon to SIS, import the grades, and finalize the grades.

What if I unenroll a student from my D2L course because they dropped the course?

You don't need to do this. It's much better to leave the student in the roster and deal with it in the SIS.

Is there a problem if I have manually enrolled a student in my course?

This can sometimes create issues when D2L tries to talk to SIS. If you are experiencing issues within the open grading window and have a manually enrolled student, you may need to manually enter grades in SIS.

Can I use the same grade scheme in more than one D2L course?

Yes, but you must copy it into the additional courses.

Can I create a new grade scheme in a D2L gradebook that I use only for the final grade?

Absolutely.

What if I make a mistake on a grade?

An instructor can still change one or more grades in the SIS after the import and before the grades are approved.

What if I don't want to use it?

This process is completely optional. Any instructor is welcome to ignore this process and enter their grades in SIS as they have in the past.

Five-Week Grades

To make a 5-week grade item, log into D2L and enter your course. Follow these steps:

  1. Click on Grades
  2. Click on Manage Grades if you're not on that screen
  3. Click on the blue New button in your grade book and select Item
  4. On the New Item screen, select Calculated.
  5. The new calculated grade item screen is divided into 3 "tabs," Properties, Restrictions, and Objectives. We're only interested in the first tab, Properties, which is selected by default.
  6. Enter a Name for the calculated grade item (required).
  7. Select a Grade Scheme for the grade item (optional but recommended). The grade scheme should match the grading scale in your syllabus.
  8. Identify which grade items should be included (required). Do this by clicking on the relevant check boxes.
  9. Click Save and Close

By default, your new calculated grade item will appear at the bottom of your Manage Grades list, and at the far-right of your Enter Grades list. It will also appear at the bottom of your students' grade pages. If you'd like to re-order the calculated grade item, do the following:

  1. From the Grades - Manage Grades screen, click on the More Actions button and select Reorder
  2. A number is shown for each grade item. The number corresponds to the display order of grade items for you and your students. Find your new calculated grade item at the bottom of the list, and select the number box to reassign the calculated grade item to whichever value you feel it should have in the list. Click Save when you're done.

At this time, it is not possible to export a manually-created "calculated" grade item to SIS. Grade values will need to be keyed manually into SIS.

See above for more information about hiding grade items from students.




Keywords:5, 10.3, a, activity, adjusted, and, assess, assessment, bonus, book, calculated, calculating, categories, columns, condition, conditions, course, creating, credit, csv, d2l, default, deleting, disc, discussion, discussions, dropbox, edit, electronic, enter, exam, excel, export, exporting, extra, eye, feedback, final, five, folder, forum, grade, gradebook, grades, grading, group, hidden, hiding, import, importing, instructor, item, items, leaving, mid, midterm, of, out, point, points, publish, push, quiz, quizzes, release, releasing, restricted, rows, rubric, scan, scanned, scanner, scantron, scheme, score, scores, scoring, see, setting, settings, sis, system, term, tie, topic, topics, tying, upload, uploading, view, week, wizard   Doc ID:85359
Owner:Luke K.Group:UW Green Bay
Created:2018-08-30 12:20 CSTUpdated:2018-08-30 13:49 CST
Sites:UW Green Bay
Feedback:  0   0