Printer-Friendly Version

CTools Logo

Gradebook


Click to see:

Description
Examples of Use
Things to consider
Create/add a new Gradebook item
Edit an existing Gradebook item
Delete a Gradebook assignment
Set student feedback options
Override an autocalculated course grade
Enter grades in the Gradebook
Edit previously-entered grades
Categories and Weighting
Put assignments and grades from Assignments Tool in the Gradebook
Drop the lowest or highest scores
Import scores into the Gradebook
Export scores from the Gradebook
View assignment details
Hide columns in the grade table
Sort Gradebook tables
Aricia agestis



Description

The Gradebook tool allows instructors to list course assignments and corresponding student scores, and calculate, store, and distribute grade information to students online. Courses can be graded on letter grades with +/- (A+, A, A-...), simple letter grade (A, B, C...), or pass/fail (minimum acceptable percentage).

You can also have grades from assignments created with the

CTools Assignments tool automatically go into the Gradebook.   You can also now link discussion responses in the Forums tool to the gradebook via an assignment.  

For information on how to add the Gradebook tool or any other tool after you have created your site, click here, or click Edit Tools on the Site Info Tool help page, which can be accessed under "Site Management" in the help table of contents.

Up


Examples of use

Using the Gradebook, instructors can:

- Autocalculate course grades.

- Create and edit a mapping of the course letter grade to a 100 percent scale.

- Add, view, edit, and release point values of assignments and/or assessments to students.

- Manually enter, view, edit, and release to students their scores and grades.

- Export scores for an assessment from and to the gradebook, which creates an assignment in the gradebook and transfer student scores to that assignment.

- Export scores and grades to Microsoft Excel (in .csv format).

- Viewing scores: The Gradebook will allow students to view their own scores and grades, once instructors have released them.



Things to consider

There are different ways instructors can view information in the Gradebook, including a general overview for each course, assignment detail, course grade detail, student roster, adding or editing assignments, gradebook options, and student view.

Students can view their cumulative scores for all assignments and the corresponding percentage; view their course grades, once an instructor releases them; and sort their assignments by title, due date, grade, and total possible points per assignment.

Up


Create/add an item to the Gradebook

Note: This is not for an assignment from the CTools Assignment Tool. To do this, see the section, "Putting assignments and grades created in CTools into the Gradebook," below.

To create/add a new Gradebook assignment, follow these steps:

1. In the menubar, click Gradebook , and then click Add Gradebook Item.

2. In the web form that opens, fill in the following information:

Title: A title is required for all Gradebook assignments. The title can be up to 255 characters in length.

Gradebook Itempoint value: You must assign a point value to all Gradebook assignments. Enter a value greater than zero. Decimals are permitted, but values are limited to two decimal places. Note that you can only assign assignments in gradebook a numerical grade.  However, you can convert these numerical grades into letter grades later on.  

Due Date: You can optionally designate a due date for a Gradebook assignment. Using the drop-down lists, select the month, day, and year of the due date for the assignment.

Category: If you have created on or more categories when you set up your gradebook using the Gradebook Setup feature (see the button along the top of the main window in the Gradebook tool), you can optionally assign an item to a category using the drop-down list.

3.  If you wish to include this assignment in the calculation of the final grade, check the box next to this option.  If you do not want to include the points student receive for this assignment in the calculation of the final grade, do not check the box.  If you wish to make this assignment visible to students once you've entered grades into the assignment, check the corresponding box.  If not, leave the box unchecked.  

4. To create the item, click Add Item. You will see a message saying the item has been added. Alternatively, click Cancel to discard the item, and you will be returned to the Gradebook Items page.

Up


Edit an existing gradebook item


To edit an existing Gradebook assignment, do the following:

1. In the menubar, click Gradebook.

2. In the list of Gradebook assignments, click the assignment you want to modify.

3. On the Assignment Summary page that opens, under "Options," click Edit assignment settings .

