TLTC ANGEL Gradebook

Initial Setup

When you first enter a course's gradebook (under the Tools tab) you will encounter a wizard.

  1. Step 1 You are given the option to choose between Points or Percentage grading types. You can also add more categories and slightly alter their calculation type.
  2. Step 2 If you already have assignments made in your course, you are given the option of importing them into the gradebook right away. Check the box next to the ones you want to have the automatically appear in the gradebook.
  3. Step 3 You can enter your grading scale by putting the letter grade on the left and the corresponding minimum percentage on the right.
Note: All of the items in this setup wizard can be changed at any point.

Setting Up the Gradebook

  1. To set up the Gradebook manually, go to the Tools tab and choose Gradebook.
  2. On the Gradebook page you will see ways to view, add/edit grades, and setup grades.
  3. First you will want to click on Preferences under Grade Setup.
  4. To set how your grades will be displayed click on the drop down menu next to Default Display Format.
  5. You should also choose either Points or Percentage for the Gradebook Mode. If you would like to weight categories, choose Percentage mode. When you choose this mode, you will be required to enter a weight for each categories. Categories will be set up in the next step. If you choose Points mode you will not be able to weight categories.
  6. The Overall Display Format will determine how the score in the Overall column will be displayed. You can have you the overall score display as a percentage, a point value, a letter grade or a combination of any two options.

Adding Categories

You may want to add categories to separate different types of assignments. Categories that may be helpful to have are Tests, Quizzes, Daily Assignments, Projects and others.

  1. Click on Categories under the Gradebook Management section to set up categories within the gradebook.
  2. By default there will be one category. Click Add Category to add a new category.
  3. Choose a title and calculation type. You do not have to type a description if you do not wish to.
  4. When you are done, click Save.
  5. To edit an existing category, check the box next to its title and choose Edit Selected. Choose the settings you want and click Save.

How do I rearrange categories?

  1. Once in the Gradebook under Tools, click the Categories link at the top of the right column.
  2. Select the appropriate category that you would like to move by placing a checkmark in the box to the left of it.
  3. The buttons along the bottom will become available. Click the Show Tasks button.
  4. After the page refreshes, a list of tasks will show up below the buttons. Click the link to Move Up or Move Down.
  5. When you have the categories in the correct order, click the Save button.

Add and Edit Assignments

  1. On the main Gradebook page, click Assignments under Gradebook Management.
  2. Click Add New.
  3. Give the assignment a title. You may also type a description if you wish.
  4. If you have categories set up, click on the Categories drop down menu and choose the category that you want the assignment to be in.
  5. Assign a number of points.
  6. When you first set up the Gradebook you set up the Default Display Format for the entire gradebook. The Display Format in the assignments set up will default to the format you have previously set up. You may change the format if you wish for this particular gradebook item.
  7. Select the calculation type by clicking on the drop down menu. See the "Grading by Item" helpguide for more information on calculation types.
  8. Click Save.
  9. To edit an existing assignment, check the box next to its title and choose Edit Selected. Choose the settings you want and click Save.

How do I rearrange assignments?

Please keep in mind that in ANGEL, you will rearrange items within a particular category to change the order that they display.

  1. Once in the Gradebook under Tools, click the Categories link at the top of the right column.
  2. Select the appropriate category that has the out-of-place assignment by placing a checkmark in the box to the left of it.
  3. Then the buttons along the bottom will become available. Click the Show Tasks button.
  4. After the page refreshes, a list of tasks will show up below the buttons. Click the link to Reorder Assignments.
  5. Then select (highlight) the assignment you want to move and use the buttons on the right (Top, Up, Down, Bottom).
  6. When you have the assignments in the correct order, click the Save button.

Extra Credit

The Gradebook allows categories and assignments to be set up for extra credit. In ANGEL, an extra credit assignment will only positively affect a student's grade. If a student does not receive points for an extra credit assignment or category, it will not negatively affect their grade. To set an assignment as Extra Credit, go to the Tools tab and then click on Gradebook. Choose Categories or Assignments.

If you choose Categories, all items in the category you select will be set as extra credit.

  1. Check the box next to the category you want to be extra credit, then click the Edit Selected button.
  2. In the options that come up, check the box next to Extra Credit. To give an individual item extra credit, edit the item under Assignments.
  3. When you are done click Save.

By choosing Assignments, you will be able to give credit to individual items.

  1. Check the box next to the assignment you want to be extra credit, then click the Edit Selected button.
  2. In the options that come up at check the box next to Extra Credit.
  3. When you are done click Save.

Checking Student Grades

The Gradebook can be used to quickly access all the course grades.

  1. To access the Course Gradebook, click the Tools tab at the top of the window.
  2. Under the Course Management section, select Gradebook.

