Difference between revisions of "Get student name, submit date/time, and test score"

From DurhamtechWiki
Jump to navigationJump to search
 
 
(11 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
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):
 
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'''
+
# In Firefox: In your class, go to '''Tests & Quizzes'''
−
2) Click on the '''Published Copies''' tab
+
# Beside the published test name (such as pre-test), in the drop box, click on '''Scores'''
−
3) Beside the test name (such as pre-test), in the drop box, click on '''Scores'''
+
# On the Total Scores page:
−
4) On the Total Scores page:
+
#* Starting with the first name, drag your cursor to highlight all students and their scores;
−
  a) ''Starting with the Name column'', '''drag your cursor''' ''across to the final score column and drag down to the last student name/score'';
+
#* Right-click on the selected area and choose copy  
−
  b) '''Right-click''' on the ''selected area'';
+
# In a spreadsheet: Paste without formatting (or choose Paste Special, then choose Text only).  
−
  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.
+
''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.
−
 
−
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.
 

Latest revision as of 11:26, 8 May 2019

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. Beside the published test name (such as pre-test), in the drop box, click on Scores
  3. On the Total Scores page:
    • Starting with the first name, drag your cursor to highlight all students and their scores;
    • Right-click on the selected area and choose copy
  4. In a spreadsheet: Paste without formatting (or choose Paste Special, then choose Text only).

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.

Retrieved from "https://wiki.durhamtech.edu/wiki/index.php?title=Get_student_name,_submit_date/time,_and_test_score&oldid=18122"