4. Change the Gradebook assignment's settings, and then click Save Changes. On this page you can alter the assignment's point value or due date. You will see a message saying that you have successfully updated the assignment. Alternatively, click Cancel to discard the changes.



Delete a Gradebook item

To delete a Gradebook assignment, do the following:

1. In the menubar, click Gradebook.

2. In the list of gradebook items, click the item you want to delete.

3. On the Assignment Summary page that opens, under "Options," click Remove assignment from gradebook .

4. On the Remove Assignment confirmation page, check the box next to Remove this assignment from gradebook.

5. Click Remove to delete the assignment from the Gradebook. You will see a message saying the assignment was deleted. Alternatively, you can click Cancel to exit the page, preserving the assignment.

Up


Setting student feedback options

To set student feedback options in the Gradebook, follow these steps:

1. In the menubar, click Gradebook.

2. At the top of the Gradebook, click Course Grade Options

3. On the Course Grade Options form, choose from the following options:

Grade Display: Check the desired options for revealing assignment and course grades to your students. The Display Assignment Grades option is checked by default, and the option to display course grades is unchecked by default so that you may release your grades at the end of the grading period.

Grade Conversion: In the "Grade Type" drop-down list, select the type of grade you wish to use, and then click the Change grade type button.

Grade/percent table: In this table, you will see the minimum percentages for each grade. Manually entered course grades are not affected by the percentages in the grade/percent table. If you manually enter a course grade, you will see the error message "You have changed the grading scheme. All manually overwritten course grades remain unaffected." For more information about manually overriding course grades, see Overriding an autocalculated course grade .

4. When you have finished, click Save. If you don't wish to save your changes, click Cancel to return to the Gradebook Overview.

Up


Override an autocalculated course grade

By default, a course grade is automatically calculated by the Gradebook. This grade is simply calculated as a percentage of current points scored out of the total points possible of all assignments entered in the Gradebook. Therefore, if there are ungraded assignments present, the autocalculated course grade may not always be accurate. You can choose to manually override the course grade or use the autocalculated grade.


Overriding an autocalculated course grade

To override an autocalculated course grade, do the following:

1. While you are in the Gradebook tool, click Course Grade along the top of the window.

2. You will see a list of enrolled students and their calculated course grades. In the "Grade Override" column, enter the new course grade(s) with which you want to replace the autocalculated grade(s).

Note: When manually entering a course grade, you must use the appropriate grade type for the Gradebook in which you are working. For example, if the course is graded on a simple letter grade scale, you will only be able to enter the letters A, B, C, D, or F. If the course is graded on a standard letter grade scale, you will also be able to add  +  (plus sign) or  -  (minus sign) to the letter grade. If the course is graded on a pass/fail scale, you will only be able to enter the letters  P  or NP.

When you have finished updating any course grades you want to change, click Save.

Each time a grade is overridden in this fashion, a log is kept as to who changed the grade and and to what the grade has been changed to.  Clicking on the log icon to the left of the over ride grade box will pop up a window that shows who has last overridden the grade and what the grade has been changed to.  


Revert back to an autocalculated course grade

If you have overridden a course grade, and you want to use the autocalculated course grade instead, do the following:

1. In the menubar, click Gradebook. If you are not already on the Overview page of the Gradebook tool, click Overview near the top of the window.

2. At the bottom of the assignment list, click Course Grade.

3. On the resulting page, you will see a list of enrolled students. If you have overridden a course grade for a student, you will see the grade you manually entered in an editable field in the "Grade Override" column. To revert back to the autocalculated course grade, delete the manually entered grade and click Save.

Note: You will have to delete the manually entered grade and click Save for each grade you want to change back.  You can not do this in a mass fashion.

Up


Enter grades in the Gradebook

To enter grades for assignments into the Gradebook, do the following:

1. From the menubar, click Gradebook.

2. Locate the assignment for which you want to enter grades in the assignment list and click its title.

