Gradebook

From e-Learning Documentation

Contents 1 Faq 2 Gradebook Set Up 2.1 Option 1 - Create Columns and Enter Points 2.2 Option 2 - Create Weighted Columns and Grade Using Percentages 2.3 Option 3 - Create Weighted Categories and Grade Using Points 3 Enter Grades in a Gradebook Item (Column) 4 Enter Grades for a Specific Student 5 Import/Export Gradebook 5.1 Add Columns to Your Spreadsheet 5.2 Import Your Spreadsheet 6 Import a Scantron File 7 Prepare Grades for Submission to Grade-A-Gator

Faq

• Import Grades from File
• Release Grades to Students
• Change Grading Scale

Gradebook Set Up

There are three main ways that you can set up Gradebook 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.

Option 2 - Create weighted columns and grade using percentages. The Gradebook will calculate the final grade for you. 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 15 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.

NOTE: When you choose the weighted categories option, in the student's view of the Gradebook, they will see the categories and the weight of each category.

Gradebook will not drop the lowest score from a category, nor will it calculate extra credit. For these options, use Gradebook 2, or use Excel.

Option 1 - Create Columns and Enter Points

1. Within the course where you want to set up the Gradebook, click on Gradebook in the left menu.
2. From the options at the top of the page, click Gradebook Setup.
3. Under the heading "Grade Entry," select "Points."
4. Under the heading "Gradebook Items Display," choose whether or not to show Gradebook Items to students.
   1. As you make the columns, you can choose to create them released or not released. If you make them all released, but choose to not release them here, students won't see the grades until you release them under Gradebook Setup. This is a nice option for releasing all the columns at once without having to go to each individual column to release it.
5. Under the heading "Categories and Weighting," select "No Categories."
6. Click Save Changes

You will now create the columns for your grade data. Be aware that if you are creating graded Assignments and/or graded Tests & Quizzes and/or Assessments, those tools will automatically create Gradebook columns. You do not need to create columns for those items. If you are creating graded Discussions or need columns for any other grade entry, you will make those items within the Gradebook.

1. Click Gradebook Items at the top of the page
2. Click Add Gradebook Items.
3. Enter a Title and a Point Value in the boxes provided.
   1. The Point Value is not limiting. For example, if you set the Point Value to be "10," it is still possible to enter "11" points for the student grade.
4. Due date is optional. If you choose to enter this, students will see the due date when they view their grades.
5. Choose to release the item to the student and to include the item in course grade calculations.
   1. If you do not release the grade to the student, this column will not be included in course grade calculations.
6. If you want to add more Gradebook Items, click Add Another Gradebook Item and another set of boxes will appear so that you can continue to enter as many Gradebook Items as you want. If you do not want to add another, click Add Item(s).

Option 2 - Create Weighted Columns and Grade Using Percentages

1. Within the course where you want to set up the Gradebook, click on Gradebook in the left menu
2. From the options at the top of the page, click Gradebook Setup
3. Under the heading "Grade Entry," select "Percentages"
4. Under the heading "Gradebook Items Display," choose whether or not to show Gradebook Items to students.
   1. As you make the columns, you can choose to create them released or not released. If you make them all released, but hide them here, students won't see the grades until you release them under Gradebook Setup. This is a nice option for releasing all the columns at once without having to go to each individual column to release it.
5. Under the heading "Categories and Weighting," select "No Categories"
6. Click Save Changes

You will now create the columns for your grade data. Be aware that if you are creating graded Assignments and/or graded Tests & Quizzes and/or Assessments, those tools will automatically create Gradebook columns. You do not need to create columns for those items. If you are creating graded Discussions or need columns for any other grade entry, you will make those items within the Gradebook.

1. Click Gradebook Items at the top of the page
2. Click Add Gradebook Items
3. Enter a Title in the box provided
4. In the box labeled "Gradebook Item Relative Weight," enter the percentage of the total course grade that this one item represents. For example, if this column is for your Final Exam and that Final Exam is worth 35% of the total grade, enter 35% in this box.
5. Due date is optional. If you choose to enter this, students will see the due date when they view their grades.
6. Choose to release the item to the student and to include the item in course grade calculations.
   1. If you do not release the grade to the student, this column will not be included in course grade calculations.
7. If you want to add more Gradebook Items, click Add Another Gradebook Item and another set of boxes will appear so that you can continue to enter as many Gradebook Items as you want. If you do not want to add another, click Add Item(s).

Option 3 - Create Weighted Categories and Grade Using Points

