Gradebook 2

From e-Learning Documentation

(Difference between revisions)
Jump to: navigation, search
(Prepare Grades for Submission to Grade-A-Gator)
(Prepare Grades for Submission to Grade-A-Gator)
Line 1: Line 1:
-
Last updated: {{REVISIONMONTH}}-{{REVISIONDAY2}}-{{REVISIONYEAR}}
+
<p>Last updated: <span class="fck_mw_template">{{REVISIONMONTH}}</span>-<span class="fck_mw_template">{{REVISIONDAY2}}</span>-<span class="fck_mw_template">{{REVISIONYEAR}}</span>
-
 
+
</p>
-
==Overview==
+
<h2>Overview</h2>
-
There are two gradebook applications in Sakai - [[Gradebook | 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.  But, 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.
+
<p>There are two gradebook applications in Sakai - <a href="Gradebook"> Gradebook</a> 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.  But, 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 do everything Gradebook will do and will also:  
-
* allow for grading using letter grades
+
</p>
-
* drop the lowest score(s) in a category
+
<ul><li> allow for grading using letter grades
-
* allow for weighting specific columns within a category
+
</li><li> drop the lowest score(s) in a category
-
* calculate extra credit
+
</li><li> allow for weighting specific columns within a category
-
* allow the reordering of columns and categories by “drag and drop”
+
</li><li> calculate extra credit
-
* allow you to insert a zero in all columns until grades are entered.
+
</li><li> allow the reordering of columns and categories by “drag and drop”
-
* allow you to drop (excuse) a grade for an individual student.
+
</li><li> allow you to insert a zero in all columns until grades are entered.
-
** This keeps the Final Letter Grade calculations accurate even though not all data has been entered yet. If you do not choose this option, the Final Letter Grade calculations will not be accurate until all data is in and zeros have been entered into empty columns. It is recommended that you NOT display the Final Letter Grade to students until the end of the semester if you do not choose this option.
+
</li><li> allow you to drop (excuse) a grade for an individual student.
-
Gradebook 2 will not:
+
<ul><li> This keeps the Final Letter Grade calculations accurate even though not all data has been entered yet. If you do not choose this option, the Final Letter Grade calculations will not be accurate until all data is in and zeros have been entered into empty columns. It is recommended that you NOT display the Final Letter Grade to students until the end of the semester if you do not choose this option.
-
* allow more points than is possible to be entered in a column
+
</li></ul>
-
** because of this, you cannot remove the A+ option in Gradebook 2, but if you do it in Gradebook, the change will be reflected in Gradebook 2.
+
</li></ul>
 +
<p>Gradebook 2 will not:
 +
</p>
 +
<ul><li> allow more points than is possible to be entered in a column
 +
<ul><li> because of this, you cannot remove the A+ option in Gradebook 2, but if you do it in Gradebook, the change will be reflected in Gradebook 2.
 +
</li></ul>
 +
</li></ul>
 +
<p><b>NOTE:</b> 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.
 +
</p>
 +
<h2> Calculation Options </h2>
 +
<p>There are four main ways that you can set up Gradebook 2 calculations:
 +
</p><p><b>Option 1)</b> 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.
 +
</p><p><b>Option 2)</b> 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.
 +
</p><p><b>Option 3)</b> 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.
 +
</p><p><b>Option 4)</b> Grade using letter grades. There are a few things you need to consider before you decide to you letter grades in Gradebook 2:
 +
</p>
 +
<ul><li> You can only use Gradebook 2.  You cannot enter letter grades in Gradebook and you could create erratic information if you attempt to enter letter grades in Gradebook.
 +
</li><li> You must use <i>all</i> letter grades.  You cannot mix letter grades with numeric grades.
 +
</li><li> You will not be able to give automatically graded assessments using the Tests &amp; Quizzes or Assessments tools as those tools only give numeric grades.
 +
</li><li> You must create columns for Assignments in Gradebook 2 prior to creating the Assignment, rather than having the Assignment tool send a column to the Gradebook.  In Assignments, only numeric grades can be sent to the Gradebook. You will enter the grades in Gradebook 2, rather than in the Assignment.
 +
</li><li> You must use letter grades from the beginning of the semester.  You cannot change to letter grades from numeric and you cannot change numeric to letter grades.
 +
</li></ul>
 +
<p>The letter grades are based on this scale and cannot be changed:
 +
</p>
 +
<table width="200" cellspacing="1" cellpadding="1" border="1">
-
'''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.
+
<tr>
-
 
+
<td> A+<br />
-
== Calculation Options ==
+
</td><td> 100% <br />
-
 
+
</td></tr>
-
There are four main ways that you can set up Gradebook 2 calculations:
+
<tr>
-
 
+
<td> A<br />
-
'''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.
+
</td><td> 95%<br />
-
 
+
</td></tr>
-
'''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.
+
<tr>
-
 
+
<td> A-<br />
-
'''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.
+
</td><td> 90%<br />
-
 
+
</td></tr>
-
'''Option 4)''' Grade using letter grades. There are a few things you need to consider before you decide to you letter grades in Gradebook 2:
+
<tr>
-
 
+
<td> B+<br />
-
* You can only use Gradebook 2.  You cannot enter letter grades in Gradebook and you could create erratic information if you attempt to enter letter grades in Gradebook.
+
</td><td> 87%<br />
-
* You must use ''all'' letter grades.  You cannot mix letter grades with numeric grades.
+
</td></tr>
-
* You will not be able to give automatically graded assessments using the Tests & Quizzes or Assessments tools as those tools only give numeric grades.
+
<tr>
-
* You must create columns for Assignments in Gradebook 2 prior to creating the Assignment, rather than having the Assignment tool send a column to the Gradebook.  In Assignments, only numeric grades can be sent to the Gradebook. You will enter the grades in Gradebook 2, rather than in the Assignment.
+
<td> B<br />
-
* You must use letter grades from the beginning of the semester.  You cannot change to letter grades from numeric and you cannot change numeric to letter grades.
+
</td><td> 83%<br />
-
The letter grades are based on this scale and cannot be changed:
+
</td></tr>
-
 
