The LMS/Moodle 2.7 GradeBook Workbook

The  LMS/Moodle  2.7  

GradeBook  Workbook  

Gradebook  Overview  

Entering  Grades  

Extra  Credit  

Weighting  

Grade  Scale  

Export  to  Excel  

http://www.lbcc.edu/moodle/index.cfm  

Instructional Technology & Distance Learning (ITDL)

Moodle 2.7 Tutorials: Gradebook Overview Page 1

Moodle Gradebook Overview

Moodle gradebook enables you to arrange items in your gradebook, add categories and grade items and customize how student’s grades are calculated.

To access the gradebook, click on Grades link under Administration/Course Administration.

When you access the gradebook, Grader Report displays as a default. Grader report is an overview of all the grade categories and grade items that are currently in the gradebook.

To build your gradebook, click on Categories and Items tab.

Moodle 2.7 Tutorials: Gradebook Overview Page 2 When you are starting with a blank course you will see a blank gradebook that looks like this:

If you have activities such as assignments, graded forums, or quizzes then these grade items will be automatically populating your gradebook. We will cover this later.

To start building your gradebook, you will add categories and grade items.

To create a new category:

Select Add category button

Moodle 2.7 Tutorials: Gradebook Overview Page 3 And fill out the following:

Category Name

Then, click Save changes.

Repeat this step to add more categories.

Moodle 2.7 Tutorials: Gradebook Overview Page 4 Here is an example of the gradebook with three categories:

 Assignments

 Exams

 Reports

Now that your categories are created, you need to add individual assignments for each one. These are called grade items. Follow the instructions below.

To create a new grade item:

Select Add grade item button

Moodle 2.7 Tutorials: Gradebook Overview Page 5 And fill out the following:

 Item name

 Maximum grade

 Grade category Then, click Save changes.

Repeat this step to add more grade items.

Moodle 2.7 Tutorials: Gradebook Overview Page 6 This is an example of

 Moodle linked activities (see Assignments and Exams) and

 Manually created grade items (see Reports: Report 1 and Report 2)

Moodle 2.7 Tutorials: Gradebook Overview Page 7 The gradebook can be set up in two ways:

 Sum of grades

 Weighted means of grades Sum of grades is the default option.

Moodle 2.7 Tutorials: Gradebook Overview Page 8

Sum of grades

If you prefer to show a sum of points, you will set the course category’s aggregation method to “Sum of grades”. Your course total is the sum of all points for the course.

See the picture above.

Weighted mean of grades

This means that each category will hold a weight.

You set the aggregation to weighted mean of grades for the course and sum of grades for each category.

Look at the grade sheet below. This is an example of a grade sheet with weighted mean of grades.

There are three categories:

 Assignments worth 30% of total grade

 Exams worth 20% of total grade

 Reports worth 50% of total grade

The total for all categories must add up to 100%.

You need to put 100 in Course total window manually.

If you don’t do it, the gradebook will not calculate course totals correctly.

Moodle 2.7 Tutorials: Gradebook Overview Page 9 This covers the basic features of the gradebook.

Moodle 2.7 Tutorials: Manually Enter or Edit Grades in the Grader Report Page 1

Manually Enter or Edit Grades in the Grader Report

Moodle allows you to enter or edit grades directly in the Grader report. This method is different than grading submissions from within an activity such as an assignment, discussion forum or quiz.

Step 1

In the Grader report, click Turn Editing On (top right).

Grade cells will change to show an entry field.

Moodle 2.7 Tutorials: Manually Enter or Edit Grades in the Grader Report Page 2 Step 2

Manually input grades into blank cells in the gradebook, or edit grades already recorded for particular activities (such as assignments or quiz)

Step 3

Click Update to save changes.

Moodle 2.7 Tutorials: Manually Enter or Edit Grades in the Grader Report Page 3 If you have edited grades linked to a Moodle activity (such as assignment or quiz), Moodle will highlight the cells in orange to show that the grade has been overridden.

Manually overridden grade for assignment

