I'd like to finish my queries that I was having so much trouble with, but every time I look at a database I feel myself getting dizzy and confused.
So, I'm looking at the portfolio options enabled within Moodle.
I was slightly surprised to see the list of default options as it's rather more extensive than I was expecting:
I've used some of these in various ways (although I'm intrigued by "File Download") and I know they all have their own benefits.
However, I think I'm going to succumb to hype - I really like the look of Mahara after a cursory examination, but the thing I genuinely like about it is the option for students to take ownership. The problem we're hearing is that students aren't particularly comfortable with Moodle and therefore don't take to it.
It is possible that even if they aren't comfortable with Mahara to begin with, the freedom they have to customise it to suit themselves may give them the incentive to continue.