3. Enter each student's score for the assignment into the box following his or her name. Scores must be greater than or equal to zero, and may contain up to two decimal places (e.g., 9.25 ). You may leave a box blank if you are waiting on a student's grade.

4. To add comments for students, click Edit Comments. Type your comments in the text box.

5. Click Save Changes. A grade history log indicating the date entered, the recorded score, and the submitter will be created for each score. Click the Log icon to view the details for an entry.

Up


Edit previously-entered grades

To edit previously entered grades in the Gradebook, do the following:

1. From the menubar, click Gradebook.

2. Locate the assignment with the grades you want to edit in assignment list and click its title.

3. On the Assignment Summary page, current grades for individual students for the particular assignment will appear in editable fields in the "Points" column. To edit an assignment score for a student, change the points in the appropriate field.

4. To add comments for students, click Edit Comments. Type your comments in the text box.

5. Click Save to update the scores with your changes. A log will be kept here whenever assignment grades are changed or edited. 


Categories and Weighting

In the Gradebook tool, you can create categories and assign Gradebook items to them. You can assign percentages to the categories, thereby weighting the items they contain more or less heavily when calculating the course grade.

Note: If you create categories (whether simple or weighted), you must then assign all Gradebook items that you want included in the course grade calculation to some category. Uncategorized Gradebook items will not have the option to be included in the course grade calculation. This requirement does not apply if you don't create categories.

Creating categories

To create Gradebook categories:

1. In your site's menubar, click Gradebook.

2. Near the top, click Gradebook Setup.

3. Under "Categories & Weighting", choose Categories only.

4. In the text box that appears, type a name for the category you're adding. To create additional categories, click Add a Category.

5. When you are finished, click Save Changes.

Creating categories with weighted grades.

To create categories and weighted grades:

1. In your site's menubar, click Gradebook.

2. Near the top, click Gradebook Setup.

3. Under "Categories & Weighting", choose Categories & Weighting.

4. In the text box that appears, type a name for the category you're adding. To create additional categories, click Add a Category.

5. Next to each category name, in the "%" column, enter a number representing the percentage of the final grade that category should account for.

Note: The total percentage must equal 100. Before you can save your changes, the "Running Total" must equal 100.0%, and the "Needed Total" must equal 0.0%.

When you are finished, click Save Changes.

Adding Gradebook items to a category

After you create a category, you can assign Gradebook items to it while creating or editing the item; see Adding, editing, or deleting a Gradebook item.

Note: When you assign Gradebook items to a weighted category, keep in mind that items worth more points are already weighted more heavily.

Make certain that the combination of point values and category weights results in the impact on course grades that you intend. For example, if you want all items in a category to influence the grade equally, you must make them worth the same point value or relative weight.

Up


Put assignments and grades created in the CTools Assignments Tool into the Gradebook

When you create an assignment using the CTools Assignment tool, you can choose to have the assignment name and grades go automatically into the Gradebook of the same site.

To do this, when you create the assignment, click the box next to "Add to Gradebook" near the end of the assignment-creation form.

Note: You can not edit assignment grades entered through the assignment tool. You must edit those grades in the assignment tool, not in the gradebook.  Also, grades for specific assignments entered through the assignment tool will not appear in the gradebook.  Gradebook will include scores for assignment grades entered in assignments in the calculation of the final grade, but those specific grades will not appear in the gradebook.  

Up


Drop the lowest or highest scores

In the Gradebook tool, instructors can drop certain grades. For instance, you could drop the lowest quiz score, keep only the three highest of ten homework assignments, or drop both the lowest and highest score among peer evaluations of a group project in order to focus on the median scores.

To drop the lowest or highest grade(s):

1. In your site's menubar, click Gradebook.

2. Near the top, click Gradebook Setup.

3. In the "Categories & Weighting" section of the form, choose either Categories or Categories & Weighting.

