I am totally new to Moodle, so this may be a "newbie" question. I have some experience in data modeling and SQL and set up a webserver for my high school classroom using the XAMP package. Installing Moodle 1.7 was not difficult, and I set up a test course called CCI.
I am confused about the relationship between the Roles Module and the Participants Module.
I was able to add our IT specialist, Andrea, as a second administrator using Assign Roles, initially, in my confusion, in the context of my CCI course, and later from my Administrator tool block on the Moodle Home Page. She wasn't able to see the Administrator Tool block until I added her the second time.
Both myself and Andrea, the IT tech, showed up as administrators for my CCI course on the Moodle home page. If I go through Assign Roles on the CCI page, neither one of us show up on the Assign Roles page as existing administrators. So how do I remove her name? Accessing the Assign Roles module from the CCI page, I added myself as a teacher in the CCI course. Now I am no longer shown as an administrator for that course, but I am still listed as a teacher.
We enabled another teacher as a course creator. He created a course, and Andrea uploaded a list of students for him. They showed up on the Participants page for his course, but not in the Assign Roles page for students in his class as Existing Users. We added them that way, too, and now the Participants list for that course has doubled!
All of his students show up as Participants in my Test Course even though I did not enroll them in my test course.
Both Andrea and I show up as Administrators for his course on the Moodle Home Page.
It appears that if an administrator opens the Assign Roles page for a course, they become listed on the Front Page as an administrator for that course even if they do not assign themselves as an administrator. Curious...
It seems to me that either:
The SQL statement for Participants is not correct,
The SQL statement for the Existing Users side of the Assign Role boxes is not correct
There is a data normalization error that has users entered twice in a table from two different places
Unfortunately I won't have time to dig any deeper for a while.
Maybe I am missing something, being new. Anyone have any clues?
Finally a big shoutout and thank you from a couple of excited teachers for an exceptionally well done team effort.