Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
In the last movie we exported our grade book out of Moodle and into Microsoft Excel so we could add some grades directly into Excel. Now let's take our grade book that we've got in Excel and bring it directly back into Moodle. It's important to make sure that you've started with the grade book that you've exported from Moodle that way we know that all of the data columns are set up properly to import directly into Moodle. Now one more thing to note. Moodle will not import an Excel spreadsheet directly. We first have to save this Excel spreadsheet out as a CSV file.
To do that simply go up to the File menu and choose Save As. Depending on the version of Excel that you have the Save As feature maybe in a slightly different location. Make sure you click the dropdown menu and change it from a Standard Excel file format into a Comma Separated Values or .CSV file. Depending on the particular Moodle server that you're working from, you may need to save it as a Windows Comma Separated file or as an MS-DOS Comma Separated file. You may need to do a couple of test to see which is going to work best for your particular Moodle installation.
For our installation we're going to go ahead and use Comma Separated values right from the top. We'll make sure we know where this document is going. In this case, I'll go ahead and save it out to my desktop and I'll make note of what the name of the file is, BIOL432 Grades.csv. I'll hit the Save button and now that file should be out here on the desktop. Now I'm back inside of the Grader report in our grade book and to import these grades all we need to do is click the dropdown menu for Grader report and scroll down until we find the Import CSV file link.
Select Import>CSV and now we're able to choose which file we want to import. Click the Choose a file button. Then from the File picker click Upload a file and in the Attachment section simply click the Browse button, navigate out to your desktop, and find that the BIOL432 Grades.csv file, select it and click Open. Then hit the Upload button and now we can set a few parameters here. The encoding should be a UTF-8, the separator is comma, we do want Verbose scales and we want it to preview 10 rows.
Go ahead and click the Upload grades button and we're given a preview that shows us the information that's going to be imported. If we scroll down a little bit the first key that we need to add is how to identify our users. There is a lot of data that's here available to us, but the most unique data is the Email address. So I'll go ahead and Map from click the dropdown menu and select Email address, which is this heading right here, and I'm going to a Map to what Moodle's ID for this would be, which would be useremail.
I'll make sure that those two are set correctly and then down in the Grade item mapping I want to make sure that I do the Assignment Final Research Paper and change it from Ignore to Grade items and find the Assignment Final Research Paper. Both of those items should match exactly since we exported this spreadsheet directly out of Moodle in the first place. Next, all we need to do is click the Upload grades button.
We're given a response letting us know that the grade import has succeeded. We can click the Continue button. Now we're taken right back into our Grader report. Here we can see the Final Research Paper and all of the grades that we entered in an Excel have now been added directly into our Moodle grade book. There are a lot of really great features inside of the Moodle grade book and I encourage you to explore around and try things out. Let's go ahead and undock our settings by clicking on the Undock this item button and now we'll return back to our main course by clicking on the BIOL432 breadcrumbs link.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 76585 Viewers
80 Video lessons · 130787 Viewers
52 Video lessons · 64723 Viewers
59 Video lessons · 50549 Viewers
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.
Your file was successfully uploaded.