Gradebook 2

From e-Learning Documentation

(Difference between revisions)
Jump to: navigation, search
Line 1: Line 1:
 +
Last updated: {{REVISIONMONTH}}-{{REVISIONDAY2}}-{{REVISIONYEAR}}
 +
==Faq==
==Faq==
*Import Grades
*Import Grades

Revision as of 20:16, 13 October 2010

Last updated: 10-13-2010

Contents

Faq

Overview

There are two gradebook applications in Sakai - Gradebook is the original tool and Gradebook 2 is a later addition offering a few more options. The two tools are integrated in such a way that any changes you make in one gradebook will show up in the other. You do not need to choose one tool and get rid of the other. You may keep both tools and utilize the best parts of each. You will want to hide one of the tools from the students, though, just to minimize confusion. Gradebook 2 will do everything Gradebook will do and will also:

Gradebook 2 will not:

NOTE: The reason Gradebook 2 will not let you enter more than the most possible points is that Gradebook 2 will calculate extra credit, where Gradebook will not. If you had an exam worth 100 points, but there was a bonus question worth 5 points, you would set up a column for the exam worth 100 points and an extra credit column worth 5 points.

Calculation Options

There are four main ways that you can set up Gradebook 2 calculations:

Option 1) Create columns and enter points. The gradebook will add all columns to give you a total number of points for the course. The Final letter grade will be based on a percentage of the total points.

Option 2) Create weighted columns and grade using percentages. This would be used if you have single items that make up a certain percentage of the grade. For example, the course project is 40% of the grade, the mid-term exam is 25% of the grade and the final exam is 35% of the grade.

Option 3) Create weighted categories, place columns within the categories and enter points. This would be used if you have several items under one category. For example, you assign 10 quizzes during the semester and the total of those quizzes will make up 15% of the grade. There are 5 assignments and the total of those assignments will make up 30% of the grade, etc.

Option 4) Grade using letter grades. Every column must be graded by a Letter Grade and the final grade will be an average of the letter grades. The letter grades are based on this scale and cannot be changed:

A+
100%
A
95%
A-
90%
B+
87%
B
83%
B-
80%
C+
77%
C
73%
C-
70%
D+
67%
D
63%
D-
60%
F
0%

Set Up Calculation Options

Gradebook 2 interface is a double-paned view. The left pane will list your categories and columns while the right column is for editing. If this is the first time you’ve opened Gradebook 2, the "Set Up Gradebook" screen will be opened for you in the right pane. Any other time, click Edit at the top of the blue box and choose “Gradebook Settings.” The “Set Up Gradebook” screen will appear in the right pane.

Set Up Gradebook 2 for Option 1

NOTE: You could utilize the "Categories" option if you want to drop lowest score(s) or if you just want to use the Categories for organizing your columns.

Now you need to add columns for your data:

NOTE: The Source denotes where the column was created and where grades can be entered. This column is being added in the gradebook and so must have the grades entered in the gradebook. If you had created an Assignment that automatically created a column in the gradebook for you, the source for that column would be "Assignments." Grades could only be entered through the Assignments tool, not through the gradebook. The same is true if the column was created through Tests & Quizzes or Assessments.

Repeat the above steps as many times as needed to create your gradebook columns.

Set Up Gradebook 2 for Option 2

NOTE: This option might best be set up in Gradebook rather than Gradebook 2. If you use this method, there are no advantages to using Gradebook 2 and the terminology used in Gradebook is more precise. Gradebook 2 will work using this method, but keep in mind that the terminology can be confusing.

Now you need to add the columns. Be aware that since you are grading using percentages, every column will be worth 100 "points" (percent).

NOTE: The Source denotes where the column was created and where grades can be entered. This column is being added in the gradebook and so must have the grades entered in the gradebook. If you had created an Assignment that automatically created a column in the gradebook for you, the source for that column would be "Assignments." Grades could only be entered through the Assignments tool, not through the gradebook. The same is true if the column was created through Tests & Quizzes or Assessments.

Set Up Gradebook 2 for Option 3

Now you need to add your categories and columns:

To create columns:

NOTE: The Source denotes where the column was created and where grades can be entered. This column is being added in the gradebook and so must have the grades entered in the gradebook. If you had created an Assignment that automatically created a column in the gradebook for you, the source for that column would be "Assignments." Grades could only be entered through the Assignments tool, not through the gradebook. The same is true if the column was created through Tests & Quizzes or Assessments.

Customize Gradebook 2 Appearance

The left pane contains all categories and columns. By default, they will be displayed in alphabetical order. Columns and categories can be rearranged by clicking the item and then dragging it to the place in the list where you want it to be. If you drag a category, all columns within that category will move also.

The right pane is used for editing settings, categories and columns. When you do not have an editing screen open in the right pane, it displays student data. By default, you will see the Students' names, displayed last name first, the Course Grade and the Grade Override column in the right pane. You can choose which columns to display when you click the Attributes & Grades tab at the top of the left pane. Check the box next to the item(s) you want to see in the right pane, or uncheck the box next to the item(s) you do not want to see.

Click the Gradebook tab at the top of the left pane to return to the list of categories and columns.

You may also choose to display any or all of the gradebook columns you have created in the right pane. Check the box beside any column you want to see in the right window pane. With this system, you may choose to only display the column you are currently working with to minimize the need to scroll.

Gradebook2: Input Student Grades, Import from Scantron, Import and Export Using Excel

Manually inputting Student Grades

Inputting student grades in Gradebook 2 is just like entering into an Excel spreadsheet. From the left pane:

Grades are automatically saved. The green triangle in the upper left corner of the box designates a grade that was manually entered.

Add a Comment and View Grade History

If you right click on a grade, a window opens that allows you to select to

Import from Scantron

NOTE: Because Gradebook 2 does not allow you to enter more than the most possible points in a column, if your scantron file has any grades greater than the most possible, the file will not import. You will need to import your file through Gradebook.

When you take your bubble sheets to Turlington B-213 for scanning, you will be asked to fill out paperwork. Make sure you check the box stating that you are using e-Learning. This will make sure your results include the gatorlink usernames of your students. You also need to take a flash drive or a floppy disk for the files you will receive.

You will receive two .txt files from the scanning office. One file contains the students' gatorlink username and grade. It will be called "UploadExam1." The other is called "NoMatchExam1" and contains any grades that do not match a UFID entered on the bubble sheets. This could happen if a student entered his/her UFID incorrectly on the bubble sheet. You will need to manually enter these grades after you finish the import of the UploadExam1 file.

The file must first be converted to a .csv file which is the only type of file that can be imported into the e-Learning in Gradebook 2. To convert the file:

NOTE: If you do not already have a column created, the process will create a new column for your data. The default points possible for this column will be 100 points. If your points possible is more than 100 points, the process will not work because Gradebook 2 will not allow the entry of more than the possible number of points. Create a column with the correct points possible before you import. If your points possible is less than 100, that will be no problem. You can change the points possible after the import.

The file must now be saved as a .csv file.

You are now ready to import this file into Gradebook 2.

Import and Export Using Excel in Gradebook 2

Exporting your gradebook is an important part of the end-of-semester process. You can save this spreadsheet to your computer, or burn it to a CD or DVD for long-term storage. This serves as a back-up of this important data.

Export from Gradebook 2

Import from Gradebook 2

Gradebook 2: Change the Letter Grade Scale

It is recommended that you change the Letter Grade Scale in Gradebook. Gradebook 2 does not allow for the entry of more than the most possible points and so it is not possible to override the A+ option. Once you make the changes in Gradebook, Gradebook 2 will reflect that information.

Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox