Could I load a certificate document (a pdf file) in Moodle if a course is taken by users outside the organization and we are recording completion information in Moodle.
May be I could add an assignment activity -load a single file and allow the users to load certificates?
Is there a way for them to specify when they completed the activity (the date on which certificate was awarded to them)? need that in a field which I could query on.
Thanks
Ah you mean you want them to upload their certificates? Well you could use an assignment where they upload their certificate and type in its date in a text field OR you could use the Database activity module with a field to upload their certificate and one for them to add the date.
Hello,
I have been reading about database activity and added a database activity to my course and added a field of type date to capture certification dates of employees. However when a student_1 enters his certification date and student_2 logs in, he can see student_1's date and can modify and delete it. I thought this would be like file upload assignment activity, where students cannot see other's assignments. Did I miss something?
Also I see the field definition stored in mdl_data_fields table and date values stored in mdl_data_records table in the backend but I don't see a tie between a database activity field and course.
Thanks
Upon further reading
Here is what I found from Moodle docs
"Set up the database so that entries require approval. If the entries are never approved, then only the student that added a particular entry and the teachers can view it."
I think this would work for us.
Here is what I did, created a database activity and added two fields Certification completion date (type date) and Certificate (type file) and users were able to upload the information. This worked very well.
I have another scenario where users won't be entrusted with adding their certification information but someone else probably their supervisor or department admin will be adding the information for them. If I go with database activity approach, how would I specify that the certification line is for a specific employee. I can add a text field to input employee name, but that is error prone as people might make spelling mistakes. How could I attach a student picker to that field or validate the text entered in the field against students in Moodle.
Any help is greatly appreciated.
Thanks