Get student name, submit date/time, and test score

For each test, to get the student name, date/time submitted, and score, do the following (exports do not include date/times tests were submitted):

1) In Firefox: In your class, go to Tests & Quizzes 2) Click on the Published Copies tab 3) Beside the test name (such as pre-test), in the drop box, click on Scores 4) On the Total Scores page:

  a) Starting with the Name column, drag your cursor across to the final score column and drag down to the last student name/score;
  b) Right-click on the selected area; 
  c) Left-click on copy

5) In a spreadsheet: Left-click and click on Paste.

Note: You’ll probably have to copy and paste (using "values only") in another spread sheet for the names, so you can sort the names and can get rid of the email links. Then you can do a regular copy and paste of the submit date/time and final score into the new spreadsheet.

6) If needed: Repeat steps 1-5 for the other test (such as post-test or final test). You can calculate the time elapsed between the pre- and post/final tests.

FYI: On the Total Scores page, you can click on any column title, such as final score, to sort the data and see who has submitted and completed the tests and who hasn't.