Drupal 6: Basic school, students/teachers management

Question

Hi,

I'm developing a basic system (using drupal) to manage a school. It has to handle courses, teachers and students, among other features. With cck i've already created the courses and their respective subjects/disciplines.

My question is, how do i assign grades to each student on each subject/discipline? How can i make those assigned grades only available to the student?

Example:

• Teacher-X assigns grades for every single student(user) on Subject-X
• Student-X view his grades on all his subjects

Don't know if I made myself clear, but hope someone knows how I do this.

Thanks

Answer 1

Have you seen Moodle?

I know it's not what you asked about, but I can't resist this question because it hits close to home at the moment. I recently became the IT Director at a small college, and we are in the process of replacing our 17 yr old dos-based campus ERP system. Even the smaller systems that "only" do student information systems cost upwards of $100,000 by the time you consider implementation costs like training. I should know; I looked at a bid this afternoon that ended up higher, and it was the lowest we'd yet received. We're actually likely to spend closer to half a million for something that actually works.

I tell you this to warn you about the scope of what you're getting into, because when it comes down to it even a simple course management system needs to talk to your student information system at some point, even a basic student information system needs to talk to your general ledger come registration time, and you do not want to find yourself building a general ledger on your own for an institution the size of even a small college or primary school.

Answer 2

@Joel I admit the work involved is really daunting but a programmer that really loves his work, would like to delve deep into it. Moodle usually does not contain everything that one needs so writing a custom app in many is still the best solution.

@Ronaldo I am also working on the same project but mine is for a University. I have not yet gotten to the level that you are but I think your problem is not Drupal problem as such. It's just programming logic and database design. If you get the logic right and your db design right, solving this problem would be very simple.