Viewing Grades

  1. To view all your course grades for every assignment and all students, click the View All Grades link at the top of the main Gradebook menu.
  2. Or you can view grades based on the category by selecting All Categories from drop-down menu.
  3. You can further narrow down the category view by a particular team or an individual student. Use the Users drop-down menu to select the person/team and click the Go button.

Adjusting the View

  1. If you chose to View All Grades you can narrow down the view by teams using the Show drop-down menu at the top.
  2. To view and/or edit the grades of a particular student for all of the assignments, click that student's name (under the Username column).
  3. The columns for category averages will be in blue columns. The individual assignments will be in white columns
  4. You can resize the columns, just like in Excel, by clicking on the border and dragging it to the desired size.
  5. Clicking on a column heading will resort the entire gradebook either ascending or descending.

Grading Assignments 

  1. Enter a percentage or number of points in the corresponding column. You can enter a percentage or points, and ANGEL will auto-calculate automatically for you.

    Note In the dropdown list, categories are not indented and assignments are indented under the appropriate category. You will not have the option to grade a category; you must select an assignment to grade

    To grade assignments in the Gradebook, go to the Gradebook's main menu. Under the Enter/Edit Grades section, choose either By Assignment or By User
  2. Then select either the assignment or the student, depending on the method you chose and click Go.
  3. When you have finished entering all the grades (and Comments), click the Save Changes button.
  4. To return to the main menu, click the Done button in the bottom–left corner.
Note: When grades are added through the Gradebook, by default they will automatically become locked and you can only make additional changes by returning to the gradebook. If you add a grade through the Gradebook and it's locked, you must go back through the gradebook to edit the grade; if you change the grade through the utilities menu of that item, it will not be transferred to the Gradebook if it is marked as locked. Please review the "Grading by Item" helpguide for more information.

Exporting and Importing the Gradebook

You can export your Angel Gradebook(s), add/edit grades, and then import them back into your course(s). Exporting the Gradebook can be beneficial for a number of reasons:

  • Create a backup or save a copy to your hard drive for quick reference.
  • Add grades more quickly – add grades for multiple assignments and multiple students at the same time.
  • More flexibility – you can work offline.

Exporting the Gradebook

  1. Go to the Gradebook and scroll down to the Gradebook Setup section.
  2. Select Export Grades.
  3. Select the format type: either comma or Tab separated.
  4. If you would like to export the averages and course ID, place a checkmark next to the option(s). To keep your gradebooks straight, it's always a good idea to export the Course ID.
  5. Choose either percentage or points as the format for grades and then click the Export button.
Note: Microsoft Excel will be able to open both comma and tab separated files. However, if your assignment titles have commas in them, you will need to use the tab separation. For example, if the assignment title is "Chapter 1, Question 1" the comma will cause it to be split into two separate columns, thereby messing up the gradebook.
  1. In the File Download window that pops up, click Save. Browse for and select an appropriate location and then click the Save button.

The gradebook file will be downloaded to the location you specified. If you chose Comma Separated, the file will be named gradebook.csv. If you chose Tab Separated, the file will be named gradebook.tsv.

Opening and Editing the Gradebook File

If you saved the file as Comma Separated (*.csv), you will be able to open the file normally. If you saved the file as Tab Separated (*.tsv) you will first need to open Microsoft Excel.

  1. Once Excel is open, go to the File menu, then Open.
  2. In the Files of type drop–down menu, select All Files.
  3. Find the file you downloaded, select it, and click the Open button.
  4. If you chose Tab Separated, the Text Import Wizard will pop up (comma separated files will automatically open).
    1. Leave the default settings for the first screen and click Next.
    2. Make sure Tab is selected as the delimiter and click Next.
    3. Click Finish.

All of the assignments will be listed in columns, with the students' names in the first column of each row. Simply add or edit the grades in the appropriate row/column/cell. Make sure you save any changes you make to the file.

Importing the Gradebook

    1. Go to the Gradebook and scroll down to the Gradebook Setup section.
    2. Select Import Grades.
    3. Browse for and select the appropriate file.
    4. Select the appropriate Delimiter (Comma or Tab, depending upon the format you downloaded the file as), and click Next.
    5. The columns with assignments will automatically be setup to import; if you do not want to import some of them, select (Skip) from the drop-down menu for that column.

Note: Column A in Excel corresponds with Column 0 in Angel.

  1. When you have finished mapping the columns/assignments, scroll to the bottom. For the Treat Values as option, make sure you select the correct option (Percentages or Points), corresponding with how you exported the original file from Angel.
  2. Uncheck the box next to Lock Imported Grades and then click the Finish button.

The grades will then be imported into the Gradebook.