Skip to main content
UNSW Sydney Logo
Teaching
Mobile search
mobile nav menu button
  • About
  • Teaching
    • New to teaching
    • Educational design
    • Assessment and feedback
    • Evaluating education
    • More...
  • Educational Technology
    • Support
    • Training
    • TELT Administrator
  • Events & News
    • Upcoming events
    • Recent news
    • Event recordings & resources
    • Subscribe to education news
  • Awards
    • Awards
    • Fellowships
    • Gathering evidence of your teaching practice
  • Professional Development
    • Beginning to Teach (BTT)
    • Teaching Accelerator Program
    • Foundations of L&T (FULT)
    • Course Design Institute (CDI)
    • Self-paced learning
    • Academic Mentoring
    • More...
  • Contact & Support
  • About
  • Teaching
      1. New to teaching
      2. Educational design
      3. Assessment and feedback
      4. Evaluating education
      5. More...
  • Educational Technology
      1. Support
      2. Training
      3. TELT Administrator
  • Events & News
      1. Upcoming events
      2. Recent news
      3. Event recordings & resources
      4. Subscribe to education news
  • Awards
      1. Awards
      2. Fellowships
      3. Gathering evidence of your teaching practice
  • Professional Development
      1. Beginning to Teach (BTT)
      2. Teaching Accelerator Program
      3. Foundations of L&T (FULT)
      4. Course Design Institute (CDI)
      5. Self-paced learning
      6. Academic Mentoring
      7. More...
  • Contact & Support

Breadcrumb

  1. Teaching
  2. Technologies
  3. Educational Technology
  4. Moodle
  5. Build Courses in Moodle
  6. Build Your Moodle Course
  7. Assessment Tools
  8. Gradebook

Export Grades from Moodle Gradebook

Overview

This page contains instructions to help you export a Gradebook report, download the grades or responses for a single quiz, enter grades in a downloaded spreadsheet and re-import grades into the Gradebook

When to use

This process is useful when you have a large quantity of assignments to mark, if your in-Moodle marking is likely to be disrupted by a poor Internet connection, or if you want a bit more control over the format of your marking sheet.

Benefits

The export/reimport process minimises the likelihood of your losing your data mid-marking. It is also more accurate than entering each grade individually in the Gradebook, especially for big classes.

Challenges

To avoid syntax errors during the export–import process, ensure that each activity has had a column created for it in the Gradebook before you export marks, edit and reimport them.

Guide

Step by step instructions

  • Export a Gradebook report
  • Download the grades or responses for a single quiz
  • Enter grades in a downloaded spreadsheet
  • Re-import grades into the Gradebook

Export a Gradebook report

To avoid syntax errors during the export–import process, ensure that each activity has had a column created for it in the Gradebook before you export marks, edit and reimport them.

To export the User Report from the Gradebook:

  1. Within your Moodle course, in the Settings block, click Grades.
  2. In the Gradebook, in the Settings block, under Grade administration, click Export, and select the format in which you want the Gradebook exported.
  3. On the Export page, make the appropriate selections for this export operation. This will mean selecting:
    • Grade items to be included
    • which participants to include (if you have set up groups)
    • whether to Include feedback in export
    • whether to include students in the export whose enrolment has not been suspended (Require active enrolment)
    • Grade export display type
    • Grade export decimal points
    • When you have made your selections, click Download.
  4. If asked, click open or save the downloaded file.

Download the grades or responses for a single quiz

To download a single quiz's grades or student responses:

  1. Click Turn editing on at the top right of the page. 
  2. On the course home page, navigate to the quiz and click Edit settings from the drop-down menu.
  3. In the Settings block, select Results > Grades or  Results > Responses, depending on what you want to download.
  4. From the drop down menu and checkboxes choose the options that meets your requirements.
  5. Select a file type from the dropdown menu and click Download.

Enter grades in a downloaded spreadsheet

  1. Open the saved Excel spreadsheet.
  2. Enter the grades in the appropriate columns. Note:
    • Do not change any existing column names.
    • You can add new columns for offline activities, and enter grades in them.
  3. Save the file as a Comma Separated Values (comma delimited, .csv) file.

Re-import grades into the Gradebook

Click here for instructions on how to import/upload grades.

Additional information

Further assistance

If you experience technical or other issues, consult the Where to get help page.

  • Educational Technology
    • Moodle
      • Login
      • Dashboard
      • Build Courses in Moodle
        • Orientation to Moodle
        • Request Course through myUNSW
        • Build Your Moodle Course
          • Course Design
          • Course Home Page
          • Adding Course Content
          • Assessment Tools
            • Assignments
            • Quiz
            • Gradebook
              • View the Gradebook
              • Customise the Gradebook
              • Change Gradebook Viewing Preferences
              • Hide Grades from Students
              • Manage Assignments in the Gradebook
              • Upload Grades from Excel to Moodle
              • Export Gradebook Marks, Mark Offline and Re-import
              • Reports
              • Give Feedback with Quiz Grades
              • Change Marks in the Gradebook
              • Create and Manage an Offline Moodle Assignment
            • Create a UNSW Workshop Activity in Moodle
            • Team Evaluation plugin
          • Blackboard Collaborate Ultra
          • Personalized Learning Designer
          • Team Builder
        • Bring Content into your Teaching Instance
        • Facilitate and Deliver Course
        • Uploading grades to SIMS using Astra
      • Course Administration
      • Moodle Releases
      • Moodle Upgrade Project
      • Feature Requests
      • Contacts
      • Index of all support pages
    • Lecture Recording+
    • Turnitin
    • theBox
    • Other eLearning Tools
    • Feature Requests
    • Book a Consultation
    • Digital Media Support & Equipment
    • Immersive Technologies
    • TELT Service Status
    • Known System Issues
    • System Maintenance Windows

Events & news

ChatGPT & AI in our teaching
CEP Lightning Workshops T1 2023
More
Back to top
  • Print
  • Share
    • Facebook
    • Twitter
    • Google
    • Email
  • Home
  • About
  • Educational Technology
  • Events & news
  • Awards
  • Contacts

Authorised by Pro Vice-Chancellor Education
UNSW CRICOS Provider Code: 00098G, TEQSA Provider ID: PRV12055, ABN: 57 195 873 179
Teaching at UNSW, Sydney NSW 2052, Australia Telephone 9385 5989

Footer menu

  • Privacy Policy
  • Copyright & Disclaimer
  • Accessibility
  • Report an incident
  • Complaints
  • Site Map
  • Site Feedback
Page last updated: Friday 18 December 2020