+
<tr>
-
{| width="200" cellspacing="1" cellpadding="1" border="1"
+
<td> B-<br />
-
|-
+
</td><td> 80%<br />
-
| A+<br>
+
</td></tr>
-
| 100% <br>
+
<tr>
-
|-
+
<td> C+<br />
-
| A<br>
+
</td><td> 77%<br />
-
| 95%<br>
+
</td></tr>
-
|-
+
<tr>
-
| A-<br>
+
<td> C<br />
-
| 90%<br>
+
</td><td> 73%<br />
-
|-
+
</td></tr>
-
| B+<br>
+
<tr>
-
| 87%<br>
+
<td> C-<br />
-
|-
+
</td><td> 70%<br />
-
| B<br>
+
</td></tr>
-
| 83%<br>
+
<tr>
-
|-
+
<td> D+<br />
-
| B-<br>
+
</td><td> 67%<br />
-
| 80%<br>
+
</td></tr>
-
|-
+
<tr>
-
| C+<br>
+
<td> D<br />
-
| 77%<br>
+
</td><td> 63%<br />
-
|-
+
</td></tr>
-
| C<br>
+
<tr>
-
| 73%<br>
+
<td> D-<br />
-
|-
+
</td><td> 60%<br />
-
| C-<br>
+
</td></tr>
-
| 70%<br>
+
<tr>
-
|-
+
<td> F<br />
-
| D+<br>
+
</td><td> 0%<br />
-
| 67%<br>
+
</td></tr></table>
-
|-
+
<h3> Set Up Calculation Options </h3>
-
| D<br>
+
<ul><li>Within the course where you want to set up Gradebook 2, click on <b>Gradebook 2</b> in the left menu.
-
| 63%<br>
+
</li></ul>
-
|-
+
<p>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 <b>Edit</b> at the top of the blue box and choose “Gradebook Settings.” The “Set Up Gradebook” screen will appear in the right pane.  
-
| D-<br>
+
</p>
-
| 60%<br>
+
<ul><li>Your gradebook will have a long string of letters and numbers in the box called “Name.” This is the unique identifier of your course. You may change the name to something more understandable - such as “ABC1234 Gradebook.”
-
|-
+
</li></ul>
-
| F<br>
+
<h4> Set Up Gradebook 2 for Option 1 </h4>
-
| 0%<br>
+
<ul><li> Organize by: Select "No Categories"
-
|}
+
</li></ul>
-
 
+
<p><b>NOTE:</b> 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.  
-
=== Set Up Calculation Options ===
+
</p>
-
 
+
<ul><li> Grade Using: Select "Points"
-
*Within the course where you want to set up Gradebook 2, click on '''Gradebook 2''' in the left menu.
+
</li><li> Display to Students: Check the box(es) next to the items you want to be displayed to the students. You can come back and change this at any time.  
-
 
+
</li><li> Click <b>Save/Close</b>
-
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.  
+
</li></ul>
-
 
+
<p>Now you need to add columns for your data:  
-
*Your gradebook will have a long string of letters and numbers in the box called “Name.” This is the unique identifier of your course. You may change the name to something more understandable - such as “ABC1234 Gradebook.”
+
</p>
-
 
+
<ul><li> Click <b>File</b> at the top of the blue box and choose “New Item.” The “New Item” screen will appear in the right pane.  
-
==== Set Up Gradebook 2 for Option 1 ====
+
</li><li> Name: Enter a name for the column.
-
 
+
</li><li> Points: Enter the most possible points for this column.   
-
* Organize by: Select "No Categories"
+
</li><li> Due date: optional - it will appear to the students’ in their view of Gradebook 2  
-
'''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.  
+
</li><li> Source: Since you are creating this column in the gradebook , that is set as the source and cannot be changed.
-
* Grade Using: Select "Points"
+
</li></ul>
-
* Display to Students: Check the box(es) next to the items you want to be displayed to the students. You can come back and change this at any time.  
+
<p><b>NOTE:</b> 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 &amp; Quizzes or Assessments.  
-
* Click '''Save/Close'''
+
</p>
-
 
+
<ul><li> Include in grade: This box is checked by default. Only uncheck the box if you do not want the data in this column to be part of the calculations.  
-
Now you need to add columns for your data:  
+
</li><li> Extra credit:  Check this box if you want the data in this column to be added to the total number of points after the calculations are complete. This means that students are not penalized if they do not get these points.
-
 
+
</li><li> Release scores: Check this box if you want scores to be released to students.
-
* Click '''File''' at the top of the blue box and choose “New Item.” The “New Item” screen will appear in the right pane.  
+
</li><li> Give ungraded no credit: If you check this box, there will be a 0 in every box until a score is entered. This keeps the letter grade calculation accurate throughout the semester.
-
* Name: Enter a name for the column.
+
</li><li> Click <b>Add</b>
-
* Points: Enter the most possible points for this column.   
+
</li></ul>
-
* Due date: optional - it will appear to the students’ in their view of Gradebook 2  
+
<p>Repeat the above steps as many times as needed to create your gradebook columns.
-
* Source: Since you are creating this column in the gradebook , that is set as the source and cannot be changed.
+
</p>
-
 
+
<h4> Set Up Gradebook 2 for Option 2  </h4>
-
'''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 &amp; Quizzes or Assessments.  
+
<p><b>NOTE:</b> 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.
-
 
