Gradebook: Importing an Excel (CSV) File Moodle ISU


Introduction

There are a variety of reasons that you may want to import a file into your Moodle ISU gradebook.  For example, it might be easier to input and track your grades in Excel, you may need to include grades from an external system in your Moodle ISU gradebook, or you may need to move grades from one course (such as a lab section) to another.

This guide will help you to:

Export a Blank Gradebook Template from Moodle ISU

If you would rather calculate your grades in Excel and import them into Moodle ISU, it is advisable that you first export a blank gradebook from Moodle ISU, so your spreadsheet will import easily.

  1. In the upper left hand corner expand the Navigation drawer (the white icon with three black horizontal lines), Click Grades.

  1. In the top right hand corner expand the Grader report dropdown menu, Scroll down nearly to the bottom and select the Excel spreadsheet export option.

Note: You can also access the Import option from the Grader report dropdown menu.

  1. In the Grade items to be included section, you can select or deselect the items to be included in the export.

Note: At the end of the section, You can also Click Select all/none to select all categories to be exported.

  1. Click Download.

  1. In the pop-up window that appears, Select Save File.
  2. Click OK.

Save File.jpg

  1. Save your file to a location you will remember so that it will be easier to find.

Note: Remember to input your grades into this saved version so that your grades will be up to date when you import.

Save Your Excel File as a .CSV File

Saving the file as a .csv (comma separated values) allows the data within to be saved in a table structure format. The file must be saved as a .csv in order for the grades to import correctly into Moodle ISU.

  1. Open the Excel file you would like to import into Moodle.
  2. Click Enable Editing, if needed.
  3. In the right hand corner of the Excel document, Click File.

file.jpg

  1. Click Save As.

save as.jpg

  1. Choose where on your computer you would like to save the file.
  1. Locate the Save as type dropdown menu.

Save as CSV.jpg

Note: The Save as type dropdown menu is located below the File name dropdown menu.

  1. Select CSV (Comma delimited)(*.csv).
  2. Click Save.
  3. When asked if you want to keep the workbook in this format, Click Yes.

Click Yes.jpg

Import File into Moodle ISU

  1. In the upper left hand corner expand the Navigation drawer (the white icon with three black horizontal lines), Click Grades.

  1. In the top right hand corner expand the Grader report dropdown menu, Scroll down nearly to the bottom and select Select CSV file under Import.

  1. Click CSV file.
  1. Click Choose a file.
  1. You can also drag and drop the file into the boxed area.

Note: A new window will open called the File picker.

  1. Click Browse.
  2. Select the file that you wish to upload from your computer.  
  3. Click Open.
  1. Once you have selected the file, it will automatically appear in the Attachment text box in the File picker.
  1. Click Upload this file  located as the last option in work screen area.

Note: You will be taken back to the Moodle ISU work screen. The file you have selected will be shown under the Choose a file.

  1. Do not change any of the other available options on the screen. The defaults are:
  1. Encoding is set to UTF-8.
  2. Separator is set to Comma.
  3. Verbose scales is set to yes.
  4. Previous rows is set to 10.
  5. Force import is unchecked, however you can select this option if you updated the grades after the import file was exported.
  1. Make sure the Encoding option is UTF-8.
  2. Click Upload grades.

Note: You will be taken to a preview of the file you are about to upload.  This is to help you match up the scores with the information in Moodle ISU.

  1. If you first exported a blank spreadsheet:
  1. Scroll down to the Identify user by section.
  2. Select from the following options:
  1. Map from: The Excel file will match with the selection you choose from the drop down menu.
  2. Map to: This must match the selection you made in the Map from section.

Note: If you created your own spreadsheet, you will need to choose which two columns to map the information.  If there are any typos, name changes, or other inexact matching, the students’ scores will not come in correctly or could potentially be placed in the wrong sections. We strongly advise exporting first from Moodle ISU.

  1. In the Grade item mappings section you will select which grade items will be pulled into Moodle.  Your spreadsheet items are listed on the left with the items in Moodle ISU in the dropdown menu.
  2. From the dropdown menu, Select one of the following for each of the columns you are importing:
  1. Ignore: If you do not want to pull that item from your spreadsheet into Moodle ISU.
  2. New grade item: If a grade item does not currently exist in the Moodle ISU Gradebook.
  3. Select a specific item under the Grade items list in the dropdown menu to put the grades in your spreadsheet into the selected column in Moodle ISU. For example: Quiz (spreadsheet list) - Quiz Sample (dropdown menu list).
  4. Select a specific item under the Feedbacks list in the dropdown menu to pull the feedback from your spreadsheet into the selected column in Moodle ISU. For example: Feedback on Assignment 3 (spreadsheet list) - Feedback for Assignment 3 (dropdown menu list).

Note: Do not map any of the fields that contain student identifying information such as name or email.

  1. Click Upload grades to continue.

  1. Once the grades have been imported successfully, Click Continue.
  2. You will be taken back to the Grader report. Any new grade items created will be added to the end of your Moodle ISU Gradebook.

For more information, see Grade Import

For additional information, contact the ITRC - (208) 282-5880 or email itrc@isu.edu


This work was done by Instructional Technology Resource Center at Idaho State University and is licensed under the Creative Commons Unported License. To view a copy of this license, visit Attribution Noncommercial 3.0 United States or send a letter to Creative Commons, 444 Castro Street, Suite 900, Mountain View, California, 94041, USA.