Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now

Importing and exporting grades


From:

Moodle 2.4 Essential Training

with Mary Cooch

Video: Importing and exporting grades

While it's really useful to be able to set and grade work in Moodle, there might be times where students undertake tasks outside of Moodle, and we want Moodle to record their scores. Or else, we might need to have a print-off of our students' grades, or want to edit them in an offline spreadsheet, for more analysis. In this video, we'll look at how to export and import grades, from Noodle's Gradebook. And to do that, we go to the settings block, and click the link, grades. This takes us by default, to the grader report, and if we go to the drop-down menu, or you might have it as tabs, first of all, we are going to export and we scroll down and see that we have different options for export.
Expand all | Collapse all
  1. 3m 29s
    1. Welcome
      1m 13s
    2. Using the exercise files
      23s
    3. Surveying our project for this course
      1m 53s
  2. 24m 45s
    1. Obtaining Moodle
      3m 12s
    2. Logging in and moving around
      3m 28s
    3. Editing your profile
      2m 57s
    4. Using the text editor
      1m 58s
    5. Choosing your course layout
      3m 49s
    6. Setting up your course
      2m 24s
    7. Adding a banner
      3m 19s
    8. Adding a welcome message
      3m 38s
  3. 5m 58s
    1. Announcing course events
      1m 50s
    2. Using the calendar
      2m 19s
    3. Adding events blocks
      1m 49s
  4. 21m 8s
    1. Uploading your course information
      3m 56s
    2. Understanding the edit icons
      2m 35s
    3. Uploading a folder of exam papers
      3m 47s
    4. Giving instructions to your students
      2m 30s
    5. Displaying a YouTube video
      3m 26s
    6. Linking to a useful website
      2m 6s
    7. Embedding widgets into your course
      2m 48s
  5. 14m 40s
    1. Manually enrolling students
      1m 48s
    2. Allowing students to self-enroll
      2m 25s
    3. Putting your students into groups
      2m 54s
    4. Giving access to private files
      3m 38s
    5. Setting up messaging
      2m 21s
    6. Seeing who's online
      1m 34s
  6. 18m 5s
    1. Creating a discussion forum
      3m 53s
    2. Setting up a chat room
      3m 10s
    3. Blogging
      2m 57s
    4. Creating a wiki
      4m 12s
    5. Creating a glossary
      3m 53s
  7. 26m 45s
    1. Setting up a text assignment
      4m 9s
    2. Setting up a file assignment
      3m 50s
    3. Making a group assignment
      4m 3s
    4. Using blind marking
      3m 35s
    5. Student view of an assignment
      2m 14s
    6. Grading an assignment
      1m 57s
    7. Dealing with deadlines
      1m 35s
    8. Downloading assignments
      1m 50s
    9. Uploading feedback files
      3m 32s
  8. 12m 59s
    1. Gradebook overview
      2m 16s
    2. Organizing your gradebook
      1m 51s
    3. Manually adding grades
      1m 44s
    4. Adding custom scales
      2m 44s
    5. Importing and exporting grades
      4m 24s
  9. 11m 32s
    1. Overview of Moodle's quiz
      1m 38s
    2. Setting up a quiz front page
      3m 39s
    3. Adding questions to a quiz
      4m 6s
    4. Student view of a quiz
      2m 9s
  10. 10m 51s
    1. Feedback, Choice, or Survey?
      3m 2s
    2. Online voting with Choice
      4m 8s
    3. Getting student feedback
      3m 41s
  11. 14m 19s
    1. Enabling activity completion
      3m 42s
    2. Restricting access to activities
      3m 40s
    3. Enabling manual self-completion for a course
      2m 35s
    4. Enabling automatic course completion
      2m 56s
    5. Viewing completion reports
      1m 26s
  12. 11m 59s
    1. Viewing reports and logs
      2m 36s
    2. Importing from other courses
      2m 18s
    3. Backing up your course
      2m 8s
    4. Restoring a course
      3m 22s
    5. Resetting your course at year-end
      1m 35s
  13. 52s
    1. Next steps
      52s

please wait ...
Watch the Online Video Course Moodle 2.4 Essential Training
2h 57m Appropriate for all Oct 08, 2013

Viewers: in countries Watching now:

Teachers, learn how to create engaging courses with Moodle 2.4 and get your students excited about online learning. In this course, Moodle expert Mary Cooch shows you all the steps to creating classes for K–12 and college settings. Learn how to set up Moodle so it's just right for your classroom, add course materials (including videos, widgets, and web links), get your students enrolled, and start fostering collaborative learning with blogs and chats. Plus, learn to build quizzes, grade assignments, and get student feedback. Mary also shows you how to back up a copy of your course to use again the next year, or share with others.

