Physics LE Triangle & Text Logo (85px for Squarespace).png
 

Instructor Guide

Gradebook

 

The Gradebook is very versatile and can be customized to fit your specific course needs. When you create a homework assignment or quiz (grade item) it will automatically appear as a corresponding item in the gradebook. When students complete a homework assignment or quiz their scores are automatically recorded in the gradebook, and placed in the category selected when the assignment or quiz is created (e.g., homework, quizzes, or a custom category). The desired weighting can be assigned to individual assignments & quizzes, with overall weighting assigned to categories. Grading curves can be established to automatically determine a letter grade.

Access the Gradebook

To access the gradebook:

  1. Click on your course in the side navigation menu so that the Course page appears.

  2. In the side navigation menu click on Grades.

Overview of Gradebook

The navigation tabs appearing at the top of the gradebook page provide access to different viewing options and setup options. Each of the navigation tabs has a row of associated sub-menu tabs appearing immediately below it.

View tab

Under the View tab you’ll see the following sub-menu tabs:

  • Gradebook shows the complete gradebook for the entire class, including all graded activities created for the course. Use the Turn editing on button at the top of the page to manually enter or edit grades.

  • Grade history shows a complete report of all grades entered and changed for the course. This can be particularly useful if there are multiple instructors and/or teaching assistants involved with grading.

  • Single view allows you to enter grades for all students for a particular assignment or quiz, or grades for a particular student for all assignments or quizzes.

  • Student report shows a grade report for a particular student. This is the same view that students have of their grades. Use the Select all or one student drop-down menu to select a particular student.

Setup tab

Under the Setup tab you’ll see the following sub-menu tabs:

  • Gradebook setup controls the weightings for categories and individual assignments & quizzes, and how they’re arranged.

  • Course grade settings determines how the gradebook appears for both instructors and students.

  • Peferences: Gradebook lets you customize your personal view of the gradebook, with settings such as how many students are shown per page.

Letters tab

The Letters tab allows you to customize the boundaries used for converting numerical scores to letter grades.

Import and Export tabs

The Import and Export tabs allow you to control the settings and file formats used for importing and exporting grades to and from the gradebook.

Gradebook Main View Features

To access the gradebook main view page:

  1. In the side navigation menu click on Grades (be sure to first click on your course in the side navigation menu).

  2. In the navigation tabs (at top) click View, then select the Gradebook sub-menu tab.

Key Features

  • The gradebook displays assignments, quizzes, and totals in columns; students appear in rows. Note that categories appear at the top of the gradebook, directly above the grade items.

  • The Course section drop-down menu on the upper-left allows you to view a selected course section or the Full Course Roster. (See the Instructor Guide Placing Students into Course Sections.)

  • You can sort the gradebook information according to any of the column headers. Clicking a column header sort icon will toggle between ascending and descending sort order. Sort by students first or last names, assignment or quiz scores, and category or course totals.

  • Clicking on the name of an assignment or quiz in the column header will bring you to the Student Results page. The Student Results page contains a table summarizing how students performed on individual problems in the assignment or quiz. (See the Instructor Guide Summary Statistics and Student Results.)

  • Clicking on the magnifying glass icon appearing next to a student’s score for a particular assignment or quiz brings you to a detailed results page. This page contains detailed information showing the student’s final answers for all problems along with the problem text and the score received. A Response History section is included showing when the student started the problem, when the student finished the problem, and every correct or incorrect answer the student submitted prior to his or her final answer.

  • The table and pencil icons appearing after a student’s name can be used to display a single view report, showing only a single student’s grades.

Display Numerical Scores, Letter Grades, or Percentages

You can set the gradebook to display numerical scores, letter grades, percentages, or some combination thereof. Every column in the gradebook can have its own grade display style. Individual assignments, individual quizzes, assignment totals, quiz totals, and course totals can each display grades in the style that best meets your course needs.

Steps to setting the grade display style:

  1. In the side navigation menu click on Grades (be sure to first click on your course in the side navigation menu).

  2. In the navigation tabs (at top) click Setup, then select the Gradebook setup sub-menu tab.

  3. Under the Actions column, in the row for a grade item or category title, click Edit. From the Edit drop-down menu click Edit settings. The Edit page for this item will open.

  4. Depending on which item you selected, click the Grade item heading or Category total heading to expand the section.

  5. In the Grade display style drop-down menu, select from the following: Numerical score, Percentage, Letter grade, or some combination thereof. Note: This setting allows up to two grade display styles. For example, by selecting Percentage (letter grade) the gradebook will display "85.00% (B)".

  6. At the bottom of the page click Save changes.

Assign Weightings to Categories and Individual Assignments & Quizzes

