LSU College of Science
LSU  | Mathematics

How to transfer scores to Moodle

MyMathLab

  1. In MyMathLab, go to Course Tools, then Gradebook.
  2. In the Export Data menu, choose Quick Export.
  3. Select assignments to export, then click Download Data.
  4. Right-click on the link that appears, and choose "Save Target (link) As...". Save to your desktop. Filename must contain no spaces and end in ".csv".
  5. In Moodle, go to Grades.
  6. From the drop-down menu near the middle by the top of the page, choose "Selective import... Pearson file".
  7. Upload your file.
  8. Use Moodle's grade mapping options to map the data appropriately, then click Map Graded Items.
  9. Once the grades are in Moodle, be sure to go back and delete the file you just created on your desktop, and empty your trash. (This important step is necessary to comply with FERPA, in case your computer is ever compromised.)

WebAssign

  1. In WebAssign, click Class View, then Scores for the appropriate assessment.
  2. Once the score spreadsheet opens, click Downloads.
  3. In the resulting pop-up window, change the File Extension (in the drop down) from XLS to TXT, and click Download.
  4. When the scores show up, select all the text and copy to your clipboard.
    (To accomplish this, go to the Edit menu and use Select All followed by Copy; or, right-click on the text and choose Select All followed by Copy; or, use the standard keyboard shortcuts, typically ctrl-A followed by ctrl-C.)
  5. Paste the scores into our score converter. The converted student IDs and scores appear instantly at the bottom.
    (Adjust the Options and Score Conversion settings to meet your needs. Click the little triangle next to the Processing Log to reveal additional details on what is happening.)
  6. Copy the Moodle-formatted results from the score converter to your clipboard.
  7. Since Moodle currently refuses to accept pasted data, you'll need to temporarily put the results into a file:
    1. On your computer, open a plain text editor (e.g., Notepad, or TextEdit).
    2. Paste the results from the score converter.  ( If using TextEdit on a Mac, select "Format -> Convert to Plain Text"  before saving the file )
    3. Save to your desktop.
    4. In Moodle, go to Grades.
    5. From the drop-down menu near the middle by the top of the page, choose "Selective import... Smart file".
    6. Upload your file by dropping it into the box or by browsing for it.
    7. You might receive a list of student IDs that are in WebAssign but don't match anything in Moodle. These are either students who dropped (thus no longer appear in Moodle but still appear in WebAssign) or students who self-enrolled in WebAssign but didn't enter a correct student ID. You'll have to identify the nature of each issue on a per-student basis by consulting the roster listing in Moodle and the Processing Log in our score converter (which reports invalid or missing IDs). In WebAssign you can edit students to fix incorrect or missing IDs, or remove dropped students. After making corrections, start over at step 1: download a new set of grades, and so on, and keep fixing student records, until Moodle accepts your grades without error.
    8. Once the grades are in Moodle, be sure to go back and delete the file you just created on your desktop, and empty your trash. (This important step is necessary to comply with FERPA, in case your computer is ever compromised.)

WeBWorK

  1. In WeBWorK, use Scoring Tools to create scores (which are then stored in a CSV file within WeBWorK).
  2. Still within WeBWorK, go to the File Manager, go up to the root directory, then down to the "scores" subdirectory, find your CSV file, and choose "Edit".
  3. Click in the edit text box, then Select All and Copy. The WeBWorK scores are now on the clipboard.
  4. Close the WeBWorK file editor screen by hitting the Cancel button.
  5. Paste the scores into our score converter. The converted student IDs and scores appear instantly at the bottom.
    (Adjust the Options and Score Conversion settings to meet your needs. Click the little triangle next to the Processing Log to reveal additional details on what is happening.)
  6. Copy the Moodle-formatted results from the score converter to your clipboard.
  7. Since Moodle currently refuses to accept pasted data, you'll need to temporarily put the results into a file:
    1. On your computer, open a plain text editor (e.g., Notepad).
    2. Paste the results from the score converter.
    3. Save to your desktop.
    4. In Moodle, go to Grades.
    5. From the drop-down menu near the middle by the top of the page, choose "Selective import... Smart file".
    6. Upload your file by dropping it into the box or by browsing for it.
    7. Once the grades are in Moodle, be sure to go back and delete the file you just created on your desktop, and empty your trash. (This important step is necessary to comply with FERPA, in case your computer is ever compromised.)