+
</p>
-
* Include in grade: This box is checked by default. Only uncheck the box if you do not want the data in this column to be part of the calculations.  
+
<ul><li> Organize by: Select “No Categories”  
-
* Extra credit:  Check this box if you want the data in this column to be added to the total number of points after the calculations are complete. This means that students are not penalized if they do not get these points.
+
</li><li> Grade Using:  Select "Percentages"
-
* Release scores: Check this box if you want scores to be released to students.
+
</li><li> Display to Students: Check the box(es) next to the items you want to be displayed to the students. You can come back and change this at any time.  
-
* Give ungraded no credit: If you check this box, there will be a 0 in every box until a score is entered. This keeps the letter grade calculation accurate throughout the semester.
+
</li><li>Click <b>Save/Close</b>
-
* Click '''Add'''
+
</li></ul>
-
Repeat the above steps as many times as needed to create your gradebook columns.
+
<p>Now you need to add the columns.  Be aware that since you are grading using percentages, every column will be worth 100 "points" (percent).   
-
 
+
</p>
-
==== Set Up Gradebook 2 for Option 2  ====
+
<ul><li>Click <b>File</b> at the top of the blue box and choose “New Item.” The “New Item” screen will appear in the right pane.  
-
'''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.
+
</li><li> Name: Enter the name of the column
-
 
+
</li><li> Points: Enter the number that reflect what percentage of the total grade this column is to receive.
-
* Organize by: Select “No Categories”  
+
<ul><li> This is where the terminology is not clear in Gradebook 2.  If you are using percentages, of course every column is worth 100.  What it really wants to know is the percentage of the total grade.  
-
* Grade Using:  Select "Percentages"
+
</li></ul>
-
* Display to Students: Check the box(es) next to the items you want to be displayed to the students. You can come back and change this at any time.  
+
</li><li> Due date: optional - it will appear to the students’ in their view of Gradebook 2  
-
*Click '''Save/Close'''
+
</li><li> Source: Since you are creating this column in the gradebook, that is set as the source and cannot be changed.
-
 
+
</li></ul>
-
Now you need to add the columns.  Be aware that since you are grading using percentages, every column will be worth 100 "points" (percent).   
+
<p><b>NOTE:</b> 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 &amp; Quizzes or Assessments.  
-
 
+
</p>
-
*Click '''File''' at the top of the blue box and choose “New Item.” The “New Item” screen will appear in the right pane.  
+
<ul><li> Include in grade: check the box if you want the data in this column to be part of the calculations.  
-
* Name: Enter the name of the column
+
</li><li> Extra credit: check this box if you want the data in this column to be added to the total number of points after the calculations are complete. This means that students are not penalized if they do not get these points.
-
* Points: Enter the number that reflect what percentage of the total grade this column is to receive.
+
</li><li> Release scores: check this box if you want students to see these scores.
-
** This is where the terminology is not clear in Gradebook 2.  If you are using percentages, of course every column is worth 100.  What it really wants to know is the percentage of the total grade.  
+
</li><li> Give ungraded no credit: if you check this box every student will receive a "0" until a grade is entered. This keeps the letter grade calculation accurate throughout the semester.
-
* Due date: optional - it will appear to the students’ in their view of Gradebook 2  
+
</li><li> Repeat these steps until you have columns whose weight equals 100%.
-
* Source: Since you are creating this column in the gradebook, that is set as the source and cannot be changed.
+
</li></ul>
-
 
+
<h4> Set Up Gradebook 2 for Option 3 </h4>
-
'''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 &amp; Quizzes or Assessments.  
+
<ul><li>Set “Organize by:” to “Weighted Categories”  
-
 
+
</li><li>Set “Grade Using” to “Points”  
-
* Include in grade: check the box if you want the data in this column to be part of the calculations.  
+
</li><li>In the “Display to Students” box, check the box(es) next to the items you want to be displayed to the students. You can come back and change this at any time.
-
* Extra credit: check this box if you want the data in this column to be added to the total number of points after the calculations are complete. This means that students are not penalized if they do not get these points.
+
</li><li>Click <b>Save/Close</b>
-
* Release scores: check this box if you want students to see these scores.
+
</li></ul>
-
* Give ungraded no credit: if you check this box every student will receive a "0" until a grade is entered. This keeps the letter grade calculation accurate throughout the semester.
+
<p>Now you need to add your categories and columns:
-
* Repeat these steps until you have columns whose weight equals 100%.
+
</p>
-
 
+
<ul><li> Name: Give a name to this category.
-
==== Set Up Gradebook 2 for Option 3 ====
+
</li><li>&nbsp;% Grade: Enter the percentage of the overall grade that this category receives
-
 
+
</li><li> Drop lowest: Enter a number to drop the lowest score(s) within this category.
-
*Set “Organize by:” to “Weighted Categories”  
+
</li><li> Include in Grade: The box is checked by default - leave it checked.
-
*Set “Grade Using” to “Points”  
+
</li><li> Extra Credit: Since this category is a percentage of the total grade, it will not be extra credit so you should not check the box. If you do want to add a category for extra credit, you will make a separate category for that.  In the "percentage of grade" box, you need to enter what percentage of the grade the total number of extra credit points are.  For example, if your total points is 100 and you offer 2 extra points, you enter "2" in the "percent of grade" box.  If your course is worth 400 points and you offer 10 extra points, you enter "2.5" in the "percent of grade" box.
-
*In the “Display to Students” box, check the box(es) next to the items you want to be displayed to the students. You can come back and change this at any time.
+
</li><li> Weight items equally: You must check this box if you are dropping lowest score(s).  Even if you are not dropping lowest score(s), check the box if every item in this category will carry the same weight within the category.  If you do not check the box, when you create your columns, you will have the option to set each column with a weight within the category.
-
*Click '''Save/Close'''
+
</li><li> Release scores: Check the box if you want the scores in all the columns in the category to be released to students.
-
 