Weightings can be established for grade categories and individual assignments & quizzes. It’s best practice to place all assignments & quizzes into a category. The gradebook does, however, allow assignments & quizzes to be placed alone outside a category.
(Note: In order to use weightings within the gradebook, Aggregation must be set to Natural. See the section Add a New Gradebook Category.)

  1. In the side navigation menu click on Grades (be sure to first click on your course in the side navigation menu).

  2. In the navigation tabs (at top) click Setup, then select the Gradebook setup sub-menu tab.
    The gradebook setup page displays categories (indicated with a black folder icon) organized in rows. Individual assignments & quizzes are also organized within rows, usually nested within a category.

  3. In the Weights column, select the checkbox next to the item’s weight and enter the desired weight (in percent). Be sure to enter weights such that the sum of all categories equals 100 percent, and the sum of all grade items within a category equals 100 percent. If an item is assigned a weight of zero it will not be calculated in the total.
    Important: After making changes to a weight, the corresponding checkbox must remain selected at all times. If the checkbox is unselected the custom weight values may unexpectedly be changed by the system. Note that if you enter values that do not add up to 100 percent for a given grouping, the system will replace your values with new values which meet this requirement.
    Recommendation: As assignments & quizzes are added to a category over time, the corresponding weights can remained non -checked with no custom weight value entered. The system will automatically set equal weightings for all grade items in the category. At the end of the grading period you can then enter your desired weightings. Alternatively, you can enter custom weight values at the time the assignment or quiz is added, and make the necessary weight adjustments for all grade items in the category.

  4. At the bottom of the page click Save changes, or press Enter on your keyboard.

 

Add a New Gradebook Category

The gradebook categories Assignment and Quiz appear by default in the gradebook. You can add additional gradebook categories to provide further groupings, each having their own selected weighting. New categories can be added at any time, existing assignments & quizzes can easily be moved into a new category.

  1. In the side navigation menu click on Grades (be sure to first click on your course in the side navigation menu).

  2. In the navigation tabs (at top) click Setup, then select the Gradebook setup sub-menu tab.

  3. Scroll to the bottom of the page and click the Add gradebook category button. The Gradebook category page will open.

  4. Enter a Category name and select category options.
    Important options include:
    Aggregation: The type of calculation for grade items in this category. This is most commonly set to Natural which will sum up the scores in the category and allow weightings to be applied.
    Exclude empty grades: When selected, assignments or quizzes without scores will not be counted in the category total. The primary use of this feature is to give an up-to-date course total at anytime throughout the grading period, and ignore missing or unassigned grade items. When using this option, you must manually enter a zero (0) score to include in the grade calculation an assignment or quiz missed by a student. If you leave an assignment or quiz score blank, it is considered to be empty and will be excluded from the grade calculation. Alternatively, if this option is not selected empty grades are calculated as zero.
    Drop the lowest: Excludes a set number of grade items with the lowest value from being calculated in the category total. This option begins dropping lowest grades once there are more grade items appearing than the number of lowest grades to drop (e.g. if a category is set to drop the 2 lowest scores, the 2 lowest scores will not be dropped until 3 or more grade items are present).
    Note: When using Natural weighting, Drop the lowest is only allowed when all grade items of the category have equal weights, and all grade items of the category have equal max grade

  5. Click Save changes at the bottom of the page. (Default settings should be used for Category total and Parent Category sections.)

Move Assignments & Quizzes and Categories

Assignments & quizzes (grade items) can be moved to different locations in the gradebook, they can also be moved in or out of categories. Categories can be moved as well.

  1. In the side navigation menu click on Grades (be sure to first click on your course in the side navigation menu).

  2. In the navigation tabs (at top) click Setup, then select the Gradebook setup sub-menu tab.

  3. At the left of the Grade item or Category you want to move, click the Move icon (vertical arrow). The word (Move) will appear next to the item to be moved, and dashed rectangles will appear in the possible locations where the item can be moved to.

  4. Click any of the dashed rectangles to move the item to that location (do not drag the vertical arrow icon). The page will refresh showing the item in the new location. You can cancel your action at any time by clicking Cancel at the bottom of the page. If you move a category that contains items and/or sub-categories, all of its contents will also be moved to the new location.

Edit Grade Letter Boundaries

You can customize the boundaries used for converting numerical scores to letter grades. The gradebook allows you to display a letter grade along with the numerical score.

Steps to editing grade letter boundaries:

  1. In the side navigation menu click on Grades (be sure to first click on your course in the side navigation menu).

  2. In the navigation tabs (at top) click Letters. The View sub-menu tab will show the values currently being used to convert scores to letter grades.

  3. Click Edit grade letters at the top of the table. The Edit grade letters page will open.

  4. To edit the grade boundary values, check the box Override site defaults. The fields for Grade letters and Letter grade boundaries will become editable. The Override site defaults box MUST REMAIN CHECKED in order to save custom settings, if it is unchecked all entered values will be lost and default values will appear instead. (Note: Grade letters A and F must correspond to maximum and minimum, respectively.)

  5. Enter new grade letters and/or boundary values as required. (Note: Numerical values will display as rounded to two decimal places but will actually store up to 5 decimal places.)

  6. At the bottom of the page click Save changes.