1. Within the course where you want to set up the Gradebook, click on Gradebook in the left menu.
2. From the options at the top of the page, click Gradebook Setup.
3. Under the heading "Grade Entry," select "Points."
4. Under the heading "Gradebook Items Display," choose whether or not to show Gradebook Items to students.
   1. As you make the columns, you can choose to create them released or not released. If you make them all released, but hide them here, students won't see the grades until you release them under Gradebook Setup. This is a nice option for releasing all the columns at once without having to go to each individual column to release it.
5. Under the heading "Categories and Weighting," select "Categories & Weighting." As soon as you select this option, a box appears for you to enter a category and its weight.
   1. As you enter the categories, the system keeps a running total of the percentages you have entered and how much you still need to equal 100%. The system will not allow you to enter more than 100%.
6. Once you have entered all your categories, click Save Changes.

You will now create the columns for your grade data. Be aware that if you are creating graded Assignments and/or graded Tests & Quizzes and/or Assessments, those tools will automatically create Gradebook columns. You do not need to create columns for those items. If you are creating graded Discussions or need columns for any other grade entry, you will make those items within the Gradebook.

1. Click Gradebook Items at the top of the page
2. Click Add Gradebook Items
3. Enter a Title and a Point Value in the boxes provided
   1. The Point Value is not limiting. For example, if you set the Point Value to be "10," it is still possible to enter "11" points for the student grade.
4. Due date is optional. If you choose to enter this, students will see the due date when they view their grades.
5. Under the heading "Category," choose the appropriate category from the drop-down menu.
   1. If you do not choose a category, the Gradebook Item will be listed under "Unassigned" and cannot be used in calculations.
6. Choose to release the item to the student and to include the item in course grade calculations.
   1. If you do not release the grade to the student, this column will not be included in course grade calculations.
7. If you want to add more Gradebook Items, click Add Another Gradebook Item and another set of boxes will appear so that you can continue to enter as many Gradebook Items as you want. If you do not want to add another, click Add Item(s).

Enter Grades in a Gradebook Item (Column)

From within the course in which you want to enter grades:

1. Click Gradebook in the left menu bar.
   • If Gradebook Items were added when an Assignments, Assessments, or Tests & Quizzes was created, the grades will come from within the tool of origin. You cannot enter grades directly from the Gradebook, but must grade within the tool. From the "Gradebook Items" screen, you will see a column to the far right called "Grade Editor" that tells you if that Gradebook Item was created in a tool and which tool.
2. At the top of the page, click All Grades
3. Locate the column to which you want to add grades and click Details.
   1. If you want to provide comments to the students along with their grades, click Edit Comments at the top of the page.
4. Enter each student's grade along with any comments.
5. Click Save Changes.
   • You will notice that each grade now displays a "log" beside it. This log displays the history of the grade, who entered and/or changed a grade.

Enter Grades for a Specific Student

From within the course in which you want to enter grades:

1. Click Gradebook in the left menu bar.
   • If Gradebook Items were added when an Assignments, Assessments, or Tests & Quizzes was created, the grades will come from within the tool of origin. You cannot enter grades directly from the Gradebook, but must grade within the tool. From the "Gradebook Items" screen, you will see a column to the far right called "Grade Editor" that tells you if that Gradebook Item was created in a tool and which tool.
2. At the top of the page, click All Grades.
3. From the list of students, click the name of the student for whom you want to enter grades.
4. A screen will appear listing each column and providing a box for any grade that you may enter or change in the Gradebook. Enter grades.
5. Click Save Changes.

This screen also allows you to view this specific student's grades as that student would view them. At the top of the screen click (Student Name's) View of Grades. When you are done, click Return to Instructor's View of Grades for (Student Name).

Import/Export Gradebook

Though Gradebook or Gradebook 2 will perform the vast majority of common grade calculations, there may be occasions when you might need to perform a calculation using Excel. You may export your Gradebook to Excel, manage your grade calculations there, save the data as a .csv file and then import the information back into Gradebook for secure display to students.

Rather than creating a spreadsheet from scratch, you will want to create it by downloading your Gradebook. This way your spreadsheet is properly formatted and contains all the information needed to easily import back into the Gradebook. You will want to wait until the semester has begun and your Gradebook is fully populated with students before you download it. Some instructors choose to wait until drop/add has ended.

From within the course in which you want export/import grades:

1. Click Gradebook in the left menu bar.
2. At the top of the page, click Import Grades.
3. Click Download Spreadsheet Template.

The file exports as a .csv file. You may save it as an Excel file in order to insert forumlae and conduct calucations. But before you import the data back into the Gradebook, you must save the file as a .csv file again.