+
</li><li> Click <b>Add</b>.  Repeat these steps to add as many categories as you need to total 100%.
-
Now you need to add your categories and columns:
+
</li></ul>
-
* Name: Give a name to this category.
+
<p>To create columns:
-
* % Grade: Enter the percentage of the overall grade that this category receives
+
</p>
-
* Drop lowest: Enter a number to drop the lowest score(s) within this category.
+
<ul><li> Click <b>File</b> at the top of the blue box and choose “New Item.” The “New Item” screen will appear in the right pane.  
-
* Include in Grade: The box is checked by default - leave it checked.
+
</li><li> Name: Enter a name for the column.
-
* Extra Credit: Since this category is a percentage of the total grade, it will not be extra credit so you should not check the box. If you do want to add a category for extra credit, you will make a separate category for that.  In the "percentage of grade" box, you need to enter what percentage of the grade the total number of extra credit points are.  For example, if your total points is 100 and you offer 2 extra points, you enter "2" in the "percent of grade" box.  If your course is worth 400 points and you offer 10 extra points, you enter "2.5" in the "percent of grade" box.
+
</li><li> Category: Select the appropriate category from the drop-down menu.
-
* Weight items equally: You must check this box if you are dropping lowest score(s).  Even if you are not dropping lowest score(s), check the box if every item in this category will carry the same weight within the category.  If you do not check the box, when you create your columns, you will have the option to set each column with a weight within the category.
+
</li><li> Points: Enter the most possible points for this column.   
-
* Release scores: Check the box if you want the scores in all the columns in the category to be released to students.
+
</li><li> Due date: optional - it will appear to the students’ in their view of Gradebook 2  
-
* Click '''Add'''.  Repeat these steps to add as many categories as you need to total 100%.
+
</li><li> Source: Since you are creating this column in the gradebook , that is set as the source and cannot be changed.
-
 
+
</li></ul>
-
To create columns:
+
<p><b>NOTE:</b> 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 &amp; Quizzes or Assessments.  
-
* Click '''File''' at the top of the blue box and choose “New Item.” The “New Item” screen will appear in the right pane.  
+
</p>
-
* Name: Enter a name for the column.
+
<ul><li> Include in grade: This box is checked by default. Only uncheck the box if you do not want the data in this column to be part of the calculations.  
-
* Category: Select the appropriate category from the drop-down menu.
+
</li><li> Extra credit:  Check this box if you want the data in this column to be added to the total number of points after the calculations are complete. This means that students are not penalized if they do not get these points.
-
* Points: Enter the most possible points for this column.   
+
</li><li> Release scores: Check this box if you want scores to be released to students.
-
* Due date: optional - it will appear to the students’ in their view of Gradebook 2  
+
</li><li> Give ungraded no credit: If you check this box, there will be a 0 in every box until a score is entered. This keeps the letter grade calculation accurate throughout the semester.
-
* Source: Since you are creating this column in the gradebook , that is set as the source and cannot be changed.
+
</li><li> Click <b>Add</b>
-
 
+
</li><li> Repeat this process until you have all your columns created.
-
'''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 &amp; Quizzes or Assessments.  
+
</li></ul>
-
 
+
<h4>Set Up Gradebook 2 for Option 4</h4>
-
* Include in grade: This box is checked by default. Only uncheck the box if you do not want the data in this column to be part of the calculations.  
+
<p>Other than the fact that you are using letters rather than points, setting up the categories and columns are exactly like options 1 &amp; 3 above.  When you create a new column, it will ask for "Points." Just ignore this box.  Other than that, follow the instructions above to set up Gradebook 2 for letter grades.
-
* Extra credit:  Check this box if you want the data in this column to be added to the total number of points after the calculations are complete. This means that students are not penalized if they do not get these points.
+
</p>
-
* Release scores: Check this box if you want scores to be released to students.
+
<h2>Customize Gradebook 2 Appearance</h2>
-
* Give ungraded no credit: If you check this box, there will be a 0 in every box until a score is entered. This keeps the letter grade calculation accurate throughout the semester.
+
<p>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.   
-
* Click '''Add'''
+
</p><p>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 <b>Attributes &amp; Grades</b> 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.
-
* Repeat this process until you have all your columns created.
+
</p>
-
 
+
<ul><li> Display ID = gatorlink username
-
====Set Up Gradebook 2 for Option 4====
+
</li><li> Display Name = student name, first name first
-
 
+
</li><li> Last Name, First = student name, last name first
-
Other than the fact that you are using letters rather than points, setting up the categories and columns are exactly like options 1 & 3 above.  When you create a new column, it will ask for "Points." Just ignore this box.  Other than that, follow the instructions above to set up Gradebook 2 for letter grades.
+
</li><li> Email = gatorlink email address
-
 
+
</li><li> Section = section #
-
==Customize Gradebook 2 Appearance==
+
</li><li> Course Grade = displays the calculated letter grade and shows the percentage that the letter grade is based on in parentheses - B+(89.7%)
-
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.   
+
</li><li> Grade Override = this column allows you to override the calculated letter grade.
-
 
+
</li><li> Letter Grade = displays the calculated letter grade without the percentage - B+
-
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.
+
</li><li> Calculated Grade = displays the calculated percentage without the letter grade - 89.7%
-
* Display ID = gatorlink username
+
</li></ul>
-
* Display Name = student name, first name first
+
<p>Click the <b>Gradebook</b> tab at the top of the left pane to return to the list of categories and columns.
-
* Last Name, First = student name, last name first
+
</p><p>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.
-
* Email = gatorlink email address
+
</p>
-
* Section = section #
+
<h2>Gradebook2: Input Student Grades, Import from Scantron, Import and Export Using Excel</h2>
-
* Course Grade = displays the calculated letter grade and shows the percentage that the letter grade is based on in parentheses - B+(89.7%)
+
<h3>Manually inputting Student Grades</h3>
-
* Grade Override = this column allows you to override the calculated letter grade.
+
<p>Inputting student grades in Gradebook 2 is just like entering into an Excel spreadsheet.   
-
* Letter Grade = displays the calculated letter grade without the percentage - B+
+
-
* Calculated Grade = displays the calculated percentage without the letter grade - 89.7%
+
-
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:
From the left pane:
-
* check the box next to the column(s) into which you want to input grades.
+
</p>
-
** The column(s) will show next to the list of student names in the right pane.  
+
<ul><li> check the box next to the column(s) into which you want to input grades.
-
* click in the column beside the student's name and type in the grade.
+
<ul><li> The column(s) will show next to the list of student names in the right pane.  
-
Grades are automatically saved. The green triangle in the upper left corner of the box designates a grade that was manually entered.   
+
</li></ul>
-
====Add a Comment and View Grade History====
+
</li><li> click in the column beside the student's name and type in the grade.
-
If you right click on a grade, a window opens that allows you to select to  
+
</li></ul>
-
* Add a comment: Add a comment to the student pertaining to his/her grade. Type your comment and click '''Submit'''.
+
<p>Grades are automatically saved. The green triangle in the upper left corner of the box designates a grade that was manually entered.   
-
* Edit a comment: (only if a comment already exists) - Make edits to a previously posted comment * View Grade History - See any changes that have been make to this grade.  Includes the name of the person who made the change.
+
</p>
-
 
+
<h4>Add a Comment and View Grade History</h4>
-
====Excuse (Drop) a Grade for an Individual Student====
+
<p>If you right click on a grade, a window opens that allows you to select to  
-
In the right window pane where your students are listed:
+
</p>
-
* Click the hyperlinked name of the student
+
<ul><li> Add a comment: Add a comment to the student pertaining to his/her grade. Type your comment and click <b>Submit</b>.
-
* A smaller box opens within the right pane that contains the student information and then the scores listed below that.  There are three tabs at the top of the list of scores.  Click on '''Excuses'''
+
</li><li> Edit a comment: (only if a comment already exists) - Make edits to a previously posted comment * View Grade History - See any changes that have been make to this grade.  Includes the name of the person who made the change.
-
* Check the box beside any grade you want to drop for this student.
+
</li></ul>
-
* Click '''Close'''
+
<h4>Excuse (Drop) a Grade for an Individual Student</h4>
-
 
+
<p>In the right window pane where your students are listed:
-
===Import from Scantron===
+
</p>
-
 
+
<ul><li> Click the hyperlinked name of the student
-
'''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.
+
</li><li> A smaller box opens within the right pane that contains the student information and then the scores listed below that.  There are three tabs at the top of the list of scores.  Click on <b>Excuses</b>
-
 