(Orange cell)

Moodle 2.7 Tutorial: Gradebook / Extra Credit Page 1

MOODLE - EXTRA CREDIT

The Moodle gradebook provides a feature for extra credit that instructors award points on assignments without penalizing students for not completing the task.

There are two ways to set up extra credit.

1. Include extra credit in one of the categories (for one or two extra credit assignments) 2. Create a separate extra credit category (for multiple extra credit assignments) Include extra credit in one of the categories

Extra credit it will be included in the category where the extra credit is awarded. For example, if your gradebook has an assignment category and students will have extra credit assignment opportunities, you will place extra credit grade item in the assignment category.

1. First go to the “Categories and items” tab of your gradebook in simple or full view and click “Add Grade Item” button at the bottom of the page.

2. In the new grade item settings, give the item a name and maximum grade.

3. Finally, select the appropriate parent category and click the “Save Changes” button.

You should now have returned to the “Categories and Items” page. Locate the extra credit grade item and check its “Extra Credit” box. Click “Save Changes” button at the bottom of the page.

Here is an example - Extra Credit placed in “Assignments” category.

Moodle 2.7 Tutorial: Gradebook / Extra Credit Page 2

Notice that points in extra credit do not count towards the category total.

Moodle 2.7 Tutorial: Gradebook / Extra Credit Page 3

If you have multiple assignments for extra credit, it is a good idea to set up an extra credit category and add all assignments into it.

1. First go to the “Categories and items” tab of your gradebook in simple or full view and click “Add Category” button at the bottom of the page.

2. In the new grade category settings, give the category a name.

3. Click the “Save Changes” button.

4. Now add grade item to the newly created category - click “Add grade item” at the bottom of the page.

5. In the new grade item settings, give the item a name and maximum grade.

6. Finally, select the appropriate parent category (Extra Credit) and click “Save Changes” button.

7. Repeat steps 4-6 to add more grade items.

When finished, you should now have returned to the “Categories and Items” page. Locate the extra credit category and check its “Extra Credit” box. Click “Save Changes” button at the bottom of the page.

Here is a sample of Extra Credit category with two grade items in it

The extra credit category does not count towards the course total.

ITDL•  Moodle  Tutorials:  Attendance  •  Weighting27•  11/12/15   Page  1  

Gradebook:  Weighting    

If  you  choose  to  have  any  weighted  assignments  or  categories,  you  must  change  the  overall  

COURSE  AGGREGATION  to  Weighted  Mean  of  Grades.    

Keep  your  CATEGORIES  as  Sum  of  Grades.  Then  you  will  see  a  new  column,  named  “Weight”  

that  will  appear  to  the  right  of  the  Aggregation  column.    

Now,  choose  the  Weight  for  each  Category.  Your  overall  course  total  should  be  set  to  100  

(percentage).  

Overall  course  aggregation  

Continued  below……  

ITDL•  Moodle  Tutorials:  Attendance  •  Weighting27•  11/12/15   Page  2  

Total  here  must  add  up  to  100.00  

Moodle 2.7 Tutorials: Gradebook - Change Grading Scale Page 1

Change Grading Scale

By default, Moodle assigns letter grades according to the following percentages:

You can modify this grading scale and create your own.

First click on Edit Grade letters link.

You will be taken to a page that allows you to adjust the scaling basis for all the grades.

Moodle 2.7 Tutorials: Gradebook - Change Grading Scale Page 2 Check the Override site defaults box at the top.

You can now edit the way letter grades are awarded.

For example:

To change the letter boundary for grade letter A from 93% to 90%, select 90% from the drop-down menu.

Moodle 2.7 Tutorials: Gradebook - Change Grading Scale Page 3 To eliminate the grade letter that it is not used, select Unused under Letter grade boundary.

Continue to adjust all grade letters by repeating the steps above.

When finished, click Save changes button at the bottom of the page.

This is an example of the grading scale that has been adjusted.

Moodle 2.7 Tutorials: Export the Gradebook to Excel Page 1