Topics include:
  • Choosing your course layout
  • Using the calendar and managing events
  • Uploading course materials
  • Giving instructions to your students
  • Enrolling students
  • Creating a discussion forum
  • Setting up assignments
  • Grading assignments
  • Adding quizzes
  • Evaluating your courses
  • Tracking course completion
  • Backing up and restoring courses
Subject:
Education + Elearning
Software:
Moodle
Author:
Mary Cooch

Importing and exporting grades

While it's really useful to be able to set and grade work in Moodle, there might be times where students undertake tasks outside of Moodle, and we want Moodle to record their scores. Or else, we might need to have a print-off of our students' grades, or want to edit them in an offline spreadsheet, for more analysis. In this video, we'll look at how to export and import grades, from Noodle's Gradebook. And to do that, we go to the settings block, and click the link, grades. This takes us by default, to the grader report, and if we go to the drop-down menu, or you might have it as tabs, first of all, we are going to export and we scroll down and see that we have different options for export.

I'm going to choose Excel spreadsheet and when I click on that, I'm then presented with all of the grade items in the gradebook, and I can choose, which ones or all of them, I can download. So I'm just going to choose the final assessment, Meet Me in St. Louis. So I check that box and then I want to click the Submit button, which then gives us a download button to download these grades, into an Excel spreadsheet. And when we click that button, we're prompted to choose where we want to save it.

I'm going to save it to the desktop for ease of access, so when we click save, you notice that it's downloading our grades onto the desktop. Now to bring grades into Moodle, that is to import them, the main thing to understand, is that the student's name and the assignment name must match, both in Moodle's grade book and in the file we'll upload. For the sake of the demonstration, lets just use our student, George Adams, and the St. Louis assignment. And the simplest way to get it right, is often to export some grades as we have done, add or edit those grades, and then import them.

So we're going to use the file that we just exported. So I'm going to minimize my Moodle course and go to the desktop, where you can see that we have the Excel file of grades. If we open this up, and if we then change George's grade, he has a grade of 50 for this particular assignment. So if we make it 75 and then save it, we're going to upload that grade, which will then be changed to 75, in Moodle's grade book. We're only doing this with one student, but you can see the process for if you have a very large class.

For import, Moodle accepts CSV or XML files. So I'm going up to file, save as, and save it as a CSV file on the desktop. So I'm going to select CSV, comma delimited, and click save. And we see that we've now got a CSV file, which we could upload into our Moodle course. So if we open our course again, and in the grade book, from the dropdown or the tabs, we select import CSV file, we're then prompted, either to drag and drop if our browser allows it, or to choose a file to import.

So I'm going to select upload a file, and I click choose file or browse according to your browser for our CSV file of grades, which we've edited. Then, when we've opened it, we don't need to change any of the other settings and we just click upload this file, and then the button at the bottom, upload grades. Then it's important, to make sure that we can map the grades, to the students correctly. So I'm going to select email address and user email, and then we scroll down and click the button, upload grades.

And you can see, that the grade import has been successful, and clicking continue would take us to Moodle's grade book, where we would will see that, in our case, just George's, in your case, perhaps a class full of grades, have been successfully edited. It is important however to realize, that you now can't change those grades directly from, within the assignment. Changing grades this way, locks them down in Moodle's grade book. So in this video, we've learned that using Moddle's grading features, doesn't limit us to only grading online, and we can export and import grades for use and analysis, elsewhere.

There are currently no FAQs about Moodle 2.4 Essential Training.

 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now Already a member? Log in

* Estimated file size

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Moodle 2.4 Essential Training.

Return to your organization's learning portal to continue training, or close this page.


OK

Upgrade to View Courses Offline

login

With our new Desktop App, Annual Premium Members can download courses for Internet-free viewing.

Upgrade Now

After upgrading, download Desktop App Here.

Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your lynda.com subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Start your FREE 10-day trial

Begin learning software, business, and creative skills—anytime,
anywhere—with video instruction from recognized industry experts.
lynda.com provides
Unlimited access to over 4,000 courses—more than 100,000 video tutorials
Expert-led instruction
On-the-go learning. Watch from your computer, tablet, or mobile device. Switch back and forth as you choose.
Start Your FREE Trial Now
 

A trusted source for knowledge.

 

We provide training to more than 4 million people, and our members tell us that lynda.com helps them stay ahead of software updates, pick up brand-new skills, switch careers, land promotions, and explore new hobbies. What can we help you do?

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.