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. Click on My Courses option located in the Navigation block.
  2. Click on the course you wish to work with.

  1. Locate the Administration block.
  2. Click on the Grades option.

  1. Click on the Export option.

  1. Click on the Excel Spreadsheet option.

  1. Click on the Submit button.

  1. In the small window that appears, Click on the Download button.

  1. On the box that appears, Click on the OK button to open the blank Gradebook.

The blank Gradebook should open automatically for you.

Save Your Excel file as a CSV File

  1. Open the Excel file you would like to import into Moodle.
  2. Click on the File tab located at the top of the tool bar.
  3. Click on the Save As option.

A new window will appear to give you options for saving your Excel sheet.

  1. Locate the Save As Type dropdown menu.

Note: The Save As Type dropdown menu is located below the file name dropdown menu and is the second dropdown menu under the Documents Library box.

  1. Select the CSV (Comma delimited) option.
  2. Click the Save button.
  3. Click the Yes button.

 

Importing a CSV File into Moodle ISU Gradebook

  1. Click on My Courses option located in the Navigation block.
  2. Click on the course you wish to work with.

  1. In the Administration block click on the Grades options.

  1. Click on the Import option.

  1. Click on the CSV File option.

  1. Click on the Choose a File…button located on the main work screen.

A new window will open called the File Picker.

  1. Click on the Upload a File option with your mouse.

  1. Click on the Browse button.
  2. Double Click the file that you wish to upload from your computer.  Once you have selected the file it will automatically appear in the Attachment text box on the File Picker screen.
  3. Click on the Upload This File button located as the last option in work screen area.

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

  1. Do not change any of the other available options on the screen.
  2. Click on the Upload Grades button.

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 locate the Identify User By box.
  2. Select from the following options.
  1. Map from ID number: The Excel file will match with the Bengal ID number that you have for a specific student.
  2. Map to ID number: refers to the students Bengal ID number.

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 student’s scores will not come in correctly or could potentially be placed in the wrong sections.  We strongly advise exporting first from Moodle ISU.

  1. Locate the Grade Item Mappings box.
  2. From the dropdown menu Select one of the following to best match your needs:

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

  1. Click the Upload Grades button to continue.

  1. Once the grades have been imported successfully, Click the Continue button. 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 please visit http://docs.moodle.org/25/en/Grade_import


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.