Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
As nice as the Gradebook is inside of Moodle, many of us still prefer to use a spreadsheet in order to do our grading, but we still want to be able to hand our grade back to our students using Moodle. Well the best way to accomplish this is to first set up your Gradebook inside of Moodle creating all of our assignments for our students to upload our files so that everything is all set up, and then simply export that Gradebook out and open it in our preferred spreadsheet program. In this movie I'll show you how to grade the final research paper in Microsoft Excel.
To begin, go up to the dropdown menu in your Gradebook and then in the Export menu select Excel spreadsheet from the dropdown menu. Next, all we need to do is go ahead and select what items that we want to export into Excel. We're not going to include any of the feedback. we can preview 10 rows which would be previewing 10 student's records. We do want to have the real grades exported. we don't want to export any percentages or letter grades, let's go ahead and deal with the real point values.
We can choose how many decimal places we want assigned to each of these. in this case we will use the default of two. Next, we'll scroll down and we can see a list of all the different assignments and categories that we may want to export out of our Gradebook. If we want to just export our whole Gradebook into all of our grading in Excel, we could just accept this default, but since we're only going to grade the final research paper, let's go ahead and hit the none link at the bottom of the column, and then only select the Final Research Paper in the list.
This will make our spreadsheet nice and clean. Now simply click the Submit button at the bottom, we're now showing a preview of what information is going to be exported. This all looks correct, so we'll hit the Download button and now Moodle is going to attempt to download this file to our computer. Now it may automatically open in Excel, or you may need to save the file and then open it. I'm going to go ahead and say open with Microsoft Excel and after the file downloads, my spreadsheet opens up and I'm able to go directly into Excel and access my Gradebook.
Here I get a listing of all my Students, if their ID numbers have been added, they're right here, the Institution, Department Name, Email Address and here's the Final Research Paper Assignment. Now for this assignment I can simply go ahead and click in the first blank, select the text that's already there and assign a point value. I give Sally 45 points, hit the Return key. I'll give Elvis 40 points, Eugene 45 points, Johnny 42 points, and Al.
we'll give him 45 points as well. Now that we have all our data saved. In the next movie, I'll show you how to get from this Excel spreadsheet back into Moodle.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 68110 Viewers
80 Video lessons · 126343 Viewers
52 Video lessons · 61842 Viewers
84 Video lessons · 28319 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.