Add Columns to Your Spreadsheet

1. In the next available column in your spreadsheet, enter the column name and the point value using this format: Final Exam [100.0]
2. Enter grades in the column
   • You may add columns, grades, changes to existing data, etc in your spreadsheet. Be aware that if you are adding forumlae in Excel, only the results of those calculations, not the formulae themselves, will be imported back into the Gradebook.

Import Your Spreadsheet

Changes you've made to the spreadsheet can now be imported into the Gradebook. You must now save a copy of your Excel file as a .csv file.

1. From the "Import Grades" screen under the heading, "3. Import Spreadsheet" click Choose File.
2. Locate the .csv and double-click it.
3. Click Import Spreadsheet

Your data is now in your Gradebook

Import a Scantron File

There is another method for importing just one column of data, such as a Scantron File. This process will create a new column for your data. It will not put data into an already existing column.

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 Sakai gradebook. To convert the file:

1. Open MS Excel
2. Click the "Office Button" icon
3. Click Open. A box will open where you can locate the file.
4. At the bottom of this box, beside the heading "Files of type:" choose "All Files" from the drop-down menu.
5. Locate the file and double-click it. A box opens.
6. Click Next.
7. On the next screen under the heading "Delimiters," uncheck the box labeled "Tab" and check the box labeled "Comma."
8. Click Next.
9. Click Finish. Your data is displayed in Excel.

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

1. Click the "Office Button" icon
2. Double-click on Save As.
3. A box will open where you can save to a location on your computer. At the bottom of this box, beside the heading "Save as type:" choose CSV (Comma delimited) from the drop-down menu.
4. Click Save.
5. A box will open alerting you that .csv format will not preserve some formatting. Click Yes.
6. Close the file. Even though you have already saved it, you will get a "Do you want to save the changes box." Click No.

You are now ready to import this file into Gradebook.

From the "Gradebook Items" screen in the Gradebook:

1. Click Import gradebook item from spreadsheet. This takes you to the "loading dock" - a place where spreadsheets are stored.
2. Click Upload spreadsheet(csv format) to Loading Dock
3. Title this spreadsheet, for example "Mid-term exam" and click Choose File.
4. Locate the .csv file and double-click it.
5. Click Save
6. Your spreadsheet will be displayed. If this is correct, click OK. Now the spreadsheet is listed in your "loading dock" area.
7. Click Import.
8. Select the column of data you want to import and click Import Selected.
9. On the next screen, enter a Title for the new column and a Gradebook Item Point Value.
10. Click Submit.

Prepare Grades for Submission to Grade-A-Gator

Once the semester is over and all grades are entered into the Gradebook, prepare your grades to be entered into the Registrar "Grade-A-Gator" system.

1. In the Gradebook, click on Course Grades. The student's grade is displayed, along with the points received.
   • If there are students who have not received a grade in come columns, you must let the Gradebook know that the student is going to receive a zero for that submission. If you do not do this, the system still expects that there will be a grade entered and the calculations will be inaccurate.
2. To add zeros:
   1. Click Calculate Course Grades at the bottom of the page.
   • You will get a message explaining that this process is irreversible. That is true, but you can still make changes to the grades once you have Calculated Course Grades. If you make changes to grades after the calculation, click Calculate Course Grades again to include your changes.
3. If you have more than one section in this course, use the "View" drop-down menu to select one section.
   • The instructor can override any grade by entering the grade you want to give the student in the "Grade Override" box. If you change a grade, a Log is created that tracks all changes.
4. Click Export Course Grades.

The file that results contains the student ID, the student name, and the final Letter Grade. This file must be adjusted to meet Registrar requirements:

• Remove the headings from the first row of the spreadsheet.
• The student's names are displayed as "Last Name, First Name." You must remove the comma and the first name so that only the last name remains in the column.
• Replace the gatorlink username with the UFID.
  • If the first number(s) of a UFID is zero, Excel will drop the leading zero. In order to make the spreadsheet preserve the leading zeros, format those cells as "text."
    • Highlight the row
    • Click format
    • Click format cells
    • On the "Number" tab, select "Text"
    • Click OK
• Add a column with the course credit hours.
• Order columns in this order:
  • Section
  • UFID
  • Last Name
  • Letter Grade (If any student received an "F", this grade must be changed to an "I" or "E".
  • Credit Hours
• Save the file as a .csv file and proceed with upload to Grade-A-Gator.

Please contact the Office of the University Registrar at (352) 392-1374 if you have questions about the format of the file or the submission process.