Often instructors or TAs have need to use an external editor to manage their students’ grades, such as Microsoft Excel. This instruction sheet will assist TAs and professors in:
The advantages to managing grades in this fashion include:
To manage Ted grades in Excel, you should first download a spreadsheet from the class's Grade Center. This will give you a spreadsheet that is properly formatted to copy grades back in to Ted's Grade Book.
Go to your class's Full Grade Center by clicking the arrows that follow Grade Center in the Control Panel.
From the Work Offline button above the right side of the gradebook, select Download.
Ted presents you with a number of options for how to download the spreadsheet. Under Data, you can Select [which] Data to Download. If you plan to use or enter many grades in Excel, select Full Grade Center. If you will only be adding new columns, select User Information Only.
The other options you may leave unchanged, unless you have your own reasons for changing any of them. ClickSubmit to continue.
Ted will then package your gradebook into a file, and present a Download button; click it to download your gradebook.
The current version of Ted contains a bug: The first cell of the spreadsheet may show ï»¿"Last Name" when you open it. If that is the case, clear the cell's contents and enter just Last Name before you upload your scores to Ted.
Internet Explorer and Firefox will ask what you want to do with this file. Save the file somewhere you can easily access, such as your Desktop or a folder you use for other class files.
The first five columns of the gradebook are "Information Columns" - that is, information about each student in your class. These are read-only, and if you make changes, they will be ignored. Do not change or delete the Username column. You may remove the other columns ('Last Name','First Name','Student ID', or 'Last Access') if it is convenient for your purposes, but the Username column must be present and must appear before any "Grade" columns.
"Grade" columns, in this case, are any columns in the spreadsheet besides those five "Information" columns. Any grade columns you download from Ted will include two pieces of information: The column's name in Ted, and a number unique to each column in Ted. For example, "Midterm 1" will show up as "Midterm 1|4847".
You may remove any columns you will not be managing in Excel - these columns will simply not be updated when you upload your spreadsheet. This will ensure that you do not make any unintended changes to those columns, and will remove distracting information from your view as you make your changes.
To add a new grade column, simply enter a name for the grade column in the first row, in the column following the rightmost grade in the spreadsheet. Enter your students' scores in that column.
When you are finished, save your changes by going to the File menu and selecting Save. Excel will warn you that the workbook contains features that will not work or may be removed if you save it in the selected file format. ClickYes/Continue to keep the workbook in this format. You can then close the workbook or quit Excel. (Excel will ask you again if you want to save your changes, even if you didn't make any. Click No.)
Return to the Full Grade Center for your class. From the Work Offline button above the right side of the gradebook, select Upload.
Next to the upload field labeled Attach Local File, click Browse (in Safari, Choose File), and choose the file you saved containing your grades. Click Submit to continue.
The Confirmation page will show the columns being imported, and note if anything was changed for each column. In the example below, the Messages column notes when there are "No Data Updates", if it will "Add Column" or "Update Name", and that it will not make any changes to calculated columns. The columns that have changes will show the new scores for each student in that column for you to review.
The Upload column contains a checkbox for each row. If any of the messages indicates a change that you do not want, uncheck this box to skip that column.
Click Submit to continue.
Ted will return to the Full Grade Center, and display a note summarizing the changes made to the gradebook, including the number of columns uploaded and a list of the changed and added columns.
Grades are available to students immediately, but are not immediately included in point totals and weighted columns. If you only need students to see the scores you have uploaded, and do not need to include them in later calculations, you are finished!
First, some background. For every column, Ted tracks the Points Possible for that column. That allows Ted to convert a score in that column to a percentage, or to a Letter Grade. It also allows a score to accurately reflect its contribution to Total or Weighted Total columns.
However, when you upload a new column, its data is considered "Text", not a numeric Score. Since you cannot perform math on text, it cannot be included in any further calculations. By changing the column to display something besides "Text", you are telling Ted to convert that text into a numeric Score, which may then be used for further calculations.
Ted can also display Scores as a Letter Grade. It maintains one or more Grading Schemas - that is, a table that lists which scores correspond to which grades, and vice versa. It contains one built-in Grading Schema called Letter. You will see this listed when you decide how to display the column.
From the button's drop-down menu in the column header, select Edit Column Information.
In the Column Information section, change the following fields:
Click Submit to continue.
Ted will warn you that When converting text columns, all numeric values will be treated as a score out of the defined points possible and used to translate the value to other display options. Values that cannot be converted to the selected type will display as zero after the conversion. Continue? Click OK.
You are finished (phew)! The grades are now available to students and displayed as you like.
If you have any questions with this process please feel free to email IWDC at firstname.lastname@example.org, or call 858.822.3315.