1 Reply Latest reply on Jun 29, 2010 2:58 PM by fitch

    Grades for students and whole lot more:-)



      Grades for students and whole lot more:-)


      Filemaker 10 on OSX 10.5.8:


      Here goes,  I'm completely new to formulas and have no idea on how to use them but I want to do something cool in Filemaker. 


      The scenario is that I am recording student grades using a field for each grade eg.  Grade 1 (Text field) can either be a Pass, Merit or Distinction (Value list).  However there are 4 grades to complete a unit of work.  So the student could obtain the following grades on a particular subject:  Pass - Merit - Merit - Distinction.


      What is importartant is the grade the student earns from the above results.  The rule is that they will be awarded a 'Pass' for the unit of work due to that being the lowest grade they have attained.  (It's a harsh rule but it motivates the learner and If they are doing well in the other areas it carries that they should do well in all of it i.e they may be being a bit lazy in studying this particular area).


      Just to clarify: Merit - Merit - Merit - Distinction would result in the unit of work being awarded a Merit, (Again being the lowest grade).

      It also follows that if they got Distinction - Distinction - Distinction - Distinction this would result in the unit of work being awarded Distinction.


      So extending this further I would like to use all of the calculated unit grades to provide a timeline of how the unit grades develop throughout the academic year, something like what follows:


      Sep      Oct      Nov      Dec      Jan      Feb      Mar      Apr      May     Jun      Jul    (Looks odd but its the months of the academic year)

      Pass    Merit   Merit     Pass     Merit    Distin   Pass     Merit    Merit    Merit    Pass



      And finally....

      Each of the above unit results all add up to create a grand total.  Where Pass = 70 - Merit = 80 - Distinction =90.  So the above timeline would make a grand total of 850.

      This grand total is used to allow the student to apply for other courses.  Obviously, the higher the total the higher course they can apply for.

      If you can help please let me thank you in advance for any time you may spend on this.  If not I hope you enjoyed reading:-)






        • 1. Re: Grades for students and whole lot more:-)

          Since you're looking for a numeric result at the end, I'd start with that, i.e. use numbers to enter the data. You can create a simple 3-record "Grade Labels" table that you use to display the Pass, Merit or Distinction text, but the grade data you store will be numbers.


          The lowest of the four grades would then be Min( grade1; grade2; grade3; grade4 )


          Make a new record for each month for each student and relate them by student ID. This will allow you to make a timeline and add up the totals.