Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
We already have our Grade Book that we have exported out of Moodle and we have edited the column for Student-led Discussion. Next, we want to save this Excel spreadsheet in a format that we can import directly into Moodle. To do this, simply go up to the File menu, and select Save As. We then want to click the dropdown menu for Format and select Comma Separated Values (.csv). Depending on the specific configuration of your server, you may need to select Windows Comma Separated (.csv) or MS-DOS Comma Separated (.csv).
It's going to depend on your server, so you may have to do a little bit of experimentation to make sure you have the right format. In our case, the simple Comma Separated Values should work just fine. We'll select that option. Make sure we know where the file is going to save to. In our case, it's going to save to the Desktop and we know what the file name is going to be, BIOL432_Grades.csv. We'll then click the Save button. The new file is created out on our Desktop. We can then return back to our web browser, and next we need to import the file back into Moodle.
To do this, simply go to the dropdown menu for Choose an action inside of your Grade Book and then select Import from CSV file. We then need to simply browse to find the local CSV file that we want to import. To do this, simply click the Browse button and then find the BIOL432_Grades.csv file from your Desktop. Click the Open button, and then we need to set some parameters in here. The first set Encoding UTF-8 should be the correct format. You may need to make some adjustments here depending on your local server configuration. Next, we'll select the Separator. We chose to use a Comma separated file, so the default of comma is correct. We'll leave Verbose scale set to Yes, and Preview rows set to 10. This is going to give us a preview of all of the data that we are going to be importing into Moodle.
We will click on the button for Upload Grades, and we are given a preview of the data that's going to be imported. We know we have the student's first name, their surname, their email address and the data for Student-led Discussion is coming in just fine. Next, we need to select some identifiers for our data. The first option Map from is a direct mapping of the data that's coming in from the file. So we want to map the email address, so we'll click the dropdown menu and select Email address.
Then under Map to, we'll click the dropdown menu and select the appropriate field. In our case, it's going to be user-email. This way, the data inside of Moodle for each user's account where their email address is stored here is going to match with the data coming from our imported data, which is the email address here. We then need to select the grade mappings that we want to use. In our case, we are only interested in the Student-led Discussion column that is up in the top.
So we'll select Student-led Discussion, click the dropdown menu and change it from Ignore to the Grade item for Student-led Discussion. These are the assignments that are inside of our Grade Book, and we want to map to the appropriate field. So we'll simply select Student-led Discussions and then click the button for Upload Grades. We are given a response from the server saying Grade import success. We'll click the Continue button and now when we return back to our main Grade Book, we can see the assignment of Student-led Discussion has all of the data that we just entered in, in our Excel spreadsheet exported as a CSV file and then imported directly into Moodle.
This is a great way for you to save time by using an external Grade Book to quickly enter in grades and then import them back into Moodle. Just be sure you set up the Grade categories and grade items before you do your export and have those fields selected as part of your dataset. Then the import process goes very smoothly and you have no trouble getting your grades in.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64872 Viewers
80 Video lessons · 124406 Viewers
52 Video lessons · 60330 Viewers
59 Video lessons · 46155 Viewers