Note: There can only be one points-to-letter grade conversion setup, individual grade items cannot have different conversion setups. The settings on the Grade letters page will be used for all grade items that are set to display as letter grades. Adjusting the setup will affect the letter grades displayed for all grade items.

Manually Edit and Override Grades

  1. In the side navigation menu click on Grades (be sure to first click on your course in the side navigation menu).

  2. In the navigation tabs (at top) click View, then select the Gradebook sub-menu tab. This will bring you to the main view page.

  3. Click the Turn editing on button in the upper-right corner. Grade cells will change to show an entry field.
    Notice: Changes you make to this page cannot be saved if gradebook records are updated by another user, or in a different browser window, while this page is open.

  4. Search for the column that you want to edit or override. Manually input grades into blank cells in the table, or edit grades already recorded.

  5. At the bottom of the page click Save changes, or press Enter on your keyboard. Click the Turn editing off button in the upper-right corner. The edited grades will be highlighted to show the grade has been overridden.

Remove an Assignment or Quiz from the Gradebook

An assignment or quiz can be removed from the gradebook using one of two methods. If you wish to preserve the assignment or quiz for future use, be sure to use the second method below.

Method 1:

Delete the Assignment or Quiz on the Course page.

  1. Go to the Course page and click the Turn Editing On button.

  2. Click the Edit menu appearing directly to the right of the assignment or quiz you wish to remove from the gradebook.

  3. Select Delete from the Edit menu.

  4. In the pop-up window, confirm you wish to delete the assignment or quiz.

Warning: The assignment or quiz will be permanently deleted and will not be available for future use. This action cannot be undone.

Method 2:

Scale the points to zero for the assignment or quiz.

  1. Go to the Course page and click on the assignment or quiz you wish to remove from the gradebook.

  2. Click on the gear menu in the upper right corner and select View/Add Physics Problems.

  3. Set the Scaled total points value to zero, then click the Save button.

Note: This method will allow the assignment or quiz to be used again in the future and can be undone. Simply set Scaled total points to a nonzero value to have the assignment or quiz appear in the gradebook.

Expand and Collapse Categories

Entire categories can be collapsed in order to hide assignment & quiz columns from view, creating a more compressed gradebook. The overall course category (appearing above the regular categories and bearing your course name) can also be collapsed so that only the Course total appears in the gradebook.

Category views cycle through the following options:

  • Total only: Click the minus icon () next to a category heading to collapse the grade items in that category and show the category total only.

  • Grades only: Click the plus icon (+) next to a category heading to show grade items, but no category total.

  • Full view (default): Click the rectangle icon ([]) next to a category heading to show the grade items and category total.

Manually Create a Grade Item

You can also manually add columns to the gradebook to record extra grade items that are separate from Physics LE (for example, if you administer a written midterm exam).

Export Gradebook Data

You can take data from your gradebook and export it for use in a different grading system, or to have your own copy of the gradebook for convenient referencing or archiving purposes. The following export file formats are available: (1) Plain text file .csv (2) Excel spreadsheet .xlsx (3) XML file .xml (4) OpenDocument spreadsheet .ods

  1. In the side navigation menu click on Grades (be sure to first click on your course in the side navigation menu).

  2. In the navigation tabs (at top) click Export.

  3. Below the Export tab in the sub-menu tabs, select the desired export file type.

  4. For Course section, select whether the exported file should include the Full Course Roster or a particular course section.

  5. Under Grade items to be included, select the check boxes for the gradebook columns to download.
    Note: By default, every column in your gradebook will be included. At the bottom of the list, you can click Select all/none to make selecting columns more efficient.

  6. Under Export format options, select the check boxes for the desired options.
    Options include:
    Include feedback in export: Include a column in the exported file for existing feedback or to add feedback for future upload.
    Require active enrollment: Only include students in the export whose enrollment is active and has not been suspended.
    Export new or updated grades only: Exports only grades that have been changed since the most recent import. (This option is only available for XML file export.)
    Grade export display types: Select which grade display styles you wish to include in the export. Select any number of the following: Numerical score, Percentage, Letter grade. Note that each additional display style will be placed in a new column which could potentially create more columns than desired.
    Grade export decimal places: Select the number of decimal places to be used in the downloaded values. Values range from 0 to 5.
    Separator (delimiter): Select the delimiter for the exported data. A comma is commonly used for .csv files. (This option is only available for Plain text file export.)

  7. Click Download to start downloading your gradebook file. Your web browser settings determine whether the downloaded file will automatically go to a pre-selected download folder, or if a dialog box will allow you to enter the name and destination for the downloaded file.