Exporting your Moodle Gradebook to Excel

 Export your Moodle Gradebook to Excel

 Add the final letter grade to your Excel sheet

 Format the Excel Sheet

 Send your file to Enrollment Services

 Export your Moodle Gradebook to Excel

1. Go to Grades > View / Grader Report

2. Choose the Export Tab

3. Choose “Excel Spreadsheet.” Make sure you choose this option. The first choice “Open

document spreadsheet” is the default choice.

Moodle 2.7 Tutorials: Export the Gradebook to Excel Page 2

4. You will see Options and Grade Sections below.

Your currently enrolled student participants will be included on the Excel sheet.

(Note that “Exclude suspended users” is checked by default.)

5. Look at "Grade export display type" menu.

The three display choices are: Real, Percentage and Letter.

Regardless how you have set up individual grade items in your gradebook, the export feature

will display only one type. The default is Real (actual grades, points).

Real: Actual grades - points

Percentage: %

Letter: A, B, C, etc.

Depending on which one you choose, the resulting Excel file will contain ALL points,

percentages or letter grades.

6. “Grade items to be included” section

Scroll down. All your grade items will be checked, by default.

You can click the Select all/none link to deselect all items, and then select only the ones you

require.

Or proceed with all items checked.

Moodle 2.7 Tutorials: Export the Gradebook to Excel Page 3

Then click the "Submit" button – see below.

Moodle 2.7 Tutorials: Export the Gradebook to Excel Page 4

7. You will see a preview of your gradebook, as partially shown below.

Choose the “Download” button.

Moodle 2.7 Tutorials: Export the Gradebook to Excel Page 5

Depending on your Internet browser, the Excel file should automatically download. If not, a

pop-window will appear and you need to select Save File and then click OK.

Then, open it with Excel (if Excel does not automatically launch).

8. The Excel Spreadsheet

File Name: Moodle automatically creates a name for your file.

The resulting Excel file will include the following columns:

Student First Name, Student Surname and Student ID number, followed by all your

grade items. The last column will be the Course total.

Moodle 2.7 Tutorials: Export the Gradebook to Excel Page 6

 Add the final letter grades to your Excel sheet

You can create an Excel sheet that displays the grade items as points or percentages, then add

the final letter grades to the last column of the sheet.

1. Follow the instructions above, choosing Real (points) or Percentages.

2. Export a SECOND Excel sheet, following the instructions below, choosing Letter as the

export display type.

a. In the settings, choose Letter as the display type, as shown.

b. Click the Select all/none link to deselect all items.

Moodle 2.7 Tutorials: Export the Gradebook to Excel Page 7

c. Then select the last item: Course Total.

Repeat steps to download Excel file.

d. Export this additional Gradebook. Open it in Excel. Select the final row, as shown below.

Moodle 2.7 Tutorials: Export the Gradebook to Excel Page 8

e. Copy the letter grade column by clicking on the letter at the top of the column, then right-

click to copy the column.

Paste that row into the first gradebook you created, after the course total column.

Moodle 2.7 Tutorials: Export the Gradebook to Excel Page 9

 Format the Excel Sheet

If you need to print the Excel sheet, you will need to do a bit of formatting.

 Change the page orientation from Portrait to Landscape.

 To make all your assignment titles visible:

o Use your cursor to drag to make the title row height larger.

o Use the Format Cells feature to change that row to 90 degrees Alignment, or

choose Alignment > Wrap Text so all your assignment names will be visible.

 Look at a Print Preview of the pages before printing, and adjust scaling or other items.

 Send your file to Enrollment Services

You can send electronic files for grades and attendance to Enrollment Services, using the e-

mail address [email protected]

It is recommended that you use your LBCC e-mail account when sending, as well as providing

information in the subject -line and the body of the e-mail that is as informative as possible.

You do not need to format your Excel sheet for printing before you send it to Enrollment

Services.

Consult the A&R Faculty Services page, check with your department or Enrollment Services if

you have more questions about what is needed at the end of the semester.