Hi
I'm new to Moodle and am trying to get my head around a problem we've encountered.
Please bare with me, I am not an IT person (but am administrator for Moodle).
We give our students grades each term by an excel sheet, we don't want to change this as most of the course is physical, and are using Moodle for the very little academic side.
I want the ability to upload the grades (as a pdf file) but want it so only the student can look at their grades (so not public).
Is there any way to (easily) do this? Is there 'personal' area the students can have? I have a book called 'Using Moodle' and it suggests creating a database, but I can't see how to make the database private so not everyone can see the uploading files?
Thanks!
Alice
You are asking to do something that is really unnatural from Moodle's point of view.
The natural way to solve this is to put the grades into Moodle's gradebook. Then, Moodle will take care of letting the teacher see all the grades, but the student only see their own grades.
The Moodle gradebook can import a .csv file. Excel can export as .csv. I think it is worth your while at least trying that option out on a test Moodle install, to see what it looks like.
The natural way to solve this is to put the grades into Moodle's gradebook. Then, Moodle will take care of letting the teacher see all the grades, but the student only see their own grades.
The Moodle gradebook can import a .csv file. Excel can export as .csv. I think it is worth your while at least trying that option out on a test Moodle install, to see what it looks like.
Thanks for your response.
The problem is that our gradebook didn't really tranfer across as .csv properly - as the grades we use are numbers which transfer into letters from a hidden matrix. I tried to look into amending the Moodle one but our weird grading system was too complex I think for Moodle to handle. Also, the hidden calculations didn't remain hidden when transferred as a .csv.
Manually inputting all the grades would be a nightmare, as we have written comments and seperate grades for different sections e.g. - a grade for 'professionalism' a grade for 'discipline' etc...
I think the main thing for us, is not the fact they are grades... We just want a way to be able to give a student a file that no one else can see.
The problem is that our gradebook didn't really tranfer across as .csv properly - as the grades we use are numbers which transfer into letters from a hidden matrix. I tried to look into amending the Moodle one but our weird grading system was too complex I think for Moodle to handle. Also, the hidden calculations didn't remain hidden when transferred as a .csv.
Manually inputting all the grades would be a nightmare, as we have written comments and seperate grades for different sections e.g. - a grade for 'professionalism' a grade for 'discipline' etc...
I think the main thing for us, is not the fact they are grades... We just want a way to be able to give a student a file that no one else can see.
Do you mean that you have a separate spreadsheet or pdf for each student with their grades on? Are your students enrolled in the course already, and therefore in the gradebook? In which case I suppose you could use the offline assignment type. Set one up with just a message - here are your grades - and then - presuming your students appear in the gradebook, click on "view...submitted assignments" to get into the gradebook; click on "grade" for each student one at a time and in the comments section, make a hyperlink to their relevant pdf file with their grades on which you will have uploaded to Moodle or can upload when you hyperlink.
There are other ways to do this too -seems long winded though.
There are other ways to do this too -seems long winded though.
I would personally write a VBA app that takes the date needed from you local spreadsheet and convert it into a format that Moodle accepts. You could also use Visual Basic.net or write a PHP script on the server. The steps would look like this:
John
- Open grade spreadsheet
- Run VBA app to create new spreadsheet in Moodle accepted format
- Save new spread sheet as CSV
- import into Moodle
- Open Grade spreadsheet
- save as CSV
- Upload to server
- Run PHP script to convert to Moodle accepted format
- import into Moodle.
John