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.
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.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
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.