+
</li><li> Check the box beside any grade you want to drop for this student.
-
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.
+
</li><li> Click <b>Close</b>
-
 
+
</li></ul>
-
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.
+
<h3>Import from Scantron</h3>
-
 
+
<p><b>NOTE:</b> 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.
-
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:
+
</p><p>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.
-
* Open MS Excel
+
</p><p>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.
-
* Click the "Office Button" [[File:office-button.png]]icon
+
</p><p>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:
-
* Click Open. A box will open where you can locate the file.
+
</p>
-
* At the bottom of this box, beside the heading "Files of type:" choose "All Files" from the drop-down menu.
+
<ul><li> Open MS Excel
-
* Locate the file and double-click it. A box opens.
+
</li><li> Click the "Office Button" <img src="/lssmw-faq/images/9/99/Office-button.png" _fck_mw_filename="Office-button.png" alt="" />icon
-
* Click '''Next'''
+
</li><li> Click Open. A box will open where you can locate the file.
-
* On the next screen under the heading "Delimiters," uncheck the box labeled "Tab" and check the box labeled "Comma."
+
</li><li> At the bottom of this box, beside the heading "Files of type:" choose "All Files" from the drop-down menu.
-
* Click '''Next'''
+
</li><li> Locate the file and double-click it. A box opens.
-
* Click '''Finish'''. Your data is displayed in Excel
+
</li><li> Click <b>Next</b>
-
* You see two columns - one contains the gatorlink username and the other the score.  In the heading of the gatorlink username column, change "User ID" to "Student ID"
+
</li><li> On the next screen under the heading "Delimiters," uncheck the box labeled "Tab" and check the box labeled "Comma."
-
* If you have already created a column in Gradebook 2 to receive these scores, change the heading of the column to match perfectly the heading in the gradebook.  
+
</li><li> Click <b>Next</b>
-
 
