Below you will see the merged data, containing Usernames and their scores on this test.
Click Copy Merged Data to Clipboard below to copy the data. Go to Microsoft Excel, create a new spreadsheet, and paste the data into the first row and column in the spreadsheet. Next, go to the File menu and select Save As. For the File Name, enter something unique, and be sure to remember where you are saving the file. Next to Save as type, select "CSV (Comma Delimited)", and click Save. Excel will warn you that not all features are supported (such as multiple workbooks and formatting). This is perfectly fine for our purposes, so click OK/Yes to the windows that pop up.
Once you have saved the file, continue using the instructions on Using Excel to Manage Grades in Ted.
External Grades for Students Not in Gradebook
You will also see a list of scores that could not be matched to a student. You will need to
add their scores to Ted manually, if any. Many of these students may have simply filled out
their student ID incorrectly on the scantron or clicker.
If not, however, they may be students who either added to the class late, or who are
wait-listed, auditing, or concurrently enrolled and need an 'Add Computing' slip. Please refer to your Ted
Class Setup notice or email email@example.com for instructions on adding these
students to Ted.
Gradebook names not found in External Grades
Last is a list of students in Ted's gradebook, for whom no grade was found in the External Gradebook. These students either did not fill out the scantron/clicker correctly, or did not take the test (students who dropped, for instance).