4. In the text box that appears, type a name for the category you're adding.

5. Directly below "Categories & Weighting, check Enable Drop Highest, Enable Drop Lowest or Enable Keep Highest.

6. In the boxes that appear, enter the number of items you want to drop.

For example, to drop only the lowest or the highest item, type 1.

7. When you are finished, click Save Changes.

Up


Import scores into the Gradebook

You can edit your grades in a spreadsheet application (e.g., Excel) and import the grades into the gradebook.

1. Click Import Grades along the top of the main window.

2. Download either the Excel or CSV spreadsheet template.

3. Edit the spreadsheet in your favorite spreadsheet application, such as Excel, and save it as a csv or xls file.

3. Click Choose File then browse to find your spreadsheet.

4. Click Import Spreadsheet.



Export scores from the Gradebook

From the Gradebook, you can export your students' scores for Microsoft Excel file or as a PDF or csv file. To export scores from the Gradebook, in the relevant course site, click Gradebook from the menubar , and then follow the appropriate steps below:

Exporting cumulative scores

Under the list of assignments, click the Course Grade link. You will see a course summary with an average score for your entire class and your grading table. To export your course scores to Microsoft Excel ( .csv format), click the Export for Excel or the Export CSV button.

The default filename format for your file is course_grade_[courseID]__date.* . The exported fields and the names of the Excel column headers are "Student Name", "Student ID", and "CourseGrade". The full student display names and complete assignment names are exported. Assignment point values will only export up to two decimal places. Scores are listed in the assignment name column.

Exporting scores from the student roster

At the top of the Gradebook, click the All Grades link. You will see your student roster, and Export for Excel and Export CSV buttons at the bottom of the page. For more information about exporting scores from the student roster, see Viewing and exporting student roster from the Gradebook .

It is also possible to export the roster in a format that matches the Wolverine Access format.

Up


View assignment details

In the Gradebook tool, you can access a page listing all of the details for a particular assignment by following these steps:

In the menubar , click Gradebook . If you are not already on the Overview page of the Gradebook tool, click Overview near the top of the window.

In the assignment list, locate the assignment for which you want to view details, and then click its title.

On the resulting Assignment Summary page, you will be able to view the maximum points possible ("Points") and the class average score ("Average for scores entered") for the selected assignment. Other information and options to edit assignment scores and settings are also available on this page.

Up


Hide columns in the grade table

When you are in the "All Grades" view (click the All Grades button along the top of the window) you can hide columns on the table of grades.

To do this, click the Hide/Show Columns button, which is on the right side just above the table. A box will open in which you can check the columns you want to hide.

Hiding a column will not affect any grade calculations or displays for the students. This is only used to organize and simplify the "All Grades" grade table for instructors.



Sort Gradebook tables

In the Gradebook, there are several tables that you can sort in various ways. In any of these tables, simply click the column heading by which you want to sort the table. Repeatedly clicking the same column heading will switch the sorting order between ascending and descending.

On the Overview page, you can sort the "Assignments" table by the following:

- Title
- Due Date
- Avg (class average score)
- Points (points possible)
- Grading table

You can also use the up and down arrows in the "Sorting" column to change the order.

On the Assignment Summary page for a particular assignment, you can sort the "Grading Table" by the following:

- Student Name (sorted by last name)
- Student ID (email address)- =Points (points earned on the assignment)

On the Course Grade summary page, you can sort the "Grading Table" by the following:

- Student Name (sorted by last name)
- Student ID (email address)
- Points (overall course points earned)
- Calculated Grade (Gradebook autocalculated course grade)
- Grade Override (overridden course grade)
- Roster

On the Roster page, you can sort the table by the following:

- Students (sorted by last name)
- Student ID (email address)
- Assignment Name (sorted by points earned on the assignment)
- Cumulative (overall course points earned)

Up



 

Brown Argus Butterfly

Brown Argus Butterfly

Aricia agestis