+
</li><li> Click <b>Finish</b>. Your data is displayed in Excel
-
'''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.  
+
</li><li> You see two columns - one contains the gatorlink username and the other the score.  In the heading of the gatorlink username column, change "User ID" to "Student ID"
-
 
+
</li><li> If you have already created a column in Gradebook 2 to receive these scores, change the heading of the column to match perfectly the heading in the gradebook.  
-
The file must now be saved as a .csv file.
+
</li></ul>
-
* Click the "Office Button" [[File:office-button.png]]icon
+
<p><b>NOTE:</b> 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.  
-
* Double-click on '''Save As'''. A box will open where you can save to a location on your computer.
+
</p><p>The file must now be saved as a .csv file.
-
* At the bottom of this box, beside the heading "Save as type:" choose CSV (Comma delimited) from the drop-down menu.
+
</p>
-
* Click '''Save'''.
+
<ul><li> Click the "Office Button" <img src="/lssmw-faq/images/9/99/Office-button.png" _fck_mw_filename="Office-button.png" alt="" />icon
-
* A box will open alerting you that .csv format will not preserve some formatting. Click '''Yes'''.
+
</li><li> Double-click on <b>Save As</b>. A box will open where you can save to a location on your computer.
-
* Close the file. Even though you have already saved it, you will again get a "Do you want to save the changes box." Click '''No'''.
+
</li><li> At the bottom of this box, beside the heading "Save as type:" choose CSV (Comma delimited) from the drop-down menu.
-
 
+
</li><li> Click <b>Save</b>.
-
You are now ready to import this file into Gradebook 2.
+
</li><li> A box will open alerting you that .csv format will not preserve some formatting. Click <b>Yes</b>.
-
* Click '''Tools''' at the upper left of the blue box
+
</li><li> Close the file. Even though you have already saved it, you will again get a "Do you want to save the changes box." Click <b>No</b>.
-
* Click '''Import'''
+
</li></ul>
-
* On the next screen, click '''Browse''' beside the "File:" box.
+
<p>You are now ready to import this file into Gradebook 2.
-
* Locate the file on your computer and double-click on it.
+
</p>
-
* Click '''Next'''
+
<ul><li> Click <b>Tools</b> at the upper left of the blue box
-
* You will see the "Preview Data" screen which shows the information you are importing.  Verify that this is accurate and click '''Next'''.
+
</li><li> Click <b>Import</b>
-
* Click '''Done'''
+
</li><li> On the next screen, click <b>Browse</b> beside the "File:" box.
-
* If you created a new column with this import, it will not be released to the students.  Double-click the name of the column in the left pane to release and adjust any settings that need to be changed.
+
</li><li> Locate the file on your computer and double-click on it.
-
 
+
</li><li> Click <b>Next</b>
-
===Import and Export Using Excel in Gradebook 2===
+
</li><li> You will see the "Preview Data" screen which shows the information you are importing.  Verify that this is accurate and click <b>Next</b>.
-
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.   
+
</li><li> Click <b>Done</b>
-
 
+
</li><li> If you created a new column with this import, it will not be released to the students.  Double-click the name of the column in the left pane to release and adjust any settings that need to be changed.
-
====Export from Gradebook 2====
+
</li></ul>
-
* Click '''Tools''' at the upper left of the blue box
+
<h3>Import and Export Using Excel in Gradebook 2</h3>
-
* Click '''Export'''
+
<p>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.   
-
* Select:
+
</p>
-
** '''Only Grades as CSV''' - this option exports all student IDs (gatorlink username), Name, all columns including a comments column for each grade column, and the Course Grade. You will choose this option if you want to import scores and/or comments back into Gradebook 2. The file is already in the proper format for importing back into Gradebook 2.
+
<h4>Export from Gradebook 2</h4>
-
** '''Only Grades as Excel 97/2000/XP''' - this option exports the same information as above, but opens it in Excel which allows you to add calculations and other formatting not available in .csv format.  If you want to import data from this spreadsheet, you will have to save it as .csv before importing. Be aware that numeric values are the only data that can be imported into Gradebook 2 unless you are grading with letter grades.  In that case, only the standard letter grades with +/- can be imported.
+
<ul><li> Click <b>Tools</b> at the upper left of the blue box
-
** '''Grades & Structure as CSV''' - this option exports all grades and also states the information about how the gradebook was set up - such as weighted categories, dropped scores, etc. in .csv format.   
+
</li><li> Click <b>Export</b>
-
** '''Grades and Structure as Excel 97/2000/XP''' - this option exports the same as above, but in Excel format.   
+
</li><li> Select:
-
* The file is saved to your computer.   
+
<ul><li> <b>Only Grades as CSV</b> - this option exports all student IDs (gatorlink username), Name, all columns including a comments column for each grade column, and the Course Grade. You will choose this option if you want to import scores and/or comments back into Gradebook 2. The file is already in the proper format for importing back into Gradebook 2.
-
 
+
</li><li> <b>Only Grades as Excel 97/2000/XP</b> - this option exports the same information as above, but opens it in Excel which allows you to add calculations and other formatting not available in .csv format.  If you want to import data from this spreadsheet, you will have to save it as .csv before importing. Be aware that numeric values are the only data that can be imported into Gradebook 2 unless you are grading with letter grades.  In that case, only the standard letter grades with +/- can be imported.
-
====Import from Gradebook 2====
+
</li><li> <b>Grades &amp; Structure as CSV</b> - this option exports all grades and also states the information about how the gradebook was set up - such as weighted categories, dropped scores, etc. in .csv format.   
-
 
+
</li><li> <b>Grades and Structure as Excel 97/2000/XP</b> - this option exports the same as above, but in Excel format.   
-
'''NOTE:''' If you are working with a file you exported from Gradebook 2, it will include a column with the student UFID in it, even though you do not see that column in Gradebook 2.  That column has been inserted so that when you export your grades at the end of the semester for import into Grade-A-Gator, you will have the UFID.  But if you are going to re-import this spreadsheet back into Gradebook 2, you will need to delete the UFID column.  That column will not import.   
+
</li></ul>
-
 
+
</li><li> The file is saved to your computer.   
-
* Click '''Tools''' at the upper left of the blue box
+
</li></ul>
-
* Click '''Import'''
+
<h4>Import from Gradebook 2</h4>
-
* On the next screen, click '''Browse''' beside the "File:" box.
+
<p><b>NOTE:</b> If you are working with a file you exported from Gradebook 2, it will include a column with the student UFID in it, even though you do not see that column in Gradebook 2.  That column has been inserted so that when you export your grades at the end of the semester for import into Grade-A-Gator, you will have the UFID.  But if you are going to re-import this spreadsheet back into Gradebook 2, you will need to delete the UFID column.  That column will not import.   
-
* Locate the file on your computer and double-click on it.
+
</p>
-
* Click '''Next'''
+
<ul><li> Click <b>Tools</b> at the upper left of the blue box
-
* You will see the "Preview Data" screen which shows the information you are importing.  Verify that this is accurate and click '''Next'''.
+
</li><li> Click <b>Import</b>
-
* Click '''Done'''
+
</li><li> On the next screen, click <b>Browse</b> beside the "File:" box.
-
* If you created a new column with this import, it will not be released to the students.  Double-click the name of the column in the left pane to release and adjust any settings that need to be changed.
+
</li><li> Locate the file on your computer and double-click on it.
-
 
+
</li><li> Click <b>Next</b>
-
==Gradebook 2: Change the Letter Grade Scale==
+
</li><li> You will see the "Preview Data" screen which shows the information you are importing.  Verify that this is accurate and click <b>Next</b>.
-
It is recommended that you change the Letter Grade Scale in [[Gradebook#Change the Letter Grade Scale in Gradebook | 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.
+
</li><li> Click <b>Done</b>
-
 
+
</li><li> If you created a new column with this import, it will not be released to the students.  Double-click the name of the column in the left pane to release and adjust any settings that need to be changed.
-
==Prepare Grades for Submission to Grade-A-Gator==
+
</li></ul>
-
 
+
<h2>Gradebook 2: Change the Letter Grade Scale</h2>
-
If any of the Course Grades have three asterisks beside them, for example, "B (87.2%)***" that means that all data is not available for that grade.  If a student doesn't have a grade in at least one column, you will see the three asterisks.  You will need to add zeros to the empty cells:
+
<p>It is recommended that you change the Letter Grade Scale in <a href="Gradebook#Change_the_Letter_Grade_Scale_in_Gradebook"> Gradebook</a>.  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.
-
 
+
</p>
-
# Double-click on the name of the column in the left pane.   
+
<h2>Prepare Grades for Submission to Grade-A-Gator</h2>
-
# In the right pane, check the box beside "Give ungraded no credit."  
+
<p>If any of the Course Grades have three asterisks beside them, for example, "B (87.2%)***" that means that all data is not available for that grade.  If a student doesn't have a grade in at least one column, you will see the three asterisks.  You will need to add zeros to the empty cells:
-
# Click '''Save'''
+
</p>
-
# Continue until all columns have zeros inserted.  Click '''Save/Close'''
+
<ol><li> Double-click on the name of the column in the left pane.   
-
 
+
</li><li> In the right pane, check the box beside "Give ungraded no credit."  
-
You have the option to override any grade.  If there is a final grade that you want to change before exporting the grades, you may do that. In the Gradebook 2 left pane:
+
</li><li> Click <b>Save</b>
-
# Click the "Attributes and Grades" tab
+
</li><li> Continue until all columns have zeros inserted.  Click <b>Save/Close</b>
-
# Make sure the check box is checked beside "Course Grade" and "Grade Override."
+
</li></ol>
-
# In the right pane, those columns appear beside the student names.  In the Grade Override column, enter the grade you want to give the student(s).  In the "Course Grade" column, the calculate percentage will change to say "override."
+
<p>You have the option to override any grade.  If there is a final grade that you want to change before exporting the grades, you may do that. In the Gradebook 2 left pane:
-
 
+
</p>
-
'''NOTE:''' You cannot use this process to change an "F" to an "E" or an "I" as those are not valid grades in the system.  You can only change the letter grade to another valid letter grade; A+, A, A-, B+, B, B-, C+, C, C-, D+, D, D-, F.
+
<ol><li> Click the "Attributes and Grades" tab
-
 
+
</li><li> Make sure the check box is checked beside "Course Grade" and "Grade Override."
-
You are now ready to download the grades. '''NOTE:''' This tutorial is being edited to address the lack of section numbers.  We will be issuing a corrected tutorial within hours. 12162010, 10am.
+
</li><li> In the right pane, those columns appear beside the student names.  In the Grade Override column, enter the grade you want to give the student(s).  In the "Course Grade" column, the calculate percentage will change to say "override."
-
 
+
</li></ol>
-
# At the top of the Gradebook 2 screen, click '''Tools > Export > Only Grades > as Excel 97/2000/XP (.xls)'''
+
<p><b>NOTE:</b> You cannot use this process to change an "F" to an "E" or an "I" as those are not valid grades in the system.  You can only change the letter grade to another valid letter grade; A+, A, A-, B+, B, B-, C+, C, C-, D+, D, D-, F.
-
# The file will be downloaded to your computer.  Open the file.  Delete all the columns except "Student ID," "UFID," "Student Name," and "Course Grade."  To remove the calculated percentage from the letter grade column (these instructions are for Office 2007):
+
</p><p>You are now ready to download the grades. <b>NOTE:</b> This tutorial is being edited to address the lack of section numbers.  We will be issuing a corrected tutorial within hours. 12162010, 10am.
-
<div style="clear:both;float:right;">[[File:Gradebook2_Excel_Replace.PNG]]</div>
+
</p>
-
## Select Ctrl-F and enter (* in the Find field. Leave the Replace field blank.
+
<ol><li> At the top of the Gradebook 2 screen, click <b>Tools &gt; Export &gt; Only Grades &gt; as Excel 97/2000/XP (.xls)</b>
-
## Click Replace All. Every student's course grade will have the percentage removed.
+
</li><li> The file will be downloaded to your computer.  Open the file.  Delete all the columns except "Student ID," "UFID," "Student Name," and "Course Grade."  To remove the calculated percentage from the letter grade column (these instructions are for Office 2007):
-
## Change any grade of "F" to an "I" or an "E."
+
</li></ol>
-
 
+
<div style="clear:both;float:right;"><img src="/lssmw-faq/images/2/2c/Gradebook2_Excel_Replace.PNG" _fck_mw_filename="Gradebook2 Excel Replace.PNG" alt="" /></div>
-
 
+
<ol><li><ol><li> Select Ctrl-F and enter (* in the Find field. Leave the Replace field blank.
-
 
+
</li><li> Click Replace All. Every student's course grade will have the percentage removed.
-
We will now add the Section Number.  The first column in your spreadsheet is the Student ID (gatorlink username) which is not needed.   
+
</li><li> Change any grade of "F" to an "I" or an "E."
-
# Click in the cell that contains the first student's gatorlink username, and change it to the section number.  
+
</li></ol>
-
# Click the lower right corner of that cell and drag it down the column to replace all the gatorlink usernames with the Section Number.
+
</li></ol>
-
 
+
<p><br />
-
 
+
</p><p>We will now add the Section Number.  The first column in your spreadsheet is the Student ID (gatorlink username) which is not needed.   
-
 
+
</p>
-
We will now add a column to contain the Credit Hours.
+
<ol><li> Click in the cell that contains the first student's gatorlink username, and change it to the section number.  
-
# Insert a column between the Student Name and the Course Grade.   
+
</li><li> Click the lower right corner of that cell and drag it down the column to replace all the gatorlink usernames with the Section Number.
-
# In the first cell of this column, enter the Credit Hours.   
+
</li></ol>
-
# Click the lower right corner of that cell and drag it down the column to enter the Credit Hours in all the cells.   
+
<p><br />
-
 
+
</p><p>We will now add a column to contain the Credit Hours.
-
 
+
</p>
-
 
+
<ol><li> Insert a column between the Student Name and the Course Grade.   
-
# Remove the headings from the first row of the spreadsheet. Columns should be in this order:
+
</li><li> In the first cell of this column, enter the Credit Hours.   
-
## Section
+
</li><li> Click the lower right corner of that cell and drag it down the column to enter the Credit Hours in all the cells.   
-
## UFID
+
</li></ol>
-
## Last Name, First Name
+
<p><br />
-
## Credit Hours
+
</p>
-
## Grades
+
<ol><li> Remove the headings from the first row of the spreadsheet. Columns should be in this order:
-
# Save the file as a .csv file and proceed with upload to Grade-A-Gator.
+
<ol><li> Section
-
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.
+
</li><li> UFID
 +
</li><li> Last Name, First Name
 +
</li><li> Credit Hours
 +
</li><li> Grades
 +
</li></ol>
 +
</li><li> Save the file as a .csv file and proceed with upload to Grade-A-Gator.
 +
</li></ol>
 +
<p>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.
 +
</p>

Revision as of 16:04, 16 December 2010

Last updated: 12-16-2010

Contents

Overview

There are two gradebook applications in Sakai - <a href="Gradebook"> Gradebook</a> 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. But, 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. There are a few things you need to consider before you decide to you letter grades in Gradebook 2:

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.

Set Up Gradebook 2 for Option 4

Other than the fact that you are using letters rather than points, setting up the categories and columns are exactly like options 1 & 3 above. When you create a new column, it will ask for "Points." Just ignore this box. Other than that, follow the instructions above to set up Gradebook 2 for letter grades.

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

Excuse (Drop) a Grade for an Individual Student

In the right window pane where your students are listed:

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

NOTE: If you are working with a file you exported from Gradebook 2, it will include a column with the student UFID in it, even though you do not see that column in Gradebook 2. That column has been inserted so that when you export your grades at the end of the semester for import into Grade-A-Gator, you will have the UFID. But if you are going to re-import this spreadsheet back into Gradebook 2, you will need to delete the UFID column. That column will not import.

Gradebook 2: Change the Letter Grade Scale

It is recommended that you change the Letter Grade Scale in <a href="Gradebook#Change_the_Letter_Grade_Scale_in_Gradebook"> Gradebook</a>. 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.

Prepare Grades for Submission to Grade-A-Gator

If any of the Course Grades have three asterisks beside them, for example, "B (87.2%)***" that means that all data is not available for that grade. If a student doesn't have a grade in at least one column, you will see the three asterisks. You will need to add zeros to the empty cells:

  1. Double-click on the name of the column in the left pane.
  2. In the right pane, check the box beside "Give ungraded no credit."
  3. Click Save
  4. Continue until all columns have zeros inserted. Click Save/Close

You have the option to override any grade. If there is a final grade that you want to change before exporting the grades, you may do that. In the Gradebook 2 left pane:

  1. Click the "Attributes and Grades" tab
  2. Make sure the check box is checked beside "Course Grade" and "Grade Override."
  3. In the right pane, those columns appear beside the student names. In the Grade Override column, enter the grade you want to give the student(s). In the "Course Grade" column, the calculate percentage will change to say "override."

NOTE: You cannot use this process to change an "F" to an "E" or an "I" as those are not valid grades in the system. You can only change the letter grade to another valid letter grade; A+, A, A-, B+, B, B-, C+, C, C-, D+, D, D-, F.

You are now ready to download the grades. NOTE: This tutorial is being edited to address the lack of section numbers. We will be issuing a corrected tutorial within hours. 12162010, 10am.

  1. At the top of the Gradebook 2 screen, click Tools > Export > Only Grades > as Excel 97/2000/XP (.xls)
  2. The file will be downloaded to your computer. Open the file. Delete all the columns except "Student ID," "UFID," "Student Name," and "Course Grade." To remove the calculated percentage from the letter grade column (these instructions are for Office 2007):
<img src="/lssmw-faq/images/2/2c/Gradebook2_Excel_Replace.PNG" _fck_mw_filename="Gradebook2 Excel Replace.PNG" alt="" />
    1. Select Ctrl-F and enter (* in the Find field. Leave the Replace field blank.
    2. Click Replace All. Every student's course grade will have the percentage removed.
    3. Change any grade of "F" to an "I" or an "E."


We will now add the Section Number. The first column in your spreadsheet is the Student ID (gatorlink username) which is not needed.

  1. Click in the cell that contains the first student's gatorlink username, and change it to the section number.
  2. Click the lower right corner of that cell and drag it down the column to replace all the gatorlink usernames with the Section Number.


We will now add a column to contain the Credit Hours.

  1. Insert a column between the Student Name and the Course Grade.
  2. In the first cell of this column, enter the Credit Hours.
  3. Click the lower right corner of that cell and drag it down the column to enter the Credit Hours in all the cells.


  1. Remove the headings from the first row of the spreadsheet. Columns should be in this order:
    1. Section
    2. UFID
    3. Last Name, First Name
    4. Credit Hours
    5. Grades
  2. 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.

Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox