Hi Moodle Community,
i wrote my thesis about an automation approach in python 3.6 to send grades and grade-feedback from an excel sheet to moodle using the moodle REST API (among other things). It is all about saving time on daily tasks for teachers and tutors.
My solution is tailored for the needs and systems of my professors at my university. So i linked excel, moodle (REST API), a git server (SSH access) and email servers (SMTP access) to synchronize all systems to the excel sheet including learning groups. Also i wrote scripts to clone an existing course and create several working-groups in it on one double click. With some slimming changes everyone could use my approach.
The benefits are (if just using the excel <-> moodle functionality):
- you can keep your usual (customized) excel sheet by just adding one additional row
- one simple configuration file to customize important parameters
- upload grades and feedback on one double-click
- manage working-groups in excel and synchronize changes with moodle
My solution is designed to work for:
- one excel sheet <-> one moodle course
- working groups (moodle addon groupchoice https://moodle.org/plugins/mod_choicegroup) in that moodle course (grading for single students, NO group grading)
I am mainly using following python packages:
- openpyxl (process excel files) http://openpyxl.readthedocs.io/en/default/
- requests (for HTTP-Requests to moodle REST API) http://docs.python-requests.org/en/master/
- configparser (process configuration file) https://docs.python.org/3/library/configparser.html
- some other built-in packages
Please let me know if you are interested in such approach and if you are willing to test it.
You can find the source code of my complete approach under following link:
https://github.com/ZJoscha/PyWSC
If you need any help / explainings or just want to chat about it feel free to contact me or comment below.
I can post my thesis and manual here as well, but it is in german though...
best regards,
Joscha Zander