0 Replies Latest reply on Dec 4, 2013 5:06 PM by AlexanderVyverman

    grading database - need help to set up

    AlexanderVyverman

      Title

      grading database - need help to set up

      Post

           Hi all,

           first and foremost, thanks for all the great people who try to help eachother out here, it's truly amazing!
           I'm a complete and utter newcommer in the world of databases and filemaker, so I really hope I do not insult anyone by posing my questions here.

           Problem:

           I need to set up a grading database system for the college I'm working for. 
           Basically I have a bunch of different classes (about 12) each containing 10 to 20 students. I wish to make different tables of each and every class containing the list of students.

           Then I also have 8 different student exercises which all students are to make, and who need to be graded.
            

           The purpose of this database is to create a system where correctors who correct student exercises can open the database,
           choose a class from a list, choose a student from a list, choose an exercise from a list, and then be presented with 5 different criteria of the exercise,
           Of which they have to pick a number between 0 and 5 for each criteria, after which a predeterment calculation will calculate an end result, 
           Which will be automaticaly saved in the student record (table?).

           I am pretty sure that for seasoned filemakers such as you this might sound like the simpelest of tasks to do, but I have been trying to wrap my head around this idea and how to implement it for days, and I my solutions seem to involve creating hundreds of tables, or columns and seem extremely inefficient.

           Not asking you to do my job, on the contrary, but a good push in the right direction of a good model would be a life saver right now.

           Many thanks in advance!

           Alex