Contact The CCI Helpdesk

Bb Learn Tests -- Submission Dates and Times and Test Time Duration Gathering

Introduction and Method 1 -- Download Grade History for a Test as CSV or tab-delimited text file to open in Excel

Note 1: Test duration (how long it took the student to take the test) is not included with this method.

Note 2: With this method, different events in the history of a single attempt (or submission) are recorded in multiple different lines.

  • Examples:
  • "Attempt submitted (needs grading)" in a row indicates when a student submitted the test. An attempt is a submission.
  • "Attempt Grade #" in a row indicates when a student's test submission was graded, as well as the grade entered.
  • "Attempt marked as Not Ignored #"  in a row indicates when a student's test submission was graded, as well as the grade entered. The submission might have been set to be "Ignored" previously or not.
  • "Attempt Grade #" in a row with text in the "Comments" column when instructor or course assistant feedback comments were added.
  • "Override Grade #" in a row indicates when a grade was entered for a student's test that overrides other grades, as well as the grade entered.
  • "Attempt Grade Cleared" in a row indicates that a student's graded test submission was reverted back to a "need grading" or null state.
  • "Override Grade Cleared" in a row indicates that a student's overriding test grade was reverted back to a "need grading" or null state.

Here's how to use this method:

  1. Enter "Full Grade Center" in the Bb Learn course shell.
  2. Click the circled down arrow in the test's column header.
  3. Click "View Grade History."
  4. Click drop-down menu next to "Go" button, and select "All."
  5. Click "Go" button.
  6. Click "Download."
  7. Choose "Delimiter Type."
       (a) Choose "Comma" if you're not sure.
  8. Select "No" to not include "Comments."
       (a) Unless you want "Comments."
       (b) Attached or embedded files are not included.
  9. Click "Submit."
  10. Click "DOWNLOAD."
       (a) The file will be downloaded to your computer to your downloads folder.
  11. With "Tab" files, when opening the file, click "Yes" to confirm it is okay to open the file in Excel or another spreadsheet program.


Method 2 -- Manually Copy from View All Attempts to a Good Plain Text Editor and then to a Spreadsheet

Windows 7, 8, 8.1, 10

  1. If "Notepad++" is not installed on your Windows computer, visit the webpage below, download, and install it.
       (a) "Notepad++" is different, and vastly better, than the pre-installed "Notepad" on Windows computers.
       (b) https://notepad-plus-plus.org/ 
                i.  Click the "Download" link and follow the onscreen instructions.
       (c) If you need help, contact us.
  2. Enter "Full Grade Center" in the Bb Learn course shell.
  3. Click the circled down arrow in the test's column header.
  4. Click "View All Attempts."
  5. Click the "Show All" button at the bottom of the "View All Attempts" webpage.
  6. Open a new "Notepad++" document or file.
  7. On the Bb Learn "View All Attempts" webpage, highlight all the text on the page.
       (a) Simultaneously press "Control" and "a" on the keyboard.
       (b) Or use your mouse to just highlight the data you need.
  8. Copy/paste the highlighted text into the "Notepad++" file.
  9. (OPTIONAL) Delete the rows or lines you don't need.
  10. Highlight all the text in the "Notepad++" file.
  11. Copy/paste from the "Notepad++" file to a new Excel spreadsheet.
  12. Delete rows and columns that are not needed.
  13. Widen columns if date information appears like "##########".
  14. Save the Excel spreadsheet.

Mac

  1. Enter "Full Grade Center" in the Bb Learn course shell.
  2. Click the circled down arrow in the test's column header.
  3. Click "View All Attempts."
  4. Click the "Show All" button at the bottom of the "View All Attempts" webpage.
  5. Open a new "TextEdit" document or file.
       (a) "TextEdit" is an application or program pre-installed on Macs and can be found with all the other "Applications."
       (b) Click "New Document" if prompted, or click "File" and then "New" to create a new file.
  6. Click "Format" and select "Make Plain Text."
  7. Click "OK" to confirm converting document to plain text.
  8. On the Bb Learn "View All Attempts" webpage, highlight all the text on the page.
       (a) Simultaneously press "command" and "a" on the keyboard.
       (b) Or simultaneously press ⌘ and "a" on the keyboard.
       (c) Or use your mouse to just highlight the data you need.
  9. Copy/paste the highlighted text into the "TextEdit" file.
  10. (OPTIONAL) Delete the rows or lines you don't need.
  11. Highlight all the text in the "TextEdit" file.
  12. Copy/paste from the "TextEdit" file to a new Excel spreadsheet.
  13. Delete rows and columns that are not needed.
  14. Widen columns if date information appears like "##########".
  15. Save the Excel spreadsheet.

Linux Ubuntu 16.04 LTS (may work with other Linux OS variants as well)

  1. Enter "Full Grade Center" in the Bb Learn course shell in the Firefox internet browser.
  2. Click the circled down arrow in the test's column header.
  3. Click "View All Attempts."
  4. Click the "Show All" button at the bottom of the "View All Attempts" webpage.
  5. Highlight all the text on the page (simultaneously press "Control" and "a" on a Windows/Linux computer keyboard).
       (a) Or use your mouse to just highlight the data you need.
  6. Copy/paste the highlighted text into a new "gedit" text editor file.
  7. Highlight all the text in the "gedit" file.
  8. Copy/paste from the "gedit" file to a new LibreOffice Calc spreadsheet.
  9. Uncheck "Detect Special Numbers."
  10. Change the "Character set" (encoding) if you want.
  11. Click "OK."
  12. Remove the rows you don't need.
  13. Save the LibreOffice Calc spreadsheet.


Including Section Numbers

Here is how to include section numbers with submission dates and/or test time durations.

  1. Use one of the above methods to create a submission date and/or duration spreadsheet.
  2. Use the general instructions at the webpage below to download the entire "Full Grade Center" table from your Bb Learn course shell.
       (a) Bb Learn Grade Center -- Downloading
  3. Open the downloaded "Full Grade Center" table in Excel (or another spreadsheet application).
  4. Remove all columns from the downloaded "Full Grade Center" table except for the following:
       (a) Last Name
       (b) First Name
       (c) [column with section numbers]
                i.  If you need help generating such a column, and you working in a cross-listed course, see the webpage below. 
                       1.  COMING SOON! 
  5. Sort the "Full Grade Center" spreadsheet by first name.
  6. (IF METHOD 1 ABOVE USED) Remove duplicates entries from the "Full Grade Center" spreadsheet so each student is only on 1 row.
       (a) Keep the final grade entered entries for each student.
  7. Sort your submission date and/or duration spreadsheet by both the first name and last name columns. Prioritize sorting by first name.
       (a) See the webpage below for how to sort by multiple columns in Excel.
       (b) https://support.office.com/en-us/article/Sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654?ui=en-US&rs=en-US&ad=US#__toc246836976
  8. Copy the sorted section number column from the "Full Grade Center" spreadsheet
  9. Paste the sorted section number column to your submission date and/or duration spreadsheet.
  10. Check that the first and last student on the submission date and/or duration spreadsheet have the correct section number listed.
  11. Spot check the section number listing for 2-4 or so other students from different parts of the submission date and/or duration spreadsheet.
CCI Support Site